APPLICATION INSTRUCTIONS: - CURRENT PENN STATE EMPLOYEE (faculty, staff, technical service, or student), please login to Workday to complete the internal application process. Please do not apply here, apply internally through Workday. - CURRENT PENN STATE STUDENT (not employed previously at the university) and seeking employment with Penn State, please login to Workday to complete the student application process. Please do not apply here, apply internally through Workday. - If you are NOT a current employee or student, please click “Apply” and complete the application process for external applicants. Approval of remote and hybrid work is not guaranteed regardless of work location. For additional information on remote work at Penn State, see Notice to Out of State Applicants. ​ POSITION SPECIFICS​ Penn State IT is seeking a creative, analytical, and innovative Database Administrator who is passionate about building and maintaining reliable database solutions. This role collaborates closely with system administrators, developers, quality analysts, solution architects, business analysts, and data professionals to ensure high-quality data products are delivered to support organizational needs. The Database Administrator will support both existing and emerging data platforms across on-premises and cloud environments while helping design scalable, secure, and high-performing database solutions. LOCATION The location of this position is flexible and can operate fully remote within the United States (restrictions may apply). Standard working hours are in the Eastern Time Zone. Questions related to flexible work hours should be directed to the hiring manager during the interview process. KEY RESPONSIBILITES - Perform daily, weekly, and monthly operational support on database solutions (ie: MS SQL Server MongoDB, MySQL, Azure SQL, AWS, and Google database services). - Oversee routine database maintenance on all operational systems, including backup and recovery, performance tuning, monitoring, and physical sizing. - Monitor system performance, assess space utilization and growth, and recommend upgrades and enhancements to software and/or hardware to ensure optimal database performance. - Work in collaboration with IT Security to define policies and procedures that ensure compliance across database operations. - Contribute to the Architecture, Design, and Delivery of database solutions as assigned by the Systems Delivery team. - Contribute to and maintain comprehensive documentation for database architecture, configurations, and operational procedures. - Contribute to the development of standards and practices that promote the reuse of existing or common data stores, data elements, and components. - Assist developers with the release and deployment of database objects into existing databases. QUALIFICATIONS Qualified candidates will demonstrate strength and experience across several of the following areas: - Experience working with enterprise relational databases in a 24x7 production environment, collaborating with data engineers and other technical teams. - Strong proficiency with MS SQL Server or comparable relational database platforms, including database creation, administration, and optimization. - Experience developing and implementing backup, restore, and disaster recovery strategies for enterprise database systems. - Hands-on experience with performance tuning, query optimization, and diagnosing slow or inefficient queries. - Ability to troubleshoot database performance and functionality issues in complex production environments. - Knowledge of database security practices, including encryption, access control, and compliance requirements. - Strong understanding of database design and architecture, including schema design, normalization, table design, and partitioning strategies. - Ability to work effectively in a collaborative, fast-paced environment with a proactive, team-oriented mindset. MINIMUM EDUCATION, WORK EXPERIENCE & REQUIRED CERTIFICATIONS Bachelor's Degree 3+ years of relevant experience; or an equivalent combination of education and experience accepted Required Certifications: None ADDITIONAL SUCCESS FACTORS In addition to a strong commitment to customer service, the successful candidate must: - Demonstrate excellent oral, written, and presentation communication skills. - Be self-motivated, capable of working independently, and able to manage multiple simultaneous tasks. - Remain flexible and maintain critical thinking abilities under pressure. - Possess strong problem identification and problem-solving skills. - Maintain excellent documentation practices. BACKGROUND CHECKS/CLEARANCES Employment with the University will require successful completion of background check(s) in accordance with University policies. Penn State does not sponsor or take over sponsorship of a staff employment Visa. Applicants must be authorized to work in the U.S. SALARY & BENEFITS The salary range for this position, including all possible grades, is $76,700.00 - $115,100.00. Salary Structure - Information on Penn State's salary structure Penn State provides a competitive benefits package for full-time employees designed to support both personal and professional well-being. In addition to comprehensive medical, dental, and vision coverage, employees enjoy robust retirement plans and substantial paid time off which includes holidays, vacation and sick time. One of the standout benefits is the generous 75% tuition discount, available to employees as well as eligible spouses and children. For more detailed information, please visit our Benefits Page. CAMPUS SECURITY CRIME STATISTICS Pursuant to the Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act and the Pennsylvania Act of 1988, Penn State publishes a combined Annual Security and Annual Fire Safety Report (ASR). The ASR includes crime statistics and institutional policies concerning campus security, such as those concerning alcohol and drug use, crime prevention, the reporting of crimes, sexual assault, and other matters. The ASR is available for review here. EEO IS THE LAW Penn State is an equal opportunity employer and is committed to providing employment opportunities to all qualified applicants without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. If you are unable to use our online application process due to an impairment or disability, please contact 814-865-1473. Penn State is committed to and accountable for advancing equity, respect, and belonging. We embrace individual uniqueness, as well as a culture of belonging that supports equity initiatives, leverages the educational and institutional benefits of inclusion in society, and provides opportunities for engagement intended to help all members of the community thrive. We value belonging as a core strength and an essential element of the university’s teaching, research, and service mission. Federal Contractors Labor Law Poster PA State Labor Law Poster Penn State Policies Copyright Information Hotlines

Agency Office of the State Controller Division OSC Information Technology Job Classification Title Database Administrator II (NS) Position Number 65034561 Grade DT10 About Us The State Controller serves as an independent resource to protect the financial integrity of the State and to promote accountability in an objective and efficient manner through its accounting, disbursing, payroll, internal controls, data management, eCommerce, and financial reporting systems that serve state agencies, employees, and the public. The foundational principles of the office are Integrity/Ethics, Objectivity, and Accountability. OSC’s overall goals are to optimize operational execution, manage risk effectively and efficiently, and foster a high-performance culture. OSC will provide excellent customer service while achieving those goals. Description of Work This position is Optional for 100% Remote. A $7500 Sign on Bonus is available for selected candidate. **See eligibility for Sign-on Bonus below in the Supplemental and Contact Information section. ** Please Note: OSC does not use 3rd parties to conduct job interviews. **OSC is interested in every qualified candidate who is eligible to work in the United States. However, we cannot sponsor visas at this time. ** **Successful candidate will be subject to a criminal background check. ** The mission of the Office of the State Controller (OSC) is to protect the financial integrity of the State and promote accountability in an objective and efficient manner. NOTE: This job posting will close at 11:59 p.m. the night before the closing date. Salary Range: $87,617 - $131,426 The foundational principles of the office are Integrity/Ethics, Objectivity and Accountability. OSC’s overall goals are to optimize operational execution, manage risk effectively and efficiently and foster a high-performance culture. OSC will provide excellent customer service while achieving those goals. The State Controller is the State’s Chief Fiscal Officer. The Controller serves as an independent resource to protect the financial integrity of the State and to promote accountability in an objective and efficient manner through accounting, disbursing, payroll, internal control, eCommerce, and financial reporting systems. The basis for the Controller’s authority is statutory. Description of Work: This position is part of the NCFS Technical Team (Business Intelligence) and focuses on producing reports that support statewide business needs, while ensuring data quality and report performance in the enterprise Business Intelligence system. This position is responsible for designing, developing, implementing, and supporting Oracle ERP reports using Oracle Cloud Financial ERP reporting tools, specifically BI Publisher (BIP), Oracle Transactional Business Intelligence (OTBI), and Financial Reporting Studio (FRS). Responsibilities include hands-on report development, managing reports that are part of outbound interfaces, administration of report scheduling, and collaboration with business stakeholders. This role is responsible for end-to-end implementation of reporting solutions and outbound data integrations for Oracle Financials, including monitoring, maintaining, and enhancing existing reports. Duties include: Design and Development • Assist with defining scope and estimates for new development work. • Support quarterly upgrade to Oracle cloud by assessing its impact on reports. • Gather reporting requirements from stakeholders and lead the design of efficient, scalable reporting solutions. • Provide technical direction and expertise related to reporting strategies. • Create and maintain design documents relating to reporting initiatives which may involve developing detailed data mapping and data transformation rules. • Develop and support Oracle Cloud Financials reports using Oracle provided reporting tools. • Responsible for designing, developing, and supporting various reports and data extracts. • Analyze requirements and architect appropriate solutions, with detailed design documents. • Ensures ad-hoc reporting requests are captured, prioritized and where possible create standardized dynamic reports to meet ad hoc reporting needs. Knowledge Management • Responsible for sharing knowledge about reports and outbound integrations with other team members and IT Customer Support team throughout the life cycle of project. • Collaborate with Finance and Accounting teams to define and document reporting requirements. • Maintain expert-level skills in Oracle ERP reporting tools, specifically BI Publisher (BIP), OTBI, and FRS. • Develop and maintain an up-to-date knowledge of Oracle quarterly product updates and the impact on reports and outbound integrations. Process Improvement • Participate in cross-functional discussions to analyze requirements and recommend effective solutions. • Evaluate and optimize existing reports, ensuring performance, scalability, security, error logging, and auditing, and propose modifications to meet business needs. • Develop and implement automation strategies for reporting and simplify report delivery and usage wherever possible. • Plan and document projects to test architectural proposals, explore industry trends and new technologies, and provide guidance to senior management. Production Support • Support outbound data integrations and reporting processes within Oracle Cloud Financials. • Assist in incident resolution and service requests related to Oracle Financials. • Monitor and maintain existing reporting processes to ensure accuracy and efficiency. **Eligibility for Sign-on Bonus ** Qualified applicants must be selected from the candidate pool of this posting and meet the State policy following requirements: A newly hired permanent full time or permanent part-time employee who works 30 to 40 hours per week is eligible for a sign-on bonus (this will be prorated for employees working less than 40 hours per week). The sign on bonus will be paid in three installments. An employee is not eligible for a sign-on bonus if: (1) the employee has held a position in North Carolina State government, including the judicial system, or the University of North Carolina system within the last 12 months (the employee shall remain ineligible for 12 months from the separation date); (2) the employee has previously received a sign-on bonus from any State agency; This Sign-on Bonus is contingent upon budget and final eligibility determination as of the effective date of hire. Before receiving this sign-on bonus, the hired applicant must agree to repay the bonus on a pro-rated basis should he/she not have a performance rating of at least Meets Expectations or separates employment with OSC within 18 months of the hire date. Knowledge Skills and Abilities/Management Preferences Note to Applicant: Any job-related Knowledge, Skills, and Abilities that you have must be clearly documented in your application to be considered for the Most Qualified applicant pool. - Technical experience in Oracle financials, preferably Oracle cloud reporting with broad understanding of at least four modules from General Ledger, Accounts Payable, Accounts Receivable, Purchasing, Supplier Portal, Employee Expense, Fixed Asset, Inventory, Cost Management, Project Accounting and Grants. - Strong hands-on experience with Oracle reporting tools, specifically BI Publisher (BIP), OTBI, and FRS, including report development, customization, and scheduling. - Solid understanding of Oracle Financials data structures, subject areas, and reporting architecture. - Proficiency in Oracle ERP technologies, with hands-on experience in Oracle EBS R12 or higher; Oracle Fusion/Cloud ERP experience preferred. - Expertise in Oracle reporting tools including OTBI, BI Publisher, Smart View, and FRS, with deep knowledge of Oracle Financials architecture, report catalog security, and ESS job scheduling. - Advanced technical and automation skills, including SQL development, Visual Basic macros, and batch scripting for process optimization. - Experience with version control, GIT/Subversion. - Expertise in Oracle Workflow and Personalization Minimum Education and Experience Some state job postings say you can qualify by an “equivalent combination of education and experience.” If that language appears below, then you may qualify through EITHER years of education OR years of directly related experience, OR a combination of both. See the Education and Experience Equivalency Guide for details. Bachelor's degree in computer science or an IT related field or a related curriculum from an appropriately accredited institution and three years of progressive experience in programming and applications analysis including the design and maintenance of an integrated database system; or Associate degree in computer science or an IT related field or a related curriculum from an appropriately accredited institution and four years of progressive experience in programming and applications analysis including the design and maintenance of an integrated database system; or High School or General Educational Development (GED) diploma and seven years of relevant experience in programming and applications analysis including the design and maintenance of an integrated database system; or an equivalent combination of education and experience. EEO Statement The State of North Carolina is an Equal Employment Opportunity Employer and dedicated to providing employees with a work environment free from all forms of unlawful employment discrimination, harassment, or retaliation. The state provides reasonable accommodation to employees and applicants with disabilities; known limitations related to pregnancy, childbirth, or related medical conditions; and for religious beliefs, observances, and practices. Recruiter: Pamela Denise Hamm Recruiter Email: PAMELA.HAMM@NCOSC.GOV

• Responsible for the design, implementation, maintenance, and optimization of database systems that power Augeo's enterprise platforms across multiple teams and technology stacks. • Serve as a cross-team resource, ensuring database reliability, performance, and security across SQL Server, Snowflake, Oracle, and MySQL environments. • Manage both on-premises and cloud-based database infrastructure, develop and maintain ETL processes using SSIS, and partner with development teams to optimize queries and design efficient data models. • Ensure high availability and disaster recovery readiness. • Leverage AI-powered database management tools and agentic AI assistants to automate routine administration tasks and accelerate performance diagnostics.

• Manage and maintain all Databricks workspaces across development, test, and production environments. • Administer Unity Catalog / Hive Metastore, including schema design, permissions, external locations, mounts, and data governance configurations. • Manage clusters, cluster policies, job clusters, cluster performance, auto-scaling, and cost optimization. • Oversee Databricks Jobs, workflows, task orchestration, alerting, and SLAs. • Configure and maintain external data sources and connectors (ADLS Gen2, Delta tables, SQL MI, Snowflake, APIs). • Implement and maintain CI/CD pipelines for Databricks notebooks, SQL, and infrastructure using Azure DevOps/GitHub Actions. • Develop, maintain, and enforce platform security standards including RBAC, service principals, secrets, key vault integration, and audit logging. • Administer Azure SQL Managed Instance and other SQL environments supporting the CAQH EDW. • Perform database performance tuning, indexing, partitioning, storage management, and query optimization. • Oversee backup/restore operations, failover strategies, and high availability configurations. • Manage schema changes, deployments, and environment synchronization across dev, test, and prod. • Partner with the Data Engineering team on efficient ingestion and transformation patterns to SQL-based systems. • Monitor capacity, costs, and system health for all SQL and storage resources in Azure. • Administer Azure Data Factory including linked services, integration runtimes, pipelines, triggers, and parameterized workflows. • Implement enterprise standards for logging, error handling, retries, alerting, and operational monitoring. • Ensure secure configuration and compliance for all data movement operations, including PII/PHI safeguards. • Establish and enforce standards for data access, identity management, secrets rotation, key management, and auditability. • Participate in Data Governance initiatives including metadata management, lineage tracking, and catalog standardization. • Build documentation for platform configurations, processes, and operational playbooks. • Evaluate new Azure features and provide recommendations for modernization and cost efficiency. • Monitor platform reliability, SLAs, performance, and uptime across all Azure data services. • Troubleshoot and resolve platform-wide issues including job failures, performance bottlenecks, and connectivity disruptions. • Partner with InfoSec to ensure compliance with CAQH security policies and healthcare data regulations, including but not limited to HITRUST security access reviews. • Support agile development teams by managing environments, access, and deployment pipelines.