On Site
Bangalore
India
3-6 months
Time and material
$ 18-20/Hr
Description
Communication RTH - Y Total Years of Experience : 5-10 years Relevant years of Experience : 5+ Mandatory Skills for screening : Minimum 5 years of hands-on database administration experience. Expert-level knowledge of PostgreSQL and CockroachDB administration. Experience with MariaDB in production environments. Strong understanding of SQL performance tuning and query optimisation. Experience with replication, sharding, and high-availability configurations. Proficiency with backup and restore tools and strategies. Familiarity with monitoring tools (e.g., Prometheus, Grafana) and scripting for automation (e.g., Bash, Python). Knowledge of database security best practices. Good to have (Not Mandatory): Experience in cloud-based database deployments (Azure). Exposure to Kubernetes (OpenShift) and containerised database deployments. Understanding of distributed database concepts. Detailed Job Description : About the Role: We are seeking an experienced Database Administrator with a minimum of 5 years of professional experience managing and optimising relational database systems. The ideal candidate will have strong expertise in PostgreSQL and CockroachDB, with working knowledge of MariaDB. You will be responsible for ensuring database performance, scalability, security, and availability across multiple environments. Key Responsibilities: · Install, configure, and maintain PostgreSQL and CockroachDB clusters in production and development environments. · Perform database tuning, monitoring, and optimisation to ensure high performance and reliability. · Design and implement backup, recovery, and disaster recovery strategies. · Manage user access controls, roles, and permissions to safeguard data integrity and security. · Troubleshoot and resolve database-related issues, including performance bottlenecks and query optimisation. · Work closely with development teams to design efficient data models and schemas. · Develop and maintain documentation for database configurations, processes, and policies. · Assist with migration projects between different database systems (including MariaDB). · Stay up-to-date with emerging database technologies and best practices. - IBMFG2JP00010202
Skills:
Backup and restore strategies,CockroachDB administration,Database security best practices,High-availability configurations,MariaDB experience,Monitoring tools,PostgreSQL administration,SQL performance tuning

Interested in this project and numerous others like it?

Register on WorkWall now and get started