Hi Partners , Need SQL Server DBA Consultant With
Microsoft Certified Database Administrator (MCDBA) Please do forward 100%match Profile only *Position : SQL Server DBA * * * *Location : NYC * * * *Duration : 3+ Months * * * *JOF SERVICES * The Customer is responsible for coordinating matters of payroll policy and procedures among City oversight and line agencies, ensuring City compliance with applicable Federal, State, and City employment tax regulations, distributing and accounting for the City's payroll, managing the City's payroll bank accounts, and ensuring the integrity, accuracy, and operational effectiveness of the City's payroll systems. The Information Technology Services (ITS) division/Network Operations is seeking an experienced information technology (IT) professional to provide consulting services in the form of a Database Administrator for the LoDI FICA Refund Claim System. The LoDI application is a combination of Web, Windows Executable, Web Module, Windows Service, Bath Files, system interfaces, and other components. To date, the database consists of approximately 100 tables, 190 stored procedures with approximately 200-300 physical lines of code per stored procedure, 18 functions with approximately 50 – 100 physical lines of code each, 5 views with approximately 50-100 physical lines of code and 30 reports. The Database Administrator consultant will be responsible for analyzing business and functional requirements, planning, designing, configuring, installing, testing, troubleshooting, integrating, performance monitoring, maintaining; enhancing, security management, and support of the database system. The Database Administrator Consultant in addition to the above will be responsible for: 1. Identifying and documenting the design, functional or technical documentation of the system; 2. Creating logical data model diagrams such as entity-relationship diagrams and physical data model diagrams and 3. Implementing the data migration/conversion/transformation plan; 4. Recommending the architecture required for the system; 5. Developing and providing user support material as required; 6. Providing security protocols and documentation for the system, including passwords based on the City's requirements; 7. Providing protocols or documentations used in configuring; installing and testing of the system; 8. Developing, implement and provide protocols on capacity planning , recovering lost data; and backup and recovery plans; 9. Developing, create, implement and provide application performance plans; 10. Creating and maintaining data dictionaries by documenting data elements and their attributes; 11. Writing scripts for data base creation, manipulation, and administration; 12. Writing coding standards and procedures; *MANDATORY SKILLS/EXPERIENCE * *Note: candidates who do not have the mandatory skills will not be considered. * ♦ 4 year Computer Science degree ♦ *Microsoft Certified Database Administrator (MCDBA)* ♦ Five years experience as a SQL Server Data Base Administrator (DBA) Proficiency in: ♦ SQL Reporting Services ♦ Microsoft Project ♦ Microsoft Visio ♦ Microsoft Office (Word, Excel, PowerPoint, Access) *DESIRABLE SKILLS/EXPERIENCE * *Knowledge of City of New York Payroll Management System (PMS) data.* *SPECIAL REQUIREMENTS (use this section to identify any special instructions or requirements, e.g., Background Checks required, gaps in periods of performance, etc.) * *♦ Customer shall conduct criminal background inquiries for Consultant(s) prior to assignment. * * * *♦ The Contractor shall supply the Date of Birth (DOB) of the proposed consultant prior to assignment. * * * *♦ The Consultant shall be required to comply with the physical and LAN security policies of the agency and sign a Confidentiality/Non-Disclosure Agreement upon assignment.* * * * * Thanks & Regards, Sandy Sr Technical Recruiter Global Computer Products Inc. (GCP-Inc) Office: 703-349-2318 | Fax: 703-349-5760 | Email address :[EMAIL PROTECTED] www.gcp-inc.com| --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "ORACLE DWH DBA" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/ORACLE-DWH-DBA?hl=en -~----------~----~----~----~------~----~------~--~---
