jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom professional summary dynamic database engineer devoted maintaining reliable computer systems uninterrupted workflows delivers uptodate methods increase database stability lower likelihood security breaches data corruption offers detailed training reference materials teach best practices system navigation minor troubleshooting technical skills oracle 19c18c12c11g10g9i 18c12c11g racasm exadata ms sql server 20161208 mysql mariadb mongodb administration tools utilities skills oem 13c12c toad uc4 opcon scheduler tkprof rman datapump importexport sql loader tuning diagnostic packs awraddm load runner veritas netbackup commvault datadomain emc srm explain plan erwin sqlnavigator data guard pentaho sql server integration services ssis redhat linux 4x 5x 6x 7x solaris 10 11 aix 71 hpux 11i windows 200812 sql plsql tsql unix shell scripting c c perl amazon web services aws oracle cloud infrastructureoci interfacing oracle corporation technical support environments oracle 10g11g ms sql server 20052008 redhat linux 4x5x sunsolaris 10 rman backup recovery awr addm statpack tkprof sql trace work history senior database engineer 082017 current humana inc ormond beach fl installation configuration maintenance oracle 19c12c rac new servers redhat linux 7060 upgraded several databases 11g10g 12c 12c 18c19c databases sizing 1 tb 10 tb migration databases nonrac rac clusters also crossplatform hpux redhat linux troubleshooting rac issues like bugs network issues configuration files issues ocr issue node eviction issue rac systems crs upgrade asm upgrade db upgrade oem agent upgrade supported san migrations moved asm disk groups server server adddrop disks existing diskgroups breaking rac instances added new cluster nodes existing clusters added 4 nodes existing 3 node cluster configuration implementation dataguard physicallogical standby databases automating monitoring resolving gap lagging issues installed configured upgraded golden gate oracle database enable realtime data integration continuous data availability capturing delivering updates critical information changes occur providing continuous data synchronization across heterogeneous environments capture propagation apply using golden gate worked implementing disaster recovery strategies rds oracle databases documented confluence page hands experience amazon web services aws provisioning good knowledge aws services like ec2 s3 elastic beanstalk elb load balancers rds vpc direct connect route53 cloud watch cloud formation iam sns etc configured installed involved using aws services ec2 data pipeline s3 rds emr architecting new dba solutions aws provide domain expertise opensource commercial relational dbms products services oracle 11g12c sql server postgresql aws rds nosql databases eg mongodb cassandra databases defined aws security groups acted virtual firewalls controlled traffic allowed reaching one aws ec2 instances installed application aws ec2 instances configured storage s3 buckets worked migrating oracle databases aws rds using utility aws database migration service dms implemented maintained monitoring alerting production corporate servers ec2 storage s3 buckets using aws cloud watch creating 3 buckets managing policies 3 buckets utilized 3 bucket backup aws worked aws oracle databases app migration private cloud worked aws database migration services migrating data oracle rds hands experience implementing dataguard high availability environment rds oracle databases worked configuring installation dataguard broker aws servers worked configuring installing data guard broker implemented fsfo higher environment implement maintain database security create maintain users roles assign privileges implemented rat real application testing testing run poc test 12c upgrade critical databases configuration implementing various rman backup recovery using catalog controlfile configuration implementing ddboost tape tdpo backup recovery configuration implementing automating datapump backup jobs full db schema level table level frequently cloningrefresh databases using rman ddboost datapump export import utilities configuring performing flashback restore point archivelogs managing recovering blockcorruption using rman proactively monitoring management databases using oem grid control plsql shell scripting automate monitoring backup jobs cleanup reporting jobs using crontab well dbms scheduler utilities performance tuning fine tuning initialization parameters io memory storage operating system kernel parameters oracle sql optimizer query plan optimize queries performing plsql code profiling troubleshooting database performance issues analyzing automated workload repository awr active session history ash automatic database diagnostics monitor addm reports using sql adviser undo adviser tools oem grid toad tracing blockinglocking long running sessions wait interface capacity planning per data growth workload working closely decision making teams development businessclients apply cpu dst rdbms patches rac databases per requirement supporting os patching activity rac servers create databases development testing production including rac databases non rac databases oemgrid ogc installation configuration monitoring performance tuning performed range partitioning cause improve performance database database monitoring maintenance activities include checking alert logs space management undo management gathering database statistics database locking issues scheduling jobs creation users schemas table spaces database objects environments oracle 19c18c12c11g racasm golden gate shareplex san oem 13c12c dataguard toad datapump awr addm ash sql loader plsql unix shell scripting rman oracle enterprise linux 567 sun solaris hpux 11 windows aws oci contributed internal activities overall process improvements efficiencies innovation senior database administrator 012014 072017 solute philadelphia pa performing database administration activity like space management database user roles administration schema management databases set controlled user profiles access levels database segment protect important data experienced automating routine server tasks alerts using various scripting technologies unix shell scripting batch files configure alerts oem implementing 11g data guard one physical database used oem grid control diagnostic tuning packs tune application sql queries installation configuration administration oracle 11gr2 rac 7 production support day day operations call responsibilities working knowledge exadata involved moving oltp databases exadata environment attended exadata workshop familiar smart scan hybrid column compression flash cache irom implemented hugepages performed exadata health check newly build exadata environments optimization tuning sql queries using trace file tkprof explain plan extensive usage addm awr assm features 10g11gr2 database structure changes tableindex sizing sga sizing sql io application tuning transaction monitoring detecting lock contentions tuning sort operations timely reorganization tables rebuilt indexes improve performance sql queries part scheduled maintenance window developing online rman backup scripts automate backup procedures database exportimport evaluating backup recovery procedures periodically performing backups using rman restoration recovery backup timely manner support application development team testing cloning application production environment test environment using 11g new feature active database cloning application patches configure manage oracle advanced security features oracle database vault oracle wallet manager encryption security administration including management profiles roles users privileges providing controls users required permissions preventing performing unauthorized changes databases administrated user accounts creating users roles privilege managing using grants profiles configure manage database auditing configure manage database gateway oracle heterogenious services clone rac databases various strategies like coldhotlogical refresh rman backup rac systems crs upgradeasm upgrade db upgrade oem agent upgrade cloning cluster database normal database cloning normal database cluster database handled standard database administrative tasks proactive performance tuning monitoring troubleshooting backup recovery installations configurations needed basis transformed logical database designs physical databases build implement test quality assurance production databases environments coordinated strategies move data databases created sql tuning sets sql profiles better optimization database monitoring maintenance activities include checking alert logs space management undo management gathering database statistics database locking issues scheduling jobs creation users schemas table spaces database objects used different tools like toad dbartisan explain plan awr addm tkprof oracle enterprise manager grid control 12c solve performance issues helped developer installing oracle client troubleshoot establish connection oracle database jdbc responsible monitoring rman backup jobs analyze tables indexes oracle database periodically better performance extensively used sql plsql designed data model using erwin installed configured supported mysql databases managed data repository datawarehouse databases performing necessary structural changes etl activities using pentaho tool environments oracle 11g rac asm 11gr2 mysql oem 12c dataguard rman datapump expdpimppdp erwin data modeling pentaho rhel 45 aix 6171 windows 2008 server database administrator 072012 122013 sentry little rock ar oncall 24x7 dba support production databases implemented supported 10g11r2g rac consisting 2 8 nodes managed multiple terabytes databases created database users roles manage database user security passwords development engineersusers implemented 10g11g data guard one physical database automated housekeeping monitoring jobs using global scripting installed upgraded oem 12101 12102 12103 implemented oracle stream replication database schema level table level implemented oracle streams replication dml ddl operations trouble shooting various database performances proper diagnosis levels including sql plsql database design database tables indexes instance memory operating system java calls installed rac oracle 10g 11gr2 worked asm feature oracle security user management privileges roles auditing profiling authentication upgraded multiple databases 9110gr110204 11203 performed dr test regular intervals mission critical environments part database upgrade involved upgrade oracle tde encryption 10g 11203 installed agents mysql timesten db2 databases part oem 12c configuration according end user business requirement implemented transparent data encryption rac 11g extensive performance tuning memory sga tuning rac tuning net backup emc time finder srdf raid raw devices data migration part enterprise data warehouse project used triggers database activities including delete update insert triggers multimaster replication cloning databases using scripts well rman installation setup configuration dataguard used plsql sql loader part etl process populate operational data store perform oracle replication advanced queues materialized views etc recovery database recovering media failure recovering tables dropped accidentally recovering data files recovering block corruption supported development effort providing sql statement tuning optimizing etl procedures removing load query performance bottlenecks using tools explain plan sql trace tkprof oracle enterprise manager based user scope security purpose restricted users using virtual private database vpd also implemented vpd sensitive information protection solid discipline providing endusers timely updates problems installing server software addition users objects etc required granting proper privileges database access taking care database checking size database addition table spaces data files extensively worked asmcmd managing asm environment made use ref cursors stored procedures report generation daily health check database using statspack awr addm optimal space utilization tablespace avoiding fragmentation tuning sga io tuning identifying contention waits tuning taking periodic backup database software using rman veritas netbackup able work effectively multiple teams able thrive fastpaced time compressed dynamic environment solid skills discipline change management practices processes server 20052008 environments oracle 10g11g racasm 10g11g oem dataguard rman datapump expdpimppdp sunsolaris linux ms sql oracle database administrator 082010 062011 cvs health champaign il performing database administration activities like installation configuration cloning patching upgrade performance tuning backup recovery space management database user roles administration schema management installation configuration upgrade patching oracle rdbms applications monitored production databases performed performance tuning added data files resized segments table spaces security user management privileges roles auditing profiling authentication installed configured oracle 10g migrated oracle 10g database oracle 11g supported databases frontend siebel java applications storage space management including table spaces data files supported oltp olap databases siebel crm applications monitoring database fragmentation correcting database performance tuning using statpack tkprof sql trace explain plan monitoring management table space growth extent growth planning implementation backup recovery procedures maintenance database performed backuprecovery using rman wrote scripts startup shutdown automation backups monitoring scheduled jobs daily activities performance databases prepare documents process knowledge transferring project new team members worked development team solve issues checking alert log databases involved process tuning refining queries various applications written scripts health check databases analyzing tables rebuilding indexes master science 122012 education northwestern polytechnic university fremont ca bachelor technology electronics communication engineering 052011 jawaharlal nehru technological university hyderabad india accomplishments 10 years experience information technology various roles database administrator hands experience database administration performed different tasks like installation configuration upgrades patches performance tuning golden gate backup recovery production support cloning space management database security enterprise manageroem shell scripting install configure container non container databases pluggable databases architecture installation concepts associated database hands experience amazon web services aws provisioning good knowledge aws services like ec2 s3 elastic beanstalk elb load balancers rds vpc direct connect route53 cloud watch cloud formation iam sns etc automated rman backups data pump cloning space management database security cloning migration aws dms aws kms aws iam aws adg aws rds aws ec2 documentation configured installed involved using aws services ec2 data pipeline s3 rds emr architecting new dba solutions aws provide domain expertise opensource commercial relational dbms products services oracle sql server aws rds nosql databases eg mongodb databases performed migration different data centers non asm asm single instance rac extensively worked identifying bugs installing necessarylatest cpupsu patches rolling fashion clusterware home database home worked performance optimization large objects lob blob clob monitoring redoes generation increasing log buffer size blocksize changing archiving procedures query tuning using statspack tkprof oem performance tuning database memory allocation tuning io tuning tuning contentions using oracle tools like awr addm advisories tkprof explain plan better performance provided technical troubleshooting give consultation development teams performed database refreshes database copies development test production databases implemented basic replication materialized views expertise cross platform data migrations using transportable tablespaces excellent troubleshooting skills os level database level worked aws dms migrating oracle databases worked s3 buckets cloud trails monitor logs backups experience monitoring managing oracle instances using enterprise manager grid control oem grid 10g11g12c13c worked building rolling new databases devsituat environments setup configured oracle enterprise manager cloud control use tool administration monitoring performance tuning experience construction catalog databases developed scripts perform backups using rman implemented rman backup full incremental cumulative recovery disaster recovery installation configuration recovery catalog multiple databases experience taking logical backup database using datapump expdpimpdp used oracle configuration assistants like database configuration assistant dbca creating databases adrci oracle database diagnostic data database upgrade assistant dbua upgrading databases network configuration assistant netca creating listener tns names establish clientserver environment experience implementation enterprise databases enterprise storage solutions using storage area networks san network attached storage nas experience configuring managing monitoring asm standalone rac databases experience performance tuning better performance identifying bottlenecks memory disk contentions indepth study automatic workload repository awr active session history ash automatic database diagnostic monitor addm reports hands experience implementing installation dataguard broker ec2 instances supported high availability environment multiaz locations responsible 24x7 production operations incident breakfix change service requests management oncall rotation additional information provided dba support multiple cluster non cluster asm database production development testing servers unix aix windows environments experience installation oracle real application cluster rac asm manage rac instances using crsctl srvctl utilities first handson experiences software firmware maintenance database storage servers exadata database machine including upgrades patching provide implement performance tuning recommendations components exadata database machine develop record certified processesprocedures potential downstream support groups maintain upgrade exadata database machine deep understanding exadata specified features smart scan hcc hybrid columnar compression flash cache etc backup recovery issues related loss ocr voting disk oracle cluster ware also issues corruption individual disk data blocks loss os configuration files loss net configuration files resolved diagnose node eviction add remove node rac implement configuring replication technology using dataguard golden gate installation worked implementing disaster recovery strategies rds oracle databases documented confluence page installation configuration maintenance physicalactive standby databases data guard implemented dataguard maximum availability protection performance configurations worked dataguard failover switchover cases resolving different sync issues dr identifying root cause resolving restore logs applying manually necessary golden gate install configuration maintenance trouble shooting upgrade upgrade grid oracle infrastructure multi node rac cluster 11g 12c 12c 19c oracle certified professional certifications