Database Administrator

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: www.seniormarketsales.com

SUMMARY

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

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;

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.

QUALIFICATIONS

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.

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

Strong knowledge of complex SQL server replication troubleshooting

Ability to work within a team and to foster teamwork

Proficient in Microsoft Office products

#LI-DD1

"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 1-877-901-9473 and let us know the nature of your request and contact information.

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