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
10826 Albany, NY 12233 SQL Programmer: MS SQL Server Management Studio, Data Modeling, Crystal Reports/SSRS DOE Contract OPEN
If you are unable to click on links above to submit resume, you may email your resume to
jobs@iit-inc.com    

Subject=IIT Career Site/Resume for JobID=10826 (SQL Programmer: MS SQL Server Management Studio, Data Modeling, Crystal Reports/SSRS) in Albany NY 12233 (SJU)

Estimated Length: 24 months Full-Time 8 am – 4:30 pm   All work to be on-site, no telecommuting.

Mandatory Requirements

Senior 60-84 months

Desired Requirements

  • Minimum 60 months experience in designing advanced SQL queries, stored procedures, triggers, scripts, cursors and views
  • Minimum 60 months experience in MS SQL Server Management Studio
  • Minimum 60 months of experience in data modelling and designing data architecture 
  • Minimum 48 months of experience in SQL code tuning, consolidating views and tracking database performance metrics
  • Minimum 48 months of experience in designing reports using either Crystal Reports or Business Objects XI or SSRS
  • Minimum 48 months of experience in designing and maintaining data dictionary and system documentation

Responsibilities

  • Building complex SQL queries, stored procedures, functions, views and reports.
  • Understand the business needs effectively and work with the ColdFusion developers to design and draft modern and effective database architectures.
  • Analyze functional requirements to perform ad-hoc Extract, Transform and Load (ETL) processes involving data analysis, data manipulation and setting up SSIS packages.
  • Review performance logs to track and analyze production issues and optimize stored procedures for improved database responsiveness.
  • Work closely with the database management team to establish database user provisioning and access management for the core applications.
  • Participate in unit and regression testing by assisting business analysis team to mine and translate complex dataset.
  • Work with data modelling team to draft/maintain system data model and data dictionary. Establish standards for system documentation and advise other team members.  
 
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