Database administrators are in charge of storing, organizing, presenting, using and analyzing data and database management software.
Whatever the information storage needs of a company are, a database administrator strives to meet them. This can include setting up new databases.
A database administrator regularly performs routine tests and modifications to ensure that a database is performing and running correctly.
If a problem occurs, a database administrator troubleshoots the programs and hardware. Based on the findings, repairs or changes can be made to fix the problem.
A database administrator routinely discusses and coordinates security measures with other administrator in the company. This position entails successfully working with a cross-functional team including Engineering, IT, Devops & Analytics.
Organization Grade2.2 Position TitleDatabase Administrator II DepartmentDBA Reporting RelationshipsLead DBA Cross Functional RelationshipsIT, Engineering, Data & BI, Analytics LocationChennai
Critical Business Activities
Availability : Ensure performance, security and availability of databases. Develop & support replication.
Optimization : Optimize database design of database systems, establish mechanism for DB backup / restore. Profile server resource usage, optimize and tweak as necessary.
Monitoring : Performs Day to day administration tasks including monitoring database replication alerts, manual DB fixes, monitoring ETL jobs.
Competencies and Experience
Technical Skills and Experience
2-4 Years of experience in MySQL production environment.
Knowledge of RDBMS architecture required
Manage MySQL databases through development to mission-critical production systems.
Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
Refine and automate regular processes, track issues, and document changes.
Handle common database procedures, such as upgrade, backup, recovery, migration, day to-day support etc.
Assist developers with complex query tuning and schema refinement.
Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log issues, connectivity issues, security issues
Provide rotation-based 24 / 7 on call support for unplanned outages and planned maintenance / release events.
Knowledge of High Availability (HA) and Disaster Recovery (DR) options within MySQL.
Database Backup & Restoration management
Have strong communication skills, both written and oral.
Good team-working skills.
A willingness to keep up to date with developments in technology
Knowledge of Structured query language (SQL).
General understanding of operating system, e.g. : Linux, windows
Maintain database documentation as required.
Develop and support MySQL database replication.
Exposure to AWS, MongoDB, & Pentaho ETL will be added advantage.
Solving problems : Take up learning opportunities, acquiring knowledge and skills, updating specialist knowledge, applying practical skills, learning by doing, applying common sense, continuously improving things, identifying key issues, making intuitive judgements.
Influencing people : successfully persuade others, shapining opinions, negotiating, can question assumptions, challenges established views, argues own perspective, gives presentations, explains things and is able to project social confidence.
Adapting approaches : show empathy, listen to people, understands hidden motivation, works particpatively, encourages team contributions, involves other in decisions, shows consideration, can tolerates others (their personalities, ways of working) and can trust people.
Delivering Results : Does the incumbent making things happen, uses initiative, invests energy, identifies business opportunities, generates sales (selling of ideas / approaches), outperforming competitors, achieves outstanding results, acts with determination and persist through difficulties.