Position: Sr. Site Reliability Engineer – Database Administration (MySQL)
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 24×7 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
Company: Visa
Location: Anywhere
Salary Range:
Job Providers:
Learn4Good