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 deep expertise in AWS Aurora PostgreSQL. The successful candidate will design, optimize, and maintain high-performance, secure, and scalable database systems while implementing best practices and ensuring system reliability.
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
Skills
- Deep expertise in AWS Aurora PostgreSQL
- Experience in designing, optimizing, and maintaining high-performance, secure, and scalable database systems
- Ability to define and implement PostgreSQL best practices
- Experience supporting CI/CD automation
- Experience ensuring system reliability across multiple environments
- Ability to create data structures such as tables, views, and schemas based on technical specifications
- Experience developing and maintaining stored procedures, triggers, and functions to support application logic
- Experience implementing authorization-level security using PostgreSQL roles and privileges
- Ability to maintain compliance with organizational and regulatory data protection standards
- Experience implementing physical performance optimizations through indexes, partitions, and materialized views
- Experience conducting logical performance tuning through SQL optimization and query analysis
- Experience configuring and tuning AWS Aurora performance and scalability features
- Ability to identify and implement PostgreSQL and AWS cost optimization opportunities
- Experience designing and implementing high availability (HA) and disaster recovery (DR) architectures leveraging AWS Aurora features
- Experience conducting cross-environment data cloning and synchronization
Company Overview