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.
Job Classification
Industry: AutomobileFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Database AdministratorEmployement Type: Full time