SUMMARY:

• Results - driven IT professional with skills in Database Administration, team building and problem solving with established reputation for effectively working with diverse groups of people and adaptability to changing environments.
• Planning, installation, configuration, management and troubleshooting of Oracle11g/12c databases on Linux and Windows OS
• Installation and management of Oracle database usingDBCA (Database Configuration Assistant)
• Installation and application of several Oracle critical patches to various database versions
• Install and configure relevant network components to ensure database access as well as database consistency and integrity
• Configure database network dealing with tnsname and listener
• Establish, implement and maintain comprehensive Oracle database maintenance plans
• Developed, implemented and maintained an Enterprise Oracle backup, recovery
• Performed import and export as needed and scheduled nightly export on each database
• Perform various cold and hot backups using the RMAN utility.
• Performing database cloning using RMAN.
• Upgraded Oracle 11g databases from 11.2.0.1 to 11.2.0.3 using patch set
• Apply quarterly CPU patches to different version of databases.
• Upgrade Oracle 11g database to 12c.
• Managing Database Security using audit statements and fine grain auditing
• Troubleshoot and resolve various Oracle problems such as connectivity problems, backup and performance issues.
• Perform maintenance and related preventative maintenance on databases
• Providing Oracle network troubleshooting
• Create and manage documentation on the configuration and support of the Oracle databases
• Perform bulk load into the database using SQL Loader
• Administer database user accounts. Create, modify and deactivate user accounts; assign and monitor user access rights
• Ensure the creation and usability of backups for recovery needs
• Expertise in the creation of databases, table spaces, tables, indexes and other database objects
• Installed and manage Oracle Enterprise Manager.
• Managing Schema Objects.
• Regular Monitoring Alert log Files and trace files on Day to Day Basis.
• Monitoring Tablespaces and Datafiles utilization.
• Implemented multiplexing control files and redo log files
• Performing Complete Media Recovery of Database depends on the nature of failure.
• Creating and rebuilding indexes as necessary.
• Knowledge and understanding of Data guard
• Proficient in Enterprise Manager

TECHNICAL SKILLS:

Database Technologies: Oracle RDBMS 10g, 11g, 12c. Microsoft Access

Operating Systems: Windows 2000 Server, Windows XP, Windows Server, Red Hat Linux

Middleware Technologies: Oracle WebLogic Server 12c (12.2.1.3)

Encryption Technologies: Vormetric (5.3.1)

Languages: Oracle SQL*Plus, SQL, PL/SQL

High Availability Solutions: Oracle Data Guard and VMware Technologies

Networking: SQL*NET Configuration for connectivity to Oracle

Desktop Applications: Microsoft Office Suite, Toad for Oracle, WinSCP, Putty

PROFESSIONAL EXPERIENCE:

Confidential

Oracle DBA

Responsibilities:

• Applied CPU and quarterly patches in the development and production environments using Opatch utility
• Implementing DoD/DISA Security Technical Implementation Guide STIG requirements across multiple Oracle database environments
• Worked with clients closely to enforce security measures that are in line with company policies.
• Controlled access to restricted and confidential client records through roles and privileges. Administering database user accounts. Create, modify and deactivate user accounts; assign and monitor user access rights
• Monitored the databases to ensure optimal performance and perform database tuning where required.
• Troubleshooting Database/Application issues with users via Remedy ticketing system.
• Daily storage checks to ensure the availability of Production applications.
• Working with Oracle support to resolve database critical issues
• Periodically refreshing the /UAT databases from Production database
• Provided DBA support for developer requests as well as assisted developers.

Confidential

Oracle DBA

Responsibilities:

• Installation of MySQL software on UNIX platforms and configuration of database.
• Installation of Oracle 12c software on UNIX platforms and configuring databases. Applying upgrades and patches
• Installation and configuration of Oracle Business intelligence 12c on UNIX platforms.
• Installation of Vormetric Transparent Encryption. Deploying Vormetric agents to multiple VM/Servers. Configuring the Voremtric Data Security Manager (DSM) with Vormetric Agents to encrypt files/directories
• Applying Security Technical Implementation Guides (STIGs) to Oracle RDBMS 12c. Oracle Weblogic Server 12c, and Application Security and Development STIG for Oracle Business Intelligence Enterprise Edition (OBIEE)
• Data transfer using Oracle SQL Loader. Creating control files, and sqlldr commands to execute table loads
• Created and resized tablespaces, adding data files to existing tablespaces, creating redo log files
• Monitored the databases to ensure optimal performance and perform database tuning where required.
• Worked with clients closely to enforce security measures that are in line with company policies. Controlled access to restricted and confidential client records through rolesand privileges. Administered database user accounts.
• Performed various type of exports and import using Oracle Data Pump
• Configuring Oracle Enterprise Manager to monitor system resources.
• Writing documentation on all procedures for future .

Confidential

Oracle DBA

Responsibilities:

• Installed Oracle 11G software on UNIX and Windows platforms and configured
• Databases; Performed upgrades and applied patches as required.
• Created and resized tablespaces, adding datafiles to existing tablespaces, creating redo log files
• Monitored the databases to ensure optimal performance and perform database tuning where required.
• Worked with clients closely to enforce security measures that are in line with company policies. Controlled access to restricted and confidential client records through rolesand privileges. Administer database user accounts.
• Performed various type of exports and import using Oracle Data Pump
• Implemented and managed database backup using Oracle RMAN (hot and cold backups)

Oracle DBA/Analyst

Confidential

Responsibilities:

• Create and configure new oracle databases using DBCA Performing backup and recovery using RMAN and Flash Recovery
• Performing data migration using export/import and data pump.
• Managing database security by creating and assigning appropriate roles and privileges to users depending on the user activity.
• Performed database maintenance by applying required patches and software updates.
• Assisting customers with modifying, creating and editing Government s using PRISM. The Prism application utilizes an Oracle 10g database on the backend. Creating and modifying reports for PSC-DAM customers using TOAD and Oracle Reports Builder