Job Description 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. 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 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. 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 Education’s website at https://studentaid.gov/pslf/ . To Apply All applicants, including current City Employees, may apply by going to https://a127-jobs.nyc.gov 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 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; 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 individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.