Objective

• An accomplished Database Administrator having around 12+ years of Experience and RAC with demonstrated success designing and implementing database solution that improve business functionality.
• Possess diversified technical background with Enterprise System Solution. Proven ability to implement technologies that decrease costs, increase performance and positively affect the bottom line.

SUMMARY

• Around 12+ years of experience in IT and presently working as Oracle DBA on Unix / Linux / Windows platform.
• Ability to motivate teams to increase productivity.
• Expertise in High Availability Solution like Oracle Real Application Clusters (RAC)and Oracle Dataguard
• Expertise in UNIX/LINUX Administration
• Expertise in setting up Datacenters
• 10+ years of Expertise in High Availability Solutions including Oracle Real Application Clusters (RAC), Oracle Dataguard, SUN Clusters and VERITAS Clusters.
• 4+ years of experience in UNIX/LINUX Administration
• Experience in verticals including Banking, Financial and Insurance.
• Team leader for projects across different contracts and industries.
• Experience in MS SQL Server, Postgres and Mysql
• Expertise in Installations / Patching / Cloning / Troubleshooting of Database's both Single Instance and RAC.
• Disaster recovery planning, testing and implementation.
• High Availability database implementations utilizing Oracle Data Guard, and Active/Passive configurations
• Oracle RMAN backup and recovery, cloning, migration and upgrade of systems
• Oracle GRID/Enterprise Manager installation and implementation
• Implementation of Glodengate replication and troubleshooting.
• Expertise in setting up Datacenters, Hardening and Service Activation and Deactivation SAND of Servers.
• Database security hardening using Security Technical Implementation Guides (STIG)
• Custom PL/SQL stored procedure programming, debugging and tuning
• Data architecture planning and implementation, relational database design
• Performance tuning using Oracle utilities such as ADDM, ASH and AWR
• Experienced in Capacity planning / Benchmarking for Oracle Products.
• Deep understanding of technology with focus on delivering business solutions.
• Posse Strong Communication skills and Analytical Skills that consistently resolves ongoing issues or defects.
• Ability to learn and adapt to new Technologies quickly.
• Experienced in project management and team leadership.
• Prove ability in providing internal Trainings and Career Development programs

TECHNICAL SKILLS

Operating Systems: AIX 5L, SUN Solaris 8/9/10, Windows 2003, Redhat RHEL 4/5/6Hardware SUN SPARC E450/V440, ULTRA SPARC 10, HP Intel XENONHP AMD DL - 385, HP SAN Storage, IBM eServer p5 series

Database: Oracle 9i, 10g, 11g,12c, MS SQL Server 2008/2012 SAP HANA, Postgres and MySQL

Cluster ware: Oracle RAC, VERITAS Clusters, SUN Clusters

Virtualization Tools: VMware ESX/ESXi, vCenter

Programming: JAVA, C, Knowledge in Python, SQL, UNIX / LINUX Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Senior Oracle DBA

Responsibilities:

• 24x7 Production support for, 000+ databases including Oracle and MS SQL Server, Postgres and Sybase
• Team Lead and Database consultant at Confidential Bank.
• Patching, Cloning, Installing and Upgrading databases
• Troubleshooting Single Instance and RAC Databases, Dataguard, MS SQL Server and Postgres databases
• Upgraded databases from 11g to 12c.
• Maintain and Troubleshooting Glodengate replication servers.
• Restoration and Recovery of databases at the times of occurrence of critical failures of both Oracle and MS SQL Servers.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Created and reorganizing Table Partitions, Materialized Views, Indexes, Parallel Execution
• Partitioned large tables for better performance and manageability.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Work closely and communicate with IT Management team.
• Engage a wide cross section of internal and external stakeholders - development, support, Oracle consulting services, and third party partners
• Experience with Oracle high availability technology including Data Guard and RAC; Oracle setup, configuration and patching, Oracle Performance management including Instance tuning and Application Tuning
• Database monitoring using tools such as OEM Grid Control, SQL Management Studio
• Enforce adherence to IT Processes including SDLC, Change management, and other fundamental processes.
• Work with Development team on designing standardized data models, and standard and optimal PL/SQL code.
• Oversee the Development and implementation of Database security policies and procedures, in line with corporate objectives

Confidential, Fortworth, TX

Senior Oracle DBA

Responsibilities:

• Was team lead at Dailmler responsible to Maintain 5000+ Production Databases including both Oracle and SQL Servers.
• Performance Tuning of both Oracle and SQL Sever databases.
• Patching, Cloning, Installing and Upgrading databases
• Troubleshooting Single Instance and RAC Databases, Dataguard and MS SQL Server Databases
• Growth projections and Capacity planning both Oracle and MS SQL Servers databases
• 24x7 Production database and applications support.
• Upgraded databases from Oracle 9i to 10g and 10g to 11g.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Created and reorganizing Table Partitions, Materialized Views, Indexes, Parallel Execution
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Partitioned large tables for better performance and manageability.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Written PL/SQL Stored Procedures, Packages, Functions and Triggers using TOAD.
• Worked with Data Pump to take the logical backups of databases.
• Experienced in performing Point-in-Time Recovery(PITR).
• Load and Transform data using SQL*Loader and External Tables
• Logical and Physical Database Design
• Wrote Knowledge Based Articles

Confidential, Kentucky

Senior Oracle DBA

Responsibilities:

• Team lead for a team of 20 DBA’s
• Responsible to maintain Confidential custromer databases ranging from Production Databases including Oracle and MS SQL Server
• Performance Tuning of RAC and Single Instance Databases.
• Patching, Cloning, Installing and Upgrading databases
• Provide 24/7 Support for Oracle and MS SQL Server databases
• Troubleshooting Single Instance and RAC Databases, Dataguard.
• Growth projections and Capacity planning.
• 24x7 Production database support for both Oracle and MS SQL Servers.
• Upgraded databases from Oracle 10g to 11g.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Created and reorganizing Table Partitions, Materialized Views, Indexes, Parallel Execution
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Partitioned large tables for better performance and manageability.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Written PL/SQL Stored Procedures, Packages, Functions and Triggers using TOAD.
• Worked with Data Pump to take the logical backups of databases.
• Experienced in performing Point-in-Time Recovery(PITR).
• Load and Transform data using SQL*Loader and External Tables
• Logical and Physical Database Design
• Wrote Knowledge Based Articles

Confidential

Senior Oracle DBA

Responsibilities:

• Installing & configuring 2-Node Oracle 10g RAC for New York Life Insurance on AIX p5 Servers.
• Provided 24/7/365 On call Support for Database and System Admin issues.
• Team member of Project Development and Deployment team.
• Apply Patches and Upgrading Oracle RAC and Single Instance Databases.
• Performance Tuning of RAC databases.
• Configuring RMAN for LTO Tapes through Tivoli Storage Manager.
• Wrote RMAN scripts for Backups.
• Configuring and Troubleshooting Oracle Cluster / Dataguard (Standby) problems.
• Follow the Process as per the standards Patch Management, Change management.
• Interacting with Development team, Architects and System Admins and for solving problems and Deployement.
• Integrating of Applications like Websphere with RAC Databases.

Confidential

Oracle DBA

Responsibilities:

• Installing and Configuring Oracle 10g RAC on Redhat RHEL with ASM.
• Responsible for maintaining 130+ Oracle RAC databases for India Railways.
• Performance monitoring and Tuning using Enterprise Manager.
• Configuring and Managing Backups Using RMAN.
• Configuring TAF and Load Balancing for High Availability and Performance.
• Troubleshooting Clusterware and Database/ Standby(Dataguard) issues.
• Integrating Applications with Databases.
• Provided 24/7 On-Call support for database issues.
• Included in Product Development and Deployment.
• Provided Application support at Database level
• Wrote PL/SQL scripts, Created Database Procedures and Functions

Confidential

Oracle Database Administrator

Responsibilities:

• Involved in Product Development and Deployment team.
• Installed SUN Solaris and Configured Veritas and SUN Clusters for Oracle Databases.
• Creating Filesystems and Configuring NFS and file sharing for Oracle servers.
• Wrote PL/SQL code, Created Database Procedures and Functions.
• Design Database Objects and Schemas.
• Maintenance of Oracle Databases running on Sun Solaris and Windows platforms using Oracle 9i through 10g.
• Installing and configuring production databases leveraging the high-end Oracle RAC architecture on SUN Clusters to offer unmatched deployment flexibility and massive scalability.
• Performance monitoring and tuning, indexing, analyzing database objects, database object creation.
• Responsible for establishing the initial sizing of implementation and production databases, as well as growth projections, based on data supplied by the clients.
• Performed logical and physical database backups and recoveries on UNIX Configuring and Performing Backups using RMAN.
• Wrote Unix Shell Scripts for monitoring Database health.