Talent.com
This job offer is not available in your country.
P Square Solutions - Database Administrator - PostgreSQL

P Square Solutions - Database Administrator - PostgreSQL

P Square Solutions LLCKochi
30+ days ago
Job description

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

Technical Competencies :

  • 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).

    • Soft Skill Competencies (Expectation based on role) :

  • 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

    • (ref : hirist.tech)

    Create a job alert for this search

    Database Administrator • Kochi