What are the responsibilities and job description for the Database Administrator position at Rogue Community College?
Position Description
Position Title
Database Administrator
Secondary Title
Group / Grade
7
Classification
Classified
Work Location
All Campuses
Overtime Eligible
Non-Exempt
Division
Operations & Finance
Differentials
N/A
Department
Information Technology
Reports To
Director, Information Technology Management
Supervision Received
Works under the general supervision of the Director, Information Technology Management.
Supervisory Responsibility
Supervision is not a responsibility of this position. May oversee student employees.
Position Summary
The Database Administrator (DBA) is responsible for the design, implementation, maintenance, security, and optimization of the college’s database systems. The DBA ensures the availability, reliability, integrity, and performance of all database resources that support institutional applications, reporting, analytics, and enterprise services. This position plays a critical role in data governance, compliance, and institutional effectiveness, working closely with system administrators, application developers, and functional departments to deliver high-quality, reliable database solutions that enable student success and operational excellence.
Examples of Duties - Essential Functions
1.
Database Administration & Operations
- Install, configure, upgrade, and maintain database management systems such as Microsoft SQL Server, Oracle, MySQL/MariaDB, and PostgreSQL.
- Monitor and maintain database health, availability, and performance to meet service-level agreements.
- Implement and manage database backup and recovery strategies to ensure business continuity and disaster recovery compliance.
- Develop scripts and tools to automate database tasks and optimize workflows.
- Manage database storage, capacity planning, and resource allocation to support institutional growth.
2.
Security & Compliance
- Implement and enforce database security policies, standards, and access controls.
- Apply patches and monitor for vulnerabilities to maintain secure database environments.
- Ensure compliance with FERPA, HIPPA, PCI-DSS, GDPR, and other applicable data privacy and security regulations.
- Conduct regular audits, access reviews, and risk assessments, producing compliance documentation as required.
- Maintain and review database access logs to identify and resolve anomalies.
3.
Collaboration & Support
- Serve as Tier 3 escalation for complex database-related incidents.
- Partner with system administrators, developers, and analytics teams to integrate systems and resolve cross-platform issues.
- Provide technical guidance and training to IT staff and developers on query optimization, security practices, and database usage.
- Support Institutional Research, compliance, and reporting needs by designing and maintaining queries, views, and reporting structures.
4.
Performance Tuning & Optimization
- Monitor system performance and resolve bottlenecks to ensure efficient database operations.
- Optimize SQL queries, indexes, and stored procedures to improve performance and reduce run times.
- Collaborate with developers to review database designs and schema changes for scalability, security, and maintainability.
5.
Data Management & Governance
- Ensure data integrity, accuracy, and standardization across systems and applications.
- Maintain entity-relationship diagrams, data dictionaries, and metadata repositories.
- Manage schema changes through established change control and documentation processes.
- Assist with data migration, integration, and ETL activities to support system upgrades and institutional initiatives.
6.
Strategic Planning & Continuous Improvement
- Stay current with emerging database and cloud technologies and assess applicability to college needs.
- Recommend new tools, platforms, and practices to improve efficiency, security, and reliability.
- Contribute to IT strategic planning, lifecycle management, and digital transformation initiatives.
- Provide expertise during ERP upgrades and other large-scale IT projects to ensure continuity and integration.
7.
Other Duties as Assigned
- Provide after-hours and on-call support for database maintenance and emergency response.
- Participate in committees, task forces, and special projects, including the Data Governance Committee.
- Assist in cross-training IT staff and document procedures to promote knowledge sharing.
- May participate in College committees as assigned.
- Engages in professional growth opportunities as assigned.
- Performs other duties as assigned.
Institutional Expectations
- Demonstrates our core values of integrity, collaboration, diversity, equity, and inclusion, sustainability, and courage.
- Actively contributes to a culture of respect and inclusivity by collaborating effectively with students, colleagues, and the public from diverse cultural, social, economic, and educational backgrounds.
- Participates in recruitment and retention of students at an individual and institutional level in promotion of student success.
- Embraces and leverages appropriate technology to accomplish job functions.
- Provides high quality, effective service through learning and continuous improvement.
Screening Criteria
Qualifications & Additional Position Information
1.
Minimum Qualifications
- Education – a Bachelor’s degree in Computer Science, Information Systems, or a closely related field is required.
- Experience – a minimum of three years of progressively responsible experience in database administration, database development, or a related IT role, preferably in a higher education, public sector, or enterprise environment. Experience should include installation, configuration, maintenance, and security of relational databases (e.g., Microsoft SQL Server), as well as report and dashboard development using tools such as SSRS, Power BI, or Crystal Reports.
Only degrees received from an accredited institution will be accepted: accreditation must be recognized by the office of degree authorization, US Department of Education, as required by ORS 348.609. Final candidate will be required to provide official transcripts for required degree.
Any satisfactory equivalent combination of education and experience which ensures the ability to perform the essential functions of the position may substitute for the requirement(s). Please see our Applicant Guide for more information on education/experience equivalency guidelines.
2.
Preferred Qualifications
- Microsoft certifications such as Azure Database Administrator Associate, Azure Data Fundamentals, or Data Analyst Associate (Power BI).
- Familiarity with Jenzabar EX/Jenzabar One or comparable enterprise applications.
- Agile and/or ITIL Foundations certification (may be acquired after hire).
3.
Essential Knowledge, Skills, & Abilities (Core Competencies)
- Knowledge – Knowledge of relational database management systems (RDBMS), particularly Microsoft SQL Server, including database architecture, indexing strategies, query optimization, and security administration. Knowledge of enterprise applications such as Jenzabar EX/Jenzabar One in a higher education environment; data integration methods and tools connecting systems such as LMS, HR/payroll, and CRM; and institutional reporting tools such as SSRS, Power BI, and Crystal Reports. Understanding of backup and recovery processes, disaster recovery planning, and high-availability strategies, as well as applicable data privacy and security regulations including FERPA, HIPAA, and industry best practices. Familiarity with scripting languages such as T-SQL and PowerShell, version control practices, and awareness of emerging database and cloud technologies. Knowledge of Microsoft Office Suite® and general office productivity software.
- Skills – Skills in SQL programming, scripting, and query optimization; configuration, maintenance, and tuning of enterprise-level database systems; and use of reporting and business intelligence platforms to deliver accurate and timely data. Strong skills in troubleshooting complex technical issues across systems, developing automation tools, and documenting processes for both technical and non-technical audiences.
- Abilities – Ability to manage multiple projects and meet deadlines in a dynamic environment; collaborate effectively with IT staff, administrators, faculty, and external vendors; and maintain the confidentiality and integrity of sensitive data in compliance with legal and policy requirements. Ability to analyze complex data environments, recommend improvements in efficiency, performance, and security, and adapt to evolving technologies. Strong communication skills are required to provide clear guidance and support to both technical and non-technical stakeholders.
4.
Other Requirements
- For assignments requiring operation of a motor vehicle, possession of a valid Oregon Driver’s License or the ability to obtain one within 30-days of employment, and maintenance of an acceptable driving record are required.
5.
Remote Work Options (see AP 7239 Working Remotely for more details)
- In-person/On Campus – this position functions as an in-person work arrangement, working on campus with either a set schedule or flexibility depending on operational needs.
6.
Physical Demands
The physical demands listed below represent those that must be met by an incumbent to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with qualified disabilities to perform the essential functions.
Manual dexterity and coordination are required for more than three-quarters of the daily work period, which is spent sitting while operating office equipment such as computers, keyboards, 10-key, telephones, and other standard office technology. While performing the duties of this position, the employee is frequently required to sit for extended periods, type, and perform repetitive hand/wrist motions. The employee may also be required to stand, walk, reach, bend, kneel, stoop, twist, crouch, climb short step stools, balance, see, talk, hear, and manipulate objects. The position requires some mobility, including the ability to move materials less than 5 lbs. routinely and 5–25 lbs. occasionally. This position requires both verbal and written communication abilities.
7.
Working Conditions
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this position, the employee is primarily working indoors in an office environment. The employee is not exposed to hazardous conditions. The noise level in the work environment is usually moderate, and the lighting is adequate. The work schedule is stable and typically does not fluctuate; however, the incumbent may occasionally be required to provide after-hours or on-call support for database maintenance and emergency response.
Additional Posting Information
This is a Full-time Classified, 40-hour-per-week (100%) position in the Information Technology department. Starting compensation is entry level for Group 7 on the 2025-26 Classified Wage Schedule.
The position will remain open until filled, with screening scheduled to begin 11/7/2025. Applications received after the screening date are not guaranteed review. Documents required for submission include a cover letter and resume. Applications missing any of the listed required documents may be considered incomplete and ineligible for further review.
Candidates with disabilities requiring accommodation and/or assistance during the hiring process may contact Human Resources at 541-956-7329. Only finalists will be interviewed. All applicants will be notified by email after final selection is made. Interview costs are at applicant's expense. Final candidate will be required to show proof of eligibility to work in the United States. For positions with a degree required, only degrees received from an accredited institution will be accepted; accreditation must be recognized by the Office of Degree Authorization, US Department of Education, as required by ORS 348.609.
Public Service Loan Forgiveness
Rogue Community College is considered a qualifying public employer for the purposes of the Public Service Loan Forgiveness Program. Through the Public Service Loan Forgiveness program, full-time employees working at the College may qualify for forgiveness of the remaining balance on Direct Loans after 120 qualifying monthly payments under a qualifying repayment plan. Questions regarding your loan eligibility should be directed to your loan servicer or to the US Department of Education.
Rogue Community College is committed to a culture of civility, respect, and inclusivity. We are an equal opportunity employer actively seeking to recruit and retain members of historically underrepresented groups and others who demonstrate the ability to help us achieve our vision of a diverse and inclusive community.RCC does not discriminate in any programs, activities, or employment practices on the basis of race, color, religion, ethnicity, use of native language, national origin, sex, sexual orientation, gender identity, marital status, veteran status, disability, age, pregnancy, or any other status protected under applicable federal, state, or local laws. For further policy information and for a full list of regulatory specific contact persons visit the following webpage: www.roguecc.edu/nondiscrimination.
Benefits include family medical, dental, and vision insurance; employee life insurance; paid holidays, sick leave, vacation, contract days, and emergency leave days; 16-credit tuition waiver per quarter; membership in the Oregon Public Service Retirement Plan (OPSRP) when eligible; and eligibility for professional growth funds.
Qualifying veterans and disabled veterans may obtain additional consideration during the RCC employment process under ORS 408.230 and 408.225; OAR 839-006-435 to 839-006-0470, by submitting (attach as Other Document #1) a copy of the Certificate of Release or Discharge from Active Duty (DD Form 214 or 215).
Database Administrator / Database Engineer
LanceSoft Inc -
Waukesha, WI
Database Administrator
BTI -
Martinsburg, WV
Database Administrator
LHH US -
San Francisco, CA