Senior Enterprise Database Administrator & Data Architect

i-Link Solutions; City of Albany (NY); On-site; USD 110,000 - 160,000; Full time

Job summary

i-Link Solutions seeks an Expert Database Administrator to design and maintain enterprise data architecture for a State of NY ITS project. Responsibilities include data modeling, DDL scripting, complex SQL/PLSQL, data conversion, and performance tuning across SQL Server and IBM DB2 environments.

The role requires extensive experience with ER/Studio Data Architect, SSMS/SSIS/SSRS, and related tools, plus collaboration with PMs, analysts, developers, and QA.

Qualifications

• 7+ years designing logical and physical data models and creating DDL scripts for tables, views, indexes, triggers, and stored procedures.
• 7+ years designing Data Conversion Strategy Plans, Data Mapping Documents, and Gap Analysis documentation.
• 7+ years writing complex DML SQL against enterprise Microsoft SQL Server and IBM DB2 databases.
• 7+ years using SSMS, SSMS Job Scheduler, SSIS, SSRS, ER/Studio, QMF for Workstation, Redgate SQL Compare, and TSO.
• 7+ years of SQL and PL/SQL programming languages.
• 5+ years performance tuning complex SQL against SQL Server and DB2 databases.
• Specialized Data Modeling Experience with ER/Studio and enterprise data architectures.
• 12+ months experience with ER/Studio Data Architect for enterprise data modeling, metadata management, and DDL generation.

Responsibilities

• Build and maintain enterprise data architecture based on requirements.
• Design and develop logical and physical data models.
• Create and maintain DDL scripts for tables, views, indexes, constraints, triggers, and procedures.
• Write, optimize, and maintain SQL and DML for SQL Server and DB2.
• Support data conversion activities including mapping, transformation, reconciliation, validation, and migration.
• Collaborate with stakeholders to ensure solutions meet requirements.
• Analyze and tune database performance through query optimization and indexing.
• Provide guidance on data-related initiatives and best practices.
• Mentor junior team members on database design and development.

Skills

Data modeling

SQL & PL/SQL

SSMS/SSIS/SSRS

ER/Studio Data Architect

Redgate SQL Compare

T-SQL

QMF for Workstation

SSMS

Education

Bachelor's Degree in CS/IS or related field

Microsoft DP-300

Microsoft DP-203

IBM DB2 Database Administrator

IBM DB2 Certification for DB2 10

Tools

ER/Studio Data Architect

SSMS

SSIS

SSRS

Redgate SQL Compare

QMF for Workstation

TSO

Export/Import tools

Job description

i-Link Solutions seeks an Expert Database Administrator to design and maintain enterprise data architecture for a State of NY ITS project. Responsibilities include data modeling, DDL scripting, complex SQL/PLSQL, data conversion, and performance tuning across SQL Server and IBM DB2 environments.

The role requires extensive experience with ER/Studio Data Architect, SSMS/SSIS/SSRS, and related tools, plus collaboration with PMs, analysts, developers, and QA.