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. 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.

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.