Recently postedOther

DB2- Administartor

IPS Technology Services, LLCAlbany, NY🇺🇸United States

Quick overview

SeniorityMid Senior

Work modeOn Site

LocationAlbany, NY, United States

PL/SQLSQLScrumComplianceRegulatory ReportingAzureSQL ServerAgile

Job description

Job Title: Database Administrator (Expert) - DB2

Duration in months: 24

Location: Albany, NY 12255

Work Mode: Onsite/Hybrid

Interview Process: Webcasting

Mandatory Documents:

· Resume

· Passport Copy mandatory for Non USA Citizens

· Copy of Visa Stamping Page

· Three Professional References

· Copy of Driver License (USA Citizens)

· Pre-submission Video screening + ID verification required

Requested Qualification:

· 84 months of experience designing and developing logical and physical data models and creating DDL scripts for tables, views, indexes, triggers, and stored procedures.

· 84 months of experience designing and developing Data Conversion Strategy Plans, Data Mapping Documents, and Gap Analysis documentation.

· 84 months of experience writing complex DML SQL against enterprise Microsoft SQL Server and IBM DB2 databases.

· 84 months of experience working with SQL Server Management Studio (SSMS), SSMS Job Scheduler, SSIS, SSRS, Export/Import tools, ER/Studio Data Architect, QMF for Workstation, Redgate SQL Compare, and TSO.

· 84 months of experience using SQL and PL/SQL programming languages.

· 60 months of experience performance tuning complex SQL against enterprise Microsoft SQL Server and IBM DB2 databases.

· Specialized Data Modeling Experience

12 months of experience using ER/Studio Data Architect to support enterprise data architecture initiatives, including logical and physical data modeling, metadata management, database design, and DDL generation.

· Hybrid Database Environment Experience

24 months of experience designing enterprise data models and writing complex SQL for IBM DB2 z/OS and Microsoft SQL Server environments utilizing ER/Studio Data Architect, QMF for Workstation, TSO, SQL Server Management Studio (SSMS), and Redgate SQL Compare.

· Professional Database Certification

Candidate must possess at least one of the following certifications:

Microsoft Certified: Azure Database Administrator Associate (DP-300)

Microsoft Certified: Azure Data Engineer Associate (DP-203)

IBM Certified Database Administrator - DB2

IBM Certified Application Developer - DB2

· Candidate must have at least 12 months experience in the following:

Experience leading enterprise data architecture and database modernization initiatives.

Experience preparing technical documentation for audits, compliance reviews, and regulatory reporting.

Experience participating in Agile and Scrum-based project environments.