What are the responsibilities and job description for the Staff Database Engineer - MS SQL Server Development position at Visa?
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
Visa Merchant and Acquirer Processing Product Development (MAPPD) team is seeking a Staff Database Engineer to lead a world-class team of software and database engineers to deliver client-ready solutions by building the next generation of systems, automation and tools to support overall productivity and developer efficiencies. You will provide strategy, vision and technical leadership to the product development teams across Visa to ensure engineering teams are building DB products that use a foundational approach that prioritizes high availability and security.
As part of MAP PD team, you will work on enabling multiple technology teams that work on payment transaction processing, You will be responsible for mentoring top database engineering talent, keeping the team highly engaged and motivated while delivering exceptional results. Your ability to work across functions and teams will allow you to drive results and foster the right culture and environment to achieve Engineering Excellence and Innovation. You will be responsible for working with product development, quality engineering, security engineering, enterprise operations and other internal and external technology partners to deliver products for business integration & enablement.
Essential Functions:
- Support Database Engineering in the architecture, development and employment of Oracle and MS SQL Database on LUW in high SLA environments.
- Expert in writing T-SQL, PL/SQL programming, and performance tuning.
- Solid understanding on data model and ability to provide logical and physical design for the given business requirements.
- Design scalable database solution for Very Large Database (VLDB).
- Support the migration initiative of Oracle to SQL Server.
- Implementation of active-active configuration at the database layer.
- Engage in proof of concepts on new SQL Server features and advocate the business benefits to the leadership team.
- Provide database engineering for off the shelf and external merchant facing applications.
- Implementation of databases, storage structures, high-availability solutions, replication, encryption, and disaster recovery solutions.
- Follow the industry best practice in writing TSQL and PL/SQL code and unit test cases.
- Expert in writing T-SQL, PL/SQL programming, and performance tuning.
- Mentor junior resources provide necessary guidance and perform code reviews.
- Proactive performance analysis, troubleshooting and resolution of database issues.
- Work very closely with the application team and DBA team to ensure delivery of database services within the SLA's and performance target set.
- Support P1/P2 database issues which impacts the customer applications.
- Manage, support and maintain database technology and infrastructure, adhering to the architectural guidelines and policies.
- Address vulnerabilities and TSR findings reported by the DBA team.
- Ability to work well as a team and as an individual with minimal supervision.
- Ability to maintain composure under tight deadlines
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
Extensive experience in implementing SQL Server 2017 and SQL 2019 new features.
Work experience in the implementation of active-active configuration at the database layer.
Good understanding of the high availability and disaster recovery options. Expert in SQL Server native replication.
Experience with tools development, automation (CI/CD, Auto Deployment with Redgate, System Availability, etc.).
Extended experience in Agile Release Management practices, governance, and planning.
Ability to quickly identify and manage/mitigate risks.
Ability to influence Senior Leadership on direction of engineering efficiencies and integration management through data, roadmaps, short/long term plans, etc.
Strong ability to build and sustain working and strategic relationships across technology.
Strong leadership skills with demonstrated ability to lead global, cross-functional teams.
Strong analytical and problem-solving skills.
Additional Information
