Aurora PostgreSQL Automation Engineer

Primay Responsibilities:

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.

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

Qualifications:

Minimum of 5 years of related experience, with a minimum of 4 years of related PostgreSQL experience

Bachelor's degree preferred or equivalent experience

Manage large scale Aurora database environments.

Strong knowledge on AWS cloud technologies as you will be 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.

Performance Tuning and Optimization skills including re-writing SQLs.

Automation using Terraform, Ansible, Jenkins

Shell and Python scripting to automate tasks.

AWS certification a plus

Talents Needed for Success:

Strong knowledge on AWS cloud technologies; AWS certification would be a plus

4+ 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