Research Foundation for Mental Hygiene, Inc.
  • 03-Aug-2018 to 24-Aug-2018 (EST)
  • 44 Holland - Finnerty
  • Albany, NY, USA
  • $101,235 - $104,802
  • Salary
  • Full Time

Full benefits package based on percentage of full-time effort.


The Research Foundation for Mental Hygiene, Inc. is seeking qualified candidates for a full-time Application Oracle Database Administrator, Grade 30, to support statewide public mental health initiatives with the New York State Office of Mental Health Psychiatric Services and Clinical Knowledge Enhancement System (PSYCKES) team. PSYCKES is an award-winning web-based application designed to support quality improvement and clinical decision making, and is currently in use by over 400 provider agencies in New York State as well as state agencies, county governments, health homes and managed care organizations. The PSYCKES team manages several health information technologies supported statewide quality improvement projects and clinical implementation efforts, including training, technical assistance, and evaluation, and participates in requirement development and quality assurance activities.

The Application Oracle Database Administrator will assist the PSYCKES IT Team in operational and logical/application DBA support to both non-production and production Oracle database environments.

Note: this position does not provide relocation assistance. A cover letter and resume are required. 

Responsibilities Include:

  • Configures and manages database maintenance, including backups, re-orgs., and any additional required maintenance stemming from proprietary application usage.
  • Participates in a rotation of a monthly data runs on PSYCKES summarization process, using PL/SQL packages and functions.
  • Represents database administration team in operational as well as project activities.
  • Viewed as the subject matter expert for the team on the proprietary application.
  • Works on complex problems where analysis of situations or data requires an in-depth evaluation of various factors.
  • Exercises judgement within broadly defined practices and policies in selecting methods, techniques and evaluation criterion for obtaining results.

Qualifications:

  • Bachelor's Degree in Computer Science
  • 8+ years as an Oracle DBA in a Linux/Unix environment
  • PL/SQL and SQL coding, tuning and troubleshooting in 11g and 12c environments with Explain Plan analysis and optimization
  • Strong working knowledge of Oracle PL/SQL features for performance and new features launched with 11g and 12c
  • Expert in Oracle Real Application Clusters (RAC)
  • DBA level knowledge of Unix fundamentals and shell scripting
  • Expert in Resource Monitoring (CPU, memory, I/O, RAC/ASM, etc.) and using OEM.
  • Must have an understanding of AWR Reports
  • Performance Tuning; Diagnostic evaluation (ADDM, AWR, ASH)
  • Tuning (advisors, SQL tuning, indexing, partitions, etc.)

Preferred qualifications:

  • Oracle 11g/12c Certification a big plus
  • Preferable experience in a health or mental health setting with a good understanding of HIPAA data.

 

Location:        44 Holland Ave. Albany, NY 12229

Salary:            $104,802

To apply:        Please note: This position does not provide relocation assistance, and a cover letter and resume are required. Submit an application with cover letter and resume through our website http://corporate.rfmh.org Click on Employment Opportunities. Only applications submitted through the RFMH website will be accepted. 

The Research Foundation is a private not-for-profit corporation and is not an agency or instrumentality of the State of New York. Employees of the Research Foundation are not state employees, do not participate in any state retirement system, and do not receive state fringe benefits. Excellent Benefits Package. Employer/Minority/Women/Disabled/Veteran Employer. VEVRAA 41 CFR 60-300.5(a) compliant

 

Research Foundation for Mental Hygiene, Inc.
  • Apply Now

  • * Fields Are Required

    What is your full name?

    How can we contact you?

    I agree to ApplicantPro's Applicant Information Use Policy.*
  • Sign Up For Job Alerts!

  • Resources
    • Share This Page
    • Facebook Twitter LinkedIn Email
    .
    Logo Self Service Web FTask NYPI NKI IBR OASAS Site Index