Principal - Database Administration

**Job Title : Principal - Database Administration**

**The Purpose of This Role**
- Provide Database Administration to Mainframe DB2 systems. Work with senior level business and technology partners to define and implement database solutions. The person will be responsible in providing Database Administration to DB2 systems.

**The Value You Deliver**

The Mainframe DBA group provides a variety of services related to DB2 on z/OS systems at Fidelity. Those services might include but are not necessarily limited to:

- Design operational and transactional database solutions that meet the functional and non
- functional business requirements.
- Interface with Technology Operations and infrastructure groups to plan and manage changes in the production environment
- Analyze complex database/Systems problems and implement solutions and/or workarounds
- Review business data requirements, database designs and database access code
- Project coordination and planning
- Evaluation and recommendation of software products in database management arena
- As a Database Administration, provide administration work, maintain and provide 24X7 support for DB2 z/OS
- Participate in periodic Disaster Recovery tests
- Participates in the evaluation, selection, and piloting of new technologies
- Work with a wide range of teams across various issues, locations, and time zones
- Provide cross training to peers in the Database Support group
- Work closely with other departments within Fidelity and act as interface between the DB2 group and the other technical teams coordinating their upgrades/projects/deliverables

**The Skills that are Key to this role**

**Technical / Behavioral**
- In-depth experience in DB2 utilities Working on Reorg, Quiesce, Copy, Runstats, Recovery, Modify recovery, Unload, Load, Repair, Bind, Rebind, Listcat, Stogroup and other maintenance activities for Production, Staging and Test databases
- DB2 object design, creation and manipulations
- Data refresh from PROD to TEST environments
- Performance monitoring/tuning
- Supporting all DB2 activities in Production, Integration and Test environment.
- Development and Maintenances of DB2 Application Backup
- Recovery strategies for DB2
- Experience with Database replication solutions (IBM QREP, CDC, Power Exchange, etc.)
- Solid experience with z/OS environment (TSO, ISPF, SMP/E)
- In-depth knowledge JCL, SQL, and DB2 utilities
- In-depth knowledge of DB2 Datasharing and SYSPLEX environment
- Experience in vendor interactions (IBM PMR, CA, etc.)
- Experience with CA DB2 tools, OMPM, Insight, etc.
- Very Strong problem management skills - Work with the software vendors and other technical partners to troubleshoot problems and implement solutions and corrective action
- Working knowledge of DB2 Connect and DDF work flow
- Working knowledge of DB2 stored procedures
- Proficiency in the use of DB2 monitoring tools (DB2PM, CA Insight, SYSVIEW, Omegamon, CA Detector, etc.)
- Strong interpersonal and communication skills
- Proficiency of REXX programming a plus

**The Skills that are Good To Have for this role**
- QREP
- CDC
- Cloud exposure - Azure & AWS

**How Your Work Impacts the Organization**

You would be able to contribute in maintaining stability of our end points by upkeeping infrastructure uptime through structured software, distribution and patch management mechanism thereby helping associates to perform their day to day tasks seamlessly.

**The Expertise We’re Looking For**
- 12-15 years of IT experience
- Graduate

**Location**: Chennai - Bangalore

**Shift timings**: 1:00 pm - 10:00pm

**Certifications**:
At Fidelity, building a better financial future— for everyone— is our mission. For the last 75+ years, our privately-held company has remained committed to supporting our clients throughout their lifelong financial journeys.