Performs and is responsible for the development and maintenance of rdbms platforms and database objects and with data access control supporting OLTP or analytic software applications on at least one major rdbms platform. Is responsible for database performance monitoring and tuning activities.
MAJOR DUTIES AND RESPONSIBILITIES:
*1. Assumes sole ownership of database administration activities including creating database's and data objects and managing database access.
*2. Assists in evaluating DBA monitoring and productivity tools.
*3. Performs complex relational database management tasks for both development and production applications. Assists in database tuning when applicable.
*4. Identifies, documents and tracks all database related performance problems assisting in their resolution.
*5. Performs tasks to develop database and data object creation scripts and to automate data management alerts.
*6. Collects data for Database monitoring metrics and reporting.
*7. Assists in developing, gathering data for and reporting of metrics.
*8. Develops database management skills and assists with the development of junior dba's.
*9. Works on projects of moderate to high complexity within one or more development environments. Works on multiple systems/rdbms platforms as a project team member.
10. Consistently performs tasks with minimal supervision and re-work.
11. Performs other duties as assigned or required.
*Denotes essential functions
COMPETENCIES AND SKILLS:
Demonstrates working knowledge of at least one major rdbms technology (excluding Access).
Demonstrates the ability to provide database production support of critical systems including backup and recovery, database object creation and administration, performance tuning of queries and data structures.
Demonstrates excellent verbal and written communication skills along with good administrative and facilitation skills. Must be able to communicate difficult/sensitive information in a diplomatic and tactful way.
Demonstrates solid knowledge of at least one business area or system/rdbms
Healthcare payer and Facets experience preferred.
EDUCATION AND EXPERIENCE:
Bachelor's degree in Computer Science, Information Systems, or related field required. Masters degree preferred. Minimum eight years’ experience with networking and I.S. infrastructure which three of those years must be database administration.
Associate's degree in Computer Science, Information Systems, or related field required. Minimum eleven years’ experience with networking and I.S. infrastructure which six of those years must be database administration.
In lieu of Degree, minimum of fourteen year’s IT experience with six year’s experience performing database administration-related activities is required.
Exposure to the full life-cycle of analytic or operational data management development experience required.
Database-related certifications and training highly desired, whether vendor-specific or nationally recognized programs such as Oracle OCP, Microsoft MCDBA or Teradata v12 or higher.
If a suitably experienced candidate cannot be found, applicants who meet the basic qualifications but possess fewer years of experience will be considered for hire at a lower level.Salary would commensurate with experience.
WORKING CONDITIONS/PHYSICAL DEMANDS:
Work is typically performed in an office environment with occasional travel to different buildings. Mostly sedentary work interacting with computers and people. Requires ability to perform visual inspection and lifting less than 10 pounds.
OUR PURPOSE & VALUES: Everything we do is about caring for our patients, our members, our students, our Geisinger family and our communities. KINDNESS: We strive to treat everyone as we would hope to be treated ourselves. EXCELLENCE: We treasure colleagues who humbly strive for excellence. LEARNING: We share our knowledge with the best and brightest to better prepare the caregivers for tomorrow. INNOVATION: We constantly seek new and better ways to care for our patients, our members, our community, and the nation.
ABOUT GEISINGER: Geisinger is a physician-led health system comprised of approximately 30,000 employees, including nearly 1,600 employed physicians, 13 hospital campuses, two research centers, and a 583,000-member health plan Geisinger is nationally recognized for innovative practices and quality care. Geisinger serves more than 3 million people in central, south-central and northeast Pennsylvania and also in southern New Jersey with the addition of National Malcolm Baldridge Award recipient AtlantiCare, A member of Geisinger. In 2017, the Geisinger Commonwealth School of Medicine became the newest member of the Geisinger Family.
We offer healthcare benefits for full time and part time positions from day one, including vision, dental and domestic partners.* Perhaps just as important, from senior management on down, we encourage an atmosphere of collaboration, cooperation and collegiality. For more information, visit www.geisinger.org, or connect with us on Facebook, Instagram, LinkedIn and Twitter.
** Does not qualify for J-1 waiver. We are an Affirmative Action, Equal Opportunity Employer Women and Minorities are Encouraged to Apply. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of disability or their protected veteran status.
*Domestic partner benefits not applicable at Geisinger Holy Spirit.
At Geisinger, our innovative ideas are inspired by the communities we serve – like our Fresh Food
Farmacy, a program that delivers life-saving healthy alternatives to patients with diabetes. With additional tools like our MyCode Community Health Initiative, one of the first health system genome sequencing
programs, and our new asthma app suite that we developed in partnership with AstraZeneca, it’s no wonder we’re ranked one of the Top 5 Most Innovative Healthcare Systems by Becker's Hospital Review. We continually work towards continuous improvement in a culture where everyone has a voice and firmly believe that better begins with all of us.
Founded more than 100 years ago, Geisinger serves more than three million residents throughout central, south-central and northeastern Pennsylvania and southern New Jersey. Our physician-led system is comprised of 30,000 employees, including 1,600 employed physicians, and consists of 13 hospital campuses, the Geisinger Health Plan, Geisinger Commonwealth School of Medicine and two research centers.
What you do at Geisinger shapes the future of health and improves lives – for our patients, communities, and you.