SUMMARY

• Oracle Database Administrator (DBA) wif over 6 (six) years of extensive experience on Architecture, Installation, Testing and Supporting next - generation database solutions in Oracle Database as well as other database/system related areas. Proficient in an assortment of technologies in Oracle Data Base Unix/Linux, Solaris and Windows.
• Oracle Databases wif an emphasis on problem solving, troubleshooting Production issues, provide guidance to Application teams on database performance tuning items and ensure database stability, availability and also provide support to upgrade, migrate and patching the systems.
• Experienced working wif fast-paced, large scale and very diverse 24x7 database environment.Continue interested in Oracle Database Administration position at a distinguished organization where I can utilize and further enhance my database design & administration, problem solving, communication, as well as technical writing skills.

PROFESSIONAL EXPERIENCE

Oracle Database Administrator

Confidential, Richmond, VA

Responsibilities:

• Installed Oracle Database 11gR2 (11.2.0.4) and 12c Software on Windows and mostly on Linux.
• Built physical standby databases for standalone databases on Linux platforms.
• Supporting 24 x 7 production database administrative activities over different database servers (Dev, Test, SQA, PreProduction & Production).
• Monitoring day-to-day Database administration activities such as Schemas, table space, mount point space and CPU utilization.
• Supporting production DB in solving the database problems and co-ordination wif Oracle Support (Submitting SR) in case of oracle database bugs to be solved.
• Designing backup and recovery strategy using RMAN.
• Performing oracle 10g/11g RMAN refresh of different environments such as development, testing from production environment.
• Using Expdp and Impdp for exporting and importing of database objects between databases.
• Upgrading and Migration of databases from 10g to 11g database environments.
• Involved in Application tuning using explain plan, DBMS STATS and ADDM.
• Performance tuning using AWR & ASH reports to view statistics regarding I/O Tuning, Memory Tuning, wait events, resource intensive SQL etc.
• Performed database tuning using Oracle Enterprise Manager.
• Responsible to write the SQL queries to generate the reports as per the client requirement.
• Scheduling Oracle Jobs and Backups using CRONTAB.
• Trouble shooting Database High load and Memory/Process issues.
• Responsible for ORA- errors when the application team performing any application upgrade.
• Alert log Monitoring for critical databases every day in the production environment.
• Scheduling and attending day-to-day meetings as part of agile/waterfall methodology.
• Maintaining Physical standby active data guard databases.
• Achieving High Availability, Data Protection and Maximum performance by maintaining both physical and logical standby databases.
• Converting Physical standby to open mode (then flashback) for testing purposes.
• Ensure Data Security using Transparent Data Encryption (TDE) and wallet creation.
• Configured and installed Real Application Cluster (RAC) database environment.
• Migrating Single Instance databases to RAC databases.
• Managing automatic storage management adding and dropping disks from disk groups.
• Installing and configuring of Golden-Gate on 11g database for the Bi-directional replication.
• Applied quarterly Oracle combo Patch (July 19, 2016).
• Compliance wif security auditing policies and procedures.
• Thoroughly reviewing and proofreading various IT related data/information; dedicating focus to accomplish tasks that are complete, precise, and accurate to a given IT situation.
• Making decisions or recommendations that influence Database and applied new developments to previously unresolved problems.
• Making clear and convincing presentations, listening to others, recognizing potential miscommunication, attending to nonverbal cues, and responding appropriately.

Oracle DBA

Confidential, Virginia Beach, VA

Responsibilities:

• Involved in installation of Oracle 10g and 11g standalone databases environments.
• Performed Daily Health Checkup of the database, reviewing logs and alerts and availability of databases.
• Created Users and granted them the required Roles and Privileges accordingly.
• Monitored Production database for performance issues.
• Managed RMAN backup of various databases in different environments.
• Created tables, views, indexes, views, materialized views, stored procedures, and other database objects as needed.
• Performed database/schema level refreshes of development databases from production using Data Pump export/Import.
• Performed allocation of system storage and planning for future storage requirements for the database and related functions.
• Performed periodic data refresh from production to testing environments, Re-organizing database structures.
• Created a Clone Database using RMAN.
• Responsible for backup of very large 10-TB Database.
• Monitored the Oracle Instances on Users, Tables, Tablespaces, Memory structures, Rollback segments, Redo logs, Archived Redo logs and Alerts.
• Involved in space management, rectification of lock problems, user session.
• Worked closely wif Software testing team and System Administrators.
• Implemented Data-Guard wif maximum availability, protection and performance configurations and worked wif Data-Guard Fail over and Switch over cases at the times of up-gradation and migration.
• Performed RMAN recovery in Real Application Cluster (RAC) and standalone database.
• Installed, Configured and Managed RAC database using srvctl and crsctl.
• Responsible for Oracle Database patching.
• Identified IT related problems using a variety of materials or sources.
• Gathered and applied technical information to determine accuracy and relevance to moderately complex problems

Confidential, Austin, Texas

Responsibilities:

• Responsible for the installation of oracle 10g/11g databases in production.
• Responsible for performing backup and recovery by using RMAN for hot backups, and weekly full backups.
• Responsible for developing, implementing, and maintaining processes and procedures for database administration on production and non-production servers.
• Performed installation of multi-node Oracle 11g databases on Linux OS wif RAC & ASM.
• Performed Configuration and utilize oracle flashback technology for recovery of errors.
• Proactively manage the database to prevent it from poor performance by using the Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) to analyze the statistic levels.
• Maintained Oracle Data guard for Physical standby databases for disaster recovery.
• Performed weekly refresh of Development and Test Databases using EXPDP/IMPDP from Production
• Worked as an on-call DBA for added support on a rotating schedule.
• Performed detailed analysis of the database for areas of optimization (e.g. tablespace, flashback log, undo, redo and archive log management).
• Responsible for system monitoring, improving database performance, active capacity planning and management.
• Performed migration of databases by using Data Pump utilities Expdp/Impdp and SQL*Loader for availability.
• Supported application development and performance test teams on Oracle-related topics and issues.
• Implementation of database patches PSU & CPU.
• Supported database issues in production, including on-call support as needed.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities and Performed database refresh activities for business requirement and tuning purposes.
• Assisted wif implementation by working closely wif developers, resolving questions and issues around business/functional requirements.
• Worked closely wif developers and system administrators to ensure all database needs are being met.

Oracle DB Admin

Confidential, St. Louis, MO

Responsibilities:

• Installed Oracle DB 10g, 11g RDBMS, RAC on ASM, Applying Oracle Critical patch updates, Implementing and Manage Data Guard, Backup and Recovery support and performance tuning.
• Manually created database wifout using DBCA.
• Installed Grid Infrastructure Software on new Linux Servers for 4 node RAC and Oracle Grid Control 11g Installation.
• Applied necessary Patches during installation and also in up-gradation of databases.
• Performed daily backups using RMAN.
• Responsible for performing Table space Management, Session Management, undo Management issues.
• Performed user management including creating users, giving privileges as the requirement, lock/unlock users and monitoring user space.
• Migrated databases from 10g to 11g using export/import and data pump export/import utilities and Performed database refresh activities for business requirement and tuning purposes.
• Experienced in switching primary database to standby and standby to primary during regular maintenances of catalog databases and disaster recovery databases.
• Utilized Data Pump tool for exporting and importing the data between databases.
• Used Data Pump for schema refresh and database refresh.
• Managed data dictionaries to check on role grantee and grantor.
• Successfully used flashback technology to recover lost data.
• Responsible for SQL queries to generate report as customer requirement.
• Performed team meeting related to the project