Database Administrator

Status : DBA / Developer

Experience : 5 Years

Position Base : Bhopal

Major Roles and Responsibilities-

· Core SQL, 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 projects, 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.

· Create alerts and notifications, operator, Database mail configuration for system errors, insufficient resources and fatal database errors.

· 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

· Execute Activities assigned by Client

Eligibility criteria

· BE / B Tech with a minimum of 5 years' experience

· Should have a minimum of 3 years of experience in a similar role

· DBA Certificate