IIT Inc. Home

IIT Jobs Data Bank-Job Detail

Submit Resume For This Job (via email)
Follow us on LinkedIn or Twitter or Facebook
Follow us on Facebook Follow us on LinkedIn
ID Location Skills $$ Job Type Status
11102 Brooklyn, NY 11201 SQL DBA \ Developer: Database Administrator, Data Modeling, SQL, ETL, SSIS, SSAS, SSRS (LOCAL) DOE Contract OPEN
If you are unable to click on links above to submit resume, you may email your resume to

Subject=IIT Career Site/Resume for JobID=11102 (SQL DBA \ Developer: Database Administrator, Data Modeling, SQL, ETL, SSIS, SSAS, SSRS (LOCAL)) in Brooklyn NY 11201 (SJU)

Estimated Length: 24 months 35 hrs per week 


Mandatory Requirements

Expert  (84 Months + )

Desired Requirements

  • 84+ Months of Experience in Database Management doing Data Modeling
  • 84+ Months of Experience with MS SQL Server in the setting up and configuring Microsoft SQL Server in a virtual and clustering environment.
  • 84+ Months of Experience in ETL using IBM DataStage (IBM Infosphere Information Server),Tienet and eScholar Applications
  • 84+ Months of Experience in SQL Server Backups, Restore Strategies, and Replication
  • 84+ Months of experience in designing and coding SQL Server Integration Services (SSIS)
  • 84+ Months of experience in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS)
  • 84+ Months of experience in SQL Server Performance Tuning and Query Optimization 
  • 84+ Months of experience writing complex Stored Procedures, Functions, and views using SQL
  • Bachelor’s Degree 
  • MS SQL Server Certification 


  • Manage requirements gathering and analysis for new and existing projects
  • Support Microsoft SQL Server 2012/2014/2016 databases across all environments
  • Support and Troubleshoot Tienet application implementation
  • Support Microsoft Windows 2012 and 2016 Enterprise Servers including configuration and maintenance
  • Automate work processes by use of scripting, specifically PowerShell and Python to help streamline work and enhance processes 
  • Perform administration tasks related to the IBM InfoSphere Information Server (IIS), DataStage and QualityStage
  • Install and configure Microsoft SQL Server 2012/2014/2016 and Microsoft Windows 2012 and 2016 servers
  • Monitor Microsoft SQL Server activity on a proactive basis and tune the system for optimal performance
  • Create, design, manage and troubleshoot SSIS packages
  • Monitor and troubleshoot ETL jobs daily using BCP, DTSRUN, SSIS and other Performance Monitoring tools
  • Automate Octopus deployments with azure devops and GIT integration
  • Use Online Analytical Processing (OLAP) and Online Transactional Processing (OLTP) Data modeling with the ERWIN data modeling tool
  • Support Operational data model and data mapping
  • Support the development and maintenance of DIIT/STARS data dictionary
  • Manage and Support DB2 relational system and troubleshoot issues on the DB2 System
  • Administer DB2 Connect, DB2 Gateway in different ETL set up.
  • Install and Support Geographic Information System (GIS) servers and Identify bottlenecks in  ArcGIS applications
  • Support and Administer Escholar application and configuration of eScholar Data Manager (eDM) Servers
  • Troubleshoot/upgrade/redesign ETL processes across different platforms
Submit Resume For This Job (via email)
Don't See a Position Matching Your Skills?
Click here to Email / Register your resume and be notified of future job openings.
About IIT:

Founded in 1995, IIT is a leading provider of Workforce Solutions to Government and Fortune-1000 organizations. IIT is a winner of Inc-500 award. IIT's core services include:

  • Consulting for projects / IT Outsourcing
  • IT staffing (Contract / Temporary / Contingent / Consulting)
  • Custom Workforce Solutions
  • Recruitment Process Outsourcing (RPO)
  • Headquartered in New York, IIT has over 400 consultants deployed at Client Sites. Other IIT highlights include

  • Winner of Inc-500 award 2 consecutive years
  • Winner of Ernst & Young / USPAACC Fast-50 award 2 consecutive years
  • Winner of USPAACC Top-10 Award in the Northeast US
  • IBM Business Partner
  • Oracle Business Partner
  • Adobe Business Partner
  • NYSA Member - New York Staffing Association - Regional Affiliate of ASA / American Staffing Association
  • NYS MBE certified
  • Our Consultants love working for IIT

  • Competitive compensation
  • W2 or C2C
  • Biweekly Direct Deposit for W2 Consultants
  • Visa and Green Card sponsorship opportunities for qualified individuals
  • Local contact for you to meet and talk to anytime (not someone sitting overseas in a different time zone)
  • Follow us on LinkedIn or Twitter or Facebook

    IIT is an Equal Opportunity Employer