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.

• Working against an existing MS SQL based platform in the regulatory risk space. • DBs require optimisation and stability engineering to meet expectations and forecast scale requirements.