PostgreSQL DBA

1012 years of experience in managing Postgres databases. 5 years of experience should be on the cloud version preferably AWS experience in managing databases as RDS services in AWS security policy user authentication IAM and database administration in AWS.

Install configure patch Migrate Maintain and upgrade Opensource Database platforms Databases like PostgreSQL and AWS RDS

Working Knowledge of EDB Oracle SQL Server and AWS Day to Day operation on S3 EC2 etc

Should be able to implement effective and maintainable database coding practices that form an architectural foundation

Experience in Postgres SQL performance improvement indexing/other approaches Good experience on partitioning database

Experience with message queuing fulltext indexing and other highperformance data concepts Experience in AWS environment management and knowledge of different tools for the same

Experience in Postgres SQL migration approach estimating it and technically managing it

Advanced understanding of Linux OS use SSH to connect to remote systems with password & public/private keys

Ability to efficiently write database code without compromising data quality privacy or security. Handson Experience in Jira GitHub Ansible & Terraform.

Good understanding of CI/CD using GitLab

Good understanding of the Batch process and Job scheduling automation

Knowledge of database design principles query optimization index management integrity checks statistics and isolation levels

Good troubleshooting skills Ability to evaluate alternative solutions and/or workarounds 1 Strong analytical and interpersonal communication skills

Must possess good communication skills both in verbal and in written form and be Proficient in identifying analyzing and solving problems for Client facing experience