Dutchess County Ocis Poughkeepsie , NY 12603
Posted 3 weeks ago
This is a provisional competitive position in the Dutchess County Office of Central and Information Services. This is a highly technical position that is responsible for installing, configuring, maintaining and securing all County database systems. The incumbent follows best practices to produce secure solutions and works on a wide variety of systems, including disaster recovery and backup. The incumbent also investigates new industry developments, such as system productivity tools, design and programming methodologies, documentation approaches, and makes recommendations for current and projected use. Additionally, this position will assist developers with proper database designs, configurations, and standards. It is the responsibility of this position to expand the use of existing database systems to improve security and automation. This position will educate and assist the members of the Office of Central and Information Services (OCIS) Database Team and use them as support for performing routine tasks. The work is performed under the general direction of a higher-level employee with wide leeway in conducting project assignments. Supervision is not a normal function of the position.
TYPICAL WORK ACTIVITIES:
Installs, configures, and regularly tests database management and operating systems software by planning and implementing upgrades, ensure optimal functionality and performance; develops, maintains, and manages a service program for all database infrastructures/systems, backups, and related platforms; configures database management systems for maximum up-time, including implementing high availability (HA) solutions; implements and enforces database security based upon regulations, industry best practices and County policies; reports on the utilization of databases and related software; reviews database designs and makes recommendations for changes to improve performance, security and data integrity; develops database documentation, including data standards, procedures and definitions; evaluates, and tests hardware and software, makes recommendations as to its appropriateness on a variety of different platforms, and performs any necessary database related scripting; researches and responds to clients needs regarding database functionality; troubleshoot failures and make corrections to ensure business continuity; prepares reports, correspondence and other documents; participates in disaster recovery exercise planning and execution.
Applicants must apply online at https://www.co.dutchess.ny.us/CivilServiceInformat...
SALARY: $67,408 (2021)
(A) Bachelors degree in Computer Science, Information Systems, Information Technology, or a closely related field AND two (2) years of full-time work experience which primarily involved server administration, database system administration, and database design;
(B) Associates degree in Computer Science, Information Systems, Information Technology,or a closely related field AND four (4) years of full-time work experience which primarily involved server administration, database system administration, and database design;
(C) Graduation from high school or possession of a high school equivalency diploma and six (6) years of full-time work experience which primarily involved server administration, database system administration, and database design;
(D)An equivalent combination of training and experience as indicated in (A), (B) and (C) above.
NOTE: Certification as a Microsoft Certified Solutions Associate (MCSA): SQL 2016 Database Administration,
MCSA: SQL 2016 Database Development, or Microsoft Certified Solutions Expert (MCSE): Data Management and
Analytics may be substituted for one (1) year of work experience as defined above. Equivalent certifications for any
currently supported version of Microsoft SQL Server may be accepted in place of those listed.
NOTE: Your degree or college credit must have been awarded by a college or university accredited by a regional, national, or specialized agency recognized as an accrediting agency by the U.S. Department of Education/U.S. Secretary of Education.
Possession of a valid Driver License to operate a motor vehicle in New York State at time of application and to
maintain the position.
FINGERPRINTING: A fingerprint supported background investigation is required before an appointment is
made to some positions. Pursuant to New York State Executive Law, the Division of Criminal Justice Services
requires that a fee accompany each such request for a search. It is due once a job offer is made and accepted by the
For immediate consideration, submit an application on or before 8/4/202
Comprehensive benefits plan including medical, dental, and vision. Eligibility for NYS retirement plan. Paid personal, vacation and sick time. More details available upon request.
Dutchess County Ocis