Oracle Security

University of Maryland – Princess Anne, Maryland

B.S. in Computer Science (May 2015)

The Computer Workshop – Dublin Ohio

oMicrosoft SQL Server for Oracle Database Administrators

Certification (July 2018)

Professional Certification

Oracle 11g Database Administrator Certified Associate OCA

Oracle 12c Database Security Certified.

CompTia Security + CE

Projects:

Oracle Database upgrades 12c to 19c on AIX 7.2 power 9.

Oracle Grid/Database 18c/19c installation and Configuration on six 2 nodes RAC Servers

Unified Auditing: Auditing all actions done in the database by a user to meet IRS specs.

Trace File Analyzer(TFA) Upgrade: Diagnostic tool for SR with Oracle Support

Oracle Enterprise Manager 13c release 4 installation: To monitor Oracle 12.2, 18c/19c

Databases

SQL Server 2012, 2014 service pack upgrade.

Oracle catalog database creation to save backup records.

Oracle ASM storage Replication.

Oracle database upgrade from 11.0.1.3 to 12.0.1 on all 6 AIX 2 nodes RAC servers

TDE Encryption.

MSSQL Warehouse failover configuration.

Tax New Year Prep: coordinate with developers in getting SQL Server databases for upcoming

Year Income tax and Business Tax year.

Work Experience

Ohio State Department of Taxation Sept 2016 - Present

Columbus, OH

Oracle/MSSQL Database Administrator

Job Duties

24/7 Oracle/SQL Database Support for large number of databases Oracle 11g, 12c, 18c, and 19c.

Implement and Support MSSQL servers Database systems, reporting services

Maintain and support MS SQL Servers with databases used for prod, staging and development

Oracle Multitenant Administration on two nodes RAC.

Database Migration and Upgrades of various applications running on multiple versions of Oracle and SQL server.

Analyze, understand and implement existing upgrade methodology and strategy.

Work with application teams and project teams to resolve database issues.

Document all project results, findings and lessons.

Oracle Database Security Admin.

Data Refresh/Data Load using IMPDP/EXPDP (Oracle), Redgate tool(SQL SERVER), Linked server (SQL SERVER)

SSRS for reporting purposes.

Database backup and recovery for both ORACLE and SQL SERVER.

Performance issues (Oracle SQL tuning, SQL server trace file analyzer).

Research new technologies and develop recommendations for the adaption of the technologies.

Optimize database design and manages data integrity.

Ability to define problems collects data, establish facts and draw valid conclusions.

Implement compliance changes via procedural recommendations.

MEDSTAR HEALTH July 2013 - Sept 2016

Washington DC

Oracle/MSSQL Database Administrator

Responsibilities:

Oracle Database backup and Recovery via TSM storage

Oracle database Monitoring and performance tuning using OEM

Oracle Database PSU and CPU upgrade

SKILLS:

Extensive knowledge of Performance tuning for both Oracle and MS SQL.

Strong verbal and written communication skill

Strong knowledge of MSSQL AlwaysOn, and Replication.

Expert knowledge of CLUSTER administration.

Knowledge of SHELL Scripting.

Controlling access permissions, privileges to ensure data security.

Problem solving skills.

Html,css,javascript

SSRS,SSIS, WINDOWS AD

Reference will be made available based on request.

Contact this candidate