{"schemaVersion":"jobsearcher.job.v1","id":"5f22b70a0a4a6c31ec260156","url":"https://jobsearcher.com/jobs/5f22b70a0a4a6c31ec260156","canonicalUrl":"https://jobsearcher.com/jobs/5f22b70a0a4a6c31ec260156","title":"MS SQL Server Database Administrator (DBA) and Developer","description":"The City of Oxnard is seeking versatile professional who can seamlessly transition between the roles of MS SQL Server Database Administrator (DBA) and Developer. The ideal candidate will be responsible for ensuring the stability, performance, and security of SQL Server databases while also contributing to database design, backup and recovery strategies, installation of new releases, and data modeling.\n\nWHAT YOU'LL DO:\n\nDatabase Administration: Manage and maintain SQL Server databases to ensure data integrity, high availability, and performance of the applications.\nT-SQL Programming: Develop, optimize, and maintain T-SQL scripts and stored procedures.\nDatabase Design: Assist in the design and implementation of database schemas, ensuring efficient data storage and retrieval.\nBackup and Recovery: Develop and implement backup and recovery plans to safeguard data against loss and corruption.\nInstallation and Upgrades: Handle the installation of new database releases and patches, ensuring minimal disruption to operations.\nPerformance Tuning: Monitor and tune database performance, including SQL Server configuration, indexes, and query execution plans.\nSecurity: Implement and manage database security measures, including user permissions and data encryption.\nTroubleshooting: Diagnose and resolve database access and performance issues.\nMaintenance: Conduct regular database maintenance activities such as index rebuilds, database reorganizations, and statistics updates.\nDocumentation: Document database configurations, processes, and procedures to ensure knowledge transfer and continuity\nModernization: Stay current with industry trends and best practices in MS SQL Server Administration and development.\nPayroll/Classification Title: Principal Business Systems Analyst\n\nWORK SCHEDULE: This is an on-site job. The normal work week is Monday through Thursday 8:00am to 6:00pm and alternating Fridays 8:00am to 5:00pm.\nPlease note:\nThe Information Technology Department supports public safety personnel including the Police Department. Therefore, as part of the selection process, applicants will be required to successfully complete a thorough background investigation, which includes a polygraph exam.\nMinimum Qualifications\nThe following are the minimum qualifications necessary for entry into the classification:\n\nEDUCATION:\nA Bachelor’s Degree from an accredited institution with major coursework in Computer Science, Information Technology, Cyber Security or a related field.\nEXPERIENCE:\n3+ years of experience as a MS SQL Server Database Administrator.\n5+ years of experience as a MS SQL Developer.\nStrong proficiency in administering MS SQL Server databases (versions 2014 and above).\nExperience with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).\nExperience with database design, development, and optimization using T-SQL.\nHands-on experience with database backup and recovery strategies.\nFamiliarity with database security best practices and principles.\nExcellent problem-solving and troubleshooting skills.\nProven experience with database documentation including ERDs.\nStrong communication and collaboration skills, with the ability to work effectively in a team environment.\nLICENSING/CERTIFICATIONS:\nValid CA Class C Driver's License\nOTHER REQUIREMENTS:\nMust be able to effectively communicate in English, both orally and in writing\n\nHighly Desirable Experience, Qualifications and/or Certifications:\nLocal government or public sector experience especially public safety (police and fire).\nExperience with high availability and disaster recovery solutions and database mirroring.\nKnowledge of performance tuning techniques and tools for MS SQL Server databases.\nExperience managing all levels of data models: conceptual, logical, and physical\nFamiliarity with cloud-based database solutions such as Azure SQL Database or Amazon RDS.\nExperience with other database solutions such as Oracle, DB2, or mySQL\nRelevant certifications such as Microsoft Certified: Azure Database Administrator Associate or Microsoft Certified: Data Management and Analytics are a plus.\nGeneral Information\nAPPLICATION PROCESS:\nSubmit NEOGOV/Government Jobs on-line application.\nComplete and submit responses to the supplemental questions, if required.\nUpload resume, cover letter, proof of degree (transcript), or other requested documents.\n\nYour application may be rejected as incomplete if you do not include the relevant information in the online application and include the information only on the resume. Applications and/or Supplemental Questionnaires that state \"see my resume\" or \"see my personnel file\" are considered incomplete and will not be accepted. Cover letters and/or optional resumes are not accepted in lieu of a completed application.\n\nThe list of qualified candidates established from this recruitment may be used to fill other full-time, part-time, and temporary assignments.\nSelected candidate(s) must pass a thorough background investigation.\nUNION MEMBERSHIP: Positions in this classification are represented by the Oxnard Mid Manager's Association (OMMA).\n\nNOTE: For most positions, the City of Oxnard relies on office automation (Microsoft Office/Google) and web-based enabled tools, therefore candidates must be proficient and comfortable with computer use to perform functions associated with on-going work.\nRegular and reliable attendance, effective communication skills, and development of effective working relationships are requirements of all positions.\n\nEmployees are required to participate in the City's direct deposit plan and are paid on a bi-weekly basis.\n\nThis position requires a 12 month probationary period.\n\nPursuant to California Government Code Section 3100, all public employees are required to serve as disaster service workers subject to such disaster service activities as may be assigned to them.\n\nEQUAL OPPORTUNITY: The City of Oxnard is an Equal Opportunity Employer and welcomes applications from all qualified applicants. We do not discriminate on the basis of race, color, religion, sex, national origin, age, marital status, medical condition, disability or sexual orientation.\n\nREASONABLE ACCOMMODATION: The City of Oxnard makes reasonable accommodation for individuals/people with disabilities. If you believe you require special arrangements to participate in the testing process, you must inform the Human Resources Department in writing no later than the filing date. Applicants who request such accommodation must document their request with an explanation of the type and extent of accommodation required.\n\nLEGAL REQUIREMENT: On the first day of employment, new employees must provide proof of citizenship or documentation of legal right to work in the United States in compliance with the Immigration Reform and Control Act of 1986, as amended. The City participates in E-Verify and will provide the federal government with your form I-9 information to confirm that you are authorized to work in the U.S. If E-Verify cannot confirm that you are authorized to work, this employer is required to give you written instructions and an opportunity to contact Department of Homeland Security (DHS) or Social Security Administration (SSA) so you can begin to resolve the issue before the employer can take any action against you, including terminating your employment. Employers can only use E-Verify once you have accepted a job offer and completed the Form I-9. For more information on E-Verify, please contact DHS. 888-897-7781 dhs.gov/e-verify\n\nIf you have any questions regarding this recruitment, please contact Jackie Ramos at jackie.ramos@oxnard.org or (805) 385-7451.\n\nNOTE: The provisions of this bulletin do not constitute an expressed or implied contract. Any provision contained in this bulletin may be modified or revoked without notice.\n\nRetirement Contributions:\nNew members (as defined by PEPRA), 2% @ 62; \"Classic\" members 2% @ 55. The employee will be required to pay a portion of their annual earnings toward their retirement. The City of Oxnard does not participate in social security.\n\nVacation/Annual Accrual Rates:\nLeave accrual rates vary between 6.24 – 11.78 hours per pay period based on years of service.\n\nAdministrative Leave:\nManagement employees are not compensated for overtime worked. However, the department director may authorize up to 40 hours of administrative leave in one year.\n\nDeferred Compensation:\nThe City contributes 1% to a deferred compensation program.\nBilingual Pay:\nA regular full time employee may receive bilingual pay at the rate of $50.00-$100.00 bi-weekly depending on the Level the employee is required to provide bilingual services as determined by the City Manager or designee.\nHealth and Dental:\nEmployees can choose from a variety of medical plans provided by the City. The City's contribution to medical coverage is outlined below:\n\nLevel One – For employees hired before January 1, 2023, the City contributes $1,543.00 per month toward medical insurance premiums and an additional $74.21 per month toward dental insurance premiums. Employees will receive cash back if the medical plan they choose is less than the City’s monthly contribution of $1,543.00 per month. Employees who waive medical insurance will receive cash back in the amount $1,243.00 per month provided they provide proof of other qualifying coverage. Any unused dental premium monies are paid to the employee. If employees hired prior to January 1, 2023 make any changes to their health plan, they will be placed in level two.\n\nLevel Two - For employees hired on or after January 1, 2023, the City will contribute $1,863.00 towards medical insurance premiums with no cash back. Employees who waive medical insurance will receive $500.00 per month cash back provided they show proof of other qualifying coverage. The City will continue to provide $74.21 per month towards dental insurance.\n\nHolidays:\nThe City observes 12 holidays per year\n\nLife Insurance:\nCity employees receive Basic Life Coverage ($5,000) + AD&D ($10,000) + 1 times annual salary 100% paid by the City. Employees also have the option to purchase additional insurance.\n\nTuition Reimbursement:\nFull-time employees are eligible for 75% reimbursement for work related coursework up to a maximum of $5000 per fiscal year.","company":"Cityofoxnar","rawCompany":"cityofoxnar","city":"Oxnard","state":"CA","isRemote":false,"isActive":false,"createdAt":"2026-04-12T20:47:25.082Z","occupations":[{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1244.00","title":"Network and Computer Systems Administrators","slug":"network-and-computer-systems-administrators"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541519","title":"Other Computer Related Services","slug":"other-computer-related-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"MS SQL Server Database Administrator (DBA) and Developer","description":"The City of Oxnard is seeking versatile professional who can seamlessly transition between the roles of MS SQL Server Database Administrator (DBA) and Developer. The ideal candidate will be responsible for ensuring the stability, performance, and security of SQL Server databases while also contributing to database design, backup and recovery strategies, installation of new releases, and data modeling.\n\nWHAT YOU'LL DO:\n\nDatabase Administration: Manage and maintain SQL Server databases to ensure data integrity, high availability, and performance of the applications.\nT-SQL Programming: Develop, optimize, and maintain T-SQL scripts and stored procedures.\nDatabase Design: Assist in the design and implementation of database schemas, ensuring efficient data storage and retrieval.\nBackup and Recovery: Develop and implement backup and recovery plans to safeguard data against loss and corruption.\nInstallation and Upgrades: Handle the installation of new database releases and patches, ensuring minimal disruption to operations.\nPerformance Tuning: Monitor and tune database performance, including SQL Server configuration, indexes, and query execution plans.\nSecurity: Implement and manage database security measures, including user permissions and data encryption.\nTroubleshooting: Diagnose and resolve database access and performance issues.\nMaintenance: Conduct regular database maintenance activities such as index rebuilds, database reorganizations, and statistics updates.\nDocumentation: Document database configurations, processes, and procedures to ensure knowledge transfer and continuity\nModernization: Stay current with industry trends and best practices in MS SQL Server Administration and development.\nPayroll/Classification Title: Principal Business Systems Analyst\n\nWORK SCHEDULE: This is an on-site job. The normal work week is Monday through Thursday 8:00am to 6:00pm and alternating Fridays 8:00am to 5:00pm.\nPlease note:\nThe Information Technology Department supports public safety personnel including the Police Department. Therefore, as part of the selection process, applicants will be required to successfully complete a thorough background investigation, which includes a polygraph exam.\nMinimum Qualifications\nThe following are the minimum qualifications necessary for entry into the classification:\n\nEDUCATION:\nA Bachelor’s Degree from an accredited institution with major coursework in Computer Science, Information Technology, Cyber Security or a related field.\nEXPERIENCE:\n3+ years of experience as a MS SQL Server Database Administrator.\n5+ years of experience as a MS SQL Developer.\nStrong proficiency in administering MS SQL Server databases (versions 2014 and above).\nExperience with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).\nExperience with database design, development, and optimization using T-SQL.\nHands-on experience with database backup and recovery strategies.\nFamiliarity with database security best practices and principles.\nExcellent problem-solving and troubleshooting skills.\nProven experience with database documentation including ERDs.\nStrong communication and collaboration skills, with the ability to work effectively in a team environment.\nLICENSING/CERTIFICATIONS:\nValid CA Class C Driver's License\nOTHER REQUIREMENTS:\nMust be able to effectively communicate in English, both orally and in writing\n\nHighly Desirable Experience, Qualifications and/or Certifications:\nLocal government or public sector experience especially public safety (police and fire).\nExperience with high availability and disaster recovery solutions and database mirroring.\nKnowledge of performance tuning techniques and tools for MS SQL Server databases.\nExperience managing all levels of data models: conceptual, logical, and physical\nFamiliarity with cloud-based database solutions such as Azure SQL Database or Amazon RDS.\nExperience with other database solutions such as Oracle, DB2, or mySQL\nRelevant certifications such as Microsoft Certified: Azure Database Administrator Associate or Microsoft Certified: Data Management and Analytics are a plus.\nGeneral Information\nAPPLICATION PROCESS:\nSubmit NEOGOV/Government Jobs on-line application.\nComplete and submit responses to the supplemental questions, if required.\nUpload resume, cover letter, proof of degree (transcript), or other requested documents.\n\nYour application may be rejected as incomplete if you do not include the relevant information in the online application and include the information only on the resume. Applications and/or Supplemental Questionnaires that state \"see my resume\" or \"see my personnel file\" are considered incomplete and will not be accepted. Cover letters and/or optional resumes are not accepted in lieu of a completed application.\n\nThe list of qualified candidates established from this recruitment may be used to fill other full-time, part-time, and temporary assignments.\nSelected candidate(s) must pass a thorough background investigation.\nUNION MEMBERSHIP: Positions in this classification are represented by the Oxnard Mid Manager's Association (OMMA).\n\nNOTE: For most positions, the City of Oxnard relies on office automation (Microsoft Office/Google) and web-based enabled tools, therefore candidates must be proficient and comfortable with computer use to perform functions associated with on-going work.\nRegular and reliable attendance, effective communication skills, and development of effective working relationships are requirements of all positions.\n\nEmployees are required to participate in the City's direct deposit plan and are paid on a bi-weekly basis.\n\nThis position requires a 12 month probationary period.\n\nPursuant to California Government Code Section 3100, all public employees are required to serve as disaster service workers subject to such disaster service activities as may be assigned to them.\n\nEQUAL OPPORTUNITY: The City of Oxnard is an Equal Opportunity Employer and welcomes applications from all qualified applicants. We do not discriminate on the basis of race, color, religion, sex, national origin, age, marital status, medical condition, disability or sexual orientation.\n\nREASONABLE ACCOMMODATION: The City of Oxnard makes reasonable accommodation for individuals/people with disabilities. If you believe you require special arrangements to participate in the testing process, you must inform the Human Resources Department in writing no later than the filing date. Applicants who request such accommodation must document their request with an explanation of the type and extent of accommodation required.\n\nLEGAL REQUIREMENT: On the first day of employment, new employees must provide proof of citizenship or documentation of legal right to work in the United States in compliance with the Immigration Reform and Control Act of 1986, as amended. The City participates in E-Verify and will provide the federal government with your form I-9 information to confirm that you are authorized to work in the U.S. If E-Verify cannot confirm that you are authorized to work, this employer is required to give you written instructions and an opportunity to contact Department of Homeland Security (DHS) or Social Security Administration (SSA) so you can begin to resolve the issue before the employer can take any action against you, including terminating your employment. Employers can only use E-Verify once you have accepted a job offer and completed the Form I-9. For more information on E-Verify, please contact DHS. 888-897-7781 dhs.gov/e-verify\n\nIf you have any questions regarding this recruitment, please contact Jackie Ramos at jackie.ramos@oxnard.org or (805) 385-7451.\n\nNOTE: The provisions of this bulletin do not constitute an expressed or implied contract. Any provision contained in this bulletin may be modified or revoked without notice.\n\nRetirement Contributions:\nNew members (as defined by PEPRA), 2% @ 62; \"Classic\" members 2% @ 55. The employee will be required to pay a portion of their annual earnings toward their retirement. The City of Oxnard does not participate in social security.\n\nVacation/Annual Accrual Rates:\nLeave accrual rates vary between 6.24 – 11.78 hours per pay period based on years of service.\n\nAdministrative Leave:\nManagement employees are not compensated for overtime worked. However, the department director may authorize up to 40 hours of administrative leave in one year.\n\nDeferred Compensation:\nThe City contributes 1% to a deferred compensation program.\nBilingual Pay:\nA regular full time employee may receive bilingual pay at the rate of $50.00-$100.00 bi-weekly depending on the Level the employee is required to provide bilingual services as determined by the City Manager or designee.\nHealth and Dental:\nEmployees can choose from a variety of medical plans provided by the City. The City's contribution to medical coverage is outlined below:\n\nLevel One – For employees hired before January 1, 2023, the City contributes $1,543.00 per month toward medical insurance premiums and an additional $74.21 per month toward dental insurance premiums. Employees will receive cash back if the medical plan they choose is less than the City’s monthly contribution of $1,543.00 per month. Employees who waive medical insurance will receive cash back in the amount $1,243.00 per month provided they provide proof of other qualifying coverage. Any unused dental premium monies are paid to the employee. If employees hired prior to January 1, 2023 make any changes to their health plan, they will be placed in level two.\n\nLevel Two - For employees hired on or after January 1, 2023, the City will contribute $1,863.00 towards medical insurance premiums with no cash back. Employees who waive medical insurance will receive $500.00 per month cash back provided they show proof of other qualifying coverage. The City will continue to provide $74.21 per month towards dental insurance.\n\nHolidays:\nThe City observes 12 holidays per year\n\nLife Insurance:\nCity employees receive Basic Life Coverage ($5,000) + AD&D ($10,000) + 1 times annual salary 100% paid by the City. Employees also have the option to purchase additional insurance.\n\nTuition Reimbursement:\nFull-time employees are eligible for 75% reimbursement for work related coursework up to a maximum of $5000 per fiscal year.","datePosted":"2026-04-12T20:47:25.082Z","dateModified":"2026-04-12T20:47:25.082Z","hiringOrganization":{"@type":"Organization","name":"Cityofoxnar","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Oxnard","addressRegion":"CA","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"5f22b70a0a4a6c31ec260156"},"url":"https://jobsearcher.com/jobs/5f22b70a0a4a6c31ec260156"}}