Lead MYSQL DBA in Pittsburgh, PA, and multiple client tech hub

Lead MYSQL DBA in Pittsburgh, PA, and multiple client tech hub locations Columbus, Ohio, United States

Indotronix is seeking a Lead MYSQL DBA in Pittsburgh, PA, and multiple client tech hub locations with our direct client

Position Title: Lead MYSQL DBA

Position Location: Pittsburgh, PA, Strongsville, OH, Phoenix, AZ, Birmingham, AL, Dallas, TX

Ability to work remote: Hybrid, 3/2 schedule

Travel: Very limited, if any; maybe 1x per year max

Days of the week: M-F, on-call rotation

Working Hours (Flexible): 8 am-5 pm, 40 hours

Acceptable time zone(s): EST hours

Duration: Contract to hire

Industry background:

Banking or Financial experience is preferred, not required

Roles and Responsibilities:

The Senior MySQL DBA will have responsibility primarily for MySQL database technologies.

Typical work-related activities include:

• Install, patch, upgrade, configure, tune, and maintain MySQL databases (current versions 8.0.x, 8.4.x being migrated to newer versions 8.0.42, 8.4.5)

• Identify, Innovate, Develop, and Deliver latest capabilities for MySQL such as Innodb clustering implementation to multi-data centers.

• Troubleshoot critical performance bottlenecks for Production 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 Client's security policy

• Review stress testing results and provide recommendations to development teams

• Automate management tasks, streamline processes, and perform standard administrative functions

• Automated installation and patching experience are a big plus

• Mentor, assist, encourage, and serve as a backup to other team members

Technical Skills: (6+ years)

• Complete Understanding of MySQL's underlying storage engines

• Significant Knowledge of MySQL version 8.x and new features

• Knowledge of Automated Failover Solutions for MySQL

• Knowledge of TDE (At Rest Encryption)

• Knowledge of de-facto standards and best practices in MySQL

• Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases

• Strong knowledge of ODBC/JDBC client/server communication

• Significant Automation experience with 'shell' and 'SQL' scripting

Flex Skills:

N/A

Soft Skills:

• 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

• Excellent customer service skills

• Interpersonal skills to deal effectively with all business contacts

• Ability to deliver consistent, high-quality, cost-effective service by handling routine, as well as some non-routine, systems issues

Degrees/Certifications:

Bachelor's - IT-based studies

Certifications are a big plus

Role Differentiator:

Contract to hire

Lead role - will make an immediate impact

Client Benefits

Interview Process:

1. Video Call - technical assessment with Manager (1 hour)

2. Video Call - personality match with Manager (30 minutes)

Indotronix Commitment: A Safe and Inclusive Workplace" - Promoting a Culture of Inclusion, Respect, Equality, and Diversity: Ensuring Safety and Non-Discrimination.

We actively strive to attract, retain, and empower a diverse range of talented individuals, recognizing that diverse perspectives and experiences enhance our collective performance.

Indotronix Commitment to Pay Equity - At Indotronix, we are committed to Equal Employment Opportunity (EEO) and ensure pay equity across all job roles. We proudly champion equal pay for equal work, guaranteeing fair compensation for all employees based on their skills, experience, and contributions.

Celebrating & Honouring Veteran Contributions: Approximately 13% of our workforce are veterans (nearly twice the national average). This achievement underscores our deep commitment in fostering Opportunities for success to Civilian Careers

Recognition - Indotronix has been recognized as one of the largest staffing companies in 2023 by Staffing Industry Analysts - a testament to our continued growth, commitment to excellence, and the trust our clients and candidates place in us.

Compliance Indotronix upholds good corporate citizenship by complying with all applicable laws, including taxation, equal employment opportunity, statutory benefits, and data reporting. In 2023, we hired over 1,200 U.S.-based employees as consultants, contributing to workforce expansion and client service excellence.