| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
PHONE NUMBER AVAILABLE | Fajardo, Puerto Rico | EMAIL AVAILABLESeeking Database Administrator, Data Engineer or Business Analyst role - Available Immediately for either employment (desired) or a Consulting role, remoteCurrent Skills and Experience:
Cigna / Evernorth, Senior SQL and Oracle Database Administrator, 03/2010 03/2024 More than 20+ years Senior SQL Server Database Administrator experience in SQL Server 2005, 2012, 2017 and 2019 More than 7+ years Senior Oracle Database Administrator experience in 9i, 10g, 12c and 19c More than 25+ years performing Business Analysis role for Database Solutions as an Application DBA and Analytics advisor, ETL specialist and Data Engineer 30+ years Database experience in SQL, MySQL, Oracle, Vax RDB, S1032, Access Expert in SQL Server and Oracle Optimization and Query Tuning for problematic Database applications, and with Oracle Performance Hub, and Resource Manager Extensive Healthcare applications experience at Cigna, Blue Cross of CA, Baxter Caremark, Wellpoint, and others, mostly in the Medical Claims Cost Containment area Both in-house and 3rd party applications were installed, maintained, and extended Data Architect role in many of the projects, usage of SSIS for ETL, and SSRS for reporting, and Oracle Data Integrator (ODI) was also used Specialist in efficient Key and Join design, Query Plan analysis and Table design in both Oracle and MS SQL Extensive experience with Solarwinds Database Performance Analyzer (DPA) Specialist in Transaction Control in both Oracle and MS SQL environments utilizing all Transaction Isolation levels as appropriate Database Security Issues addressed at all levels, Auditing safeguards were developed, row and column security was implemented on sensitive data Database Compression and Transparent Data Encryption (TDE) in both Oracle and MS SQL was introduced to several departments as well as SQL Backup and Restore, Replication Strategies, and Disaster Recovery, and was also done with RMAN in Oracle. Training of other users, analysts, and programmers on Database script and programming techniques was performed Worked closely with the Analytics and Reporting teams to construct correct and efficient queries performing ETL for Microsoft BI Reports and Dashboards in both MS SQL and Oracle Created Application Pools along with Resource Governor to control and Optimize DB throughout. Most recently have handled specialized SQL Databases for software robotics applications including Blue Prism, Pega, Automation Anywhere and UiPath on the cloud. Azure experience. Other successful engagements prior to Cigna in the Healthcare field include Pacificare of CA, Blue Cross/Blue Shield of CA, Baxter Caremark of Illinois. Others include Honickman Bottling of NJ, a beverage distributor and Harris Bank in Chicago, IL.Accomplishments: Installed, configured, and optimized Software Robotics database products Blue Prism and Automation Anywhere, costing many millions of dollars, to bring the Cigna organization into the Robotics applications sphere successfully. Managed a large database project with a team of 3 DBAs in the Medical Cost Containment area to achieve a $40 million cost savings in complex medical claims over a two- year period Successful ETL project to bring in data from external sources and EDI transfers to make data available for the Medical Claims Engines saved over $7 million in internal costsEducation: Stevens Institute of Technology, Castle Point Station, Hoboken, NJ Bachelor of Science in Engineering, Certification in Project Management, MS Project Manager |
