PROFESSIONAL SUMMARY

• Certified Oracle Database Administrator with over 15 years of DBA experience in production and development environments that run on LINUX/UNIX and windows servers. Good knowledge of Software Development Life Cycle (SDLC)
• Superior communication, analytical and problem - solving skills. Committed team player with excellent customer orientation.

SKILLS

• Oracle 9i, 10g, 11g, 12c, 18c,
• SQL
• PL/SQL
• Windows
• Linux
• Unix
• AWS
• Azure
• Solaris
• Putty
• WinSCP
• Veritas
• Toad
• VMware
• Shell Scripts
• Microsoft Office

PROFSSIONAL Experience

Confidential

Senior Oracle Database DBA

Responsibilities:

• Upgraded and migrated Oracle database from 12c to 18c.
• Patched Oracle 18c database server with latest critical patch updates and java patches.
• Addressed IAVA/STIG findings on database and application servers
• Implemented and enforced data and system security for all Oracle Database servers.
• Created and configured AWS RDS instance using AWS console and/or CLI.
• Imported data into AWS RDS instance using Oracle Data Pump and AWS S3 bucket.
• Implemented and supported high availability cluster solutions using Veritas.
• Successfully monitored, failed over, probed and failed back server clusters using Veritas.
• Deployed database scripts to production databases for latest software and application releases.
• Designed and implemented backup and recovery system strategies using Oracle Data pump, RMAN and flashback technologies.
• Configured Transparent Data Encryption (TDE) and created encrypted tablespaces.
• Provided support for Oracle databases, including performance tuning.
• Provided incident reports and logs to Oracle support using ADRCI (Automatic diagnostic repository command interpreter).
• Wrote PL/SQL code to automatically update table records.
• Utilized Oracle flashback technology to rewind database to any ‘point in time’ to resolve user errors.
• Solved disk space issues by creating scripts to delete old logs and files.
• Maintained database and server using Oracle grid control 13c.
• Monitored system audit table for database intrusions.
• Created, cloned and refreshed multiple databases from production or baseline backups.
• Exported and imported schemas using data pump for development team.
• Performed general technical trouble shooting and gave recommendation of new technologies to management.
• Created and provided extensive database reports to management for project analysis.
• Handled database security and maintenance of documentation.
• Performed database tuning using Oracle Enterprise Manager and toad.
• Created and provided extensive database reports to management for project analysis.
• Implemented automated monitoring to ensure proactive handing of reoccurring issues.
• Installed and maintained all Oracle related software.

Confidential

Oracle DBA

Responsibilities:

• Patched Oracle database server with latest critical patch updates and java patches.
• Installed and upgraded Oracle database software.
• Upgraded and migrated Oracle database from 10g to 11g.
• Setup and configured Oracle data guard environment.
• Setup and configured logical standby database for reporting team.
• Addressed IAVA/STIG findings and applied security configuration guidelines to all databases in all environments.
• Cloned and refreshed multiple databases from production or baseline backups.
• Used RMAN to backup databases and established recovery strategies.
• Deployed schema build scripts and maintained database baselines.
• Implemented Oracle flashback technology to rewind database to any ‘point in time’ to resolve user errors.
• Maintained database and server using Oracle grid control 12c.
• Installed Oracle agents to database servers and added host targets for grid control management and monitoring.
• Created scripts to re-assign users to programs and posts.
• Monitored system audit table for database intrusions.
• Scrambled database PII (Personally Identifiable Information) data and FTP to off-site developers.
• Designed and created database schema scripts.
• Improved the performance of the application by tuning SQL queries.
• Wrote SQL, PL/SQL procedures required to retrieve data using cursors and exception handling.
• Created scripts to add new tables and views for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Solved user tickets by writing database scripts to fix data issues.
• Exported and imported schemas to sync development and testing environment to production.

Confidential

Senior Oracle DBA

Responsibilities:

• Wrote SQL queries to convert application and database data.
• Wrote PL/SQL code to automatically update table records.
• Deployed database scripts to production databases for latest software and application releases.
• Implemented working knowledge of RMAN to perform and maintain sound backup and recovery policies and procedures.
• Provided support for Oracle Data Guard including applying patches, performance tuning, backup and recovery using RMAN.
• Implemented and supported high availability solutions using Oracle Data Guard.
• Utilized Oracle flashback technology to rewind database to any ‘point in time’ to resolve user errors.
• Solved disk space issues by creating scripts to delete old logs and files.
• Created scripts to re-assign users to programs and posts.
• Monitored system audit table for database intrusions.
• Created, cloned and refreshed multiple databases from production or baseline backups.
• Exported and imported schemas using data pump for development team.
• Performed general technical trouble shooting and gave recommendation of new technologies to management.
• Created and provided extensive database reports to management for project analysis.
• Handled database security and maintenance of documentation.
• Performed database tuning using Oracle Enterprise Manager and toad.
• Improved the performance of the application by tuning SQL queries.
• Installed and configured Oracle 11g database software and Oracle client.
• Created and configured database to meet end-user requirements.
• Queried database and created reports for management team.
• Installed, Configured and Administrated Oracle 11g RAC.
• Installed and configured oracle data guard and failover system.
• Used RMAN to backup and restore files.
• Prepared the primary standby database for database creation.
• Created a physical standby database.
• Created a standby database with RMAN.

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Installed and configured Oracle 11g grid control to monitor and manage database systems.
• Installed and configured oracle data guard and failover system.
• Installed and configured Oracle replication using Goldengate.
• Installed Goldengate monitor to manage replication.
• Altered and configured Oracle database to accommodate Goldengate.
• Created and configured Oracle replication loads using extracts and replicats.
• Installed and configured Oracle 11.2.0.3 software to accommodate new databases.
• Created and configured Oracle 11g databases.
• Used UNIX related knowledge and commands to move, copy, zip and create files and directories.
• Manipulated UNIX files and directories by setting and modifying user ownership and permissions to prepare for Oracle database administration duties.
• Created stored procedures and triggers using PL/SQL code.
• Maintained and altered Oracle stored procedures to troubleshoot database related issues.
• Tested and debugged PL/SQL code before deployment.

Confidential

Senior Oracle Database Engineer

Responsibilities:

• Installed and configured the Oracle RDBMS software according to standard security baselines.
• Exported and Imported data dumps into database servers to synchronize database environments.
• Refreshed development and test databases based on request from team members.
• Secured and audited database systems based on security configuration standards.
• Monitored performance on production database servers.
• Split partitions to re-write newly created tablespace.
• Patched up both database and failover server to update CPU and PSU security.
• Created privileged user accounts for developers.
• Created new schema and tablespace to accommodate new data loads.
• Installed and configured grid infrastructure and create RAC database.
• Configured and managed RAC environment services.
• Managed backup and recovery strategies.
• Retrieved information from data warehouse using SQL queries.
• Wrote PL/SQL stored procedures based on database team needs.

Confidential, Arlington, VA

Oracle Database Administrator

Responsibilities:

• Installed and configured the Oracle RDBMS software according to standard security baselines.
• Upgraded and patched Oracle software to current versions.
• Created and built databases as required for end users and unit testing.
• Created user accounts within the database and granted restricted roles and privileges.
• Monitored system audit table for database intrusions.
• Ran the Oracle 9i, 10g DS security scripts to lockdown database servers.
• Encrypted/Scrambled database PII (Personally Identifiable Information) data and FTP to off-site developers.
• Utilized working knowledge of RMAN to perform and maintain sound backup and recovery policies and procedures.
• Implemented UNIX Shell scripts for process integration and automation of data load.
• Created, cloned and refreshed multiple databases from production or baseline backups.
• Maintained batch and automation jobs using Windows and OEM schedulers.
• Deployed database scripts to production databases for latest software and application releases.
• Performed general technical trouble shooting and gave consultation to development teams.
• Maintained all Oracle server and database passwords list in secure directory.

Confidential, Columbia, MD

Oracle Database Administrator

Responsibilities:

• Installed and upgraded Oracle database software.
• Created and configured database to meet developer and end-user requirements.
• Performed system upgrade and applied patches as needed.
• Configured database to ensure acceptable level of performance and availability.
• Implemented database systems security and audit strategy.
• Created and managed indexes for faster data retrieval and report creation.
• Recovered database and storage media ensuring minimal downtime.
• Developed and implemented backup and recovery strategies.
• Developed automated system processes using Shell and scripts.