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.

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.

Desired Experience:

• Database Administration: Experience with relational and non-relational databases.
• Cloud DBs: Experience working with databases on Microsoft Azure, Google GCP, or AWS.
• CloudSQL 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.