Database Administrator

Batchservice

Early Applicant

3 months ago
Be among the first 50 applicants

Exp: 5-10 Years

India, Cochin / Kochi / Ernakulam

Job Description

The Database Administrator oversees storing, organizing, presenting, using and analyzing data and database management software. Whatever the information storage needs of the company are, the Database Administrator strives to meet them, this can include setting up new databases. Regularly performs routine tests and modifications to ensure that a database is performing and running correctly. If a problem occurs, the Database Administrator troubleshoots the programs and hardware. Based on the findings, repairs or changes can be made to fix the problem. Routinely discusses and coordinates security measures with other administrators in the company. This position entails successfully working with a cross-functional team.

Duties and Responsibilities

Understand the business impact of database systems and show good judgement when making technical trade-offs between short-term technology and long-term business needs.
Develop strategies to scale out MySQL and PostgreSQL deployment in multiple DCs.
Play an integral part of our software engineering teams, assist in design and development of database systems consisting of MySQL, PostgreSQL and MongoDB.
Leverage DevOps techniques and practices like Continuous Integration, Continuous Deployment, Test Automation, Build Automation and Test-Driven Development to enable the rapid delivery of end user capabilities.
Design and implement tools to automate database operation, self-service tools and monitoring.
Setup and support MySQL master/master, master/slaves replication servers.
Plan and execute tests of fault tolerant capabilities, including backup/recovery, replication, cluster failover and disaster recovery.
Problem analysis, solution determination, modification, and documentation.
Measure and analyze database performance and implement changes to improve performance.
Perform database load testing and benchmarking.
Monitoring and performance optimizations of SQL and NoSQL databases.
Designs and implements sharding and indexing strategies for MongoDB.
Provide technical assistant to sort out the issues related to the databases.
Mentor developers with best practices recommendations concerning optimization of the queries and schema/index design.

Skills and Qualifications

Overall 5 to 10 years of experience in Database Administration
Must have experience with AWS RDS environments for deploying and managing MySQL and PostgreSQL databases.
Must have 4-6 years of MySQL and Linux experience in an intensive, high-traffic, web-based, multi-threading applications on multi-core architecture environment.
Must have expert level knowledge in MySQL 5.7+, complete understanding of different engines and related utilities such as Percona Toolkit, mysqladmin etc.
Must have experience with MySQL monitoring tools (i.e., AWS Cloudwatch, DataDog, PMM, NewRelic etc.)
Experience with designing and implementing high-availability database features, utilizing various replication and disaster recovery methodologies.
Must have experience in backup/recovery/failover methods and best practices.
Must have experience in scripting languages, such as Shell, Perl, Python, etc
Experience with Mongo DB Administration and NOSQL database is a big plus.
Experience with Kubernetes and Prometheus-Grafana is a big plus.