Database Admin

• Position Job Title: Database Administrator (Expert Level)

• Request ID / Position ID: HBITS-08-15049

• Work Location: AESB, 80 S. Swan Street, 7th Fl, Albany, NY, 12255

• Telecommuting: Allowed (50% / hybrid schedule)

• Interview Format: Webcasting (Candidate required to be on camera)

Mandatory & Requested Qualifications

Mandatory Qualifications (84 Months Experience Required):

1. Experience designing and developing logical and physical data models and creating DDL scripts for tables, views, indexes, triggers, and stored procedures.

2. Experience designing and developing Data Conversion Strategy Plans, Data Mapping Documents, and Gap Analysis documentation.

3. Experience writing complex DML SQL against enterprise Microsoft SQL Server and IBM DB2 databases.

4. 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.

5. Experience using SQL and PL/SQL programming languages.

6. Experience performance tuning complex SQL against enterprise Microsoft SQL Server and IBM DB2 databases.

Requested Qualifications:

• Specialized Data Modeling Experience: 12 months of experience using ER/Studio Data Architect to support enterprise data architecture initiatives (logical/physical modeling, metadata management, database design, 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 using ER/Studio, QMF for Workstation, TSO, SSMS, and Redgate SQL Compare.

• Professional Database Certification: Must possess at least one of the following:

• 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

• Additional Experience (At least 12 months):

• Leading enterprise data architecture and database modernization initiatives.

• Preparing technical documentation for audits, compliance reviews, and regulatory reporting.

• Participating in Agile and Scrum-based project environments.