98 applicants

Company

Alliant Insurance Services · 10 hours ago

Senior Database Engineer

United States

Full-time

Remote

Senior Level, Lead/Staff

10+ years exp

Maximize your interview chances

ConsultingFinancial Services

H1B Sponsor Likely

Insider Connection @Alliant Insurance Services

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Ensures database integrity, stability and system availability.

Performs database server installations, patches, and upgrades, including both standalone and high availability environments.

Implements database maintenance best practices including index rebuilds, distribution statistics, and database consistency checks.

Develops backups, recovery and recovery testing, and verification.

Performs database performance tuning activities such as analyzing SQL server query plans, index tuning, troubleshooting database blocking, and resolving deadlocks.

Monitors, maintains database systems and troubleshoots problems that may arise.

Maintains data integrity and security (manage roles and permissions of database users).

Uses tools like SQL Profiler for database tuning. Generates traces, executes plans, identifies performance issues, deadlocks/contention and resolves them.

Develops strategies and implements solutions for managing back-ups, restoration and replication.

Works with developers to create new applications that use databases or modifying existing applications to improve their performance or functionality.

Creates documentation to explain how to use databases effectively and efficiently.

Supports software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures.

Leads, mentors and cross trains other team members.

Participates and contributes input in high level project planning, providing database tasks and milestones for project plans. Supervises and delegates projects.

Participates in hardware capacity planning and configuration for database environments.

Architect for high availability and disaster recovery solutions for database environments.

Analyzes and resolves database-related issues in areas of performance, availability, and production operations as needed within established SLAs.

Provides 24x7 standby support on a rotational basis.

Performs other duties as assigned.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Microsoft SQL ServerT-SQLSQL Server Integration Services (SSIS)SQL Server Reporting Services (SSRS)SQL Server Analysis Services (SSAS)Windows O/SSQL Server ClusteringDatabase security best practicesData warehousingDisaster recovery technologiesMCDBA certificationCMDBA certificationProficient in Microsoft OfficeTime management skills

Required

Bachelor’s degree in computer technology or equivalent combination of education and experience

Ten (10) or more years of experience in administering Microsoft SQL server

Eight (8) or more years of experience with Windows O/S

Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems

Extensive Experience in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)

Extensive Experience with SQL server profiler for monitoring and troubleshooting database activity and performance

Experienced in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies would be an advantage

High knowledge of modern data network, enterprise storage (SAN, NAS, etc.), server consolidation, server virtualization, directories, and disaster recovery technologies

Extensive knowledge of complex computing management systems including system administration, performance monitoring, problem management, change management, records management, and disaster prevention and recovery

Data warehousing, data modeling, and business intelligence knowledge a plus

Strong verbal and written communication skills

Strong organizational and documentation skills

Good planning, prioritization and time management skills

Excellent conceptual, analytical and problem-solving skills

Strong knowledge of database security best practices

Ability to work within a team and to foster teamwork

Proficient in Microsoft Office products

Preferred

MCDBA, CMDBA, or equivalent technical certification preferred

Company

Alliant Insurance Services

Glassdoor

3.9

Alliant Insurance Services is a distributor of diversified insurance products and services.

Founded in 1925

Newport Beach, California, USA

10001+ employees

https://alliant.com

H1B Sponsorship

Alliant Insurance Services has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2022 (2)

2020 (1)