Sr. Site Reliability Engineer - Database Administration (MySQL)

Visa - Austin, TX

Full-time - Mid Level

Hybrid - Austin, TX

Credit Intermediation and Related Activities

About the position

As a Senior Site Reliability Engineer specializing in Database Administration, particularly with MySQL, you will play a crucial role in the planning, building, and operational management of database technologies and infrastructure. This position requires a deep understanding of database administration and engineering practices, as you will be responsible for delivering database projects, maintaining operational systems, and performing problem analysis and troubleshooting. You will work independently, providing technical influence and subject matter expertise to the database team, and will be expected to solve complex problems while identifying innovative solutions. Your contributions will be vital in ensuring the stability and availability of mission-critical business applications. In this role, you will support Database Platform Engineering by architecting, developing, and deploying MySQL databases in high SLA environments. You will manage and maintain database technology and infrastructure, ensuring adherence to architectural guidelines and policies. Your responsibilities will include database administration for both off-the-shelf and internally developed applications, ensuring continuous 24x7 operation and availability. You will participate in on-call rotations and be involved in database maintenance and disaster recovery activities. You will also be tasked with the physical implementation of databases, storage structures, high-availability solutions, and disaster recovery solutions. Proactive and reactive performance analysis will be a key part of your role, as you will monitor, troubleshoot, and resolve escalated Level 2 and Level 3 issues. Regular database capacity planning, trend analysis, and predictive resource requirements will be part of your responsibilities, along with developing scripts and tools to streamline database administration tasks. Collaboration with cross-functional teams will be essential to ensure the delivery of database services within established SLAs and performance targets.

Responsibilities

• Support Database Platform Engineering in the architecture, development, and deployment of MySQL databases in high SLA environments.
• Manage, support, and maintain database technology and infrastructure, adhering to architectural guidelines and policies.
• Perform database administration for off-the-shelf and internally developed applications, ensuring continuous 24x7 operation and availability.
• Install, configure, monitor, upgrade, and maintain MySQL databases in production and non-production environments.
• Participate in Database Maintenance and Disaster Recovery activities.
• Provide technical expertise and hands-on support in the consolidation and migration of databases to new hardware and platforms.
• Implement physical databases, storage structures, high-availability solutions, replication, and disaster recovery solutions.
• Conduct proactive and reactive performance analysis, monitoring, troubleshooting, and resolution of escalated Level 2 and Level 3 issues.
• Regularly perform database capacity planning related to growth and system utilization, including trend analysis and predictive resource requirements.
• Develop database and OS level scripts and tools to streamline administration tasks, deployment processes, and monitoring procedures.
• Collaborate with other Infrastructure engineering, product development, business operations, and technical operations to ensure delivery of database services within SLAs and performance targets.
• Adapt business requirements, model data, and develop database specifications, table, and element attributes.
• Evaluate, select, and implement DBA tools to improve task effectiveness such as performance monitoring and tuning, recovery, and change management processing.
• Monitor, analyze, and optimize the performance of MySQL databases by identifying and resolving performance bottlenecks and optimizing queries.
• Implement and enforce security measures and best practices to protect MySQL databases against unauthorized access and data breaches.

Requirements

• 2+ years of relevant work experience and a bachelor's degree, OR 5+ years of relevant work experience.
• 3-5 years of DBA experience in a MySQL environment.
• Hands-on experience with standalone instances, MySQL InnoDB clusters including geo-distributed and Master-Master group replication.
• Strong knowledge of UNIX and MySQL utilities, troubleshooting database production problems and connectivity issues.
• Proficiency in writing functions and packages for administration and application support.
• Strong knowledge of operating systems, scripting languages, data modeling, and business intelligence tools.
• Good interpersonal skills along with effective communication, both written and verbal.
• Demonstrated ability to solve complex systems and database environment issues.
• Ability to work well as a team and as an individual with minimal supervision.
• Strong MySQL expertise, including administering, optimizing, and troubleshooting MySQL databases.

Nice-to-haves

• Work experience in a Financial Institute is preferred.
• Familiarity with database monitoring tools such as Prometheus.
• Proficiency in scripting languages like Python, Shell, or Perl to automate routine tasks.

Benefits

• Medical
• Dental
• Vision
• 401(k)
• FSA/HSA
• Life Insurance
• Paid Time Off
• Wellness Program