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 integrated system designs, technologies, architectures, and products to recommend innovative solutions enhancing the current system and aligning it with the enterprise architectural direction, long-term strategic plans, and migration roadmaps.

f. Serve as a subject matter expert in database technologies. Develop, test, and implement relational database and data warehouse technologies, transaction processing, data trend analysis, and procedures including the use of modeling and design tools. Define and implement potential future data architectures using emerging technologies for evaluation and possible inclusion in the enterprise data architecture roadmap.

g. Collaborate with the Technical Process Governance network (TPGn) committee to establish the database and architecture standards for the DBA area and Wellmark. Maintain documentation and design papers defining access, architecture, infrastructure, implementation, systems administration, systems management, naming conventions, testing, problem escalation, and maintenance ensuring current, accurate documentation is maintained. Establish and monitor effective processes and procedures.

h. Develop comprehensive backup and recovery procedures to ensure the timely recovery of critical data in case of disaster. Participate in disaster recovery exercises and provide detailed documentation to support disaster recovery. Maintain intrusion detection to strengthen the network security policies and business continuity plans.

i. Work with the hardware and software vendor and other vendors in the assessment of advanced transaction processing and database productions, including beta and field test participation.

j. Assist programmers and provide informal technical training to developers and database administrators as needed.

k. Other duties as assigned.

All your information will be kept confidential according to EEO guidelines.

Remote Eligible : You will have the flexibility to work where you are most productive. This position is eligible to work fully remote. Depending on your location, you may still have the option to come into a Wellmark office if you wish to. Your leader may ask you to come into the office occasionally for specific meetings or other ‘moments that matter’ as well.