Job Description
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
Job Classification
Industry: IT Services & Consulting
Functional Area / Department: Engineering - Software & QA
Role Category: DBA / Data warehousing
Role: Database Architect / Designer
Employement Type: Full time
Contact Details:
Company: Zensar
Location(s): Hyderabad
Keyskills:
Automation
Security management
GCP
Postgresql
database security
Disaster recovery
Schema
data governance
Dms
SQL
