Home
/
Data and Analytics
/
Senior Site Reliability Engineer - Database Administration (MySQL)
Senior Site Reliability Engineer - Database Administration (MySQL)-September 2024
Austin
Sep 21, 2024
ABOUT VISA
Visa’s vision is to be the best way to pay and be paid for everyone, everywhere.
10,000+ employees
Technology, Engineering
VIEW COMPANY PROFILE >>
About Senior Site Reliability Engineer - Database Administration (MySQL)

  Company Description Visa is a world leader in digital payments, facilitating more than 215 billion payments transactions between consumers, merchants, financial institutions and government entities across more than 200 countries and territories each year. Our mission is to connect the world through the most innovative, convenient, reliable and secure payments network, enabling individuals, businesses and economies to thrive.

  When you join Visa, you join a culture of purpose and belonging – where your growth is priority, your identity is embraced, and the work you do matters. We believe that economies that include everyone everywhere, uplift everyone everywhere. Your work will have a direct impact on billions of people around the world – helping unlock financial access to enable the future of money movement.

  Join Visa: A Network Working for Everyone.

  Job Description As an engineer in this team, the individual will be involved in the plan, build, and run activities related to database technology and infrastructure. The role will contribute to the design and architect, solution engineering, and support, will be responsible for delivering database projects, maintaining the running systems, able to perform problem analysis and troubleshooting. The individual should be well versed in database administration and engineering practices and principles. The individual will share the responsibility of overall database build, deployment, and support. The individual will provide technical influence and subject matter expertise for the database team, responsible for solving complex problems and taking a broad perspective to identify innovative solutions. The role serves as a technical and functional specialist and works independently with guidance only in the most complex situations.

  Essential Functions:

  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 the architectural guidelines and policies.

  Database administration for off the shelf and internally developed applications, ensure continuous 24x7 operation and availability in support of mission critical business applications and participating in on-call rotation.

  Install, configure, monitor, upgrade and maintain MySQL database in production and non-production environments.

  Participate in Database Maintenance and DR activities.

  Provide technical expertise and hands-on support in consolidation and migration of databases to new hardware and platforms.

  Physical implementation of databases, storage structures, high-availability solutions, replication, and disaster recovery solutions. 

  Proactive and reactive performance analysis, monitoring, troubleshooting and resolution of escalated Level 2 and Level 3 issues.  Responding to database-related incidents, diagnose issues, perform root cause analysis, and implement corrective actions to ensure system stability and availability.

  Regular database capacity planning related to database growth and system utilization, trend analysis, predictive future database resource requirements, and the structured organized reporting of the same.

  Automation and Scripting: Develop Database and OS Level scripts and tools to streamline database administration tasks, deployment processes, monitoring procedures and application maintenance.

  Work closely with other Infrastructure engineering, product development, business operations, and technical operations to ensure delivery of database services within the SLA’s and performance targets.

  Adapt business requirements, model data, and develop database specifications, table, and element attributes.

  Participate in the evaluation, selection, and implementation of DBA tools to improve the effectiveness of tasks such as performance monitoring and tuning, recovery, and database change management processing.

  Database Performance Optimization: Monitor, analyze, and optimize the performance of MySQL databases by identifying and resolving performance bottlenecks, optimizing queries, and implementing performance tuning techniques.

  Database Administration: Perform regular database administration tasks such as database installation, configuration, backup, recovery, and security management. Ensure high availability and disaster recovery strategies are in place.

  Monitoring and Alerting: Develop and implement database monitoring and alerting systems to proactively identify issues, respond to alerts, and troubleshoot database-related problems.

  Database Security: Implement and enforce security measures and best practices to protect the MySQL databases against unauthorized access, data breaches, and other security threats.

  Collaboration: Work closely with cross-functional teams including developers, system administrators, and network engineers to resolve database-related issues and improve overall system performance.

  This is a hybrid position. Hybrid employees can alternate time between both remote and office. Employees in hybrid roles are expected to work from the office 2-3 set days a week (determined by leadership/site), with a general guidepost of being in the office 50% or more of the time based on business needs.

  Qualifications Basic Qualifications

  • 2+ years of relevant work experience and a Bachelors degree, OR 5+ years of relevant work experience.

  Preferred Qualifications

  • 3 or more years of work experience with a Bachelor’s Degree or more than 2 years of work experience with an Advanced Degree (e.g. Masters, MBA, JD, MD)

  • 3-5 years of DBA experience, with MySQL environment.

  • Hands-on experience with Stand alone instances, MySQL InnoDB clusters including geo-distributed and Master – Master group replication

  • Sound knowledge of all UNIX and MySQL utilities. Troubleshooting database production problems and database connectivity issues.

  • Should have strong UNIX platform skills and understanding of network, storage, tiered application environments and security.

  • 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 skills.

  • Demonstrated ability to solve complex systems and database environment issues.

  • Demonstrate ability to work in a complex organization to determine business and customer needs, providing the best solution to meet those needs.

  • Work experience in a Financial Institute will be preferred.

  • Ability to work well as a team and as an individual with minimal supervision.

  • Strong MySQL expertise: In-depth knowledge and experience in administering, optimizing, and troubleshooting MySQL databases. Familiarity with MySQL clustering, replication, and high availability solutions.

  • Database Performance Tuning: Proficient in query optimization, indexing strategies, and performance tuning techniques to improve database performance and response times.

  • Database Administration: Hands-on experience in database installation, configuration, backup, recovery, and security management. Knowledge of database administration tools and utilities.

  • Monitoring and Alerting Tools: Familiarity with database monitoring tools such as Prometheus.

  • Scripting and Automation: Proficiency in scripting languages like Python, Shell, or Perl to automate routine tasks and create efficient database management scripts.

  • Troubleshooting and Problem-solving: Strong analytical and problem-solving skills to identify and resolve database-related issues in a timely manner.

  • Strong Communication: Excellent verbal and written communication skills to effectively collaborate with team members, document processes, and communicate technical information to non-technical stakeholders.

  • Continuous Learning: A mindset of continuous learning and staying up to date with the latest advancements, trends, and best practices in database technologies and management.

  Additional Information Work Hours: Varies upon the needs of the department.

  Travel Requirements: This position requires travel 5-10% of the time.

  Mental/Physical Requirements: This position will be performed in an office setting.  The position will require the incumbent to sit and stand at a desk, communicate in person and by telephone, frequently operate standard office equipment, such as telephones and computers.

  Visa is an EEO Employer.  Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability or protected veteran status.  Visa will also consider for employment qualified applicants with criminal histories in a manner consistent with EEOC guidelines and applicable local law.

  Visa will consider for employment qualified applicants with criminal histories in a manner consistent with applicable local law, including the requirements of Article 49 of the San Francisco Police Code.

  U.S. APPLICANTS ONLY: The estimated salary range for a new hire into this position is 100,200.00 to 127,800.00 USD, which may include potential sales incentive payments (if applicable). Salary may vary depending on job-related factors which may include knowledge, skills, experience, and location. In addition, this position may be eligible for bonus and equity. Visa has a comprehensive benefits package for which this position may be eligible that includes Medical, Dental, Vision, 401 (k), FSA/HSA, Life Insurance, Paid Time Off, and Wellness Program.

Comments
Welcome to zdrecruit comments! Please keep conversations courteous and on-topic. To fosterproductive and respectful conversations, you may see comments from our Community Managers.
Sign up to post
Sort by
Show More Comments
SIMILAR JOBS
Industry analytics and forecasting Internship - 12 months
Garrett is the true pioneer of automotive turbocharging dating back more than 60 years and continues today as the world's leader in turbo technology solutions and an experienced supplier of electric
Data Scientist
About the Team The International Analytics team is looking for a Data Scientist to guide measurement, strategy, and tactical decision-making using Advanced Analytics approaches, as we expand our logi
Market Intelligence Analyst
We know that BUILDING HOMES & COMMUNITIES BEGINS WITH BUILDING THE BEST TEAM! How would you like to be a part of team that has been providing the American Dream of homeownership to families for m
Senior Data Analyst: Engineering and Product
About InvoiceCloud:  InvoiceCloud, an EngageSmart solution, is a leading provider of online bill payment services. Founded in 2009, the company has grown to be one of the leading disruptors in the cl
Associate, Workforce Planning (Scheduler)
About the Team As one of DoorDash's core operations teams, Support Ops ensures that when there are bumps in the last mile there's always someone there to help make things right. Our team designs, man
Deductions Specialist
Wilton's Journey Wilton is a US heritage brand with a 95-year history in baking and decorating. Now fully integrated into the Dr. Oetker family, Wilton aspires to be the most influential and successf
Senior Associate - Security Analyst
Location Designation:Hybrid When you join New York Life, you're joining a company that values career development, collaboration, innovation, and inclusiveness. We want employees to feel proud about b
Cyber Threat Intelligence Analyst, Level 1
Reporting to the Manager of Intelligence Operations, the Cyber Threat Intelligence Analyst I is responsible for identifying, collecting, analyzing, and documenting the indicators and observables from
Student-Athlete Advisor - Equity, Diversity & Inclusion (EDI)
Competition Number: REQ 5609 TITLE: Student-Athlete Advisor - Equity, Diversity & Inclusion (EDI) DIVISION: Athletics & Recreation SALARY: Payband H, starting rate $35.06 per hour HOURS PER W
Associate Research Analyst
Introduction The Public Utilities Regulatory Authority (PURA) has an exciting opportunity for two (2) Associate Research Analysts to join the Office of Technical and Regulatory Analysis (TRA) located
Copyright 2023-2024 - www.zdrecruit.com All Rights Reserved