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.
Assumes ownership of MSSQL database administration activities including creating databases and data objects and managing database access.
Assists in evaluating DBA monitoring and productivity tools.
Performs complex relational database management tasks for both development and production applications including but not limited to backup and recovery and DB disaster recovery solutions.
Assists in database tuning when applicable.
Creates, tunes, and offers technical expertise in the design of complex TSQL.
Identifies, documents and tracks all database related performance problems and assisting in their resolution.
Assists in establishing and meets database related SLAs
Performs tasks to develop database and data object creation scripts and to automate data management alerts.
Collects data for Database monitoring metrics and reporting.
Assists in developing, gathering data for and reporting of metrics.
Develops database management skills and assists with the development of junior dba's and designated teammates.
Assists SQL/analytic developers in the effective use of database query language.
Works on projects of moderate to high complexity within one or more development environments.
Works on multiple systems and rdbms platforms as a project team member.
Coordinates and monitors database snapshot replication (Dell EMC Appsync)
Stays abreast of, recommends, and implements emerging database technologies.
Acquires, maintains, and exhibits current knowledge of EHR (Epic) application support.
Participates in on-call support.
Work is typically performed in an office environment. Accountable for satisfying all job specific obligations and complying with all organization policies and procedures. The specific statements in this profile are not intended to be all-inclusive. They represent typical elements considered necessary to successfully perform the job.
*Relevant experience may be a combination of related work experience and degree obtained (Associate's Degree = 2 years; Bachelor's Degree = 4 years).
Work Location: Danville, Pennsylvania
Standard work hours: 7am-4pm On-call, weekends, Holidays based on project due dates.
The successful candidate will have opportunity to work with this fast paced team in an environment of continuous learning to gain many marketable skills. (database focused)
Required to attend occasional conferences for training as it relates to the job.
High School Diploma or Equivalent (GED)- (Required)
Minimum of 9 years-Relevant experience* (Required)
Certification(s) and License(s)
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. SAFETY: We provide a safe environment for our patients and members and 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. 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.
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.
At Geisinger, our innovative ideas are inspired by the communities we serve – like our Fresh FoodFarmacy, 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 sequencingprograms, 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.