Database Administrator - DB2

Nys Oits•Albany, NY

2d•Hybrid

About The Position

The Database Administrator will work closely with business stakeholders, agency representatives, solution architects, project managers, developers, and quality assurance teams to design, implement, and maintain enterprise database solutions supporting HESC’s strategic initiatives. The role is based in Albany, New York, with a hybrid work model requiring 50% telecommuting and 50% in-office work per week. The posting describes the position as an expert-level, 8-month contract.

Requirements

At least 84 months of experience with SSMS, SSMS Job Scheduler, SSIS, SSRS, Export/Import tools, ER/Studio Data Architect, QMF for Workstation, Redgate SQL Compare, and TSO.
At least 84 months of experience using SQL and PL/SQL programming languages.
At least 60 months of experience performance tuning complex SQL against enterprise Microsoft SQL Server and IBM DB2 databases.
At least 84 months of experience designing and developing logical and physical data models and creating DDL scripts for tables, views, indexes, triggers, and stored procedures.
At least 84 months of experience designing and developing Data Conversion Strategy Plans, Data Mapping Documents, and Gap Analysis documentation.
At least 84 months of experience writing complex DML SQL for enterprise Microsoft SQL Server and IBM DB2 databases.
Professional database certification: at least one of Microsoft Certified: Azure Database Administrator Associate (DP-300), Microsoft Certified: Azure Data Engineer Associate (DP-203), IBM Certified Database Administrator - DB2, or IBM Certified Application Developer - DB2.
At least 12 months of experience leading enterprise data architecture and database modernization initiatives.
At least 12 months of experience preparing technical documentation for audits, compliance reviews, and regulatory reporting.
At least 12 months of experience participating in Agile and Scrum-based project environments.
At least 12 months of experience using ER/Studio Data Architect for enterprise data architecture initiatives, including logical and physical data modeling, metadata management, database design, and DDL generation.
At least 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 Data Architect, QMF for Workstation, TSO, SSMS, and Redgate SQL Compare.

Responsibilities

Build and maintain enterprise data architecture based on business and technical requirements.
Design and develop logical and physical data models using ER/Studio Data Architect.
Create and maintain DDL scripts for tables, views, indexes, constraints, triggers, and stored procedures.
Write, optimize, and maintain complex SQL and DML scripts for Microsoft SQL Server and IBM DB2 databases.
Support data conversion activities, including data mapping, transformation, reconciliation, validation, and migration.
Collaborate with project managers, business analysts, application developers, solution architects, and QA teams to ensure database solutions meet project requirements.
Analyze and tune database performance through query optimization, indexing strategies, and execution plan analysis.
Work with New York State agency representatives to understand business rules, conduct gap analysis, and support data-related initiatives.
Provide technical guidance and development support for QMF for Workstation reporting and query solutions.
Use SQL Server Management Studio (SSMS), SSIS, SSRS, Redgate SQL Compare, TSO, and related tools for database administration and development.
Develop and maintain technical documentation, including data models, data dictionaries, source-to-target mapping documents, process flows, and database standards.
Support database deployment, version control, data quality initiatives, and change management activities.
Mentor junior team members and provide guidance on database design and development best practices.