Database Administrator (Dba)

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)

Requirements

EITHER:

(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;

OR:

(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;
OR:

(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;

OR:

(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.

SPECIAL REQUIREMENT:
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
applicant.
For immediate consideration, submit an application on or before 8/4/202

Benefits

Comprehensive benefits plan including medical, dental, and vision. Eligibility for NYS retirement plan. Paid personal, vacation and sick time. More details available upon request.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior Analyst Database Administrator

Central Hudson

Posted 2 months ago

VIEW JOBS 12/2/2022 12:00:00 AM 2023-03-02T00:00 <p>Benefits:</p><ul><li><p>Competitive compensation</p></li><li><p>Medical, dental, and vision insurance</p></li><li><p>401(k) retirement savings plan with substantial company match</p></li><li><p>Life and travel insurance</p></li><li><p>Tuition assistance</p></li><li><p>Wellness reimbursement program</p></li><li><p>Paid holidays and vacation</p></li></ul><p>What is a Senior Analyst</p><ul><li>Database Administrator?</li></ul><p>This role works within the Information Technology Technical Support group and is responsible for the performance, integrity, and security of Central Hudson's information systems' databases. This is not an application programming or helpdesk position. Title/level is commensurate with experience.</p><p>What does a Senior Analyst</p><ul><li>Database Administrator do?</li></ul><ul><li><p>Provides technical expertise in the design, implementation, and maintenance of database management systems</p></li><li><p>Designs and documents database architecture</p></li><li><p>Builds database schemas, tables, procedures, and permissions</p></li><li><p>Creates, tests, and executes data management languages</p></li><li><p>Develops database utilities and automated reporting</p></li><li><p>Analyzes and sustains capacity and performance requirements</p></li><li><p>Monitor's systems and platforms for availability</p></li><li><p>Oversees backup, clustering, mirroring, replication, and failover</p></li><li><p>Performs maintenance operations daily, weekly, and monthly on Oracle, MySQL, PostgreSQL, Microsoft SQL servers and databases, and information systems for the purpose of ensuring efficient program operations</p></li><li><p>Performs database backups and restorations and recovers corrupted databases</p></li><li><p>Evaluates and recommends new database technologies</p></li><li><p>Implements and maintains database security and encryption</p></li><li><p>Develops, manages, and tests database and information system backup and recovery plans</p></li><li><p>Develops standards and policies for data entry and ensures compliance</p></li><li><p>Support storm restoration efforts</p></li></ul><p>What does it take to be a Senior Analyst</p><ul><li>Database Administrator?</li></ul><p>Required:</p><ul><li><p>Bachelor's degree and 5 years of experience as a Database Administrator in an enterprise environment. In lieu of a bachelor's degree, candidates with an associate degree and 7 years of related experience or candidates with a high school diploma or equivalency degree and 10 years of related experience will be considered.</p></li><li><p>Ability to lead a small team of Database Administrators</p></li><li><p>Experience with MS SQL, MySQL, PostgreSQL and Oracle DBMS</p></li><li><p>Understanding of Microsoft Windows Server and Linux server including working in a Command line/Linux terminal/Powershell session</p></li><li><p>Experience with PowerShell/Linux BASH (Sh) scripting</p></li><li><p>Excellent interpersonal, verbal, and written communication skills; ability to interact effectively with individuals at all levels</p></li><li><p>Ability to quickly troubleshoot problems that may arise in work products and partner with analysts to identify and implement solutions; determine root cause and research potential solutions</p></li><li><p>Ability to understand business functionality and translate it into process flow diagrams, application requirements and system design</p></li><li><p>Must act as a role model for technical competence, helpfulness, facilitation of learning, and teamwork</p></li><li><p>Must take responsibility for personal learning, development, and time management, and set achievable and meaningful goals while managing personal targets</p></li><li><p>Must demonstrate a commitment to organizational values including performing to a high ethical standard while focusing on integrity, collaboration, and teamwork in all efforts</p></li><li><p>Must be able to work off-hours and weekends when required and be available for scheduled 24/7 callout support</p></li><li><p>Valid driver's license</p></li></ul><p>Preferred:</p><ul><li><p>A degree in Computer Information Systems, Computer Science or related field</p></li><li><p>Experience in Utilities</p></li><li><p>Hands-on experience as a DBA in an enterprise environment</p></li><li><p>One or more recognized technical certifications</p></li><li><p>Previous project management experience is advantageous</p></li><li><p>Experience in cost control, cost reductions, and return on investment justifications</p></li></ul><p>Please go to https://www.cenhud.com/employment. Click the &quot;Search Career Opportunities&quot; button. Follow the directions to submit an application and upload your resume for the desired position.</p><p>Applications sent via e-mail and US Mail will not be accepted. No phone calls or agencies, please. All replies will be held in strict confidence.</p><p>All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, or protected veteran status. Central Hudson Gas &amp; Electric Corporation takes affirmative action in support of its policy to employ and advance in employment individuals who are minorities, women, protected veterans, and individuals with disabilities.</p><p>VEVRAA FEDERAL CONTRACTOR</p><br> Central Hudson Poughkeepsie NY

Database Administrator (Dba)

Dutchess County Ocis