San Diego Metropolitan Transit System (MTS) ยท 3 hours ago
Senior Database Administrator
San Diego, CA
Full-time
Onsite
Senior Level
$113K/yr - $130K/yr
6+ years expSan Diego Metropolitan Transit System (MTS) is seeking a Senior Database Administrator (DBA) to oversee the administration and maintenance of the MS SQL server database infrastructure. The role involves ensuring database integrity, backup, restoration, and performance monitoring while collaborating with IT staff and other departments.
Customer ServiceRailroadTransportation
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
Qualification
Required
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
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
Knowledge of MS SQL Server 2014/16/19/22
Knowledge of Azure SQL Database
Knowledge of Windows Server 2016/19/22/25
Knowledge of T-SQL and writing and maintaining scripts and queries
Knowledge of MS SSIS, DTS, triggers and stored procedures
Knowledge of reporting tools, in particular MS SSRS and Business Objects
Knowledge of Extract Transform Load (ETL) process
Knowledge of Enterprise Data Warehouse concepts, MS SQL Server enterprise database administration standards, processes and procedures
Knowledge of Enterprise MS SQL backup and disaster-recovery processes, procedures, policies and best practices
Knowledge of performance tuning, design and implementation of high availability database architecture
Preferred
Prior experience as the strategic leader in database architecture, cloud integration, performance optimization is a plus
Experience with CommVault desirable
Oracle is a plus
Current Certifications in one or more of the following are highly desirable: Microsoft Certified Database Administration (MCDBA) (Legacy), Microsoft Certified Azure Database Administrator Associate, Microsoft Certified Azure Data Engineer Associate
Company
San Diego Metropolitan Transit System (MTS)
As the largest provider of public transportation in San Diego County, the Metropolitan Transit System (MTS) is committed to providing exceptional service to the people of the San Diego region.
1001-5000 employees
Funding
Current Stage
Late StageLeadership Team
Sharon Cooney
Chief Executive Officer
Larry Marinesi
Chief Financial Officer
Company data provided by crunchbase