Sr. Database Engineer at Visa

Job description

About Us Visa is a world leader in payments technology, facilitating transactions between consumers, merchants, financial institutions and government entities across more than 200 countries and territories, dedicated to uplifting everyone, everywhere by being the best way to pay and be paid. At Visa, you'll have the opportunity to create impact at scale — tackling meaningful challenges, growing your skills and seeing your contributions impact lives around the world. Join Visa and do work that matters – to you, to your community, and to the world. Progress starts with you. 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 Ansible ,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. Expectation of days in office will be confirmed by your hiring manager. Qualifications Basic 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 knowledge in SQL Server Cloud Deployment model and standards, Integration, and onboarding to cloud platforms. Strong experience in writing and managing Ansible, 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 Qualifications: 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 SQ