Aurora PostgreSQL Database Engineer - Hyderabad

Stradit LLC; Hyderabad; Hybrid; INR 1,800,000 - 2,400,000; Full time

Job summary

Stradit LLC in Hyderabad is seeking an experienced Aurora PostgreSQL Database Engineer to design, build, and support cloud database environments through automation. The role emphasizes performance, security, and resiliency in AWS-based systems.

You will automate tasks, tune databases, and lead projects with minimal guidance, collaborating with AWS, application support, and infrastructure teams. A strong background in PostgreSQL/Aurora and scripting is required, with on-call rotation.

Qualifications

• 5+ years of related experience, including 3+ years with PostgreSQL.
• Bachelor's degree preferred or equivalent experience.
• Strong AWS cloud knowledge; AWS certification is a plus.
• Experience managing large-scale Aurora database environments.
• Proficient in SQL tuning and rewriting for performance.
• Experience with Terraform, Ansible, and Jenkins for automation.
• Proficient with Unix/Linux/Windows OS.
• Shell and Python scripting for automation.
• Ability to work independently on tasks and projects.
• Knowledge of database backup, recovery, and security practices.

Responsibilities

• Support and manage the Aurora PostgreSQL database environments.
• Automate build and support tasks across database technologies (i.e. Oracle, MS SQL, and PostgreSQL).
• Adhere to best practices on Incident, Problem and Change management.
• Lead projects independently with minimal guidance.
• Manage and support Aurora PostgreSQL database platforms working closely with AWS, application support teams, and infrastructure teams.
• Install, configure, upgrade, and maintain database instances on AWS.
• Recommend and implement database security policies.
• Recommend and implement database backup, recovery, and redundancy strategies.
• Implement automated procedures to proactively handle issues and alerts.
• Perform database performance analysis, capacity planning, system sizing and ongoing maintenance.
• Aligns risk and control processes into day-to-day responsibilities to monitor and mitigate risk and escalates appropriately.
• Demonstrates reliability by taking necessary actions to continuously meet required deadlines and goals.
• Applies global perspective when working within a team by being aware of working styles and ensuring all relevant parties are involved in key team tasks and decisions.
• Articulates information clearly and presents information effectively and confidently.
• Thinks boldly and out of the box, generates new ideas and processes, and confidently pursues challenges as new avenues of opportunity.
• Participate in an on call rotation to support production incidents'

Skills

PostgreSQL

Aurora PostgreSQL

SQL tuning

Shell scripting

Python scripting

Linux

Windows

AWS

Database backup/recovery

Project management

Education

Bachelor's degree or equivalent

Tools

Terraform

Ansible

Jenkins

Job description

Role: Aurora PostgreSQL Database Engineer

Experience: 5 to 8 Years

Notice Period: Early joiners preferred

Work mode: Hybrid

Location : Hyderabad

Interview process: Total 2 rounds

The Database Engineer is an Aurora PostgreSQL Database and Automation engineer and is responsible for supporting all aspects of the design, build, and support of the cloud database environments through automation. The Database Engineer is responsible for ensuring that the environments are performing optimally and align to best practices for security and resiliency.

Database Engineering team designs and builds secure, resilient, recoverable, and reusable frameworks to support the entire database life cycle. The team focuses on continuous service improvements to increase the quality of service and speed of delivery.

The Database Engineer is an Aurora PostgreSQL Database and Automation engineer and is responsible for supporting all aspects of the design, build, and support of the cloud database environments through automation. The Database Engineer is responsible for ensuring that the environments are performing optimally and align to best practices for security and resiliency.

Responsibilities

• Support and manage the Aurora PostgreSQL database environments
• Automate the build and support tasks across database technologies (i.e. Oracle, MS SQL, and PostgreSQL)
• Adhere to best practices on Incident, Problem and Change management
• Lead projects independently with minimal guidance
• Responsible for managing and supporting Aurora PostgreSQL database platforms working closely with AWS, application support teams, and infrastructure teams
• Install, configure, upgrade, and maintain database instances on AWS
• Recommend and implement database security policies
• Recommend and implement database backup, recovery, and redundancy strategies
• Implement automated procedures to proactively handle issues and alerts
• Perform database performance analysis, capacity planning, system sizing and ongoing maintenance
• Aligns risk and control processes into day-to-day responsibilities to monitor and mitigate risk and escalates appropriately
• Demonstrates reliability by taking necessary actions to continuously meet required deadlines and goals.
• Applies global perspective when working within a team by being aware of working styles and ensuring all relevant parties are involved in key team tasks and decisions
• Articulates information clearly and presents information effectively and confidently
• Thinks boldly and out of the box, generates new ideas and processes, and confidently pursues challenges as new avenues of opportunity.
• Participate in an on call rotation to support production incidents'

Qualification

• Minimum of 5 years of related experience, with a minimum of 3 years of related PostgreSQL experience
• Bachelor's degree preferred or equivalent experience
• Strong knowledge on AWS cloud technologies; AWS certification would be a plus
• 3+ year experience managing large scale Aurora database environments
• Strong performance Tuning and Optimization skills including re-writing SQLs for optimal performance.
• Extensive experience with Automation using Terraform, Ansible, Jenkins
• Strong knowledge of operating systems (Unix / Linux / Windows)
• Hands on experience with Shell and Python scripting to automate tasks enabling self-healing capabilities
• Strong experience with partitioning and handling large databases
• Understands interlaying technologies like OS, Networking, Applications, and its impact to databases
• Manage tasks and projects independently with minimum guidance and directions
• Ability to independently research, design, document and implement new database related services
• Solid experience in backup and recovery processes
• Ability to work in a complex environment to determine business and customer needs and provide the best solution needed