DescriptionThe 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 offshift work to provide OnCall coverage (in a rotation) for productionsupport 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.
ResponsibilitiesTechnical Responsibilities:
- Experience:Minimum 4 years in IT with 23 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 databaserelated issues including offshift 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.
QualificationsDesired Experience:
- Database Administration:Experience with relational and nonrelational 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.
- SelfStarter:Must be a selfstarter with a strong desire to learn new technologies.