EXPERIENCE SUMMARY:

A highly skilled Corporate database administrator with a professional experience of 9+ years as a Database Administrator with extensive skills in Administration and Implementation of Various aspects of database technologies, primarily expertise in Oracle and also experienced in SQL Server and Sybase DB administration on various platforms. A self - motivated, detail oriented, responsible and reliable team player with a set of very strong technical and communication skills and extensive US based customer experience.

KEY STRENGTHS:

• Multi flavor DB environments administration (Oracle, SQL Server and Sybase).
• Multi Terabytes DB administration for Oracle 11g/10g/9i and SQL Server
• Installing and managing multi node RAC databases with ASM.
• Performing huge scale DB upgrades and cross platform upgrades with minimal downtime.
• Experienced in SQL baseline, stored outlines and fixing the execution plan.
• Performance tuning of databases, instance and sql tuning and OS level huge pages setup.
• Sound backup/recovery strategy setup (RMAN, data pump, hot/cold backups)
• Implementing tight security controls and DB auditing, SOX compliance.
• Installing Enterprise manager (including Grid control) for database monitoring/performance/diagnostics
• Data guard implementation setup for Disaster recovery and DR drill, knowledge on Golden gate.
• AWR, ASH, and TOP SQL reports.
• PeopleSoft Security administration.
• Excellent knowledge of SQL*Loader, Grid control Enterprise Manager.
• Managing/coordinating Offshore DBA team on a regular basis to discuss and resolve the Database related issues
• Raising/escalating high severity tickets for faster resolution with vendors such as Oracle support
• 24/7 and on call weekend Production support
• Effective Change control management process to allow changes to roll over to production.
• Detailed documentation skills for implementation plans, problems and root cause analysis
• Methodological handling and resolving of issue tickets raised by the user within SLAs.
• Experienced in SQL Server 2005/2008 day to day DB administrative tasks and troubleshooting.
• Experienced in SQL Server 2008 Replication setups (Transactional, Merge and Snapshot)
• Experienced in Sybase 12.5/15 DB administrative tasks, 12.5 to 15 upgrade, table encryption and backup/recovery process.
• Quick learner and can easily adapt to the different client work environments.

TECHNOLOGY SNAPSHOT:

Oracle: Oracle 11g/10g/9i, RAC, Dataguard, Grid Control, Enterprise Manager, RMAN backup & restore, data pump, TTS,ASM, patching, Perf.tuning, ADRCI and physical standby.

Sybase: Sybase 12.5/15, Encryption, Backup/recovery, DB Upgrade and patching.

SQL Server: MS SQL 2005/2008, SSIS, Replication, Backup/recovery and Upgrades.

Others: Pervasive, Linux, HP-UX, AIX, Windows, UNIX shell scripts, IBM Web sphere, TOAD, SQLSentry, Erwin, Spotlight, Lab 128, Nagios monitoring tool, dbtrends software, Configuration management and Linux administration.

DETAILED EXPERIENCE:

Confidential, Detroit

Oracle/SQL Server DBA

Responsibilities:

• Install, configure, and manage large scale Oracle single instance, Oracle RAC and SQL Server databases for company’s enterprise applications.
• Implementing and developing procedures for multi node RAC installation on ASM, adding node using silent command line and chef methods.
• Expertise in database upgrades, RAC upgrades, patching databases with minimal downtime.
• Expertise in high volume cross platform database upgrades with minimal downtime using transportable table spaces
• Root cause analysis for database incidents using various available tools like AWR, ASH, OS reports.
• Performance tuning of databases at Instance and SQL level.
• Fixing explain plan using stored outlines and SQL baselines.
• Setup of physical standby and data guard to maintain maximum availability.
• Configure and schedule periodic backups and recovery for multiple enterprise application databases using RMAN, data pump and TTS methods.
• Handling all Severity 1 incidents in 24/7 basis that affects the database availability and responding to page outs during the on-call.
• Proactively implement the performance thresholds to alert and resolve the issues through Nagios and UNIX shells scripts before impacting the end users.
• Maintain multiple disaster recovery replication site in sync with the production environment by fixing the recovery issues.
• Provisioning user access, permissions and privileges based on the requests.
• Documenting all the day to day support works and methods to troubleshoot any new issues that arise for the benefits of the team.
• Providing technical support to various enterprise application teams for efficient use of technology in area of database operations.
• Participate in implementation meeting by representing the database team and providing solid backup and restore strategies satisfying the SLA needs.
• Participate in daily incident meeting to discuss root cause of outage incidents and remediation measures.
• Participate in infrastructure capacity planning and provide reports on requirements based on usage trends
• Participate in Security audit and change control process to ensure proper security standards are met.
• Participate in weekly meeting and provide the status updates to the team and the directors.
• Perform constant research in latest technologies and trends and implementing the same which can make environment more robust and stable.
• Exposure to Amazon web service (AWS).

Confidential, Honolulu

Oracle DBA

Responsibilities:

• DBA for Oracle PeopleSoft financials 8.9 applications on Oracle 10gR2 RAC Linux production environment.
• Oracle 10g RAC upgrade, 9i to 11g upgrade, Patching Oracle binaries and applying Oracle’s critical patch updates
• Configuring, scheduling and monitoring periodic backups and recovery strategies for all Oracle databases.
• Developing UNIX shell scripts and SQL scripts to carry out routine checks on databases
• Managing User creation, permission lists, roles, and generating Database user access reports for SOX compliance.
• Maintained database as per SOX standards and responsible for all external and Internal audits.
• Software Configuration manager responsible for production code migrations
• Installation, configuration and up gradation of Sybase 12.5.4 to 15 on HP-UX.
• Implemented encryption option and encrypted the table which contains credit card data as per the PCI
• Migration from Sybase 12.5.4 to Sybase 15 with different page size.
• Monitoring Sybase database alert logs, backup logs using UNIX shell scripting
• Database backup and restore for supporting development projects
• Installing, Configuring and Managing SQL server 2000, 2005& 2008.
• Monitoring & configuring Jobs, Replication setup, Resource governor setup, Maintenance plans etc.
• User creations and configuring permissions depending on the requirements, Backup and restoring Databases
• Installed and monitored DBs using Sql sentry, and avoided many issues before affecting production environment

Confidential, NEWYORK

Oracle Data warehouse DBA, Business Objects Administrator

Responsibilities:

• Involved in setup of entire Mount Sinai Data warehouse environment starting from installing Oracle Database, Business objects Data integrator, Business objects XIR2 and setting up AIX level users and directories and up to production implementation of Data warehouse.
• Primary role is Oracle DBA and also involved as BODI Admin and AIX Basic Administration.
• Installing Oracle database software, creation of databases, installing patches.
• Creation of schemas, table spaces, tables as per the project requirements using Erwin Data modeling tool.
• Provided database support for developers in data loading and solving day to day database problems.
• Extensive usage of data pumps for backup/restore, selective export for tables for development data warehouse project.
• Creation of Materialized views for Data ware house report purposes and Virtual private database.
• Pinned frequently accessed objects in KEEP pool for better performance.
• Maintained all DEV, QA, PROD environment databases in sync with help of Erwin data modeling tool.
• Involved in writing and scheduling shell scripts to extract data from various source systems and placing to MSDW servers.