Database Administrator

Overview

SMS is part of the Alliant family of companies. SMS is a full-service insurance marketing organization (IMO) dedicated to helping independent insurance agents leverage time, make more money, and put their business in a position of distinction. With products and agents in all 50 states, SMS offers the industry's most complete IMO experience. We support every facet of an agent's business, from our comprehensive senior product portfolio to our technology, services, and marketing programs.

More information is available on the company's website at:

Responsible for supporting the design, implementation, and administration of database needs for the company.

• Ensures database integrity, stability and system availability.
• Performs database server installations, patches and upgrades, including both standalone and high availability environments.
• Manages database deployment and testing.
• Implements database maintenance best practices including index rebuilds, distribution statistics, and database consistency checks.
• Executes 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.
• Mentors and cross trains other team members.
• Other duties as assigned.

• Bachelor's degree in computer technology or equivalent combination of education and experience.
• Five (5) or more years of experience designing, implementing, and managing corporate enterprise systems.
• Five (5) or more years of experience with Windows O/S, and as a production SQL server.
• Strong knowledge and experience with stored procedures and SQL queries and optimization to improve overall database performance.
• Working knowledge of modern data network, enterprise storage (SAN, NAS, etc.), server consolidation, server virtualization, directories, and disaster recovery technologies.
• Strong working 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.

• 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
• Strong knowledge of complex SQL server replication troubleshooting
• Ability to work within a team and to foster teamwork
• Proficient in Microsoft Office products

Note:

This description reflects the current responsibilities and requirements; related duties may be assigned as needed.

Successful people do those things that failures refuse to do.

Equal Opportunity Employer; SMS participates in the E-Verify system.

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.

If you are applying for a job and need a reasonable accommodation for any part of the employment process, please call our Career Center at and let us know the nature of your request and contact information.

For more information on Alliant Insurance Service's benefits, .