SUMMARY

• 7+ years of experience in installation, configuration, administration, migration, tuning, patching & upgrades and troubleshooting of Oracle databases 8i/9i/10g/11g in UNIX and Windows operating systems
• Well experienced in oracle data warehousing, performed oracle data integration,partitioning large tables
• Experience in Oracle Warehouse Builder (OWB)11gR2, alongside with Oracle Database 10gR2 and 11gR1 and ETL
• Managed multi terabyte data warehouse with RAID infrastructure
• Experience in Open Database Connectivity, ODBC - JDBC Gateway.
• Knowledge of management information system(MIS), Student and Applicant Management Information System (SAMIS).
• Performed monitoring Streams replication environment.
• Performed cloning an oracle database using rman duplicate, NetBackup 6.5 Backup Planning and Performance Tuning, Transportable Tablespaces (TTS).
• Implemented Oracle 11g/10g/9i Real Application Clusters (RAC), Oracle Automatic Storage Management (ASM), VERITAS Volume Manager Administration, Cluster Interconnects, Load balancing and designing failover systems on UNIX platforms.
• Configured Physical standby database using Oracle Data Guard for disaster recovery.
• Strong Knowledge of 10g advanced features like ASM, AWR, ADDM, FLASHBACK, DBMS SCHEDULER, ASSM, AMM, ORADEBUG, SQL Profiling.
• Setup Oracle Enterprise Manager (OEM) 9i/(Grid Control) 10g for database monitoring/performance/diagnostics
• Oracle Streams and Advanced Replication Configured Capture, Staging areas in Streams, Applied the Changes to the Target Database. Configuring, maintaining replication at table level (Unidirectional, Bi-directional).
• Experience in using and maintaining of Materialized Views
• Performed TSPITR, duplicating database-using RMAN. Involved in Disaster Recovery Planning (DRP).
• Experience on creation and implementation of Backup and Recovery methods and disaster recovery methods using RMAN, logical, hot backups, and Flashback Recovery and Block Media Recovery methods.
• Applying Patch set, Patches, Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches using OPatch and runInstaller under UNIX and Windows.
• Expertise in Database upgrading and migration of Oracle server (9i, 10g, 11g).
• Data transferring and backup using exports/imports, Data pump and RMAN. Data loading using SQL*Loader
• Performance Tuning: Tuned various large critical OLAP and OLTP databases of Tera bytes size using various tools like STATSPACK, AWR, ADDM, ASH, Tkprofand Explain Plan Methods.
• Database Tuning - Tuning Applications, Tuning Memory, and Tuning Disk Usage
• Developed Shell scripts for day-to-day database administration tasks that include various Cron jobs for alert logs and performance, Backups, Restores and Recoverability..
• Provided 24 x 7 support and flexible to work Confidential regular hours.
• Downsizing and defragmenting the Very Large Databases (VLDB) by export / import.
• Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers etc
• Experience in ORACLE Database administration including Partitioning large tables, capacity planning, space management, Rollback segments and Undo segments, User Management, Password Management.
• Experience in Database Security and Auditing.
• Resolved database network problems using Oracle Net Configuration Assistant, Oracle Net Manager, Netstat and ping utility.
• Create and maintain databases to Oracle Optimal Flexible Architecture (OFA) standards.
• Oracle Support Services are utilized for troubleshooting and database issues by creating Service Requests.
• Capable of working in a Team/independently with ability to lead a DBA team with project management, technical, presentation, communication and time management skills.

TECHNICAL SKILLS

Operating Systems: Sun Solaris, HP-UX, AIX, Red Hat Linux, Windows NT/2000/2008:

RDBMS: Oracle 11g/10g/9i/8i, SQL server 2008,2005,2000:

Tools: RMAN,OWB, Oracle Management Server, SQL * Loader, SQL Server, Export/Import, Data pump, OEM, oracle Streams:

Other Tools: AUTOSYS, SSAS, SSRS, SSIS, VNB, TOAD, VVM, BMC Patrol, Erwin, TSM, Legato Net Worker, HPDP, WinSCP, AWR, ADDM,SQL Trace, TKPROF.:

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

Protocols: TCP/IP, HTTP, LDAP, SFTP:

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr. Oracle DBA

Responsibilities:

• Migration of Oracle DB from 10g to 11g R2.
• Configuration and maintaining ODS database, setting up the scripts to refresh three time a day .
• Configuration, maintenance and tuning of Oracle 11g/10g .
• Determined all the ports configuration and firewall settings among all the servers.
• Administration and maintain student Information including Banner 8.3 and Student portal.
• Continuously working with server team and helping them in the patching process.
• Responsible for maintaining ORACLE 11.2.0.3 using SRVCTL, OEM, maintaining Oracle Clusterware using CRSCTL
• Responsible for setting up Oracle Streams to help in propagating information within and between databases
• Maintaining all the oracle Applications Running on application servers .
• Implemented backup/recovery procedures using RMAN, Data Pump, and performed database recoveries.
• Performed daily maintenance tasks like space management, managed quotas etc., and configured network components like TNSNAMES, Names Server etc. For easy and effective management of Oracle networking. Configured listener for external procedure calls.
• Writing and modifying shell scripts, Perl scripts to manage Oracle environments and for Backend Oracle Processes.
• Used to do HOT backup every day and COLD backup once in two weeks on the application database techniques using RMAN and conducted disaster recovery drills
• Day to day performance monitoring and tuning of database using OEM 12c cloud control
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Involved in 24x7 production database maintenance and on-call support.

Environment: Oracle 10g/11g, Red Hat Linux 5, Oracle Streams,OEM GC, Data Pump, RMAN, SQL SERVER 2008, AWR, Shell scripting, ADDM, WinSCP, Putty,VERITAS Net backup, Perl scripting, Data guard, Stored Procedures, Grid Control, OWB.

Confidential, Charlotte, NC

Sr. Oracle DBA

Responsibilities:

• Oracle Clusterware installed to provide infrastructure for RAC and configured 3 node Oracle 10g/11g RAC with ASM.
• Oracle Warehouse Builder Documentation(OWB), data quality, data auditing, fully integrated relational and dimensional modeling.
• Consolidating data from disparate data sources,Designing and managing corporate metadata.
• Configuration, maintenance and tuning of Oracle 11g/10g/9i RAC.
• Performed various tasks like administering RAC using SRVCTL, adding nodes and instances, administering storage components, parameter management, configuring high availability features for RAC.
• Immurement Oracle Streams on database level and table level.
• Upgrading development and production databases to Oracle 10g.
• Applied Security patches and Patch set on Oracle Databases.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.
• Extensively worked with ASMCMD for managing ASM environment.
• Implemented flashback technology.
• Installation and Implementation of Oracle Data Vault on 10g. This helped to maintain the security feature in well-controlled manner and as of single point with role.
• Performed Cross platform migration using transportable tablespaces and RMAN.
• Extensively used AWR, ADDM, TKPROF, and SQL Trace for database performance statistics.
• Creating and managing users, roles and profiles, implementing security, assigning tablespaces to the users, granting roles and privileges etc.
• Tuning Query performance by creating indexes
• Used and maintained Bitmap indexes, materialized views.
• Written scripts to automate the synchronization process between local and remote databases.
• Responsible for network configuration and involved in a Client - Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
• Troubleshoot user related and database related issues using Oracle Support Services.
• 24x7 production support DBA working on a primary/ secondary pager rotation; and supported on holidays, weekends and Confidential regular hours.

Environment: Oracle 9i/10g/11g, Sun Solaris, Red Hat Linux, AIX, OEM GC, ASM, RMAN, SQL SERVER 2008,STATSPACK, AWR, ADDM, VERITAS Net backup, TOAD, Perl scripting, Shell scripting, SQL*Loader, Data guard, Stored Procedures, Data Vault, Grid Control, SFTP.

Confidential, Detroit, MI

Sr. Oracle DBA

Responsibilities:

• Installation, configuration and administration of oracle 10g/11gR1/11gR2.
• Installation, configuration and maintenance of Oracle 10g/11g RAC.
• Performed data management with OWB.
• Setup and configured Oracle 9i/10g/11g Physical Standby database (DataGuard) to ensure high availability, where the standby database was used for disaster recovery as well as to offload the running of huge reports.
• Upgrade and Migration of Database from 10.2.0.2 to 11.2.0.2 and applying patches whenever required.
• Configured ASM instance for simple storage management and migrated several instances from Non-ASM to ASM
• Implemented Flashback Recovery for Oracle 11g Databases to help recover data in many systems.
• Performed Logical backup of critical application databases using EXPDP/IMPDP with a scheduled jobs (Cron Job).
• Developed Backup and Recovery strategy and Maintained User managed backup and RMAN.
• Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using Basic Replication using materialized views.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF Reports, Explain Plan (10046),Statspack, AWR, ADDM, ASH and monitor the database performance on daily basis.
• Configured and Implemented replication oracle streams at table level.
• Implemented Partitioned Tables for regional data in centralized data warehouse for better performance.
• Performed database cloning to setup test and development database.
• Backup to virtual tape using VERITAS Net Backup, HPDP and shared storage Option.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Provided support to Application Database Administrators in designing the database.
• Implement Stored Procedures and Triggers based on business plans using PL/SQL.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Performing general administration tasks using tools like OEM GC and Toad.
• Configuring TNSNAMES.ORA, LISTNER.ORA for SQL *NET connectivity.
• Troubleshooting errors that occurs one daily basis and resolving problems quickly and efficiently and giving suggestions to developers when they are required for tuning the code to maximize performance of the database.
• On-call support regarding production - related database problems is performed.

Environment: Oracle 9i/10g/11g, Red Hat Linux 5.5, Sun Solaris,AIX, HP-UX, OEM GC, TOAD, RAC, RMAN, VERITAS, Explain Plan(10046), STATSPACK, AWR, ADDM, TKPROF, Oracle Replication, Data Guard, PL/SQL, SQL*Loader,SQL SERVER, HPDP, SFTP.

Confidential, New York, NY

Sr. Oracle DBA

Responsibilities:

• Primarily responsible for production support. To keep all databases up and running in production.
• Data quality, data auditing with OWB
• Upgrading Oracle database 9i to Oracle10G
• Configured and maintaining Data Guard (Physical Standby database) for the production database and tested for switchover, failover, activating the standby to primary and zero data loss.
• Migration of database from 9.2.0.1 to 10.2.0.1.
• Performing database analysis, design, coding, testing and implementing database structures.
• Cross platform migration using export / import from windows to Linux
• Benchmarking Database performance by using OEM and STATSPACK for identifying performance bottlenecks and taking appropriate action.
• Trouble shooting performance issues using Explain Plan and TKPROF and well versed with STATSPACK.
• Implemented ORACLE STREAMS, and two types of standby databases supported by Data Guard, logical standby and physical standby databases.
• Modified existing database structures layout such as disk configuration and storage allocation to enhance application performance.
• Maintained day-to-day production support thereafter, check alerts log, activity logs, error logs, RMAN log to capture any possible errors to ensure the databases health.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis.
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues. Basic OS system administrates.
• SQL and PL/SQL Performance Tuning and Identifying SQL and PL/SQL bottlenecks using PL/SQL Profiler (package DBMS PROFILER), Explain Plan, Auto trace, TKPROF and tuned them to suit SLA
• Developed Shell scripts to regularly maintain partitions and PERL Scripts for automated jobs.
• Involved in database design using Erwin and Relational/OLTP Modeling.
• Using TOAD to do database design and monitoring the databases.
• Able to work effectively with multiple teams at once. Able to thrive in a fast-paced, time compressed and dynamic environment. Solid skills and discipline for Change Management practices processes
• Provided 24X7 Support for all the production and development databases.

Environment: Oracle 8i/9i/10g/11g, Sun Solaris, Red Hat Linux, Windows, OEM GC, Oracle Partitioning, ASM, imp/exp, RMAN, ORACLE STREAMS, Hot Standby, SQL Server 2000, TOAD,ERWin, STATSPACK, AWR, ADDM, ASH, TKPROF, EXPLAIN PLAN, SQL TRACE

Confidential

Oracle DBA

Responsibilities:

• Installation, Configuration and Administration of Oracle 9i/10g.
• Database upgrades from 8i to 9i and 9i to 10g.
• Installed, configured and maintained Oracle RAC.
• Developed the scripts to load log data to database, and process the data to hourly and daily tables by using stored procedure.
• Structured and maintained database. Monitored database space usage and system sizing. Analyzed oracle database performance. Troubleshoot and supported data system.
• Planning and implementing Backup strategy for the databases using VERITAS Netbackup, RMAN, Scripting backup.
• Data transferring with export/import utilities and Data Pump.
• Monitoring and maintenance of multiple databases for production, development, testing and staging purposes using utilities like OEM and Toad.
• Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.
• Utilized TKPROF to read the execution plan.
• Tuning the database performance through STATSPACK/AWR/ADDM report.
• Used to Interact with Business Analysts to understand the business requirements and also worked with Java developers to develop procedures, package and functions.
• Implemented standby database and database replication to realize database high availability. Created partitions for large table to improve performance.
• Modified existing database structures layout such as disk configuration and storage allocation to enhance application performance.
• Logical and Physical data modeling using ERWintool.
• Optimization of various initialization parameters, batch processes with Tkprof, SQL Trace and explain plan.
• Involved in 24x7 production database maintenance and on-call support.
• Experienced in several programming languages including Shell scripting, SQL and PL/SQL in support of DBA activities such as scripting for scheduled jobs, created stored procedures and triggers and integrated front-end web pages with back-end database engines.

Environment: Oracle 9i/10g, Red Hat Linux, Windows, Oracle Advance Replication, TOAD, OEM GC, SQL*Loader, Shell Scripts, PERL Scripts, ERWin, STATSPACK, AWR, ADDM, ASH, SQL TRACE, UTLBSTAT.

Confidential

Oracle Developer/DBA

Responsibilities:

• Installation and maintained of Oracle 9i on UNIX systems and maintenance on Oracle 8i.
• Responsible for administering and supporting production and development Oracle 9i Database.
• Responsible for installing, upgrade and configuring the Oracle Server, Creating Databases, Storage Structures and Objects, Database Backup and Recovery.
• Loaded data into Database using the SQL Loader, Export, UNIX shell script Batch File and manages system Events and Jobs using OEM.
• Developed various PL/SQL Stored Procedures, Functions and Packages.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Taking Backups on scheduled time and monitoring scheduled backups using RMAN.
• Creating and dropping of users, granting and revoking rights as and when required.
• Performed general technical trouble shooting and gave consultation to development teams.
• Tested database performance and tuned database based on database performance ratios.
• Managed large tables using index and table partitions.
• Database troubleshooting and on-call supporting after regular hours.

Environment: Oracle 8i/9i, UNIX, Linux, RMAN, DBCA, Data Guard, OEM, TKPROF, EXPLAIN PLAN