Database Administrator - MySQL
- Madhya Pradesh Agency
- 12 - 15 Years
- Mumbai
- 4 years ago
- Email to a friend
- Report this job
Job Description
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 ActivePassive 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:
BE / B. Tech
or
PG in IT / CS or equivalent
Experience:
Minimum 12 years of experience in Database Administration using MySQL
Work experience must span over 4 turn-key projects as a DBA
DBA Certificate
Desirable Skills:
Experience in MySQL database architecture ,logical and physical design
Working experience for government clients would be added advantage
Knowledge of Business Intelligence tools
Experience of querying / data retrieving using multiple database type
Exposure to database administration jobs
Scheduling tasks, jobs, data migration
Knowledge of MySQL administration on Windows/Linux platform is desirable.
Knowledge of MySQL client tools like Workbench etc.
Employement Category:
Employement Type: Full timeIndustry: ITFunctional Area: ITRole Category: Database Administrator (DBA)Role/Responsibilies: Database Administrator - MySQLContact Details:
Company: Madhya Pradesh StateLocation(s): Mumbai+ View Contact
Fraud Alert to job seekers!
₹ Not Specified
Madhya Pradesh Agency
MAP_IT is a government society which has been established to propel the growth of Information Technology (IT) in Madhya Pradesh and implement the State IT Policy. Accordingly the Society has the following objectives. • To provide IT inputs to government departments/agencies and t...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in