What are the responsibilities and job description for the Database Architect position at San Mateo County Transit District?

Salary : $126,664.00 - $189,996.00 Annually

Location : San Carlos, CA

Job Type : Full-Time

Job Number : 2024-00166

Division : IT

Department : IT & Telecommunications

Opening Date : 01 / 31 / 2025

Closing Date : 2 / 23 / 2025 11 : 59 PM Pacific

General

The Database Architect reports to the Manager, IT Innovation & Technology or Director of IT and is responsible for managing Oracle & MS SQLSERVER databases and Middleware platforms for the San Mateo County Transit District (SamTrans), the Peninsula Corridor Joint Powers Board (JPB), and the San Mateo County Transportation Authority (TA).

The Database Architect's role is to install, monitor, maintain, and performance tune development, test and production databases while ensuring high levels of data availability. This individual is also responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software. This individual also needs to ensure successful migration of databases from on-premises to Cloud platforms.

Essential Functions & Duties

Responsible for "migration" of Oracle DB to MS Azure as native services (Azure SQL / SQLMI) or IAAS implementations on AVS (Azure VMware Solution) Platform.
Manages the design and development of databases and related master files. Oversees contributions by Systems, Operations, and Technical Support to develop and improve databases and master files.
Responsible for "migration" of older SQL databases to latest SQL releases.
Work closely with Microsoft and Oracle support team and open tickets as required.
Provides development and operational support for Oracle and MS SQL database systems.
Provides technical consulting to departments in the implementation of critical business applications.
Provides technical assistance to selected vendors in the implementation of new integrated applications.
Help train departmental users in the use of RDMS tools and applications.
Modify, test, and document forms, reports, and / or interface linkages as required.
Plans dataflows for new or revised databases, mapping out the 'conceptual design' for planned databases.
Support Disaster Recovery
Install and manage middleware platforms
Assist data team with their extract, transform & load (ETL) needs as necessary
Provide Audit data as necessary.
Supervise staff and vendors as necessary

Examples of Duties :

Guarantees the performance integrity and quality of databases.

Administer and support data replication to remote databases as required.

Administer and control database objects, including procedures, links, indices, etc.

Managers access permissions and privileges.

Writes database documentation, including data standards, procedures, and definitions for the data dictionary ('metadata').

Develop, test, implement, and document backup and recovery processes and procedures.

Monitor database status and tune performance.

Manage the installation and test of Oracle and / or MS SQL RDBMS and / or application updates, patches, application software releases, etc.

Manage Middleware platforms

Manage Cloud systems

Perform all job duties and responsibilities in a safe manner to protect oneself, fellow employees, and the public from injury or harm. Promote safety awareness and follow safety procedures to reduce or eliminate accidents.

Perform other duties as assigned.

Minimum Qualifications

Sufficient experience, training and / or education to demonstrate the knowledge and ability to successfully perform the essential functions of the position. In lieu of a degree, full time work-related experience that demonstrates the skills and experience necessary to perform this role will be accepted. Development of the required knowledge and abilities is typically obtained through but not limited to :

Bachelor's degree in computer science, management information system (MIS), or other related fields.

Five (5) years of full-time experience as a database administrator or other directly related database experience

Must be willing to work on-call and after hours as required

Preferred Qualifications :

Excellent verbal and written communication skills

Experience training and instructing at all levels.

Nice to have experience with Databases like Cosmos, PostgreSQL, MS Dataverse and MS Synapse.

Strong understanding of SQL tools such as "SSMA" and "SSRS".

Strong technical documentation skills.

Ability to conduct research into database issues, standards, and products as required.

Ability to present ideas in user-friendly language.

Keen attention to detail.

Proven analytical and problem-solving abilities.

Ability to effectively prioritize and execute tasks in a high-pressure environment.

Strong customer service orientation.

Experience working in a team-oriented, collaborative environment.

The selection process may include a panel interview, written and skills test assessments, or supplemental questions. Only those candidates who are the most qualified will continue in the selection process. Meeting the minimum qualifications does not guarantee an invitation to continue in the process.

How to Apply

Complete an online employment application by 11 : 59 p.m. of the listed closing date. A resume will not be accepted in lieu of the application. Incomplete applications will not be considered.

The Human Resources Department will make reasonable efforts in the recruitment / examination process to accommodate applicants with disabilities upon request. If you have a need for an accommodation, please contact the Human Resources Department.

We celebrate diversity and are committed to creating an inclusive and welcoming workplace environment. We are an Affirmative Action / Equal Opportunity Employer. Minorities, Women, Persons with Disabilities and Veterans are encouraged to apply.

This position is not eligible for benefits.

Why are you interested in working at the district.

Are you available for on-call or after hour work as needed?

Which statement below best describes the highest level of education you have completed?

High school graduate, diploma or the equivalent (GED)

Associate degree

Bachelor's degree

Master's degree

Professional degree

Doctorate degree

Required Question

Salary : $126,664 - $189,996

Apply for this job

Receive alerts for other Database Architect job openings

Database Architect

What are the responsibilities and job description for the Database Architect position at San Mateo County Transit District?

What is the career path for a Database Architect?

Job openings at San Mateo County Transit District

Not the job you're looking for? Here are some other Database Architect jobs in the San Carlos, CA area that may be a better fit.

We don't have any other Database Architect jobs in the San Carlos, CA area right now.

AI Assistant is available now!