Senior Database Administrator
Current• Working for Florida Department of Economics and opportunitiesDevelop, plan, evaluate, implement and validate guidewire deployments on day-to-day basis. Leads project and discuss technical details with the team member. Responsible for providing recommendations and attaining design approval for new technologies and major enhancements to existing systems. • Provides support to Security in the development of appropriate audit controls and procedures to ensure the integrity and protection of company resources. • Works with customers to understand business objectives in order to ensure functional and technical designs meet requirements and are in compliance with the ACG infrastructure and IS technology standards. • Create, Upgrade and migrate databases from 11g/12c/19c RAC environment to Oracle environment. This involves various deployment activities and troubleshooting database problems and implementing the solution in DEV, QA, UAT and Production environment.• Create ACG Disaster recovery environment using Oracle Dataguard replication for several applications such as Claims Datamart, Sales and Service Insurance system, Guidewire and Automotive Datamart. • Create/Implement database security using Oracle Transparent Encryption technology on ACG Claims, Emergency Road service database environment. This includes encrypting PCI and PII data in the database at the tablespace level.• Created RMAN automated Scripts to implement backups on various Florida department of economics and opertunities databases. Restore the database to Point-in-Time in case of database or application problems. • Run orachk periodically and deploy the recommendations/fix provided in exachk on all DEO databases.• Maintain and responsible for day-to-day activities on Peoplesoft, Sales and service, Liferay, Specialty Lines, Automotive DataMart, Claims DataMart and Guidewire application databases. This involves • Refresh test database with production database backup