|
Commonwealth of Pennsylvania |
|
|
POSITION DESCRIPTION FOR JOB POSTING |
|
|
Position Number: 00056717 |
Description Activated On: 10/16/2023 1:45:33 PM |
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, maintain, and protect the application databases for the Department of Education and other agencies within the General Government Delivery Center when necessary. |
|
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 the databases and database servers used for 65+ internal and internet facing/external systems used by the Department of Education. 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 PDE/Commonwealth staff and educational institutions. 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 internal to the General Government Delivery Center. 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 and related tools extensively to perform job duties. 2) Data Population and Migration Oversees and participates in the migration of data between databases and applications. 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 General Government Delivery Center 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) Supervision Plans and assigns database design, configuration, and other database support tasks to the appropriate Database Administration staff such that expected timeframes and priorities can be met. Performs supervisory responsibilities such as approving leave, conducting employment interviews, assigning and reviewing work, evaluating performance, and administering discipline as necessary. 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 the database environments for the Dept of Education and other agency applications within the General Government Delivery Center. Analyzes database performance issues and suggests appropriate resolutions to address system issues as they are discovered/reported. Recommends hardware and software requirements related to Microsoft SQLServer database instances and servers to reliably support existing and new software applications. Decides on application database standards ensuring standards are being followed across all software development activities as it relates to database design and implementation ensuring consistency across applications and databases. |
||||||||||||||||||||
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.
|