Jeff Van Der Els Email & Phone Number

Springfield, Ma, Us

Health New England is a non-profit health plan serving members in Massachusetts and Connecticut. Our mission is to improve the health and lives of the people in our communities, and we are deeply committed to the individuals we serve every day.Coordinate all production and test database activities including functional, technical and security oversight of all Oracle and MS SQL Servers. Responsible for: monitoring database activity, performance tuning and optimization; enforcing data integrity; controlling user access and security; and creating appropriate database backup and recovery processes under normal or disaster situations. Develop and automate ETL (extract transform load) processes using SSIS to gather or provide data from/to different sources respectively. Work with application developers to design and develop appropriate data architecture and stored procedures to support the requirements for applications and reports. Work with departments to design, manage and develop a data warehouse and other reporting databases.

Hartford, Ct, Us

-Identified and participated in cost reductions through decommission several servers, databases and migrating to new virtual hardware-Participated with architectural design, conversion, and integration process in creating users stories for the migration to the new Guidewire Claim Center system from the legacy Claim system-Migrated Claims non-production physical server to a virtual container server involving Oracle databases -Compiled a cold to hot backup process replacing 2 BCV (Business Continuity Volumes)-Migrated both production and test environment Tuxedo physical servers into the virtual container server-Coordinated proof of concept with QUEST tool suite -Subject matter expert composed and orchestrated knowledge transfer sessions with sourcing partners on Claim’s applications, Oracle Tuxedo, databases, and interfacing processes-Involved in multiple Oracle projects dealing with database upgrades to 11r2, platforms, with application teams-Provided technical support to new application developers and business users-Performed database monitoring and tuning to ensure peak performance and troubleshoot performance issues using OEM-Managed sourcing partners on migrating all Claims Cron jobs to AutoSys with documentation for support-Monitored Claims release procedure of sourcing partner and application support staff-Handled and administered all Claims Oracle environmental support involved with infrastructure upgrades-Managed new sourcing partners in executing the Claims Disaster Recovery plans-Upgraded and administered BEA Tuxedo domains from 2 servers to 3 servers for Claims High Availability application failover-Focal point for guiding the BMC monitoring Tuxedo portal tool for Oracle Tuxedo on new virtual container servers-Claims production 24/7 DBA team member supporting 7 lines of business applications

Hartford, Ct, Us

-Maintained disaster recovery procedures on Claims business and databases for Business Resiliency Office-Streamlined Claims database backup/refresh procedures, post refresh steps, security validations, and system integration-Performed IBM reverse demand projects that impacted Claims business application and environments, server reboots, patch upgrades, storage migration, NAS upgrades, network, and system failover testing-Provided database administration support for Property and Commercial invest projects within budget and SLA parameters.-Educated business applications on DBA standards and best practices-Provided knowledge and guidance to TaTa Technologies and Cognizant DBA support teams -Participated in product evaluation of software packages and tools that enhanced our capabilities external vendors-Performed data masking for patient privacy data on Claims test database, in compliance with HIPAA regulations and company privacy practice-Administered and audited the corporate compliance initiatives for THIP, PII, and SOX for all Claims databases-Instrumental in the definition and implementation to improve the quality of DBA services; common share drive, off-hours support model, desktop builds, design forum, document structure, source control, technical training program, and new release procedures with other areas-Streamlined and enhanced Claim’s Disaster Recovery application testing plans-Documented the release of application sys-configuration changes require for development and production data -Spearheaded the proof of concept process with PegaSystems for First Notice Loss Oracle 10i application-Provided quarterly hardware forecasting reports on disk usage for demand management-Coordinated production testing of High Availability failover on Veritas Cluster Server involving several different teams-Managed and performed updates of GREATDATA zip code for USA and Canada to Claims databases

Hartford, Ct, Us

-Installed PowerImage databases Oracle 9i and application software for Group Annuity Business workflow and document retrieval-Applied application upgrades to PowerImage software and tuned screen flow processing -Allocated and managed physical storage for Oracle Data Warehouse and PowerImage -Work as a System DBA to provide 24/7 support and responsible for system availability-Supported Group Annuity reporting database Oracle 9i that interfaced with SunGard OmniPlus-Involved in complete Disaster Site Failover testing of business application and system readiness

Hartford, Ct, Us

-Group Annuity Business readiness team member for COBOL Y2K-Provided 24/7 production support for Personal Lines and American Association of Retired Persons-Volunteered for the Oracle Training Program-Upgrade of multiple database instances from Oracle 7 to 8i for AARP applications-Focal point for SDLC migration of all Oracle products and server compatibility-Customer liaison for both system and functional areas supporting Personal Lines Insurance Center-Participated in major development projects to support auto and property lines of business for AARP-Constructed programming changes for COBOL/IMS-DB/DC front-end, batch jobs and interfacing with DB2