SUMMARY

• 8+ years of professional IT experience in Administration, Systems Design Development, Maintenance, Testing, Integration, documentation in high - availability environments.
• Expert in Architecture of Oracle Databases 11g RAC, 10g RAC, 9i with objectives of saving costs and time.
• Excellent experience in Installing, Configuring and maintaining Oracle 9.x/10g/11g/12c on Operating Systems such as Sun Solaris, IBM AIX, HP-UX, SCO-Unix, Red Hat Linux, Oracle Enterprise Linux and Windows
• Strong experience in supporting production, development, unit test, system test, Integration test, certification test databases under UNIX/LINUX.
• Experience in managing large mission critical databases high availability and disaster recovery environments in 24*7 using Oracle RAC, Standby databases (Active Data Guard).
• Experience in Upgrading databases (9i to 10g, 10g to 11g, 9i to 11g)
• Involved in doing Data Modeling, Data Mart, Data Warehousing, Data Transformation.
• Proficient in Database Administration activities such as Upgrades, Patches, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation.
• Expert in Administration, Productivity and Modeling Tools including OEM, Data pump, Exp/Imp, VERITAS, OLAP/Partition/RAC, Erwin, TOAD, SQL, Home-made Scripts.
• Installed, configured and Monitored OracleEnterprise Manager Grid Control 11g & Cloud Control 12c.
• Expert in Database Health Maintenance using Stats pack, TKPROF, RACDIAG, RDA, ExplainPlan, Enterprise Manager, Self-developed Scripts & methodology, Procedures.
• Expertise in cloning databases using manual methods and using RMAN Duplicate DB to create Test, Development databases and Active Duplication to create standby databases.
• Experience in Database Space Management, Memory Tuning and Application Tuning.
• Expertise in troubleshooting and Performance monitoring and tuning.
• Experience in Backup and Recovery activities using RMAN and conventional backups.
• Expert in configuration of 11gRAC, 10gRAC, Standby Databases (Active Data Guard) for High Availability, Disaster Recovery and reporting.
• Setup and Configure Exadata cluster with Glodengate replication.
• Exadata for best practices, maintenance and performance.
• Extensive experience with proactive monitoring, Capacity planning, benchmarking, partitioning.
• Experience in SQL (DDL, DML, and DCL), and PL/SQL and experience in writing stored procedures, packages, functions, and triggers.
• Expertise in maintenance, upgrade, administration, backup and recovery of Oracle Exadata systems.
• Expertise in Replication of Oracle Databases using Streams and Gloden Gate.
• Expertise in data archive and purge methodologies using Shell, Korn and Perl scripting.
• Expert in using Bitmap, B-Tree Indexes, Composite indexes, partitioning and histograms.
• Team player, maintained client/customer relationships by providing timely, quality and services, understanding of client/customer needs, opportunities and satisfaction criteria.
• Installing and monitoring database security tools like TIVOLI, BMC PATROL. Escalating teh issues as per teh severity of database and resolving it immediately without any delay.
• Proficient in interpersonal relations, leadership skills, Project Management, Communication, Teamwork & Organization
• Sound experience in different phases of a project life cycle including design, architecture, programming, testing, end user support, and preparing customer specifications as a part of software requirements.

TECHNICAL SKILLS

Databases: Oracle 12c RAC,Oracle 11g RAC, Oracle 10g RAC, Oracle 9i, Oracle 8i, Oracle 7.3, SQL Server

Operating System: HP UX 10.x, 11.x SunOS 10, 9, Linux RHEL 4.x, 5.x, 6.x, 7.x, AIX5L,6L,7L Windows 9x/NT/2000, UNIX, DOS

Programming: PL/SQL, Pro*C, SQL*Plus, C, C++, Shell & Perl Scripting, HTML.

Tools: RMAN, ASM, GlodenGate, Streams, DataPump, TOAD, SQL*Loader, AWR, ADDM, TKPROF, STATSPACK, Putty, Super Putty, OEM Grid Control 10g/11g, Cloud Control 12c.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Oracle Database Administrator

Responsibilities:

• 24x7 Production database and applications support.
• Administering ORACLE Databases 9i, 10g, 11g and also Oracle10g RAC/11g RAC.
• Applied patching for upgrading database from 9i to 10g, 10g to 11g and also for other updates.
• Experience in managing databases on high availability environment (Oracle RAC & Active Dataguard).
• Installed, setup and configuredOracleEnterprise Manager Cloud Control 12c as a tool of administration, performance tuning, monitoring, alerts and also OEM Grid Control 11g.
• Added and deleted RAC nodes using Oracle OEM Provisioning Pack.
• Experience supporting and managing teh EXADATA databases of various sizes ranging from 2TB to 72TB.
• Involved in teh Migration of 4-8 node RAC databases from Oracle Exadata V2 to Oracle Exadata X2 by using Data Guard and RMAN cloning.
• Upgraded teh 11.2.0.2 version RAC databases to 11.2.0.3 on Exadata X2 using DBUA.
• Installed fresh 11g databases version 11.2.0.3 on Oracle Exadata X2 ( half rack(QA) and Full rack (Prod))
• Resolved numerous issues involving 10g/11g databases on 11g R2 Grid/RAC and 11g ASM.
• Applied database patches using Opatch utility, building Clone instances for Development and Test teams.
• Managing multiple production, testing, QA and development databases and supported Application team.
• Implemented backup and recovery strategies using export/import, Datapump, RMAN Incremental backups, Traditional hot, cold backups.
• Created shell scripts and Perl scripts scheduled them for monitoring Oracle Databases.
• Creating primary database storage structures (tablespaces), altering, and modifying teh database structure according to teh company’s requirement as necessary, from information given based on business requirements.
• Migrated databases from AIX - LINUX, Solaris - LINUX.
• Setup Standby databases including Active Data Guard for disaster recovery and reporting.
• Planning and implementing Backup and Recovery procedures (RMAN), scheduling daily backups and performed periodic recovery tests.
• Skilled in using tools such as SQL Developer and TOAD.
• Performance tuning with AWR, ADDM, ASH, SQL Plan Management, SQL Tuning advisor, SQL Access advisor, Memory advisor, Segment Advisor, SQL Trace and TKProf, StatsPack, TraceMagic.
• Tuning init.ora parameters for optimal performance and scalability.
• Database Maintenance and clearing of locks, cleaning of database logs, Rebuilding indexes, Tablespace monitoring, database objects monitoring.
• Designing and developing PL/SQL packages in teh database layer, stored procedures, packages, functions and triggers.
• Performed SQL Server 2012/208 administration - creating database, setup jobs, backup and restore, monitoring space, alerts and fixing.
• UNIX scripting for automation backups, monitoring, statistics collection as well as for other routine tasks.
• GlodenGate installation, configuration for replication.
• Installing and monitoring database using security tools like TIVOLI, BMC PATROL. Escalating teh issues as per teh severity of database and resolving it immediately without any delay.
• Implement Linux Huge Pages to increase SGA performance.
• Designing teh security and database access strategies & cloning databases and partitioning tables.
• Creating and refreshing materialized views & performing SQL*loader jobs for data loading.
• Applied database patches using Opatch utility & worked on conversion from Single Node to Multi Node RAC.
• Working with Development, QA and other teams to resolve teh issues.

Environment: Sun Solaris, AIX, Linux RHEL, Oracle 10gRAC/11g RAC, Data Guard, Exadata, Datapump, RMAN, ASM, GlodenGate, SQL Server, PL/SQL, SQL Scripts, Shell Programming, SQL Developer, TOAD, Putty, Super Putty.

Confidential, Atlanta, GA

Oracle Database Administrator

Responsibilities:

• Installed, deployed and supported Oracle Grid/RAC 11g Release 2 on Linux 5 and AIX 6.1 with ASM.
• Planed, Configured, Set up and Supported high availability and high scalability Oracle 10g RAC/11g RAC on Red Hat Linux and AIX 5.3 with ASM.
• Migrated Stand alone databases on file system to RAC databases on ASM.
• Upgraded 11gR2 grid infrastructure as out of place patch.
• Applied patches on Oracle 11g/10g Clusterware and RAC databases.
• Extensive experience with rolling patches on 11g/10g grid/RAC.
• Applied numerous PSU, CPU, Patch set and one off patches to RAC, ASM and databases.
• Configured OEM Grid Control 11g to manage teh entire database in single centralized location.
• Configured and troubleshoot ASM Cluster File System (ACFS) for 11gR2 Grid/RAC cluster.
• Configured, tested and supported Oracle data guard RAC standby for RAC primary and standalone standby for RAC primary.
• Creating table spaces, tables, and users for custom applications in SQL Server.
• Worked on databases consolidation into a single database in Exadata.
• Worked on setting up Data Guard on RAC in Oracle 11g & Exadata.
• Managed patching and upgrade of Exadata Storage Server’s.
• Designed reliable, space and time efficient RMAN backup strategy.
• Coded various RMAN report scripts to report backup stats like time taken, compression ratio, backup set sizing, backup level, job status etc.
• Implemented data compression to reduce storage and improve performance for certain queries.
• Creating and maintaining Physical and Logical Data Guard (Standby Database) for Disaster Recovery.
• Setup, configure, developed database automatic monitoring of alert log, database status, space usage, connectivity, SGA etc.
• Expertise in teh Cloning (Refresh) databases from production to dev, testing. Coded scripts for automatically nightly refresh/clone of databases.
• Expertise in Monitoring and Performance Tuning of teh Databases through Tuning Applications, Tuning Memory and Planning Disk Usage.
• Expertise in configuration and implementation of Backup and Disaster Recovery, UNIX Shell Scripts, Perl scripts, RMAN and Export/Import utilities, Datapump.
• Experience in Capacity Planning, Space Management and Storage Allocation.
• Configured and supported Oracle Streams for data replication.
• Controlling and Maintaining System Security through Profiles, Roles, Privileges and Auditing.
• Migrated databases from HP-UX to LINUX.

Environment: Sun Solaris, HP UX, AIX, Linux RHEL, Oracle 10gRAC/11g RAC, Data Guard, Datapump, RMAN, ASM, GlodenGate, Exadata, SQL Server, PL/SQL, SQL Scripts, Shell Programming, TOAD, Putty.

Confidential, Omaha, NE

Oracle Database Administrator

Responsibilities:

• Managed several production, test and development instances (24x7 Support).
• Installed, configured and managed Oracle 10g RAC/ 11g RAC, Standby databases.
• Administering ORACLE Standalone and RAC Databases 11g, 10g, and 9i.
• Applications Patch management: Patch application and impact analysis, and trouble shooting.
• Involved in implementing Dashboard-based Monitoring solution by developing shell scripts and SQL scripts and also worked on Perl scripts.
• Performance Tuning Databases using SQL Trace, TKPROF, Explain Plan, STATSPACK, AWR, ADDM.
• Migrating Oracle databases from Windows to Linux.
• Monitoring growth of tables and undertaking necessary re-organization of database objects when required and generating trace files for problem resolution.
• Responsible for setting-up and managing Standby databases.
• User Maintenance (Creation, modification and deletions) and Custom code migrations.
• Proactive database monitoring using Oracle 10g grid control.
• Worked on user documentation like Instance strategy, Instance management, Problem manager, Setup document and Change management docs.
• Problem resolution repository created to reduce issue resolution timings.
• Creating and managing users, roles and profiles, auditing and monitoring user access.
• Planning and implementing Backup strategy for teh databases, Scripting backups.
• Planning and implementing Backup and Recovery procedures (Hot, Cold Backups and RMAN), scheduling daily backups and performed periodic recovery tests.
• Involved in a project, which analyzes and applies quarterly security patches (CPU&PSU).
• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora
• Allocated system storage and planned for future storage requirement for teh database.
• Created primary database storage structure for developers to develop and test teh Application.
• Data loading using Oracle SQL Loader, developing SQL Loader scripts to load global data, and fine tuned SQL Loader performance using Direct-load mechanism.
• Developing, Implementing and administering database policies and procedures.

Environment: HP UX, AIX, Linux RHEL 4, Oracle 11g RAC, 10gRAC, Oracle 9i, PL/SQL, SQL Scripts, Shell Programming, SQL Developer, Data Guard, RMAN, ASM, GlodenGate, Putty.

Confidential, Dublin, OH

Oracle DBA

Responsibilities:

• Configured and managed Large database using latest features of Oracle 9i/10g like Undo-Table space, Locally Managed Table space and Sorting Parameters.
• 24x7 Oracle Production Database Administration including Oracle 10g RAC.
• Wrote proactive scripts monitoring like monitoring teh disk usage and teh memory usage of teh server and monitoring tablespaces and mailing alerts when required.
• Involved in Logical backups, RMAN backups, Hot backups and Cold backups.
• Created and configured Data guard for physical Standby database on a fresh server starting from Oracle Installation in No-Data-Loss mode.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Installed Oracle 9i and 10g, RAC database on HP-UX 11.0, Redhat4 and Sun Solaris.
• Installed RAC on Oracle 10g and worked on ASM feature of Oracle.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks like Backups, exports and imports, archiving old records and verification of such processes.
• Used DBMS scheduler to schedule teh jobs and DBMS stats to gather teh statistics along with analyze command.
• Installation of Oracle RDBMS server software and version upgrades.
• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora
• Created Materialized views to make query response faster and has written shell scripts to refresh them.
• Created and managed tablespaces by adding/deleting/ resizing data files.
• Finest granularity approach to Oracle implementation and de-fragmentation.
• Creating DATAGUARD with logical- standby configuration with hot backup and testing it for fail-over and switch over in different modes.
• Extensively Installed Oracle10g and Upgraded teh database from Oracle 10gR1 to 10gR2 on Linux platform.
• Monitored growth of data and purged old records through automated scripts.
• Database activities include allocation and maintenance of Rollback Segments, Automatic Undo Management, table spaces, data files, redo log files, mirroring of redo log files across multiple disks.

Environment: Oracle 9i/10g, RAC, Sun Solaris 5.9, AIX 5.3,Redhat LINUX, Windows Server 2003, OEM, SQL*Loader, SQL*PLUS, TOAD, RMAN.

Confidential

Oracle Database Administrator

Responsibilities:

• Responsible for installing, upgrading and configuring teh Oracle server.
• Supported different Oracle 10g, 9i Databases of Production, Testing, Staging and Training.
• Involved in logical and physical data modeling and schema design using Erwin tool.
• Created database manually using Oracle Database Configuration Assistant.
• Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
• Creating databases, tablespaces, objects, roles and privileges.
• Partitioned large tables to increase teh performance and to improve me/O access.
• Responsible for Data load on different databases using SQL*Loader.
• Export and import of database objects using EXP and IMP Utilities.
• Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.Using database level triggers code for database consistency, integrity and security.
• Involved in teh database design, installation, creation of various instances, and creation of tables, granting roles to users and maintain teh security according to application.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc. Created users and roles, and maintained system security.
• Efficient in using teh Oracle Tools like SQL* Plus, SQL* Loader, TKPROF, STATSPACK, SQL*Net, IMPORT/EXPORT, DataPump and RMAN.
• Managing table spaces, user profiles, indexes, storage parameters.
• Develop table structures, PL*SQL stored procedures and database triggers to implement.
• Responsible to provide 24 x 7 database administrative activities over different database servers.

Environment: Sun Solaris, HP UX, AIX, Linux RHEL, 10gRAC, Oracle 9i, Oracle 8i, PL/SQL, SQL Scripts, Shell Programming, Oracle Enterprise Manager, SQL Developer, TOAD, Data Guard, RMAN

Confidential

Oracle DBA/Developer

Responsibilities:

• Configured and installed Oracle 9i on UNIX environment.
• Upgraded database from Oracle 7.3 to 8i, 8i to 9i
• Actively participated in team meetings with Business team for changes in design of teh database.
• Worked on database setup and monitored teh database growth on daily basis.
• Involved in teh logical and physical design of teh database tables.
• Sizing database objects for TEMPeffective space management and optimal performance.
• Actively participated in Database and application developers troubleshooting.
• Developed scripts for hot, cold and logical backup.
• Performed Backup and Recovery using RMAN and user managed techniques.
• Modified and established backup and recovery strategies and procedures.
• Administrated User accounts by creating users, roles and privilege and managing those using grants and profiles.
• Created tables, views and other schema objects with appropriate table space sizes.
• Database maintenance, upgrades, and patches release.
• Worked on database performance monitoring using OEM.
• Carried out Physical and Logical database design and database reorganization.
• Written SQL, PL/SQL functions, procedures, packages and triggers.
• Written shell scripts for backup and cloning automation, custom monitoring
• Created database links for accessing data from remote databases.
• Used EXPORT/IMPORT utility for performing logical backup for table level and full databases.
• Used teh Crontab in UNIX and Scheduler in Windows for Automatic Tasks (Analyzing tables, loading into Tables, Imp/Exp).