Database Developer,SQL Server & IBM DB2

Role: Database Developer SQL Server & IBM DB2

Location: Albany NY (Onsite)

Duration: 24 months

Requested Qualification

• 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

• 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