MySQL DBA in Dallas, TX at MDI Group

Date Posted: 10/5/2018

Job Snapshot

Job Description

Dallas, TX

The Database Administrator will be responsible for supporting Enterprise Data Architect with database design, tuning, deployment and data management. As a member of Enterprise Data Architecture Team, this role will closely with Developers and Architects responsible for setup and management of analytical and transactional databases. This role also involves providing support to both internal and external customers on data and performance issues. Experience in development in addition to administration will be helpful as you team up with system administrators, application developers and business process leaders to provide project insight and direction.

What You Will Be Doing:

  • Responsible for Database management (transactional and analytical)
  • Responsible for review, SQL query and performance Tuning
  • Responsible for daily, weekly and Ad-Hoc Databases refreshes
  • Responsible for troubleshooting performance issues in production databases
  • Responsible for Analysis, development and maintaining logic and physical data models
  • Design, develop and support database needs by working with business systems analysts
  • Provide management of production systems in collaboration with Client Services and Product Development
  • Provides support for development, test and production environments

Must Haves

  • 3+ years of Database Administration experience with SQL and Shell scripting skills (required); Clustrix DB, MySQL experience (desired)
  • Proficient technical skills to include (SQL DDL and DML, ETL methodologies, TOAD, Git, RDBMS, Scheduler, shell scripting)
  • Shell scripting is must and any other scripting such as python is preferred
  • Professional experience in building data models
  • Management of database backups, logging and related Admin tasks
  • Perform database tuning for optimal performance
  • Experience supporting Application and Analytical DB environment
  • Experience in database replication, data streaming
  • Technical experience should include Clustrix/ MySQL administration, exposure to Hadoop, Data Lake and supporting development teams
  • Maintains documentation of systems, policies and procedures
  • Install, configure and upgrade database software and related products. Must have professional experience in handling one or more databases in RDBMS (Clustrix DB, MySQL, postgress, SQL Server or others), NoSQL (mongo, cassandra) and/or couchdb). Experience in Hadoop eco system is desired
  • Experience in AWS Databases (Redshift, RDS) is required
  • Must have strong working knowledge/professional experience using MySQL and Linux
  • Must be experienced with Linux shell scripting
  • Must have solid experience supporting ETL/reporting DB Environments
  • Must have database replication, setup, support, performance tuning, installing upgrades
  • Must have Cloud DBA experience as well as strong AWS experience
  • Candidates ideally will be accustomed to being a Database Administrator (does not want an Architects, Developers or Engineers)
  • Candidates should be a solid professional experience using Hadoop for at least 2 or 3 projects
  • Candidates with an ETL background who have supported ETL systems preferred

Ed Cusack



Search IT Jobs