MySQL DBA

Systems Int Ltd - Remote
$60 - $70 an hourFull-time8 hour shift +1

Required Skills
· MySQL (required) - version 5.7.23-8.0.28 and some older versions at < 5.7.18
· MySQL 5.7.x and 8.0.x Enterprise Edition MySQL
· Complex P1/P2 Incident Management
· Work experience with OLTP, OLAP, Staging, and Data warehouse configuration.
· Strong knowledge of ODBC/JDBC client/server communication
Preferred/nice to have
· Ansible
· Automation experience with ‘shell’ and ‘SQL’ scripting
· Detail-oriented, strong communication, self-starter

Day to Day Responsibilities:

  • Install, patch, upgrade, configure, tune, and maintain MySQL databases (current version 5.7.23-8.0.28 and some older versions at < 5.7.18)
  • Troubleshoot critical performance bottlenecks for MySQL databases
  • Review and assess the impact of database design changes prior to their implementation
  • Collaborate with other IT teams and Vendors to resolve complex and multi-disciplinary issues
  • Work independently and represent database group in various projects
  • Ensure that databases are monitored, maintained, backed up, and available as appropriate.
  • Manage database security with an adherence to PNC’s security policy
  • Review stress testing results and provide recommendations to development teams
  • Automate management tasks, streamline processes, and perform standard administrative functions
  • Mentor, assist, encourage, and serve as a backup to other team members
  • Assist in Production releases for Critical Production Applications
  • Assist for Complex P1/P2 Incident Management as required (24x7 On-Call)
  • Understanding of MySQL’s underlying storage engines and ability to learn new architectures
  • Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases
  • Analytical skills necessary to perform troubleshooting of errors and performance issues
  • Strong verbal and written communication skills
  • Results-oriented and able to work across the organization as an individual contributor
  • Ability to work in a rapidly transforming organization
  • Excellent customer service skills
  • Interpersonal skills to deal effectively with all business contacts
  • Technically proficient in assigned IT discipline(s)
  • Ability to deliver consistent, high-quality, cost-effective service by handling routine, as well as some non-routine, systems issues

Qualification:
· HS Diploma w/certification is ok
· Bachelor's preferred (software engineering, computer science, and/or related field)
· Emphasis on work experience - 8+ years minimum regardless of education

Job Type: Full-time

Pay: $60.00 - $70.00 per hour

Benefits:

  • 401(k)
  • Health insurance
  • Paid time off
  • Vision insurance

Schedule:

  • 8 hour shift

Application Question(s):

  • What is the most recent version of MySQL you have used?
  • How many years of troubleshooting experience you have with MySQL?
  • Production support experience?
  • Would be comfortable working on W2

Experience:

  • MySQL: 5 years (Required)
  • Ansible: 3 years (Required)

Work Location: Remote

Apply
Attention - In the recruitment process, legitimate companies never withdraw fees from candidates. If there are companies that attract interview fees, tests, ticket reservations, etc. it is better to avoid it because there are indications of fraud. If you see something suspicious please contact us: [email protected]
Other jobs you may like