SUMMARY:

• Over 7 years of technical/consulting experience as Oracle Database Administrator, Data Analyst, Data Modeling and Data Migration in Oracle 9i/10g/11g on Linux, UNIX, Windows.
• Provided 24/7 on call support for very large databases VLDB and Data Warehouse environments.
• Excellent experience in OLTP/DSS database administration, implementing and managing Very Large Oracle Databases VLDB .
• Implemented High Availability/Disaster recovery using RAC, Physical Logical standby databases Oracle Data Guard .
• Experience with Real Application Testing RAT .
• Implemented Data guard Physical Standby for RAC databases.
• Upgraded 10g databases to 11g
• Upgrading 11i E-Business Suite to R12.
• Installation, Configuration and administration Oracle Golden Gate.
• Performing capacity Planning, Backup/Recoverystrategies using RMAN and conventional Oracle Hot and Cold backup and Export/Import.
• Experience with High Availability features RAC/ DG/ ASM / Flashback / RMAN .
• Oracle 10g RCA, Oracle 11g RACimplementation administration using Oracle Clusterware Oracle Cluster waresetup and configuration, RAC installation using ASM, Configuration and Patching, RAC Backup and Recovery .
• Experience in Data modeling using Reverse and Forward engineering for creating Logical and Physical Database models using Erwin.
• Experienced in using Oracle Enterprise Manager OEM /12C Grid Control for database monitoring.
• Good knowledge of Flashback Technology, Flash recovery Area, Automatic Storage management ASM and RAC.
• Performance tuning of Oracle 10g/11g databases, reviewing Statspack/AWR report for resolving performance bottlenecks and involved in SQL tuning.
• Strong RDBMS, SQL PL/SQL experience. Written Packages, Procedures, Functions, Triggers to incorporate complex business logic and writing shell scripts to automate day to day tasks.
• Refresh and Cloning using Datapump and RMAN with Commvault, VERITAS Net Backup TSM.
• Applied patches, performed database upgrades, migrations.
• Strong experience in using tools such as SQL Plus, TOAD,TKPROF, RMAN and Export/Import.
• Performance tuning using, SQL Trace, Explain Plan, STATS PACK, AWR, ADDM
• Proficientin Capacity planning and bench marking.
• Experience in performing crash recoveries without data loss.
• Experience in Databaseup-gradation and conversion from Oracle 9i/10g to Oracle 11g.
• Replication using materialized views, streams, Golden Gate.
• Knowledge on Exadata.
• Experience in different phases of Software Development Life Cycle which include Analysis, Design, Development and Testing and working closely in implementing DB Auditing and Compliance as well as Oracle and system Security enhancement.
• Strong Analytical, Communication, organizational, Troubleshooting interpersonal skills.
• Performed all aspects of database administration including installs, builds, upgrades, object sizing, object creation, backup/recovery, patches, monitoring, export/imports and SQL loader.
• Involved in capacity and resource planning. Estimated the size of data files and redo log files considering transactions rate, transaction records size, transaction type, and volatility of the data, recovery time allowed etc.

TECHNICAL SKILLS:

• Languages :PL/SQL,SQL,SQL PLUS,C,Java,Shell Scripting, Perl Scripting.
• Databas: Oracle 11g RAC/10g RAC/9i/8.x, MS Access, DB2 UDB
• Operating System : UNIX, Solaris,AIX,HP-Unix,Linux,Windows 2005/2003/XP/2000
• Tools :SQL PLUS,SQL Developer,TOAD, SQL Navigator,OEM,OEM12C
• RMAN, SQL LOADER, Imp/Exp and Data pump,NoSQL data
• stores Cassandra, MongoDB Hadoop.
• Tuning Tools : TKPROF, EXPLAIN PLAN, STATSPACK, ASH, AWR, ADDM
• Tools/Utilities :RMAN, ASM, Grid Control, Golden Gate, EXP, IMP, expdp, impdp
• Others: :EMC, NetApp, Veritas, TSM, HP OmniBak

PROFESSIONAL EXPERIENCE:

Confidential

Oracle DBA

Responsibilities:

• Managing Users, Privileges and Roles.
• Performance information and monitoring/interpreting alert log and trace files.
• Troubleshooting and maintenance of Oracle Database.
• Handling Import/Export like schema, table, full database etc.
• Experience in configuring and maintaining the RAC environment up to 4 node cluster.
• Proactive monitoring of Oracle Database which include Space management, Cluster services availability check, quickly identify and resolve database level errors.
• Cloning Oracle Databases between DEV, UAT and Production Environments.
• Performed SQL tuning, Application and database tuning.
• Writing and testing Shell Scripts for Monthly Partitions and backups.
• Setting sqlT profile for better performance.
• Managing DR server, standby DB, using DATAGUARD.
• Handling space issues.
• Performance monitoring and tuning using OEM Grid Control, SQL Trace, Explain Plan, STATS PACK, Automatic Workload Repository AWR
• Experience in Creating and maintaining Physical Standby Database.
• Changing the Mode of the Stand by database to Maximum Protection, Maximum Availability.
• To monitor maintain the performance of system hardware servers to ensure availability of system to the user.
• Refresh and Cloning of Database and applications for development and testing purpose.
• Worked on scheduling cronjob for automated tasks of oracle database.
• Experienced at enabling and analyzing SQL tracing and using TKPROF utility.
• Performed and expertise at export imports using exp/imp and Data Pump using with links.
• Created Indexes Primary and global Indexes .
• Provided partitioning of the large tables and automated the process of creating partitions for each year and setting statistics for better performance.
• Developed Oracle backup and recovery strategy and scripts.

• Analyzing tables on a regular basis for the Oracle optimizer.
• Created a logon trigger for the protected login's to the databases.

Environment: Oracle10g/11g, IBM AIX, Sun Solaris, OEM, SQL Developer, TOAD, RMAN, ASM.

Confidential

Oracle DBA

Responsibilities:

• Worked on database backup strategy designing and implementation using cold/hot backup techniques.
• Written SQL, PL/SQL functions, procedures, packages and triggers.
• Migrated NON ASM databases to ASM databases.
• Exceptional experience with MySQL Server.
• Monitoring and managing the Storage Usage by Resizing Older Tablespaces, Creation of New Tablespaces and relocation of data files for better Disk I/O.
• Configured Statspack for Tuning databases.
• Performed DB2 installation and configuration .
• Migrated Databases from MySQL, Oracle, IBM Informix, to SQL Server 2005/2007.
• Has worked on setting up OEM 12C also helped in creating a complete documentation.
• Installed upgraded and patched DB2 software and associated applications.
• Provided primary database administrative and Architect support for DB2 UDB Installed and configured DB2 V9.5 HADR environment.
• Provided primary administrative and Architect support for DB2 UDB V7, v8 and V9 databases in Linux and Windows and AIX P-SERIES, OLAP environment .
• Database Memory management shared pool, db buffer cache and log buffer .
• Upgrading, analysis and testing of the test and production database.
• Installation, Configuration and administration of 10g/11g RAC environment
• Monitored alert logs, trace files, partition tables and indexes for better performance of the database.
• High Availability Topologies for Oracle Access Manager OAM using load balancer to direct traffic to the Oracle HTTP Servers installed with WebGate and WebPass.
• Experience designing, configuring and implementing High Availability HA solutions for OID and OVD.
• Database physical/logical layout design and procedures for production, development, test servers.
• Performed export imports using exp/imp, Data Pump.
• Performed Data loads using SQL Loader.
• Installation and configuration of Golden Gate.
• Replication using Streams and Golden Gate.
• Performed real-time data integration, transactional change data capture, data replication using Golden Gate.
• Perform capacity planning required to create and maintain the database environments.
• 24x7 Production Database Support.
• Installation, Configuration and Administration of Oracle 10g,11g databases.
• Upgraded databases from 10g to 11g and created roles, profiles, users and assigned privileges to them.
• Involved in backup/recover strategy designing and implementation using cold backup, hot backup and RMAN methodologies.
• Configuring the databases parameters, creation, reorganization, extending table space, administer database security, create users, grant/revoke roles, privileges, extended databases storage capacity, performance and monitor, reduce DB fragmentation, manage data-files, rollback-segments, extents, rebuilding indexes.
• Provided partitioning of the large tables to reduce the access time.
• Applied patches.
• Optimization and performance tuning of database, SGA and SQL Net/Net8 related problems.
• Installing Oracle 8i on Win NT Server and Setting up Oracle Clients.
• User Creations with allocation to appropriate Tablespaces and quotas with necessary privileges and roles.

Environment:Oracle 10g/11g, SQL Plus, Oracle Enterprise Manager OEM Grid Control, TOAD, RMAN, RedHat Linux, HP-UX, Sun Solaris,Golden Gate.

Confidential

Sr. Oracle Database Administrator

Responsibilities:

• 24x7 on-call production database support.
• Primarily responsible for production support. To keep all databases up and running in production.
• Responsible for Oracle 9i/10g/11g logical and physical databases design, implementation and maintenance.
• Installation, Configuration and administration of 10g RAC/11g RAC environment.
• Upgraded Oracle 9i, 10g databases to 11g.
• Involved as a Apps DBA in handling Several Corporate Trainings on Oracle Upgrade and Implementations also exposed to projects involving Design Implementation of Oracle9i, Oracle10g with Oracle E-Business Suite.
• Performed extensive tuning / troubleshooting of databases for optimal performance. Tuning the application SQL / lock contention / index usage etc., Monitor object growth and modify segment storage for better performance.
• Applied patches.
• Developed strategies for optimal backup and restores procedures.
• Documented up gradation procedures from MySQL Server and Oracle to SQL Server.
• Managed and resolved design issues.
• Implemented RAC and Physical Standby databases for High availability and disaster recovery.
• Implemented and monitored RMAN backup scripts on regular basis for successful backup.
• Involved in DatabasePerformance tuning and analyzing Statspack/AWR reports on regular basis to resolve performance bottlenecks.
• Partitioned large tables, created global portioned indexes for manageability and performance improvement.
• Created primary database storage structures tablespaces , altering, and modifying the database structure according to the business requirement as necessary.
• Developing SQL, PL/SQL stored procedures, packages, functions, triggers and views.
• Created and managed users, roles and profiles, implementing security, granting roles and privileges etc.
• Planning and implementing Backup and Recovery procedures Conventional Cold Hot Backups, and RMAN Backups , scheduling daily backups and performed periodic recovery tests.
• Installation and configuration of Golden Gate.
• Replication using Streams and Golden Gate.
• Developed Unix Shell scripts to automate database cloning, backups and database monitoring.
• Performance monitoring and tuning using ExplainPlan, STATS PACK, AWR, ADDM, and Oracle Enterprise Manager.
• Helped developers to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC.

Environment:Oracle 9i/10g/11g, SQL Plus, Oracle Enterprise Manager OEM Grid Control, ERWIN, RMAN, RedHat Linux, HP-UX, Sun Solaris

Confidential

Sr. Oracle Database Administrator

Responsibilities:

• 24x7 on-call production database support.
• Provided primary administrative support for Oracle9i/10g/11g databases in LINUX/UNIX and NT environments.
• Installation, Configuration and administration of 10g/11g RAC environment.
• Created, upgraded, and cloned Oracle databases for Development and testing databases.
• Worked on Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.
• Performed backups and recoveries using RMAN conventional hot backups.
• Created and Maintained database stored procedures, database triggers, and user-defined functions.
• Performance monitoring and tuning using OEM Grid Control, SQL Trace, Explain Plan, STATS PACK, Automatic Workload Repository AWR Automatic Database Diagnostic Monitoring ADDM .
• Performed export imports using exp/imp, Data Pump.
• Performed Data loads using SQL Loader.
• Tuning Query performance by creating indexes.
• Monitoring, sizing and tuning undo segments by creating multiple undo tablespaces.
• Database Maintenance and clearing of deadlocks, cleaning of database logs, Re-indexing, Tablespace monitoring, database objects monitoring.
• Optimization of various initialization parameters, batch processes with Tkprof, SQL Trace and explain plan.
• Analyzing tablespaces and removing row-chaining and row migration in tablespaces.
• Designing and developing packages in the database layer, stored procedures, functions and triggers.
• Knowledge on Exadata working on smart scan processing and exadata patching.
• Installation and configuration of Golden Gate
• Applied latest patches as per evaluation requirement.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Estimating the space requirements for database growth for future making availability of hardware to support the processes.
• Developing, Implementing and administering database policies and procedures.
• Created users, roles and granted privileges according to the business requirements.
• Proactive monitoring of Oracle Database Applications, which include Space management, Standard services availability check, quickly identify and resolve database and application level errors.
• Assisted application development team with database design and support.

Environment: Oracle 9i/10g/11g, Red Hat Linux, IBM AIX, HP-UX, Sun Solaris, Windows 2000, OEM, SQL Plus, TOAD, RMAN, ASM.

Confidential

Oracle Database Administrator

Responsibilities:

• Provided 24x7 production database administration supports.
• Administered several databases including single instance and multi-node RAC instances.
• Upgraded databases from 9i to 10g.
• Performed extensive tuning / troubleshooting of databases for optimal performance. Tuning the application SQL / lock contention / index usage etc., Monitor object growth and modify segment storage for better performance.
• Wrote scripts to automate data loads, performance monitoring and backup.
• Database physical/logical layout design and procedures for production, development, test servers.
• Guided the Operations team in Creating, Cloning, and trouble shooting Oracle Databases, Database Objects Designs, and Partitioning, capacity planning of disk, table spaces, tables, backups and recovery.
• Helped the Production teams in Applications Performance Tuning and providing 24X7 Production Support.
• Performed capacity planning required creating and maintaining the database environments.
• Provided tuning support for SGA shared pool, buffer pool and log buffer pool etc .
• Managed archived redo files, DB-links Partitions, loading data for users by using SQL loader.
• Replication of materialized views snapshots with fast refreshes for transfers of information.
• Set up Cron jobs to monitor file systems usage, archive logs, backup logs and cleaning up of these file systems periodically, and also RMAN Hot Backup Scripts.
• SQL and PL/SQL Performance Tuning and Identifying SQL and PL/SQL bottlenecks using PL/SQL Profiler, Explain Plan, and Auto trace, TKPROF and tuned them to suit SLA.
• Gathered Database Instance Statistics generated reports using STATSPACK.
• Implemented Oracle New features like SPfile, Shared Severs, Locally managed Temporary Tablespace, UNDO Tablespace and RMAN.
• Created Partitions at O/S level, according to DB requirements.
• User Creations with allocation to appropriate tablespaces and quotas with necessary privileges and roles.

Environment: Oracle Server 9i/10g RAC, SQL, AIX 5.2, Shell scripting, PL/SQL, MS SQL Server.

Confidential

Oracle Database Administrator

Responsibilities:

• 24x7 Production Database Support
• Installation, Configuration and Administration of Oracle 8i/9i databases.
• Upgraded databases from 8i to 9i
• Created roles, profiles, users and assigned privileges to them.
• Analyzed STATSPACK reports for optimization of DB performance periodically.
• Created different types of Indexes B tree, reverse key, IOT and function based etc .
• Involved in backup/recover strategy designing and implementation using cold backup, hot backup and RMAN methodologies.
• Configuring the databases parameters, creation, reorganization, extending table space, administer database security, create users, grant/revoke roles, privileges, extended databases storage capacity, performance and monitor, reduce db fragmentation, manage data-files, rollback-segments, extents, rebuilding indexes.
• Provided partitioning of the large tables to reduce the access time.
• Applied patches.
• Detecting and diagnosing production system performance by analyzing oracle trace, log files, analyzing SQL statement, measuring system and database activity.

Environment: Oracle 9i, HP-UX, IBM AIX