Database Administrator Sql Developer

Location:

Las Vegas, NV

Posted:

April 21, 2023

Contact this candidate

Resume:

LESLIE ATOKA

781-***-****

adwn8d@r.postjobfree.com

SENIOR ORACLE DATABASE ADMINISTRATOR(DBA)

Professional Summary

An enthusiastic Oracle Database Administrator contributed with Jelani Consulting for over 5 years of experience in database security and user management, backup and recovery, disaster recovery, database performance tuning, database design, monitoring, Migration, Upgrades, Cloning and Replication. I have experience across a multitude of platforms (LINUX, Solaris, UNIX, and Windows) in development, test and production environments. Experience on different versions of Oracle including 10G, 11G, 12C, 18C and 19C. I am an enthusiastic, proactive team player who is fast at picking up new technology with great attention to detail. I possess excellent leadership ability and creative problem-solving skills in both strategic and tactical areas as well as great communication /documentation skills. With my strong aptitude to analyze and resolve problems, I have a well- honed ability to adapt and thrive in a dynamic fast paced and challenging work environment.

AREAS OF EXPERTISE INCLUDE

• Backup and recovery

• Upgrades and Migration

• Security and patching

• Transparent data Encryption

• Performance monitoring and tuning.

• Installation, Configuration and capacity planning

• Oracle ASM

• Grid Control

• Oracle Data Guard & Data Pump

• Oracle Golden Gate & RAC

• Bash/Unix Shell scripting & Automation Database Cloning TECHNICAL SKILLS AND TOOLS DATABASE SECURITY (TDE)

Backup & Recovery using RMAN

Real Application Cluster (RAC)

Experience on 12c and 19C

Monitoring and performance tuning using OEM Console, Toad, SQL

Developer, Grid Control, Explain Plan, AWR, ADDM & DRA

Work with various operating systems like MS Windows Servers (2008, 2012, 2014), UNIX,SOLARIS, LINUX

Database migration using Exp/Imp/Data pump, and SQL Loader, Oracle Automatic Storage Management ASM (clusters) and Real Application Clusters (RAC) configuration and administration Oracle Golden Gate (Data Replication) Oracle Data Guard installation/administration for High availability and Disaster Recovery (DR) SQL, PL/SQL, UNIX Shell Scripting Installation, configuration and update of Oracle 10g, 11g, 12c, 18c & 19c using OUI, DBCA, DBUA

ORACLE GOLDEN GATE

ORACLE EXADATA

GRID CONTROL

PROFESSIONAL EXPERIENCE

(DATAONE SOLUTIONS: August2022 – Present)

Implementing the latest leading-edge Oracle technologies while optimizing their current infrastructures. I am currently working as a remote Senior Oracle DBA providing Operational and production DBA support and maintaining database high Availabilities. Worked in a cross functional team that oversaw the Real application clusters installation and configuration for Linux environments.

•Rewrote and implemented a backup strategy following company SLA; execution of backup schedule for both physical and logical backups using RMAN and DATA- PUMP utilities respectively. I also used block change tracking (BCT) which reduced backup time from 8hrs down to 45mins.

•Deployed Database security policy and installation, using passwords, privileges and user profiles, Used Oracle Transparent Data Encryption to encrypt columns, tables and Tablespaces, I also implemented the “triple A” (AAA) and database auditing policies as well as data redaction.

• Installed and administered Oracle Physical Standby Database for Single and multiple instances to achieve high availability and DR solution (DATA GUARD) Managed database security by creating, assigning appropriate roles & privileges to users depending on user activity, auditing, & performing other security related tasks including Transparent Data Encryption.

•Cloned databases using RMAN and DATA-PUMP utilities for all database sizes.

•Extensively used AWR, ADDM, ASH, and Explain plan for periodic Performance tuning.

•Monitored AWR, ADDM, ASH, Alert log, dynamic performance views, DBMS_STATS, Trace Files, System Event Logs for unusual events & took appropriate action according to company policies of incident reports.

•Experience migrating database objects from development through test & into production environments.

•Capacity planning (supported 3 tier architecture, planning of tables, indexes, tablespaces and databases) to allow for growth potential and analyze data growth trends for capacity and resources.

• Installed and administered Oracle Physical Standby Database for single and multiple instances to achieve high availability and DR solution (DATA GUARD).

•Capacity planning to meet the demands of the dynamic aspects of storage & memory for the databases.

•Performed database Refreshes from production environments.

• Implement table and index partitioning to Minimize DB time, increase disk load balancing, improve query speed and enable faster parallel query. PROFESSIONAL EXPERIENCE

(JELANI CONSULTING: February2017 – August2022) REMOTE ORACLE DATABASE ADMINISTRATOR

•Supported daily administration, monitoring, tuning, and troubleshooting on single instance on UNIX/Linux, Windows server 2003, 2008, 2012 and 2016

(Database sizes range 100GB to 21TB).

• Implemented a backup and recovery policy under tight SLA times using RMAN and Data Pump.

•System Development Life Cycle (SDLC) methodology for designing, analysis, development & implementation.

•Championed database migration from 10g to 11g and database upgrade from 12c to 18c using the Oracle Data Pump and DBUA utilities respectively. Currently testing 19c

• Installed and configured software for Oracle 10g, 11g, 12c and 19c on both Windows and LINUX platforms using Oracle OFA. Also Installed, Administered and Maintained SQL Server Instances 2008 and 2012.

•Used range, hash and composite table partitioning which greatly decreased the DB time and SQL Execution time. Also performed instance tuning by changing init.ora parameters and managed region parameters such as shared_pool_size and db_cache_size with the use of AMM and ASMM.

•Worked on migrating Oracle databases to AWS RDS using Database Migration Service (DMS)

•Worked on S3 buckets and cloud trails to monitor logs and backups

• Implemented and installed Data Guard Broker for EC2 instances and supported High Availability in multi-AZ locations.

• Installed the application of AWS EC2 instances and configured the storage of S3 buckets

•Maintaining Database security policy and installation, using passwords, privileges and user profiles, Used Oracle Transparent Data Encryption to encrypt columns, tables and Tablespaces, I also implemented the “triple A” (AAA) and database auditing policies as well as data redaction.

•Created databases from Entity Relational Diagrams (ERD) in Forward Engineering using the Oracle SQL Developer to OFA Institution and finally to DB launch.

• Installed and administered GOLDEN GATE in a unidirectional, bidirectional, and broadcast configuration to mainly replicate data and ensure high availability, in a heterogeneous environment, also worked with EXADATA Machines for high performance and availability.

•Configured Oracle tools like SQL*Net to access the database across the network.

•Configure and manage ASM instances on Oracle 11g, 12c,18c, 19c.

•Worked in a cross functional team that oversaw the Oracle RAC installation & configuration for Linux environments.

•Part of the on-call production support team for 24/7 on-call production support.

•Developed standard operation procedures to ease operational support.

•Database monitoring/maintenance, replication process and performance tuning using OEM Automated processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

• Involved in the installation, configuration and extended support to Oracle 10g two Node RAC with ASM file system on Sun Solaris platform.

• Involved in converting a single instance database to Oracle 10g RAC databases.

•Maintaining highly reliable 24x7x365 Linux production servers for AWS EC2 instances.

•Part of the on-call production support team for 24/7 on-call production support.

•Administered a Mongo DB to create, update, delete and read documents, in a limited role.

•Creating standard operational procedures to ease operational support.

•Administered a Mongo DB to create, update, delete and read documents, in a limited role.

• Creating standard operational procedures to ease operational support. PROFESSIONAL EXPERIENCE

(ORANGE CAMEROON March2016 -September2016)