Manager Data

Caroline Awoh

Email: *************@*****.*** Phone: 313-***-****

Technical Skills

Databases

Oracle 18C/13C /12C/11G/10G, AWS RDS, PostgreSQL,Amazon Aurora, MySQL 5.6, PostgreSQL, MS sql Server, Redshift, Dynamo db

Operating Systems

Hp-UX 10.x, 11.x. Sun Solaris 8, 9, 10. AIX 5.3, 6.1, RHEL 5.x, Linux Enterprise Server 9, 10. Windows 2012

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM, Performance insights, NACL

Languages

SQL, PL/SQL, SHELL, BASH, C/C++,Java, python, SAS, Jason, C#

Utilities

RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, TOAD, Oracle SQL Developer, Lambda, EC2, Docker, DMS, SCT, Jason

CERTIFICATION

Oracle Database 12c Certified Associate, OCA

AWS Certified Solutions Architect Associate

AWS certified Solutions Architect Professional

Professional Summary

I am an accomplished and seasoned IT professional with 7 years of proven experience in Oracle database administration and AWS architectural Design, automating and supporting Mission critical Deployment in AWS, leveraging configuration management,CI/CD and DevOps Processes.

I have worked in heterogeneous system environment including Solaris, UNIX, and Windows, supporting a variety of applications using Oracle 11g,12c,13c, 18c and 19c . I have Proven technical knowledge of rdbms infrastructure both Oracle and AWS RDS combined with outstanding leadership ability and creative problem solving skills. I have the ability to work in a versatile, dynamic fast paced and challenging environment both single or team-based roles with limited direction. I have excellent communication/documentation skills and a strong aptitude to analyze and resolve problems.

Skills

●I have Supported as Production and development DBA on OLTP, Data warehouse, OLAP environment. Involved in Change/Release/Patch management and off-shore co-ordination, Product development, data center Migration and administration including design, deploy, tune, trouble-shoot.

●Used Amazon Aurora to manage databases, automate scaling and creating endpoint in order to connect applications.

●Connfiguration management using Puppet, and Ansible

●Knowledge of Python, C/C++, and Java

●Uses SAS for data management, Business Intelligence and Advanced Analysis.

●Version control systems: Git, Subversion, and Perforce

● have designed and implemented AWS services as a solutions Architect

●I have used basic AWS compute Services like

●Installed and Configured and managed a Unidirectional topology for Golden gate

● Used MySQL Workbench to manage database, security, backup and recovery.

●Worked on Oracle Exadata Machine and Golden Gate

●Used MySQL Replication to scale out,read workloads, provide high availability and geographic redundancy, and offload backups and analytic jobs. From MySQL server ( Master) to MySQL server (Slaves).

●I am Efficient to manage 50+DB. VLDB size in 5 TB

●I have Upgrade databases from 11g to 12c. Apply PSU and bug fix patch. Trouble-shoot upgrade process. Upgrade ASM and RAC and Validate database objects as well.

●Managed Databases on Aurora

●Extensive experience defining IT Road-map, cloud strategy, Enterprise/solution architecture assessment .

●I have Installed and Configured PostgreSQL from source or packages on Linux machines . Performed Minor and major upgrades on PostgreSQL from 8.4.x to 9.4x

●Implemented migration tasks from Oracle apps to PostgreSQL databases.

●I have Installed and Configured PostgreSQL from source or packages on Linux machines.Performing upgrades on PostgreSQL from 8.4.x to 9.5.x.

●Detailed knowledge of Microsoft SQL Server technology and how to Administer, create, upgrade, maintain, STIG, and customize manually and using SQL Queries

●Maintained RAC configuration including but not limited to VIP management, relocated services, add/delete/modify objects etc.

●Migrated databases From oracle 11g to Amazon RDS and Aurora PostgreSQL using Schema Conversion tool SCT and the data migration Service DMS.

●I have done Backup of Databases based upon Business Strategy: Daily Backup, weekly Backup etc.) using RMAN .Logical backup of schemas using expdp/impdp.

●Recovery of Databases (Media Failure,Block Corruption, drop table etc.)

●Created 12c multitenant container database using DBCA .

●I was part of a project with Expertise in configuration and Installation of RAC on Linux and Solaris using ASM and RAW devices and Oracle CRS.

●Expertise in maintaining Database Security using security compliance auditing, data masking, data reduction and data encryption using TDE

●Experience using Exadata machines

●Provisioned RDS and EC2 insurances using cloud formation Templates

●I also have Debug PL/SQL objects, function/ stored procedure/ packages Create trigger/ . Manage cursor. Tune and trouble-shooting PL/SQL codes. Handle run-time errors. Create Materialize view.

●Performance, Tuning of databases using ADDM, AWR, explain plan, stats pack, TKPROF and dictionary views. Gather statistics, de-fragmentation of table, re-organize structure. Monitor memory, index, Schedule jobs, Partition pruning for big table. Top sql/session, bottle-neck issues. Tune init parameter. Full table scan and Index usage. Tuned RAC databases, Golden Gate and Dataguard.

●Loading data using Import/export/ sql loader. Purging /cleansing data. Used Data Pump. Estimate timing for imp/exp. Refresh schema.

●Experience with mid-tier architectures, OEM, TOAD, Oracle grid-control.

●Excellent Written and verbal Communication skills with a customer service oriented attitude.

Work Experience

Bristol Mayers Squibb (BMS) / DXC Technology Princeton New Jersey

November 2019 to July 2020

Role: Database Administrator/ AWS Cloud Engineer

Responsibilities:

●Managed database on AWS RDS (PostgreSQL, Oracle, mysql and Microsoft sql Server)

●Provisioned RDS and EC2 instances on Linuz and windows platforms using AWS Cloud formation Templates.

●Installing and configuring connection pooling tools like Pgbouncer and pgpool etc.

●Support 100+ production Oracle 19c databases

●Perform Upgrades from 12c to 19c

●Installing and monitoring PostgreSQL database using the standard monitoring tools like Nagios etc.

●Configuring log analyzation tools like pgfouine and pgbadger etc.

●Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.

●Used mainframe for census, transaction processing and customer statistics

●Created and developed ETL tools Using Informatica/MSBI, tuned ETL processes

●Migrate Oracle and SQL Server databases from on-premise to AWS RDS ( Oracle, mysql and Postgress) using Data Migration Services and Schema conversion tool.

●Used SQL Server Replication for copying and distributing data and database objects from One database to another synchronously

●Worked on production SQL server databases with several configuration, performance tuning, high availability/disaster Recovery solutions; Failover clusters, replication, log shipping and mirroring.

●Managed GitHub repositories and permissions, including branching and tagging

●Used Python programming to develop object oriented programming to enhance company product management..

●Automated build and deployment using Jenkins to reduce human error and speed up production processes.

●Actively selected, manage, improve, and monitor cloud infrastructure on AWS, EC2, S3 and RDS including backups, patches and scaling. Worked on Elastic Beanstalk, EFS, VPC, RDS, Glacier, IAM, Kinesis, Cloud Front, Cloud Watch, Cloud Trail, Elb, Redshift,DynamoDB, Lambda, Route53, SNS, SQS, API Gateway, Code Pipeline.

●Use Python language in handling all hits Django redis and other applications.

●Design front end application using Python and also development and deployment and maintenance of web applications based on Django-Python.

●Designed and deployed scalable highly available, and fault tolerant systems on AWS using Auto Scaling, making use of AZ, Elb, S3, EBS resources.

●Lifted and shifted on-premises application to AWS with the help of AWS Cloud Adoption Framework.

●Reduced costs by $2000 monthly by eliminating unnecessary servers and consolidating databases.

●Identified appropriate use the AWS Well-Architected Framework combined with implementation.

●Analyzed data variances from databases using SAS, for Business intelligence

●Secured infrastructure on AWS using IAM, KMS, Cognito, API Gateway, Cloud Trail, Cloud Watch, Config, Trusted Advisor, Security Groups, NACL Responsible for Oracle (RDS) performance tuning

●Build and deployed Docker containers to break up Monolithic app into microservices, improving developer workflow, increasing scalability and optimizing speed.

●Create and maintain fully automated CI/CD pipelines for code deployment using Octopus Deploy and PowerShell.

Hyundai Information Service North America- Montgomery, AL

August 2017 – October 2019

Role: Oracle Database Administrator / AWS Cloud Engineer

Environment: RHEL 5.X, 6.X; Windows NT 2000/2003; Oracle 10g, 11g, 12c ; AWS RDS

Responsibilities:

●Primary DBA for 100+ databases of Oracle 10g/11gR2 on Linux REHL, HP-UX.

●Worked as per ITSM/Remedy Incident ticket/Critical Response Time (CRT) call.

●Responsible for MySQL performance monitoring, provided technical assistance of database software components and upgrades, performances tuning, backup and recovery strategies and replication.

●Used PgAdmin for administering PostgreSQL databases. Assist in designing and managing PostgreSQL schemas and tables.

●Performing schema management, database sizing, maintaining privileges.

●Data migration while upgrading database versions.

●Extensive experience with Warm Standby (PostgreSQL 8.x and earlier), and Hot Standby (PostgreSQL 9.x and greater).

●Performance monitoring and optimization

●Installing and configuring Object level replication like Slony etc.

●Installing and configuring connection pooling tools like Pgbouncer and pgpool etc

●Installed and Configured Golden Gate for unidirectional topology . Involved in Lag resolution and general performance Golden Gate troubleshooting.

●RAC- Administration/Trouble-shooting of 3 Node cluster on Oracle 10g/11G R2. Configuring Grid Infrastructure SCAN Listeners on 11gR2. Migrate OCR files to ASM. Managed ASM storage. ASM cloning. Prepare/Add/remove ASM disks.

●Provisioned RDS and EC2 instances on Linux and windows platforms using AWS Cloud formation Templates

●Migrate Oracle databases from on-premise to AWS RDS ( PostgreSQL, mysql, Oracle) using AWS data migration service and Schema conversion tool.

●Responsible for RDS performance monitoring.

●Create and maintain fully automated CI/CD pipelines for code deployment using Octopus Deploy and PowerShell

●Used ElastiCache for Redis for critical production Deployments either having encryption at rest and in transit, multi AZ availability for failed primary clusters to read replica in Redis cluster that support replication.

●Used mainframe for critical applications and bulk census data processing.

●Actively manage, improve, and monitor cloud infrastructure on AWS, EC2, S3, and RDS, including backups, patches, and scaling

●Reduced costs each month by eliminating unnecessary servers and consolidating databases

●Built and deployed Docker containers to break up monolithic app into microservices, improving developer workflow, increasing scalability, and optimizing speed

● Used Oracle Intelligence Business Suite (OBI) to provide centralized data access and calculation.

●Debugging PL/SQL scripts using SQL Developer

●Used stored procedures to create ETL processes

●Created source and targets mapping and ETL designs for integration of new or modified data streams Into the data warehouse and mart

●Data guard - configure primary -standby using duplicate from active database command of 11g. Apply SCN-based Incremental backup to sync standby after loss of Archivelogs on primary. Measure data loss based on latency/lag. Cross-platform migration using Data guard.

●Performed incremental backups using Recovery Manager (RMAN). Created recovery catalog, performed complete and incomplete recovery using RMAN.

Diagnose and repair block level corruption using RMAN backup/restore.

●Audit database performance using ADDM reports, AWR snapshot and diagnostic SQL scripts. Identify and tuning of ad-hoc queries, PL/SQL code . Tuning instance by init parameter. Used explain plan and stats pack/TKPROF utility to Improve response time of query. Create/manage local partitioned and bit-map indexes.

●Used Powershell to control and automate jobs on windows.

●Migrated VLDB multi terabyte databases around 10TB and redesigned the RMAN backup Strategy.

●Developed, modified and optimized very complex queries to data retrieval using Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.

●Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.

●Scheduled UNIX scripts in crontab jobs to automate daily tasks like backups, monitoring the alert logs, backup logs, cleaning the old archive logs, old log files, tablespace monitoring to send notification emails.

●Performed Online and Offline backups with RMAN, export/import and expdp/impdp. Performed Point in time recovery using RMAN

●Extensively used Oracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database

Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL

Performance Analyzer, Database Replay, SQL Plan Management, SQL Tuning

Automation, Flashback Database, compression techniques.

●Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results.

●Performed Schema &Table level Replication using Oracle Streams.

●Developing and maintaining OLAP cubes using SQL Server Analysis Services (SSAS)

●Database performance evaluation using Utility Control Point (UCP), Performance Monitor and Dynamic Management Views

●Implemented downstream capture at the destination db using Oracle Streams.

●Managed some small to medium size Cassandra and Mongo DB databases

●Installed and Configured Oracle OEM (Oracle Enterprise Manager) Grid sDdF.

●Supported & maintained the Production/Development databases on various servers

● Extensively worked on setting up auditing in many databases we supported.

●Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.

●Installed ASM environment and migrated databases from NON-ASM to ASM.

●Migrated databases from Oracle 11g to AWS RDS Using SCT and DMS.

●Selected appropriate AWS service based on data,compute, or security requirement and appropriate use of AWS Well-Framework.

Ally financials, Detroit Michigan

September 2013 - August 2017

Role:Oracle Database Administrator

Responsibilities:

●Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

●Successful in applying quarterly RDBMS patches for security and bug fixes to improve database functionality.

●Implemented proactive monitoring using Tuning Packs, Diagnostic Packs, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

●Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

●Plan and schedule RMAN backups (hot, cold and incremental backups)

●Setup 12c Oracle Enterprise Manager (OEM), used TOAD for database management.

●Implemented Transparent Data Encryption (TDE) for database security.

●Involved in converting a single instance database to Oracle 11g, 10g RAC databases.

●Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control

●Automated the Data Replication process using Materialized Views for reporting databases.

●Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.

●Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.

●Implemented switchovers on primary and standby databases as a part of planned maintenance activities.

●Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.

●Installed ASM environment and migrated databases from NON-ASM to ASM.

●Made optimal use of Oracle Support in resolving the SRs.

●24 X 7 Production & Development database support and administration.

Pacific System Inc - Atlanta, GA

July 2013 – September 2013

Role: Oracle DBA ( Intern)

Responsibilities:

●Serve as database administrator for Oracle 11g running on Linux Red hat 7 Operating systems.

●Used Oracle Enterprise manager (OEM) to manage Databases. Perform User managed backup using Recovery Manager(RMAN) and logical backups using datapump.

●utilize Structured Queried language (SQL) to manipulate data.

●Creat schema objects such as views, tables, indexes and sequences.

●Managed meta data through the data dictionary and dynamic views .

●Secure systems by granting and revoking privileges to manage user accounts, quotas and data auditing .

●Administered advanced security using Transparent data encryption to secure and encrypt sensitive data at rest.

●Made optimal use of Oracle Support in resolving the SRs.

EDUCATION

University of Buea Cameroon Bachelor of Science Degree in Accounting,2013

Contact this candidate