Company: | NYC Dept. of Health |
Job Category: | IT/Software Development |
Location: | New York, NY |
Job Title: | Database Administrator- 0022 |
Website: | http://www.nyc.gov/ |
The position will be located in the Division of Informatics and Information Technology (DIIT). Under the supervision of the Director of Application and System Development, with broad scope for independent initiative and judgment, the Database Administrator performs tasks related to the development, implementation, maintenance, procedures, and functions using SQL Server 2000/2005/2008.
As the Database Administrator, your duties will include:
– Developing, designing, implementing, enhancing, maintaining and analyzing database systems, queries, and procedures.
– Review and develop detailed system specifications and modify existing systems to accommodate changing business needs
– Administer all databases housed by the Division of Informatics and Information Technology, ensure their security and be responsible for the timeliness and effectiveness of all backups.
– Work with Business Reengineering and Quality Assurance and Control groups to ensure complete satisfaction of software by end users and DIIT.
– Research and recommend current and new technologies for use by DIIT staff.
– Assures that confidential documents are properly handled.
– Participate in agency wide required activities for emergency preparedness. Follow up on emergency or emergency preparedness as necessary promptly and accurately.
The qualified candidate will possess:
1. The professional/vendor certification(s) in database administration that is required Vendor Certification: Certified Database Administrator (MCDBA) or Oracle Certified Professional (OCP)for the position to be filled.
2. A Baccalaureate degree from an accredited college, and two years of satisfactory full-time (not classroom based) experience in database administration planning, design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, enhancement, and security management; or
3. A four-year High School diploma or its educational equivalent and six years of satisfactory full-time (not classroom based) information technology experience of which at least 2 years must have been as described in (1) above; or
4. A Masters degree in computer science or a related field from an accredited college may substitute for one year of experience. However, all candidates must have at least one year of satisfactory full-time (not classroom based) information technology experience as described in above, and
5. Minimum 3 years experience hands-on database administration using SQL Server 2000/2005/2008.
6. Knowledge with table and stored procedure design, performance tuning, DTS.
7. Experience with data integrity, data retention, backups, and disaster planning.
8. Excellent verbal and written communication skills and the ability to work independently and collaboratively.
9. Excellent analytical, organizational, and interpersonal skills.
10. The ability to analyze and understand complex business processes.
Note:
In addition to meeting the minimum Qualification Requirements: Incumbents may be required to update existing and/or obtain additional professional industry-standard certification(s) for current and future technical environment(s) in which they may be assigned to work, as determined by the employing agency.
NYC Residency Is Required.