SUMMARY

• 3 years of experience in the IT industry. 2+ years of experience as an Oracle Database Administrator.
• Responsible for Administration, Installation, Upgrading, Configuration, Maintenance, and Troubleshooting of the Oracle Databases.
• Complete range of Oracle DBA activities including day - to-day production database monitoring, Backup & Recovery.
• Administering the Database users, Managing all types of database objects and responsible for data/database security and protection.
• Use DBCA to create and DBUA to upgrade Oracle databases.
• UNIX Systems Administration, Help desk assistance, Hardware troubleshooting, Issue logs tracking and Patch management with excellent technical skills
• Provide administrative database security role by protecting the database, creating and managing users.
• Provide system management role by troubleshooting, reviewing and monitoring database performance.
• Performs general DBA duties (install software, create databases, table spaces, add redo log files, managing storage & work closely with Sr. DBA on capacity planning and performance tuning
• Performs daily database backup of development and test environments, use production data to refresh development and test schemas for testing
• Excellent troubleshooting skills
• Performance tuning and monitoring
• Identify and make recommendations per database performance issues
• Knowledge of managing Oracle on Windows
• Knowledge of database design
• Use DBCA to create and DBUA to upgrade Oracle databases
• Prepare documentation for DBA department
• Implements/maintains database security with roles and system privileges
• Experience working in a help desk and call center environment.
• Demonstrate ability to quickly diffuse heated customer situations.
• Excellent troubleshooting and logical problem solving skills.
• Creative ability to solve unusual or difficult problems when logical methods have failed.
• Demonstrate ability to meet deadlines and set priorities.
• Strong communication and interpersonal skills.
• Ability and desire to learn new technologies quickly.

TECHNICAL SKILLS

Relational Databases: Oracle 10g, 11g, 12c

Operating systems: Microsoft, Unix( Linux)

Networking Topologies / Protocols: Ethernet, TCP/IP & router configuration

Programming Languages: SQL,SQL*PLUS

Software Applications/Tools and Utilities: OEM, RMAN, DATA MIGRATION-EXPORT-IMPORT,BACKUP &RECOVERY PERFORMANCE TUNING-SQL-LOADER, DATA GUARD, AWR.ADDM.

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administrator

Responsibilities:

• Participate as an active member of the operational support team to monitor, report, troubleshoot, escalate and resolve technical issues with Oracle databases and associated systems
• Execute SQL queries against Oracle databases
• Transferring, cleaning and validating client data
• Documenting processes, standards and methodologies for working with client data and systems
• Developing, updating and maintaining reporting processes and tools
• Provided Oracle network troubleshooting, technical and administrative duties
• 24/7 production environment support
• Applied security features to 10g and 11g databases
• Tuned the database and applications for faster and better performance also performed goal oriented tuning as necessary

Confidential

Oracle Database Operator Intern

Responsibilities:

• Planning, installation, configuration, management and troubleshooting of oracle 10g and 11g databases on Linux and Windows OS
• Assisted in database upgrade from 10g to 11g and 11g using DBUA.
• Assisted in Installation and Management of Oracle using Grid 11g and database control by installing the software and agent, this I used to manage multiple databases.
• Assisted in Installation and application of several oracle critical patches to various database versions looked for critical path for the OS and also had to check the location of my O-Patch.
• Monitored, optimized and allocated physical data storage for database systems
• Implemented the use of Oracle Recovery Manager (RMAN) to back up the databases.
• Performed import and export as needed on each database.
• Assisted in Performing various daily RMAN backups and recovery for numerous oracle 10g and 11g databases using physical backup (RMAN) and logical backup (export, import and data pump).
• Install and configure Physical Standby on Windows and Linux environment.
• Troubleshoot and resolved various oracle problems such as connectivity problems, back up and performance issues
• Provided Oracle network troubleshooting, technical and administrative duties
• Created and managed documentation on the configuration and support of the oracle databases.
• Created and managed user accounts, profiles and system policies.
• Performed a flashback and point in time recovery
• Migrated data using the data pump export (expdp) and import (impdp)
• Created non-default listeners for databases.
• Provided Oracle database administrative support to various user groups (application developers, data managers etc.);
• Control and monitor user access to the database using roles, and profiles
• Performed hands-on monitoring, troubleshooting and administration of Local Area Network (LAN) resulting in performance and minimum downtime in the organization.
• Create and Maintain of Databases through DBCA
• Knowledge in Database performance monitoring & tuning
• Investigate potential problems and issues raised by business users
• Create and Assign Roles, Privileges and Profiles to Users
• Monitoring Alert logs for any errors, problems or processes running
• Configuration and working with RMAN (Recovery Manager).
• Knowledge in cloning using cold backup, hot backup and RMAN