Vincent Johnson

About Vincent Johnson

Mr. Johnson is a detail-oriented, Senior Oracle Database Administrator with 12 years of experience. Highly accomplished, IT specialist, with in-depth knowledge in Oracle database architecture, performance tuning, backup and recovery, schema management, installation, configuration, upgrades, patches, database security & migration. Mr. Johnson is highly skillful in performing diverse database administration roles, while working in large-scale database environments (developmental, test and production) across various platforms such as LINUX, Windows, & SQL Server. He is also conversant in an assortment of technologies including Oracle 11g, 12c, 19C, SQL Developer, and OEM. Mr. Johnson possesses extraordinary written, verbal, analytical and organizational abilities. He is a proven leader with a motivational management style, a solid reputation for building and retaining highly motivated teams and development of innovative solutions.

Experience

1. Senior Oracle Database Administrator

   FedEx

   Jan 2020 — Present · Frederick, MD, US

   Proficient at using SQL developer to design, create and maintain Oracle databases. • Primarily use SQL Developer to create table spaces, indexes, set privileges and create user logins. • Assist in SQL tuning and providing consultation such as creating Materialized views, adding indexes, dropping unnecessary indexes, using hints wherever possible, amongst others. Creation of users and roles, table spaces; ensuring database functionality • Successfully installed and configured Oracle 19C on Red Hat Linux 9.0 • Diagnosed and repaired data failures and corruption utilizing the Data Recovery Advisor feature in RMAN utility. • SQL Mirroring and performance tuning • Extensively used AWR, ADDM, ASH, and Explain plan for periodic Performance tuning. Applying RDBMS patches, security patches for improving the security and functionality of the databases • Implementing Data pump, conventional export/import utility of Oracle 12g, 19C for re-organizing Databases/Schemas/Tables to improve the performance. • Completely eliminating space errors by implementing proactive space monitoring and effective space allocation. • Proficient at using SQL Developer to create, drop, or alter tables and running SQL Queries • SQL Server and Database Security Management • Have Experience in Writing optimized SQL queries for integration with other applications. • Proficient at using SQL Tuning Advisor to auto tune or correct poorly written statements.

Education

• University of Maryland Global Campus

  Bachelor's degree, Computer Science

  2021