DB2 DBA

Role name:

Analyst

Role Description:

• Proven work experience as a DB2 Database Administrator• Firm grasp on DB2 database management and deployment• Experience with DB2 diagnostic tools• Strong command over SQL and DB2 related scripting• Excellent understanding of data administration and management function (collection, analysis, distribution, etc.)• Proficient in database security administration• 5+ years of experience in being a DB2 database administrator• Degree-level qualification in a relevant discipline (e.g. Computer Science, Information Technology or similar)• Experience of working in a multi-vendor outsourced environment and with remote offshore teams • Exposure and knowledge of compliance and controls frameworks like SOX, NACHA, PCI and others.• Ability to influence stakeholders and work closely with them to determine acceptable solutions• Excellent communication skills to work within a multi supplier environment • Experience with performance tuning and capacity planning to optimize database performance and ensure efficient resource usage• Excellent problem-solving skills• Knowledge of DB2 Replication

Competencies:

Mainframe DB2 - Application Development, Database Administration (DBMS)

Experience (Years):

8-10

Essential Skills:

• Create/Update application DB objects (tables, function, index, procedures, etc.)• 5+ years of experience in being a DB2 database administrator• Application specific SQL tuning, diagnostics, recommended changes• Data repairs SQL verification• SQL code implementation for Production and test environments• Health checks• Manage/monitors database events (batch jobs)• Database growth tracking• Batch execution support (Production and test environments)• Support of Customer Service System (CSS) production push support• Database backups and restores (Production and test environments)• Index, partition recommendations and implementation• Archival Strategy recommendations and implementation• Manage database event monitors• Application Database growth tracking and management• Data provisioning and management of SOX controls• Manage application data auditing• Manage application database links• Support System Administrator Physical DBA• Support installation, upgrade and patching of DB2 database environment • Maintain DB2 database environments, ensuring optimal performance and data integrity• Work with Physical DB2 DBA on capacity planning and management• Respond to requests and incidents related to the logical environment quickly and efficiently• Writing database documentation, including data standards, procedures and definitions for the data dictionary• Testing and modifying databases to ensure they operate reliably• Manage database access accurately and within SOX regulations• Ability to analyze and solve complex database issues using exceptional problem-solving skill quickly and efficiently • Recovery and restoration in case of any data loss

Desirable Skills:

• Create/Update application DB objects (tables, function, index, procedures, etc.)• 5+ years of experience in being a DB2 database administrator• Application specific SQL tuning, diagnostics, recommended changes• Data repairs SQL verification• SQL code implementation for Production and test environments• Health checks• Manage/monitors database events (batch jobs)• Database growth tracking• Batch execution support (Production and test environments)• Support of Customer Service System (CSS) production push support• Database backups and restores (Production and test environments)• Index, partition recommendations and implementation• Archival Strategy recommendations and implementation• Manage database event monitors• Application Database growth tracking and management• Data provisioning and management of SOX controls• Manage application data auditing• Manage application database links• Support System Administrator Physical DBA• Support installation, upgrade and patching of DB2 database environment • Maintain DB2 database environments, ensuring optimal performance and data integrity• Work with Physical DB2 DBA on capacity planning and management• Respond to requests and incidents related to the logical environment quickly and efficiently• Writing database documentation, including data standards, procedures and definitions for the data dictionary• Testing and modifying databases to ensure they operate reliably• Manage database access accurately and within SOX regulations• Ability to analyze and solve complex database issues using exceptional problem-solving skill quickly and efficiently • Recovery and restoration in case of any data loss

Country:

United States

Branch City Location:

TCS - Boston, MA

WALTHAM

Waltham,MA

BA Recruiter Name:

ANJANA A N

Start Date:

Jul-31-2025

Duration (Months):

3

Status:

Open

Keywords:

IT Systems Analyst III DB2 DBA