|
Commonwealth of Pennsylvania |
|
|
POSITION DESCRIPTION FOR JOB POSTING |
|
|
Position Number: 00297234 |
Description Activated On: 7/1/2020 11:46:42 AM |
Position Purpose: Describe the primary purpose of this position and how it contributes to the organizations objectives. Example: Provides clerical and office support within the Division to ensure its operations are conducted efficiently and effectively. This position provides 24 X 7 operational support and administration of all databases and computer storage systems for the Integrated Enterprise System (IES) providing statewide ERP applications for Financials, Budget, Payroll, Human Resources, Procurement, and Business Warehouse, Time Collection, PennWatch and supporting systems. Work responsibilities include database administration, software installation & upgrade, backup and recovery, performance tuning, system monitoring, error correction, database reorganization, data archiving and disaster recovery. This is an advanced technical position. This position reports to the IES Basis Team Manager. |
|
Description of Duties: Describe in detail the duties and responsibilities assigned to this position. Descriptions should include the major end result of the task. Example: Types correspondence, reports, and other various documents from handwritten drafts for review and signature of the supervisor. Participate in the day-to-day database administration responsibilities for all IES supported databases running on SAP HANA and Oracle Clusterware across all operation system platforms. Coordinate with PA Compute Services (PACS) staff and other IES team members for daily maintenance, change control and project implementation. Participate in all aspects of database administration, including: - Installation, configuration and upgrade of all database software - Creation and maintenance of all database systems, both SAP and Non-SAP - Schedule backup and recovery in conjunction with PACS staff - Monitoring and tuning database to improve performance. - Identification and trouble-shooting of database level problems. - Audit of database level security. Trouble-shoot technical issues for IES functional team activities Monitor database performance using HANA Cockpit and Oracle Enterprise Manager Maintain and support for SAP Content Server database (MAXDB) Maintain and support for OS and SAP data archiving process Participate in IES disaster recovery process Participate in IES database off-hours on-call rotation on-site and remotely Research, evaluate and implement new technologies and/or procedures Provide weekly activity report to Database Manager reporting major project activities Maintain latest database administration knowledge through formal training, seminars and publications Perform other duties as assigned |
Decision Making: Describe the types of decisions made by the incumbent of this position and the types of decisions referred to others. Identify the problems or issues that can be resolved at the level of this position, versus those that must be referred to the supervisor. Example: In response to a customer inquiry, this work involves researching the status of an activity and preparing a formal response for the supervisors signature. Provide initiatives in the research and monitoring of database activities. Advise team manager of system abnormalities and recommend solutions. Develop detailed project plan and execute project plan under the team manager supervision. |
||||||||||||||||||||
Requirements Profile: Identify any specific experience or requirements, such as a licensure, registration, or certification, which may be necessary to perform the functions of the position. Position-specific requirements should be consistent with a Special Requirement or other criteria identified in the classification specification covering this position. Example: Experience using Java; Professional Engineer License Experience: Knowledge of advanced information technology and systems administration principles and techniques. Knowledge of working principles of server, client, and network operating systems. Knowledge of the process of installing and configuring computer systems and peripheral hardware Knowledge of Unix and Windows operating systems, including process and file system administration, software installation, script development, job scheduling and trouble shooting Knowledge of advanced Oracle database administration processes, including database configuration, SQL, storage management, performance tuning, and data backup and recovery Ability to perform system workload analysis Ability to perform database backups, restoration, and recovery Ability to perform identify and resolve database problems Ability to plan, organize, and manage time effectively Ability to communicate clearly and effectively, in speaking and in writing Ability to evaluate products scientifically and recommend unbiased solutions Ability to research and acquire work-related in new technology Ability to establish and maintain effective working relationships with others. Ability to travel to points away from the established work location to carry out the responsibilities of the position. Licenses, registrations, or certifications: 1. N/A 2. N/A 3. N/A 4. 5. 6. |
||||||||||||||||||||
Essential Functions: Provide a list of essential functions for this position. Example: Transports boxes weighing up to 60 pounds.
|