Database Architect

Job Description:

Database Architect

Description

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.

This position is not eligible for benefits.

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

Salary:

$126,664.00 - $189,996.00 Annually