Senior Database Engineer
Alliant Insurance Services is one of the nation’s largest and fastest-growing insurance brokerage and consulting firms. We operate through a network of specialized national platforms and local offices to offer our clients a comprehensive portfolio of solutions built on innovative thinking and personal service. Alliant is changing the way our clients approach risk management and benefits, so they can capitalize on new opportunities to grow and protect their organizations.
More information is available on the company's website at: www.alliant.com.
SUMMARY
Responsible for supporting the design, implementation, and administration of database needs for the company. Performs all duties in accordance with all company policies and procedures, and all federal, state and local laws, wherein the Company operates.
ESSENTIAL DUTIES AND 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.
QUALIFICATIONS
EDUCATION / EXPERIENCE
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
MCDBA, CMDBA, or equivalent technical certification preferred
SKILLS
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
#LI-DD1
We are proud to provide comprehensive, high quality employee programs to meet employees’ needs now and in the future, including a very competitive financial package. We encourage you to explore what we have to offer.
For immediate consideration for this position, please click on the “Apply Now" button.
Alliant Insurance Services, Inc. is an equal opportunity employer. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of race, color, age, religion, gender, sexual orientation, gender identity, national origin, disability, protected veteran status or any other protected status.
For more information on Alliant Insurance Service's benefits, click here.
Other details
- Pay Type Salary
- United States
- Virtual