Database Administrator

Job overview

The Database Administrator role is hybrid in Albany, NY. Compensation is not specified. The position supports the State of New York's Information Technology Services agency on a 24-month assignment. The administrator builds and maintains enterprise data architecture and database solutions, supporting agency data initiatives through modeling, SQL development, conversion, performance tuning, deployment, and documentation. The work helps project teams deliver database solutions aligned with business and technical requirements.

What you'll do

• Build and maintain enterprise data architecture
• design logical and physical data models and DDL scripts
• write and optimize SQL and DML for Microsoft SQL Server and IBM DB2
• support data mapping, transformation, reconciliation, validation, and migration
• tune database performance
• work with agency representatives on business rules and gap analysis
• support reporting and query solutions
• maintain technical documentation
• support deployment, version control, data quality, and change management
• and mentor junior team members.

What we're looking for

Skills & competencies

database administrator

enterprise data architecture

sql server

ibm db2

data modeling

data conversion

er/studio

albany ny

i-link solutions

hybrid

state of new york

24-month position

Work arrangement

• Weekend coverage required

Why this role

The posting requires extensive experience with SQL Server and IBM DB2, data modeling, data conversion documentation, and named tools including ER/Studio Data Architect, QMF for Workstation, SSMS, SSIS, SSRS, Redgate SQL Compare, and TSO. A listed database certification and a bachelor's degree or equivalent in a related field are required.

About the employer

i-Link Solutions Inc is hiring for this role. Industry: All Other Professional, Scientific, and Technical Services. Sector: 54.