Avatar for JSM Consulting
Improves asset performance & optimizes operations through IT services & asset management

Database Administrator

  • |84 years of exp
  • |Contract
Posted: 3 weeks ago
Job Location
Remote Work Policy

In office - WFH flexibility

Visa Sponsorship

Not Available

RelocationAllowed
Skills
SQL
PL/SQL
SSRS
Microsoft SQL Server
IBM DB2
TSO
SSIS
ER/Studio Data Architect
DDL
SQL Server Management Studio (SSMS)
DML SQL
Redgate SQL Compare
QMF for Workstation
SSMS Job Scheduler
Export/Import Tools

About the job

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 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.