Senior Database Administrator

CONFIRE Joint Powers Authority • Rialto, CA

3d • Hybrid

About The Position

CONFIRE, JPA is recruiting for a Senior Database Administrator who will be responsible for the administration, maintenance, security, performance, and availability of CONFIRE’s enterprise database environments and data management systems. This position requires advanced technical expertise in database administration, performance optimization, high availability solutions, disaster recovery planning, data integration, and database security. The Senior Database Administrator ensures the reliability, integrity, and accessibility of mission-critical data supporting public safety communications, emergency response operations, administrative services, and business applications through collaboration with internal stakeholders, member agencies, vendors, and technology partners. The primary work location for this position is CONFIRE’s Rialto Office; however, you may occasionally be required to work at the communications centers in Hesperia or San Bernardino. CONFIRE, JPA is a Joint Powers Authority (JPA) located in San Bernardino County California established to provide communications, dispatch, computer information systems support (IS), and geographic information systems (GIS) to CONFIRE member and contract agencies. The CONFIRE Communications Center's (Comm Center) primary function is to provide 24-hour/365 day direct fire, EMS, and rescue dispatch services to CONFIRE agencies. Beyond the direct fire dispatch role, Comm Center also functions as the San Bernardino County (XBO) Operational Area dispatch, which provides large incident coordination for fire, local government, and emergency medical resources on a countywide basis.

Requirements

• A bachelor's degree from an accredited college or university with major coursework in Computer Science, Information Systems, Information Technology, Database Administration, Software Engineering, or a closely related field.
• Five (5) years of increasingly responsible professional experience in database administration, performance tuning, and enterprise data support.
• OR Nine (9) years of increasingly responsible professional experience in database administration, performance tuning, and enterprise data support, including experience administering enterprise database environments, implementing backup and recovery strategies, and troubleshooting complex database systems.
• Possession of a valid California Class C Driver License or ability to provide alternative transportation as required.

Nice To Haves

• Relevant database and technology certifications such as Microsoft Certified: Azure Database Administrator Associate, Microsoft SQL Server certifications, Oracle Database certifications, AWS database certifications, or other industry-recognized credentials are highly desirable at the time of hire.
• Extensive experience with Microsoft SQL Server in an enterprise environment.
• Strong background in database performance tuning, query optimization, indexing, and workload analysis.
• Experience supporting mission-critical systems with high availability and disaster recovery requirements.
• Experience with ETL, ELT, and data warehousing concepts and tools.
• Experience monitoring and debugging production data pipelines.
• Experience with Azure SQL, cloud-based database platforms, or hybrid environments.
• Familiarity with database monitoring tools and performance analytics solutions.
• Experience with Oracle, PostgreSQL, or other relational database systems.
• Strong working knowledge of T-SQL and database scripting for automation and administration.
• Experience with PowerShell, Python, or similar scripting tools.
• Knowledge of database security controls, access management, and encryption practices.
• Experience supporting public safety, government, or public-sector systems is highly desirable.
• Strong analytical, organizational, and communication skills.
• Ability to manage multiple priorities and work effectively in a fast-paced environment.

Responsibilities

• Administer, monitor, maintain, and support enterprise database environments, with primary emphasis on Microsoft SQL Server and related database technologies.
• Install, configure, patch, upgrade, and maintain production, development, test, and reporting database instances.
• Design, maintain, and optimize database schemas, indexes, stored procedures, functions, views, triggers, and queries to support mission-critical applications.
• Analyze and tune slow-running queries, database workloads, and execution plans to improve application performance and resource utilization.
• Use performance monitoring and diagnostic tools to identify bottlenecks and recommend corrective action.
• Support database environments used for operational reporting, analytics, data warehousing, and business intelligence.
• Monitor and support ETL and ELT pipelines, including production data movement processes, scheduling, error handling, and troubleshooting.
• Support data integration tools and workflows used to move, transform, and validate data across internal and external systems.
• Maintain and improve database monitoring, alerting, and maintenance processes.
• Develop, implement, and test backup, restore, replication, clustering, failover, and disaster recovery procedures.
• Ensure databases are protected through access controls, encryption, auditing, and other security best practices.
• Implement and maintain database security standards, documentation, and administrative procedures.
• Coordinate with vendors, developers, and internal staff on database-related problems, enhancements, and system changes.
• Participate in planning and implementation of system migrations, upgrades, and new application deployments.
• Support high availability solutions and ensure database services remain available to meet operational needs.
• Perform capacity planning, workload forecasting, and resource analysis to support long-term growth and performance.
• Provide technical guidance and mentoring to IT staff on database-related matters.
• Research and evaluate database tools, performance monitoring solutions, and emerging technologies for possible use by CONFIRE.
• Prepare documentation, technical reports, recommendations, and procedures related to database administration and data management.
• Participate in after-hours support, scheduled maintenance windows, and emergency response activities as required.
• Provide vacation or temporary relief as required.
• Perform other related duties as assigned.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior