Senior Database Administrator

About the role

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.

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.
• 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.
• 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.
• Perform other related duties as assigned.

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.
• 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.
• 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.

Qualifications

• Education: Bachelor's Degree in Computer Science, Information Systems, Information Technology, Database Administration, Software Engineering, or a closely related field.
• Experience: Five (5) years of increasingly responsible professional experience in database administration, performance tuning, and enterprise data support.
• License/Certification: Valid California Class C Driver License or ability to provide alternative transportation as required.
• Desired Qualifications: 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.