Software Administrator I/II (SQL Administrator)

About the Opportunity

THE IDEAL CANDIDATE

The Behavioral Health & Recovery Services Department (BHRS) is looking for bright, ambitious, customer- focused professionals to join our IT team. BHRS is a dynamic workplace where we all strive to provide services to our customers in a responsive, progressive, and most importantly, friendly way. Candidates should be eager to apply their expertise and to learn new skills and approaches. Candidates will be challenged to broaden their horizons and step outside of their comfort zones. Candidates will need to function effectively in the service of their team's objectives. Candidates must be able to effectively communicate technical concepts to customers. The ideal candidate will be optimistic, self-motivated and believe in the power of technology to have a positive impact in the community we serve.

To learn more about the Behavioral Health & Recovery Department, click here .

Stanislaus County now offers an employee bonus worth up to $10,000!Click here for details

ABOUT THE POSITION

The BHRS IT Division is comprised of three teams: Help Desk, System Engineers, and the Data team. The Software Administrator II will primarily work with the Data team. The Data Team develops and maintains data collection tools and reports; validates data for state submissions; assists in deployment testing; provides data quality checks and analysis of data.

Software Administrator I
Under supervision, to perform a variety of software development and administration duties of simple to average difficulty; and other related duties as required.

This is the entry level professional class in the Software Administrator series. Assignments require some experience in carrying out software maintenance efforts at the departmental or enterprise level. This classification is focused on the maintenance and enhancement of existing applications, development and administration of databases, development of ETL (Extract, Transform and Load) processes as part of Data Warehouse and/or Data Marts, and reporting solutions including basic dashboards. Incumbents should have knowledge and experience with industry-standard project development methodologies. This classification is distinguished from Software Administrator II in that the latter is the fully experienced, journey level classification capable of performing more difficult and complex tasks with less supervision. Software Administrators administer enterprise solutions or critical department systems such as electronic health record, electronic medical record, Oracle Financial Management System, PeopleSoft and C-IV where the primary responsibilities are related to maintaining system availability, ETL processes for reporting purposes, using development tools to customize or enhance data entry, maintaining databases, maintaining user access and security, and system administration with limited coding. The Software Administrator series is distinguished from the Software Engineer series in that the latter classification is focused on the analysis of business needs, creates applications, designs new or enhanced programs, codes programs, develops desktop and web-based applications, and provides ongoing support to internally developed applications.

Software Administrator II
Under general supervision, to perform a variety of software development and administration duties of average to high difficulty; and other related duties as required.

This is the journey level professional class in the Software Administrator series. Assignments require expertise and experience in carrying out software maintenance efforts at the departmental or enterprise level. This classification is focused on the maintenance and enhancement of existing applications, development and administration of databases, and basic data warehousing and/or the development of basic ETL (Extract, Transform and Load) processes as part of Data Warehouse and/or Data Marts, and reporting solutions including basic dashboards. Incumbents should have knowledge and experience with industry-standard project development methodologies. This classification is distinguished from Software Administrator I in that the latter is the entry level classification performing more routine tasks under closer supervision while learning to perform more difficult and complex tasks.

Software Administrators administer enterprise or critical department systems such as electronic health record, electronic medical record, Oracle Financial Management System, or PeopleSoft and C-IV where the primary responsibilities are related to ETL processes for reporting purposes, using development tools to customize or enhance data entry, maintaining databases, maintaining user access and security, and system administration with limited coding The Software Administrator series is distinguished from the Software Engineer series in that the latter classification is focused on the analysis of business needs, creates applications, designs new or enhanced programs, codes programs, develops desktop and web-based applications and provides ongoing support to internally developed applications.

Unless otherwise provided, this position is part of the Classified Service of the County and is assigned to the Technical Services bargaining unit for labor relations purposes.

Individuals who are in a full-time classification position are required to serve a twelve-month probationary period, which may be extended an additional six months, for a total of eighteen months.

This position is subject to overtime, standby, weekend, holiday, shift, and callback assignments as identified in the MOU (Memorandum of Understanding).

The Job Task Analysis provides information detailing the physical and functional demands of the classification. For the complete job task analysis, visit the Risk Management website http://www.stancounty.com/riskmgmt/risk-dm-jta-class-sub-main.shtm

Typical Tasks

Software Administrator I
Duties may include, but are not limited to, the following:

• Assist in the administration and maintenance of complex enterprise systems, ensuring optimal performance and reliability.
• Support database management by optimizing queries, improving database performance, and troubleshooting system issues.
• Analyze and resolve software-related issues by diagnosing errors, developing solutions, and implementing best practices.
• Provide technical support and guidance to users, creating documentation, processes, and procedures to enhance software utilization.
• Develop SQL queries and design reports to extract, analyze, and present data for business needs.
• Maintain, enhance, or refactor legacy MS Access databases and other existing applications.
• Monitor system logs and performance data to proactively identify and address potential issues.
• Conduct code reviews and provide feedback to enhance software quality and maintainability.
• Install, configure, and test software updates, patches, and security enhancements.
• Ensure data integrity and security by implementing backup and recovery procedures.
• Collaborate with cross-functional teams to understand business needs and provide technical solutions to streamline workflows.
• Assist in updating IT security policies and maintaining compliance-related documentation, including Security Risk Assessments (SRAs) required under HIPAA regulations.
• Maintain comprehensive documentation for all developed applications, queries, security policies, and system processes.
• Perform additional duties as assigned to support IT operations and business initiatives.

Software Administrator II
Duties may include, but are not limited to, the following:

• Serve as a lead system administrator for enterprise-level software solutions, managing system performance, security, and scalability.
• Design, develop, and optimize relational databases within applications, ensuring data integrity and efficiency.
• Act as a primary or backup Microsoft SQL Server Administrator, overseeing database maintenance, tuning, and troubleshooting.
• Lead the development and implementation of data management solutions, including data warehouses and data marts.
• Analyze and resolve complex software and system issues, utilizing advanced debugging, testing, and troubleshooting methodologies.
• Design and implement data extraction, transformation, and loading (ETL) processes to support business intelligence initiatives.
• Enhance system functionality by developing custom scripts, automation, and integrations with third-party systems.
• Oversee the maintenance and refactoring of legacy systems, ensuring seamless transition to modernized solutions.
• Provide mentorship, guidance, and code reviews for junior software administrators, fostering professional development.
• Lead system monitoring efforts, identifying performance bottlenecks and implementing proactive solutions.
• Ensure robust security measures, compliance, and best practices for data governance and system access.
• Develop and maintain IT security policies and compliance documentation, ensuring adherence to HIPAA, and other regulatory requirements, including Security Risk Assessments (SRAs) and audit readiness.
• Collaborate with business stakeholders to assess needs, propose solutions, and implement efficient workflows.
• Supervise, train, and evaluate assigned staff members, ensuring alignment with organizational goals and industry standards.
• Perform additional duties as needed to support organizational objectives and IT strategies.

Minimum Qualifications (Knowledge, Skills, Abilities, Education/Experience)

Knowledge:
Software Administrator I

• Basic applicable development tools and applications which may include SQL, Java, Linux, Windows, GIS applications, enterprise resource planning, electronic health record and other enterprise-wide applications;
• Basic Data Warehouse concepts, methodologies, and techniques;
• Basic database design development, management, and ETL processes;
• Routine maintenance, backup, and recovery processes;
• Principles and practices of effective customer service;
• Operations, services, concepts, terms, and activities common to a comprehensive, state of-the-art information technology program; and
• Principles of database management.

Software Administrator II

• Applicable development tools and applications which may include SQL, Java, Linux, Windows, GIS applications, enterprise resource planning, electronic health record and other enterprise-wide applications;
• Data Warehouse concepts, methodologies. and techniques;
• Database design, development, management, and ETL processes;
• Maintenance, backup. and recovery processes;
• Principles and practices of effective customer service;
• Operations, services, concepts, terms. and activities common to a comprehensive, state of-the-art information technology program; and
• Principles of records and database management.

Skills/Abilities:
Software Administrator I

• Learn the operations and functions of an assigned business unit;
• Assist with application deployment, support, and maintenance;
• Basic troubleshooting and debugging of database problems;
• Implement routine recovery plans;
• Communicate clearly and concisely, both orally and in writing;
• Analyze procedures and instructions and develop logical conclusions;
• Learn to organize work, manage multiple priorities, establish procedures, and meet deadlines;
• Reason logically, draw valid conclusions and make appropriate recommendations;
• Keep current and maintain knowledge of emerging technologies in the areas of RDBMS, ETL processes and applicable programming languages and procedures;
• Learn to install, maintain, repair and modify a variety of software applications;
• Learn to write procedures and documentation for problems, solutions, and standards;
• Communicate technical issues to individuals with varying degrees of information technology knowledge;
• Establish and maintain effective working relationships with those encountered during the course of the work; demonstrate, develop and support a strong commitment to customer service;
• Work independently and as a cooperative, contributing member of a team; and
• Work with confidential and protected information and maintain confidentiality of data.

Software Administrator II

• Learn the operations and functions of an assigned business unit;
• Perform application design, deployment, support, and maintenance;
• Troubleshoot computer issues;
• Troubleshoot and debug database problems;
• Implement recovery/maintenance plans;
• Communicate clearly and concisely, both orally and in writing;
• Analyze procedures and instructions and develop logical conclusions;
• Organize work, manage multiple priorities, establish procedures, and meet deadlines;
• Reason logically, draw valid conclusions and make appropriate recommendations;
• Keep current and maintain a strong knowledge of emerging technologies in the areas of RDBMS, ETL processes and applicable programming languages and procedures;
• Install, maintain, repair and modify a variety of software applications;
• Write procedures and documentation for problems, solutions, and standards;
• Communicate technical issues to individuals with varying degrees of information technology knowledge;
• Establish and maintain effective working relationships with those encountered during the work; demonstrate, develop, and support a strong commitment to customer service;
• Work independently and as a cooperative, contributing member of a team;
• Work with confidential and protected information and maintain confidentiality of data; and
• Supervise staff, plan, assign and delegate work, monitor performance, take corrective action.

Experience and Education
Software Administrator I
PATTERN I

• Equivalent to the completion of an Bachelor’s Degree from an accredited college or university with major coursework in computer science, information technology, or a related field.

PATTERN II

• Possession of an approved information systems technology certificate, or completion of an approved information systems training course or equivalent to an Associate’s Degree from an accredited college or university with 30 units of computer related coursework; AND
• Two (2) years of related software administration, database management or related information technology experience.

PATTERN III

• Three (3) years of experience equivalent to Technology Specialist II with Stanislaus County.

Software Administrator II
PATTERN I

• Two years as a Software Administrator I with Stanislaus County.

PATTERN II

• Equivalent to the completion of an Bachelor’s Degree from an accredited college or university with major coursework in computer science, information technology, or a related field; AND
• Two (2) years of experience in database administration, software administration, GIS administration or related field.

PATTERN III

• Possession of an approved information systems technology certificate, or completion of an approved information systems training course or equivalent to an Associate’s degree from an accredited college or university with major coursework in computer science, information technology, or a related field; AND
• Four (4) years of experience in database administration, software administration, GIS administration or related field.

Software administrator I/II: License or Certificate:

• Some positions may be required to possess and maintain a valid California Driver’s License and meet County insurability requirements.

• Depending upon assignment, demonstrated technical competency and/or certification pertaining to the information technology used by the appointing department may be required. Need to add a list.

Proof of education (degree or certificate) will be required for verification purposes at the time of application. Applicants who are unable to submit proof must call (209) 525-7339 to make other arrangements before 5 pm on the final filing date. Failure to submit proof or make other arrangements before the final filing date will result in disqualification.

Application and Selection Procedures

APPLICATION PROCEDURES/FINAL FILING DATE
Applications cannot be submitted later than 5:00 p.m. on the final filing date. Make your online application as complete as possible so a full and realistic appraisal may be made of your qualifications.

Resumes will not be accepted in lieu of a completed application.
Attaching your resume and cover letter are an optional feature for those who wish to do so in addition to completing the required application. Information on your resume and cover letter will not substitute for the education, work experience and required fields on the County application. The online County application is the primary tool used to evaluate your job qualifications.
EXAMINATION PROCESS
Most County recruitment consists of the steps detailed below and are governed by Merit Principles. The examination process ensures that all applicants are given the same opportunity to gain employment within Stanislaus County.

• Application Review and Screening. Applications are carefully screened based on information provided. Those who submit incomplete applications that lack relevant qualifications or do not submit all required documents will not be invited to move on.
• Written Examination. Applicants will be invited to participate in a written exam that tests knowledge for the position.
• Oral Examination. Applicants are invited to a panel interview in which they will be evaluated by County subject matter experts.
• Eligible Lists. Candidates who pass the examination will be placed on an eligible list for that classification. Eligible lists are effective for six months, but may be extended up to eighteen months.

TENTATIVE RECRUITMENT SCHEDULE Application Deadline: April 16, 2025, at 5pm Written Exam: Tentatively the week of April 21, 2025
Oral Examination: Tentatively the Week of April 28, 2025
Note: The eligible list generated from this recruitment may be used to fill future extra-help, part-time and full-time vacancies throughout Stanislaus County .

GENERAL INFORMATION
Final appointment will be conditional upon successfully passing a County paid pre-employment drug screening (if applicable for position) and a job-related background investigation.

Some positions may require possession or the ability to obtain, and maintenance of a valid California Driver’s license or the ability to utilize an alternative method of transportation when needed to carry out job related essential functions.

Stanislaus County supports the good health of its workforce. More information is available at http://myclubwellness.org

Cell phones are typically incompatible with the online application format or browser. We recommend using a desktop or laptop computer. If you are still having technical difficulties, please call NEOGOV at 1-855-524-5627.

Benefits associated with this position can be found at Benefits Summary.

Closing Date/Time: 4/16/2025 5:00 PM Pacific

• 

• Stanislaus County

• (209) 525-6341

Show more