SQL Database Administrator

    • Full-Time
  • Wilmington, DE
  • 60,000-100,000

Looking for both JR and SR Database Administrators

Job Description

The MySQL Database Administrator is responsible for providing operational database services as well as project-level support to the organization. This DBA role requires a service-oriented mentality with a high sense of ownership of the problems and requests assigned, the ability to focus on managing and resolving issues within SLAs, establishing and maintaining communication with technology customers to keep them updated with status of their requests, and proactively escalating any issues that cannot be resolved within the established timeframes.

Responsibilities

  • Perform day-to-day production MySQL database administration tasks in a Linux environment, including maintenance, troubleshooting, scaling, tuning, optimization, installation, upgrades, backup/recovery, and data migration across multiple data centers and multiple database server architectures/systems
  • Troubleshoot and resolve production database issues
  • Ensure performance, security, and availability of databases
  • Profile server resource usage, optimize and tweak as necessary
  • Maintain database design/release documentation
  • Work closely with Engineering and DBA Team to design and implement optimal solutions
  • Work with Product teams to enhance the Data warehouse and client reporting solution
  • Provide Maintenance and Support for Client Reporting Solution

Skills and Qualifications

  • Bachelor’s degree in computer science or related IT field preferred
  • 3+ years’ hands-on experience in designing and administering MySQL databases in an HA environment
  • Knowledge of de-facto standards and best practices in MySQL
  • Experience with replication configuration in MySQL
  • Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM
  • Proficient in writing and optimizing SQL statements
  • Ability to plan resource requirements from high-level specifications
  • Unix shell scripting and the ability to automate routine tasks
  • Familiarity with monitoring tools and how to apply to DB environment
  • Must be ready to support environments remotely while on on-call
  • Hands-on experience with NoSQL / non-relational databases
  • ETL / data migration experience with large data sets
  • Experience with data modeling in relational databases and writing complex SQL queries

Preferred Qualifications

  • Experience with Percona for MySQL Server
  • Experience with MySQL Backup tools and Monitoring tools.
  • Experience with Reporting/Visualization tools is a plus (Tableau preferred).
  • Experience with ETL tools and data warehouse concepts is a plus (Talend Preferred)
  • Proficient understanding of code versioning tools such as git

 

To apply for this job email your details to hr@infiniasearch.com