Cloud Database Engineer

The ideal candidate will be responsible for managing and optimizing our GCP relational/NoSQL databases, ensuring high availability, performance, and security for the databases hosted in GCP.

The work will be performed in the Chennai, India as a member of a team of Cloud DB engineers. There will be occasional off-shift work to provide On-Call coverage (in a rotation) for production-support incidents and to support scheduled changes to applications after hours.

Key Responsibilities:

• Database Administration

  : Manage and administer Cloud databases, ensuring their optimal performance and reliability.

• Platform Expertise

  : Demonstrate proficiency in working with databases on GCP Cloud, with experience across other platforms being advantageous.

• Growth Environment

  : Operate effectively within a rapidly growing environment, anticipating and responding to emerging needs

• Design and Development

  : Design, develop, and enhance production and test databases within the technical architecture.

• Monitoring

  : Continuously monitor database systems to ensure their stability and performance.

Desired Experience:

• Database Administration:

  Experience with relational and non-relational databases.

• Cloud DBs:

  Experience working with databases on Microsoft Azure, Google GCP, or AWS.

• Cloud SQL Support:

  Supporting PostgreSQL/SQL Server on Google Cloud.

• Migration:

  Experience in migrating Oracle/SQL Server to GCP Cloud SQL PostgreSQL/SQL Server.

• Scripting:

  Unix shell scripting and Terraform development for provisioning GCP Databases.
• 
  

• Authentication:

  Experience with SSL and IAM authentication for GCP Databases.

• Migration Tools:

  Familiarity with ora2pg and GCP Database Migration Service (DMS).

• Pipeline Development:

  Experience with Tekton pipeline development (nice to have).

• Communication Skills:

  Excellent written and verbal communication skills.

• Technical Communication:

  Ability to communicate effectively with both business and technical teams.

• Database Products:

  Working experience with SQL Server & PostgreSQL

• Certifications:

  GCP Relational/NoSQL Database experience and GCP Database Engineer or Architect certification

• Terraform:

  Experience using Terraform in cloud maintenance

• PostgreSQL Expertise:

  Experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/SQL programming.

• Query Tuning:

  Proficient in query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc.

• Self-Starter:

  Must be a self-starter with a strong desire to learn new technologies.

Technical Responsibilities:

• Experience:

  Minimum 4+ years in IT, with 2-3+ years specifically in Relational and NOSQL Databases.

• Cloud Expertise:

  Proficient in relational and NoSQL databases on GCP, AWS, or Azure.

• Configuration Management:

  Manage, monitor, and report on databases hosted in GCP environments.

• Optimization:

  Configure and optimize applications for resource usage, including hybrid cloud deployments.

• Performance:

  Optimize database workloads for Cloud SQL PostgreSQL and monitor/tune database performance.

• Backup and Recovery:

  Define and implement robust database backup and recovery strategies.

• Database Changes:

  Assist in planning and implementing database and application changes.

• Evaluation:

  Evaluate new database products and features.

• Space Management:

  Perform database space management, reorganizations, backups, and recovery.

• Troubleshooting:

  Identify and solve database-related issues, including off-shift coordination with cloud providers.

• Liaison:

  Act as the point of contact for application developers and business customers regarding cloud environments.

• Security:

  Ensure adherence to database security protocols.

• Performance Tuning:

  Conduct performance tuning and capacity management.

Functional Responsibilities:

• Business Continuity:

  Knowledge of business continuity and disaster recovery.

• Process Improvement:

  Adhere to processes, drive improvements, and manage knowledge.

• Problem Management:

  Involve in problem management and mentoring junior team members.

• Communication:

  Attend global meetings and cascade inputs to the team.

• Incident Management:

  Manage incidents/tickets queue and adhere to SLA