Senior Database Administrator

Senior Database Administrator – CONFIRE

THIS IS A CONFIRE POSITION ONLY

CONFIRE, JPA is recruiting for a Senior Database Administrator 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 primary work location for this position is CONFIRE’s Rialto Office; occasionally, you may be required to work at the communications centers in Hesperia or San Bernardino. Job Description Under general direction of the Information Technology Manager, the Senior Database Administrator is responsible for the administration, maintenance, performance tuning, security, and availability of CONFIRE’s enterprise database environments. This position supports mission‑critical systems and applications used for public safety communications, operational reporting, administrative functions, and related business systems. The Senior Database Administrator serves as the lead technical resource for database architecture, optimization, backup and recovery, disaster recovery planning, data integrity, and database‑related troubleshooting. The incumbent also provides advanced support for data integration, ETL processes, data warehousing, and production data pipelines, while working closely with application developers, system administrators, and business users to ensure reliable and efficient database operations. Duties may include, but are not limited to: 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. Conditions of Employment Certifications: 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. Ongoing certification maintenance may be required to support evolving technologies and operational requirements. Work Availability: Must be available to work a flexible schedule, including evenings, weekends, and holidays as needed, to support critical infrastructure and respond to network incidents. Must be available to report to CONFIRE facilities in Rialto or Hesperia as required. On‑Call and Emergency Response: Participation in an on‑call rotation is required. The role may necessitate returning to work outside of regular hours to respond to network outages or mission‑critical issues. Travel: Travel between CONFIRE sites and member agency locations may be required. A valid California driver license and proof of automobile liability insurance must be presented at time of hire and maintained throughout employment. Qualifications Education: 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.

-AND-

Experience: Five (5) years of increasingly responsible professional experience in database administration, performance tuning, and enterprise data support. -OR- Experience Substitution: 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. License/Certification: Possession of a valid California Class C Driver License or ability to provide alternative transportation as required. 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. #J-18808-Ljbffr CONFIRE Joint Powers Authority (CA)