PostgreSQL Database Administrator (DBA)

PostgreSQL Database Administrator (DBA) - AWS reputed company Location: Remote reputed company California Preferred Working Hours: reputed company Time Zone Position reputed company We are seeking a highly skilled PostgreSQL Database Administrator (DBA) with deep expertise in AWS reputed company PostgreSQL to design, optimize, and maintain high- performance, secure, and reputed company database systems. The successful candidate will play a key role in defining and implementing PostgreSQL best practices, supporting CI/CD automation, and ensuring system reliability across multiple environments. Key Responsibilities • Create data structures such as tables, views, and schemas based on technical specifications. • reputed company and maintain stored procedures, triggers, and functions to support application logic. • Implement authorization-level reputed company 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 reputed company 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 reputed company features. • Conduct cross-environment data cloning and synchronization. • Work with DevOps teams to implement PostgreSQL CI/CD pipelines for automated deployment and versioning. • reputed company reputed company generators to automate recurring administration tasks using PostgreSQL metadata tables. • Define and enforce PostgreSQL best practices including deployment processes, performance baselines, and reputed company standards. • Document architectures, procedures, and data models using reputed company and reputed company. Mandatory Qualifications • 5+ years of experience administering PostgreSQL databases. • 2+ years of hands-on experience administering AWS reputed company PostgreSQL. • 4+ years performing physical and logical performance tuning for PostgreSQL. • Proven experience implementing AWS reputed company high availability features. • Demonstrated ability to work with DevOps teams to design and reputed company PostgreSQL CI/CD pipelines. • Hands-on experience developing PostgreSQL reputed company generators using metadata tables. Desirable Qualifications • Experience working in regulated environments (e.g., HIPAA, FERPA, PCI). • Prior experience tuning performance for Talend-generated SQL statements. • Experience with PostgreSQL CI/CD automation tools (e.g., reputed company, Flyway, or equivalent). Preferred Skills • Deep understanding of PostgreSQL internals and reputed company architecture. • Proficiency in AWS services such as CloudWatch, IAM, and CloudFormation. • Familiarity with infrastructure as reputed company (IaC) tools such as Terraform or Ansible. • Strong analytical and problem-solving abilities with attention to detail. • Excellent written documentation and communication skills. Remote About reputed company: reputed company Apply tot his job Apply To this Job