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 & PostgreSQLCertifications : GCP Relational / NoSQL Database experience and GCP Database Engineer or Architect certificationTerraform : Experience using Terraform in cloud maintenancePostgreSQL 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 SLASkills Required
Cloud, Configuration Management, Shell Scripting, Plsql, Sql, Database Administration