GCP Database Administrator

Role & responsibilities

Database Installation and Configuration:

• Install, configure, and maintain databases or RDS like PostgreSQL, SOLR, Clickhouse (Mandatory), MSSQL and MySQL (Optional) in a Cloud environment preferably Google Cloud Platform
• Implement best practices for database setup, including security configurations, backup strategies, and high-availability solutions.

2) Performance Tuning and Optimization:

• Monitor and optimize database performance to ensure efficient and reliable operation.
• Identify and resolve performance bottlenecks, query optimization, and indexing strategies.

3) Backup and Recovery:

• Design and implement robust backup and recovery solutions for all supported database systems.
• Regularly test backup and recovery processes to ensure data integrity and availability.

4) Security:

• Implement and maintain database security policies and procedures.
• Ensure compliance with security standards and best practices.

5) Monitoring and Alerting:

• Set up monitoring tools to proactively identify and address potential issues.
• Respond to alerts promptly and troubleshoot any database-related problems.

6) Collaboration and Documentation:

• Collaborate with development and infrastructure teams to understand database requirements.
• Document database configurations, processes, and troubleshooting procedures.

7) Database Upgrades and Patch Management:

• Plan and execute database upgrades and patch management activities.
• Stay informed about the latest updates and features for supported database systems.

8) Disaster Recovery Planning:

• Develop and maintain disaster recovery plans for all databases.
• • Conduct periodic drills to ensure the effectiveness of disaster recovery processes.

Preferred candidate profile

• Proven experience as a Database Administrator, with a focus on GCP and the mentioned database systems.
• Strong knowledge of database performance tuning, backup and recovery, and security best practices.
• Experience with cloud-native database solutions and services on GCP.
• Familiarity with infrastructure as code (IaC) and automation tools.
• Excellent problem-solving and troubleshooting skills.
• Strong communication and collaboration skills.
• Experience with containerization technologies (e.g., Docker, Kubernetes).
• Familiarity with DevOps practices and tools.
• Experience with large-scale, distributed database systems.
• Knowledge of data warehousing concepts.

Years of Experience - 8+ years as a DBA