ESaaS - PostgreSQL Database Admin

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