Oracle Database Administrator

SALIEU SESAY

Oracle Database Administrator

PROFESSIONAL SUMMARY

An accomplished Oracle Database Administrator with over 8+ years of experience managing and maintaining complex database systems.

Extensive experience in database administration, maintenance, and optimization, with a focus on Oracle and SQL Server environments and NOSQL.

Expert in utilizing RAIK (Redundant Array of Independent Kernels) technology to implement high-performance and fault-tolerant storage solutions, enhancing data availability and system reliability in multi-node cluster environments.

Expert with Oracle grid control, Oracle enterprise manager OEM, ASM, AWR, ADDM, Flashback Technology, SQL tuning advisor, SQL access advisor, and SQL server undo advisor.

Proficient in conducting regular database performance monitoring and tuning activities, analyzing SQL execution plans, optimizing query performance, and implementing indexing strategies to enhance overall system efficiency and response times

Experience in identifying poor SQL statements using EXPLAIN PLAN, STATSPACK, TKPROF, SQL TRACE, OEM Grid Monitoring.

Proficient in database backup, recovery, and disaster recovery strategies.

Skilled in performance tuning and query optimization, using tools such as Oracle Enterprise Manager and SQL Server Management Studio.

Managed and maintained multiple Oracle Database 21c instances, ensuring high availability, performance, and security. Led database installation, configuration, and upgrade projects for Oracle Database 21c across development, testing, and production environments.

Proficient in working on all kinds of backup operations using RMAN (full database, datafiles, image copies, incremental backup-sets, validating) using Flash recovery area, recovery operations (block media, full database, tablespace, datafiles, control files, point in time, validating) and catalog maintenance.

Experienced in designing, implementing, and maintaining database solutions to support business needs.

Familiar with cloud database technologies, such as Amazon RDS and Azure SQL Database.

Proficient in scripting and automation using PowerShell, Python, and Bash.

Expert in performing general DBA duties (installing software, creating databases, Enterprise Master Data Group, table spaces, adding redo log files, managing storage & working closely with Sr. DBA on capacity planning and performance tuning.

Experienced in working with database-related technologies, such as ETL tools, JAVA, reporting tools, and BI platforms.

Skilled in collaborating with cross-functional teams, including developers, system administrators, and business stakeholders.

Proficient in raising TAR with Oracle Support and using Meta-link to resolve the bottleneck in the database environment.

Experienced in Installing patches and upgrades of Oracle database software as well as in migrating and relocating from one OS platform to other.

Experience as On-Call 24x7 production DBA support.

Hands-on training on performance tester using Load Runner and JMeter.

Effective communication and documentation skills, with the ability to present complex technical information clearly and concisely.

EDUCATION

BS With Honors in Business and Information Technology

CERTIFICATION

Oracle Certified Associate

TECHNICAL SKILLS:

Languages

SQL*Plus, PL/SQL, Unix Shell Scripting (csh, ksh, bash)

Database Tools:

OEM, RMAN, Data Pump, Export/Import, SQL Loader, OWB, OID, ASM, Oracle RAC, Data Guard, Toad, SQL Developer, DPA

Hardware

Sun Sparc E series, HP 9000, IBM RS6000, Compaq, EMC, UCS blades

GUI

Developer 2000 (Forms 4.5, Reports 2.5), Developer 6i (Forms 6i, Reports 6i)

Miscellaneous Tools

BMC Patrol, Veritas Clusters, Veritas NetBackup, Tivoli Data Protection, Cron

Additional Skills

NoSQL, RAIK (Redundant Array of Independent Kernels)

Database

Oracle 19c/12c/11g/10g/9i, Oracle Golden Gate, Physical Data Guard, RAC

Operating Systems

Sun Solaris, HP-UX, IBM-AIX, Red Hat Linux, Windows Family

PROFESSIONAL EXPERIENCE

Liberty Mutual Finance Boston, MA Mar 2020 - Present

Oracle Database Administrator

Responsibilities:

Provided 24/7 Oracle production database support for Oracle 10g/11g/12c/19c RAC and standalone databases.

Implemented NoSQL database solutions (e.g., MongoDB, Cassandra) to support the storage and retrieval of unstructured data, improving scalability and performance for specific use cases.

Configured and fine-tuned RAIK (Redundant Array of Independent Kernels) for efficient load balancing and fault tolerance, optimizing resource utilization and ensuring high availability in distributed computing environments.

Managed and administered database systems as a DBA, Enterprise Master Datagroup including database installation, configuration, backup and recovery, performance tuning, and security management, ensuring optimal system operation and data integrity.

Performed database design assessments with technical Product Owners to build and deploy standardized database solutions that meet business needs.

Installed, configured, and maintained Oracle RAC and standalone databases.

Installed and configured OEM Grid control.

Installed and configured Oracle Golden Gate unidirectional and bidirectional replication.

Upgraded Golden Gate from 12c to 19c.

Proficient in Oracle Database 21c administration and managementStrong understanding of database architecture, performance tuning, and troubleshootingExperience with Oracle RAC (Real Application Clusters) and Data GuardFamiliarity with Oracle Enterprise Manager (OEM) and Oracle Cloud Infrastructure (OCI)Excellent communication and collaboration skillsStrong problem-solving and analytical abilities.

Managed, troubleshooted, and resolved Oracle database, RAC, and application issues.

Involved in upgrade/migration of the Oracle database from 11g to 12c, 12c to 19c.

Implemented high availability solution with Oracle 12c, 19c RAC, physical and logical standby, and replication using GoldenGate.

Developed back-end logic for business applications, e.g., views, procedures, functions, and triggers.

Monitored/managed several RAC and standalone databases using OEM Grid control.

Configured database backup using the RMAN catalog database for full, incremental, and archive log backup.

Environment: RAIK, DBA, Oracle RAC, Golden Gate, RAC, Java, OEM Grid control, RMAN, NoSQL, Oracle

Ameri Source INC, Glen Raven, NC Mar 2017 – Feb 2020

Oracle Database Administrator

Responsibilities:

Created and set up Dev/TEST/QA environments from the Production database.

Upgraded and configured Oracle databases from 11g to 12c.

Installed, set up, and configured Data Guard.

Cloned databases using scripts as well as RMAN.

Collaborated with cross-functional teams to optimize database performance and troubleshoot performance issues, utilizing advanced tuning techniques and tools such as Oracle Enterprise Manager, Enterprise Master Data Group and SQL tuning advisors.

Implemented high availability and disaster recovery solutions, including database replication, failover mechanisms, and backup strategies, ensuring data availability and minimizing downtime in case of system failures.

Wrote shell scripts for alerts for ORA errors, backup and recovery, and import and export procedures.

Managed user security, privileges, roles, auditing, profiling, and authentication.

Extensively tuned database performance, including SGA tuning.

Helps Java applications running in the Oracle JVM on the server to access data present on the same system and same process.

Created and managed database objects, including tables, tablespaces, data objects, Java indexes, user logins, and passwords.

Implemented and enforced security policies, including role-based access control (RBAC), data encryption, and auditing, to protect sensitive data assets. Oracle Database Administrator XYZ Company, Another City, USA

Provided day-to-day support for Oracle Database 21c environments, including routine maintenance tasks, patching, and performance monitoring.

Refreshed and replicated databases from production to testing using hot backup.

Partitioned tables and created index-organized tables and locally managed tablespaces.

Worked with blobs, clobs, materialized views, and bitmap indexes.

Managed storage, including space, tablespaces, segments, extents, rollback segments, and the data dictionary.

Installed and administered Automatic Storage Management (ASM).

Involved in database designing and database architecture.

Evaluated and researched hardware for Oracle RAC environment.

Used Oracle Advanced Replication feature to set up multi-master replication.

Conducted business impact analysis, developed recovery strategy, and planned testing and training for business continuity and disaster recovery plans.

Environment: SQL, Dev/TEST/QA. RMAN, bitmap indexes, blobs, clobs, Oracle RAC, Automatic Storage Management (ASM), Oracle

Huntington Bank, Mt Vernon, OH Dec 2016 – Feb 2017

Oracle Database Administrator

Responsibilities:

Provided administrative support and maintenance on Oracle 10g, 11g, and 12c installations, database creation, database security, database optimization, and tuning.

Provided and maintained high availability and disaster recovery using ORACLE DATA GUARD.

Monitored and troubleshooted database performance using OEM, AWR, ADDM, ASH, Explain Plan, and TOAD.

Performed other Security related tasks including Transparent Data Encryption (TDE).

Implemented Security policy enhancement through roles, profiles, privileges, and password policies as per business requirements.

Worked on Cloning schemas, objects, and databases on the new server using exports from the 10g database and imported in 11g using data pump.

Performed backup and recovery procedures using RMAN and Data Pump utility for Oracle databases.

Upgraded databases from 10g to 11g and 11g to 12c. Applied PSU and bug fix patch.

Implemented, tuned, and maintained Oracle database using OEM.

Developed Standard Operating Procedures (SOPs) for data extraction, outage reports with supporting resolutions, preventative maintenance documentation, and weekly activity reports.

Participated in the 24/7 on-call DBA rotation schedule.

Managed Database Structure, Storage Allocation, Table partitioning, Table/Index segments, Rollback segments, Constraints, Database Access, Roles, and Privileges.

Architected and implemented Golden Gate replication in Oracle RAC Multimode and Oracle RAC One Node.

Involved in Oracle Database performance-tuning services with EXPLAIN PLAN, AWR reports, ADDM

Used Oracle Enterprise Manager (OEM) Grid Control for Performance, Administration and Maintenance of Databases

Day-to-day maintenance included patching, cloning, and administration of concurrent management processes, Users, Forms, Reports, and performance issues.

24x7 remote support and on-call rotation.

Environment: Oracle, Oracle Data Guard, RMAN, Golden gate, Standard Operating Procedures (SOPs), Oracle Enterprise Manager

Erie Insurance Group, Ashland, OH Mar 2015 – Nov 2016

Oracle Database Administrator

Responsibilities:

Planned and configured near Zero downtime database migration and upgrade of Oracle databases from Non-Exadata to Exadata Servers.

Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup and recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data guard, Oracle Advanced Replication, Real Application Clusters, Oracle standby services.

Designed and implemented Active to Active and Active to Passive GoldenGate replication and also Upgraded Goldengate to 12.1.0.2 from lower versions.

Implemented advanced security using TDE (Transparent Data Encryption).

Managed cross-platform migration of 15TB heavy transactional Oracle database from Solaris (11.1.0.7) to Linux (12c) using Oracle Goldengate.

Analyzed the execution plans generated by the optimizer and replaced bad plans with historical execution and improved performance of SQL running on databases.

Installed, configured, and administered OEM13c.

Upgraded Golden Gate from 12c to 19c.

Migrated more than 70 Oracle databases between different data centers from NonExadata to Exadata machines using Goldengate, Active Dataguard, Transportable tablespaces, RMAN, and EXPDP/IMPDP.

Upgraded 11.2.0.4 databases to 12c using manual upgrade and DBUA.

Configuration and Implementation of Dataguard Physical / Logical Standby Databases and Automating the Monitoring / Resolving on and off Gap or lagging issues.

Performed tuning of Oracle Wait Events/Latches-Enqueues/Memory structures using Automatic shared memory management (ASMM), ASH, and Buffer Cache Advisors.

Fabricated multiple CLONING databases using manual method and RMAN utility Backup and recovery procedures using RMAN.

Created scripts for RMAN incremental backups and also for full database backups using Datapumps.

24x7 on-call support for critical database issues to help meet deadlines.

Environment: RMAN, EXPDP/IMPDP, Oracle Goldengate, Transparent Data Encryption, Oracle, Windows

Contact this candidate