About the position
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. DOI's 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 DOI's 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 on-time 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 DOI's 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.
Responsibilities
- Support DOI's Case Management System (CMS), Microsoft SharePoint 365, OpenText Content Management System, and all applications built internally.
- Provide overall technical design, enhancements and conduct maintenance on all systems supported by the development team.
- Establish business and technical specifications for the creation of the CMS and other system architecture design.
- Manage the overall scoping, planning, execution, and on-time delivery of enhancements, defects resolution, and other project deliverables.
- Create and maintain project plan and schedule, project timelines, budget and forecast documents.
- Identify and resolve project and technical issues and risks.
- Develop launch/release plans.
- Assess the impact of change requests on schedule or budget.
- Coordinate and facilitate meetings with Business Units and IT staff.
- Coordinate with the DOI's IT Network Infrastructure team to ensure 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.
Requirements
- A four-year high school diploma or its educational equivalent approved by a State's Department of Education or a recognized accrediting organization and four years of satisfactory full-time 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.
- A baccalaureate degree from an accredited college or university.
- Education and/or experience equivalent to the above.
Nice-to-haves
- 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.
- Experience with Agile and Lean software development practices.
- Knowledge of networking and TCP/IP principles.
- Strong analytical and problem-solving 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.
Benefits
- Eligibility for federal loan forgiveness programs and state repayment assistance programs.
