SUMMARY

• Over 8 years of experience in Oracle Database Administration on Design, Administration, Configuration, and Support for Pre and Post Production systems
• 8 years of Extensive Experience in Installing and Upgrading Oracle 8i/9i/10g/11g databases on production, test and development environments on Solaris, AIX, HP Unix and Linux boxes.
• 8 years of Proficient Experience with Standby Database, Data Guard, Replication.
• 5+ years of experience in Installing, Implementing, Configuring and Running Oracle 10g/11g RAC.
• 5+ years of experience in upgrading RAC Database 10g to 11g
• 7+ years of strong experience in Backup and Recovery
• 6 years of Extensive Performance Tuning experience, specializing in Operating system tuning, SQL tuning, Database/Instance tuning
• 4 years of Experience in Implementing and configuring 10g/11g OEM Grid Control.
• Experience in OLTP/DSS database systems, managing large Oracle databases (VLDB) and data warehouse systems.
• Strong experience with Oracle Databases (11g/10g/9i/8i), RAC on Unix/Linux/Windows/ Confidential platforms.
• Experience with Installation, Configuration, Upgrades, Migrations, Administration, Security and Patching of Oracle Databases and Oracle Applications.
• Knowledge of exadata.
• Strong Knowledge on Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR, etc.
• Experience with SQL turning, AWR reports, Wait events and also Performance issues of long running jobs.
• Experience in configuring and maintaining 11g Golden gate
• Experience in handling the entire life cycle of the project with respect to Databases starting from planning to documenting Standard operating procedures for Post production support
• Experience in developing shell Shell scripts to automate the deployment and maintenance of various administrative tasks.
• Considerable experience working with Sql Developer, DB Artisan and Toad products.
• Well versed in the various procedures and processes involved in resolving outages and providing production support for multiple projects and working effectively with different groups in multiple environments (Development, QA, Production).
• Experience handling sql server 2008 backup, replication and Mirroring of databases
• Experience working with Oracle support on problem determination, troubleshooting, and resolution - SRs, running and submitting, gather scripts and log info, tuning, trace, taking thread and heap dumps.
• Highly motivated self-starter with a strong analytical problem solving, having ability to multi-task, work in a team environment, understand and be responsive to customer needs, work under tight deadlines and work independently and be flexible, a good listener and have strong oral and written communication skills.
• Excellent problem resolution and communication skills with ability to work under pressure in a highly visible role.
• Very good knowledge of Hbase database and hadoop architecture.
• Experience in providing 24x7 production support and maintenance of Database Servers on a rotation basis.

TECHNICAL SKILLS

Databases: Oracle 9i/10g/11g, MS-Access2003, MySQL, SqlServer 2008, HBASE

Languages: C, C++, SQL,PL/SQL, Perl, Java

Operating Systems: Sun Solaris, RHEL, OEL, HP UNIX, AS/400, OS/390, Z/OS and Windows /NT/XP

Web Technologies: HTML, XML

Case Tools & Utilities: TOAD, SQL Developer, PL/SQL Developer, OUI, DBCA, DBUA, Grid Control, EXP / IMP, SQL Tuning ADVISOR/ TKPROF / EXPLAIN PLAN / STATSPACK, ADDM, AWR and DATAPUMP, HP Service Desk, HP Openview, IBM Clearquest, Remedy, HP Data Protector, DB Artisan, Helpzilla, HP Service guard, Golden Gate

Monitoring tool: BMC Patrol, Oracle Enterprise Manger 10g/11g/12c, Zenoss

PROFESSIONAL EXPERIENCE

Confidential, Palo Alto, CA

DATABASE administrator

Responsibilities:

• Implemented stand-alone and RAC database creation, backup scripts configuration and creation of crontab scripts for DB maintenance.
• Provided war room support during Quarter-end, Year-end and major product releases as per the business requirement.
• Configured and Maintain Oracle Golden gate for replication between databases.
• Cloned databases using RMAN / BCV.
• Configured and maintained 10g/11g EM grid control
• Configured NLS Character set to normalize with other databases.
• Configured fast start fail over in oracle 11g dataguard as part of maximum availability.
• Analyzed and tuned SQL queries using various performance tuning techniques like Oracle Sql Performance Analyzer
• Identified performance issues by analyzing AWR, Statspack, and ADDM, and tuned databases and servers for best performance
• Monitoring the server’s memory, disk, CPU I/O and network to establish baseline and peak performance for applications using UNIX command-line utilities
• Implemented 11g Active Dataguard on RHEL os.
• Applying CPU (Critical Patch Updates)
• Expertise in troubleshooting and tuning sql queries, memory, cpu and Disk IO for optimum performance.
• Automated scripts for weekly cloning of databases using RMAN duplicate
• Created Oracle EBS users and added responsibilities to the users depending on the requirement
• Added and dropped disks to/from Diskgroups to ASM whenever is required.
• On call, on pager, 24x7 production support and maintenance of Applications Servers on a rotation basis.
• Identify and fix issues upon providing RCA for Severity 1 and Severity 2 issues.
• Working on Transportable tablespace refresh to refresh between two OLAP databases.
• Active involvement in monitoring server performance to reduce performance bottleneck

Environment: Oracle 11g R2 RAC, Oracle 11i ebiz, Oracle 12c/11g EM grid control, Golden gate, Helpzilla, HP Project Portfolio Management, Zenoss, OEL Linux 6

Confidential, BOISE - ID

Sr. Database Administration

Responsibilities:

• Provided 24/7 On-call DBA support with on-demand client interaction and a customer focused attitude
• Maintained very large Databases OLTP, Warehouse (OLAP) and SAP Oracle databases for various in house applications
• Upgraded database for oracle 10g to oracle 11g r1 on Solaris and Linux environment
• Maintained SAP databases using SAP BRTOOLS
• Monitored, and handled escalations and attending ERTs whenever required.
• SQL performance tuning as per the requirement.
• Used clear quest tool to track the progress of projects
• Audited SOX database credentials and performed maintenance as per policy
• Prioritized issues based on the severity and SLA norms as per SOW
• Provided support to any changes done to the Production databases as part of projects
• Performed monthly and quarterly maintenance activities like partitioning and tablespace re-organization
• Used DBArtisan tool for quick performance monitoring and modelling of database
• Installed & configured the Oracle database as per application requirements
• Upgraded and migrated databases from Windows X64 to Solaris SPARC
• Partitioned tables on quarterly basis for better performance
• Applied PSU, CPU, and one off patches for development, test and Production environments
• Cloned Production Databases to Development and Test environments
• Performed On call, on pager, 24x7 production support and maintenance of Database Servers on a rotation basis.

Environment: Oracle 10g (10.2.0.3 and 10.2.0.4), SAP, 10g RAC, DB artisan, BRTOOLS, 10g OEM Grid control, clearquest, BMC Remedy, linux, solaris

Confidential

Oracle Database Administrator

Responsibilities:

• Installed of Oracle 11g RAC ONE, 10g RAC and standalone databases on RHEL 6 platform
• Validation of backups by recovering the backups on test machines at regular intervals
• Upgraded existing Oracle 10g Grid control EM server to Oracle 11g EM server.
• Co-ordinated with the Oracle support to resolve any critical issues.
• Configured shell scripts to track growth of databases.
• Managed SAP databases using SAP BR Tools like BR Backup and BR archive.
• Troubleshooting database versions 10g, 11g R1 and SAP databases .
• Created performance tuning activities like index rebuild tablespace reorganization, partitioning tables on a monthly and quarterly basis depending on requirement.
• Installed pentaho client for oracle database monitoring and growth trend analysis
• Cloned Production databases using RMAN utility on a weekly basis for business reports.
• Configured bash and shell scripts to backup listener log and alert log trace files and purge them on regular basis on linux environment.
• Worked closely with developers and application support team to troubleshoot and tune databases as per the requirement.
• Worked with multiple application teams during Change Advisory Board meeting and review the changes that come up in the upcoming week.
• Implemented high availability solutions such as Standby Database and Disaster Recovery setup using dataguard.
• Given Support and Maintenance for Oracle 11g 4 node RAC Databases
• Fixed issues related to various aspects of Oracle database
• Foreseen strict adherence to ITIL processes like Incident Management, Change Management and Problem Management by using BMC Remedy tool.
• Manage backup of sql server databases depending on the critical of databases
• Mange SQL server 2008 replication using snapshot .
• Supported Sql server 2008 non production databases during releases
• Provided 24X7 On call support on a rotational basis.

Environment: Oracle 11g Rac one, Oracle Siebel CRM application, SAP BR Tools, Remedy, Pentaho, Oracle 11g Grid Enterprise Manger, Sql server 2008, TOAD

Confidential

Oracle Database Administrator

Responsibilities:

• Database monitoring, maintenance and backups on a daily basis.
• Handled tickets using HP Openview tool .
• Maintained critical database backups using HP data protector snapshot backup tool .
• Involved in database switch over and switch back activities as part of yearly drill to validate the disaster recovery strategy.
• Performed Database Switch over Testing.
• Managed HP clusterware using HP Service guard
• Manually recovered DR Site when log shipping was not happening
• Performed cloning of a database to generate reports.
• Took Logical, Cold & snapshot backup of the database regularly.
• Moved data between database using utilities like Export/Import.
• Created and managed different kinds of Tablespaces, extent and storage parameters.
• Created bash shell scripts on linux environment to manage archivelogs.
• Created new user accounts, profiles, and roles and assigned them to different users.
• Configured listeners on server side and TNS aliases on client side.
• Tested Data Guard for 24x7 databases and implemented it on test database.
• Frequent interaction with Developers, and working with them in developing the applications using SQL developer

Environment: Oracle 9i, Infosys Finacle application, HP Openview, HP dataprotector, sql developer, HP Service guard, HP UNIX, Linux