MYSQL Database Administrator

This is a 12 month contract with Lexis Nexis. 100% remote. Only CST/EST candidates. preferred locations: Boca Raton, Alpharetta, or Minneapolis. Visa-All open - No h1b. Additional Notes: Candidates must have deep experience handling on-prem MySQL Production replication DBA support with focus on devops centric areas and cloud/Cassandra/postgres etc would be an added advantage. MySQL specific experience. Replication experience is also a requirement. General SQL will not suffice. Job Description: MySQL/DevOPS/Cloud Sr. Database Administrator Consultant Be part of the Risk Solutions Database Services Team. As a MySQL DBA Contractor you will be working with other top notch DBAs and Architects in a technologically diverse environment in our best-in-class enterprise data centers and cloud based environments. You will be contributing towards helping migrating MySQL Database Replication systems to new hardware by ensuring zero down time. Be part of a team where best practices and standards are the norm and all are empowered to achieve success. Be part of a team that continually masters a high degree of collaboration and knowledge sharing and where members are able to excel in their accomplishments and realize their career goals. QUALIFICATIONS: Bachelor in Computer Science, Management of Information Systems(MIS) or related discipline or equivalent work experience. 5 years DBA working experience on Linux and Unix environments. 5 years or more of experience in database environment life cycle management and support of production and development environments. TECHNICAL SKILLS - REQUIRED 5 years MySQL DBA working experience on Linux and Unix environments Extensive industry experience (5 years) that include serving as a DBA in all facets of DBMS design, implementation, deployment, administration and maintenance, and project coordination 5 years or more of experience in database environment life cycle management and support of production and development environments Experience supporting Data Warehousing and ETL processing Experienced in database and disk system performance tuning Self-motivated detail oriented and highly responsible Capable of handling multiple assignments and additional responsibilities Expert level MySQL DBA knowledge and experience with MySQL 5.6, 5.7 and 8.0 - MySQL certification preferred Extensive MySQL technical experience in the following: High Availability solutions using replication, Disaster Recovery solutions Backup and recovery experience with Percona Tools [i.e., Xtrabackup] Performance tuning, production operations & support Security Administration Experience performing MySQL patches and Major version upgrades Experience in Linux Shell programming, SQL. 2 or more years using DevOPS tools. I.E., Terraform, Ansible, Chef, GitLab using one or more programming languages [I.E., Python, Perl, etc] on bare metal and virtual environments [I.E., AWS, OpenStack, Proxmox, Azure] RESPONSIBILTIES Support the database management system and all related software. Design and Build Database Environments (Assist in developing estimates and schedules for new projects and/or extensions to existing systems). Technical Support for DBMS Environments (Provide technical support and perform database administration for all development and production databases on multiple environments). Willingness to be on call and support critical database issues that arise in the evening or on weekends.