Merged Promotional & Open Competitive
Database Administrator
WELCOME TO SANTA MONICA COLLEGE! This critical position will perform lead, expert level professional work in administering, planning, developing, and implementing strategic data models to ensure the availability, optimum performance, accessibility, security, efficiency and integrity of databases that are an integral part of District-wide applications. This position is scheduled to work 40 hours per week, 12 months per year on the Santa Monica College Main Campus.
Please note that all candidates must have authorization to work in the United States; the District does not have the ability to provide sponsorship.
What You Will Bring to the College
Our ideal candidate will possess substantial experience independently performing the full scope of database administration responsibilities within an Oracle environment. Additionally, it is critical that the selected employee have experience monitoring and maintaining the Banner system. Incumbents will be responsible for planning, analyzing, installing, configuring, patching and upgrading databases, as well as troubleshooting any related issues. Incumbents will provide support to users and collaborate with other IT colleagues to ensure successful implementation of application, software, and system maintenance. Experience with Oracle APEX is preferred, but not required. The ideal candidate will have experience managing databases on Unix-based systems and performing Unix Shell scripting. Finally, the ideal candidate will also have experience with Weblogic and Tomcat application servers and be knowledgeable about data and server security. Remote Work Program
Santa Monica College has a remote work program option available for employees whose job duties do not require a physical presence on College property. This position will include a combination of in-person and remote work; as such, candidates must be available to come into the office as assigned. Remote work arrangements cannot be guaranteed prior to the date of hire, and must go through a review and approval process.
Why Work at SMC?
At SMC, you will work beside a diverse group of colleagues who leverage their combined talents and passions to accomplish something great. No matter what department you are in, or what job you have, your contributions will be critical to helping our students fulfill their dreams - landing that new job, or breaking through the cycle of poverty.
Some details about us:
- We are currently the number one transfer college to UCLA, USC, the University of California system, and Loyola Marymount University
- We are dedicated to sustainable practices and are accessible via environmentally-friendly transportation options, including the Expo Line and Big Blue Bus.
- We are one of the select community colleges in California approved to award a Bachelor's degree. SMC currently awards a Bachelor's degree in Interaction Design.
Please visit www.smc.edu/aboutsmc to learn more about us and why we are Proud to Be SMC!Benefits
We value our employees as people, and recognize the value of work-life balance, the health of you and your family, and professional development. We offer a variety of benefits and perks to support new members of our team, including:
- 18 paid holidays*
- 12 paid vacation days*
- 12 paid illness days*
- Fully paid medical, dental, and vision-care coverage (including eligible dependents)
- Free mental health assistance through the Employee Assistance Service for Education (EASE) program.
- Membership in the California Public Employee Retirement System (CALPERS)
- 5% increase in base pay for every 5 years worked with SMC, up to 40 years of service.
- Waived tuition fees for classes taken at Santa Monica College.
- Reimbursement for related classes, conferences or workshops to empower your professional development.
- Free Big Blue Bus access and monthly incentives for eligible employees through the Sustainable Transportation Incentive Program
- CSEA Chapter 36 Union Membership Option
*Benefits, holidays, vacation, and illness days listed above assume a 40-hour per week, 12 month per year schedule. Benefits, vacation and illness days are prorated for other work schedules.
Salary Placement
New Employees: Generally, new employees start at the first step on the salary schedule. A new permanent classified employee may request a higher salary placement based on recruitment issues and/or additional training and experience which greatly exceeds the minimum requirements. Please note that salary placement above the third step requires additional approvals by Santa Monica College executive staff.
Current Employees: Upon promotion, the new salary for a current, permanent employee is based on Merit Rule 12.2.7. In accordance with this rule, employees are entitled to at least a one-step (5%) salary increase, and may be eligible for advanced step placement in accordance with established criteria.About the Selection Process
The selection process tentatively consists of a Qualifications Appraisal Interview (weighted 100%), which may be preceded by a Training & Experience Evaluation (pass/fail). Candidates must be successful on all test parts to be placed on the eligibility list. The eligibility list created from this recruitment will be used to fill any vacancies that occur during the one year life of the eligibility list, including full-time and/or part-time, permanent and/or temporary positions.
Santa Monica College reserves the right to modify the stated test components and weights prior to the administration of any test.
Certain positions within this classification may require employees to routinely and consistently read, speak, and/or write using a language other than English. Testing of eligible candidates’ bilingual proficiency will occur, as needed, as the District identifies positions that require this skill.
Communication for this recruitment will be via e-mail. You must check your e-mail on a regular basis to be informed of your status for this recruitment.
Test Retake Policy
Based on the District’s hiring needs, we may administer multiple recruitments for this job classification (or a related job classification that uses the same test(s)) within the next several months. Candidates must wait a period of 90 calendar days between testing appointments before retesting. Candidates who are ineligible to participate in an upcoming test or interview due to the provided retake period will be notified via email, and will have their highest valid score(s) on any non-weighted (pass/fail) test parts applied toward that recruitment.
The Santa Monica Community College District is committed to the principles of equal employment opportunity. All qualified applicants for employment, as well as District employees, shall have full and equal access to employment opportunity. No person shall be subjected to unlawful discrimination in any program or activity of the District. The District's Board Policy 3120 (Equal Employment Opportunity and Nondiscrimination in Employment) may be accessed at: https://www.smc.edu/administration/governance/documents/administrative-regulations/AR_3000_Human-Resources.pdf
Equity Statement
"Santa Monica College encourages candidates that are equity-minded to apply. SMC is a minority-serving, Hispanic-serving institution. We actively seek to attract candidates from minority groups that value equity, diversity, and inclusion. Equity, diversity, and inclusion are built into the culture at SMC, and are an essential component of the work that we do. SMC is committed to racial and socioeconomic diversity as it is a reflection of our student population and we strive to hire candidates that share this commitment."
Develops data models and long-range comprehensive database plans to support information requirements.
Develops goals and objectives to implement long-range comprehensive database plans, and conducts ongoing assessment of future implementation needs.
Performs database and application server administration duties, including database and application server and database tools and utilities installation, customization, storage and memory allocation, monitoring, tuning, and upgrades.
Determines, implements, and enhances standards on database security and develops and performs data recovery procedures to ensure backup and recovery strategies are tested and in place.
Analyzes, designs, and implements data migration and conversion plans.
Documents the database schemas; develops and maintains the data element dictionaries; establish and monitor standard table and field naming conventions.
Develops policies and procedures, and monitors and controls the redundancy of data to ensure the quality and integrity of the database environment.
Works with internal and external resources and provides recommendations on database management solutions.
Responds to database and application server problems or emergencies, and monitors database resource usage reports and performs database capacity planning.
Performs other related duties as requested or assigned.
Examples of essential duties are descriptive and not restrictive in nature and are generally listed in descending order of importance.
