Cloud Database Engineer

Job Description

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