Hannah Ngobatasi

Laurel, MD Mobile:313-***-**** add6dl@r.postjobfree.com

Experienced Database Administrator

Dynamic, solutions-oriented Database Administrator with 7+ years of experience working on multiple database versions running on different platforms, including Linux, Windows, AIX, and Solaris, delivering expert technical knowledge in both production and project support environments. Excel at managing all database related activities as mentioned below. Proven capacity to work collaboratively on conducting requirements gathering, project scoping and acceptance testing. Adept at planning, prioritizing and scheduling work activities to ensure project targets are consistently achieved. Proactive, able to work with various technical teams developing solutions to applications and database development projects and integration.

CORE COMPETENCE ( ORACLE)

Oracle Database Administration Production & Project Support Performance Tuning Backup & Recovery Database Refresh Patch/upgrades Management Migration Security Management Configuration: RAC, Data Guard, Golden Gate Shell Scripting SQL SERVER PostgreSQL Project Management Team Leadership Cross-Function Collaboration Application Customization Capacity planning Functions & Procedures Transparent Data Encryption (TDE) Data/object replication Disaster Recovery EXADATA PL/SQL Functions T-SQL

CORE COMPETENCE ( SQL SERVER)

Physical and Virtual SQL Server Database Security and Auditing

Microsoft SQL Server Installs High Available and Disaster Recovery (HA/DR)

Microsoft SQL Server Management Studio (SSMS) Backup, Restore and Recovery

Transact-SQL (T-SQL) Database Upgrades

Database Performance Tuning Data Export and Import

Data Warehouse and ETL Management

CORE COMPETENCE ( POSTGRESQL)

Physical and Virtual PostgreSql Database Security and Auditing

PostgreSql Installs High Available and Disaster Recovery (HA/DR)

PG ADMIN (GUI) Backup, Restore and Recovery

Database Upgrades Data Warehouse and ETL Management

Database Performance Tuning Data Export and Import

EDUCATION & PROFESSIONAL CERTIFICATION & OTHERS

Bachelor’s Degree, Information Technology, University of Buea, Cameroon, 2012

CERTIFICATIONS: Oracle SQL Certified, Oracle Certified Associate (OCA 12c)

: Oracle Cloud Infrastructure Architect Associate (OCI) 2019)

: AWS Certified Solution Architect Associate

: CompTIA Security+

CLEARANCE: Active Public Trust

COMPUTER SKILLS

Database (RDBMS): Oracle 10g, 11g, 12c, 18c, 19c SQL Server, 2012, 2014, 2016 PostgreSQL (9.X, 10.X, 11.X)

Operating Systems: Windows 2008 /2010/2016/NT, RHEL 2.1, 3.X, 5.X, 6.x, 7.x (RedHat UNIX/Linux Enterprise Server

9,10.), AIX5.1, 5.2, 5.3, 6.1 Sun Solaris 2.5, 2.6, 8, 9, 10. HP-UX 10.x, 11.x.

Applications: HR, FIN, PEOPLESOFT, SAP, EBS, JIRA, KACE

DATABASE MANAGEMENT TOOLS

SQL SERVER: SSMS, SSRS, SSIS, SSDT, SSMA, SSAS, QUERY OPTIMIZER, PERFMON, BCP, T-SQL, PROFILER, BCP,

(POWER SHELL SCRIPTS), DBCC, FAILOVER CLUSTER MANAGER, DYNAMIC MANAGEMENT VIEWS, SQL SERVER MIGRATION ASSISTANT (SSMA), SSDT, INFORMATICA, TALEND, ALOOMA, POWER BI.

ORACLE: SQL PLUS, OEM (12c, 13c), TK PROF, RMAN, TOAD, AWR, ASH, SQL TUNING ADVISOR, EXPLAIN PLAN, ODI, SQL DEVELOPER, SQL LOADER, ADDM, DTA PUMP, SCT, DMS, MTK

POSTGRESQL: PG ADMIN, MTK, BART, PG_STATS, PG_POOL, ANSIBLE, TALEND, PG_UPGRADE, VACUUMING, GREENPLUM, NAGIOS, PG_BADGER, EFM, PEM, NAGIOS,

VACU

PROFESSIONAL EXPERIENCE

Riley Technologies, Mooresville NC February 2018 – Present Oracle Database Administrator/Production Support

Play an integral role delivering technical expertise to deliver support for multiple databases, production, development, testing and staging purposes on Sun Solaris and Windows environments. Effectively and efficiently monitor performance and formulate solutions to optimize performance of the database and applications utilizing OEM and homespun scripts.

Migrated, oracle, Postgresql database to AWS cloud using SCT AND MDS tools and managed databases on EC2 instances.

Used ANSIBLE to automate task, create databases and run multiple batch jobs on the databases on EC2 instances.

Experience creating roles, database access, performing Vaccum operations

Support physical and logical design for database and data warehouse schemas.

Experience in implementation of monitoring tools such as Cloudwatch, Nagios, check_postgres.pl modules, splunk

Good understanding of performance optimization/Tuning on Aurora SQL Scripts, views, and procedures

Perform Extract, Transfer, and Load (ETL) functions to populate and build data warehouses.

Studied and stayed current on features and functionality of PostgreSQL.

Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization

Configuring PostgreSQL Streaming Replication and Pgpool for load balancing. Managing the monitoring tools for better performance like PgBadger, Kibana, Graphana, and Nagios

Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.

Responsible for all backup, recovery, and upgrading of all PostgreSQL databases

Successfully Deployed Database instances using Always-On Clustering, Database snapshots, Database mirroring, Log shipping, SQL Server Replication.

Designed SSIS-packages, including ETL processes and integrations with third parties.

Experience maintaining the SQL Server test environment and installing and upgrading SQL Server.

Played a major role in the team during the migration Of Oracle database to SQL SERVER and Oracle to PostgreSQL.

Configure Applications to leverage the Secondary replica for Reporting needs, which reduced the load off from the Primary instance.

Install & configure Database instances including add on components (Always on HA clustering, SQL Replication, Log Shipping, Integration Services, Reporting & Analytics Services, Disaster Recovery)

Proficient in managing Microsoft SQL Server 2014 and 2016 to include setting up security, creating tables, indexes, stored procedures, designing SQL reports, and creating maintenance jobsite

Communicate regularly with technical, applications and operational staff to ensure database integrity and security.

Monitor performance and manage parameters to provide fast responses to front-end users.

Install and test new database management systems to ensure data security, privacy, and integrity. Support and maintain Microsoft SQL database applications.

Perform GoldenGate automation using tools such as OBEY FILES, and SHELL Scripts

Ability to migrate from Oracle 9i to 12c using Oracle GoldenGate

Migrating Goldengate old versions to High and upgraded versions (11gR1, 11g R2)

Experience with cross server GoldenGate replication (Oracle to Oracle and Oracle to SQL Server)

Configured Goldengate 12c RAC – RAC/EXADATA Active configuration with 11g database.

configuring and maintenance of Oracle Replication Tool using Oracle Golden Gate. Performed database replication through Golden Gate.

Performed database replication through Golden Gate.

Configured and worked in Oracle GoldenGate installation, configuration, troubleshooting GoldenGate issues.

Strong experience in Oracle DBA tasks like Installation, creation, maintenance, performance tuning, problem identification, resolution and migration in production and development environments.

Expert knowledge in installing oracle database server on SOLARIS, HP-UX, AIX, WINDOWS NT, LINUX and migration of oracle server from 9i to 10g and 10g to 11g and 12c.

Expertise in migrating single instance databases to multi-nodes 10g, 11g R1, R2 and 12c RAC/EXADATA environments for high availability, scalability and load balancing.

Walgreen Company, Deerfield IL January 2013 – January 2018

Oracle Database Administrator/PRODUCTION SUPPORT

Provided technical expertise supporting multiple databased for production, development, test and staging across multiple platforms. Worked on set up of infrastructure for databases in large data centers. Performed database backup and recovery utilizing RMAN. Played a key role in troubleshooting backup issues. Contributed to performance tuning related issues and query analysis. Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.

Installed and upgraded database management systems, monitor, maintain and performance tune all production, test and development databases including but not limited to, Oracle and SQL server.

Monitor and troubleshooting of SQL Agent jobs, SSIS packages, and Walgreen software as required

Analyze SQL SERVER services to determine if they are running properly or if they are causing any system- related problems (i.e. query performance, hardware utilization, database, and system log monitoring)

Develop and implement corrective measures for database issues/problems found during monitoring.

Oversee and perform backups, restoration, clustering, mirroring, replication, and failover and recover corrupted databases.

Installed, configured, and upgraded database applications by applying patches and upgrades on a regular schedule (daily, weekly, and monthly, in accordance with industry standard or as requested by the program management).

Responsible for merging data from multiple sources into a data warehouse using the ETL process and different ETL tools such as Informatica, TALEND or inbuild SQL SERVER tools such as POLYBASE.

Always looked for opportunities to improve performance using database optimization techniques (both from database design perspective and T-SQL tuning).

Develop DBA administration scripts using T-SQL, stored procedure, SSIS packages, and Power Shell scripts. Assist with the development of ad-hoc SQL, stored procedures/views, and tune them to improve performance.

Builds database scheme, tables, procedures, and permissions. Create and manage constraints and indexes

Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms

Loading data from flat files to database using SQL*Loader, External Tables.

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

Involved in the installation, configuration, and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.

Involved in converting a single instance database to Oracle 11g, 10g RAC databases using Rconfig. Installed ASM environment and migrated databases from NON-ASM to ASM.

Collaborated, cross-functionally on the installation, configuration, and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system.

Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).

Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

Installing, configuring and maintaining Enterprise Manager Cloud Control to monitor and manage regular databases. Used TOAD for database management.

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

Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.

Developed RMAN Cold Backup Script to take backups automatically every week for about 200 databases vary in size from 200GB to 2TB and automated the process through Scripts and Crontab.

Performed full and incremental backup (cumulative and differential) using RMAN and implemented recovery strategies. This help to speed up recovery process in this environment.

Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performance and troubleshooting issues in RAC environment (11GR2).

Ran Scripts for Health Check on RAC, Data guard and all standalone databases.

Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.

24 X 7 Production & Development database support and administration. Made optimal use of Oracle Support in resolving the SRs.

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

Database refreshes using Datapump and RMAN for database Duplication and cloning.

Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).

Documented the Standard Processes for peers to follow.

Implemented Flashback technology of the Oracle 11g, 10g along with Recycle bin for a faster recovery of the databases and database objects.

Refreshed/cloned databases using RMAN utility.

Applying upgrade patch, maintenance and interim (Opatch) patches on all the databases. Performed Database upgrade from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC.

Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes

Contact this candidate