Database Administrator
Fidelity Investments · Chennai, Tamil Nadu, India
Financial Services · 10,001+ employees
About the role
The Database Administrator is responsible for managing and supporting Db2 on z/OS, Aurora PostgreSQL, and Aerospike platforms. This role includes performing database migrations, SQL tuning, and providing 12x7 on-call support for mission-critical brokerage applications.
What they look for
Requirements
Candidates must have 2-5 years of industry experience with a background in DB2 z/OS administration and proficiency in SQL, JCL, and COBOL. A bachelor's degree or MCA is required for this position.
Full description
Job Description:
Job Title – Database Administrator
The Purpose of Your Role
Responsible for managing Fidelity Brokerage’s Db2 on z/OS Platform along with Aurora PostgreSQL and Aerospike on AWS.
The Value You Deliver
As part of this role, the DBA will be responsible for the below key responsibilities:
- Providing Application Database and Replication support for a large DB2 z/OS sysplex environment
- Providing Application Database and Data Migration support for an established cloud-based database infrastructure
- SQL tuning and Performance on both Db2 and PostgreSQL
- Maintenance of Databases – Utilities management
- Providing 12x7 on-call support
- Database Engineering
The Skills that are Key to this role
- Extensive experience in DB2 z/OS Database Administration in a large complex Database Environment
- Extensive experience in SQL, JCL, COBOL
- Experience in Qrep and IIDR replication products
The Skills that is good to have for this role
- Knowledge of DB2 LUW on LINUX/UNIX
- Experience on CA Platinum tools
- Expertise in distributed technologies (Linux, VSCode, Git, Jenkins) including AWS based Aurora PostgreSQL
- Expertise in AWS concepts and services like IAM, SSO, KMS/CMK, PG, PHZ, VPC, Route53, RDS, RDS-Proxy, Lambda, S3, EBS,CloudWatch, DMS, EC2, AMI, rehydration, etc. and provisioning them
How Your Work Impacts the Organization
FAE (Fidelity Architecture & Engineering) provides a wide range of brokerage technology solutions for BRT,FIT and IWMS technology and business partners. FAE Tech team provides technology services in the area of development, maintenance, quality assurance and production support of mission critical brokerage applications. FAE is part of the Enterprise Technology organization and has over 1,300 associates located in Boston, Covington, Denver, Merrimack, New York, New Jersey, Smithfield, Raleigh-Durham, Westlake, as well as India and Ireland. The FAE India team is distributed across Chennai and Bangalore.
The Expertise we’re Looking For
- BE/MCA
- 2-5 years of industry experience
Location : Chennai, Bangalore - Manyata Shift timings: 8:30 am - 5:00 pm
Certifications:
Category:
Information Technology
