Database Architect

Database Architect

The Database Architect reports to the Manager, IT Technology and Telecommunications and is primarily responsible for managing MS SQLSERVER RDBMS 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). In addition to managing SQL Server the DBA will also manage Oracle Databases.

Examples of essential functions include:

• Install, monitor, maintain, and performance tune production databases while ensuring high levels of data availability.
• Develop, implement, and oversee database policies and procedures to ensure the integrity and availability of databases and their accompanying software.
• Provides development and operational support for Oracle and MS SQL database systems.
• Provides technical consulting to departments in the implementation of critical business applications.
• Provide technical assistance to selected vendors in the implementation of new integrated applications.
• Help train departmental users in the use of Relational Data Base Management System (RDMS) tools and applications.
• Modify, test, and document forms, reports, and/or interface linkages as required.
• 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.
• Plans dataflows for new or revised databases, mapping out the 'conceptual design' for planned databases.
• Backups and Recovery.
• Support Disaster Recovery.

Examples of duties include:

• 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 Middleware platforms.
• Manage Cloud systems.
• Manage the installation and test of Oracle and/or MS SQL RDBMS and/or application updates, patches, application software releases, etc.
• 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 in an effort to reduce or eliminate accidents.
• Perform other duties as assigned.

Works under the supervision of the Manager, IT Technology and Telecommunications, who establishes goals and objectives and evaluates performance.

Minimum qualifications include:

• Bachelor's degree in Computer Science, Management Information System (MIS), or other related fields.
• Four (4) years of full-time experience as a Database Architect.
• Willing to work On Call and After hours as required

Preferred qualifications include:

• Experience with managing SQL Server and Oracle Databases in the cloud.
• Strong technical documentation skills.
• Experience training and instructing at all levels.
• Ability to conduct research into database issues, standards, and products.
• Ability to present ideas in user-friendly language.
• Keen attention to detail.
• Proven analytical and problem-solving abilities.
• Good written and oral communication skills.

The selection process may consist of an evaluation of the applicant's qualifications, review of the supplemental questionnaires, panel interview, practical exercise and/or internal Department interviews. Upon completion of the selection process, an offer of employment may be conditionally based upon the successful completion of employment and education verification and criminal background check.

To apply, please visit the . Complete an online employment application and supplemental questionnaire. This is a continuous recruitment. A resume will not be accepted in lieu of the application and supplemental questionnaire. Incomplete application 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 at View phone number on click.appcast.io.

SamTrans celebrates diversity and is 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.