PROFESSIONAL SUMMARY:

• Over Seven plus years of experience in full application life cycle development, testing and production in Information Technology - Software Industry
• Experience with Oracle 9i,10g,11g and 12c on Unix & Windows operating systems
• Oracle Certified DBA with experience in installation, configuration, tuning and troubleshooting
• Installation and Configuration of Oracle 12c Real Application Clusters (RAC) with Automatic Storage Management (ASM)
• Experience with RMAN, Oracle Enterprise Manager (OEM), OEM Grid control, Data warehousing, Oracle Data Guard
• Strong knowledge on GRID/CRS, OCR, VOTING, OLR, GPNPD, GLOBAL CACHE mechanism.
• Well versed with Database Administration, Cloning of Database, Backup and Recovery strategy using RMAN and User Managed
• Experience in using data pump import/export utility of ORACLE
• Experience in database migration by designing and implementing database logical and physical storage structures
• Experience on Oracle 11i applications with knowledge of CRM, EBS, HR and finance
• Experience in optimizing database access and allocates/re-allocates database resources for optimum configuration, database performance and cost
• Extensive experience in daily batch and report monitoring, space management, index rebuilds, statistics collection and other Oracle housekeeping tasks
• Extensive Knowledge about Oracle Golden Gate in implementing one way and bi-directional replication and experience in performing disaster recovery exercises.
• Developed database support processes and automated tasks through tools, PL/SQL and UNIX Shell Scripting. Oracle SQL*Net, SQL, PL/SQL, writing triggers, functions and PL/SQL procedures, Functions, creating Tables, Views and Indexes
• Experience with scripting skills like shell scripting, python and Windows Batch Scripts
• Expertise in data modeling and database designing and extensive knowledge of relational database concepts.
• Strong Oracle PL/SQL development background besides DBA skills
• Experience in database security strategies by creating database Implemented & monitored daily, weekly and monthly batch jobs in database
• Experience in backup/restore, disaster recovery using RMAN & OEM Grid Control
• Upgrading and Migrating Databases from lower versions to higher versions
• Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning, Refreshing test and development databases, Monitoring, Troubleshooting & Tuning
• Experience in analyzing database & rebuilding indexes to improve database performance
• Experience in Leading, Motivating and coordinating team of developers
• Applying oracle patches (CPU, PSU and ONE-OFF), upgradation and migration of databases using the OPatch utility and fixing bugs
• Experience with Oracle Streams to replicate or migrate data from system to another
• Performance Monitoring and Tuning of Database, Application, System Global Area, I/O, Rollback segments using self-developed scripts, Oracle Enterprise Manager, Spotlight on Oracle, Toad, Explain Plan, Tkprof Utilities, RDA, statspack, AWR, ADDM
• Supported 24/7 Production databases and responsible for round-the-clock database operations. Offering solutions for Production/Development of database applications
• Leadership skills and Goal Oriented, Good Co-ordination and Co-operation with the Team and Management. Adept at learning and adaptable to complex work environment

TECHNICAL SKILLS:

RDBMS: Oracle 9i/10g/11g/12c, SQL server 2005/2008/2012, MySQL

Operating Systems: HP-UX, Sun Solaris 2.5/2.8/5.9, IBM-AIX, Linux, Windows NT/ 2000/2003/2008

Oracle DB Tools: Toad, Export, SQL*Loader, Import, Data pump, SQL developer, Streams, AWR, ADDM, RMAN, OAM, OEM

Other Tools: AUTOSYS, Net meeting, VMware Server, VVM

Hardware/Storage: EMC Clarion with RAID5, Sun Sparc E15K/E4500/420, Sun-Fire v440/v890VERITAS Net Backup, Tivoli Storage Manager (TSM)

Data Modeling Tool: ERWin 8

Languages: C, C++, SQL, PL/SQL, Shell scripting, PERL scripting

Networking: Sql *Net, TCP/IP, FTP

PROFESSIONAL EXPERIENCE:

Confidential, Santa Fe, NM

Sr. Oracle DBA

Responsibilities:

• Installation, configuring, patching of Oracle Enterprise Edition ranging from Oracle 11gR2 and 12c on various platforms
• Installation, configuration and Maintenance of the Oracle 12c RAC databases on a four node Linux environment with replication using Golden gate.
• Upgraded the test and production database s from 11gR2 to 12c
• Re-configured Enterprise Manager Grid control for Oracle 12c Database to monitor Oracle Databases
• Worked closely with end Users and Business Analysts in determining database requirements, creating and developing new databases.
• Install and setup Golden Gate between Oracle and SQL Server databases for replication.
• Coordinated technical details and action plans with subordinates and vendors for RDBMS and Application-level maintenance procedures
• Configured and maintained Oracle 11gR2 databases in multi-tier environment.
• Applying CPU patches, Oracle patches, Release upgrades, Bug fixes
• Performing database/table re-org, index rebuild tasks and structural changes to the database
• Moved the Oracle databases over different Operating System platforms
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using OEM Grid Control, AWR, ADDM, STATSPACK, ESTIMATE, ANALYSE, INDEXES
• Proficient in SQL, PL/SQL, Query/application tuning using optimizer hints, Explain Plan, SQL Trace, DBMS STATS and Auto trace.
• Monitoring, following up & working with Oracle Support in resolving issues by SR’s.
• Supported Production databases on 24/7 on call rotation
• Created duplicate databases using RMAN duplicate for monthly development and QA database refreshes.
• Delivering SQL and Database performance tuning services via V$/GV$views, TKPROF, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), analyzing SQL trace dumps for 9i/10g/11g.
• Gathering database statistical information using STATSPACK, AWR, ADDM reports when the performance is both good and bad
• Experience with replication software’s such as Golden Gate especially in troubleshooting the replication issues.
• Patches and Maintain Oracle 11i Applications Environment.
• Performed clones of EBS instances and associated post clone activities.
• Database monitoring, Disaster recovery and backup using SQL Server technologies.
• Configured reports using SQL Server Reporting Services (SSRS).
• Monitoring SQL Server 2012 database, Performance tuning using SQL Profiler, and Index tuning.
• Configuration of Database Mirroring, Log Shipping and Replication in SQL server 2008 databases
• Created back up plans and test recovery scenarios in SQL Server
• Schema Refreshes using export/import and oracle Data pump Export (DPE) and Data Pump Import (DPI)
• Experienced in Capacity planning, capacity monitoring and management
• Databases refresh from production to UAT/DEV/Test environment for the Application/Project team using RMAN/logical backup
• Writing Shell Scripts for managing day-to-day activities, monitoring and automation of backup
• Designed and modified logical and physical data warehouse/data marts, data modeling using Dimensional Data Modeling configured for OLAP with Erwin data modeler
• Analyzed tables and indexes for Cost Based Optimizer (CBO) to work efficiently
• Involved in projects assigned and participate in Project meetings and kick-off meetings for go-live.

Environment: Oracle 12c RAC, ASM, Oracle 11g (11.2.02), SQL SERVER 2008/2012, PL/SQL, RMAN, Goldengate, OEM Grid Control, SSRS, SQL Plus, TOAD, ERWIN 8, Solaris, HP-UX, BMC Patrol, HP Service Guard

Confidential, CLEVELAND, OH

Sr. Oracle DBA

Responsibilities:

• Installation, configuration and Maintenance of Oracle 11gR2 RAC databases on a two node cluster with ASM
• Responsible for administration, supporting production and development of oracle 9i databases
• Installed the Grid Control Management agents on database servers to discover them in OEM Grid control
• Installation and configuring the physical standby databases using Active Data Guard at DR site for the operational recovery
• Monitoring SQL Server 2008 database, Performance tuning using SQL Profiler, Perform counters and Index tuning
• Develop, Implement and administer database policies and procedures
• Worked with Oracle Enterprise Manager, Net configuration assistant
• Monitored database performance using TKPROF, explain plan and sql trace
• Extensive use of CRONTAB in UNIX environment for scheduling routine tasks
• Managing tables and storage structures within a table
• Implementing and maintaining indexes, integrity constraints
• Managing passwords and resources using profiles
• Used Oracle backup utility RMAN to implement Oracle backup
• Implemented table partitioning and sub-partitioning to improve performance and data management
• Extensive knowledge on Oracle fundamentals, concepts, utilities and applications
• Experience with managing control files, redo log files, tablespaces, segments, extents and blocks
• Managing users, resources and privileges
• Monitoring of Oracle databases, automated error notification
• Ensure High Availability of database at all times and resolve all problems within targets
• Strong UNIX shell scripting abilities
• Data refresh from production to test and development, maintain Database Security
• Develop documentation to support the business and the support team
• Responsible for taking hot backups and logical backups at schema, tablespace and database level
• Performed Data load on different databases using SQL*Loader
• Used EXPORT/IMPORT to do table level and full database defragmentation
• Database capacity planning and performance tuning using AWR and other reports
• Logical and Physical Modeling using ERWIN Data Modeler
• Assisting the developers for the application performance tuning and verifying the TKPROF.
• Optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views, using HINTS, Explain Plan and STATSPACK etc.
• Extensively used Cursors and Ref Cursors in order to generate various reports.
• Requirement analysis and database design
• Helped developers to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC
• Developed future storage requirements for production database
• Tuning of SQL’s for the release changes using TOAD before implementing them into production

Environment: Oracle 11gR2 RAC, Oracle 10g, Data Guard, Linux, AIX, SQL Server 2008, SQL, PL/SQL, Shell Scripting, RMAN, DATA GUARD, TOAD, OEM, ERWIN, SQL * Loader

Confidential, F almouth, ME

Sr. Oracle DBA

Responsibilities:

• Installed, configured and maintained Oracle Databases and Clients
• Applied patches, keeping applications software bug free, and improving data integrity
• Experience in handling high availability databases.
• Consults and advises users on access to various databases
• Created user, roles and granted appropriate privileges
• Configured Enterprise Manager Grid control & DB control for Oracle 10g Database to monitor Oracle Databases
• Installed OEM Grid control agents in test and production environments
• Schema Refreshes using export/import and oracle Data pump Export (DPE) and Data Pump Import (DPI)
• Tuning the databases for optimal performance
• Implemented and configured Database Monitoring tools
• Configured Physical Standby database using Oracle DATAGUARD for Disaster recovery
• Databases refresh from production to UAT/DEV/Test environment for the Application/Project team using RMAN/logical backup
• Perform monitoring by scheduling the scripts in CRON and performance tuning
• Maintain user security on the database
• Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Provided Technical Guidance for database projects and configuring Oracle Clients on Workstations.
• Managing Schema Objects, Tablespaces, Datafiles, Space management, User Security
• Defragmentation of Databases which saved Lot of space for Future Application Growth.
• Co-Ordination with Application Developers on Database Issues, Including Index Design, Creation and alteration of Tables, Views, Indexes.

Environment: Oracle 10g (10.2.0.3/10.2.0.4 ), Oracle 9i (9.2.0.8), SQL, PL/SQL, RMAN, DATAPUMP, SQL Plus, Solaris, HP-UX, LINUX

Confidential, Columbus, OH

Oracle Database Administrator

Responsibilities:

• Installed and configured Oracle 10g, 9i
• Tablespaces and DataFile allocation and management
• Managing schema objects and rollback segments
• Database security such as establishing security policies
• Managing users and resources, controlling user privileges, roles and auditing database use
• Experienced in taking Hot, cold backups with and without RMAN
• Demonstrated benefits of using RMAN for backup and recovery
• Experience with Oracle RMAN and Veritas Net Backup
• Performed Logical backups at schema level using Export/Import and datapump
• Database instance tuning such as tuning memory allocation, tuning I/O, tuning contention, tuning related to sorts and free lists and check points
• Installation of Oracle 9i/8i software on various platforms like Red Hat Linux Adv
• Reorganized the database tables to improve report generation time
• Migrated databases from 9i to 10g using transportable tablespace from Solaris to RHEL 4
• Database monitoring using OEM. Application and database tuning using statspack, AWR
• Set trace session, get explain plan and run TKPROF on trace file to identify SQL problems
• Built Batch Scripts for automating the daily operations of database management.
• Improve application run time by building optimal indexes, gathering object statistics, analyze objects and using parallel query
• Database refreshes, environment configurations, and troubleshooting
• Performed several rollback to undo and dictionary to local extent management tablespace conversions
• Troubleshot database errors, warnings, and failed jobs to greatly reduce potential database downtime, and ensure database recoverability
• Supported different OLTP Databases like Production, Development, Testing, and Training
• Resolving database storage management issues
• Ran batch Scripts in Task Manager to invoke Hosts.
• Performing the logical and physical structures for tables, indexes, modeling, normalization and foreign key constraints
• Provided all kinds of DBA support to development teams as well as production support to various applications.

Environment: UNIX Sun OS 5.6/ HP UNIX 11.11, Windows NT 5.0/ 2000, Oracle9i, 10g, RMAN, OEM, Reflection, Toad, PeopleSoft 8.3, Veritas Netbackup, Dataguard, OLTP, Erwin and Designer 2000

Confidential

Jr. Oracle DBA

Responsibilities:

• Oracle Installation, patch application, migration of databases to newer releases of Oracle
• Monitored server disk space, database performance, replication, backups and scheduled tasks
• Production and Development support for an Oracle 8i database
• Created and managed an Oracle 8i database/instance and rollback segments
• Set up and administered table spaces, data files, tables, indexes, views and sequences
• Developed functions, procedures and packages using PL/SQL
• Configured and managed users, security and redo logs
• Moved all database from conventional backup to Oracle Recovery Manager (RMAN)
• Performed backup and recovery for both hot and cold backups without using RMAN
• Creating primary database objects such as tables, views, sequences, triggers, and indexes
• Daily monitoring and optimizing the performance of the database to ensure that database resource such as tablespaces, memory configuration, sessions, archive files, etc, are in their proper status
• Performing backup and recovery procedures to include exporting and importing of the database
• Performed full, tablespace and datafile recoveries with the database open and closed
• Creating user accounts and appropriate privileges as well as maintaining database security
• Enabled the Database in Archive Log Mode
• Performed backup jobs using batch scripts.
• Used Windows NT backup Program to perform backup jobs.
• Used Task Scheduler Service to schedule an automatic backup job.
• Modifying the database structure, as necessary, to support activities of application developers
• Created Database storage structures Data Tablespace, Index Tablespace
• Created/Altered/Modified database objects
• Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).
• Proactively managed the databases; set up alarms for managing any exceptions in day to day management of the databases; pre-empted and prevented issues disasters from happening.

Environment: Oracle 9i, SQL, PL/SQL, Win NT 4.0/Unix, Sun Solaris, PVCS, Toad