P Square Solutions - Database Administrator - PostgreSQL

Number of Open Positions - 1

Experience - 4-5 years

Industry - IT Product & Services

Employment Type - Hybrid

Work Location - Smart City, Kochi, Kerala

Shift timing based on projects typically day/evening shift.

Role Description

• Administer and support PostgreSQL (1116) and Oracle (11g/12c/19c) databases across development, test, and production environments.
• Manage cloud database services on AWS RDS/Aurora, Azure Database, and/or GCP Cloud SQL.
• Perform database installations, upgrades, and patch management for PostgreSQL and Oracle, MySQL, SQL Server
• Configure and maintain HA/DR setups using PostgreSQL replication (streaming/logical), Oracle Data Guard, RAC, and cloud-native failover options.
• Design and execute backup and recovery strategies (RMAN, pgBackRest, Barman, snapshots).
• Optimize database performance via indexing, query tuning, partitioning, and monitoring.
• Implement automation for DB tasks using Ansible, Terraform, and CI/CD pipelines (e.g., Jenkins, GitLab).
• Monitor database health using tools like pgBadger, OEM, Prometheus, Grafana, and cloud-native monitoring solutions.
• Ensure database security: manage user access, encryption, and compliance policies.
• Support database migrations and cloud lift-and-shift projects as needed.
• SA as a direct hire and must have the appropriate visa/work permit credentials
  
  

• 45 years of experience as a DBA managing PostgreSQL, Oracle, MySQL, SQL Server databases.
• Strong hands-on experience with cloud database platforms: AWS (RDS, Aurora), Azure, GCP.
• Proficient in backup & recovery, HA/DR configurations, and performance tuning.
• Experience with DevOps tools: Git, Jenkins, Ansible, Terraform.
• Good knowledge of SQL, PL/SQL, and shell scripting (Bash, Python optional).
• Experience working in Linux/Unix environments.
• Excellent problem-solving and troubleshooting skills.
• Experience in Flyway or Liquibase for DB deployments
• Experience with PostgreSQL extensions (e.g., PostGIS, pg_partman, pg_stat_statements).
  
  

• Strong analytical and problem-solving skills.
• Effective communication and collaboration skills.
• Ability to work independently as well as in a team-oriented environment.
• Proactive attitude with a passion for continuous learning and improvement.
• Strong time management and ability to handle multiple tasks efficiently