Sr. Database Engineer

Visa Visa · Fintech · Bengaluru, India, IN

Visa is seeking a Sr. Database Engineer to architect, engineer, and automate reliable, scalable, secure, and cost-effective database infrastructure solutions. The role involves managing RDBMS and NoSQL technologies, strategizing enterprise solutions for automated build-patching, and ensuring efficient administration to meet security, availability, and performance requirements. Responsibilities include SQL Server design, deployment, life cycle management, migration, automation, HADR, clustering, replication, encryption, partitioning, performance tuning, cloud deployment, and complex migrations. The role also involves license optimization, onboarding new SQL versions, automating upgrades and patching, and providing L3 support. Scripting with Ansible and PowerShell, and creating internal dashboards with Power BI and SSRS are also key aspects.

What you'd actually do

  1. Responsible for SQL Server Database design, development, deployment, life cycle management, migration, and automation efforts.
  2. Install, configure, and support SQL Server HADR, Clustering, Replication topology, Encryption, Partitioning, Performance, Backup, Security, SSIS and SSRS services.
  3. Implement deployment standards, recommendations, operating procedures, and cost-effective Active-Active solutions.
  4. Implement SQL Server Cloud Deployment model and standards, Integration, and onboarding to cloud platforms.
  5. Automate and Integrate SQL Server version upgrade, patching and security standards.

Skills

Required

  • DBA experience with Microsoft SQL Server - HADR, Clustering, Always On, Distributed AG, Replication, Encryption, Partitioning, Performance Tuning
  • SQL Server Cloud Deployment model and standards, Integration, and onboarding to cloud platforms
  • Writing and managing Ansible, PowerShell scripts for DB Deployment, patching and automation efforts
  • Automation and Integrate SQL Server version upgrade, patching and security standards
  • Complex SQL migrations and optimization
  • Proof of concepts, onboarding and certification of new SQL versions and tools

Nice to have

  • 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
  • Database replication technologies including Always-on, Golden Gate, P2P
  • Automation of infrastructure and database provisioning using Terraform, Ansible, and PowerShell, integrated with CI-CD pipelines via Jenkins, Bitbucket, and GitHub

What the JD emphasized

  • 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.
  • 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.