PostgreSQL DBA

Mandatory skills : AWS Infra Services, PostgreSQL, PostgreSQL-DB Administration, Terraform

Job description:

• We are looking for a midlevel Database Administrator DBA with strong handson experience in PostgreSQL administration along with solid AWS exposure and Terraform expertise especially writing reusable Terraform modules
• 4 to 8 years flexible based on depth of PostgreSQL AWS Terraform
• The role will focus on ensuring database reliability performance security automation and supporting cloudbased database environments
• Oracle experience is a plus but not mandatory

Key responsibilities:

• Install configure administer and maintain PostgreSQL databases in production and nonproduction environments
• Perform backup and recovery planning and execution PITR restore validations DR readiness
• Monitor database health and performance troubleshoot issues related to queries indexing locks replication and storage
• Plan and execute patchingupgrades migrations and version compatibility checks
• Implement and manage replication streaming replicationlogical replication where needed and high availability strategies
• Ensure database security access controls rolesprivileges and audit readiness
• AWS Responsibilities
• Work with AWS services related to database hosting and operations such as
• Amazon RDS for PostgreSQL Aurora PostgreSQL preferred
• EC2based PostgreSQL deployments
• Supporting services IAM VPC Security Groups KMS CloudWatch S3 SNS
• Support cloud best practices for networking encryption monitoring scalability and cost awareness
• Participate in DR strategies using AWS native capabilities
• Terraform Infrastructure as Code IaC
• Design and develop Terraform modules for repeatable infrastructure deployments
• Maintain Terraform codebase apply IaC practices such as
• Remote state workspaces state locking
• Module versioning reusable patterns naming standards
• Secure variable handling Secrets ManagerParameter Store integration
• Partner with DevOpsSRE teams to automate infrastructure provisioning for DB environments
• Operational Collaboration
• Participate in on call production support if required for incidents and problem management
• Create and maintain runbooks SOPs and technical documentation
• Collaborate with application teams to review schema changes query performance and release readiness

Required skills qualifications:

• 4 to 8 years of hands on DBA experience with PostgreSQL in production
• Strong understanding of
• Backup recovery replication HADR concepts
• Performance tuning indexes vacuum analyze query plans
• Security roles grants encryption basics
• Working experience in AWS RDSAurora preferred
• Strong expertise in Terraform including writing and maintaining Terraform modules
• Familiarity with Linux administration and scripting Shell Python is a plus
• Strong troubleshooting mindset and ability to handle production issues calmly

Nice to have preferred:

• Oracle DBA experience basic administration backup restore concepts troubleshooting
• Experience with CICD integration for Terraform JenkinsGitHub ActionsGitLab
• Monitoring tools CloudWatch Prometheus Grafana Datadog New Relic etc.
• Container environments EKS Kubernetes for DB adjacent services