MySQL Database Administrator in Chicago at Signature Consultants

Date Posted: 5/21/2019

Job Snapshot

Job Description

MySQL Database Administrator Summary:

Signature Consultants has a direct hire opportunity for a MySQL Database Administrator in Chicago or Northbrook, IL. (Consultant can sit in either location.) Using their deep expertise in databases and application development, the candidate will work with the team to develop and maintain the data platform. This role will help develop, enhance and maintain applications using AWS cloud technologies, along with using relational, MySQL and other specialized databases. The candidate will help write data services in Java and demonstrate concurrent programming skills as needed. Our client will depend on your futuristic thinking to mitigate issues before they occur and will look to you to test, debug and troubleshoot challenges and to document resolution steps when necessary.

Responsibilities:

  • Formulates detailed network, storage, and computes design specifications for stable and secure computing operations in a dynamic cloud based environment to support Tableau reporting infrastructure
  • Monitors MySQL databases to assist in optimization of database performance, resource use, and physical implementation
  • Creates custom Java and/or Python based scripts to automate data retrieval and integration into database
  • Collaborates with internal and external parties to transform high-level technical objectives into comprehensive technical requirements
  • Makes recommendations for improvements to security, scalability, manageability, and performance across a wide variety of network, storage, and compute technologies
  • Participates in, implements, and coordinates with others, in maintaining, modifying, and creating database structures
  • Develops strategies for data acquisitions, archive recovery, and implementation of MySQL databases
  • Assists and begins to develop designs for databases
  • Monitors and manages MySQL database backups and restorations
  • Installs, maintains, and upgrades MySQL database software as required
  • Administers, maintains, and develops policies and procedures for ensuring the security and integrity of databases
  • Continues our charge towards test automation and continuous integration
  • Drives innovation by coming up with new and surprising ideas for our applications and our processes
  • Designs, implements, and maintains our application and infrastructure components
  • Refactors and improves maintainability of the codebase
  • Solves complex scalability, platform, and integration problems
  • Learns new paradigms, languages, and libraries as you work
  • Assists with identifying and planning potential new cloud services, features, and capabilities
  • Demonstrates problem solving skills and the ability to work on multiple projects simultaneously
  • Meets predetermined deadlines set for assigned tasks
  • Studies the technical structure and requirements of the DBM system to be supported
  • Demonstrates the ability to utilize training in assigned tasks
  • Performs project tasks to ensure that associated deliverables are completed in a timely manner
  • Creates documentation in accordance with the tasks performed
  • Ensures written communication is accurate, timely, and thorough
  • Adheres to accepted department standards and procedures
  • Database Administration and Monitoring
  • Owns and solves performance issues of database applications by implementing changes to database objects and/or working with developers/vendors on application tuning effort

Qualifications:

  • Bachelor's degree in computer science, MIS or a related field or the equivalent in education and experience is required
  • Experience in data modeling, along with 2-3 years of programming experience writing performant stored procedures/functions/SQL statements is required
  • Experience installing/administering clustered MySQL v5.x+ instances
  • Solid understanding of different Database Models
  • Experience in either Oracle or MySQL is required
  • Minimum 2 years of working experience in core java is required
  • Understanding of how HTTP works as it applies to RESTful architectures required
  • Data warehousing experience is preferred

Compensation and Benefits:

  • Competitive salary
  • Flexible work location
  • Stocked kitchen
  • Health, dental and vision insurance
  • Smart and fun co-workers who will quickly feel like family
  • 3 weeks PTO
  • 401k plan with company match
  • Short Term Disability

About Signature Consultants, LLC

Headquartered in Fort Lauderdale, Florida, Signature Consultants was established in 1997 with a singular focus: to provide clients and consultants with superior staffing solutions. For the ninth consecutive year, Signature was voted as one of the "Best Staffing Firms to Work For" and is now the 15th largest IT staffing firm in the United States (source: Staffing Industry Analysts). With 27 locations throughout North America, Signature annually deploys thousands of consultants to support, run, and manage their clients' technology needs. Signature offers IT staffing, consulting, managed solutions, and direct placement services. For more information on the company, please visit www.sigconsult.com.

CHECK OUT OUR SIMILAR JOBS

  1. Developer Jobs
  2. DBA Jobs