Delan Associates is looking for ITS professionals Database Developer for our client located in the New York City area.

U.S. Citizenship is required.

Location: Must live in the New York City area

Contract Period of Performance : 1-3 years long (1 year with (two) additional years to renew)

Overview:

The company ITS is a full-service provider of information technology services. ITS provides the company with centralized network services that will encompass, but will not be limited to, systems development / design, security analysis, information processing, telecommunications and data center support services, data communications infrastructure, platform hosting, an e-mail system, internet and intranet access data security and exchange, desktop/client support, help desk, project management, applications development and quality assurance.

The company's hardware and software platforms include, but are not limited to, IBM and UNISYS mainframe, Microsoft Windows client servers and SUN/UNIX.

ITS requires assignments to be completed within a specific time frame provided by ITS during normal work hours. The consultants assigned to these positions may be asked to work off-hours, weekends, or holidays. ITS estimates the various assignments associated with a position will be worked simultaneously and will be required over the life of the contract.

PROJECT NAME: IT Development and Management

HRA JOB TITLE: Database Developer

PROJECT DESCRIPTION: COMPANY has a constant increased need for the provision of full systems life cycle applications development on various computer platforms, including a variety of client eligibility and recertification systems, employment/work engagement services, claims systems, etc., that are critical to the operation and functioning of COMPANY programs, requiring periodic refinements to maintain the applications at optimum service levels. Having a project portfolio which properly reflects the user's business needs and COMPANY' workload is crucial. Therefore, there is a need for IT consulting resources for the expanding responsibilities at COMPANY.

Tasks & Duties

• Develop Database documentation
• Create and maintain detailed documentation of database designs, configurations, procedures, and best practices.
• Ensure documentation is up-to-date and accessible to relevant stakeholders.
• Ensure data quality and consistency across various systems.
• Perform Database Development
• Develop and maintain complex database systems ensuring data integrity, security, and performance.
• Design scalable and efficient database schemas based on application requirements and industry best practices.
• Develop and maintain SSIS Packages, Stored Procedures, Functions, Triggers, SQL statements in MS SQL Server.
• Assists other developers in the team with database issues.
• Develop and maintain ETL (Extract, Transform, Load) processes to integrate data from multiple sources.
• Lead and manage database development projects, ensuring timely delivery and adherence to

Required Skills

• Minimum 4 Years Experience with Development and Maintenance of SSIS Packages, Stored Procedures, Functions, Triggers, SQL statements in MS SQL Server.
• Minimum 4 Years Experience with Performance Tuning including tuning/optimizing SQL, T-SQL code.
• Minimum 4 Years Experience Database design and data migration.
• Minimum 4 Years Experience with technical and user documentation, database dictionary.