Database Administrator

About the role

Build and maintain a data architecture based on the requirements. Design and develop Logical and Physical Data Model using ER Studio Data Architect. Create DDL scripts to establish and maintain necessary databases. Write complex SQL queries against SQL Server and DB2 databases. Create DML scripts to manipulate data. Work with project managers, solution architects, business analysts, application development teams and QA to ensure the quality of DDL and DML scripts. Perform performance tuning of SQL to improve efficiency. Work with NYS Agency representatives to develop gap analysis specifications and understand Agency business rules. Provide guidance and hands-on development for developing and maintaining queries in QMF for Workstation. Create clear and accurate documentation on data models, and description of data usage in the application process flow.

Responsibilities

• Design and develop logical and physical data models, and create DDL scripts for tables, views, indexes, triggers, stored procedures.
• Create Data Conversion Strategy Plan, Data Mapping Documents, Gap Analysis.
• Write complex DML SQL against enterprise SQL Server and DB2 databases.
• Work with tools like SQL Server Management Studio, SSMS Job Scheduler, SSIS, SSRS, Export/Import, ER Studio Data Architect, QMF for Workstation, Redgate SQL Compare, TSO.
• Use programming languages such as SQL, PL/SQL.
• Perform performance tuning of complex SQL against enterprise SQL Server and DB2 databases.

Requirements

• 84 months of experience designing and developing logical and physical data models, and creating DDL scripts for tables, views, indexes, triggers, stored procedures.
• 84 months of experience designing and developing Data Conversion Strategy Plan, Data Mapping Documents, Gap Analysis.
• 84 months of experience writing complex DML SQL against enterprise SQL Server and DB2 databases.
• 84 months of experience working with tools like SQL Server Management Studio, SSMS Job Scheduler, SSIS, SSRS, Export/Import, ER Studio Data Architect, QMF for Workstation, Redgate SQL Compare, TSO.
• 84 months of experience using programming languages such as SQL, PL/SQL.
• 60 months of experience performance tuning complex SQL against enterprise SQL Server and DB2 databases.

Qualifications

• Mandatory qualifications as detailed in the "Mandatory Qualifications" section.

Skills

• Experience with SQL Server and DB2 databases.
• Proficiency in SQL, PL/SQL, and other relevant programming languages.
• Knowledge of data modeling tools like ER Studio Data Architect.
• Experience with database management systems and tools such as SQL Server Management Studio, SSMS Job Scheduler, SSIS, SSRS, Export/Import, Redgate SQL Compare, TSO.
• Performance tuning skills for complex SQL queries.

Benefits

• Equal Employment Opportunity (EEO) policy.
• Compliance with federal, state, and local laws regarding diversity and inclusion.

Pay

Negotiable based on experience and qualifications.

Schedule

Full-time position with a flexible schedule to accommodate agency needs.