Sr. Database Administrator

Company Description

Why Wellmark: We are a mutual insurance company owned by our policy holders across Iowa and South Dakota, and we’ve built our reputation on over 80 years’ worth of trust. We are not motivated by profits. We are motivated by the well-being of our friends, family, and neighbors–our members. If you’re passionate about joining an organization working hard to put its members first, to provide best-in-class service, and one that is committed to sustainability and innovation, consider applying today!

Why Wellmark Technology: Wellmark is building innovative, modern solutions using cutting edge technology. We are driving organizational transformation and business strategy by empowering our technology team to innovate new and elegant solutions to enhance the customer experience. Together, we are leaning into the future, owning the outcome, and driving organizational change to transform how we work.  

Job Description

Mentor and assist with team activities to design, architect, script, query, monitor, document, test, implement, troubleshoot, manage, report, and maintain secure enterprise wide databases and data warehouses to provide Wellmark with cost effective technological resources. Database management includes configuration, security, resource monitoring and reporting, troubleshooting, and the development of specialized scripts and queries. Contribute to the coordination of issues with other IS teams including applications and operations. Assist the Team Leader in serving as a futurist within IS, keeping the enterprise on the cutting edge of current database technology. Providing streamlined databases and data warehouses used in daily business processes, trending, internal and external customer service, and data analysis. Provide a stable, reliable database infrastructure that delivers services promoting and enhancing Wellmarks ability to deliver products and services on a 24 x 7 schedule ensuring data integrity and recoverability to internal and external customers with services delivered in accordance with established Service Level Agreements (SLA). Maintain compliance with all applicable legal, regulatory, licensing, governance, and contractual requirements by helping to establish and monitor effective processes and procedures. Support Wellmarks Vision, Values, Mission, and Purpose.

Qualifications

Required:

• Bachelor's Degree direct and applicable work experience
• Minimum 7 years database administration experience in a Unix environment including advanced modeling and design tools. Of those 7 years:
• At least 4 years database security experience
• Experience with scripting/programming languages
• Systems administration experience, including knowledge of network technologies and protocols
• Strong communication skills (both written and verbal) to express complex technical concepts effectively
• Advanced experience troubleshooting database connectivity issues
• Ability to continually prioritize and stay organized in a fast paced environment
• Ability and interest in managing projects or tasks within a project

Additional Information

a. Ensure that the databases are functioning as designed and provide a stable database environment by proactively monitoring the database servers and tracking logs in a Knowledgebase. Provide optimal database performance levels through proactive systems management practices identifying and resolving cross-capability architectural dependencies, simplification opportunities, and gaps while minimizing costs.

b. Design, develop, troubleshoot, and maintain appropriate databases and database structures in a client / server environment. Perform physical data modeling both data warehouse and application development efforts. Perform development programming/coding for both data warehouse and application development efforts

c. Support both OLAP and OLTP database environments, ETL and EAI processes, and Business Intelligence tools and standards. Resolve database performance and capacity issues and provide maintenance to database replication environments as necessary.

d. Monitor and measure database servers for system performance to analyze, recommend changes, and fine tune the system to provide users with improved processing and optimally tuned databases. Analyze and improve existing SQL code. Provide scheduled reports on system problems and their solutions, as well as provide forecasting of future utilization and equipment requirements.

e. Define and implement infrastructure enhancements ensuring optimal database performance and reliability to improve processing and utilization, while addressing the requirements of heterogeneous integration, compatibility, security, and business continuity to guarantee scalable solutions. Conduct research activities on the applicability of new integr