Sr. Oracle DBAÂ Resume Greenbelt, MD - Hire IT People

SUMMARY:

Lead Oracle DBA working as part of a team tasked with providing project and day to day operational support for Oracle Applications running on forms 11g/10g servers and Oracle 12c/11g/10g databases.
Monitored and tuned applications and databases to optimize stability and performance. Enforced business rules by using integrity constraints & Database triggers.
Superior familiarity with LINUX, Unix, Windows & Windows XP. Network Security. Networking: TCP/IP, DHCP, PING, Traceroute, Netstat, Nslookup, nbstat, cable tester, probe tester, wireless configuration. Experience with Oracle RAC & ASM Administration, Virtualization on VMware. Security: Antivirus, Firewalls, Anti Spyware, user Authentication/strong passwords; encryption, certificates.

TECHNICAL SKILLS:

Database Admin: Oracle 11g/10g/9i/ SQL Server 2008/2005

OS: Linux - Windows 2000 Server, Windows XP, Windows 2003 Server, Red Hat Linux 5.4

Hardware: IBM Power Machines, Dell Servers, Windows Server

Virtualization: VMware and Oracle Virtual Box

Language: Oracle SQL, PL/SQL, Bash Shell Scripting, Java

Backup: RMAN, Cold and Hot backup

Tuning Utilities: SQL Trace, Autotrace, TKPROF, Explain Plan, AWR, ASH, ADDM, ADRCI

Migration Tools: Data Pump (expdp/impdp), SQL*Loader

High Availability: Data Guard, RAC, ASM, Grid Control

PROFESSIONAL EXPERIENCE:

Confidential, Greenbelt, MD

Sr. Oracle DBA

Responsibilities:

Install the Oracle client and server software and configuration
Installed and configure RAC on VM Virtual Box for test and development purposes.
Installed and configured Oracle on VMware for test and development purposes.
Configuring Backup (RAMN) for database and restoring database.
Installation of Oracle Database 11g and configuration on Redhat Enterprise Linux Platform.
Perform daily monitor of real time replication as well as detailed reports
Database Links, Creating, Managing Tablespaces and Datafiles.
Installed and Configured Enterprise Manager for Oracle databases.
Establishing user needs and monitoring user access and security.
Troubleshoot and fix replication issues.
Load and transfer data using Data pump and SQL Loader utilities.
Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development and production environments for implementation and maintenance of user security.
Creating and Rebuilding Indexes, Managing Database Security.

Confidential, Washington, DC

Oracle Database Administrator

Responsibilities:

Monitored data files, logical data storage and data growth activities
Planned and Performed Daily, Weekly and Monthly Backups. Tested and implemented restore procedures for complete and incomplete recovery using RMAN.
Database Tuning by generating explain plans for long running queries, creating indexes on columns to improve performance.
Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.
Setting up and testing the backup and recovery strategies.
Involved in designing new structures/procedures/views/functions for development and data migration from production to reports.
Provided assistance to Memory Corruption and Dictionary Corruption Errors

Confidential, Reston, VA

Oracle Database Administrator

Responsibilities:

Supported Oracle 10g database systems by providing input/review of schema design in order to maintain database integrity on both MS SQL server and UNIX OS.
Lead efforts to monitor production databases and middleware logs to ensure efficient operation and prevent downtime.
Reviewed database backups and recovery as required, coded in pl/sql, capacity planning and performance tuning.

Confidential, Beltsville, MD

Junior Database Administrator

Responsibilities:

Creation and configuration of custom data exports on a per-client basis
Provided guidance to remote-hosted clients on recommended best practices and configuration and configure appropriately
Ensured the success of transactional replication from multiple publishers
Installation and implementation of the Oracle8i, 9i on Windows NT, Linux environment
Performed recoveries using hot and cold backup, applied on-off patches, patch sets
Worked database development writing PL/SQL code, analyzing business requirement
Provided company-wide recommendations on purchases of new server hardware