Sr. Database Engineer - DB2

  • Full-time
  • Job Family Group: Technology and Operations

Company Description

As the world’s leader in digital payments technology, Visa’s mission is to connect the world through the most creative, reliable and secure payment network - enabling individuals, businesses, and economies to thrive. Our advanced global processing network, VisaNet, provides secure and reliable payments around the world, and is capable of handling more than 65,000 transaction messages a second. The company’s dedication to innovation drives the rapid growth of connected commerce on any device, and fuels the dream of a cashless future for everyone, everywhere. As the world moves from analog to digital, Visa is applying our brand, products, people, network and scale to reshape the future of commerce.

At Visa, your individuality fits right in. Working here gives you an opportunity to impact the world, invest in your career growth, and be part of an inclusive and diverse workplace. We are a global team of disruptors, trailblazers, innovators and risk-takers who are helping drive economic growth in even the most remote parts of the world, creatively moving the industry forward, and doing meaningful work that brings financial literacy and digital commerce to millions of unbanked and underserved consumers.

You’re an Individual. We’re the team for you. Together, let’s transform the way the world pays.

Job Description

As an engineer in this team, the individual will be involved in the plan, 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 and engineering 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.

Essential Functions:

  • Primarily the architecture, engineering, deployment, and support of IBM DB2 LUW database technology. 

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

  • Manage, support and maintain database technology and infrastructure, adhering to the architectural guidelines and policies.
  •  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.
  •  Provide technical expertise and hands-on support in consolidation and migration of databases to new hardware and platforms.
  •  The physical implementation of databases, storage structures, high-availability solutions, replication, and disaster recovery solutions.
  • Proactive and reactive performance analysis, monitoring, troubleshooting and resolution of 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 another Infrastructure engineering, product development, business operations, and technical operations to ensure delivery of database services within the SLA’s and performance targets.
  •  Adapt business requirements, model data, and develop database specifications, table and element attributes.
  •  Participate in the evaluation, selection, and implementation of DBA tools to improve the effectiveness of tasks such as performance monitoring and tuning, recovery, and database change management processing.
  •  Ability to work well as a team and as an individual with minimal supervision.Additional information

 

Qualifications

Basic Qualification

  • 2 years of work experience with a Bachelor’s Degree or an Advanced Degree (e.g. Masters, MBA, JD, MD, or PhD)

Preferred Qualifications

  •  5-7 years of DBA experience, generally with  DB2  LUW and partitioned databases/ DPF environment.
  • Strong knowledge and extensive experience with  DB2 UDB RDBMS technologies is a mandatory and good understanding of BLU acceleration.
  •  Sound knowledge of all UNIX and DB2 UDB utilities. Troubleshoot database production problems and database connectivity issues.
  •  Should have strong UNIX platform skills and understanding of the network, storage, tiered application environments, and security.
  •  Proficiency in writing SQL procedures, functions and packages for administration and application support and experience with Q replication, Range partitioned tables, Hash partitioned tables, Replicated MQT's and MDC's.
  • 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.

Additional Information

Work Hours:

  • Incumbent is expected to work during core business hours

Travel Required:

  • Incumbent will be expected to travel less than 5%

Physical Requirements:

  • This position will be performed in an office setting.  The position will require the incumbent to sit and stand at a desk, communicate in person and by telephone, frequently operate standard office equipment, such as telephones and computers, and reach with hands and arms.

Visa will consider for employment qualified applicants with criminal histories in a manner consistent with EEOC guidelines and applicable local law.

Privacy Policy