Feedback

Role of a Database Administrator (DBA) in Bhopal MPSEDC

Understanding the Role of a Database Administrator (DBA) – Key Responsibilities, Skills, and Qualifications

Job Description: Designation: DBA – MySQL Job Location: Bhopal Position Type: Fixed Term Employment (Up to 2 years), Extendable based on performance

Job Objective: The role of a Database Administrator (DBA) is crucial in administering, designing, and maintaining database schemas and objects for IT projects, ensuring high levels of data availability. DBAs evaluate and advise on technology components for database management systems, handle databases for entire systems or individual applications, and contribute to the continuous improvement of technical artifacts.

Core Responsibilities:

• Monitoring and optimization of MySQL, MariaDB, and MySQL Enterprise
• Designing and creating database objects such as tables, stored procedures, views, triggers, etc.
• Data migration, backup, recovery, and resolution of performance issues
• Implementing and monitoring 2-Node Active/Passive SQL Clustering for High Availability
• Ensuring security and integrity controls, including backup and disaster recovery strategies
• Translating business requirements into technical design specifications and documentation
• Conducting data analytics using tools like Power BI and Tableau
• Handling large databases and integrating MySQL with Windows Active Directory security
• Coordinating with technical staff for database development and maintenance
• Diagnosing and resolving database access and security issues
• Planning and executing data migrations between different database systems
• Developing, implementing, and maintaining change control processes for database modifications

Education & Experience:

• Education: BE/B.Tech or PG in IT/CS or equivalent
• Experience: Minimum 12 years of experience in Database Administration using MySQL
• Certification: DBA Certificate
• Additional Skills: Experience in MySQL database architecture, knowledge of Business Intelligence tools, familiarity with MySQL administration on Windows/Linux platforms, etc.

Desirable Skills: