Job Description

Responsibilities:


Database Provisioning and Administration: Setting up and managing PostgreSQL databases on GCP Cloud SQL.


Performance Optimization: Monitoring and optimizing SQL queries and database performance.


Backup and Recovery:Implementing disaster recovery plans and maintaining regular backups.


Security Management:Ensuring database security and managing user access permissions.


Migration:Migrating on-premises databases to GCP Cloud SQL using tools like DMS.


Automation:Developing automation technologies for efficient data loading and management.


Design, deploy, configure, and maintain PostgreSQL databases on GCP Cloud SQL


Ensure database security, backups, high availability, disaster recovery, and monitoring are implemented and functioning properly


Tune and optimize PostgreSQL performance, queries, and indexes


Manage schema changes, migrations, and upgrades with minimal downtime.


Automate routine database maintenance and monitoring using tools like Cloud Functions, or Cloud Monitoring


Monitor database health, conduct root cause analysis on incidents, and propose preventive measures


Ensure compliance with security, data governance, and industry best practices.


Implement and maintain monitoring and alerting systems for proactive database health checks







Skills:


Proficiency in PostgreSQL database management.


Experience with GCP Cloud SQL and migration.


Strong SQL query performance skills.


Knowledge of database schema maintenance and tablespace management.




Soft Skills:




Excellent problem-solving and analytical skills


Strong communication and collaboration abilities


Ability to work independently and handle multiple tasks