Post Job Free

Resume

Sign in

Oracle Database Administrator

Location:
Columbus, OH
Posted:
July 18, 2023

Contact this candidate

Resume:

Salieu Sesay

adydtq@r.postjobfree.com

Ph: 267-***-****

Summary

Experienced Database Administrator with over 6 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

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

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

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

Familiar with Agile development methodologies and DevOps practices, including continuous integration and delivery

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

Excellent problem-solving and troubleshooting skills, with a strong attention to detail

Effective communication and documentation skills, with the ability to present complex technical information in a clear and concise manner.

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

Excellent communication skills, co-ordinate and communicate with system administrator, network engineer, business data analysis and development team.

Experience as On-Call production DBA support.

Hands on training on performance tester using load runner and JMeter. TECHNICAL SKILLS

Database: Oracle 19c/12c/11g/10g/9i/, Oracle GoldenGate, Physical Data Guard, RAC Hardware: Sun Sparc E series, HP 9000, IBM RS6000, Compaq, EMC, UCS blades OS: Sun Solaris, HP-UX, IBM-AIX, Red hat Linux, Windows NT GUI: Developer 2000(Forms 4.5, Reports 2.5), Developer 6i (Forms 6i, Reports 6i) DB Tools: OEM, RMAN, Data Pump, Export/Import, SQL Loader, OWB, OID, ASM, Oracle RAC, Data Guard, Toad, SQL developer, DPA.

Misc. Tools: BMC Patrol, Veritas Clusters, Veritas NetBackup, Tivoli Data Protection, Cron Languages: SQL*Plus, PL/SQL, Unix Shell Scripting, csh, ksh, bash PROFESSIONAL EXPERIENCE

Liberty Mutual Finance Mar 2020 - Current

Oracle Database Administrator

Responsibilities:

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

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 GoldenGate unidirectional and bidirectional replication.

Upgraded GoldenGate from 12c to 19c.

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, triggers.

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

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

Ameri Source INC Mar 2017 – Feb 2020

Oracle Database Administrator

Responsibilities:

Created and set up Dev/TEST/QA environments from 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.

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

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

Extensively tuned database performance, including SGA tuning.

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

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. Education:

BACHELOR OF SCIENCE WITH HONORS IN BUSINESS AND INFORMATION TECHNOLOGY

Certification: OCA

DIPLOMA IN BANKING AND FINANCE

CERTIFICATE IN BUSINESS STUDIES

HIGH SCHOOL DIPLOMA



Contact this candidate