Oracle dba
Resume:
PATIENCE WANKA
**************@*****.***
Preference : Full Time/Remote Jobs
Education
Bachelors in Linguistics
University of Buea /Cameroon /2006-2009
Marketing/Public Relation, PAID-WA Buea 2010
Visa Status :Green Card
Outgoing and Diligent Database Administrator with 7 years of experience and еxреrtiѕе in реrfоrmаnсе tuning, backup and recovery, сriѕiѕ mаnаgеmеnt, and high аvаilаbilitу to inсrеаѕе rеliаbilitу, maximize рrоduсtivitу, and intrоduсе ѕуѕtеm еffiсiеnсiеѕ. Adept at tеѕting and ѕuрроrting next-generation databаѕе. Prоfiсiеnt in Oracle 10g, 11g and 12c running on AIX, HP-UX, Linux and Windows platforms seeking to leverage .My technical and professional expertise to enhance technical services
Experience Summary
Experienced Oracle DBA with 7 years of experience in Oracle Database Administration in large-scale production environments across multiple platforms.
Ability to provide expert-level technical support in all aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning and backup & recovery Hands-on experience with Oracle Real Application Clusters (RAC) and Data Guard.
Ability to work both as an individual contributor and as a member of a team.
Experience in Performance tuning of Oracle Golden Gate Processes to achieve zero lag times.
I have great leadership experience,I have successfully exercised my lead experience during the data Guard Configuration for disaster recovery/I assigned and monitored projects and equally wrote project reports
Hands on experience on using of macros, conflict resolution, filtering and transformation, exception handlers and Security.
Experience with Oracle Data Guard setup, maintenance and troubleshooting for High Availability.
I configured data guard for high availability, data protection, and recoverability.
In my current environment, our standby data guard is configured to a physical standby database and set to Maximum Performance mode.
I have used Service to create tickets, it equally updated me of the daily tasks assigned to me by my Manager
I configured a logical standby database in some of my test environments.
I converted some of my databases into a snapshot standby database for testing.
I have the ability to set the database on maximum availability and maximum protection mode.
During my configuration, I had to configure my physical standby database and managed it using OEM where iconfigured Data Guard Broker to manage the primary and standby databases to facilitate a fast-start failover during the fail over. I did this so that it automatically detects the failure, evaluates the status of the dg configuration and if appropriate, executes the failover to the previously chosen standby database.
Experience in performing Backups/Recovery using RMAN, Datapump and Flashback Technologies.
Experience in SQL Tuning using tools like Explain Plan, SQL*Trace, TKPROF and OEM.
Effective troubleshooting of Database Performance and tuning using ASH, AWR, ADDM.
Experience in Database capacity planning, monitoring object growth and Storage Management.
Performed data migration from flat files into an Oracle database using SQL*Loader.
Experience in performing Cloning and Refresh using RMAN and Datapump.
Experience in Oracle Advanced Compression techniques.
Experience in Online/Offline Re-Organization of database objects.
Experience in Partitioning Tables, Rebuilding of Indexes, Secure files, DBLINKS, Materialized Views, Store Procedures, Triggers and constraints.
Demonstrated proficiency in managing Oracle Instance, database storage structure, schema objects, managing tablespaces, Rollback and undo segments, creation of database objects, Data Modeling.
Experience in defining Users, Roles, Privileges, Auditing to ensure database Security.
Proficient With Database Network encryption(DNE)
Proficient with Auditing Vault server Database Firewall(DBFW) by
Assuring First line of defense: Transparently detect and block SQL injection attacks, privilege escalation, and other threats against Oracle, Microsoft SQL Server, IBM DB2, SAP
Faster response: Automatically detect unauthorized database activities that violate security policies, and thwart perpetrators from covering their tracks
Simplified compliance reporting: Easily analyze audit and event data and take action in a timely fashion with out-of-the-box compliance reports
Experience working with database security tools TDE, DB Vault / VPD.
Experience in applying CPU/PSU patches to various versions of databases with minimum downtime.
Experience in upgrading Oracle Binaries and databases from 10g to 11g and 11g to 12c.
Experience in handling very large databases (VLDB) ranging up to 3TB.
Proficient in writing SQL, PL/SQL (Stored Procedures, functions, packages and triggers) scripts.
Experience in Shell Scripting for configuring monitoring alerts and automation.
Experience in performing Data Migration between Non ASM and ASM databases and also between the databases of different vendors.
Worked with EXP/IMP, EXPDP/IMPDP to refresh the schemas and to
Database Performance Tuning Diagnosing using AWR (Automated Workload Repository) / Stats pack and ASH (Active Session History) reports, ADDM (Automatic Database Diagnostic Monitor) analysis.
Proactive database monitoring via automatic Email and Text alerts of Alert.log, Listerner.log and Space errors to DBA cell phone
Experience in Upgrading databases, applying patches.
Managing Security Management, Schema Management, Instance Management, Storage/Space Management.
Proficient with Database Cloning, Migration, and Patching of Oracle Databases.
Installed Oracle 11g with ASM and OCFS2 File systems.
Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.
I have implemented unidirectional and bidirectional real time replication in Golden Gate, I have also done upgrades and migration with zero downtime
Professional Experience
Pfizer – Peacock, NJ
Oracle Database Admin, Oct 2015-Jul 2018
Displayed a high level of expertise while handling the various scenarios of database Backup & recovery and cloning using the RMAN tool in RAC and Data Guard environments of large to very large databases also setup RMAN catalog for the same
Hands on experience in installation and implementation of 12c cloud control and migration of 11g grid control to 12c cloud control.
Converting Standby database to Snapshot standby database for pre-go live activities
I have and still take responsibilities of Analysing and trouble shouting databases to enhance its performance,by doing this I have used tools like ASH,AWR,ADDM,TKProf,OEM,Toad and Scripts
On a daily bases I overlook the entire performance of the production services by monitoring and administering the Production system
Admiral Insurance Company – Austin, Tx
JUNE 2011– Sept 2015
Oracle Database Administrator
Displayed a high level of expertise while handling the various scenarios of database Backup & recovery and cloning using the RMAN tool in RAC and Data Guard environments of large to very large databases also setup RMAN catalog for the same.
Hands on experience in installation and implementation of 12c cloud control and migration of 11g grid control to 12c cloud control.
Tuning of Oracle Databases for performance improvement using AWR, ADDM, ASH, Trace Analyzer, SQLTXPLAIN, OSWatcher and other OS related utilities like pstack, pmap, top, vmstat, iostat, prstat, strace, truss and also used Oracle Enterprise Manager(OEM) 11g and 12c to monitor single instance and RAC databases.
Converting Standby database to Snapshot standby database for pre-go live activities
Performed oracle Software's Installations, Creation of new standalone and clustered databases.
I successfully led a team of Five DBAs during the configuration of a data Guard for disaster recovery
Administering and setting up of 11G RAC and 10G RACclusterware and instances.
Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.
Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
Also worked on Network data encryption to improve the security and also implemented SSL wallet to secure the connections.
Database Services creation for distributing the applications across multiple nodes, Extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD,
Redefinition of tables using DBMS_REDEFINITION, partitioning the tables in the production, re-defining the columns data types, and moving the LOBS to different tablespace
Partitioned tables Maintenance, adding new partitions, exchanging one year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
Implemented 11g Interval Partitioning for monthly partitioning of large tables..
Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active-active duplication.
Experience with Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Golden Gate and worked with conventional EXP/IMP for migrating data from 9i to 10G.
Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER, Crontab and $UNIVERSE.
Designed and implemented different backup strategies like Cold, Hot, MAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.
Handled Chained Rows and Row migration, and solved the database performance issues.
Experienced with ASM, adding, deleting disks to the disk group.
Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster.
Generated Statspack/AWR reports using OEM 12C from Oracle 11g database and analysed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.
Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries
Information Technology- Data transmission,data retrieval,data manipulation,data processing and data storage
I have applied patches and upgrades on Golden Gate with zero down time
I have implemented real time replication on a pilot project in Golden Gate
I have done unidirectional and bidirectional replication in Golden Gate
I have implemented DML and DDL replication in Goden Gate
I have done schema,table,column and whole database replication in Golden Gate
Technical Proficiency
Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000
RDBMS: Oracle 9i, 10g, 11g
Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL
Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.Toad, Putty, NX client, Winscp, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client
Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import
Ticketing : Service now
Remedy
Contact this candidate