Job Description
Designation DBA – MYSQL
Job Location Bhopal
Position Type Fixed Term Employment (Upto 2 year), Extendable basis performance
Job Objective
The Database Administrator role is to administer design database schemas, all type of database objects like
tables, views, stored procedures, functions etc for IT project, including maintaining databases while ensuring
high levels of data availability. The Database Administrator will evaluate and advise on all technology
components for database management systems and applications. They may handle databases for entire
systems as well as for individual applications. Using their analytical and problem-solving skills, database
administrators help companies structure their data in a way where it's easily accessible, valid and secure
environment. work on continues upgradation of technical artifacts.
Core Responsibilities:
• Core MySQL, MariaDB and MySQL Enterprise monitoring.
• Extensive work experience on query optimization, script optimization, other related optimization tools and
techniques including Performance monitoring.
• Design and create database objects such as data table structures, stored procedures, views, Triggers,
reports, Database Administration, Configuration, Maintenance and Support.
• Data migration, backup, restore & recovery, Resolving performance issues, blocking and deadlocks.
• Implement and Monitor 2-Node Active\Passive SQL Clustering to provide High Availability for mission
critical events, database mirroring, replication and log shipping.
• Implement and maintain security and integrity controls including backup and disaster recovery strategies
for document management system and MySQL databases.
• Help in translating business requirements into technical design specifications and preparing high-level
documentation for the Database Design and Database Objects.
• Create alerts and notifications, operator, Database mail configuration for system errors, insufficient
resources and fatal database errors.
• Data analytic like Power BI, Tableau
• Database partitioning, replication, Migration
• Able to handle large database (more than 1 TB)
• Integrated MySQL with Windows Active directory security for database/table level permissions
• Conduct research and make recommendations on database products, services, protocols, and standards in
support of procurement and development efforts.
• Coordinate and work with other technical staff to develop relational databases and secondary databases,
Identify inefficiencies in current databases and investigate solutions.
• Diagnose and resolve database access and security issues.
• Plan and execute data migrations between different database systems.
• Develop, implement, and maintain change control and testing processes for modifications to databases.
Ensure all database systems meet business and performance requirements.
• Creating and scheduling Jobs in MySQL, ETL, deploy SQL patches, Perform Data Migration Activity.
• Coordination with respective OEMs/Vendors.
Education & Experience Desirable Skills
Education • Experience in MySQL database architecture ,logical
BE / B. Tech and physical design
or • Working experience for government clients would
PG in IT / CS or equivalent be added advantage
• Knowledge of Business Intelligence tools
Experience: • Experience of querying / data retrieving using
• Minimum 12 years of experience in Database multiple database type
Administration using MySQL • Exposure to database administration jobs
• Work experience must span over 4 turn-key
projects as a DBA • Scheduling tasks, jobs, data migration
• DBA Certificate • Knowledge of MySQL administration on
Windows/Linux platform is desirable.
• Knowledge of MySQL client tools like Workbench
etc.
