Senior Database Administrator

San Diego Metropolitan Transit System (MTS)•San Diego, CA

2h•$113,000 - $130,000

About The Position

Under the direction of the Information Technology Operations Manager, the Senior Database Administrator (DBA) is responsible for the administration and maintenance of the MS SQL server database infrastructure and dependent systems. The Senior DBA acts as the primary technical resource for database integrity, backup and restoration, and performance monitoring.

Requirements

Knowledge of or ability to learn MTS policies and regulations; ability to read, understand and apply MTS policies, regulations and union labor contracts; ability to write letters, memoranda and reports using clear, concise and grammatically correct English; ability to speak clearly, distinctly and effectively in person-to-person or small group situations using tact and diplomacy; ability to coordinate and initiate actions necessary to implement decisions and delegate responsibilities to appropriate personnel; ability to establish and maintain priorities in order to complete assignments by deadlines without detailed instructions; skill in verifying the accuracy and completeness of forms and reports; knowledge of Microsoft Office Suite and the ability to learn and use other software that MTS might have or acquire; exceptional verbal and written communication skills; ability to clearly communicate complex technical concepts to individuals or groups with varying technical understanding; exceptional organizational, prioritization and multi-tasking skills; exceptional interpersonal skills and understanding of customer relationship management; exceptional collaborative and team-centric working style; good stress-management coping skills and ability to work well under pressure.
MS SQL Server 2014/16/19/22
Azure SQL Database
Windows Server 2016/19/22/25
T-SQL and writing and maintaining scripts and queries
MS SSIS, DTS, triggers and stored procedures
Reporting tools, in particular MS SSRS and Business Objects.
Extract Transform Load (ETL) process
Enterprise Data Warehouse concepts, MS SQL Server enterprise database administration standards, processes and procedures.
Enterprise MS SQL backup and disaster-recovery processes, procedures, policies and best practices (experience with CommVault desirable).
Performance tuning, design and implementation of high availability database architecture.
Possess a bachelor’s degree from an accredited college or university in computer science, information technology, management information systems, or related field.
Must have a minimum of six (6) years of experience administering MS SQL server databases in an enterprise environment.
Experience with managing data integrity and replication, monitoring database health and security, tuning database objects, ETL systems and storage capacity planning is required.
Must possess and maintain a valid California Driver License or be able to utilize alternative transportation when needed to perform job-related essential functions.

Nice To Haves

Oracle is a plus.
Prior experience as the strategic leader in database architecture, cloud integration, performance optimization is a plus.
Microsoft Certified Database Administration (MCDBA) (Legacy)
Microsoft Certified Azure Database Administrator Associate
Microsoft Certified Azure Data Engineer Associate

Responsibilities

Administers, monitors, maintains, upgrades and troubleshoots existing database infrastructure across development, testing, and production database environments.
Designs, implements, and improves new database infrastructure components, applications, interfaces, replications, SSIS packages, stored procedures, etc.
Develops, documents, and maintains enterprise best practices standards and procedures for database creation, upgrades, patches, backups, restoration, replication, index maintenance, tuning, monitoring, alerting, and security.
Performs and monitors regular data imports from disparate internal and external systems, ranging from fully automated to manual processes, in order to meet the MTS operational reporting requirements.
Performs required server and software patches in conjunction with Datacenter Operations schedules and System Administrators (may require after-hours support).
Establishes and maintains security and access controls for MTS database systems, applications, data, indexes, database services, replication packages, and processes in conjunction with Datacenter Operations and System Administrators.
Creates and maintains documentation for databases, database infrastructure and database processes and procedures.
Evaluates emerging database technologies and recommends adoption strategies to improve scalability and performance.
Architects and manages high-availability and disaster recovery solutions using SQL Server Always On and cloud-native tools.
Leads strategic planning and implementation of database technologies across on-premises and cloud environments.
Maintains business critical replication infrastructure, including legacy systems.
Designs and executes database queries and data analysis in response to requests from MTS departments.
Creates and maintains documentation for databases, database infrastructure and database processes and procedures.
Collaborates with IT staff, MTS departments, and SAP support personnel in the design, development, tuning and troubleshooting of database infrastructure, services, servers and applications.
Contributes to the IT Disaster Recovery Plan through yearly review and update.
Performs other duties as assigned.