Database Administrator (SQL Server / Azure SQL)

we are seeking an experienced SQL Server Database Administrator (DBA) to support a small development team responsible for modernizing and restructuring the city’s revenue collection systems and related database environments.

The ideal candidate will have strong hands-on experience administering Microsoft SQL Server and Azure SQL environments, with expertise in database security, performance optimization, backup and recovery, troubleshooting, and database migration.

The candidate will be responsible for maintaining database availability, ensuring data integrity, optimizing system performance, and supporting database modernization initiatives., Administer, maintain, and optimize Microsoft SQL Server databases to ensure performance, availability, and reliability.

Monitor database performance, analyze system usage, identify bottlenecks, and implement performance tuning solutions.

Establish and maintain database security standards, including user access, authentication, permissions, and role management.

Implement database backup, restoration, recovery, and archival procedures to protect critical business data.

Diagnose and resolve database performance issues, connectivity problems, and operational failures.

Plan and execute database migrations, conversions, upgrades, and transitions to new database versions or servers.

Support Azure SQL Database and Azure SQL Managed Instance administration, including security, monitoring, and backup/recovery.

Experience with database migration, conversion, upgrades, and server transitions.

Proficiency in SQL queries and T-SQL.

Knowledge of operating systems and database infrastructure.

Experience with Azure Data Factory or Azure Database Migration Service is preferred.

Ability to troubleshoot complex database issues and maintain data integrity and availability.

Education and Experience

Bachelor’s degree in Computer Science, Information Systems, or a related field.

Minimum of 2 years of experience in database management, including performance optimization, troubleshooting, and administration of hierarchical or relational database management systems.

An equivalent combination of education and relevant professional experience may be considered.

Preferred Candidate Profile

Experience supporting enterprise or government database environments.

Strong analytical, troubleshooting, and problem-solving skills.

Excellent communication and documentation abilities.

Ability to work collaboratively with technical teams, management, vendors, and business stakeholders.