Database Administrator 2025
Apply NowCompany: Santa Monica College
Location: Santa Monica, CA 90405
Description:
Salary : $126,648.00 - $153,948.00 Annually
Location : 1900 Pico Blvd. Santa Monica 90405, CA
Job Type: Full-time, Permanent
Job Number: DBA2025
Department: Information Technology
Opening Date: 04/02/2025
Closing Date: 4/23/2025 11:59 PM Pacific
Description
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 work40 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. Currently, employees must come into the office one day per week, though the in-office requirement will be greater at the start of employment as the employee learns the District's database systems and procedures. 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:
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:
*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 six month 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:
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."
Examples of Duties
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.
Minimum Qualifications
Education Requirement:
Bachelor of Science degree in Computer Science or closely related field from an accredited university or college.
Experience Requirement:
Four (4) years of experience with databases, database application servers, Web application servers, and n-tier systems architecture administration in a large-scale Oracle environment.
Education/Experience Equivalency:
Experience and/or education of the same kind, level or amount as required in the minimum qualifications may be substituted on a year-for-year basis.
Supplemental Information
For additional information about our employment process, please visit our page and click on "current employees" (for existing, permanent SMC employees) or "job applicants" (for external applicants).
Santa Monica College offers a comprehensive benefits package including vacation, holiday, and sick leave as well as medical, dental, vision, and life insurance for permanent positions. Permanent full-time positions of 35 hours or more receive fully paid District benefits. Permanent position assignments of 20 to 34 hours per week receive a pro-rated benefits package as outlined in CSEA Chapter 36 Bargaining Agreement.
Temporary positions and permanent position assignments of less than 20 hours per week do not have a benefits package.
For more information visit the following link:
01
Santa Monica College is not able to provide sponsorship for employment.If hired for this position, can you legally work in the USA without sponsorship from Santa Monica College?
02
To participate in the selection process, all candidates must meet the minimum education and experience requirements for this job. The following supplemental questions will help us determine if you meet these requirements. In addition, this process is designed to further evaluate your qualifications beyond the minimum requirements as part of a Training & Experience Evaluation (). You are required to answer each of the questions truthfully and completely - do not refer us to your resume. Only the highest scoring candidates will move forward to the next step in the hiring process. Your answers MUST be supported by the information you have entered in your general application and are subject to verification; responses which cannot be supported by information contained in your application will be deemed invalid. Falsification, exaggeration, and misrepresentation will result in your disqualification.Do you agree to answer the following questions truthfully and completely AND understand that falsification or overstatement of your qualifications is grounds for disqualification of your application?
03
Candidates must possess four (4) years of experience with databases, database application servers, Web application servers, and n-tier systems architecture administration in a large-scale Oracle environment. Do you meet this experience requirement? Please Note: Additional qualifying education, beyond what is listed in the minimum education requirement, may substitute for missing experience on a year-for-year basis (30 semester/45 quarter units = 1 year experience).
04
Candidates must possess a Bachelor's degree in Computer Science or closely related field from an accredited university or college. Do you meet this education requirement? Please Note: Additional qualifying experience, beyond what is listed in the minimum experience requirement, may substitute for missing education on a year-for-year basis (30 semester/45 quarter units = 1 year of experience).
05
At a later date, you may be required to present educational degrees or transcripts verifying completion of the education listed in your application. Please ensure that you have access to these documents. I understand and agree to follow these instructions.
06
Do you have a relative, domestic partner or member of your household employed at Santa Monica College? This includes a spouse, domestic partner, or co-habitant; a child, including adopted, in-laws and step- or half-parent; a grandchild, including adopted, in-laws and step- or half-grandparent; a sibling, including in-laws and step- or half-; any other member of the employee's household whether or not related by blood or marriage; and children and family members of siblings and spouses.
07
If you DO HAVE a relative, domestic partner or member of your household employed at Santa Monica College, please provide the employee's name and the department in which they work. If you DO NOT, please type NA.
08
The following questions will be reviewed and evaluated as part of the Training and Experience Evaluation test part (please see question #2 for more details). Please provide a thorough response to the following questions and address all parts of the questions asked. Please do not refer us to your resume. Your responses to the following questions will be reviewed and scored at a later date by a panel of subject matter experts; only the best qualified candidates will be eligible to proceed in the hiring process. As such, please be thorough when responding to the questions below. I understand the instructions provided.
09
Please discuss your experience planning and administering databases, application servers, and n-tier systems architecture administration in a large-scale Oracle environment. In your response, please include: (1) Job title(s) and dates of employment when you gained this experience, (2) An overview of the work you performed and the scope of your responsibility for the areas mentioned above (3) The typical size of databases that you oversaw and the typical number of users. If you do not have experience in this area, please type N/A.
10
Please describe your experience performing database and accompanying software administration activities for the Banner ERP system. In your response, please include: (1) Job title(s) and dates of employment when you gained this experience, (2) An overview of the work you performed and the scope of your responsibility If you do not have experience in this area, please type N/A.
11
Please describe your experience using Unix operating systems, and developing scripts using Unix Shell, to administer databases and support specific applications. In your response, please include: (1) Job title(s) and dates of employment when you gained this experience, (2) An overview of the work you performed and the scope of your responsibility If you do not have experience in this area, please type NA
12
Please discuss your experience managing Weblogic application server and Tomcat application server and application deployment. In your response, please include: (1) Job title(s) and dates of employment when you gained this experience, (2) An overview of the work you performed and the scope of your responsibility If you do not have experience in this area, please type N/A.
13
Please discuss any experience you have with Oracle APEX within the Oracle database environment. In your response, please include: (1) Job title(s) and dates of employment when you gained this experience, (2) An overview of the work you performed and the scope of your responsibility If you do not have experience in this area, please type N/A.
Required Question
Location : 1900 Pico Blvd. Santa Monica 90405, CA
Job Type: Full-time, Permanent
Job Number: DBA2025
Department: Information Technology
Opening Date: 04/02/2025
Closing Date: 4/23/2025 11:59 PM Pacific
Description
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 work40 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. Currently, employees must come into the office one day per week, though the in-office requirement will be greater at the start of employment as the employee learns the District's database systems and procedures. 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.
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
- 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 six month 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:
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."
Examples of Duties
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.
Minimum Qualifications
Education Requirement:
Bachelor of Science degree in Computer Science or closely related field from an accredited university or college.
Experience Requirement:
Four (4) years of experience with databases, database application servers, Web application servers, and n-tier systems architecture administration in a large-scale Oracle environment.
Education/Experience Equivalency:
Experience and/or education of the same kind, level or amount as required in the minimum qualifications may be substituted on a year-for-year basis.
Supplemental Information
For additional information about our employment process, please visit our page and click on "current employees" (for existing, permanent SMC employees) or "job applicants" (for external applicants).
Santa Monica College offers a comprehensive benefits package including vacation, holiday, and sick leave as well as medical, dental, vision, and life insurance for permanent positions. Permanent full-time positions of 35 hours or more receive fully paid District benefits. Permanent position assignments of 20 to 34 hours per week receive a pro-rated benefits package as outlined in CSEA Chapter 36 Bargaining Agreement.
Temporary positions and permanent position assignments of less than 20 hours per week do not have a benefits package.
For more information visit the following link:
01
Santa Monica College is not able to provide sponsorship for employment.If hired for this position, can you legally work in the USA without sponsorship from Santa Monica College?
- Yes
- No
02
To participate in the selection process, all candidates must meet the minimum education and experience requirements for this job. The following supplemental questions will help us determine if you meet these requirements. In addition, this process is designed to further evaluate your qualifications beyond the minimum requirements as part of a Training & Experience Evaluation (). You are required to answer each of the questions truthfully and completely - do not refer us to your resume. Only the highest scoring candidates will move forward to the next step in the hiring process. Your answers MUST be supported by the information you have entered in your general application and are subject to verification; responses which cannot be supported by information contained in your application will be deemed invalid. Falsification, exaggeration, and misrepresentation will result in your disqualification.Do you agree to answer the following questions truthfully and completely AND understand that falsification or overstatement of your qualifications is grounds for disqualification of your application?
- Yes
- No
03
Candidates must possess four (4) years of experience with databases, database application servers, Web application servers, and n-tier systems architecture administration in a large-scale Oracle environment. Do you meet this experience requirement? Please Note: Additional qualifying education, beyond what is listed in the minimum education requirement, may substitute for missing experience on a year-for-year basis (30 semester/45 quarter units = 1 year experience).
- Yes, I meet this experience requirement
- No, I do not meet this experience requirement. However, I have additional education (beyond the minimum required) that can fully substitute for the missing experience.
- I do not meet the experience requirement, and do not possess additional education that can substitute for this experience.
04
Candidates must possess a Bachelor's degree in Computer Science or closely related field from an accredited university or college. Do you meet this education requirement? Please Note: Additional qualifying experience, beyond what is listed in the minimum experience requirement, may substitute for missing education on a year-for-year basis (30 semester/45 quarter units = 1 year of experience).
- Yes, I meet this education requirement.
- No, I do not meet this education requirement. However, I have additional experience (beyond the minimum required) that can fully substitute for the missing education.
- I do not meet the education requirement, and do not possess additional experience that can substitute for the missing education.
05
At a later date, you may be required to present educational degrees or transcripts verifying completion of the education listed in your application. Please ensure that you have access to these documents. I understand and agree to follow these instructions.
- Yes
- No
06
Do you have a relative, domestic partner or member of your household employed at Santa Monica College? This includes a spouse, domestic partner, or co-habitant; a child, including adopted, in-laws and step- or half-parent; a grandchild, including adopted, in-laws and step- or half-grandparent; a sibling, including in-laws and step- or half-; any other member of the employee's household whether or not related by blood or marriage; and children and family members of siblings and spouses.
- Yes
- No
07
If you DO HAVE a relative, domestic partner or member of your household employed at Santa Monica College, please provide the employee's name and the department in which they work. If you DO NOT, please type NA.
08
The following questions will be reviewed and evaluated as part of the Training and Experience Evaluation test part (please see question #2 for more details). Please provide a thorough response to the following questions and address all parts of the questions asked. Please do not refer us to your resume. Your responses to the following questions will be reviewed and scored at a later date by a panel of subject matter experts; only the best qualified candidates will be eligible to proceed in the hiring process. As such, please be thorough when responding to the questions below. I understand the instructions provided.
- Yes
- No
09
Please discuss your experience planning and administering databases, application servers, and n-tier systems architecture administration in a large-scale Oracle environment. In your response, please include: (1) Job title(s) and dates of employment when you gained this experience, (2) An overview of the work you performed and the scope of your responsibility for the areas mentioned above (3) The typical size of databases that you oversaw and the typical number of users. If you do not have experience in this area, please type N/A.
10
Please describe your experience performing database and accompanying software administration activities for the Banner ERP system. In your response, please include: (1) Job title(s) and dates of employment when you gained this experience, (2) An overview of the work you performed and the scope of your responsibility If you do not have experience in this area, please type N/A.
11
Please describe your experience using Unix operating systems, and developing scripts using Unix Shell, to administer databases and support specific applications. In your response, please include: (1) Job title(s) and dates of employment when you gained this experience, (2) An overview of the work you performed and the scope of your responsibility If you do not have experience in this area, please type NA
12
Please discuss your experience managing Weblogic application server and Tomcat application server and application deployment. In your response, please include: (1) Job title(s) and dates of employment when you gained this experience, (2) An overview of the work you performed and the scope of your responsibility If you do not have experience in this area, please type N/A.
13
Please discuss any experience you have with Oracle APEX within the Oracle database environment. In your response, please include: (1) Job title(s) and dates of employment when you gained this experience, (2) An overview of the work you performed and the scope of your responsibility If you do not have experience in this area, please type N/A.
Required Question