Description
Schedule :Monday - Friday (40 hrs/wk)8:00 AM - 5:00 PM
Department: IT Software Operations - 212
Primary Purpose :
The IT Database Administrator I is responsible for system availability, disaster recovery, performance, version upgrades, software patch installation, and optimization of database infrastructure. Has knowledge of database infrastructure and schema design and supports the implementation of database standards and practices, and Operates under the direction of senior database staff while adhering to department, corporate, and industry standards and practices. Assists in the planning and implementation of improvements to existing database configuration, security, and architecture. Ensures that reliable database backups are performed. Executes database schema change releases in various environments.
About ARUP :
ARUP Laboratories is a national clinical and anatomic pathology reference laboratory and an enterprise of the University of Utah and its Department of Pathology. Based in Salt Lake City, Utah.
ARUP proudly hires top talent to create a work environment of diversity, professional growth and continuous development. Our workforce is committed to the important service we provide to over one million patients each month. We always strive for excellence and have a strong desire to have involvement with the advances in medicine and the role laboratory services plays within each patient’s life. We never forget that there is a patient behind every specimen we receive.
We are looking for individuals who want to contribute to ARUP's culture of accountability, integrity, service, and excellence. Consider joining our dynamic team.
Essential Functions :
Assist in the planning and implementation of improvements to existing database configuration, security, and architecture.
Ensure that reliable database backups are performed.
Execute database schema change releases in various environments.
Administer and maintain reporting and business intelligence infrastructure.
Participate in the design technology infrastructure to support performance, availability, and architecture requirements in collaboration with other IT resources.
Develop and maintain custom code and scripts to support database management requirements.
Tune performance of queries, database objects, and database configurations.
Perform database system maintenance and upgrades.
Attend database related design reviews.
Perform system access privilege grants and maintenance.
Perform audits of database security privileges.
Assist in consulting for development projects.
Participate in a collaborative team environment functioning within the SCRUM (agile) methodology.
Support efforts to evaluate, select, and implement database management tools and components.
Demonstrate attention to detail and adherence to policy and procedure.
Ensure that database practices comply with department and corporate standards and industry best practices.
Support corporate compliance with regulatory requirements such as HIPAA.
Demonstrate excellent customer service skills.
Serve in the 24/7 on-call rotation.
Other duties as assigned.
Physical and Other Requirements :
Stooping: Bending body downward and forward by bending spine at the waist.
Reaching: Extending hand(s) and arm(s) in any direction.
Mobility: The person in this position needs to occasionally move between work sites and inside the office to access file cabinets, office machinery, etc.
Communicate: Frequently communicate with others. ARUP Policies and Procedures: To conduct self in compliance with all ARUP Policies and Procedures.
Sedentary Work: Exerting up to 10 pounds of force occasionally and/or negligible amount of force frequently or cons+I57man body.
Fine Motor Control: Picking, pinching, typing or otherwise working, primarily with fingers rather than with the whole hand as in handling.
On Call: Ability to respond to emergencies after normal working hours and on the weekends.
Qualifications
Education
Required
- High School Diploma or Equivalent or better
Preferred
Licenses & Certifications
Preferred
Experience
Required
With a high school diploma: four years of paid, relevant IT work experience OR With an Associate's degree: no additional experience
Four (4) years in a database related job role
Two (2) years of experience with MS SQL Server
One (1) year of SQL query creation
One (1) year using Microsoft Windows Systems and Network services
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)