Principal – Database Administration
Bangalore, Karnataka
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 accommodations@fmr.com or call 800-835-5099 for more information
Benefits Developed for You
From the little things that make every day better to those big-picture, life-changing tools. That’s exactly what you’ll get at Fidelity. We have an amazing package of benefits and programs designed to help you thrive both at and outside of work.
Insurance
Affordable and accessible healthcare benefits for you and your loved ones.
- Coverage of up to INR 300,000 for you along with your spouse/partner, with additional top-up options available
- Insurance covers for parents/in-laws made available at subsidized costs
- Personal accident insurance cover of six times your annual basic salary
- Life insurance cover of eight times your annual basic salary
Wellness
We invest in nurturing healthy habits and promoting overall wellness of our associates through three pillars – Physical, Emotional, and Financial wellness.
Parenting
To help you through the exciting yet demanding times of parenthood, avail of time off and other benefits such as childcare allowance and access to daycare.
Transport
You will have access to free transport services to and from work, subject to residing within our pre-defined boundary limits
Retirement
Finally, like the icing on the cake, we offer benefits that will help you contribute to and invest towards your retirement.
- National Pension System (NPS) offered at Fidelity:
- At Grade 6 and below, Fidelity will match your NPS contribution up to 5% of your basic salary
- At Grade 7 and above, Fidelity contributes 10% of your basic salary towards NPS as part of your compensation structure
- Avail of other statutory benefits such as EPF, VPF and Gratuity
Read more about our Benefits program.
Committed to Continuous Learning
At Fidelity, we are constantly adapting to the changing needs of our customers, new technologies, and better ways of working. And we empower our associates to do the same, with an emphasis on developing skills that will help propel you forward in your career while being able to make an impact for Fidelity’s customers around the world.
We offer a wide range of options including online, in-person, and mentor driven solutions – as well as learning days and job shadow opportunities to expose you to new elements of our business to broaden your experience.
Ongoing Opportunities for Growth
- Free access to thousands of online training resources
- Internal clubs focused on trending topics and associate interests
- Ability to pursue online or in-person technical certifications
Read more about our Learning & Development program.
Connected to Our Communities
At every level of our organization, you’ll find people who are committed to doing their part to make the world a better place. We host events and conduct volunteering activities, encouraging associates across the organization to get involved and make an impact on the lives of people in the communities where we live and work.
Fidelity Cares
- Through our community relations program, we provide associates with several opportunities to actively volunteer and create an impact
- Host numerous company-wide volunteering and awareness events.
- Partner with a number of not-for-profit organizations to benefit our local communities
Year-Round Volunteer Opportunities
- Partner with schools and our not-for-profit organizations on financial literacy programs, career counselling, and online tutoring for students
- Teach employability skills to youth from low-income backgrounds, and conduct mock interviews to prepare them for corporate jobs
- Create joyful learning experiences for primary school children through the ‘Art in Education’ program
- Plant urban mini forests and participate in local cleanup efforts
Read more about our Fidelity Cares community relations program..
