|
Commonwealth of Pennsylvania |
|
|
POSITION DESCRIPTION FOR JOB POSTING |
|
|
Position Number: 00053178 |
Description Activated On: 2/10/2026 11:43:53 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 Delivery Center (PSDC) provides database design, development, administration and support of databases developed for the Pennsylvania Justice Network (JNET) and the Pennsylvania Commission on Crime and Delinquency (PCCD) and/or supporting vendors. This position is responsible for advanced technical and administrative work in all phases of database development activities (planning, design, development, implementation, data migration, quality assurance, data cleanup, and data administration). This position may be required to be assist with database administration, operations, and monitoring as needed. This position reports to the JNET/PCCD Solutions 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. This position is responsible for analysis, design, development, implementation, deployment, and administration of databases for both JNET and PCCD within the Public Safety IT Delivery Center. Duties include the logical design and configuration of databases and developing data models and logical data designs. Detailed duties are described below: A. Database Development - 45% 1. Designs databases and ensures their stability, reliability, and performance. Works with application developers optimizing in-application SQL statements as necessary and establishes best practices. Helps solve all database usage issues and develops strategies and instruction that can help avoid such problems in the future. Writes complex T-SQL (Transact-SQL) queries to support web application and business analytics in addition to ensuring database performance, efficiency, and recovery. Works directly with the web application development team to design, code, test, debug, and document web application data tiers. 2. Maintains operational systems, programs, and databases to support development of new systems/databases by utilizing knowledge of current techniques in database design, planning, application development, programming, operating systems, systems and network architecture, hardware and software capabilities, and capacity planning. 3. Maintains and modifies specialized software and utilities, analyzes, and resolves problem conditions attributed to database design or software. May involve contacting vendor or internal technical support on software related problems. 4. Analyzes business processes, procedures, and problems to develop database and data solutions to meet business needs. 5. Develops and establishes data administration standards and procedures pertaining to data elements, data dictionary, data sharing, entity relationship diagrams and methodologies, and quality assurance. 6. Interfaces with program staff, the user community, and application development staff in developing data models and resolves data quality problems. 7. Maintains knowledge of latest developments in database administration/management techniques by reviewing professional publications and/or participating in formal training programs, courses, and seminars. 8. Provides 24x7 support for critical production systems. 9. Possesses excellent knowledge in Relational Database Management Systems (RDBMS) concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers, user profiles, data dictionaries, and data integrity, SQL joins, and query writing. 10. Ensures customer IT requirements are fully supported by utilizing knowledge of on-line transaction processing and on-line analytical processing, knowledge of database performance measurement and evaluation techniques and database problem resolution techniques to ensure customer IT requirements are fully supported. B. Application Database Administration - 15% 1. Provides team leadership and supervision, when assigned, to Database Analysts and/or other IT employees engaged in phases of database administration and/or Database Analysts performing database administration functions for designated agency databases. 2. Enhances or optimizes operational efficiencies or resolve deficiencies by analyzing business processes and in modifying database software 3. Analyzes and resolve database problems. 4. Analyzes business processes to assess data requirements. 5. Researches, evaluates, tests, and installs database and third-party software. 6. Monitors database performance, assesses space utilization, takes corrective action to enhance performance and more effectively utilize space. 7. Utilizes knowledge of creating complex, high performance stored procedures. Utilizes knowledge of SQL Server Integration Services (SSIS) and extraction, transformation, and load (ETL) development, and works with a variety of data sources and destinations, all major Control tasks and Data transformations tasks. 8. Utilizes MS SQL Server suite of products like SSRS, SSAS and SSIS of MS SQL Server and responsible for performance tuning of stored procedures using SQL Profiler and Database tuning wizard. 9. Serves as a member of the Continuity of Government Relocation Team. In the event that the essential functions of the client agency must be temporarily relocated to a field location, due to an emergency, this position will participate on the Relocation Team and performs all duties as directed by the team leader. 10. Be knowledgeable of, adhere to and contribute to established digital accessibility regulations and standards. C. Activity Management - 20% 1. Provides status reporting on assigned projects, tasks and work efforts. 2. Interprets policies, business objectives, goals of JNET/PCCD and PSDC to staff and contractors. 3. Attends user meetings to understand their business processes and challenges in relation to database development requirements. 4. Receives, reviews, and ensures IT service requests for database development needs are completed in their entirety. Follows up with requestor to gather additional information as required. Assists with the development of the request estimate. 5. Develops and maintains project plans for all medium, large enhancements and projects as assigned. Determines the scope of anticipated benefits, cost and budget amounts; ensures that required technical skills and staff/contractor resources are available to complete the request/project within established time frame. Monitors and reports on progress against the established plan; resolved critical issues; and conducts formal reviews at critical milestones. 6. Works with Applications Development staff and other PSDC/vendor staff to eliminate all obstacles, technical and administrative, inhibiting progress with assignments. D. Supervision and Management Duties - 10% 1. Provides support in preparing requests for quotations (RFQ's) for contracted services. 2. Meets with vendor personnel and participates in the review and evaluation of vendor proposals and recommendations to determine their adequacy and overall efficiency. 3. Oversees contracted staff on the design, development and implementation of application enhancements, modifications, and support fixes. 4. Coordinates skills transfer for contracted services, including the coordination of vendors and staff, reviewing knowledge transfer materials and conducting performance and effectiveness reviews of knowledge transfer efforts. E. Additional Duties - 10% 1. Provides support and assistance to application development staff and contractors as needed. 2. Provides technical assistance to project managers, management, customers, and other technicians. 3. Maintains industry standards, methodologies related to database and application administration and automation technologies. 4. Maintains contact with equipment vendors and professional organizations to ensure that the most current practices and techniques are utilized. 5. Performs related work as required. 6. Performs other related work and 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. Assignments, general instructions, and proposed objectives are given by immediate supervisor or result from operational system and support needs. Work is done independently to obtain the objectives. Any problem areas that do exist are independently analyzed and corrected as efficiently as possible. Status meetings are scheduled to see that the objectives are being reached. This position has a high level of independence in decision making and reports to the Solutions Manager. In the absence/unavailability of the Solutions manager, this employee shall be able to make independent decisions as the situational needs require/dictate. Work is assigned by the Solutions manager as general objectives. |
||||||||||||||||||||
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.
|