PostgreSQL DB with Azure Cloud & MySQL Experience

With Aries Consultancy India Private Limited in Hyderabad - IN

More jobs from Aries Consultancy India Private Limited

Posted on August 01, 2020

About this job

Job type: Full-time
Role: System Administrator


postgresql, azure, sysadmin

Job description

Responsibilities :
•Responsible for the monitoring and uptime of all production databases
•Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage
•Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime
•Develop Stored Procedures and Database Triggers in support of application development
•Participate in application development projects and be responsible for the database architecture and design
•Participate in the creation of development, staging, and production database instances, and the migration from one environment to another
•Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release
•Responsible for regular backups and recovery of databases
•Responsible for regular maintenance on databases (e.g., Vacuum, Re-indexing, Archiving)
•Responsible for pro-active remediation of database operational problems
•Responsible for Query tuning and preventative maintenance
•Partitioning the data based on the requirements, capacity planning

Qualifications & Skills:
•6+ years of experience in PostgreSQL DB and 4+ in Azure MySQL Design, Architect and Build a cloud based multi-tenant platform hosted on Microsoft Azure
•Must have strong analytical, verbal and written communication skills
•Must have experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/ SQL programming, catalog navigation, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc.
•Must have strong knowledge of OS
•Strong understanding of command line and server administration
•Knowledge of shell scripting (e.g., Bash, Perl)
•Understanding of PHP and web application framework
•Good knowledge on EDB new features
•Hands on experience in Azure cloud

8.00-15.00 Years

Masters in Technology (M.Tech/M.E/M.Sc), Bachelor Of Computer Application (B.C.A), Master in Computer Application (M.C.A), Bachelor Of Technology (B.Tech/B.E)

Apply here