SUMMARY:

• Experience as an Oracle Database Administrator having hands on experience in installing, configuring, upgrading, patching, cloning and performance tuning on various OS platforms including UNIX, Linux and Windows.
• Expertise in installing, administration and configuring Oracle 11gR2 RAC/ASM and also converting standalone databases to RAC.
• Proficient in DR by setting up physical stand by databases.
• Expert in Data Modeling, especially in Logical/Physical database design.
• Installation and configuration of oracle Golden gate on 11g.
• Proficient in designing and implementing the backup strategy using RMAN and SAN storage clones.
• Maintained and supported Oracle databases along with using various tools such as Oracle Enterprise Manager (OEM), Oracle Grid Control and TOAD.
• Encrypted Oracle 11g and MS SQL 2008R2/2012R2 databases using Trasparent database encryption.
• Expert in both database and SQL tuning using SQLTXPLAIN, tkprof, sqltrace, AWR, and ADDM
• Expertise in planning, implementation and documentation of installation, migration, patching, backup retention policy, recovery, security, auditing, capacity planning, space management and storage allocation.
• Expert in AWR reports.
• Expert in migrating data from one instance to another using export/import and data pump utilities.
• Expert in shell scripting and scheduling jobs using crontab.
• Installed and configured OEM 12c.
• Excellent interpersonal and strong analytical, problem - solving skills with customer service oriented attitude. A very good team player, self-motivated, dedicated in any work environment.

TECHNICAL SKILLS:

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.1, 5.2,6.1, Red Hat Linux RHEL 4.x,5.x, Windows 2000/2003/2008

RDBMS: Oracle 11gR2, Oracle 11gR1, Oracle 10gR2, Oracle 9i.

Languages: SQL, PL/SQL, C, C++ and UNIX Shell Scripting

DB Management: TOAD, SQL Developer and Enterprise Manager grid.

Tools: /Utilities: RMAN, OEM, Oracle Management Service (OMS)SQL*Loader, ASM, Export/Import, TOAD, Patch: Management, ODBC, DBUA, DBCA, putty, Golden gate, ImpExp32, Grid Control, Data pump, Data guard, cloning, Exadata, RAC, Migration VERITAS Net Backup and MS Access.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM, SQLT, SQL TUNING ADVISOR.

WORK EXPERIENCE:

Confidential, ATLANTA, GA

Oracle Database Administrator & MS SQL DBA

Responsibilities:

• Installed, configured and maintained Oracle 11gR2/12c Real Application Cluster (RAC) databases including a 3 Node RAC.
• Involved in Availability testing of several Production databases before going Live which involved Node level failover testing, Listener/Scan level failover testing and database failover testing.
• Performed health checks of Real Application Cluster instances using crsctl and srvctl utility and troubleshooting RAC using clusterware logs
• Converted single Instance Databases to RAC databases Manually and expertise in troubleshooting RAC issues, very strong in using ocr config to backup OCR and Voting files
• Monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid) 11g /12c.
• Supported more than 80 production and development databases.
• Implement Enterprise Manager Grid Control (11g) to provide monitoring and management of the Oracle database estate.
• Encrypted Oracle and MS SQL databases using TDE.
• Worked on configuring databases on Azure.
• Worked on shrinking Log files by holding Replication, Backup and restore on MS SQL 2008R2 databases.
• Implemented Disaster recovery for production databases using Data guard and creating physical standby databases, and involved in converting physical to snapshot standby, and also Active Data-guard
• Converted physical standby to Snapshot standby and back to physical standby as per business requirement
• Setup physical standby’s (Dataguard) for several Databases and configured Data guard broker between the primary and standby databases,
• Assisted in deployment of software environments, integration connectors, and customizations
• Problem diagnosis and Performance tuning by implementing Partitioning, Parallelism and Compression.
• Setting up Hugepages - Calculated the recommended values and setup hugepages on Linux severs.
• Performed Database and SQL tuning by using various Tools like AWR reports, SQL Tuning Advisor, ADDM, Real Time ADDM, Database Replay and EXPLAIN PLAN analysis for query optimization.
• Performed stopping and starting web logic server whenever required and Worked with Fusion middleware team in tuning oracle database parameters, tested and deployed in production
• Provided backup/Restore; Recover of the databases using RMAN and FLASHBACK database procedures.
• Installed and controlled Grid Control to monitor RAC and Non RAC instances patched and upgraded the grid control
• Applying Quarterly patches and Version change patch bundles.
• Upgrade the binaries by applying patch set and interim patches using OPatch and OPatch Auto.
• Creation of new PL/SQL procedures and triggers based on the project requirement and UNIX shell scripting as and when required based on the requirement.
• Implemented backup strategies using hot/cold, Expdp/Impdp used on the business requirement.
• Backup and recovery procedures using RMAN. Created scripts for RMAN incremental backups and also for full database backups using Datapump.
• UNIX shell scripting as and when required based on the requirement.
• Providing technical support to Application Support team for performance and database related issues.
• 24x7 Production database administrations, support and monitoring to ensure a proactive problem recognition and resolution of database issues.

Environment: Red Hat Linux5.x, Aix 6.1, Oracle 9i,11g Oracle Enterprise Manager 12c, 11g r2Enterprise Manager GRID, RMAN, ASM, RAC, Streams, Opatch CDC, Data Guard, SQL*Plus, PL/SQL, ASM, ToadV11.x& SQL, Navigator V6.1.

Database Administrator

Responsibilities:

• Extensively involved in analyzing the functional requirements for the Database Access Profiles.
• Managed and monitored the Oracle Real Application Cluster (2 node RAC) running on VERITAS storage.
• Performed Tuning, coding and Monitoring for Oracle Real Application Clusters (RAC) nodes, Production Standalone Servers via Toad.
• Extensive experience in RMAN recovery in RAC and standalone database.
• Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases at the times of up gradation and migration.
• Performed Upgrades, Enhancements, and regular maintenance to system by researching, planning, as well as applying patches to databases and E-Business suite to keep them up-to-date.
• Kept databases, applications, and operating systems up-to-date through assessing, planning, and implementing upgrades and patches.
• Improved the database integrity and increased data accuracy for end-users and management by proficiently using SQL language to troubleshoot, query, insert, update, and delete table data.
• Installation, configuration and maintenance of Oracle 10g and 11g database on OEL.
• Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.
• Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.
• Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.
• Implemented data transfer using Data Pumps and Export/Import utilities.
• Taking the RMAN incremental and cumulative backups.
• Implemented DRP (Disaster recovery plan) for critical databases using Streams.
• Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Always monitoring the Oracle Instances, Users, Tables, Tablespaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs and Alerts.
• Created, monitoring database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Responsible for capacity planning, recovery planning and installing patches.
• Monitored the various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure proper capacity and availability
• Developed stored procedures using PL/SQL. Used Hints, Indexes, Explain Plan, Sql Trace and tkprof for effective retrieval and processing of queries used for retrieving current details and also history of changes made for a version.

Environment: Oracle 10g/9i, Sun Solaris 9, AIX, Redhat Linux, OEM, SQL, PL/SQL, SQL Plus, Unix.

Database Administrator

Responsibilities:

• Oracle Configuration. Oracle Tuning. Oracle Patch Administration.
• Installed patches and upgrades for various bugs.
• Migration of all Oracle 9i/10g databases/clients to 11g.
• Coordinating Backup and Recovery operations over all databases, ensuring 100% recoverability.
• Performing Daily, Weekly and Monthly Oracle monitoring and maintenance tasks.
• Wrote Stored Procedures according to specs and control files for input to SQL*Loader utilities for loading data from external files into the Oracle database.
• Planning, Installation and Configuration of Oracle Database on the Server.
• Creation of Table space, Data files, Indexes, Rollback Segment and monitoring them.
• Creation of Users and Granting them privileges and roles.
• Performed Database Tuning. Performed Database Security and Integrity.
• Wrote extensive Sub Queries, PL/SQL procedures, functions, database triggers and packages.
• Responsible for writing database programming to Store/Retrieve the information from the database using SQL.
• Designing and creating schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle.
• Writing Pl/SQL procedures and functions. Writing shell scripts to automate the data loading.
• Monitoring the data loading jobs and tuning the SQL queries.

Environment: Oracle 9i, SQL Server 2000, UNIX (Sun Solaris), Windows (NT/2000/Advanced Server), TOAD, OEM, SQL*PLUS, Explain Plan, UNIX Shell Scripting, PL/SQL navigator.

Database Administrator

Responsibilities:

• Oracle Configuration, Tuning, Patch Administration.
• Installed patches and upgrades for various bugs.
• Migration of all Oracle 10g databases/clients to 11g.
• Coordinating Backup and Recovery operations over all databases, ensuring 100% recoverability.
• Performing Daily, Weekly and Monthly Oracle monitoring and maintenance tasks.
• Planning, Installation and Configuration of Oracle Database on the Server.
• Creation of Table space, Data files, Indexes, Rollback Segment and monitoring them.
• Creation of Users and Granting them privileges and roles.
• Performed Database Tuning. Performed Database Security and Integrity.
• Wrote extensive Sub Queries, PL/SQL procedures, functions, database triggers and packages.
• Designing and creating schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle.
• Writing Pl/SQL procedures and functions. Writing shell scripts to automate the data loading.
• Monitoring the data loading jobs and tuning the SQL queries.

Environment: Oracle 10g/11g, SQL Server 2000, UNIX (Sun Solaris), Windows (NT/2000/Advanced Server), TOAD, OEM, SQL*PLUS, Explain Plan, UNIX Shell Scripting, PL/SQL navigator.