SUMMARY

• Around 12 years of experience as Database Administrator, providing 24X7 Production, test and development support 12c/11g/10g/9i/8i Oracle databases on different platforms like HP - UX, SUN SOLARIS, AIX, Redhat Linux and Windows.
• Around 2 year of experience as Microsoft Sql Server DBA on windows.
• Experience in installation, configuration and administration of Oracle Databases and SQL server Databases.
• Implementation of High Availability solutions with Oracle 11g/10g/9i RAC/ASM, Physical and Logical Standby Databases (Data Guard) and Replication using Oracle Streams and Oracle Goldengate.
• Strong experience in Patching and Cloning Oracle Applications on different platforms
• Involved in key roles and handled various discretionary projects, change requests, Root Cause Analysis and SOX Support.
• Excellent experience in cloning oracle databases for development and testing.
• Good experience in resolving teh issues related to installation, upgrades and patches.
• Involved in capacity planning and resource planning.
• Monitoring and ticketing tools like Foglight, OEM, Grid Control, Cloud Control, PPM, BMC Remedy and other third part tools like KINTANA (HPPPMC), Version Control System (PVCS) and Microsoft VSS
• Performed backups and tested crash recoveries using conventional hot & cold backups and RMAN, cloning databases using RMAN and VERITAS Netbackup.
• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Maintaining data integrity and tune database for optimum performance and availability.
• Proficient in analyzing and optimizing queries, performance tuning and providing reports using STATSPACK, TKPROF, and Explain Plan.
• Strong Knowledge on replication tools like snapshot, Shareplex, materialized views, Streaming and Goldengate.
• Knowledge in Datawarehousing concepts, dimensional starschema and Snowflake Schema methodologies, fact and dimension tables and Dimensional modeling, OLAP and OLTP process.
• A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges.
• Excellent communication skills, strong analytical, logical abilities in business analysis and technical documentation

TECHNICAL SKILLS

Operating Systems: Linux AS4.6, 5.8/6.2, Windows 2003/2008/2012 ServerSolaris 5.8/5.10/5.11, HP Itanium 11.23, AIX 5.3/6.1

Databases: Oracle 12c/11g/10g/9i/8i,10g/11g RAC, SQL Server 2005/2008

ERP: Oracle applications 11.5.10.2

Tools: Oracle’s OEM 12c,BMC Patrol,Foglight, Lightspeed,SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), Oracle Golden gate 11g, Informatica PowerCenter9.1/8.6,BusinessObjectsXIr2/6.x/5.x,ETL,PowerDesigner

Languages: SQL, PL/SQL, T-SQL, UNIX Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential

Lead/ Senior Oracle DBA

Responsibilities:

• Providing teh 24X7 production support (on-call rotation) and administration of Oracle 11g/10g RAC/Non-RAC.
• Actively worked on migrating various standalone databases to RAC configuration for high availability and scalability
• Installation, Upgrade and Configuration of Oracle (9i, 10g, 11g & 12c) standalone databases and RAC databases.
• Creation, Configuration and Setting up of RMAN Catalog databases and registering target databases with teh Catalog.
• Applied RDBMS patches related to security(PSU), performance and bug fixes on Test, Dev, Stage & Production instances.
• Monitoring teh operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like SAR, VMSTAT, ISOSTAT and TOP.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports.
• Worked on various DR setups using Oracle Standby and Active Dataguard technology on 11g RAC on ASM
• Actively worked on setting up and configuring OEM 11g and 12c and Upgraded teh OEM 11g to OEM 12c (12.1.0.3) and defined teh monitoring customized templates.
• Interaction with various stakeholders for timely delivery of different tasks
• Analyzing Database objects to improve Application sql performance on teh Database.
• Storage management, sizing teh database objects, monitoring file systems, and tablespace growth
• Installation of Golden Gate in one way replication, Performing Initial load, Online change synchronization, table replication from source to target. Creation of Manger process. and extract, replica process on source and target.
• Experience in using Automation Scheduling tools like Autosys and Control-MRefresh teh test and development databases from teh source production databases on a regular basis using export/import utility and Clone using RMAN.
• Involved in Performance Planning and Tuning, using baselines and proactive monitoring, bottleneck elimination and teh wait event interface to identify issues.
• Performed production database maintenance and modifications to ensure databases are operational, as well as diagnosed and corrected any database environment problems; monitored database usage, and reported on database performance and system availability.
• Worked with developers in teh development phase to diagnose database related application problems, provided development support to design, maintain schema for new application and distribution of data.
• Generated weekly performance reports to identify and solve teh problems with performance.
• Diagnosed Oracle bugs and coordinated with Oracle support through Metalink to resolve them in timely manner.
• Created shell scripts to extract data from various sources.
• Created new tablespaces, tables, indexes, synonyms, procedures, functions etc..
• Applied patches (DST, Patch sets and CPU patches) and worked closely with Oracle to make Application environment up to date.
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication.
• Extensive Performance Tuning, Memory (SGA) Tuning, etc.
• Responsible for data integrity, user security, daily monitoring for production and non-production systems. Used standard, value-based and FGA auditing.

Environment: s: Oracle 9i/10g/11g RAC on ASM, Oracle10g/11i AS, Red Hat Linux, AIX, UNIX and WINOWS, SQL Server 2012

Confidential

Senior Oracle DBA

Responsibilities:

• Provided regular production DBA support for around 1000+ databases Oracle and SQL Server .
• Manage and support Production Oracle 9i/10g and SQL Server 2000/2005 databases
• Installation of Oracle CRS and configuration of RAC setup on HP Itanium 11.23 with ASM raw devices.
• Convert teh Single Instances to RAC cluster databases in 10gR2
• Perform cross platform Migrations of large database systems with transportable database option in 10gR2.
• Configured High Availability with Dataguard with two nodes RAC.
• Setting High Availability technologies like Log Shipping, Database Mirroring in SQL Server 2005.
• Solving Disk space related issues and Log and database file full issues.
• Troubleshooting Log shipping, Database Mirroring issues.
• Applying teh CPU Patches and fix teh bugs.
• Managed high end databases in Data Warehouse Systems and OLTP databases and its applications.
• Maintaining 9i RAC and 10g RAC databases and Dataguard.
• Cloning databases using scripts as well as RMAN.
• Creating teh database, tables, tablespaces, data objects, setting privileges, indexes, user logins, password (security).
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Creating new databases, configuring backups and maintaining
• Taking Hot and Cold Backups, Logical backups (Export) on specified databases.
• Writing scripts for backup and recovery, Import and export procedure.
• Unix Shell scripting in csh, ksh (KORN) for automating startup/shutdown of databases, getting system alerts etc.
• Applying patches both Server side and Client side.
• Applied DST patches and security patches to Oracle Databases.
• Upgrading to Oracle Server 8i and then to 9i/10g.
• Migration of Oracle Databases from Linux to HP UNIX and HP UNIX to AIX.
• Deciding teh naming conventions of datafile, redo log files, tablespaces, and segments.
• Generating teh STATSPACK and ADDM reports.
• Did SQL tuning and Instance tuning.
• Creating new tablespaces, tables, indexes, synonyms, procedures, functions etc..
• Worked on Replicated databases
• Clone/refresh teh databases for users to generate reports.

Environment: Oracle 8i/9i/10g, Oracle 11i E-business Suite, HP UNIX 11, Red Hat Linux 3.0/4.0

Confidential

Senior Oracle DBA

Responsibilities:

• Provided 24 * 7 on-call Production support for Oracle 8, 8i, 9i and 10g
• Manage and support around 900 databases on 400+ servers.
• Installation and configuration of Oracle databases on LINUX/SOLARIS/UNIX platforms
• Participate in establishing and evolving database standards within teh company
• Involved in server consolidation.
• Maintaining teh RAC databases
• Troubleshooting, Helpdesk and identifying Bottlenecks on Oracle database 8, 8i, 9i and 10g
• Cloning Database using RMAN
• Maintaining standby/Dataguard databases
• Database Cloning
• Database Up gradation from old version to new versions.
• Done Memory tuning using utlbstat/utlestat, STATSPACK utility.
• Trace teh sessions.
• Did SQL tuning and Instance tuning.
• Creating new users on databases and giving permissions (grants/roles)
• Restore teh databases in critical situation.
• Checking teh backup’s status using DBVERIFY utility.
• Configure new standby databases as per client requirement.
• Export/import users and database and Transportable Tablespaces to refresh database.
• Defragmentation of database using export import.
• Removing row chaining for better performance.
• Writing scripts for backup and recovery, Import and export procedure.
• Unix Shell scripting in csh, ksh (Korn) for automating startup/shutdown of databases.

Environment: Oracle 8/8i/9i/10g, Solaris/Linux/Unix

Confidential

Oracle DBA

Responsibilities:

• Launch new project first time in India for push to talk mobiles.
• Install Oracle and create new databases as per client requirement.
• Import teh database dumps.
• Configure teh standby databases.
• Install and Configure teh RMAN.
• Write teh automate scripts to take teh backups.
• Write teh automate scripts to through teh oracle internal errors.
• Create teh new users to access teh databases and giving grants to users.
• Monitor teh database growth and estimating teh space.
• Create teh new tablespaces as per requirements.
• Alter teh storage structures.
• Create new tables, indexes, views as per requirements.
• Write stored procedures and functions.
• Analyze teh indexes and generation teh statspack reports.
• Part of core Production DBA team and Development databases
• Administering teh physical aspects of teh databases such as creation of Tablespaces, Users, Rollback segments
• Participate in establishing and evolving database standards within teh company
• Providing 24X7 support for production databases and working experience on on-call
• Maintaining user accounts, security management and auditing.
• Creating new tablespaces, tables, indexes, synonyms, procedures, functions etc..
• Assigning table space quotas and resource limits to users.
• Tuning of teh SQL queries using Explain Plan, SQL*Trace and TKPROF.
• Diagnosing system problems and taking corrective action. Heavily updated
• Apply teh patches to fix bugs.

Environment: Oracle 8i/9i, Solaris/Linux/AIX/Window 2000/Windows NT

Confidential

Oracle DBA

Responsibilities:

• Install Oracle and create new databases as per client requirement.
• Import teh database dumps.
• Configure teh standby databases.
• Install and Configure teh RMAN.
• Write teh automate scripts to take teh backups.
• Write teh automate scripts to through teh oracle internal errors.
• Create teh new users to access teh databases and giving grants to users.
• Monitor teh database growth and estimating teh space.
• Create teh new tablespaces as per requirements.
• Alter teh storage structures.
• Create new tables, indexes, views as per requirements.
• Write stored procedures and functions.
• Analyze teh indexes and generation teh statspack reports.
• Part of core Production DBA team and Development databases
• Administering teh physical aspects of teh databases such as creation of Tablespaces, Users, Rollback segments
• Participate in establishing and evolving database standards within teh company
• Providing 24X7 support for production databases and working experience on on-call
• Maintaining user accounts, security management and auditing.
• Creating new tablespaces, tables, indexes, synonyms, procedures, functions etc..
• Assigning table space quotas and resource limits to users.
• Tuning of teh SQL queries using Explain Plan, SQL*Trace and TKPROF.
• Diagnosing system problems and taking corrective action. Heavily updated
• Apply teh patches to fix bugs.

Environment: Oracle 8i/9i, Solaris/Linux/AIX/Window 2000/Windows NT