|
Commonwealth of Pennsylvania |
|
|
POSITION DESCRIPTION FOR JOB POSTING |
|
|
Position Number: 00043536 |
Description Activated On: 4/1/2026 8:59:54 AM |
Position Purpose: Describe the primary purpose of this position and how it contributes to the organization’s objectives. Example: Provides clerical and office support within the Division to ensure its operations are conducted efficiently and effectively. The employee directs and participates in highly advanced technical work to plan, design, implement, and maintain databases used by agencies supported by the General Government Delivery Center. |
|
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. This position is responsible for managing internal databases for agencies supported by the General Government Delivery Center. This includes duties in the following areas: 1) Database Design and Implementation Directs and participates in the planning, design, and implementation of complex database structures that support web-based applications used by both Commonwealth staff and external entities/business partners. Directs and participates in the creation of data models and logical database designs to provide data solutions that meet business needs. Reviews, approves, and makes recommendations for all database designs created by outside consultants or by staff in the Database Administration Section. Directs and participates in the translation of logical database designs into physical databases designed for processing efficiency, ease of programming and maintenance, and protection of data integrity. Directs and participates in the creation and modification of physical database structures on the development, test, and production database servers. Directs and participates in the design and creation of data marts from the operational databases, making data more readily accessible to users for ad hoc reporting. Uses Microsoft SQL Server software extensively to perform job duties. 2) Data Population and Migration Oversees and participates in the migration of data between databases. Directs and participates in the writing of extracts and packages to load and populate data into various databases, the data warehouse, and data marts. Writes and reviews packages and database triggers to populate certain database tables and fields when required for specific application functions. Oversees and participates in the correction and merging of student and teacher data in the PIMS data warehouse when complexity necessitates a backend change. Assists in researching data issues and implements plans for their resolution as required. 3) Database Technical Support and Guidance Provides technical guidance to Commonwealth users, managers, and information technology staff on database design, implementation, and security. Writes, reviews, and deploys stored procedures that access database information to ensure their accuracy, efficiency, and proper documentation. Assists application developers as needed in writing stored procedures and Transact-SQL code to access data. Establishes and enforces database standards, policies, and procedures and maintains related documentation. Keeps informed about new database technologies by reviewing professional publications and participating in formal training programs, courses, and seminars. 4) Database Security and Performance Oversees the security of the Department’s database servers and the databases on those servers. This includes establishing appropriate security standards and procedures, granting appropriate database permissions, and controlling application security roles and their associated users in any databases housing application security. Ensures that production databases are monitored for performance and tuned appropriately using indexes or other techniques. Establishes, validates, and maintains database backup and recovery procedures to assure that every database is backed up on a regular basis, individual databases can be restored from backups to a point in time or migrated to different servers, and that a complete server recovery can be performed with minimal down time. Works with the infrastructure and DBA staff to ensure the procedures are understood and implemented properly. Researches and resolves problems related to database access, usage, and performance. 5) Database Infrastructure Support Instructs the infrastructure area on the initial setup of the database servers and installs and configures the database software on the various database servers. Requests firewall openings as needed. Determines the placement of databases on the various database servers, implements high availability databases where needed, and sets up database replication where required. Monitors and calculates database and server space requirements. Plans for and makes recommendations on upgrading server capacity and database software. Converts databases to use upgraded software and moves databases to other servers as required. 6) Oversight of contracted work Plans and coordinates database design, configuration, and other database support tasks assigned to contracted resources to ensure work is completed within expected timeframes and aligned with established priorities. Reviews deliverables, monitors progress, and provides guidance or clarification as needed to ensure technical accuracy and adherence to project requirements. 7) Performs other related duties as required. |
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 supervisor’s signature. Makes decisions related to all aspects of administering database environments. Makes decisions regarding the management of direct subordinates. Makes recommendations, but not final decisions regarding software and hardware purchases. Has input, but does not make decisions on Delivery Center priorities. |
||||||||||||||||||||
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: 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.
|