Uploaded File
Briane
brianabane24@gmail.com
240-615-7285
Texas City, TX 77590
ORACLE DBA / AWS SOLUTION ARCHITECT / CPA GLOBAL
8 years experience W2
0
Recommendations
Average rating
50
Profile views
Summary

  • Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, and STATSPACK.
  • Have ample knowledge in implementing policies, and procedures for disaster recovery and archival processing to ensure data protection.
  • Expert in delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 10g OEM Grid monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
  • Experience with SQL coding including DDL, DML and fine-tuning those SQL's for better performance.
  • Experience in using 10g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Recycle Bin, 10g Grid Monitoring. Expert in RMAN backups including full, incremental and cumulative.
  • Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Experience in applying patches/ patch sets to the databases.
  • Extensively worked on Import/Export and Data Pump Import/Export tools.
  • Knowledge in configuring ASM (Automatic Storage Management)
  • UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.
  • Expert in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and replication using Streams.
  • Perform database monitoring and tuning to ensure databases run at peak performance; troubleshooting production performance issues.
  • Extensively managed users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).
  • Excellent communications and interpersonal skills.
  • Installation and consolidation of 12c multitenant database's in QA and Test environments. Container and Pluggable database administration and cloning.
  • Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Streams.
  • Remote administration and support of Oracle production and development Databases on major Operating Systems with sizes up to 2 TB.
  • Experience in Installation of Oracle Databases 9i, 10g, 11g and 12c versions.
  • Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.
  • Experience in configuration of Oracle 10g, 11g and 12c physical & logical standby database using Data Guard.
  • Good hands-on experience in configuration of Oracle 10g R2, 12c OEM Grid Control to monitor database.
  • Configuration and Management of Data Guard on RHEL, OEL.
  • Experience in creating and managing control files, redolog files, data files and archive redo log files.
  • Experience in Database and table reorganization using methods like Online table reorganization, coalesce, deallocate and shrink space.
  • Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage Area Networks (SAN)/Network Attached Storage (NAS).
  • Implementation of Flashback Technology, Log Miner, Automatic Database Diagnostic Manager (ADDM).
  • Proactively monitoring the database's health and taking preventive or corrective actions
  • Expert experience in Hot and Cold Backup and Recovery, cloning of databases using RMAN, Veritas NetBackup and IBM Tivoli Storage Manager (TSM).
  • Proficient in using various database Utilities like EXPORT/IMPORT, Data Pump, TOAD.

Experience
ORACLE DBA / AWS SOLUTION ARCHITECT
Information Technology
Mar 2016 - Jan 2018
Texas City, TX
  • Worked as a team member for 24x7 support with on call rotation in all prod, QA and dev environments.
  • Worked on Multitenant Databases (Oracle 12c Container and pluggable databases)
  • Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions.
  • Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.
  • Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration
  • Installed and configured Oracle 12c Enterprise manager to monitor and report the Database health for over 500+ databases
  • Upgraded databases from 9i to 10g, 10g to 11g, 11g to 12c and minor version upgrades
  • Setting up High Availability Oracle Golden Gate systems on Oracle 11gR2 RAC environments
  • Installation and creation of 11g databases for Testing & Development on both IBM-AIX and Linux environment in OLTP, Decision Support System Data Warehousing environment.
  • SQL tuning - AWR history of sql execution, index recommendations, SQL Tuning Advisor, SQL Access Advisor, Real Time SQL Monitoring, Interpret Execution plans, Re-write more efficient SQLs.
  • Proficient in Oracle High Availability features like RAC, DATA GUARD, GRID CONTROL and Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL-Tuning Advisor, EXPLAIN PLAN, TK PROF, and DBV.
  • Performed Data file recovery from logical and physical block corruptions
  • Work with Oracle Data Pump (expdp and impdp) which provides high data and metadata movement of Oracle database contents. speed, parallel, bulk
  • Management of schema objects, partitioning of tables & indexes and performing SQL*Loader jobs for loading data from flat files (ETL) and Oracle Database monitoring, troubleshoot and resolve the issues.
  • Provide support to developers to enhance their SQL, PL/SQL code and responsible for setting up of new user accounts, schema Deployments and related user administrative tasks.
  • Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
  • Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
  • Used GOLDEN GATE for Zero Downtown Upgrade and Migration
  • AWS Certified Solutions Architect with excellent proven track record in providing solutions
  • In-depth knowledge on various AWS Services including EC2, VPC (NAT, Peering, VPN), IAM, EC2 Container service, Elastic Beanstalk, Lambda, S3, Cloud Front, Glacier, RDS, Dynamo DB, Elastic Cache, Redshift, Direct Connect, Route 53, cloud watch, Cloud Formation, Cloud Trail, Opsworks, Amazon Elastic Map Reduce (EMR), AWS IoT, SNS, SQS, Lambda, API Gateway, AWS Alexa etc.
  • Good knowledge and experience using AWS Lambda for Server-less computing using Python and Java.
  • Experience working on administering various AWS Services using AWS Console, AWS CLI and using Amazon Api using python, Node.js & Java.
  • Experience implementing Security using ACL, Security groups, Private-subnets, Encryption on Transit and Encryption at rest.
  • Experience working on Migrations from On-prem to AWS Cloud
  • Experienced in automating, configuring and deploying instances on AWS, Oracle cloud environments and in Data centers.
  • Expertise in scripting for automation, and monitoring using Shell, PHP, Python & Perl scripts.
  • Worked with Custom AMI's, created AMI tags modified AMI permissions.
  • Created Security Groups, configuring Inbound /Outbound rules, creating and importing Key Pairs.
  • Leveraged AWS S3 service as Build Artifact repository and created release based buckets to store
  • J.B HUNT TRANSPORT Inc.
DBA Data Replication Data Warehousing Oracle PL/SQL Performance Tuning Database Upgrades Database Backups OLTP Solutions Architecture SQL Linux Quality Assurance Python Perl AWS CloudFormation Database Maintenance Database Reorganization Golden Gate AWS Lambda AWS EC2 AWS AWS Cloudfront AWS S3 Cloudwatch Elastic Beanstalk PHP Scripting IAM Oracle 12c Oracle Cloud
Remove Skill
ORACLE DATABASE ADMINISTRATOR
Information Technology
Feb 2014 - Mar 2016
New York City, NY

  • Worked as a team member for 24x7 support with on call rotation in all prod, QA and dev environments.
  • Worked on Multitenant Databases (Oracle 12c Container and pluggable databases)
  • Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions.
  • Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.
  • Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration
  • Installed and configured Oracle 12c Enterprise manager to monitor and report the Database health for over 500+ databases
  • Upgraded databases from 9i to 10g, 10g to 11g, 11g to 12c and minor version upgrades
  • Setting up High Availability Oracle Golden Gate systems on Oracle 11gR2 RAC environments
  • Installation and creation of 11g databases for Testing & Development on both IBM-AIX and Linux environment in OLTP, Decision Support System Data Warehousing environment.
  • SQL tuning - AWR history of sql execution, index recommendations, SQL Tuning Advisor, SQL Access Advisor, Real Time SQL Monitoring, Interpret Execution plans, Re-write more efficient SQLs.
  • Proficient in Oracle High Availability features like RAC, DATA GUARD, GRID CONTROL and Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL-Tuning Advisor, EXPLAIN PLAN, TK PROF, and DBV.
  • Performed Data file recovery from logical and physical block corruptions
  • Work with Oracle Data Pump (EXPDP and IMPDP) which provides high data and metadata movement of Oracle database contents. speed, parallel, bulk
  • Management of schema objects, partitioning of tables & indexes and performing SQL*Loader jobs for loading data from flat files (ETL) and Oracle Database monitoring, troubleshoot and resolve the issues.
  • Provide support to developers to enhance their SQL, PL/SQL code and responsible for setting up of new user accounts, schema Deployments and related user administrative tasks.
  • Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
  • Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
  • Used GOLDEN GATE for Zero Downtown Upgrade and Migration
DBA Data Replication Oracle PL/SQL Performance Tuning Database Upgrades Database Backups OLTP SQL Linux Quality Assurance Data Warehousing Database Maintenance Database Reorganization Golden Gate Oracle RAC Metadata
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
SALVATION BILINGUAL HIGH SCHOOL
ORACLE UNIVERSITY OCA
Certifications
Advance Level Certificate) * SIANTOU UNIVERSITY COMPLEX YAOUNDE( ASSOCIATE DEGREE
Skills
Data Replication
2018
3
Data Warehousing
2018
3
Database Backups
2018
3
Database Maintenance
2018
3
Database Reorganization
2018
3
Database Upgrades
2018
3
DBA
2018
3
Golden Gate
2018
3
Linux
2018
3
OLTP
2018
3
Oracle
2018
3
Performance Tuning
2018
3
PL/SQL
2018
3
Quality Assurance
2018
3
SQL
2018
3
Metadata
2016
2
Oracle RAC
2016
2
AWS
2018
1
AWS CloudFormation
2018
1
AWS Cloudfront
2018
1
AWS EC2
2018
1
AWS Lambda
2018
1
AWS S3
2018
1
Cloudwatch
2018
1
Elastic Beanstalk
2018
1
IAM
2018
1
Oracle 12c
2018
1
Oracle Cloud
2018
1
Perl
2018
1
PHP
2018
1
Python
2018
1
Scripting
2018
1
Solutions Architecture
2018
1
Disaster Recovery
0
1
RHEL
0
1
Shell Scripts
0
1
Veritas NetBackup
0
1