Database Administrator
Fidelity Investments Chennai, Tamil Nadu, India
Financial Services · 10,001+ employees
About the role
The Database Administrator is responsible for managing Db2 on z/OS, Aurora PostgreSQL, and Aerospike platforms. Key duties include providing application database support, data migration assistance, and performing SQL tuning and performance optimization.
What they look for
Requirements
Candidates must have 2-5 years of industry experience and a degree in BE or MCA. Extensive experience in DB2 z/OS administration, SQL, JCL, and COBOL is required.
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
Similar roles
-
Database Engineer
DigiFlight Columbia, Maryland, United States
-
Senior Oracle Database Engineer - PL/SQL
Quevera LLC Anne Arundel County, Maryland, United States
-
Oracle Database Administrator
Auctane Wrocław, Lower Silesian Voivodeship, Poland
-
Senior Database Administrator (PostgreSQL and MySQL Focus)
CommIT Kyiv, Ukraine
-
Cloud Database Administrator - Remote (WFH)
COGNITIVE MEDICAL SYSTEMS INC United States · $90K–$115K/yr
-
Database Administrator II - SQL Server/MariaDB
Quevera LLC $141K–$189K/yr