|
Commonwealth of Pennsylvania |
|
|
POSITION DESCRIPTION FOR JOB POSTING |
|
|
Position Number: 50441765 |
Description Activated On: 10/16/2024 11:33:05 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. This position functions within the Solutions Management team for the Public Safety IT Delivery Center (PSITDC) and provides database design, development, and support of databases developed for the Pennsylvania State Police and/or supporting vendors. While this position will be assigned to provide database support for the PA State Police, cross-agency PSITDC assignments may occur. The client agencies supported by PSITDC include: PA State Police (PSP), Department of Corrections, PA Board of Probation & Parole, Office of Victim Advocate, Sex Offender Assessment Board, Firearms Education and Training Commission, PA Justice Network, and the PA Commission on Crime and Delinquency. This position is also responsible for database operations activities (database administration, database security, assuring availability, server monitoring, performance monitoring, capacity planning, SQL software installation and configuration, and Service Pack installations). |
|
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. 60% Database Development • Collaboration: Work closely with development teams to support database-related needs and projects. • Creates, maintains, and supports the logical and/or physical design of assigned databases • Defines, develops, and creates databases by assessing requirements • Designs tables through database normalization by efficiently organizing data by eliminating redundant data and ensuring data dependencies are appropriate • Researches and works with application developers to utilize SQL server features not already implemented elsewhere within PSP • Uses database modeling tool to develop and maintain data models • Creates and/or reviews data dictionaries and data models; provides comments in accordance with standards. • Provides database related information to the Agency’s documents • Captures database requirements in application documents before deployment to Test and Production environments • Provides database design support for PSP’s databases created and supported by Enterprise Application Services within Solutions Management • Provides technical guidance in developing database system requirements and all areas of SQL Server application related processes such as SSIS packages and stored procedures for other development staff 20% Data Analytics • Provides support to ensure the daily running of the Data Marts and Warehouse as needed • Creates and maintain SSIS packages within development projects scope to fit reporting and dashboard needs or the organization • Creates T-SQL queries, stored procedures, and views for Power BI data models • Participates in the on-call duty phone rotation and acts as the escalation point for Power BI-related issues • Deploys Power BI reports to the production environment • Administers Power BI cloud workspaces and Power BI Gateway • Administers Power BI Report Server • Stays abreast of Power BI technologies and OLAP data structure design 15% Database Operations • Provides SQL Database and Database Server administration support for critical production systems both On Premise Instances as well as Microsoft Azure Managed Instances • Monitors and optimizes database performance, including query tuning • Coordinates with vendors and service providers to resolve technical support issues • Administers, maintains, and enforces appropriate security and access to databases, including performing security audits • Ensures overall health and availability and quality of services, which includes Health Checks on databases and Instances • Backup and Recovery: Implements and manages backup and recovery strategies to protect data integrity • Security Management: Configures and manages security settings, including encryption, firewall rules, and access controls • Monitoring and Alerts: Sets up and manages monitoring tools and alerts to proactively address potential issues • Supports disaster recovery efforts for those systems subscribed to a disaster recovery service. • Performs migration and upgrade of SQL Databases • Coordinates, develops and implements database maintenance activities • Performs data migration by designing programs to optimally extract, cleanse, transform and load data between data sources as part of data migration and data validation support • Coordinates database restores with datacenter’s backup team and restore databases to lower environments upon request from developers • Deploys database schema changes to test and production environments • Develops ways to improve and automate current operational processes and daily tasks • Serves as an escalation point for database and server issues such as IS packages, data migration, reporting services, and other database and server issues • Participates on all change planning discussions and coordinates with other members on changes to ensure adequate DBA production support during deployments • Stays abreast of current trends and emerging technologies in the field • Updates and maintains database security standards 5% Other • Participate in special projects and studies as required • Perform other related duties as assigned to include those outlined in the CoG Plan when the Plan is activated • Respond to the designated alternate or secondary location when directed in response to a catastrophic incident • Be knowledgeable of, adhere to, and contribute to established digital accessibility regulations and standards |
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. General or detailed guidelines and proposed objectives are supplied by the immediate supervisor. It is the incumbent’s responsibility to further expand and develop the proposed objectives. Work is reviewed by the immediate supervisor to see that the initial objectives have been reached, and any problem areas that do exist are analyzed and resolved. |
||||||||||||||||||||
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. N/A 5. N/A 6. N/A |
||||||||||||||||||||
Essential Functions: Provide a list of essential functions for this position. Example: Transports boxes weighing up to 60 pounds.
|