- Company Name
- OKAYA INFOCOM
- Job Title
- PostgreSQL DBA
- Job Description
-
Job Title: PostgreSQL DBA
Role Summary:
Provide expert administration, performance tuning, and high‑availability configuration for PostgreSQL databases while integrating with Snowflake data warehouses and cloud PaaS environments. Ensure secure, efficient, and resilient database assets for 24/7 operations.
Expactations:
- Active participation in on‑call rotations supporting mission‐critical infrastructure.
- Continuous improvement of automation scripts and documentation.
- Collaboration with engineering, security, and operations teams to enforce best practices.
Key Responsibilities:
- Design, deploy, and maintain PostgreSQL clusters with HA/replication and fault tolerance.
- Migrate and manage data in Snowflake, applying ETL best practices.
- Provision cloud database services (AWS RDS, Azure Database for PostgreSQL) and configure networking, firewalls, load balancers.
- Implement security controls: encryption, masking, certificates, PKI, SSH, VPN.
- Troubleshoot complex performance, availability, and scaling issues using analytical methodologies.
- Manage CI/CD pipelines (Jenkins, GitLab) for database schema changes and deployments.
- Create and maintain infrastructure as code (Terraform) for database resources.
- Document architecture, procedures, and incident post‑mortems.
- Support PCI‑DSS, ITIL, and compliance frameworks as required.
Required Skills:
- 5+ years DB2 or PostgreSQL administration; 2+ years Snowflake administration/development.
- Experience with Linux/Unix, cloud PaaS databases (AWS/Azure).
- Proficiency in CI/CD tools (Jenkins, GitLab).
- Strong knowledge of database security (encryption, masking, PKI).
- Expertise in HA and fault‑tolerant system design.
- Familiarity with automation, Terraform, and scripting (Python/Bash).
- Understanding of networking protocols (TCP/IP, UDP, routing, firewalls, load balancers).
- Excellent analytical and problem‑solving skills.
Required Education & Certifications:
- Bachelor’s degree in Computer Science, Engineering, or equivalent practical experience.
- Certifications such as PostgreSQL Expert, Snowflake Administrator, or cloud‑specific credentials (Azure/AWS) preferred.