Visa REF8087O - Senior (MySQL) Database Engineer in Austin, Texas
The Database team is part of Visa Technology Operations' nfrastructure’s Distributed Systems Division and is responsible for delivering open system database infrastructures with operational excellence. We are the industry leader in preventive and predictive operations driven by continuous innovation through self-healing and automated ecosystems; we architect, engineer, and build the reliable, scalable, secure, available, and cost-effective database infrastructure solutions for product development partners.
Our team is the technology owner of multiple RDBMS and NoSQL technologies, and we are responsible to strategize, advance, and engineer enterprise solutions for automated build/patching and efficient administration, that meets security, availability, performance, fast delivery and reporting requirements, as well as to support projects and products using these technologies.
In this role, you will primarily focus on the architecture, engineering, deployment and support of *MySQL database environment. * You will support the Database Platform Engineering in the architecture, development and deployment of MySQL Database on LUW in high SLA environments. Experience supporting MySQL Database technologies will be a plus. This includes, but is not limited to advanced engineering and implementation of the following:
Management, support and maintainenance of database technologies and infrastructure, adhering to the architectural guidelines and policies
Database administration for off-the-shelf and internally developed applications, ensuring continuous 24x7 operation and availability in support of mission critical business applications and participating in on-call rotation
Installation, configuration, monitoring, upgrading and maintaining MySQL databases in production and non-production environments
Support local/across the DC failover with High Availability Disaster Recovery environment with Native MySQL replication. Participate in Database Maintenance and DR activities
Write/maintain OS level scripts for DB automation and application maintenance
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
Regular database capacity planning related to database growth and system utilization, trend analysis, to predict future database resource requirements, and the structured organized reporting of the same
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
Ability to work well as a team and as an individual with minimal supervision
*Required unless otherwise specified as a preference or a plus: *
Bachelor Degree in Computer Science or Information technology field is a must.
7-10 years of DBA experience, managing MySQL databases, Versions 5.x and onwards
5-6 years of MySQL Replication experience, managing complex replication topology
InnoDB Cluster Experience is a plus
Strong understanding of MySQL database fundamentals including Native Replication fundamentals, and MySQL database security management
Should have strong UNIX platform skills and understanding of network, storage, tiered application environments and security
Proficiency in writing SQL procedures and functions for administration and application support
Knowledge of operating systems, Shell scripting, Perl/Python scripting
Good interpersonal skills along with effective communication (both written and verbal) skills
Demonstrated ability to solve complex systems and database environment issues
Demonstrated 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 is preferred.
All your information will be kept confidential according to EEO guidelines.