Advanced/Senior Systems Engineer, DBA

Job Description:

Advanced/Senior Systems Engineer, DBA

Description

ABOUT US

At the County of Marin, our employees overwhelmingly report feeling their work is meaningful, they like the work they do, and they are proud to tell people “I work for the County of Marin.” Discover more about us, our values and our organizational culture on the Department of Human Resources website . Read on to find out more about this opportunity.

About the Information Service and Technology (IST) Department : Marin County IST connects the people of Marin with their government by providing innovative products and services tailored to the needs of our departments and communities accessible anytime, anywhere. We provide centralized IT services to County departments across four key areas: Business Solutions Delivery, Enterprise Platforms & Services, Information Security & Compliance, and IT Governance & Operations.

In addition to a full benefits package that includes Medical, Dental, Vision, Pension/Retirement, deferred compensation, and flexible spending accounts, we offer our employees:

• Hybrid (telework/onsite) work schedules
• Options for Alternative Work Schedules (such as 4-5/9’s)
• A culture of public service collaboration and work/life balance
• Training and career development opportunities
• County benefits such as Employee Assistance Program (EAP) and Tuition Assistance Program (TAP)

ABOUT THE POSITION

There is one vacancy in the Information Services and Technology Department which will be filled at the Advanced Systems Engineer OR the Senior Systems Engineer. Candidates will be considered for the level(s) for which they meet minimum qualifications and assignment-specific requirements.
The Database Administration (DBA)Team is part of the Data Unit of the Information Services and Technology (IST) department. Advanced and Senior Systems Engineers on the DBA team play key technical roles in this team; the work blends traditional SQL Server database administration responsibilities with exciting new opportunities to support modern data infrastructure and contribute to enterprise data initiatives.

This position is ideal for a hands-on DBA who is passionate about managing data systems, building robust data integrations, and helping drive data accessibility and usability across the County. This role also provides an opportunity to collaborate with other engineers and technicians as well as skilled professionals outside of the IST department.

In this position, you will have responsibility for:

Core Database Administration:

• Install, configure, and maintain Microsoft SQL Server environments.
• Monitor database performance, job execution, and alerts.
• Manage database security, backups, and disaster recovery protocols.
• Create and maintain automated SQL Agent jobs, SSIS packages and SFTP processes.
• Support data/application migrations and troubleshoot database issues.
• Configure, manage, and maintain SQL Server Reporting Services (SSRS) environments, including site architecture, folder structures, and report deployment.
• Maintain documentation related to database procedures and standards.
• Review and execute change scripts.
• Collaborate with developers, system administrators, application teams, and analysts, to implement best practices, ensure database integrity, and deliver clean, reliable data across systems.

Enterprise Data & Integration Work:

• Support the development of the County’s Enterprise Data Architecture by working with diverse source systems and structured/unstructured data.
• Extract, transform, and load data into modern data models and repositories.
• Assist in building and supporting modern data platforms, including cloud data lakes and warehouses.

The Advanced level engineer is the advanced journey level in the Systems Engineer series, and performs complex technical assignments with minimal supervision, occasional instruction and assistance, and review of final products.

The Senior level engineer is the technical specialist level in the series and works with greater latitude to define the parameters and work methods of assignments. They typically manage projects independently and provide guidance to less experienced team members.

Work Schedule and Remote Work Options: Occasional night and weekend work is required for tasks that cannot be performed during normal work hours.

Some duties for this position may be performed remotely and options for a hybrid (telework/onsite) work schedule are available. However, engineers on this team must be able to work onsite in San Rafael on a weekly basis and to report for various meetings and work assignments upon short notice, as needed and when deemed appropriate.

ABOUT YOU

Our Highly Qualified Candidate is self-driven, curious, and passionate about the power of data. They have a strong foundation in SQL Server database administration and are interested in working on data architecture, cloud platforms, and modern integration tools. They thrive in a collaborative team environment, enjoy problem-solving, and possess strong verbal and written communication skills.

The highly qualified candidate will also have:

• Strong experience administering Microsoft SQL Server environments, including performance monitoring, query tuning, and troubleshooting.
• Proven ability to design, implement, and maintain SSIS packages and SSRS reports.
• Proficiency in writing and reviewing complex queries and procedures.
• Working knowledge of version control tools such as GitHub and TFS; experience using Visual Studio in a database development context.
• Understanding database replication and batch operations.
• Experience with automation scripting, including PowerShell and automated file transfers (e.g., SFTP).
• Exposure to or experience with cloud-based data platforms (e.g., Amazon S3, Azure Data Lake), modern integration tools (e.g., AWS Glue, Azure Data Factory), and foundational concepts in data warehousing and cloud-native architecture.
• Awareness of data governance and cataloging tools, such as Microsoft Purview or AWS Glue Data Catalog.
• Familiarity with Python, R (desirable but not required).

ADDITIONAL QUALIFICATIONS
Knowledge of:

• Computer hardware platforms, operating systems, and middleware systems.
• Middleware products and deployment of multi-tier components.
• Information Security Principles.
• Principles of customer support and service.
• Principles and practices of technical problem solving.
• Testing standards and procedures.
• Principles and practices of project management, work planning, and status reporting.

Senior Systems Engineer (in addition to the above):

• Design of multi-tier environments.
• Principles and techniques of application and systems analysis and design

Ability to:

• Analyze and resolve problems in applications, and software and hardware integration.
• Apply technology to provide business solutions.
• Create, modify, test, and implement applications using programming languages, database services, middleware services, web services and office automation services.
• Communicate effectively both orally and in writing.
• Analyze and resolve complex problems, including applications, and hardware and software integrations.
• Work effectively with clients, peers, and support teams to define business requirements, provide support for software, hardware, and applications, and ensure that tasks are completed accurately and in a timely manner.

Senior Systems Engineer (in addition to the above):

• Design systems that meet defined requirements, and document system designs for development, implementation, testing and client use.
• Research potential solutions and make recommendations for implementation; and apply technology to provide business solutions.
• Develop solutions and recommend technology to provide target business outcomes.

MINIMUM QUALIFICATIONS:

Both Levels: Any combination of professional experience, certification, and/or relevant coursework that demonstrates the necessary knowledge and abilities. Examples include:

• Twelve (12) semester units of coursework from an accredited program and in a discipline relevant to the assignment is equivalent to a full year of related professional experience.
• A completed certification program relevant to the assignment and knowledge and abilities necessary of the role.
• A training program with evidence of completion providing the knowledge and abilities necessary of the role.
• An internship and/or apprenticeship providing the required knowledge and abilities of the role.
• Relevant professional experience demonstrating knowledge and abilities necessary of the role.

Advanced Systems Engineer: Any four-year combination of professional experience, certification, and/or relevant coursework that demonstrates the necessary knowledge and abilities listed above.

Senior Systems Engineer: Any six-year combination of professional experience, certification, and/or relevant coursework that demonstrates the necessary knowledge and abilities listed above.

Special Sub-class Recruitments: Recruitments for positions in this class may be conducted according to the program or department in which a vacancy exists and the special certificates, licenses and/or experience requirements of the position. Recruitment for these positions may be conducted to include bilingual ability according to the needs of the department.

IMPORTANT INFORMATION

All applicants will receive email notifications regarding their status in the recruitment process. Please be sure to check your spam settings to allow our emails to reach you. You may also log into your GovernmentJobs.com account to view these emails.

Testing and Eligible List: Depending on the number of qualified applications received, the examination may consist of a highly qualified review, application screening, online assessment, written examination, oral examination, performance examination, or any combination to determine which candidates' names will be placed on the eligible list. The eligible list established from this recruitment may be used to fill the current vacancy, and any future vacancies for open, fixed-term, full-time or part-time positions which may occur while the list remains active.

Disaster Service Workers: All County of Marin employees are designated Disaster Service Workers through state and local law (California Government Code Section 3100-3109). Employment with the County requires the affirmation of a loyalty oath to this effect. Employees are required to complete all Disaster Service Worker-related training as assigned, and to return to work as ordered in the event of an emergency.

Equal Employment Opportunity Employer: If you have questions regarding equal employment opportunities, please contact Roger Crawford, Equal Employment Opportunity Director, at 415-473-2095. If you have questions concerning this position announcement, please contact Catherine Heckendorf at Catherine.Heckendorf@MarinCounty.gov.

PLEASE NOTE: The benefits described herein do not apply to temporary (contingent) or to part-time employees that work less than 50%.

COUNTY OF MARIN BENEFITS: GENERAL
Below are some of the excellent benefits the County offers. More information about our benefits can be found on the Marin County's Benefits Homepage .

Paid Time Off : Competitive vacation accrual; 12 holidays per year; and generous sick leave accruals. Additional types of paid leaves are available for some bargaining units.

Health Plan : Choice of four health plans (two Kaiser HMOs, Western Health Advantage HMO, and an Anthem Blue Cross PPO) along with dental through Delta Dental PPO, and vision through Vision Service Plan (VSP). There is a County contribution toward the premiums (the contribution amount varies depending on coverage tier elected such as employee only, employee + 1, employee + family). Plus, the County offers excellent Life Insurance, Disability, Flexible Spending Plans, a Dependent Care Assistance Program, professional development and more.

Retirement : Defined benefit plan under the County Employees Retirement Act of 1937. More information can be found online at www.mcera.org.

IRS 457 Plan : Choice of pre-tax or post-tax (Roth) employee contribution up to the IRS annual maximum.

Retiree Medical : The County provides access to group health plan coverage to eligible retirees.

For specific questions regarding the employment process, please contact Human Resources at (415) 473-6104. For additional details about the benefits or retirement, please contact the Benefits Division at (415) 473-2197.

*IMPORTANT NOTE: Benefits described herein do not represent a contract and may be changed without notice.

Closing Date/Time: Continuous

Salary:

$109,531.50 - $141,082.50 Annually