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. **Requisition ID** : 45369