Database Analyst

With a network of nearly 200 branches, Loomis armored transportation, cash management centers, and cash inventory vaults keep cash flowing throughout financial institutions and retail businesses across the US. Loomis prides itself on providing employees with opportunities for career advancement and job satisfaction. In fact, many of our company's managers, vice presidents, and corporate executives started out in the branches as driver/guards and tellers. Our work can be challenging, but the thousands who have stayed with our company for decades will tell you that if you have the desire to learn and the drive to succeed, Loomis is the place to be. Come join our team!

Position Summary

Loomis is seeking a full-time Database Administrator to support and maintain our enterprise database environment. This role will be primarily focused on Microsoft SQL Server administration, with additional responsibilities supporting Windows-based application environments, reporting platforms, production troubleshooting, database migrations, and after-hours operational support.

The ideal candidate will have strong hands-on experience administering SQL Server in a production environment, supporting high availability and disaster recovery, troubleshooting performance issues, managing SQL Agent jobs, supporting database security, and partnering with application, infrastructure, and business teams. This role requires a dependable DBA who can take ownership of critical systems, follow change management standards, document work clearly, and respond to production issues as needed.

Essential Duties and Responsibilities

• Administer, monitor, maintain, and support Microsoft SQL Server environments.
• Support SQL Server versions including legacy and current platforms such as SQL Server 2012, 2016, 2019, 2022, and newer versions as applicable.
• Perform database backup, recovery, maintenance, and integrity checks.
• Support high availability and disaster recovery technologies, including Always On Availability Groups and related SQL Server HA/DR configurations.
• Monitor database performance, troubleshoot blocking, deadlocks, long-running queries, wait statistics, indexing issues, and query execution plans.
• Tune T-SQL queries, stored procedures, indexes, and database configurations to improve performance and stability.
• Manage and troubleshoot SQL Server Agent jobs, maintenance jobs, alerts, operators, and job failures.
• Support SQL Server security, permissions, logins, roles, service accounts, and access requests.
• Assist with SQL Server migrations, upgrades, patching, server moves, and application database cutovers.
• Support reporting and data-related platforms such as SQL Server Reporting Services and Power BI Report Server.
• Provide support for application teams, infrastructure teams, developers, and business users.
• Participate in required on-call rotation and provide after-hours support for production issues, maintenance windows, deployments, and emergencies.
• Perform other database administration and technology support duties as assigned.

Required Qualifications

• Minimum of 5 years of professional database administration experience.
• Strong hands-on experience with Microsoft SQL Server administration in production environments.
• Experience supporting enterprise-level databases with high availability, disaster recovery, backup, restore, and performance requirements.
• Strong T-SQL troubleshooting and query tuning skills.
• Experience with SQL Server Agent jobs, database maintenance plans, backups, restores, DBCC checks, and index/statistics maintenance.
• Experience troubleshooting performance issues using execution plans, wait stats, blocking analysis, indexing strategies, and SQL Server DMVs.
• Experience with SQL Server security, permissions, roles, logins, and access management.
• Experience supporting SQL Server migrations, upgrades, patching, and server/database moves.
• Ability to participate in an on-call rotation and provide after-hours support as required.
• Strong written and verbal communication skills.
• Ability to work independently, manage priorities, document work clearly, and follow established change management processes.

Preferred Qualifications

• Experience with SQL Server Always On Availability Groups.
• Experience with SQL Server replication.
• Experience with SQL Server Reporting Services and/or Power BI Report Server.
• Experience with Azure SQL Database, Azure SQL Managed Instance, or other Azure data platform services.
• Experience supporting legacy applications and database platforms during modernization or migration efforts.
• Microsoft SQL Server or Azure certifications are a plus but not required.

Technical Skills

• Microsoft SQL Server administration
• T-SQL / PowerShell
• Backup and recovery
• High availability and disaster recovery
• SQL Server Always On Availability Groups
• SQL Server Agent
• Performance tuning and query optimization
• Indexing and statistics maintenance
• SQL Server security and access management
• SSRS / Power BI Report Server
• Azure SQL fundamentals
• Production support and incident response
• Change management and documentation
• Solarwinds SQL Sentry

Work Environment and Expectations

This is a full-time, on-site position. The role requires participation in an on-call rotation and after-hours support for production incidents, maintenance windows, deployments, migrations, and emergency troubleshooting. The candidate must be comfortable supporting critical systems in a production environment and working with cross-functional technical and business teams.

Benefits:

Loomis offers one of the most comprehensive employee benefit packages in the industry, which includes:

• Vacation and Sick Time (PTO) as well as Paid Holidays
• Health & Dental Insurance
• Vision Insurance
• 401(k) Plan
• Basic Life Insurance Plan
• Voluntary Life Insurance Plan
• Flexible Spending and Health Savings Account
• Dependent Care Account
• Industry-leading Training and Development

Loomis is an Equal Opportunity Employer and Drug Free Workplace. Qualified applicants will receive consideration for employment without regard to their race, color, religion, national origin, sex, sexual orientation, gender identity, protected veteran status or disability.