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
10724 Albany, NY 12255 SQL Developer: Data Models, Gap Analysis, DDL Scripts, DML SQL, SQL Server, DB2 Databases DOE Contract OPEN
If you are unable to click on links above to submit resume, you may email your resume to
1196-MH2857@apply.maxhire.net    

Subject=IIT Career Site/Resume for JobID=10724 (SQL Developer: Data Models, Gap Analysis, DDL Scripts, DML SQL, SQL Server, DB2 Databases) in Albany NY 12255 (SJU)

Estimated Length: 24 months Full-Time 8am – 5:30 pm

Mandatory Requirements

Expert 84+ Months

Desired Requirements

  • 84 Months of Experience designing and developing logical and physical data models, and creating DDL scripts for tables, views, indexes, triggers, stored procedures.
  • 84 months of Experience designing and developing Data Conversion Strategy Plan, Data Mapping Documents, Gap Analysis.
  • 84 Months of Experience writing complex DML SQL against enterprise SQL Server and DB2 databases.
  • 84 Months of Experience working with the tools like SQL Server Management Studio, SSMS Job Scheduler, SSIS, SSRS, Export/Import, ER Studio Data Architect, QMF for Workstation, Redgate SQL Compare, TSO.
  • 72 months of experience using programming languages such as SQL, PL/SQL.
  • 60 Months of experience performance tuning complex SQL against enterprise SQL Server and DB2 databases.

Responsibilities

  • Build and maintain a data architecture based on the requirements. 
  • Design and develop Logical and Physical Data Model using ER Studio Data Architect. Create DDL scripts to establish and maintain necessary databases. 
  • Write complex SQL queries against SQL Server and DB2 databases. Create DML scripts to manipulate data.
  • Work with project managers, solution architects, business analysts, application development teams and QA to ensure the quality of DDL and DML scripts.
  • Performance tuning SQL to improve efficiency. 
  • Working with NYS Agency representatives to develop gap analysis specifications and understand Agency business rules. 
  • Provide guidance and hands-on development for developing and maintaining queries in QMF for Workstation.
  • Create clear and accurate documentation on data models, and description of data usage in the application process flow.
 
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