Senior DBA: SQL & Data Platforms

IdahoPTV; Boise (ID); Presencial; USD 50.000 - 56.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

State benefits package

Public Service Loan Forgiveness (PSLF)

PERSI retirement

Generous vacation and leave

Descripción de la vacante

The State of Idaho is hiring a Database Administrator III to design, secure, and maintain data platforms powering statewide digital services. You will work primarily with Microsoft SQL Server, with opportunities to explore MySQL, PostgreSQL, and Oracle in modernization projects.

Join a collaborative team focused on performance, security, and reliability across agency databases. Fingerprint background checks apply; Boise on-site location; state benefits and long-term career growth.

Formación

• Experience installing, administering and monitoring production databases and database servers.
• Experience training and mentoring staff on the effective and secure use of data.
• Experience monitoring and tuning the performance of databases, queries and indexes.
• Experience developing procedures and controls to ensure database security, integrity and availability.
• Experience resolving complex database problems.
• Experience in database resource planning.

Responsabilidades

• Install, configure, and maintain database server environments to support agency applications.
• Monitor availability, health, and performance across numerous production databases.
• Manage user permissions and data access across diverse agencies to meet security/compliance.
• Lead or support database migration efforts as infrastructure needs evolve.
• Design, implement, review, and update stored procedures, functions, and internal maintenance processes.
• Use SQL tracing and diagnostics tools to troubleshoot root causes of failures.
• Write SQL scripts to support maintenance, automation, or data integrity initiatives.
• Design or refine ETL processes as agency requirements change.
• Partner with development, infrastructure, and hosting teams during deployments.
• Perform performance tuning, capacity planning, and storage forecasting.

Conocimientos

Database administration

SQL Server

Performance tuning

Security & compliance

ETL processes

Stored procedures

Troubleshooting

Mentoring staff

Herramientas

Microsoft SQL Server

MySQL

PostgreSQL

Oracle

SSIS

SSRS

Azure Data Factory

Windows Server

Descripción del empleo

The State of Idaho is hiring a Database Administrator III to design, secure, and maintain data platforms powering statewide digital services. You will work primarily with Microsoft SQL Server, with opportunities to explore MySQL, PostgreSQL, and Oracle in modernization projects.

Join a collaborative team focused on performance, security, and reliability across agency databases. Fingerprint background checks apply; Boise on-site location; state benefits and long-term career growth.