Note: The job is a remote job and is open to candidates in USA. Tek Leaders Inc is seeking a highly skilled PostgreSQL Database Administrator (DBA) with expertise in AWS Aurora PostgreSQL to design, optimize, and maintain high-performance, secure, and scalable database systems. The role involves defining and implementing PostgreSQL best practices, supporting CI/CD automation, and ensuring system reliability across multiple environments.
Responsibilities
- Create data structures such as tables, views, and schemas based on technical specifications
- Develop and maintain stored procedures, triggers, and functions to support application logic
- Implement authorization-level security using PostgreSQL roles and privileges
- Maintain compliance with organizational and regulatory data protection standards
- Implement physical performance optimizations through indexes, partitions, and materialized views
- Conduct logical performance tuning through SQL optimization and query analysis
- Configure and tune AWS Aurora performance and scalability features to ensure efficient database operation
- Identify and implement PostgreSQL and AWS cost optimization opportunities
- Design and implement high availability (HA) and disaster recovery (DR) architectures leveraging AWS Aurora features
- Conduct cross-environment data cloning and synchronization
- Work with DevOps teams to implement PostgreSQL CI/CD pipelines for automated deployment and versioning
- Develop code generators to automate recurring administration tasks using PostgreSQL metadata tables
- Define and enforce PostgreSQL best practices including deployment processes, performance baselines, and security standards
- Document architectures, procedures, and data models using Confluence and Lucidchart
Skills
- 5+ years of experience administering PostgreSQL databases
- 2+ years of hands-on experience administering AWS Aurora PostgreSQL
- 4+ years performing physical and logical performance tuning for PostgreSQL
- Proven experience implementing AWS Aurora high availability features
- Demonstrated ability to work with DevOps teams to design and deploy PostgreSQL CI/CD pipelines
- Hands-on experience developing PostgreSQL code generators using metadata tables
Company Overview
Company H1B Sponsorship