We are seeking a skilled and versatile SQL Database Administrator (DBA) to join our dynamic team in a role that blends core database administration with opportunities to contribute to application architecture. This position offers the unique chance to work beyond traditional database management, engaging with the broader ecosystem of networking, security, operations, and infrastructure to ensure a robust and optimized SQL environment.
As a key member of our team, you will leverage your deep technical expertise to maintain data integrity, optimize performance, and support applications critical to our business operations. You’ll collaborate closely with developers, project managers, product owners, and cross-functional teams in networking, infrastructure, security, and operations. This role spans both production and non-production database environments, supporting applications used across all our North American lines of business.
If you’re passionate about database administration and eager to expand your impact by engaging in application architecture and the broader IT landscape, we’d love to hear from you.
In this role, you will:
Install, configure, and maintain SQL Server instancesImplement and manage database backup, recovery, and disaster recovery strategiesEnforce database security through user roles, permissions, and encryptionManage high availability (HA) and disaster recovery (DR) solutions (e.g., Zerto Replication)Monitor and troubleshoot database performance using SQL Server Profiler and DMVsConduct database patching and upgradesCreate, schedule, and monitor SQL Agent jobsDesign efficient database schemas, tables, and indexes while ensuring normalization and denormalization techniques. Ability to use data modeling tools (e.g., ERwin, Visio, or SQL Server Data Tools)Identify and Resolve performance bottlenecks, implementing indexing strategies, and managing statisticsDevelop ETL workflows using SQL Server Integration Services (SSIS)Collaborate with cross-functional teams and document processes clearlyBachelor’s degree in Computer Science, Computer Technology, or a related discipline requiredMinimum of 7 years of experience in a SQL Database Administration rolePrevious experience analyzing SQL Server execution plans and understanding query optimization, including index usage and SQL Server internalsProficiency with tools like Query Store and Database Engine Tuning Advisor for performance monitoring and optimizationExpertise in designing and developing ETL workflows with SQL Server Integration Services (SSIS), including package development and troubleshootingDemonstrated experience with SSIS components, performance tuning, and integrating ETL processes with various data sources and systemsAdvanced T-SQL skills for creating complex queries, stored procedures, functions, and triggers, with experience in the database development lifecycle from requirements gathering to deploymentFamiliarity with version control systems (e.g., Git, TFS) to manage database scripts and SSIS packages while collaborating with developers to optimize application-database interactions Experience with cloud-based SQL Server solutions (e.g., Azure SQL Database)Knowledge of data warehousing concepts and Microsoft BI tools (e.g., SSRS)Demonstrable proficiency with scripting languages (e.g., PowerShell) for database task automationUnderstanding of basic DevOps principles (CICD, version control, automated testing)Familiarity with use, creation and deployment of certificates for server and database encryptionExperience with use, creation and deployment of certificates for server and database encryptionKnowledge of VMWare, VM guests, VDIs, Snapshots, etc.Microsoft Certified: Database Administrator Professional preferredAny network/security certifications are a plus