SUMMARY

• Ability to perform both Oracle and operating system performance monitoring
• Acquire abundant knowledge of how Oracle acquires and manages resources
• Excellent with Recovery Manager (RMAN) including hot and cold backup options
• Expert in physical and logical database design Great with Oracle tools
• Highly knowledgeable of Oracle security management
• In depth knowledge of the operating system(s)
• Possess a sound understanding of the business requirement
• Proficient in both database and program code performance tuning
• Thorough knowledge of user interface applications
• Well experienced in migration (import and export utilities)
• Hands - on experience in RHEL systems installation, configuration and maintenance
• Hands-on experience in managing physical and virtual RHEL machines (on VMWare ESXi)
• Competent in package management - installations, updates and upgrades
• Proficient in using RHEL User account administration and autantication
• Competent in RHEL networking configuration and troubleshooting

TECHNICAL SKILLS

Hardware: HP Servers and PCs

Operating System: Red Hat Enterprise Linux 6 and Microsoft Windows 2008

Tools/Utilities: Server Manager, SQL* Loader, Oracle Universal Installer, Database Configuring Assistant, Database Upgrade Assistant, Oracle Net Manager, OWM, Recovery Manager, Data Pump, and Oracle Enterprise Manager, putty,apache tomcat, winscp

Language: LINUX shell programming, PL/SQL

Database: ORACLE 11.2.0.4(11g)/12c

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administrator

Responsibilities:

• Part of a team of 6 DBA's in a 24 x 7 environment responsible for monitoring, configuring, managing, upgrading and troubleshooting over 200oracle10g and 11g databases with sizes from 2TB to over 15Tb
• Engineer end-to-end solutions which require extensive interaction with other engineering teams like Storage, Systemsadministrators, Platforms, Networks and Application developers.
• Configure audit, grant privileges and restrict access, create users, profiles, roles and monitor quota on tablespaces.
• Perform physical backup using RMAN. Clone databases using RMAN.
• Monitor tablespace and Data file utilization.
• Apply system anddatabaseapplication patches to uphold system integrity.
• Security and granting privileges; autantication, auditing, and authorization. Using Fine Grain Access Control.
• Performdatabasecloning using RMAN.
• Implement and maintainDatabaseaccess and security.
• Data transfer using export/import utilities, Data Pump and SQL* Loader.
• Create and drop flashbacks.
• Monitor user sessions, killing inactive session when necessary.
• System documentation for various processes.
• Daily review backup reports and resolve any failed backups.
• Manage Data Guard Physical Standby.
• Manage Data Guard using Data Guard broker.
• Troubleshoot and resolve log gap in Data Guard Configuration
• Maintained data integrity and security using integrity constraints anddatabasetriggers.
• Troubleshoot and resolve variousOracleconnectivity problems
• Work in the AWS cloud solution.
• Deploy and maintain oracle database on amazon cloud services.
• MEDSTAR Health Washington D.C(2011-2013) Junior Database Administrator
• Controlled access to thedatabaseby giving security password and permissions.
• Responsible for developing and maintaining the integrity of the databases.
• Performed data cleansing and data migration functions.
• Worked daily on incremental backup and weekly on fulldatabasebackup
• .Used RMAN to backupdatabase.
• Configured and monitored the TNS Listener using NetCA.
• Installed and patched DBMS software, upgrades and related products in both production and test platforms.
• Configuring audit, granting privileges and restricting access, creating users, profiles, roles and monitoring quota on tablespaces in line with resource planning guide.
• Documenteddatabasestructure, changes, problems and issues for future reference.
• Administereddatabaseuser accounts. Created, modified and deactivated user accounts; assigned and monitored user access.
• Provided internal communications relating to maintenance, outages, or other Hosting Center events.
• Completed upgrades, apply patches, and perform regular maintenance on production environments.
• Responded to trouble calls, outages and perform troubleshooting and provide solutions.
• Completed daily checklist of environments to validate performance and stability.
• Provided recommendations and feedback to Product Management and Product Development as it relates to applications
• Created documentation related to operations, implementation, monitoring and control.
• Prepared PL/SQL statements and execute stored procedures withinORACLEand MS SQL.
• Responded to feature and functionality questions from the various channels, including both internal/external customers and vendor.
• Documenteddatabasestructure, changes, problems, issues for future reference

Confidential

Oracle Database Administrator

Responsibilities:

• Planning, installation, configuration, management and troubleshooting of Red Hat Enterprise Linux platform
• Install and manage virtual Linux machines on VMWare ESXi
• Work closely with software developers as needed to troubleshoot and resolve production outage
• Create mount points for database administrators for Oracle database install
• Creation and management of approved user accounts and groups
• Manage filesystems utilization using script scheduled as cron job track filesystem space usage
• Maintain user-based security via password aging
• Maintain file system and host security using chmod, chown, chgrp, immutable bit, iptables and tcp wrappers
• Turn-off unused services on systems to strengtan host security
• Disabled direct ssh root login on servers
• Configure and manage TCP/IP networking on RHEL systems
• Troubleshoot and resolved networking issues
• Perform software package installation, upgrades and updates using yum and rpm commands
• Apply system patches and updates
• Manage filesystems using fdisk and LVM
• Perform critical system administration tasks from Single user mode
• Create directory symbolic links for users as requested
• Install and configure Apache httpd server to be used by developer to host web applications
• Configured multiple websites on one Apache http server using virtualHost containers
• Install and configure Apache tomcat server for developers
• Configure NFS server and mount exported nfs resources at the client side
• Configured and managed vsftp servers
• Utilized f5 Big IP load balancer web interface to control traffic on web servers during system maintenance
• Change root password on all server from centralized puppet master server
• Manage user access