Software Administrator III
Stanislaus County Modesto, California, United States
- Location: Modesto, California, United States
- Categories: Administration and Management, Information Technology and Communication Services
- Job Type: Full Time
- Posted: Dec 14, 2024
Job Description:
Software Administrator III
Description
About the OpportunityThe Ideal Candidate
The Behavioral Health & Recovery Services Department (BHRS) is looking for bright, ambitious, customer-focused professional(s) 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.
About the Position
The BHRS IT Division is comprised of three teams: Electronic Health Record (EHR) support, Outcomes and Performance Measurement (OEM) and Data and Reporting Technology (DART). The Software Administrator III will primarily work with the DART team. The DART 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. This position will require extensive Project Management skills as well as team building and supervisorial skills.
This is the advanced journey level professional class in the Software Administrator series. Assignments require extensive expertise and experience in carrying out software maintenance, database administration and Data Warehousing efforts at the departmental or enterprise level. This classification is focused on the maintenance and enhancement of existing applications, identification of software solutions to improve operations, 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 dashboards. Incumbents should have strong knowledge and experience with industry-standard project development methodologies. This classification is distinguished from Software Administrator II in that the latter is the journey level classification performing complex duties under general supervision while this classification performs the most complex duties with limited direction, may be the highest-level classification in a moderately complex department and may supervise other professional staff.
The Software Administrator series administer enterprise solutions or critical department systems such as electronic health record systems and database administration platforms such as Microsoft SQL Server.
To learn more about Behavioral Health and Recovery Services, click here.
Click here for details.
Unless otherwise provided, this position is part of the Classified Service of the County and is assigned to the Mid-Management/Supervisory 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.
Incumbents may also be subject to overtime, standby, callback, weekend, holiday and shift assignments as identified in their 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 at http://www.stancounty.com/riskmgmt/ under the "Disability" tab.
Typical Tasks
Duties may include, but are not limited, to the following:
- Supervise a team of Software Administrator II's and Staff Services Analyst
- Serve as system administrator for a large enterprise-wide system as electronic health record, enterprise resource planning, or geographical information system;
- Perform database administration, design, and develop databases with an application; apply security and functionality patches and updates to the system and test pre and post production;
- Administer the GIS system, automate GIS tasks by creating scripts; complete complex analysis and create maps and other documents, organize and lead GIS user groups;
- Participate in the analysis and design of county wide solutions like Data Warehouse and Data Marts;
- Identify problems and supervise staff who provide resolutions for complex off the shelf or third-party systems, develop processed and procedures to aid staff using applications;
- Monitor system logs/performance data to identify potential problems and remedy identified issues; tune database and write solutions to improve system performance;
- Correct program problems by analyzing results of production runs, design and run test scenarios to diagnose problems; resolve data, configuration and operator errors;
- Analyze customer problems and requests; create solutions using advanced features of computer applications or creating detail program specifications for software engineers or vendors;
- Supervise the business need determination, vendor selection, and implementation of complex applications;
- Write and maintain user documentation;
- Install software packages and patches including pre-production testing; perform data conversion and package maintenance;
- Supervise, train and evaluate performance of staff;
- Ensure data is backed up; may perform data recovery or restoration;
- Provide after hours support as assigned; and
- Perform related duties as assigned
Minimum Qualifications (Knowledge, Skills, Abilities, Education/Experience)
Knowledge:
- 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;
- Principles of records and database management; and
- Principles and practices of project management.
Skill/Abilities:
- Learn the operations and functions of an assigned business unit;
- Perform application design, deployment, support, and maintenance;
- Troubleshoot and debug database problems;
- Implement recovery/maintenance plans;
- Supervise staff, plan, assign and delegate work, monitor performance, take corrective action;
- Manage project teams and user groups;
- 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 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.
- Two years as a Software Administrator II 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 journey experience in database administration, software administration, GIS administration or related field; supervisory experience desirable.
- 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 journey experience in database administration, software administration, GIS administration or related field; supervisory experience desirable.
- 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.
In addition to the qualifications referenced above, applicant screening may focus on the following desirable qualification. Please list any of these qualifications you may have within the "duties" section of the online application.
- One (1) year experience using Microsoft 365 tools, such as Power Apps, SharePoint, and Teams; AND
- One (1) year experience in programming and development in C#, MS SQL, ASP/ASP.NET, and VB for Microsoft Access, Visual Studio and ASPRunner.NET; AND
- One (1) year experience in database management in MS SQL Server, with experience in MySQL for specialized applications. Skilled in database monitoring and optimization using ApexSQL and Redgate; AND
- One (1) year experience in reporting and analytics including Report Builder and Power BI for data visualization and reporting; AND
- One (1) year experience in version control with Git, project management with Jira Software, and efficient scripting using Notepad++
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 recruitments 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: Friday, December 27, 2024
Oral Examination: Tentatively the week of January 6, 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: 12/27/2024 5:00 PM Pacific