Sr. Database Engineer - DB2

Visa Consolidated Support Services India; Bengaluru; Hybrid; INR 1,800,000 - 2,700,000; Full time

Job summary

Visa Consolidated Support Services India is seeking a Database Reliability Engineer to design, build, deploy and support DB2 LUW databases and related NoSQL technologies. The role emphasizes 24x7 availability, high-availability, and automated operations in a large-scale environment.

You will collaborate with cross-functional teams to ensure performance, security, and successful delivery of database services; prior experience with IBM DB2 LUW and Cassandra is preferred, along with strong UNIX

Qualifications

• Bachelor's degree in Computer Science or related field.
• 4–8 years of DBA experience with DB2 LUW exposure.
• Strong knowledge of DB2 LUW and NoSQL like Cassandra.
• Solid UNIX platform skills and DB2 utilities.
• Proficient in scripting, data modeling and BI tools.
• Excellent written and verbal communication; team-oriented.

Responsibilities

• Provide build, deployment and support for DB2 LUW databases in production and non-production environments.
• Manage and maintain database technology in line with architectural guidelines.
• Perform problem analysis, troubleshooting and on-call rotation.
• Plan prerequisites for database implementations (OS, storage, network).
• Ensure 24x7 availability for mission critical apps and DR readiness.
• Write OS-level scripts for automation and maintenance.

Skills

UNIX/Linux troubleshooting

Database troubleshooting

On-call support

Collaboration

Education

Bachelor's degree in Computer Science

Tools

DB2 LUW

NoSQL Cassandra

UNIX

Scripting (Shell)

BI tools

Job description

Job Description

At the heart of Visa lies a secure, global payments processing network that for 40 years has empowered people, businesses and governments in over 200 countries. It is in the midst of profound change, innovating like never before and transforming and refreshing the technology assets to set the foundation for the next several decades.

Within Technology, Infrastructure division provides best-in-class infrastructure services that are secure, scalable, continuous available. It architects, builds and maintains secure and reliable data centers, systems and networks to support the business functionality that Visa provides to payment industry stakeholders.

The Database Reliability team is part of Site Reliability Engineering Division and is responsible for delivering and supporting open system database infrastructures with operational excellence, being the industry leader in preventive and predictive operations driven by continuous innovation through selfheal and automated ecosystems, building the reliable, scalable, secure, available, and cost-effective database infrastructure solutions for product development partners; working closely with them to use database products to the best, meeting various workload requirements, being transactional, analytical, non-relational, or data warehouse.

The team is responsible to build, support databases, automated build/patching and efficient administration, that meet security, availability, performance, fast delivery, and reporting requirements, and to support projects and products using these technologies.

Job Scope:

As an engineer in this team, the individual will be involved in the build and run activities related to database technology and infrastructure. The role will contribute to the design/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 practices and principles. The individual will share the responsibility of overall database build, deployment, and support. He or she 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/functional specialist and works independently with guidance only in the most complex situations.

Primarily the deployment and support of this database technology.

Responsibilities:

• Support Database Platform Engineering in the development and deployment of DB2 LUW and DB2 partitioned databases/ DPFin high SLA environments. Support NoSQL technologies like MongoDB, Cassandra, and Redis will be a plus.


• Manage, support and maintain database technology and infrastructure, adhering to the architectural guidelines and policies.


• Experienced technologist with strengths in problem determination and technical support for high-volume production database systems.


• Plan and define prerequisites for the database implementation such as operating system, storage and network requirements.


• Database administration for off the shelf and internally developed applications, ensure continuous 24x7 operation and availability in support of mission critical business applications and participating in on-call rotation.


• Install, configure, monitor, upgrade and maintain DB2 LUW databases in production and non-production environments.


• Support local failover with TSA and High Availability Disaster Recovery (HADR) environment. Participate in Database Maintenance and DR activities.


• Write/maintain OS level scripts for DB automation and application maintenance.


• Physical implementation of databases, storage structures, high-availability solutions, replication, and disaster recovery solutions.


• Proactive and reactive performance analysis, monitoring, troubleshooting and resolution of L1, escalated Level 2 and Level3 issues.


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


• Work closely with other Engineering teams, product development, business operations, and technical operations to ensure delivery of database services within the SLAs and performance targets.


• Adapt business requirements, model data, and develop database specifications, table, and element attributes.


• Ability to work well as a team and as an individual with minimal supervision.

This is a hybrid position. Expectation of days in office will be confirmed by your hiring manager.

Qualifications

Requirements:

• Bachelors/Degree in Computer Science or other technology field is a must.


• Experience: 4-8 years of DBA experience, generally with DB2 LUW and exposure to NoSQL database like Cassandra.


• Key Skillsets: Strong knowledge and extensive experience with DB2 LUW technologies is mandatory with an understanding on NoSQL technologies like Cassandra.


• Other Required Skillsets: Sound knowledge of all UNIX and DB2 LUW utilities. Troubleshoot database production problems and database connectivity issues.


• Should have strong UNIX platform skills and understanding of network, storage, tiered application environments and security.


• Strong knowledge of operating systems, scripting languages, data modeling and business intelligence tools.


• Good interpersonal skills along with effective communication (both written and verbal) skills.


• Demonstrated ability to solve complex systems and database environment issues.


• Demonstrate ability to work in a complex organization to determine business and customer needs, providing the best solution to meet those needs.


• Sound knowledge of NoSQL technologies like MongoDB, Cassandra is preferable.


• Work experience in a Financial Institute will be preferred.