Sign upLog in
Database Administrator Jobs in New York

Database Administrator

i-Link Solutions Inc
  • Albany,, NY
  • Instant Apply
1 day ago

Job Description

Job Title: Database Administrator Expert
Task ID: HBITS-08-15049
Position Duration: 24 Months
Client: State of NY
Agency: Information Technology Services (ITS)

Please call (703) 466-0951 | (571) 351-1868 | (703) 348-3018 or email at

nysreqs@ilinksolutions.com



Description
Daily 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 against 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 directly with NYS agency representatives to understand business rules, conduct gap analysis, and support data-related initiatives.
  • Provide technical guidance development support for QMF for Workstation reporting and query solutions.
  • Utilize SQL Server Management Studio (SSMS), SSIS, SSRS, Redgate SQL Compare, TSO, and related tools to support database administration and development activities.
  • 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.
Mandatory Qualifications
1 84 months of experience designing and developing logical and physical data models and creating DDL scripts for tables, views, indexes, triggers, and stored procedures.
2 84 months of experience designing and developing Data Conversion Strategy Plans, Data Mapping Documents, and Gap Analysis documentation.
3 84 months of experience writing complex DML SQL against enterprise Microsoft SQL Server and IBM DB2 databases.
4 84 months of experience working with SQL Server Management Studio (SSMS), SSMS Job Scheduler, SSIS, SSRS, Export/Import tools, ER/Studio Data Architect, QMF for Workstation, Redgate SQL Compare, and TSO.
5 84 months of experience using SQL and PL/SQL programming languages.
6 60 months of experience performance tuning complex SQL against enterprise Microsoft SQL Server and IBM DB2 databases.
7 Specialized Data Modeling Experience
" 12 months of experience using ER/Studio Data Architect to support enterprise data architecture initiatives, including logical and physical data modeling, metadata management, database design, and DDL generation.
8 Hybrid Database Environment Experience
" 24 months of experience designing enterprise data models and writing complex SQL for IBM DB2 z/OS and Microsoft SQL Server environments utilizing ER/Studio Data Architect, QMF for Workstation, TSO, SQL Server Management Studio (SSMS), and Redgate SQL Compare.
9 Professional Database Certification
" Candidate must possess at least one of the following certifications:
" Microsoft Certified: Azure Database Administrator Associate (DP-300)
" Microsoft Certified: Azure Data Engineer Associate (DP-203)
" IBM Certified Database Administrator - DB2
" IBM Certified Application Developer - DB2
10 Candidate must have at least 12 months experience in the following:
" Experience leading enterprise data architecture and database modernization initiatives.
" Experience preparing technical documentation for audits, compliance reviews, and regulatory reporting.
" Experience participating in Agile and Scrum-based project environments.
Required Documentation " Re sume
" Copy of Candidate Identification
(i.e., Driver's License/Green Card/Visa and Passport if applicable)
" Any documents referenced in the above Requested Qualifications
(i.e., professional certifications, degrees, etc.)

i-Link Solutions requires a Bachelor's Degree or its equivalent in Computer Science, Computer Information Systems, Information Systems or a closely related field of study for all positions.

Disclaimer: i-Link Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability

Numbers & Facts

LocationAlbany,, NY

Skills

  • Agile Programming Methodologiesunmatched
  • Analysis Skillsunmatched
  • Best Practicesunmatched
  • Business Analysisunmatched
  • Change Managementunmatched
  • Computer Scienceunmatched
  • Computer Workstationsunmatched
  • Data Description Language (DDL)unmatched
  • Data Mappingunmatched
  • Data Modelingunmatched
  • Data Qualityunmatched
  • DataArchitect Data Modeling Toolunmatched
  • Database Administrationunmatched
  • Database Analysisunmatched
  • Database Designunmatched
  • Database Programmingunmatched
  • Database Triggersunmatched
  • Embarcadero ER/Studiounmatched
  • Enterprise Architectureunmatched
  • Gap Analysisunmatched
  • IBM DB2unmatched
  • IBM Product Familyunmatched
  • IBM TSO/ISPFunmatched
  • IBM z-OS Operating Systemunmatched
  • Import/Exportunmatched
  • Information Technology & Information Systemsunmatched
  • Leadershipunmatched
  • MCDBA - Microsoft Certified Database Administratorunmatched
  • Mentoringunmatched
  • Metadataunmatched
  • Microsoft SQL Serverunmatched
  • Microsoft Windows Azureunmatched
  • Oracle PL-SQLunmatched
  • People Managementunmatched
  • Performance Tuning/Optimizationunmatched
  • Process Flowunmatched
  • QMFunmatched
  • Quality Assuranceunmatched
  • Query Optimizationunmatched
  • Reconciliationunmatched
  • Regulatory Complianceunmatched
  • Regulatory Reportsunmatched
  • SQL (Structured Query Language)unmatched
  • SQL Databasesunmatched
  • SQL Server Integration Services (SSIS)unmatched
  • SQL Server Reporting Services (SSRS)unmatched
  • Schedule Developmentunmatched
  • Scripting (Scripting Languages)unmatched
  • Scrum Project Management and Software Developmentunmatched
  • Software Developmentunmatched
  • Source Code/Configuration Management (SCM)unmatched
  • Stored Proceduresunmatched
  • Strategic Planningunmatched
  • Systems Administration/Managementunmatched
  • Technical Leadershipunmatched
  • Technical Supportunmatched
  • Technical Writingunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Resume Builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Resume Builder