Database and Data Warehouse Administrator

Polk State College · United States

Please label all uploaded documents with your full name (for example: Jane_Doe_Resume ). This helps ensure your materials are properly matched to your application. If you are a currently active Polk State College employee, please create an account using your polk.edu staff email address. Our HR system will not recognize you as an active employee. Description The Database Administrator (DBA) is responsible for the administration, maintenance, optimization, security, and operational support of Polk State College's Operational Data Store (ODS), Enterprise Data Warehouse, reporting databases, and related data platforms. Reporting to the Manager, Applications and Integrations, this position serves as the College's primary technical resource for database administration, data architecture, performance tuning, data quality management, and reporting support. The Database Administrator reports to the Manager of Applications and Integrations and works closely with the Banner Operations Lead and Data Integrations Specialist to ensure institutional data is accurate, secure, accessible, and available to support reporting, analytics, compliance, and operational decision-making. This position plays a critical role in supporting Banner SaaS data integrations, data governance initiatives, Institutional Effectiveness, Accreditation and Research, and enterprise reporting environments, including Argos, Power BI, and other business intelligence tools. Essential Functions/Duties Administer, maintain, monitor, secure, and optimize the College's Operational Data Store (ODS), Data Warehouse, reporting databases, and related data platforms. Serve as the primary technical administrator for institutional data repositories supporting reporting, analytics, compliance, and operational decision-making. Design, develop, maintain, and optimize database structures, schemas, views, stored procedures, functions, and reporting datasets. Monitor database performance and implement tuning strategies to improve system reliability, scalability, and efficiency. Collaborate with the Data Integrations Specialist to support data movement, data validation, ETL/ELT processes, and data synchronization between Banner SaaS and integrated systems. Work closely with the Banner Operations Lead to troubleshoot Banner-related data issues, reporting discrepancies, and data governance concerns. Support Institutional Effectiveness, Accreditation and Research, Enrollment Services, Student Services, Academic Affairs, Finance, Human Resources, and other departments with reporting and data analysis requirements. Assist in the development and maintenance of reporting environments supporting Argos, Power BI, and other business intelligence platforms. Develop and maintain SQL queries, views, stored procedures, and reporting objects used by internal stakeholders and reporting tools. Monitor data quality, data integrity, data lineage, and source-of-record consistency across enterprise systems. Support data governance initiatives through implementation of data validation controls, reconciliation processes, audit reporting, and metadata management practices. Maintain database backup, recovery, disaster recovery, and business continuity procedures. Implement database security controls, role-based access management, encryption, and auditing practices to protect institutional data. Assist with Banner SaaS upgrades, Ethos releases, reporting enhancements, and integration projects affecting institutional data. Create and maintain database documentation, data dictionaries, data models, standards, procedures, and technical specifications. Participate in strategic planning initiatives involving data architecture, analytics, reporting modernization, and enterprise data management. Perform other related duties and special projects as assigned. Typical Qualifications Required Skills: Advanced SQL development, query optimization, and database administration skills. Strong knowledge of relational database design, normalization, dimensional modeling, and data architecture principles. Experience administering Operational Data Stores (ODS), Data Warehouses, and enterprise reporting environments. Knowledge of ETL/ELT processes, data transformation, data validation, and data integration concepts. Experience supporting reporting platforms such as Argos, Power BI, SSRS, Tableau, or similar business intelligence tools. Knowledge of data governance principles, data stewardship practices, metadata management, and data quality management. Understanding of source-of-record concepts and higher education data environments. Strong analytical, troubleshooting, and problem-solving abilities. Knowledge of cybersecurity principles, database security controls, FERPA, GLBA, and information security best practices. Ability to communicate technical concepts effectively to technical and non-technical audiences. Ability to manage multiple priorities while maintaining exceptional attention to detail. Working Conditions: This is a full-time, on-campus position within the Institutional Technology department. Work hours may include evenings and weekends as needed to support critical operations, system maintenance, upgrades, or special projects. Travel between Polk State College campuses and centers may be required. Frequent use of computers and office technology is required. Salary and Benefits Information: This position is classified at Level P15 . Polk State College offers an excellent employer-paid benefits package, including Medical, Dental, Life, Long-Term Disability, Vacation, Holiday, and Sick Leave, Retirement (if eligible), and college fee waivers. Additional voluntary benefits are also available. Required Education: A Bachelor's degree in Computer Science, Information Systems, Information Technology, Data Analytics, Database Administration, Software Engineering, or related field from a regionally accredited college or university. Preferred Education: Master's degree in Computer Science, Information Systems, Data Analytics, Database Administration, Information Technology, or a related field. Required Experience: Three years of experience supporting enterprise databases, data warehouses, reporting environments, or enterprise data management platforms. Experience administering relational databases and developing complex SQL queries. Experience supporting ODS, Data Warehouses, or enterprise reporting environments. Experience troubleshooting database performance and data integrity issues. Experience supporting reporting and analytics platforms. Experience implementing database security controls and disaster recovery processes. Preferred Experience: Experience supporting Ellucian Banner SaaS, Ethos Integration, ODS, Data Warehouse, Insights, and related Ellucian products. Experience supporting Argos, Power BI, Snowflake, Microsoft Fabric, Tableau, or similar reporting and analytics platforms. Experience supporting higher education administrative systems including Student, Finance, Human Resources, Financial Aid, and Advancement. Experience with data governance programs, data quality initiatives, and institutional reporting environments. Experience supporting cloud-based database technologies and modern analytics platforms. Relevant certifications in SQL Server, Oracle, Snowflake, Microsoft Data Platform, Power BI, database administration, or related technologies. Alternative Credentials: High School Diploma or equivalent with 7 years of directly related experience. or Associate's degree with 5 years of directly related experience. Supplemental Information Submissions that do not include all parts of the following required information will not be considered: a resume. an electronic job application (all sections MUST be completed). Important Information If you are a retiree of the Florida Retirement System (FRS), please check with the FRS on how your current benefits will be affected if you are re-employed with the State of Florida. Your current retirement benefits may be canceled, suspended, or deemed ineligible depending upon the date of your retirement. Polk State College participates in E-Verify. Candidates must provide documentation of eligibility to work in the United States. Polk State College does not provide visa sponsorship. To request Veteran's Preference, please be sure to upload all necessary documents (DD-214, etc.) to your application. Polk State College is a drug-free workplace. Polk State College is committed to working with and providing reasonable accommodation to applicants and employees with disabilities. Reasonable accommodation is considered on a case-by-case basis. Employment visa sponsorship is unavailable for this position. Applicants requiring employment visa sponsorship now or in the future (e.g., F-1 STEM OPT, H-1B, TN, J1, etc.) will not be considered. Reference checks, successful completion of a background check, and third-party Education Verification for all stated degrees will be required prior to employment. Polk State College does NOT provide relocation assistance for this position. Equal Opportunity Statement Polk State College does not discriminate on the basis of race, color, national origin, sex, disability, or age in its programs, activities, or employment. For information about the College's equal access and equal opportunity policies and procedures, or to file a complaint, please contact: Title IX Coordinator 3425 Winter Lake Road Lakeland, FL 33803 863.669.2903 compliance@polk.edu For additional information, visit polk.edu/compliance We encourage applicants to provide feedback on their experience or request help at Careers@polk.edu .