Database Engineer - GCP Cloud SQL

Job Title:

Total Experience:

About the Role

Database Engineer

Key Responsibilities

Database Management & Administration:

• Manage and administer

  GCP Cloud SQL

  databases (MySQL, PostgreSQL, SQL Server).
• Create and manage

  MemoryStore (Redis)

  instances and configurations.
• Handle database provisioning, upgrades, patching, backups, and recovery.
• Ensure

  high availability (HA)

  and

  disaster recovery (DR)

  setups are maintained.

Performance Optimization & Tuning:

• Analyze and tune database performance for optimal query response times.
• Identify and resolve performance bottlenecks in SQL queries and schema design.
• Optimize indexes, stored procedures, and execution plans.

Monitoring & Troubleshooting:

• Set up monitoring tools and dashboards for database health and performance.
• Proactively identify issues and resolve database-related incidents.
• Ensure continuous uptime and minimal downtime for production databases.

Security & Compliance:

• Implement

  database access controls, encryption

  , and security policies.
• Ensure compliance with

  industry standards and data protection regulations

  .
• Regularly perform audits and maintain documentation of security configurations.

Collaboration & Communication:

• Work closely with

  data engineers, architects, and DevOps teams

  to support application and infrastructure requirements.
• Provide

  technical guidance

  , documentation, and support for database best practices.
• Participate in

  design and architecture discussions

  to ensure optimal database solutions.

Technical Skills Required:

• Cloud Databases:

  GCP Cloud SQL (MySQL, PostgreSQL, SQL Server)

• Additional GCP Services:

  Cloud Spanner, MemoryStore (Redis)

• SQL Expertise:

  Query optimization, indexing, triggers, stored procedures

• Monitoring Tools:

  GCP Monitoring (Stackdriver) or equivalent

• Scripting & Automation:

  Python, Shell, Terraform (preferred)

• Performance Tuning:

  Query analysis and resource utilization optimization

• Security:

  Data encryption, IAM roles, compliance policies

Desired Skills (Good to Have):

• Experience with

  BigQuery

  for analytics and data warehousing.

• GCP Certification:

  Google Professional Cloud Database Engineer or equivalent.
• Familiarity with

  CI/CD pipelines

  ,

  Dataflow

  , or

  Cloud Functions

  .
• Exposure to

  multi-cloud or hybrid cloud environments

  .

Soft Skills:

• Strong problem-solving and analytical skills.
• Excellent verbal and written communication.
• Ability to work effectively in cross-functional teams.
• Proactive and detail-oriented mindset with a focus on quality and efficiency.

Educational Qualification:

• Bachelor’s or Master’s degree in

  Computer Science, Information Technology, or related field

  .
• GCP certifications preferred.