Principal - Database Administration
Location
Bangalore | India
Job description
2090300
Job Description 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 - Very strong DB2 z/OS Database Administration and SQL/application database performance tuning skills
- 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.
Our formula is simple: we support our team, and they support our customers. That culture begins with our employees, whose personal and professional growth is key to our collective success. In keeping with that legacy, our privately-held company offers associates career stability and security, while at the same time encouraging your professional exploration and growth. At Fidelity India, we are proud to continue that legacy. With offices in Bangalore and Chennai, our Indian branch is now celebrating 20 years as a Global Capability Center. To find out more, visit India.Fidelity.com, or our global site at fidelitycareers.com.
Fidelity Investments is an equal opportunity employer, and whenever possible we accommodate applicants with disabilities who need adjustments to complete the application or interview process. Please email us at [HIDDEN TEXT] or call 800-835-5099 for more information
Job tags
Salary
