JC
Database Administrator
JSM Consulting Inc
- 🇺🇸 United States
- On-site
- 21 hours ago
- SQL
- Microsoft SQL Server
- DB2
- SSIS
- SSRS
- PL/SQL
- Data Modeling
- z/OS
- Azure
- Agile
- Scrum
21 hours ago
| 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. |
Database Administrator · JSM Consulting Inc