Sr. Database Administrator

Wellmark•Des Moines, IA

14d•Remote

About The Position

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.

Requirements

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

Responsibilities

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.
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
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.
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.
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.
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.
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.
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.
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.
Assist programmers and provide informal technical training to developers and database administrators as needed.
Other duties as assigned.