Oracle database Engineer

Donald Nsufor

Cell:202-***-****

Emal: ad1mst@r.postjobfree.com

.

SUMMARY

Highly skilled and experienced Sr. Oracle Database Administrator with extensive expertise in managing on-premises and cloud-based Oracle databases. Proven track record of optimizing database performance, ensuring data security, and implementing scalable solutions. Adept at collaborating with cross-functional teams to deliver reliable and efficient database systems. Seeking a challenging position to contribute my skills and knowledge to drive excellence in database administration

Skills

Data Oracle Database Administration (versions 11g, 12c, 19c)

Cloud Database Management (Oracle Cloud Infrastructure, AWS)

Database Installation, Configuration, and Upgrades

Data Backup and Recovery (RMAN, Data Guard)

Performance Tuning and Optimization

SQL Query Optimization

Database Security and Encryption

Disaster Recovery Planning

Capacity Planning and Forecasting

Troubleshooting and Problem Resolution

MS sql server

Backup and recover/ restore

deployment

Users and schema management

DATABASE $ SOFTWARE SUPPORTED

Oracle- 10g,11g,12c,18c,19c

MS SQL server- 2008,2012,2014

PROFESSIONAL EXPERIENCE

Blackhawk Network, CA

November 2022– November 2023

Oracle database Engineer

Led a team of 15 database administrators in migrating multiple Oracle databases from Solaris to Linux 19c

Conducted a comprehensive analysis of existing database structures, applications, and dependencies to plan migration strategies.

Collaborated with system administrators to set up Linux environments, ensuring compatibility with Oracle.

Executed the migration process, including exporting data, transferring database files, and importing data into the new Linux environment.

Implemented performance optimizations post-migration to ensure optimal database operation.

Managed database security by implementing access controls and encryption mechanisms.

Developed and documented best practices and migration procedures for the organization.

Administered and maintained Oracle databases on Solaris, ensuring high availability and optimal performance.

Worked closely with application developers to optimize SQL queries and improve database performance.

Conducted routine database backups, disaster recovery testing, and maintenance tasks.

Participated in troubleshooting and resolving database-related issues, ensuring minimal downtime.

Assisted in capacity planning and recommended hardware and software upgrades.

Implemented database monitoring tools to proactively identify and address performance bottlenecks.

MSA PITTSBURGH PA

MARCH 2020 – November 2022

Operational cloud Engineer

Manage and administer Oracle databases on-premises and on cloud platforms such as Oracle Cloud Infrastructure (OCI) and Amazon Web Services (AWS).

Plan and execute database installations, configurations, and upgrades to maintain optimal performance and security.

Implement data backup and recovery strategies to ensure data integrity and availability, utilizing technologies like Oracle Recovery Manager (RMAN) and Oracle Data Guard.

Perform database tuning and optimization to enhance system responsiveness and minimize downtime, including SQL tuning and index optimization.

Monitor database performance and proactively identify and resolve performance bottlenecks and issues.

Implement and maintain database security policies, access controls, and encryption measures to safeguard sensitive information.

Collaborate with development and infrastructure teams to design, develop, and deploy database solutions for new and existing applications.

Conduct capacity planning and forecasting to ensure database systems meet current and future demands.

Lead database migration projects from on-premises to cloud environments and vice versa, ensuring a smooth transition with minimal disruption.

Develop and maintain documentation related to database configurations, processes, and procedures.

Led a team of database administrators responsible for managing and maintaining multiple mission-critical Oracle databases on-premises and in the cloud.

Implemented and maintained Oracle databases in the cloud using services such as Amazon RDS, Oracle Cloud Infrastructure, or Microsoft Azure Database, ensuring seamless integration with existing on-premises infrastructure.

Conducted performance tuning and optimization of Oracle databases, resulting in a significant reduction in query response times and enhanced overall system performance.

Designed and implemented robust backup and disaster recovery strategies for cloud databases, ensuring business continuity and data availability in case of failures or disasters.

Collaborated with application development teams to optimize database schemas, leading to increased application performance and reduced resource consumption.

Implemented security best practices and access controls to safeguard sensitive data, complying with industry standards and regulations.

Actively monitored and managed database performance metrics, proactively identifying potential issues and providing timely resolutions to maintain high levels of database availability and reliability.

Conducted regular capacity planning exercises to ensure adequate resources were allocated to accommodate growing data needs in the cloud environment.

Successfully migrated on-premises databases to the cloud, leveraging automation and minimizing downtime to ensure a smooth transition.

Provided technical guidance and mentoring to junior database administrators, contributing to their professional growth and expertise. Extensive experience in RMAN recovery testing, RAC and standalone database.

Experience in setting up Oracle ASM storage for Oracle RAC databases.

Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.

Experience in Oracle Data warehouse DBA skills relating to administration and management environments, Oracle OLTP. Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

Experience in Oracle Data warehouse DBA skills relating to administration and management environments, Oracle OLTP.

ORBCOMM UTICA, NY

July 2016 – January 2020

Operational Database Administrator

I Managed and maintained 31 production Oracle databases, ensuring high availability, performance, and security.

Conducted database installations, configurations, and upgrades, optimizing system performance, and applying security patches.

Implemented and maintained Oracle Data Guard for disaster recovery, achieving RTO and RPO objectives.

Led capacity planning efforts to accommodate data growth and future business requirements effectively.

Performed proactive performance tuning and query optimization, resulting in a 99.9% improvement in overall database performance.

Collaborated with application developers to design and implement efficient database schemas and data models.

Developed and maintained database backup and recovery strategies, successfully restoring critical data when needed.

Conducted regular security audits and implemented access controls, ensuring compliance with industry standards and best practices.

Acted as a subject matter expert for database-related initiatives, providing guidance and technical support to team members.

Created and updated documentation, including Standard Operation procedure.

NYISO, ALBANY NY

July 2013 – July 2016

Administered multiple Oracle databases for various applications, including performance monitoring, backup and recovery, and user management.

Coordinated with developers to optimize SQL queries and ensure efficient database access.

Conducted periodic database health checks and implemented necessary updates and patches.

Assisted in the design and implementation of disaster recovery strategies for critical systems.

Provided technical support and troubleshooting expertise to resolve database-related incidents.

Collaborated with vendors for hardware and software upgrades and installations.

Accomplishments.

Motivated new employees and collaboratively worked with them during projects, resulting in quicker overall completion of a 2-node RAC configuration for maximum availability, scalability and reliability and also in a uni-directional Golden-gate configuration for data real time replication.

Suggested a backup strategy that was later implemented which drastically reduced the time taken for the backup of databases.

Troubleshooted performance issues and came up with some long-term fixes that went through change management and was implemented, and this drastically reduced performance issues.

Successfully configured a physical and logical standby data guard for disaster recovery and performance testing.

Successfully configured Migrate oracle database from on premises to AWS cloud on both EC2 and RDS using DMS.

Successfully upgrade oracle databases from 11g,12c, to newer version of 19c database

Patch all oracle instances running on premises.

Ability to use Opsgenie for on call rotation

Certifications

Oracle 12c Certified Database Administrator (OCA)

Oracle 12c SQL Fundamentals

Oracle Cloud Infrastructure 11g certified (OCI)

AWS Solution Architect certified.

AWS security Specialty certified.

CompTIA Security Plus certified

Bachelors in Marketing Management

Contact this candidate