Database Administrator System Engineer

The New York City Department of Investigation (DOI) is one of the oldest law enforcement agencies in the country with a mission of combating municipal corruption. It serves the people of New York City by acting as an independent and nonpartisan watchdog for New York City government City agencies and City employees vendors with City contracts individuals and entities that receive City funds.

DOIs Information Technology Unit is looking for a Database Administrator/System Engineer who will report to the Director of Development and the Chief of Infrastructure and Network Officer. The successful candidate will support DOIs Case Management System (CMS) Microsoft SharePoint 365 OpenText Content Management System and all applications built internally. The candidate will provide overall technical design enhancements and conduct maintenance on all systems support by the development team. They will help establish business and technical specifications for advice on creation of the CMS and other system architecture design. The candidate will be responsible for overseeing/delivering the following: Responsible for the direction and output of the CMS system/project implementation; manage the overall scoping planning execution and ontime delivery of any enhancements defects resolution and other project deliverables; work with DOI IT team to create and maintain project plan and schedule project timelines budget and forecast documents project and technical issue and risk identification and resolution develop launch/release plans; assess the impact of any change requests that may affect the schedule or the budget update the project baseline; coordinate and facilitate meetings with the Business Units and IT staff; coordinate with the DOIs IT Network Infrastructure team to ensure that sufficient infrastructure resources are supplied and planned for the project; coordinate the scheduling and transition of all software and database objects from design to test and from test to production; etc.


Preferred Skills

A minimum of 5 years of Database Administration; strong knowledge of Linux and Linux OS scripting; Experience in installing maintaining and supporting Microsoft SQL Server (2019 and above); Oracle RDBMS 11g/12c/19c installation and management experience; Oracle RAC 11g/12c/19c installation and troubleshooting experience; Knowledge of how to backup and restore MSSQL and Oracle databases; Knowledge of Database securities as it relates to Users Tables etc; Knowledge of Oracle BI/Analytics Reporting and installation. Knowledge of PowerShell scripting is a plus; Experience with Agile and Lean software development practices; Knowledge of networking and TCP/IP principles; Strong analytical and problemsolving skills; Excellent written and verbal communication skills. Critical/Analytic thinker able to identify escalate and resolve issues on a timely basis; Demonstrated ability to work independently and prioritize competing demands. Demonstrated ability to adjust to unexpected or changing conditions. Drive innovation and integration of new technologies into projects and activities in the software application design. Knowledge of Java/J2EE technologies core java JSP Servlets HTML Spring MVC and XML; Knowledge of ASP.NET MVC design patterns and best practices.

Additional Information

As a prospective employee of the City of New York you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information please visit the U.S. Department of Educations website at .

To Apply

All applicants including current City Employees may apply by going to and search for the specific Job ID # 686728.

Please do not email mail or fax your resume to DOI directly. Submissions of resumes do not guarantee an interview. Due to the high volume of resumes DOI receives for positions only selected candidates will be contacted.

Appointments are subject to Office of Management & Budget approval for budgeted headcount.

Residency Requirement

New York City residency is generally required within 90 days of appointment; however New York City residency is NOT required for this position. Candidates may reside in Nassau Suffolk Putnam Westchester Rockland or Orange County. To determine if the residency requirement applies to you please discuss with the agency representative at the time of interview.

Qualifications :

1. A fouryear high school diploma or its educational equivalent approved by a States Department of Education or a recognized accrediting organization and four years of satisfactory fulltime experience in an industrial or governmental agency in the field of investigation auditing law enforcement security inspections or in a major operational area of the agency in which the appointment is to be made; or

2.A baccalaureate degree from an accredited college or university; or

3. Education and/or experience equivalent to 1 or 2 above.

Additional Information :

The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic including but not limited to an individuals sex race color ethnicity national origin age religion disability sexual orientation veteran status gender identity or pregnancy.

Remote Work :

No

Employment Type :

Fulltime