Database Administrator Expert

Job Title: Database Administrator Expert

Location: Albany, NY

Role Type: Contract

Job Overview:

The Database Administrator Expert will play a pivotal role in supporting the priorities and initiatives. This position will be integral to the project portfolio, particularly in supplementing the staff for initiatives resulting from the Budget that impact Grants and Scholarship programs.

Key responsibilities:

• Building and maintaining a robust data architecture tailored to meet specific requirements.
• Designing and developing Logical and Physical Data Models using ER Studio Data Architect, and creating DDL scripts to establish and maintain databases.
• Writing complex SQL queries against SQL Server and DB2 databases, and creating DML scripts for data manipulation.
• Collaborating with project managers, solution architects, business analysts, application development teams, and QA to ensure the quality of DDL and DML scripts.
• Conducting performance tuning of SQL queries to enhance efficiency.
• Working closely with representatives to develop gap analysis specifications and understand business rules.
• Providing guidance and hands-on development for queries in QMF for Workstation.
• Creating comprehensive documentation on data models and describing data usage in application process flow.

Requested Qualifications:

• 84 months of Experience designing and developing logical and physical data models, and creating DDL scripts for tables, views, indexes, triggers, and stored procedures.
• 84 months of Experience designing and developing Data Conversion Strategy Plan, Data Mapping Documents, and 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, and TSO.
• 84 months of experience using programming languages such as SQL, PL/SQL.
• 60 Months of experience in performance tuning complex SQL against enterprise SQL Server and DB2 databases.