Sponsored
Verified Job IT / Software / Data Analyst

MYSQL DBA

Princeton, New Jersey
IT / Software / Data Analyst
#437174
Remote / WFH

Job Description

Qualifications
Strong problem-solving skills and expertise in both Windows Server and MySQL administration are essential
SQL / MySQL Database Administration:
Bachelor's degree in computer science, Information Technology, or a related field
Minimum of 5 years of hands-on experience in SQL/MySQL database administration
Strong analytical and problem-solving skills, with the ability to think critically and strategically
Excellent communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams and stakeholders
MYSQL DBA
Responsibilities
The Level 2 MySQL Administrator oversees administration tasks for MySQL database systems
Responsibilities include optimizing performance, ensuring reliability, and providing expert support for both production and development environments
Collaboration with application developers, technical leadership, and adherence to industry standards are key aspects of this role
Deploy, configure, and manage MySQL database servers in high availability environments, ensuring optimal performance and reliability
Implement database schema, indexing strategies, and partitioning to optimize query performance and enhance scalability
Develop and maintain database backup and recovery procedures, including regular backups, point-in-time recovery, and disaster recovery planning
Perform database performance tuning and optimization, including query optimization, resource utilization analysis, and database cache management
Monitor database health and performance metrics, identify bottlenecks, and implement corrective actions to ensure optimal database performance
Implement and manage database security measures, including user access controls, authentication mechanisms, and data encryption
Collaborate with application developers to troubleshoot database-related issues and optimize database queries for improved application performance
Provide expert support for Applications databases in the development and test environments
Work with Application developers and their logical data models, create physical Application database designs which conform to industry standards (e.g., data normalization), optimize performance, and efficiently utilize disk space, size tables, and indexes for production implementation based on projected row counts provided by Applications
Create complex new databases and Application database objects (e.g., tables, indexes, procedures), and as requirements change, update data structures/objects in existing databases
Coordinate production database deployment including tasks to promote database objects between environments (e.g., test to production) in support of Application requirements
Provide technical leadership to Application developers in database capabilities and features, build efficient queries, database design, Application database Problem Resolution, and the use of database utilities
Determine and implement appropriate Application database backup and recovery strategies, including decisions regarding frequency of backup and procedures for recovering Application database changes
Perform production database recovery when necessary
Job description
Job Description:

The Level 2 MySQL Administrator oversees administration tasks for MySQL database systems. Responsibilities include optimizing performance, ensuring reliability, and providing expert support for both production and development environments. Collaboration with application developers, technical leadership, and adherence to industry standards are key aspects of this role. Strong problem-solving skills and expertise in both Windows Server and MySQL administration are essential.

SQL / MySQL Database Administration:
• Deploy, configure, and manage MySQL database servers in high availability environments, ensuring optimal performance and reliability.
• Implement database schema, indexing strategies, and partitioning to optimize query performance and enhance scalability.
• Develop and maintain database backup and recovery procedures, including regular backups, point-in-time recovery, and disaster recovery planning.
• Perform database performance tuning and optimization, including query optimization, resource utilization analysis, and database cache management.
• Monitor database health and performance metrics, identify bottlenecks, and implement corrective actions to ensure optimal database performance.
• Implement and manage database security measures, including user access controls, authentication mechanisms, and data encryption.
• Collaborate with application developers to troubleshoot database-related issues and optimize database queries for improved application performance.
• Provide expert support for Applications databases in the development and test environments.
• Work with Application developers and their logical data models, create physical Application database designs which conform to industry standards (e.g., data normalization), optimize performance, and efficiently utilize disk space, size tables, and indexes for production implementation based on projected row counts provided by Applications.
• Create complex new databases and Application database objects (e.g., tables, indexes, procedures), and as requirements change, update data structures/objects in existing databases.
• Coordinate production database deployment including tasks to promote database objects between environments (e.g., test to production) in support of Application requirements.
• Provide technical leadership to Application developers in database capabilities and features, build efficient queries, database design, Application database Problem Resolution, and the use of database utilities.
• Determine and implement appropriate Application database backup and recovery strategies, including decisions regarding frequency of backup and procedures for recovering Application database changes.
• Perform production database recovery when necessary.

Qualifications:
• Bachelor's degree in computer science, Information Technology, or a related field.
• Minimum of 5 years of hands-on experience in SQL/MySQL database administration.
• Strong analytical and problem-solving skills, with the ability to think critically and strategically.
• Excellent communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams and stakeholders.

MYSQL DBA
View more Mysql Jobs in Princeton →
Sponsored

Similar Openings in IT / Software / Data Analyst

More jobs you might like

AdministratorReceptionist HR Manager Verified
Remote / WFH IT / Software / Data Analyst

Responsibilities: Answering, forwarding, and screening phone calls Checking, sorting, and forwarding emails Scheduling meetings/interviews M...

Posted 31m ago View Details
Senior Business Analyst HR Manager Verified
Remote / WFH IT / Software / Data Analyst

Job Description JOB DETAILS 1.Excellent communicator and relationship builder: A track record of collaborating with a variety of cross-funct...

Posted 31m ago View Details
Software Fresher jyoti Verified
Chennai, Tamil Nadu IT / Software / Data Analyst

Wanted Graduate TraineernJob Role : SoftwarernSkills required : Basic programming language in Java or PHPrnFreshers only can applyrnJob loca...

Posted 31m ago View Details
IT SUPPORT jyoti Verified
Delhi, Delhi IT / Software / Data Analyst

Job description GREETINGS FROM GTROPY! We have exciting openings in the IT Support Team and we like your profile! If you are interested and ...

Posted 31m ago View Details
Remote / WFH IT / Software / Data Analyst

Angular JS Developer Navi Mumbai AddThis Sharing Buttons Share to Facebook Facebook Share to Twitter Twitter Share to LinkedIn LinkedIn Shar...

Posted 31m ago View Details
Associate AspNet Developer HR Manager Verified
Remote / WFH IT / Software / Data Analyst

Senior Software Developer The Senior Software Developer focuses on developing multiple types and categories of software including end-user a...

Posted 31m ago View Details
Application Developer I HR Manager Verified
Remote / WFH IT / Software / Data Analyst

Business Unit: Global Information Technology Job Description: This role is responsible for the delivery of custom software solutions used by...

Posted 32m ago View Details