TECHNICAL SKILLS
 

• Databases: Oracle10g/11g and 12c.
• Applications: Oracle EBSR12.6
• Operating Systems: Windows Server / 2000/2003/2008/2012, Linux (Centos, Red Hat).
• Oracle Tools: Oracle Enterprise Manager (OEM), OUI, Oracle Data Guard, DBCA, DBUA (Database Upgrade Assistant), ASMCA (Automatic Storage Management Configuration Assistant), Oracle Net Manager, SQL*Plus and Recovery Manager (RMAN), Data Pump.
• Experience with: Toad, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential

Oracle EBS DBA

Responsibilities:

• Cloning Oracle EBS R12.6 using Rapid Clone
• Monitoring jobs (Application Tier and Database Tier)
• Transferring files and tables across environments using scp, Winscp, and Datapump
• Running patch analysis
• Running collect, analyzer scripts
• Participating in maintenance by bringing down and up services and databases
• Running tkprof on tracefiles
• Checking Concurrent Managers from the Frontend
• Running Concurrent Requests from the frontend
• I have also completed the following:
• Installing full stacks of Oracle EBS R12.0, Fresh Database and VISION Database, using rapidwiz
• Patching EBS R12.6 using (Opatch, BSU, and ADOP)

Confidential

Oracle DBA

Responsibilities:

• Completed configuration of databases backups using RMAN and wrote corresponding SOP
• Checked and troubleshot databases backups daily
• Assisted Applications, development, systems teams in a complete migration from PostgresSQL to Oracle
• Configured data encryption using Oracle TDE with corresponding SOP
• Checked data guards and troubleshot them for any issue daily
• Re - created entire data guards using database duplication
• Configured Data Guard Broker with corresponding SOP
• Created schemas users with dependent objects
• Deployed quarterly databases patches on Windows and Linux operating systems including (RDBMS, OJVM, and Grid)
• Configured the entire OBIEE suite stack for business analytics solutions
• Used JIRA, REMEDY, SPLUNK, CSAM, DBPROTECT, CONFLUENCE, AND TRELLO as tools to fulfil business needs
• Created databases and schemas to accommodate applications’ needs
• Configured and added features and tools across databases testing cycle: Development, UAT, FT, Staging, and Production
• Used Eclipse with developers as integrated solution framework
• Maintained wallets for highly secure databases for some of which I created triggers

Technical Environment: Red Hat Enterprise Linux 7.0, Oracle, Windows Server 2016. Database 12.2.0.1.

Confidential

Database Engineer

Responsibilities:

• Installed and managed RAC (Real Application Cluster)
• Restored databases
• Installed wallets on databases using orapki
• Managed databases across versions: 10g, 11g, 12c. Over 400 databases with thousands of embedded applications. Monitoring them using applications like Solarwinds, Nagios, OEM Grid Control 12c.
• Performed fine grained security
• Tuned and Troubleshot diverse issues in the databases
• Supported other teams (Application, Development, Systems, Network, SAN) during maintenances and normal course of activity for an average of 25 maintenances every week
• Rolled back databases and database objects as needed
• Performed storage management in LINUX and Windows platforms
• Exported and imported database objects as needed
• Created SOPs and uploaded them to the resource internal page
• Performed health check on databases
• Performed 24/7 on-call duty on a rolling basis. One full week every month

Technical Environment: Red Hat Enterprise Linux 7.0, Oracle, Windows Server 2012; Database 10gR2, 11.2.0.4, 12.2.0.1.

Confidential

Oracle DBA in charge of data security

Responsibilities:

• Established a backup and recovery strategy using daily hot backups, RMAN and weekly full backup.
• Allocated system storage and planned for future storage requirements for the database and related functions.
• Performed database migrations from Oracle versions 10g to 11g
• Created and configured Oracle databases using DBCA
• Utilized Automatic Workload Repository (AWR) to generate snapshots of key performance data
• Utilized Automatic Database Diagnostic Monitor (ADDM) to reduce DB processing time by diagnosing key problems
• Created primary database storage structures (tablespaces) and primary objects (tables, views, indexes) after the application developers had designed applications
• Modified the database structure, as necessary, as directed by the application developers
• Controlled and monitored users’ access to databases
• Planned and executed backup and recovery activities (Control Files, Redo Logs, System Data Files, etc.) to ensure timely and complete recoverability.
• Backed up and restored the database (On line and Complete) to assure restoral capability.
• Implemented and maintained Oracle physical data guard databases for disaster recovery
• Managed database security by creating and assigning appropriate roles and privileges to users depending on each user’s activity
• Designed, tested, deployed and documented Oracle RAC databases procedures.

Technical Environment: Red Hat Enterprise Linux 7.0, Oracle, Windows Server 2012; Database 11.2.0.4.

Confidential

Oracle DBA

Responsibilities:

• Provided customer assistance that included general user help with problem diagnosis and troubleshooting, user account management, incident monitoring and response, system monitoring and basic maintenance support including daily system health checks
• Troubleshot user issues while maintaining a secure OS computing baseline, analyzing system faults, reviewing audit logs, running diagnostic tests to detect problems, performing preventive maintenances, applying security patches and updates
• Monitored databases growth and gathered databases statistics
• Provided performance tuning, maintenance, and troubleshot database problems.
• Supported and assisted database development efforts in many areas: creation of tables, table structures, and views

Technical Environment: Red Hat Enterprise Linux 7.0, Oracle, Windows Server 2012; Database 11.2.0.4.