Database Administrator (DB2 z/OS | Mainframe | SQL | JCL | Bangalore)

Allegis Global Solutions (AGS); Chennai District, Bengaluru; On-site; INR 2,500,000 - 4,500,000; Full time

Job summary

Allegis Global Solutions (AGS) seeks a Database Administrator to manage DB2 z/OS, Aurora PostgreSQL, and AWS-based databases. The role covers replication, data migration, and performance tuning in a large enterprise environment.

Location is in Bangalore/Chennai with in-person interviews; relocation not considered. Candidates should have BE/MCA and 2-4.6 years of experience. This is a full-time on-site position within a global tech organization.

Qualifications

• Extensive experience in DB2 z/OS Database Administration in a large complex Database Environment.
• n'text

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

Skills

DB2 z/OS

DB2 DBA

Database Administration

Mainframe

IBM DB2

SQL

JCL

COBOL

DB2 Utilities

Performance Tuning

SQL Tuning

Data Replication

Q Rep

IIDR

PostgreSQL

Aurora PostgreSQL

AWS

Amazon RDS

Linux

Git

Jenkins

CA Platinum

Database Engineering

Production Support

Data Migration

Application Database Support

Education

BE/MCA

Tools

CA Platinum tools

VSCode

Git

Jenkins

Job description

Job Description:

Location : Bangalore / Chennai

Skillset : DB2 z/OS, DB2 DBA, Database Administration, Mainframe, IBM DB2, SQL, JCL, COBOL, DB2 Utilities, Performance Tuning, SQL Tuning, Database Replication, Q Rep, IIDR, PostgreSQL, Aurora PostgreSQL, AWS, Amazon RDS, Db2 LUW, Linux, Git, Jenkins, CA Platinum, Database Engineering, Production Support, Data Migration, Application Database Support.

Note: This opportunity is open only to candidates currently based in Bangalore or Chennai, as the first round of interviews will be conducted in person. Relocation candidates will not be considered.

Job Title Database Administrator

The Purpose of Your Role

Responsible for managing Organization 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

Organization provides a wide range of brokerage technology solutions for BRT,FIT and IWMS technology and business partners. Tech team provides technology services in the area of development, maintenance, quality assurance and production support of mission critical brokerage applications. Organization 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 India team is distributed across Chennai and Bangalore.

The Expertise we’re Looking For

• BE/MCA
• 2-4.6 years of industry experience

Regards,

Franklin.A

Talent Acquisition