Database Administrator Oracle

TIFFANY JOHNSON

Database Administrator

*************@*****.*** 412-***-****

Innovative and Highly Diversified Information Technology Professional offering experience in Oracle Database Management/Administration. Great knowledge of Oracle Database Management in various system environment including UNIX, and Windows, supporting a variety of mission critical applications using Oracle 12c and 19c.Mainly running on Linux (Red Hat Linux), Oracle Relational Database Management System (RDBMS) and Windows Operating Systems. Experience as On-Call 24x7 production DBA support, application/development DBA, system administrator. Extensive experience in Oracle DBA, OLTP & implementations.

● Lead Troubleshooting Oracle database issues, Database Strategy/Design and problem-solving initiatives.

● Complex knowledge of enterprise database systems and providing efficient IT service support, improving business IT operation through IT service delivery, Program/Project Management.

● Experience Converting and Migrating Large Databases from On-prem (19C) to the Cloud environment (AWS, Oracle 12c).

● schema migration tools experience (e.g., Liquibase).

● source control management experience (e.g., Git).

● ansible experience

● DBMS/DBA experience, PostgreSQL and Oracle. Cloud experience AWS. CI/CD pipeline experience, Jenkins. RDBMS Oracle 12c, 19c

LANGUAGES SQL, PL/SQL, SHELL SCRIPT (BASH)

OPERATING SYSTEMS Linux (Red hat), Windows

ENVIRONMENTS Agile, AWS, Oracle Cloud, Linux/Oracle Environments SOFTWARES JIRA, PACKET TRACER, MS TEAMS, OEM, SERVICE NOW SR. ORACLE DATABASE ADMINISTRATOR (REMOTE) AUG 2021 - Present SYMMETRY CORPORATION (Xyngular Pacific Northwest)

Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions.

● Responsible for supporting all efforts that keep the State databases running smoothly 24/7 to ensure seamless flow of information throughout the organization, considering both backend data structure and frontend accessibility for end users.

● Database Administrator II's provide complex database maintenance support to the organization, troubleshooting support, and collaborate on multiple projects simultaneously that have a database administration component.

● Proactively tune the database environment for applications to run smoothly and quickly and prevent outages.

● Created and maintained oracle user accounts.

● Perform SQL query performance tuning and advise developers.

● Provide response to service request tickets and solve associated database issues.

● Performed several database troubleshooting and tuning on all environments(dev,test,prod).

● Tuned the continuous slow running queries with execution plan and indexes when needed. ORACLE DATABASE ADMINISTRATOR (Contract) JUL 2018 - AUG 2021

● Checked backups daily

● Installation of Oracle 19C databases in production, development and test environments depending on project requirements.

● Managed user accounts and granted them the necessary privileges.

● Maintain and support Oracle 19C physical and logical standby databases.

● Implemented 12C and 19C databases using OEM for alert monitoring and notification.

● Upgraded databases from 12C to 19C.

● Managed user accounts and space management while granting required privileges to various users.

● Applying upgrade patches, maintenance and interim (Opatch) patches on all the databases.

● Refreshing dev and test instances with data from production when needed for testing purposes.

● Creating and assigning appropriate roles and privileges to users depending on the user activity.

● Performed company wide remediation (granting and revoking privileges to the appropriate users).

● Utilized Service Now for daily performance tuning issues. IT – TECHNICAL SUPPORT ANALYST JAN 2017 to MAY 2018 ROSE INTERNATIONAL (ALPHA TECH)

Worked to provide internal and external customers with information technology support to optimize operational efficiency.

● Provide high level complexity support for all CPS (Currency Processing Solutions) devices Assumes ownership on every Client interaction to answer the Client's questions and solve the problem during the initial contact.

● Independently investigate and implement solutions to technical issues and assisted and followed up on technical help tickets submitted via phone and email.

● Entered and confirmed Client information into the database and completed proper request forms in assisting Clients.

● Provided IT assistance for operating systems, productivity software, and a variety of other software applications used internally.

● Provided Client resolution, tech will accurately route the Clients issue to the appropriate department. ORACLE ACCELERATED COURSE ONLINE COURSE

COMPUTER SCIENCE COLUMBUS STATE COMMUNITY COLLEGE COLUMBUS, OHIO

BACHELORS

Contact this candidate