SUMMARY

• Experienced Oracle DBA with 6 years of experience in Oracle DBA in large - scale production environments across multiple platforms.
• Ability to provide expert-level technical support in all aspects of database administration including installation, configuration, upgrades, patching, migration & capacity planning.
• I have monitored and managed databases of varied sizes ranging from 40GB to 30TB across the SDLC. I have worked for Production support on performance tuning, backup and recovery, database security, data migration, managing/monitoring databases, database/schema refreshes, cloning, data Replication.
• I have done Project work on Upgrade, Installation and configured a Physical Standby Data guard, 2 node RAC and Golden Gate for Oracle High Availability Solutions.
• Ability to work both as an individual contributor and as a member of a team.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes.
• Experience in configuring Data Guard. Implemented Physical Standby in latest project.
• Experience in Backup & Recovery techniques of databases running in
• ARCHIVELOG MODE using RMAN.
• Monitoring and Optimizing the Database Performances through Database Tuning, System Tuning, Application/SQL Tuning.
• Planning and scheduling Physical Backups (offline/online) and Logical Backups (with Export/Import utilities).
• Expertise in UNIX shell Scripting (Bash).
• Detecting and diagnosing production system performance problem by analyzing Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Experience in Capacity Planning, Space Management, Database Upgrades / Migration Data Extraction.
• Hands on experience working on High Availability Environments.
• Experience in configuration and maintaining Oracle Physical Standby Database using Oracle Data Guard 10g 11g and 12C.
• Plan, Implement and test disaster recovery system, using RMAN and custom written shell scripts.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN
• I have also successfully upgraded from 11g (11.2.0.3) to 12c (12.1.0.1) using DBUA.
• Experience in applying several patches such as CPU/PSU patches, One-Of Patches, Interim patches, DST, Patch sets as per the oracle recommendations.
• Duties included database creation, backup/recovery using RMAN, tuning/reorganization, user and security management, auditing, cloning, general troubleshooting, and configuring servers.
• Extensively used Oracle Enterprise Manager (OEM 13C) for maintaining and monitoring database.
• Experience in Logical backup using and full/ partial export/import and Data Pump.
• Extensive work experience in a database migration project team, serving in both an advisory and technical capacity.
• On call technical support for 24x7 mission critical production databases. Willing to work beyond regular hours.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Linux, Unix shell scripting, C, C++

RDBMS: Oracle 10g, 11g, 11g2, 12C

Tools: Oracle Grid control, Oracle Enterprise Manager (OEM), AWS CONSOLE TOAD, PUTTY, SQL Plus, SQL Developer, SQL, Access Advisor, SQL Tuning Advisor, CLI, puppet, chef, terraform

Utilities: SQL Loader, Export / Import, Expdp /Impdp, AWR, RMAN, STATSPACK

Operating Systems: RHEL 4/5,6,Sun Solaris 5.8, 5.9, Windows 98/NT/2000/2003/XP/7, AIX

Protocols: HTTP, TCP/IP, FTP, SFTP, SSH, Telnet

Web Tools: HTML, XML

Database Modeling: ERWIN

PROFESSIONAL EXPERIENCE

Confidential, Albany, New York

Oracle DBA/AWS Cloud

Responsibilities:

• Installation, configuration, Maintenance and Support of Oracle 11g and 12c (Multitenant and NON-CDB) Databases. Installation of 11g and 13C OEM and customized it to our needs. Installed Oracle 11g on Linux and Solaris platform.
• Implemented proactive Performance Monitoring Tuning and Troubleshooting using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN. Use of Ticketing (The ticketing system we use at my job is BMC) system to perform day to day DBA activities.
• Database monitoring/maintenance using OEM (Oracle Enterprise Manager) and Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.
• Responsible for Backup and recovery of the databases using RMAN Tool (Recovery Manager), and Database Flashback using PITR (Point in time recovery) and Export and Import (Datapump and Normal) for restoring the specific objects at the database level.
• Using the new innovative technology NETAPP snapshot to backup and recover the Database
• Creation, Configuration and Setting up of RMAN Catalog databases and registering target Databases with the Catalog. Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g/11g/12c environments.
• Supporting multiple databases for and staging purposes on DEV-TEST-QA- PRODUCTION Red Hat Enterprise Linux and Solaris platform.
• Successful installation/maintenance of Physical Standby database using
• Oracle Data Guard for Oracle 11.2.0.3 and Oracle 11.2.0.3 RAC databases.
• Performed refreshes on Dev and Test instances with data from Production on a regular basis.
• Made optimal use of Oracle Support in resolving the SRs
• Participate on project teams as database administration support to ensure dat databases are appropriately modified to support new business applications and requirements.
• Worked on a project dat successfully applied patches, maintenance and interim (Opatch) patches on the databases. Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Worked on a project where we built Oracle Stand by databases for real-time replication. Implemented an Active- active bidirectional Data guard, creating both logical and physical standby databases in 11g and 12c. Implemented switchover on primary and standby databases as a part of planned maintenance activities.
• Worked on a project where we successfully installed, setup and created a 2 node
• Oracle 11g RAC for High Availability, Scalability and Performance
• Perform day-to-day DBA activities such as production databases monitoring, table space growth, and performance tuning using OEM 13C.
• Perform Oracle quarterly QA refresh with data from Production database.
• Linux and AIX shell scripting and automate of Oracle database related activities
• Configure Oracle 13c Cloud Control for databases monitoring and administration support.
• Perform database restore/recovery using NETAPP snapshot Technology.
• Worked closely with Application Developers to design/create new Oracle databases/create new schemas/database objects, as well as making database changes from DEV to PROD, via TST following requests/demands from the development team.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and Creating & Managing Database Structures, Storage Allocation, Table/Index segments, Constraints, Database Access, Roles and Privileges.
• Work on built project moving one Oracle Database to another on Solaris and Linux platform.
• Performed SQLand PL/SQL tuning oracle contention and monitored production database using AWR Reports, SQL Tuning Advisor on OEM 13C.
• Currently working on built project to configure Oracle 12c Goldengate to replicate data from oracle database to SQL server.

Confidential

Oracle DBA

Environment: RHEL 5.X, 6. NT 2000/2003; Oracle 10g, 11g, 12C, AWS CLI.

Responsibilities:

• Oracle performance tuning using the EXPLAIN PLAN, AWR, ASH, TKPROF and ADDM. Extensively used AWR, ADDM and explain plan for periodic performance tuning. Implemented proactive Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Expertise in maintaining and Implementing Advanced Database Security using auditing, Transparent Data Encryption (TDE), Data Redaction and data masking. Creating/managing profiles, users, granting and revoking roles and privileges.
• Used TOAD, OEM and RMAN for database management/monitoring. Use of Oracle Support in resolving the SRs
• Backup and restore using RMAN utilities, recovery Catalog. Used different backup and recovery strategies.
• Used import/export utilities for cloning/migration of small sized databases and Data pump import/export to move data between and 10g/11g environments.
• Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Worked with latest 10g/11g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM.
• Worked on a project to apply Patches and upgrading of databases on Oracle database versions 10g,11g & 12C using OPatch utility.
• Worked on a project dat Configured Dataguard between the primary and standby databases, perform Switchover/Failover and monitor the Dataguard status via DGMGRL and GUI.
• Utilizing command line to create and manage database users and objects on a daily basis.
• Provide operational support to developers and application support teams
• Monitor user sessions, killing inactive session when necessary
• Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.
• Test backupsperiodicallyto ensure minimal recoverability time to meet business objectives.
• Used cross platform transportable table space (TTS) to transport table spaces across platforms.
• Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.
• Implemented Data Guard, Physical Standby database in 10g and 11g RAC environment for the Production databases for Active and Passive cluster.
• Experienced in Design, implementation and generating documentation of Oracle 10g and 11gData Guard on both physical/logical standby databases in high availability mode.
• Successfully upgraded Oracle 10g (10.2.0.4) to Oracle 11g (11.1.0.6) and Oracle 11g (11.1.0.6) to Oracle 11g (11.2.0.3) on Red hat Linux 6, IBM-AIX.
• I have also successfully upgraded from 11g (11.2.0.3) to 12c (12.1.0.1) using DBUA.
• Writing and modifying UNIX Shell Scripts to manage Oracle environments for Backend Processes.
• SQL tuning and Database performance tuning TEMPhas been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export and Data pump utilities).
• Database Refreshing / Replication from production to testing using Exp /Imp.
• Wrote shell scripts for purging trace files, alert log and network log files in Linux boxes which is used as standard script across all the databases
• Extensively worked on setting up auditing in many databases we supported

Confidential

Oracle Database Administrator

Environment: RHEL 5.X; Windows NT 2000/2003; Oracle 10g, 11g

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11 g R2 on Linux and also Upgraded from Oracle 10g to 11g.
• Involved in checking and managing Tablespaces growth, monitoring the data file growth and extents too.
• Involved in export and import of database objects in order to copy them from one database to another & for backup the tables.
• Implemented the resizing the online redo logs in production and in standby database.
• Configured RMAN and performed daily backups.
• Conducted daily routine checks on alert logs and trace files.
• Creating the Database, Tablespaces, Control files, log files and user profiles.
• Installed, Configured and Administered Oracle Streams.
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Scheduled Oracle Jobs in the database.
• Analyze the schema and tables.
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant
• (DBUA) for migrating Oracle 10g versions to 11g.
• Data Refresh from Production to Test and Development environments using
• RMAN Duplicate Database.
• Responsible for all database activities such as User management, space management, database security management.
• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4 and 11.2.0.3.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and Creating & Managing Database Structures, Storage Allocation, Table/Index segments, Constraints, Database Access, Roles and Privileges.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, Indexing

Confidential, Virginia Beach

Jr. Oracle Database Administrator

Environment: RHEL 3.X, 4.X; Windows NT 2000/2003; Oracle 10g; VMware.

Responsibilities:

• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control & SQL*Plus, as well as UNIX shell scripts.
• Involvement in all phases of the project life cycle.
• Designed database tables as per technical specifications.
• Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Worked closely with Application Developers to design/create new Oracle databases/create new schemas/database objects, as well as making database changes from DEV to PROD, via TST following requests/demands from the development team.
• Backup/Recovery of Oracle 9i/10g databases using Oracle RMAN.
• Performed day to day activities such as, daily error checks and database health monitoring ofphysical resources (disk space, memory, CPU, etc.).
• Performance parameters adjusted as needed.
• Produced backup report to ensure the backups were all successful and troubleshoot if the backup was not successful to find out the root cause.