SUMMARY

• A self - motivated, responsible and reliable Oracle Database Administrator with extensive experience managing versions of Oracle 10g to 11gR2 on flavors of Unix ( HP-UX, Red Hat Linux, Solaris) and windows, providing support on Oracle database installation, configuration, upgrades, migration, Performance tuning, Database security, strong RMAN backup and recovery strategies, Network administration and Database cloning.
• A team player with strong problem solving skills of diverse scope where technical analysis and evaluation is required.
• Result-driven and has an established reputation for effectively working with diverse groups of people and adaptability to changing environments
• Planning, installation, configuration, management and troubleshooting of Oracle 10g and 11g databases on Linux and Windows OS
• Performed creation of databases, table spaces, tables, indexes and other database objects.
• Perform bulk load into the database using SQL Loader
• Extensively using DATAPUMP and Export /Import utilities for logical backups.
• Performing database cloning using RMAN.
• Monitoring the user sessions and take appropriate action to kill the inactive sessions
• Creating and rebuilding indexes as necessary.
• Managed database objects such as procedure and functions
• Schedule all kinds of database job using the scheduler
• Administer database user accounts. Creating profiles, Roles assigning and revoking Privileges
• Performed various performance goal oriented database tuning.
• Use AWR, ADDM and various Oracle Advisors to tune the database.
• Tuned various slow running query
• Apply quarterly CPU patches to different version of databases.
• Upgrade Oracle 10g database to 11g.
• Upgraded Oracle 11g databases from 11.2.0.1 to 11.2.0.3 using patch set
• Installed, configured and managed 11gR2 (RAC) on ASM storage

TECHNICAL SKILLS

• Oracle 8 9i 10g 11g 12c
• Linux/Unix and Windows
• SQL
• PL/SQL
• Oracle Application Express
• Oracle RMAN
• Oracle 11g Grid Control
• Real Application Software (RAC) Data Guard
• SQL*Loader
• EXP
• IMP
• Data Pump
• SQL developer
• AWR
• Oracle Enterprise Manager (OEM) database
• ASH
• AUTO Trace and Oracle Enterprise Manager.

PROFESSIONAL EXPERIENCE

Oracle Database Administrator

Confidential

Responsibilities:

• Installed, configured and managed Oracle 10g and 11g on Windows platform
• Interacted with the Technical Design team and contributed in database design and implementation
• Consistently delivered work assignments within given timeframe, with high quality and zero defect work which was highly appreciated by the client
• Performed daily incremental backup and full weekly backup using Oracle backup utility RMAN.
• Creating tables and views for developer and client needs
• Created Databases with DBCA, configured them to meet developer and user requirements.
• Managed two node RAC databases using CRSCTL, SRVCTL and grid control
• Configured and setup Oracle 11gR2 Data Guard.
• Managed Data Guard Physical Standby. Failover/Switchover
• Managed Data Guard using Data Guard broker.
• Troubleshoot and resolved log gap in Data Guard Configuration
• Applied CPU patches on Oracle databases
• Upgrade Oracle 10g database to 11g.
• Installed and manage Oracle Enterprise Manager.(OEM)
• Designed, tested and implemented database migration procedures using exp/imp migration utilities and SQL loader
• Implemented security administration by creating roles, views and system/object level privileges for users
• Maintained data integrity and security using integrity constraints and database triggers
• Troubleshoot and resolved various Oracle connectivity problems.
• Participated in perform bulk load into the database using SQL Loader
• Perform standard and fine grain database auditing.
• Documented database structure, changes, problems, issues for future reference
• Administered database user accounts. Created, modified and deactivated user accounts; assigned and monitored user access
• Performed database Replication and Integration using Oracle Streams

Oracle Database Administrator

Confidential

Responsibilities:

• Performing Complete Media Recovery of Database depends on the nature of failure.
• Configure and implement the use of Oracle Recovery Manager (RMAN) for cold and hot database backup
• Install and configure relevant network components to ensure database access as well as database consistency and integrity
• Documented database structure, changes, problems, issues for future reference
• Administer database user accounts. Create, modify and deactivate user accounts; assign and monitor user access rights
• Configure and implement the use of Oracle Recovery Manager (RMAN) for cold and hot backup to the databases
• Troubleshoot and resolve various Oracle connectivity problems.
• Provide network troubleshooting and administrative support for the development staff.
• Installation and management of Oracle database using database control
• Perform standard and fine grain database auditing.
• Documented database structure, changes, problems, issues for future reference
• Administered database user accounts. Created, modified and deactivated user accounts; assigned and monitored user access
• Provided database administration on production, testing and development database servers.
• Identified and removed fragmentations, row migration/chaining of database objects.
• Assisted in systems backup and recovery procedures.

SYSTEMS ANALYST

Confidential, Washington DC

Responsibilities:

• Worked with a team that developed and implemented an Integrated Acquisition System (IAS) to streamline and automate contract management and acquisition processes throughoutUSDA, and ultimately enhance support of USDA mission-critical activities.IAS wasa modern, web-based solution designed to help USDA procure goods and services more efficiently and transparently.
• Conducted research and interviewed employees from different departments within the USDA in order to obtain system requirements and changes desired to be seen on their system that will make transaction more manageable.
• Provided Support to the USDA Contracting Officer Technical Representative (COTR) who managed the National Institute of Health (NIH) and Davis Bacon website for contractors who bid for contracts, created user IDs and passwords to access the system and assisted users with Log in problems.
• Assisted in writing Oracle reports and SQL queries to gather data and system requirements for the new system being developed.
• Upgraded the database from oracle 7 to oracle 8i
• Installed, configured and managed Oracle 8i/9i on Windows platform
• Interacted with the Technical Design team and contributed in impact analysis and creation of the Technical specifications.
• Monitored database activities, file usage and ensured necessary resources are present so that database functions properly by removing or deleting old or obsolete files.
• Applied security patches on Oracle databases
• Monitored and maintained databases, check alert logs and undo space management
• Designed, tested and implemented database migration procedures using exp/imp migration utilities and SOL loader
• Created database design according to the requirements of application software on Linux
• Implemented security administration by creating roles, views and system/object level privileges for users
• Maintained data integrity and security using integrity constraints and database triggers
• Installed and configured relevant network components to ensure database access as well as database consistency and integrity
• Troubleshoot and resolved various Oracle connectivity problems.
• Provided network troubleshooting and administrative support for the development staffs.
• Participated in perform bulk load into the database using SQL Loader