Wellmark Blue Cross and Blue Shield · 1 week ago
Sr. Database Administrator
Des Moines, IA, USA
Full-time
Hybrid
Senior Level
7+ years expWellmark Blue Cross and Blue Shield is a mutual insurance company focused on the well-being of its members. The Sr. Database Administrator will design, manage, and maintain secure enterprise-wide databases and data warehouses, ensuring optimal performance and compliance with established standards.
Financial ServicesHealth InsuranceInsurancePersonal Health
No H1B
Responsibilities
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
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
Qualification
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
Company
Wellmark Blue Cross and Blue Shield
Wellmark Blue Cross and Blue Shield and its subsidiaries provide health coverage to more than 2 million members in Iowa and South Dakota.
1001-5000 employees
Funding
Current Stage
Late StageLeadership Team
John Forsyth
Chief Executive Officer
Andrew Neller
Deputy Chief Information Security Officer
Recent News
2022-02-18
Company data provided by crunchbase