*SQL Server DBA* *NY*
*3 Months* *Mandatory Requirements:* * * *1. **4 year Computer Science degree * *2. **Architecture, developing & deploying n-tier .Net Web apps, coding in VB.NET, Oracle 8i/9i and PL/SQL* *3. **Microsoft Certified Database Administrator (MCDBA)* *4. **8 years experience as a SQL Server Data Base Administrator * *5. **SQL Reporting Services * *6. **Proficiency in Microsoft Project, Microsoft Visio, Microsoft Office (Word, Excel, PowerPoint, Access)* * * *Desirable Experience:* 1. Knowledge of City of *New York Payroll Management System** (PMS) data. * 2. *ASP/COM sites to ASP.NET* *Scope of Project: * The Office of Payroll Administration (OPA) 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:* - Identifying and documenting the design, functional or technical documentation of the system; - Creating logical data model diagrams such as entity-relationship diagrams and physical data model diagrams and - Implementing the data migration/conversion/transformation plan; - Recommending the architecture required for the system; - Developing and providing user support material as required; - Providing security protocols and documentation for the system, including passwords based on the City's requirements; - Providing protocols or documentations used in configuring; installing and testing of the system; - Developing, implement and provide protocols on capacity planning , recovering lost data; and backup and recovery plans; - Developing, create, implement and provide application performance plans; - Creating and maintaining data dictionaries by documenting data elements and their attributes; - Writing scripts for data base creation, manipulation, and administration; - Writing coding standards and procedures; *Thanks & Regards,* *REKHA* *PCS Technology USA Inc* *Phone: **646-688-2396 **(Direct)* *Email: [EMAIL PROTECTED] *www.pcstech.com* * * *The desire to do something is the proof of our potential to do it.* * * *Disclaimer:* *The information provided is based on prevailing terms and conditions of the company, which, are subject to change without prior notice. This electronic message transmission contains information from PCS Technology Limited is confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, beware that any disclosure, copy distribution or use of the contents of this information is prohibited. If you have received the electronic transmission in error please notify us immediately.* --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SAP-User" 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/SAP-User -~----------~----~----~----~------~----~------~--~---
