Staff Database Engineer - SQL DBA

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

This team is part of Visa's Database Engineering team and is responsible for Architecting, Engineering, Automation and building the reliable, scalable, secure, available, and cost-effective database infrastructure solutions. This team is the technology owner of multiple RDBMS and NoSQL technologies, is responsible to strategize enterprise solution for automated build/patching and efficient administration that meet security availability  performance, reporting requirements and to support projects using these technologies.

Roles and Responsibilities:

• Responsible for SQL Server Database design, development, deployment, life cycle management, migration, and automation efforts.
• Install, configure, and support SQL Server HADR, Clustering, Replication topology, Encryption, Partitioning, Performance, Backup, Security, SSIS and SSRS services.
• Implement deployment standards, recommendations, operating procedures, and cost-effective Active-Active solutions.
• Implement SQL Server Cloud Deployment model and standards, Integration, and onboarding to cloud platforms.
• Implement and support complex SQL migrations and optimization part of consolidation and technology reduction efforts.
• Review, analyze and implement License optimization, consolidation, and version compliance standards for SQL Server Infrastructure across VISA.
• Perform proof of concepts, onboarding and certification of new SQL versions and tools.
• Automate and Integrate SQL Server version upgrade, patching and security standards.
• Create Internal dashboard and reporting for Inventory discovery and metrics using Power BI and SSRS services.
• Write, maintain PowerShell scripts for DB Deployment, patching and automation efforts.
• Provide L3 project support for escalated incidents, problem investigation and performance optimization.

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

• 5 or more years of relevant work experience with a Bachelor’s 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
• 5+ years of DBA experience with Microsoft SQL Server - HADR, Clustering, Always On, Distributed AG, Replication, Encryption, Partitioning, Performance Tuning.
• Expertise in performing proof of concepts, onboarding and certification of new SQL versions and tools.
• Strong experience in writing and managing PowerShell scripts for DB Deployment, patching and automation efforts.
• Experience in Automation and Integrate SQL Server version upgrade, patching and security standards.
• Expertise in complex SQL migrations and optimization part of
  consolidation and technology reduction efforts.

Preferred:

• 6 or more years of work experience with a Bachelor’s Degree or 4 or more years of relevant experience with an Advanced Degree (e.g. Masters, MBA,  JD, MD) or up to 3 years of relevant experience with a PhD
• Responsible for Database Architecture/design, development, deployment, Migrations, Database consolidations, High availability, capacity planning, co-ordination, Database administration, Performance tuning & monitoring, installation, Automation, patch management, upgrade of SQL server Databases.
• Strong knowledge in SQL Server Cloud Deployment model and standards, Integration, and onboarding to cloud platforms.
• Solid knowledge in database replication technologies including Always-on, Golden Gate, P2P etc. and strong architectural, Engineering skills to design systems that meet various applications High Availability and Disaster Recovery requirements.
• Strong knowledge in Automation and Integrate SQL Serv