Senior Database Engineer - DB2, NoSQL

Visa Consolidated Support Services India; Bengaluru; On-site; INR 1,000,000 - 1,500,000; Full time

Job summary

Visa Consolidated Support Services India seeks a Database Reliability engineer responsible for building and supporting database infrastructures. The role involves deployment, maintenance, and ensuring availability of DB2 LUW and NoSQL databases.

Candidates should have a Bachelor's in Computer Science and experience in database administration. This position is hybrid, allowing part of the work to be conducted remotely.

Qualifications

• 4-8 years of DBA experience, generally with DB2 LUW and exposure to NoSQL databases.
• Strong knowledge of DB2 LUW technologies.
• Sound knowledge of all UNIX and DB2 LUW utilities.

Responsibilities

• Support Database Platform Engineering with DB2 LUW and NoSQL technologies.
• Manage and maintain database technology and infrastructure.
• Plan and define requirements for database implementation.

Skills

DB2 LUW

NoSQL technologies

UNIX

Scripting languages

Database administration

Education

Bachelor's Degree in Computer Science or other technology field

Tools

Cassandra

MongoDB

Job description

The Database Reliability team is part of the 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 self‑heal and automated ecosystems, building reliable, scalable, secure, available, and cost‑effective database infrastructure solutions for product development partners.

The team is responsible for building, supporting databases, automated build/patching and efficient administration, meeting 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 build and run activities related to database technology and infrastructure. The role will contribute to design/architect, solution engineering, and support; will be responsible for delivering database projects, maintaining running systems, and performing problem analysis and troubleshooting.

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, ensuring continuous 24×7 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 Level 3 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

• Bachelor's/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.
• Strong knowledge and extensive experience with DB2 LUW technologies is mandatory with an understanding of NoSQL technologies like Cassandra.
• Sound knowledge of all UNIX and DB2 LUW utilities. Troubleshoot database production problems and database connectivity issues.
• 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 Institution will be preferred.