Talented IT Professional specializing in high-performance Database Management, working on multi-disciplinary teams which were responsible for data-security/integrity. Accustomed to working on multiple projects and priorities in a fast-paced environment. Innovative solutions-focused DBA with 5 years of professional experience in working on various projects on RDBMS’s.
Strong knowledge of Oracle Tools and utilities.
In depth knowledge of Oracle backup and recovery scenarios with and without using RMAN.
Knowledge of data quality, management, security and data testing strategies and practices.
Strong Unix scripting knowledge
Solid experience in supporting large database with heavy OLTP and batch activities
10g, 11g Database Administration
11g Real Application Cluster (RAC) on ASM installation
Data Guard Administration
RMAN Backup and Recovery
Operating Systems: Microsoft, Windows 2000, 2003 & 2008 Advanced Server, Red Hat (Linux), UNIX, VM Ware, OBI KPI’s, Powershell
Networking Topologies / Protocols: Ethernet, TCP/IP
Programming Languages: SQL, PL/SQL, SQL*PLUS, BASH
Software Applications/Tools and Utilities:
Data Migration-Export-Import, Backup & Recovery Performance Tuning-SQL-Loader, and Dataguard.
Oracle Database Administrator 04/2015 to Present
Laboratory Corporation of America
•Navigation and management of Linux/ Windows OS’s such as creating files, directories, rename and copy, function as Root Administrator, change modes and ownership of files/directories.
•Fair knowledge of partitioning/space allocation from the Linux/Windows OS. (test experience only)
•Create, design, delete and manage Oracle Data Warehouse and OLTP databases.
•Experienced in managing a Data Warehouse in a test/ development environment.
•Maintained an 11g OLTP database using security encryption and Fine Grain Access Control.
•Create, delete, manage views, tables, tablespaces, indexes (including rebuild), sequencing, job function, procedures, triggers and constraints in line with resource planning guide.
•Experienced in creating and managing audits (including fga policies).
•Design scripts and develop tools to automate periodic tasks such as backing up archive logs, control files, redo logs, system, sysaux, temporary and undo tablespaces to improve monitoring of the system
•Managed multiple databases and instances using Data Guard, RAC in a real time production, testing, and development environment.
•Experienced in setting up OMF’s, multiplexing files, import/export of database/data with and without encryption.
•Experienced in utilizing DBCA, NETCA, NETMGR, OEM, Listener Configuration.
•Work collaboratively with other team members such as Project Manager, developers and architects to ensure project success.
•Fair knowledge of Oracle internals (latches, system waits, resource allocation, access parameters).
•Used Enterprise Manager DB console to monitor performance, clone databases, tuning and maintaining optimal performance.
•Used Oracle Grid control on UNIX/Linux and Windows to maintain a 500Gb database with a group of DBAs in a 24/7 365 production environment involving technical proficiency.
•Used Data Pump for migration, Remapping, SQL*loader.
•Generated Reports using SQL Developer and preparing memo to communicate progress and providing early alerts for major updates.
•Good knowledge of Oracle backup and recovery scenarios with and without using RMAN.
•Used Enterprise Manager to schedule backups.
•Used Data guard to perform both switch over and failover exercises in a test environment.
•Configured and managed database backups (full and incremental), restores, cataloguing, and migrations on primary servers and across servers within a project.
•Used SQL*Plus, Oracle SQL Developer, Putty, PL/SQL, Command-line tools to accomplish projects.
•Advanced troubleshooting using trace files, alert log
•Developed and enforced database related policies, standards, naming conventions, operating procedures and best practices.
•Monitored thresholds in relation to the FRA.
•Monitored database security by controlling and monitoring user access
Oracle Database Administrator 12/2013-02/2015
Tasty Baking Co, LLC
•Patched and installed Oracle software.
•Supported and troubleshot to detect and correct problems.
•Setup brand new machines including Oracle software installation, Oracle side configuration, third party backup software troubleshooting and backup testing with Project Manager.
•Used incremental and full back up; Auto-backup with Job function.
•Experienced in working with DBMS automation scripts, and deploying scripts.
•Linux environment experience with Data guard.
•Monitored (alert log, memory, disk I/O, CPU, database network connectivity) using enterprise manager.
•Worked daily on incremental backup and weekly on full database backup.
•Used OEM to schedule backup.
•Handled disaster testing.
•Cloning and creating new databases using operating system commands.
•Managed and monitored direct database access security, data integrity, enforcing constraints, and database privileges.
•Configured and monitored the TNS/Listener using NetCA, NetMgr.
•Used Data Pump to implement database refresh with the hot backup using DUPLICATE or full export.
•Used EXPORT/IMPORT to do table level and full database defragmentation.
•Executed Oracle 10g logical and physical databases design, implementation and maintenance on UNIX.
•Performed tuning using the AWR, ADDM to guide tuning and maintain high database availability and reliability.
Oracle Database 11g: Oracle Certified Associate 2017
Oracle Database 11g: SQL Fundamentals I 2016
Jelani Consulting -- Oracle Database Administrator Training 2016