Job Description
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 instances
- Implement and manage database backup, recovery, and disaster recovery strategies
- Enforce database security through user roles, permissions, and encryption
- Manage high availability (HA) and disaster recovery (DR) solutions (e.g., Zerto Replication)
- Monitor and troubleshoot database performance using SQL Server Profiler and DMVs
- Conduct database patching and upgrades
- Create, schedule, and monitor SQL Agent jobs
- Design 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 statistics
- Develop ETL workflows using SQL Server Integration Services (SSIS)
- Collaborate with cross-functional teams and document processes clearly
Qualifications
- Bachelor’s degree in Computer Science, Computer Technology, or a related discipline required
- Minimum of 7 years of experience in a SQL Database Administration role
- Previous experience analyzing SQL Server execution plans and understanding query optimization, including index usage and SQL Server internals
- Proficiency with tools like Query Store and Database Engine Tuning Advisor for performance monitoring and optimization
- Expertise in designing and developing ETL workflows with SQL Server Integration Services (SSIS), including package development and troubleshooting
- Demonstrated experience with SSIS components, performance tuning, and integrating ETL processes with various data sources and systems
- Advanced T-SQL skills for creating complex queries, stored procedures, functions, and triggers, with experience in the database development lifecycle from requirements gathering to deployment
- Familiarity 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 automation
- Understanding of basic DevOps principles (CICD, version control, automated testing)
- Familiarity with use, creation and deployment of certificates for server and database encryption
- Experience with use, creation and deployment of certificates for server and database encryption
- Knowledge of VMWare, VM guests, VDIs, Snapshots, etc.
- Microsoft Certified: Database Administrator Professional preferred
- Any network/security certifications are a plus
About Us
Chubb is a world leader in insurance. With operations in 54 countries, Chubb provides commercial and personal property and casualty insurance, personal accident and supplemental health insurance, reinsurance, and life insurance to a diverse group of clients. The company is distinguished by its extensive product and service offerings, broad distribution capabilities, exceptional financial strength, underwriting excellence, superior claims handling expertise and local operations globally.
At Chubb, we are committed to equal employment opportunity and compliance with all laws and regulations pertaining to it. Our policy is to provide employment, training, compensation, promotion, and other conditions or opportunities of employment, without regard to race, color, religious creed, sex, gender, gender identity, gender expression, sexual orientation, marital status, national origin, ancestry, mental and physical disability, medical condition, genetic information, military and veteran status, age, and pregnancy or any other characteristic protected by law. Performance and qualifications are the only basis upon which we hire, assign, promote, compensate, develop and retain employees. Chubb prohibits all unlawful discrimination, harassment and retaliation against any individual who reports discrimination or harassment.
