What are the responsibilities and job description for the PostgreSQL DBA position at VeriiPro?
Job Description
We are seeking an experienced PostgreSQL DBA with strong expertise in managing PostgreSQL databases in both on-premise and cloud environments (preferably AWS). The ideal candidate will have extensive experience in database administration, performance tuning, migration, automation, and cloud-native services, along with excellent problem-solving and communication skills.
Key Responsibilities
- Manage, maintain, patch, migrate, and upgrade PostgreSQL and AWS RDS databases.
- Configure and administer database security policies, user authentication, and IAM in AWS.
- Implement effective and maintainable database coding practices aligned with architectural best practices.
- Optimize database performance through indexing, partitioning, and advanced tuning techniques.
- Manage PostgreSQL migration projects, including technical estimation and execution.
- Work with AWS services (RDS, S3, EC2) and tools for database operations.
- Support message queuing, full-text indexing, and other high-performance data concepts.
- Utilize Linux OS for database administration, with proficiency in SSH and key-based authentication.
- Automate processes using Jira, GitHub, Ansible, Terraform, and CI/CD pipelines (GitLab).
- Manage batch processes, job scheduling automation, and database integrity checks.
- Ensure data quality, security, and privacy standards in database coding and operations.
- Collaborate with cross-functional teams and provide client-facing support.
- Troubleshoot and resolve complex database issues while identifying alternative solutions.
Required Qualifications
- 7–8 years of experience in managing PostgreSQL databases, including 5 years in cloud (preferably AWS RDS).
- Hands-on experience with PostgreSQL performance tuning, partitioning, and query optimization.
- Strong knowledge of AWS cloud services (RDS, EC2, S3) and database administration in AWS.
- Working knowledge of EDB, Oracle, and SQL Server.
- Strong Linux OS administration skills.
- Experience with automation tools (Ansible, Terraform) and CI/CD (GitLab).
- Knowledge of batch processes and job scheduling automation.
- Excellent problem-solving, analytical, and communication skills.
- Strong client-facing experience.