JDXpert Job Viewer

JDXpert Jobs

HRTMS Job Description Management

IT Ops Administrator

J o b D e s c r i p t i o n

Job Profile Title:	IT Ops Administrator
Job Code:	19770
Profile Title:	19770 IT Ops Administrator
Grade / Band:	IC3
FLSA Status:	Exempt
The primary responsibility of the Database Administrator is to build and maintain all database systems. This position reports to Manager, Database Operations in the Information Management Department and coordinates with other Information Technology departments and vendors. This position also assists during production incidents and resolution, which can occur anytime 24x7.

Principal Duties & Responsibilities
Installs, upgrades, and maintains database systems. Supports system storage for the databases and applications
Installs and maintains database server, replication, and client environments. Develops, reviews, and tunes scripts, triggers, and store procedures. Provides production and project support
Assists with production incidents and resolutions, including root cause analysis and recommendations. Implements database reporting and continuous improvement
Executes performance monitoring, reporting, and tuning of database systems. Supports and maintains back‐ups and recovery process and procedures
Ensures audit trails are maintained through the use of manual or automated systems. Follow Senior and Lead DBA instructions and best practices
Assists in the design of database structures, packages, and procedures. Manages security access and controls

Required for All Jobs
Performs other job-related duties as requested
Proof of eligibility to work in the United States

Education
Education Level	Education Details	Required/ Preferred
Bachelor's Degree	Computer Science, Engineering or related field or experience	Required

Work Experience
Experience	Experience Details	Required/ Preferred
3+ Years of Prior Relevant Experience	Database administration experience in a commercial environment, or prior relevant experience	Required

Additional Requirements
Details	Required/ Preferred
Experience in Microsoft SQL Server, Oracle, or Teradata	Preferred
Experience in Microsoft SQL Server Management Studio 2005/2008/2012/2014/2016 and above, Oracle 11g/12c, or Teradata Studio	Preferred
Experience in Relational database concepts	Preferred
Experience with the following: Golden Gate Software; MS Clustering or Oracle RAC; SAN Tech; AD Security; Data Warehousing / Data Replication; Microsoft SSIS; Microsoft Terminal	Preferred
Experience in Microsoft Windows Server 2003/2008/2012 and above, UNIX, Oracle Exadata, or AIX	Preferred
Experience in data storage concepts	Preferred
Experience in backup and recovery of database systems	Preferred

Knowledge, Skills and Abilities
KSAs
Excellent customer service skills
Ability to effectively communicate in English, in both oral and written forms
Ability to work well under pressure. Strong problem trouble‐shooting skills
Ability and knowledge with relational database and data storage concepts
Knowledge of Microsoft SQL Server, Oracle, or Teradata
Knowledge of Microsoft Transact‐SQL, PL/SQL, or Teradata SQL
Knowledge of Microsoft SQL Server Management Studio 2012/2014/2016 and above, Oracle 11g/12c, or Teradata Studio
Knowledge of Microsoft Windows Server 2012 and above, UNIX, Oracle Exadata, or AIX

Physical Requirements
A thorough completion of this section is needed for compliance with legal standards such as the Americans with Disabilities Act. The physical requirements described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.
Physical Requirement	N/A	Rarely	Occasionally	Frequently	Constantly	Weight/ w.p.m.
Balancing			X
Bending			X
Carrying 10 pounds			X
Clear speech - simple				X
Clear speech - complex				X
Climbing	X
Distant vision				X
Driving	X
Flexibility - upper body			X
Flexibility - lower body			X
Hearing/Listening				X
Kneeling			X
Lifting 10 pounds			X
Near vision				X
Normal vision				X
Pushing/Pulling			X
Reaching			X
Sitting				X
Standing			X
Typing				X
Walking				X

Work Environment
While performing the duties of this job, the associate is required to work within the selected work environments.
Work Environment	N/A	Rarely	Occasionally	Frequently	Constantly
Communication - verbal				X
Communication - written				X
Confined area				X
Contacts - works alone				X
Contacts - works around others				X
Contacts - works with others				X
Exposure to dust / dirt			X
Exposure to fumes / odors			X
Extreme cold		X
Extreme heat		X
Fast pace				X
Hazardous conditions - chemicals	X
Hazardous conditions - high structures	X
Hazardous conditions - high voltage	X
Indoors				X
Noise levels - low to moderate				X
Noise levels - high			X
Office conditions				X
Outdoors			X
Restricted area		X
Shifts	X
Smoke			X
Travel		X
Wet/Humid		X

Mental Requirements
While performing the duties of this job, the associate is required to work within the selected mental requirements.
Mental Requirement	N/A	Rarely	Occasionally	Frequently	Constantly
Analytical				X
Clerical				X
Comprehension				X
Crisis incidents		X
Customer service				X
Decision making				X
High pressure				X
Judgment				X
Long hours			X
Math skills - advance			X
Math skills - basic				X
Organization				X
Reading - simple				X
Reading - complex				X
Repetition				X
Tight deadlines				X
Writing - simple				X
Writing - complex				X