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 SQLEnsure database security, backups, high availability, disaster recovery, and monitoring are implemented and functioning properlyTune and optimize PostgreSQL performance, queries, and indexesManage schema changes, migrations, and upgrades with minimal downtime.Automate routine database maintenance and monitoring using tools like Cloud Functions, or Cloud MonitoringMonitor database health, conduct root cause analysis on incidents, and propose preventive measuresEnsure compliance with security, data governance, and industry best practices.Implement and maintain monitoring and alerting systems for proactive database health checksSkills: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 skillsStrong communication and collaboration abilitiesAbility to work independently and handle multiple tasks

Zensar