SUMMARY

• Expertise on VMware Workstation to install different Operating systems, Soft wares and Disk partitioning.
• Can Provide 24x7 Mail and On Call support to clients in DEV, QA and PROD Environments.
• Good knowledge in Client and Database Up gradation, Migration and CPU Patching.
• Worked extensively with configuring database backups in RMAN environments using TSM, Net App backup utilities.
• Expertise in implementing Kerberos External authentication for Oracle Databases.
• Expertise in implementing Oracle Golden Gate and Oracle Data guard.
• Database Performance Tuning using AWR, ADDM, Explain Plan, SQL TRACE, STATSPACK, TKPROF, SQLTXPLAIN and different OEM utilities.
• Logical Backup and Physical Backup schedules using Import/Export, Data pump and RMAN.
• Strong knowledge on scripting languages like UNIX Shell Scripting, Perl Scripting and Windows Power Shell.
• Knowledge on PeopleSoft Applications for Payroll and HCM domains.
• Performing Backups, Cloning and Refresh with Delphix for Oracle Databases.
• Configuring and Scheduling mail alerts using SQL Server Agent.
• Having knowledge in Configuring High Availability like Log shipping, Mirroring and Replication in SQL Server.
• SQL Server Log Reviews Windows Event Logs, SQL Server Error Logs and Agent Logs .
• Analyzing the performance using SQL Server Profiler and Monitoring using Activity Monitor, System Monitor.
• Creating Backups, Restoration and Replication on Microsoft SQL Server 2005, 2008, 2008 R2, 2012 using SQL Server Agent and LiteSpeed for SQL Server.
• Having good knowledge on Microsoft SQL Server 2005, 2008, 2008 R2, 2012 Installation, Administration and Maintenance of SQL Server Instances.
• Experience with different databases like Oracle 8i, 9i, 10g, 11g, 12c and PostgreSQL in multiple OS environments like Windows, UNIX, Linux, AIX, Oracle Solaris and VMware Environments.
• Having experience in configuring OEM Grid 10g, 11g and 12c Cloud.
• Having experience in RAC Cluster Ware installation and Network Configuring and Disk management with ASM.
• Expertise in Database Cloning, Database Refreshing and Standby Databases.
• Expertise in Backup and Recovery for HA/DR Scenarios in Oracle and SQL Server.
• Configuring back up schedules for Development, QA and Production Databases.
• Over 9 years' experience in the Information Technology field, with comprehensive hands-on expertise as an Oracle DBA in Installation, Administration, Monitoring, Support, Database Backup and Recovery and 5 years of experience as a SQL DBA in Installation, Administration, Monitoring, Support, Database Backup and Recovery. Repeatedly demonstrates the ability to apply technical skills for the achievement of tactical and strategic business solutions, and also leverages managerial and interpersonal skills to motivate, direct and inspire project teams. With experience in different domains like BFSI, Oil Gas Utility , Logistics, SCM, HCM, Payroll and Manufacturing domains across a wide variety of systems and companies from small to Very Large.
• Good knowledge in DW, HCM, SCM and Manufacturing Environments.
• Knowledge on Oracle Support processes for technical requests with Metalink and Creating Service Request SR .

TECHNICAL EXPERTISE

PROFESSIONAL EXPERIENCE

Confidential

Role : Senior Oracle MS SQL Developer

Responsibilities:

• Oracle 11gR2 Real Application Cluster OEM Grid Implementation and Production support.
• Maintaining and supporting 2-node RAC.
• Upgrading the databases from 11gR1 to 11gR2.
• PL/SQL coding to automate the schedule jobs using shell scripts.
• SQL Server Backups, Restoration, User Management and Memory Management.
• Configuring SQL Server Log shipping and mirroring for all Production databases.
• Monitoring and Performance tuning at Physical Server Level, Database level Database settings and options and query tuning.
• Creating and maintaining Indexes, performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc.
• Scheduling the oracle backup and export jobs using CA Automation Tool.
• RMAN Backup and Recovery, DB Performance Tuning instance level.
• Management of Development, QA environment for new development requirement.
• Performing Cloning and Refresh databases with Delphix.
• Configuring Golden Gate unidirectional Replication.
• Create Users and assign permissions based on the level of database access the user would need.
• Create Linked Servers to SQL Servers and other databases such as Oracle, Access, and Informix etc.
• Maintaining database Security, Monitoring and admin using Oracle Enterprise Manager Grid Control.

Environment: Oracle 11gR1, 11gR2, 10g, MS SQL 2005/2008/2008R2/2012, Linux, AIX, Windows Server 2003/2008/2012, Oracle Golden Gate

Confidential

Role : Senior Oracle DBA

Responsibilities:

• Oracle 11g Real Application Cluster Grid Implementation and Production support.
• Maintaining and supporting 7-node RAC.
• Configuring Golden Gate unidirectional Replication.
• Gathering schema level statistics using DBMS package in Oracle.
• RMAN Backup and Recovery, DB Performance Tuning instance level.
• Management of Development, QA environment for new development requirement.
• Data migration to other database as per requirement for new systems.
• Standby database Maintenance and Configuration data guard.
• Applying Quarterly CPU PSU Patching.
• Performing Cloning and Refresh databases with Delphix.
• Taking database backups and recovery using RMAN.
• Design database Backup and Restoration Strategy using SQL Server Agent.
• Once created the database Backups, monitor those backups are being performed regularly using SQL Server Agent.
• Maintaining database Security, Monitoring and admin using Oracle Enterprise Manager Grid Control.

Environment: Oracle 11g, 10g, RAC, Golden Gate, MS SQL 2005/2008/2008R2/2012, Linux, Windows Server 2003/2008/2012

Confidential

Role : Oracle DBA

Responsibilities:

• Physical database design, Table, Column mapping with existing requirement.
• Creating/Dropping Database, Users, Table spaces, Tables Database Objects.
• Oracle 10g Real Application Cluster Implementation and Production support.
• Stats Gather at Database, Schema, Table and Index level.
• Query Tuning using ADDM, AWR and Stats pack Reports.
• Applying quarterly CPU patch to all Databases.
• RMAN Backup and Recovery, DB Performance Tuning instance level.
• Data migration to other database as per requirement for new systems.
• Standby database Maintenance and Configuration data guard.
• Monthly range partitioning of tables.
• Creating/Resizing of Tablespaces, Tables, and Users for custom applications.
• Maintaining database Security, Monitoring and admin using Oracle Enterprise Manager Grid Control.
• Monitoring Table space size and file system size alerts using UPTIME tool.
• Cold/Hot Refresh/Cloning QA, DEV databases from Production environment for testing purpose.
• Weekend on call support, Payroll support and bundle upgrade support for PeopleSoft applications.

Environment: Oracle 11g, 10g, Solaris, Windows.

Confidential

Role: Oracle DBA SQL Server DBA

Responsibilities:

• Building and Monitoring Disaster Recovery DR database from Production.
• Monitoring Blocked and Inactive database sessions and take proper action.
• Query Tuning using ADDM, AWR and Stats pack Reports.
• RMAN Backup and Recovery, DB Performance Tuning instance level.
• Creating/Dropping Database, Users, Table spaces, Tables Database Objects.
• Oracle 10g Real Application Cluster Implementation and Production support.
• Stats Gather at Database, Schema, Table and Index level.
• Analyzing the ADDM, Stats Pack reports and Explain plan output.
• SQL Server Backups, Restoration, User Management and Memory Management.
• Configuring SQL Server Log shipping and mirroring for all Production databases.
• Monitoring and Performance tuning at Physical Server Level, Database level Database settings and options and query tuning.
• Creating and maintaining Indexes, performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc
• Maintaining database Security, Monitoring and admin using Oracle Enterprise Manager Grid Control.
• Monitoring Table space size and file system size alerts using UPTIME tool.
• Cold/Hot Refresh/Cloning QA, DEV databases from Production environment for testing purpose.
• Standby Databases using Data guard when needed.
• Verifying corrupted data blocks using DBVERIFY Utility and recovers corrupted blocks using backup.
• Write UNIX shell scripts to monitor and maintain the Oracle database.

Environment: Oracle 10g, 9i, MS SQL Server 2005, Linux, Windows Server 2003

Confidential

Role: Oracle DBA

Responsibilities:

• Created new Databases, Users and Table spaces.
• Developed database Tables, Views and Indexes using primary keys and foreign keys.
• Database backups and recovery using RMAN.
• Data transfer from External files to Database using SQL Loader.
• Created Database templates using Oracle DBCA.
• Monitoring and Managing database backups and when needed restoring big loads to databases.
• Prepared Database level and table level backups in PostgreSQL.
• Troubleshooting previously written PL/SQL packages and procedures.
• Created database Triggers, Stored Procedures and Functions for the validation of input data and implementing business rules.
• Monitored database performance using Toad and Oracle Enterprise Manager.
• Write UNIX shell scripts to monitor and maintain the Oracle database.
• Responsible for Reports Generation and submitting to the Client.
• Refresh/Cloning of Database for Development and QA.
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries performance, hit ratios, I/O, lock, and latch contention.
• Assist Programmers and Developers with Oracle problems.

Environment: Oracle 9i, 8i, PostgreSQL, Linux.