Database Administrator (SQL / DB2)

Trigyn Technologies Limited; City of Albany (NY); On-site; USD 110,000 - 140,000; Full time

Job summary

Trigyn Technologies, Inc. is seeking a Database Administrator in Albany, NY to design, implement, and maintain enterprise database solutions supporting agency initiatives.

You will work with stakeholders, architects, project managers, developers, and QA to ensure robust data services. Responsibilities include building data architecture, developing data models, and maintaining scripts and performance tuning.

Qualifications

• Design and develop enterprise data models and schemas.
• Create and maintain DDL scripts for tables, views, and procedures.
• Provide data conversion planning and mapping documentation.

Responsibilities

• Build and maintain enterprise data architecture based on requirements.
• Design logical and physical data models using ER/Studio.
• Write and optimize SQL/PLSQL against SQL Server and DB2.
• Support data migration and data quality initiatives.
• Mentor junior team members on database design and development.

Skills

Data architecture

Query optimization

Mentorship

Stakeholder collaboration

Education

Microsoft DP-300

Microsoft DP-203

IBM DB2 Certification

Tools

ER/Studio Data Architect

SSMS

SSIS

SSRS

Redgate SQL Compare

TSO

QMF for Workstation

Job description

Trigyn's direct government client has an immediate need for Database Administrator in Albany, NY.

The consultant will work closely with business stakeholders, agency representatives, solution architects, project managers, developers, and quality assurance teams to design, implement, and maintain enterprise database solutions supporting client's strategic initiatives.

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:

• Uses specialized software to store and organize data, which may include capacity planning, installation, configuration, database design, migration, performance monitoring, security and troubleshooting, as well as backup and data recovery.
• Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
• 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 Plans, Data Mapping Documents, and Gap Analysis documentation.
• 84 months of experience writing complex DML SQL against enterprise Microsoft SQL Server and IBM DB2 databases.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.
• 84 months of experience using SQL and PL/SQL programming languages.
• 60 months of experience performance tuning complex SQL against enterprise Microsoft SQL Server and IBM DB2 databases.

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.

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.

Professional Database Certification:

• 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

TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 35 years. TRIGYN is an ISO 27001:2022 and CMMI Level 5 certified company.