Database Administrator
JSM Consulting Inc. · Albany, NY · 6 days ago
On-siteInformation TechnologyContract
Skills
- Designing and developing logical and physical data models, creating DDL scripts for tables, views, indexes, triggers, stored procedures
- Writing complex DML SQL against enterprise SQL Server and DB2 databases
- Using tools such as SQL Server Management Studio, SSMS Job Scheduler, SSIS, SSRS, Export/Import, ER Studio Data Architect, QMF for Workstation, Redgate SQL Compare, TSO
- Using programming languages such as SQL, PL/SQL
- Performance tuning complex SQL against enterprise SQL Server and DB2 databases
Experience
- 84 months of experience designing and developing Data Conversion Strategy Plan, Data Mapping Documents, Gap Analysis
- 9 12 months of experience working with SQL Server Management Studio, SSMS Job Scheduler, SSIS, SSRS, Export/Import, ER Studio Data Architect, QMF for Workstation, Redgate SQL Compare, TSO
- 6 8 months of experience performance tuning complex SQL against enterprise SQL Server and DB2 databases