Skip to content

 

Brooklyn, New York - USD Full Time Posted: Friday, 15 March 2019
 
 
Summary of Details Due Date PM Number of Positions 1 Maximum Rate Client Interview Format In Person or Skype Expected Billable HoursWeek Full Time - 35 HoursWeek If no rate is entered please submit at your most competitive rate Resume- Please make sure the candidate's full legal name is listed on the resume, minimum first and last name, in addition to contact information (phone and email) Degree Certificate- Please include a copy of any degrees mentioned on the candidate's resume Work Authorization Document (eg, H-1B, Green Card, or Employment Authorization Card) if candidate is not a US Citizen Rate- Please include a confirmed, all-inclusive rate References- Please provide three references including name and contact phone number Position Information Functional Title Sr. SQL Database Developer Work Location 65 Court Street, Brooklyn, NY Anticipated Start Date Expected Project Duration 3640 (24 Months) Project Name SESIS - Provider Assignment- Project Description Under general supervision with considerable latitude for independent initiative and judgment the individual is responsible for the maintenance, design, installation and enhancement of Computer Application Systems, Database Management Systems and related software functions.. Position Description Code Provider Assignment modules, screens, interfaces deploy new PA database schema to support the new SESIS 16.x release (includes enhanced ODS SQL Server Database) modifications to support changes to database column definitions, and data values. Develop and code new Contract Management functionality to allow movement of students from one vendor to another whenever a Vendor's contract is terminatedcanceled or if new Vendor Contracts are awarded. Complete delta logic for all types of data changes between SESIS and PA. Mandatory Qualifications At least 8 years of Full time experience as a SQL Database Developer. A baccalaureate degree from an accredited college. Experience with Database Administration for MSSQL Server. Experience in troubleshooting and resolving database problems. Experience with SQL Migration across versions. Experience with backups, restores and recovery models. Knowledge of indexes, index management, and statistics. Experience working with Windows server, including Active Directory and proper disk configurations. Experience with creating SSIS package. Desired Qualifications Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools. Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server. Experience in implementing operational automation using scripts. Good communication and documentation skills. Working experience with SQL 2012 is a plus. Familiarity with data warehousing concepts a plus. Familiarity with SSAS is a plus. Special Requirements Fingerprinting State education laws and DOE policy and practice mandate the taking of fingerprints as a prerequisite for licensure andor employment. Particular attention is given to fingerprint results that reveal a criminal history. Currently, this is the process httpschools.nyc.govOfficesDHRFingerprinting+Employee+IDs+and+Smart+Cards.htm httpschools.nyc.govOfficesDHRFingerprinting+Employee+IDs+and+Smart+Cards.htm Applicants must be fingerprinted to become a Consultant or obtain employment with the New York City Department of Education, whether they are hired as individuals or as part of a project. Cleared fingerprints do not guarantee employment with DOE or with a vendor providing services to the DOE. Cleared fingerprint results and eligibility for employment may change depending on the outcome of any investigations, as well as any arrests or changes in your DOE employment status that may have occurred after the date you were printed. The HR Connect Walk-In Center and the Office of Personnel Investigation (OPI) are responsible for screening all new staff hired by the New York City Department of Education (DOE) to ensure the safety and well-being of students and staff. Consultants cannot go to the HR Connect Walk-in Center for fingerprinting unless they have completed all of their required forms online. See section on "PETS" below for further details. No walk-ins will be accepted for fingerprinting. In order to be fingerprinted, the Applicant must have Proper identification - All applicants must provide a valid government-issued photo ID to be fingerprinted. Payment for processing fee - The cost for fingerprinting at the HR-Connect Walk-In Center is 115 (subject to change) and must be covered by the Contractor. The DOE is not responsible for Fingerprinting fees. Fingerprinting fees are also non-refundable. Acceptable forms of payment are money orders or personal checks made payable to DOEDHRT.

Brooklyn, New York, United States of America
IT
USD
Peer Consulting Resources
Peer Consulting Resources
JS6874_0025401AA387B4FC12B57F7847662471/668735738
3/15/2019 3:12:45 AM

We strongly recommend that you should never provide your bank account details to an advertiser during the job application process. Should you receive a request of this nature please contact support giving the advertiser's name and job reference.

Other jobs like this

See more