Friday, March 23, 2007

Database Engineer (Job #6991) in New York, NY

Friday, March 23, 2007
SmartSource is a 10 year old IT staffing company that specializes in IT staff augmentation services. Headquartered in the western suburbs of Chicago, offering nationwide coverage SmartSource provides a wide variety of IT resources on a contract, contract to hire, perm placement or project basis . We are currently seeking a backup Field Technician with some Technical background for the following direct hire or temp to perm position: Pay: Negotiable Duration: Permanent Start Date: Hiring process starting 4/4/07 1 Specialist lll/Database Engineer The New York City Department of Education (NYCDoE) requires the services of 1 consultant to perform database maintenance functions in a SQL 2000 and Windows 2003 environment. Under the direction of NYC Department of Education management, major responsibilities include analysis, design, and development for maintenance and enhancements of various SQL Server Databases for the Department of Instructional and Informational Technology (DIIT). In addition, the consultant(s) may have prime responsibility for the operation and management of the SQL Servers. These activities will be related to, but not limited to the following areas: · Architect, Design, Install, configure, Support, troubleshoot and maintain MS SQL 2000 and 7.O Enterprise Databases in a Storage Area Network and clustered Server environment · Install, configure, troubleshoot & support IIS application servers. · Install, configure, troubleshoot and support MS Win 2K Advanced Server Operating system software environments. · Plan, configure and conduct daily/weekly database backups and periodic recovery. · Monitor SQL server activity on a proactive basis; make adjustments as necessary to assure tuned performance. Make load balancing adjustments as necessary. · Administer user accounts, monitor security, control and authenticate user certificates, and support user authentication & passwords across multiple environments - Development, QA, Staging, and Production. · Maintain error and system maintenance logs and issue reports on a regular basis. · Administer replication and log shipping for very large databases · Perform, Monitor, Troubleshoot Daily Complex ETL (Extract, Transform, and Load) using FTP, Command Scripts, Task Scheduler, BCP, and DTSRUN. · Architect, Design, Install, configure, Support, troubleshoot and maintain BizTalk and XML based complex ETL for Daily Data Refresh of a large amount of Data · Application development support for Query Optimization, Stored Procedures, Triggers, Indexes etc. for multiple Development groups These activities will encompass all project life cycle phases including production support (24/7) and documentation of all tasks in accordance with Department of Education standards. Candidate must have a minimum of five years of experience as a Microsoft SQL Server Database Administrator supporting multiple enterprise applications. Candidate must have experience maintaining and supporting line of business Microsoft SQL Server databases in a large enterprise. Knowledge: · Strong knowledge of MS SQL 2000 and 7.0 and preferably Oracle RDBMS 8.0 · Solid working knowledge and experience with IIS. · Solid working knowledge of MS Windows 2000/2003 Advanced Server and/or Data Center Server. · Good knowledge of Federated Databases, Log Shipping, Remote/Linked Server configuration, Data modeling using Visio, ER Studio etc. · Firm knowledge of BizTalk Server and XML technology · Firm knowledge of Windows 2K Active Directory. · Strong knowledge of Browsers and applet viewers Netscape & Internet Explorer · Excellent oral & written communication skills. · Knowledge of MQ Series desirable Attributes: Candidate must be personable, determined, meticulous, cooperative, flexible, punctual, Team Player, with Strong Leadership Skills. Schedule: Ability to be available as needed for on-call 7X24 shift rotations, overtime and off hours support. Education: Undergraduate degree in Information Systems, Computer Science or Computer Engineering. Masters Degree preferred. Certifications: MCDBA mandatory. MCSE preferred To Apply to this job go to http://www.GadBall.com or click here