Staff Database Engineer - MySQL
Staff Database Engineer - MySQL
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
At the heart of Visa lies a secure global payments processing network that for 40 years has empowered people businesses and governments in over 200 countries. It is in the midst of profound change innovating like never before and transforming and refreshing the technology assets to set the foundation for the next several decades.
Within Technology Infrastructure division provides bestinclass infrastructure services that are secure scalable continuous available. It architects builds and maintains secure and reliable data centers systems and networks to support the business functionality that Visa provides to payment industry stakeholders.
The Database team is part of Infrastructures Distributed Systems Division and is responsible for delivering open system database infrastructures with operational excellence being the industry leader in preventive and predictive operations driven by continuous innovation through selfheal and automated ecosystems architecting engineering and building the reliable scalable secure available and costeffective database infrastructure solutions for product development partners working closely with them to use database products to the best meeting various workload requirements being transactional analytical nonrelational or data warehouse.
The team is the technology owner of multiple RDBMS and NoSQL technologies is responsible to strategize advance and engineer enterprise solution for automated build/patching and efficient administration that meet security availability performance fast delivery and reporting requirements and to support projects and products using these technologies.
JOB SCOPE
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/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. He or she 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/functional specialist and works independently with guidance only in the most complex situations.
RESPONSIBILITIES
Primarily the architecture engineering deployment and support of MySQL database environment.
Support Database Platform Engineering in the architecture development and deployment of MySQL Database on LUW in high SLA environments. This includes but is not limited to advanced to expert engineering and implementation of the following:
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 oncall rotation.
Install configure monitor upgrade and maintain MySQL databases in production and nonproduction environments.
Support local/across the DC failover with High Availability Disaster Recovery environment with MySQL native Replication. Participate in Database Maintenance and DR activities.
Write/maintain OS level scripts for DB automation and application maintenance.
Provide technical expertise and handson support in consolidation and migration of databases to new hardware and platforms.
Physical implementation of databases storage structures highavailability solutions replication and disaster recovery solutions.
Proactive and reactive performance analysis monitoring troubleshooting and resolution of escalated Level 2 and Level3 issues.
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.
Work closely with other Infrastructure engineering product development business operations and technical operations to ensure delivery of database services within the SLAs 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.
This is a hybrid position. Expectation of days in office will be confirmed by your hiring manager.
Qualifications :
Basic Qualifications:
- 5 years of relevant work experience with a Bachelors Degree or at least 2 years of work experience with an Advanced degree (e.g. Masters MBA JD MD) or 0 years of work experience with a PhD OR 8 years of relevant work experience.
Preferred Qualifications:
- Bachelors degree in computer science or information technology field is a must.
- 710 years of DBA experience managing MySQL databases Versions 8.x
- 56 years of MySQL Native replication experience managing complex replication topology
- InnoDB Cluster Experience is a plus.
- Strong understanding of MySQL database fundamentals
- Strong understanding of MySQL Native Replication fundamentals
- Strong understanding of 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
- Strong knowledge of operating systems Shell scripting Perl/Python scripting is a plus
- 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.
Additional Information :
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.
Remote Work :
No
Employment Type :
Fulltime
Employment Type
Full-time
