Database administrator jobs in San Marcos, CA

Maintaining efficiency and economy in operations management requires flexibility in job assignments. While each employee shall have a primary responsibility for the job in which that employee has been hired or later promoted to, each employee may be expected to perform other jobs from time to time. SUMMARY: 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. Application Review: Priority will be given to applications received by December 5, 2025. The position will remain open until filled. EXAMPLES OF DUTIES: Essential Functions 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. Duties May Include, But Are Not Limited To, The Following: 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. QUALIFICATIONS: Knowledge, Skills, and Abilities 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. Special Skills/Knowledge Knowledge of: 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. Oracle is a plus. Physical Requirements The successful candidate must be able to fulfill the physical demands of the job such as walking, stooping, sitting, bending, reaching for overhead files and occasional lifting (must be able to lift up to 15 pounds). Must be able to perform tasks involving manual dexterity, such as use of a computer and 10-key. Work will at times require more than 8 hours per day or an irregular work week to perform the essential duties of the position. Duties will be performed primarily in an office type environment and must be able to work on-call. Experience/Education/Certificates/Licenses 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. Prior experience as the strategic leader in database architecture, cloud integration, performance optimization is a plus. Must possess and maintain a valid California Driver License or be able to utilize alternative transportation when needed to perform job-related essential functions. 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 GENERAL: Must satisfactorily pass all applicable post-offer examinations, including but not limited to a pre-employment physical conducted by an independent medical provider, a comprehensive criminal background check, and, when applicable, a pre-employment drug test as required by MTS Board Policy 35. SALARY RANGE: The anticipated starting pay for this position is between $113,000 - $130,000. This range represents the expected starting salaries for new hires, typically within the lower to mid-portion of the overall salary range, which encompasses the full potential earnings for the role. Candidates with salary expectations outside of the anticipated hiring range may reach out to the Talent Acquisition Specialist facilitating this recruitment for more information. Salary offers are based on factors such as the knowledge, skills, abilities, and relevant experience of the successful candidate, while taking into account internal equity, budget constraints, and other market factors. This position is in salary grade #13, which has a minimum of $112,095 and a maximum of $159,175. Salary grades are typically adjusted annually to ensure they remain market competitive. DISCLAIMER: The above-described job elements are intended to indicate the general nature and levels of work being performed by employees assigned to the job. They are not intended to be an exhaustive list of duties, responsibilities and skills required of employees so classified. Management retains the discretion to add to or change the duties of the position at any time. EEO is The Law - Equal Opportunity Employer Minorities/Women/Protected Veterans/Disabled MTS is an Equal Opportunity Employer with an ongoing commitment to treat all people, including customers, co-workers and the public at large, with dignity and respect. As a public transportation agency, MTS is committed to providing an inclusive workplace that reflects the diverse communities in which we work and live. MTS supports and promotes an environment that is free of discrimination and harassment. MTS recruits, hires, trains and promotes individuals without regard to race, color, sex, religion, ancestry, national origin, age, gender, marital status, medical condition, pregnancy, physical or mental disability, genetic information, gender identity, gender expression, sexual orientation and military status, veteran status or any other status protected by federal, state or local law. MTS encourages veterans, military spouses and people from different backgrounds to apply for open positions for which they are interested. Additionally, MTS employees are encouraged to refer qualified candidates from all backgrounds and age groups. At MTS, we are committed to a fair and equitable workplace where everyone is a respected and valued member of the team.