TECHNICAL SKILLS:

• Oracle Databases 9i, 10g, and 11g
• Real Application Clusters (RAC)
• Automatic Storage Management (ASM)
• Performance Tuning
• Oracle Grid Control (OEM)
• Golden Gate
• Oracle Maximum Availability Architecture
• Recovery Manager (RMAN)
• Disaster Recovery Solutions: Data Guard
• Microsoft SQL Server DBA: SQL Server 2005 and 2008.
• MySQL databases
• Unix Shell Scripting
• System Design
• PL/SQL, Oracle Warehouse Builder
• Pro*C and C, Perl, Python, Shell scripting
• Linux, Solaris, HPUX, Tru64, AIX
• Windows NT, 2000, 2003, and 2008.

PROFESSIONAL EXPERIENCE:

Confidential, Albany, NY

Sr. Oracle DBA

Responsibilities:

• Oracle Database design: Various HA options (Veritas Cluster, Oracle RAC) and MAA
• Oracle 10g RAC Implementation, Oracle 11g RAC Implementation, and Oracle 10g to 11g RAC Upgrades.
• Oracle 10g Grid Control Implementation, Oracle 11g Grid Control Implementation
• Performance tuning of the instance and database objects & SQL Tuning
• RMAN Backup and Recovery best practices
• Oracle data guard implementations: Physical and Logical standby configurations
• Golden Gate Implementation
• Converting single instance databases to RAC
• Migrating databases to Linux from Solaris
• Transportable tablespace migrations from Solaris to Solaris.
• Working with Oracle Support for various Oracle database issues.
• Support SAP Environments and Oracle Applications environments
• Perform various ETL Operations in the warehousing with OWB(Oracle Warehouse Builder)
• Handling various projects and kind of architect role in designing the architecture based on customer business requirements.
• Automating repeated tasks like startup services and shutdown services, monitoring instances
• Being Primary point of contact, ensuring high availability of the instances.
• Have resolved numerous issues and was involving in DR Procedures.
• Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the stats pack and AWR report generated from snapshots taken at the peak Business hours.
• Creating and Managing stored, procedures and triggers, distributed data, database replication (golden gate), server tuning, automation of administrative tasks, database
• 24x7 production support DBA working on a primary/ secondary pager rotation; and supported on holidays, weekends and beyond regular hours.
• Install MySQL Server and create the databases
• Backup and recovery operations in MySQL databases
• Performance tuning in MySQL databases

Confidential, Sparks, MD

Sr. Oracle DBA, Oracle Apps DBA, SQL Server DBA

Responsibilities:

• Installation & Configuration of Oracle 9i and Oracle 10g on both Solaris, and Linux platforms
• Implementation of DR site for Oracle applications and Oracle Data guard for the database
• Creation of Database for development & Creation of Objects
• Creating new users and manage roles and privileges in both O/S and Database level
• Implementations of Disk quotas in both o/s level and database level.
• Responsible for setting up user environment, Managing Systems & User and Group Security in both O/S and Database level
• Installed and Implemented Oracle Applications 11.5.10, CU2 for HRMS.
• Installed 10g (9.0.4.0) Application Server and Implemented EAP (11i Integration with 10g portal)
• Designed EAP Architecture with SSO, OID, Portal of 10g and 11i.
• Upgraded 9.0.4.0 to 9.0.4.1 and implemented EAP program
• Installed and upgraded 10g AS to 10.1.2.0.2 and implemented “General Availability” version of EAP program.
• Administered SSO, Partner application, OID administration and Portal
• Also involved in portal customizations and support.
• Involved in designing the production Architecture, Scaling and Sizing.
• Created Production Instance, Implemented F5 Load balancer with 3 11i Middle Tiers and 9i RAC DB
• Configured SSL at BIGIP Level for 11i.
• Implemented High Availability of SSO using BIGIP (as a Hardware load balancer)
• Configured external SSL for SSO.
• Implemented High Availability for Portal Middle tiers.
• Configured Hardware load balancer, BIGIP F5 9000 series for portal.
• Configured SSL for Portal and Helping BIGIP configuration team
• Integrated 11i and 10g SSO, Portal and Registered 11i as a framework provider
• Performed Stress testing on SSO, Portal and 11i accessibility from Portal and identified lot of bottle necks and fixed all the performance issues.
• Installation, configuration and maintenance of SQL Server both standalone and clustered environments
• Database backup and disaster recovery procedures
• Replication - Snapshot, Merge and Transactional
• SQL Server upgrades from 7.0 to MS SQL Server 2000 and from 2000 to MS SQL server 2005 and 2008
• Performance monitoring of cluster administration, managing high-availability, scaling VLDB, database recovery, distributed partitioned database design, replication, DTS/SSIS, log shipping and mirroring, DMVs, etc.

Confidential

Sr. Support Engineer

Responsibilities:

• Migration of database (from 9.2.0.5 to 10.2.0.1) on LINUX (Red Hat Enterprise Server).
• Installed and Configured RAC on Red Hat Linux Advanced Server with 4 nodes server side load balancing using Automatic Storage Management
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
• Designed and Implemented database security using Oracle roles and privileges.
• Managing, optimizing and tuning Oracle and SQL Server databases through such tools as Oracle's Enterprise Manager (OEM), snapshots and AWR Reports.
• Configured securities and access to product databases in SQL Server 2000/2005, Windows 2003 Server
• Configured securities and access to production databases.
• Designed and Implemented database security using Oracle roles and privileges. And securities for users and applications.
• Worked with Oracle partition tables and applied patches as per the requirements of the module. Used Oracle replication as databases for read only snapshots to maintain local copy of master tables in OLTP systems. Also done Patches for upgrading Oracle and DBMS software.
• Extensively used Oracle Enterprise Manager (OEM) for maintaining and monitoring databases.
• Involved in disaster recovery planning; detailed out the processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery strategies using RMAN.
• Working on mentioning and implementing new database on UNIX Platforms.
• Enabling Shared APPL TOPs for various middle tiers
• Configuring and Implementing the Oracle Applications Manager (OAM) with 11.5.8
• Applying the Forms and Reports 6i patch sets to the Application instance
• Applying the application patches, and RDBMS patches and lot of troubleshooting on AD Utilities.
• Managing Concurrent Requests and Concurrent Managers
• Creating, Registering the Custom Schemas, Custom Apps, Forms with the AOL
• Have worked on Oracle HRMS module as an Oracle APPS DBA
• Creating Application and Database Users, Granting Privileges, Creating Roles on the databases
• Designing and Implementing the hot and Cold backups for the Oracle Instances
• Troubleshooting all kind of problems for all the customers in production life cycle of the project.
• Installing Oracle 9iAS Infrastructure, Application Server.
• Implementing SSL with Oracle HTTP server on iAS 10222, 902x
• Renewing SSL certificates
• Maintaining Oracle Single Sign On server and LDAP server.
• Installing, Upgrading, Patching and Managing Oracle Applications 10.7, 11.0.3, 11.5.8(11i) Tuning Concurrent Managers, Defining Work Shifts, etc.
• Cloning Oracle Applications, with Auto config methodology for 11.5.7
• Cloning of the Application instances using Rapid Clone (11.5.8,11.5.9,11.5.10)
• Upgrading the RDBMS from 8.0.6 to 8.0.6.3 on the Application node and the Database Node
• Upgrading Oracle Applications 10.7 to 11.5.7, 11.5.8, 11.5.9. Instance.
• Upgrading Oracle Applications 11.0 to 11i instance.
• Upgrading Oracle Applications 11.5.8 to 11.5.10 instance.
• Upgrading Oracle applications, point release upgrades from 11.5.x to 11.5.8, 11.5.9 and 11.5.10 instance. An example of upgrades, he has performed lately.

Confidential

Oracle DBA

Responsibilities:

• Installation & Configuration of Oracle 8.0, Oracle 8i, 9i on both Solaris and Windows 2000 platforms
• Creation of Database for development & Creation of Objects
• Creating new users and manage roles and privileges in both O/S and Database level
• Implementations of Disk quotas in both o/s level and database level.
• Responsible for setting up user environment, Managing Systems & User and Group Security in both O/S and Database level
• Responsible for Server/Client configuration using Networking using -Net * 8
• Auditing On users, Lock Management Depending up on requirement
• Backups & Recovery: Physical and logical backup
• Recover the database whenever failure occurs
• Computing the statistic of database through monitoring dynamic and performance tables regularly & Implemented SQL scripts to monitor & to get information on free space, extents, and tablespaces.
• Installed, upgraded and patched Oracle software. Setup brand new machines including Oracle software installation, Oracle side configuration, third party backup software Legato troubleshoot and backup testing.
• Managed and resolved design issues during development.
• Moved database Schema changes to stage or production.
• Migrated and upgraded databases from version 7 to 8i.
• Installation and configuration of Stats pack and analysis of Stats pack performance report and subsequent tuning of production databases.
• Implemented database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database defragmentation