SUMMARY:

• 8+ years of experience in Oracle database administration, system Analysis, implementation and Testing of Relational Database Management systems for Business solutions
• Expertise in Installation. Configuration. Upgrading. Patching. Migration Trouble shooting and Performance tuning of oracle 10g/11g and 12c databases on UNIX, LINUX and Windows environments
• Practice in creating Backups & Recovery procedures and implementing BACKUP and RECOVERY strategies for off - line and on-line Backups.
• Build configured and managed multi node RAC Cluster on RHEL
• Worked on Exadata X5
• Build RAC Clusters
• Migrated standalone databases to 2-node RAC Exadata
• Practiced in OEM (Oracle Enterprise Manager)
• Set up and managed GoldenGate Replication
• Experience in Oracle Data Guard, and SQL*PLUS, Explain Plan and TOAD
• Worked on Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases.
• Used OEM Grid Control Diagnostic and tuning packs to tune the application and SQL queries
• Good exposure on Amazon Web Services (AWS).
• Good knowledge of Flashback database, Flash recovery Area, ASM and RAC
• Experienced with tools/utilities: OEM, RMAN, TOAD, and Data Pump (expdp/impdp).
• Supporting development 24/7 production systems. Providing on call support for mission critical applications.
• Performing backups and crash recoveries using conventional hot/cold backups and RMAN.
• Full control of tablespaces.
• Fair knowledge ln writing UNIX Shell scripts to automate business process and daily backup.
• Experience with testing and pre-production and production of Oracle 11g R2 with 2 nodes RAC on Red Hat Linux with ASM.
• Good knowledge in Hot/Cold Backup, Recovery, and Cloning of database using RMAN.
• Performed all aspects of database administration including installs, builds, upgrades, object sizing, object creation backup/recovery, patches, monitoring, and exports/imports.
• Good experience in SQL, Shell Scripting.
• Experience with installing and maintaining Oracle Grid Control. installed and configured 11g RAC on LINUX platform with ASM disks for storage
• Supported the system 24x7. Ability to work beyond regular hours

TECHNICAL SKILLS:

Scripting: Unix/Linux bash shell programming, Windows batch files

OS Administration: Solaris, Linux, Windows, AIX

Database: Oracle 10g, 11g, 12c Microsoft SQL Server, Microsoft Access

Concepts & Administration: Full Database Administration, Data Guard (standby), RAC, ASM, GoldenGate, AWS, Exadata, Partitioning, Flashback, Scripting

EXPERIENCE:

Confidential

Oracle DBA Consultant

Environment: Oracle 11g, 12c RAC, ASM - Linux, Solaris, Data Guard

Responsibilities:

• Setup standby data guard between primary and standby data center.
• Managed 4 node RAC clusters
• Upgraded databases to 12c on Exadata.
• Setting and Monitoring Exadata using EM12c
• Maintaining and Troubleshooting Exadata Cell/Storage and DB/Compute node performance issues
• RCA for Node evictions and Instance evictions in Exadata
• Troubleshooting Infiniband/RDS performance issues
• Troubleshooting Exadata smartscan/offloading issues
• Supported production, development and testing databases of Multi Terabytes DB sizes.
• Skilled with Stats pack, AWR. And ASH to check health of database & hardware.
• Used Performance tuning tools such as explain plans and SQL tune advisor (OEM).
• Migrated databases to different datacenter..
• Handled RAC Node hangs and node failover tests.
• Maintaining schemas and tablespaces.
• Responsible for administration and supporting Oracle 11g and 12c databases.
• Performing day-to-day database administration tasks like Tablespaces usage, checking alert log, monitoring disk usage, running SQL scripts against tables/schemas, table partitioning … etc.
• Worked in Tuning OS, Shared Pool, Golden Gate monitoring, creating crontab jobs.
• Experienced in using Data Pump (expdp/impdp) to transfer databases from one server to another.
• Experienced in using BBDA to build servers/nodes, databases/instances, and RAC on Linux box.
• Good experience in SQL Tuning, and performance tuning.
• Provided day to day support along with 24-7 on-call rotation.

Confidential, NJ

Oracle DBA Consultant

Environment: Oracle 11g - AIX Unix, Windows Server 2008

Responsibilities:

• PSU patching for both AIX and Windows servers’ databases.
• Used Performance tuning tools such as explain plans and trace files to tune SQL Queries.
• HOT/COLD RMAN backups for databases on all kind of servers.
• Responsible for administration and supporting Oracle 11g and 10g databases.
• Created, upgraded, and cloned Oracle databases for Development and testing databases
• Experienced in using Data Pump (expdp/impdp) to transfer databases from one server to another.
• Involved in 24x7 support for production RAC databases.
• Supported production, development and testing databases of Multi Terabytes DB sizes.
• Installation of 9i, 10g and 11g clients/databases on Solaris and Linux.
• Complete Build of 3-node 11g RAC Cluster on RHEL 5.x.
• Migrated 10g database to 11g R2.
• Skilled with Stats pack, AWR. And ASH to check health of database & hardware.
• Used Performance tuning tools such as explain plans and trace files to tune SQL Queries.
• Migrated databases to different datacenter.
• Experienced with SRVCTL, LSNRCTL, and CRSCTL of 11g RAC.
• Handled RAC Node hangs and node failover tests.
• Maintaining schemas and tablespaces.
• Responsible for administration and supporting Oracle 11g, 10g and 9i databases.
• Created, upgraded, and cloned Oracle databases for Development and testing databases
• Performing day-to-day database administration tasks like Tablespaces usage, checking alert log, monitoring disk usage, running SQL scripts against tables/schemas, … etc.
• Experienced in using Data Pump (expdp/impdp) to transfer databases from one server to another.
• Experienced in using BBDA to build servers/nodes, databases/instances, and RAC on Linux box.
• Good Experience in SQL Tuning, and performance tuning.

Confidential, Chicago, IL

Oracle DBA Consultant

Environment: Oracle 9i, 10g, 11g RAC

Responsibilities:

• Installing ASM environment and migrating database from NON-ASM to ASM
• Configure and manage tablespaces. Tables and users for custom applications.
• Developed views materialized views. Functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Experienced with Space Management and Security.
• Experienced with GUI and CLI to manage database farm house.
• Rebuilding of indexes for better performance and maintenance of Oracle Database.
• Tuning high - resource queries introducing hints and creating indexes/parturitions. Changing the query if necessary.
• Configured and Maintenance of SQL Server databases.
• Implemented 10g, 11g Physical Data Guard
• Implemented Oracle high availability solution using oracle RAC. Physical Standby and Golden Gate.
• Importing data from flat files into database using SQL loader and External Tables.
• Written shell scripts to automate the tasks
• Supported 24/7 on-call pager support for mission critical financial databases.
• Created users, roles and granted privileges according to the business requirements
• Database performance monitoring. Application performance monitoring, tuning database and application with efficient database parameters.
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Experience with pre-production and production of Oracle 10gR2 with multi node RAC with ASM.
• Applied latest patches as per evaluation requirement.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Extensive use of Oracle Data pump, Exports/imports utility for moving data among the servers.
• Created indexes to facilitate easy user interface implementation and tuning.
• Monitor (ADDM). Automatic Workload Repository (AWR) for monitoring database performance.
• Performed administrative maintenance, monitoring on Oracle database systems in a global.
• 24x7 operational environments.
• Involved in gathering requirements from end users.
• Intensively used 10g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.

Confidential, Naperville, IL

Oracle DBA Consultant

Responsibilities:

• Installing, upgrading and maintaining Oracle RDBMS on UNIX Linux platforms.
• Used Oracle Enterprise Manager (OEM) for administering several databases.
• Backup of database Logical and Physical (hot and cold) procedures and also using RMAN.
• Migration from Linux to Solaris and 32 bit to 64 bit.
• Restore and Recovery of database in case of database crash, disk/media failure.
• Applying patches and works closely with Oracle to make Application environment up to date.
• Backups & Recovery Maintenance, Databases Performance Tuning
• Typically involved in database Designing creation and maintenance.
• Involved in designing logical and physical data models using Erwin.
• Working Experience with Latest TOAD having new features PLSQL & SQL Script Debugger, Database Health.
• Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace and Query Builder.
• Created indexes to facilitate easy user interface implementation and tuning.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM).
• Automatic Workload Repository (AWR) for monitoring database performance.
• Tested database performance issues (monitoring and tuning) to ensure database optimization.