SUMMARY:

• Around 17+ year experience in IT including 15+ years Oracle Database Administration and 2+ years of Cassandra/MYSQL Database Administration in UNIX (Sun Solaris, HP UNIX, IBM AIX, Linux and windows) including Production and Application development support. Having strong technical skill set, rich experience, and an impressive record of accomplishment in IT domain.
• Extensive experience in the areas of System analysis and Database Administration including database creation, up - gradation, migration, performance tuning, backup and recovery management.
• Expertise in applying quarterly security patches (PSU, CPU) and bug fixes.
• Experience in using RMAN for Backup, Recovery management, duplication database and build standby databases etc.
• Good experience in Installation, Configuring and Administration of Oracle server as well SQL Servers databases.
• Experience in setup RAC for 9i/10g/11g databases on Linux environment with ASM functionality.
• Implemented 3-hr/3-day/30-day disaster recovery planning, exercises.
• Experience in configure and setup Data Guard physical standby for 9i/10g/11g databases.
• Expertise in implementation of projects, gathering requirements, interacting with Client, working along with team members, capacity planning, designing including creation of logical and physical storage Structures and projecting future requirements for expansion.
• Expertise in using data pump, Exp/Imp, SQL Loader, Toad and Transparent data encryption (TDE).
• Experience in working with large Data ware housing (22 TB).
• Good working knowledge in OEM Grid Control (11g and 12c), setup alerts for monitoring, Change Management Pack, plugins, RMAN, and AWR/ADDM etc.
• Excellent communication skills, excellent team management problem solving skills and an attitude to learn the new cutting edge technologies
• Good knowledge of shell scripting, scheduling jobs, debugging and enhancing existing code.
• Implemented Heterogeneous Database connections - Oracle to SQL Server.
• Expertise in query tuning, memory tuning, find the bottlenecks and pro-actively provide suggestions to application teams, Debugging major oracle issues and interacting with Oracle Support Services on need basis.
• Expertise in implementation of projects, gathering requirements, interacting with Client, working along with team members, capacity planning, designing including creation of Logical Storage Structures and projecting future requirements for expansion.
• Knowledge of C language and well versed with RDBMS like Oracle, with Front End GUI tool Visual Basic, ASP and ASP.NET.
• Experience in Oracle WebLogic / Oracle application server administration.
• Automation of regular operational tasks; implement and streamline processes to increase productivity as well as respond to business needs.
• More than 10 years of experience as a Lead Oracle DBA in 24x7 Production Support environments.
• Exposure on oracle Application DBA
• Good working knowledge on Oracle Agile and Demantra Applications/Modules setup and support.
• Good working knowledge on OBIEE and Informetica setup and support.
• Exposure on MES Applications.
• Exposure on Perl scripting.
• Working Experience in SQL Server.
• Working experience in Cassandra.
• Installed and configured Cassandra DataStax Enterprise and OpsCenter monitoring.
• Supports/works on Cassandra's database administration.
• Supports full life cyle of system deployments.
• Hands on experience in configuring snapshot and incremental backups on Cassandra databases.
• Attended Cassandra trainings and webinars from Datastax
• Migrated data from Oracle database to NOSQL using Sqoop.
• Experience on MYSQL and SQL Server Databases.
• Experience in automation tools Jenkins, SVN and GitHub.

TECHNICAL SKILLS:

Operating Systems: Sun Solaris, HP Unix, IBX AIX,Linux,Windows95/98/2000/NT,MS-DOS

Languages: C,VB, SQL, PL/SQL, Shell Scripting, VB Script and COM,DCOM etc.

Databases: Oracle 8i/9i/10g/11g,12c SQL Server 7, 2000, 2005 and 2008

Hardware: Sun Solaris SPARC Enterprise, IBM RS6000 E-Server Pseries 44p Model 270,HP-UX PA RISC 9000, Linux X86-64, DELL4400 Server, DELL2500 Server, COMPAQ PROLANT 5500 Server, COMPAQ PROLANT 6400R Server,E25K.

Web Related: HTML, Java Script, ASP, ASP.Net, Oracle application Server, Oracle webLogic Servers

Domain Knowledge: Banking, Information Technology and Medical

Tools & Utilities: Oracle Enterprise Manager, PL/SQL Developer, SQL Enterprise Manager, Query Analyzer, DTS Package, Export/Import and Profiler, TOAD, SQL *Plus, Pro*C, SQL loader, RMAN, Data pump, NAMES, OID and LDAP, netiq, Autosys, Golden Gate, Oracle Streams, Putty, Secure CRT, Hummingbird, JIRA, Remedy,Sharepoint,Subverson.Sharepoint, Microsoft project 2010

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Database Administrator / Programmer

Environment: Oracle 12c,11.x, 10.x, IBM AIX, RHL,OEL, Linux X86 64 and Windows 2008, Golden Gate, OEM 12C, RMAN,Putty, Win SCP, Secure CRT, VNC Viewer, Hummingbird, Sharepoint and Toad for Oracle, SQL, PL/SQL, UNIX Shell Scripting, AWR, ADDM.

Responsibilities:

• Supporting, development and production databases of internal applications.
• Extensive knowledge & working experience of Oracle OEM 12c Architecture, Framework, and Infrastructure.
• Consolidated database creation in oracle 12c using multiple PDBs.
• Migrated pluggable databases by cloning using DB links and manually moving files.
• Used the CDB, PDB views for querying against container, pluggable 12c databases.
• Migrated 11.2.0.3 databases to 12.1.0.1 and supporting 12c production databases.
• Upgraded databases from 11.2.0.2 to 11.2.0.3 with full version upgrade.
• Deploying the database changes thru CVS/SVN control version tool.
• Worked on multiple projects as shared resource and responsible for infrastructure and capacity planning of databases, schemas etc.
• Managed the security access for databases as part of CDP (Customer Data Protection) process & SOX compliance.
• Worked on 11g golden gate unidirectional replication for DML & DDL changes.
• Worked on 11gR2 databases. Implemented new features of Oracle 11g like 11g streams, Automatic Memory Management, Query Result Cache, Read-Only Tables, Secure Files, SQL Access Advisor, SQL Performance Analyzer, and SQL Plan Management.
• Worked in Agile methodology environment in all projects and having daily scrum calls.
• Extensive Performance Tuning, Memory (SGA) Tuning, Locks and Latch resolution in DBBC and Shared pool. Monitoring and optimizing the Performance of the database using AWR/ADDM, ASH & tkprof.
• Experience deploying the data models in the databases.
• Worked in conjunction with the development team to fine tune SQL and PL/SQL Code using Execution Plan, SQL TRACE, ANALYZE, DBMS STATS and evaluating and monitoring database to resolve performance issues including troubleshooting errors, recovering database and failures as needed.
• Used Oracle streams for Data replication, Data warehouse loading, Event notification as well as business event mgt.
• Worked on Oracle DB Virtual Machine 2.X on Linux servers.
• Configuring RMAN backups and traditional backups.
• Supported multiple projects end-end for life cycles DEV, QA, LT and Prod environments.
• Worked closely with developer for tuning the SQL queries, DB parameters.
• Used Materialized Views (snapshots) for replication of data.
• Monitoring logs, alerts, managing Batch Jobs (Alteration, Automation, Tuning, Failure)
• Provide Primary DBA support for establishing, upgrading and maintaining the RDBMS software environments.
• Worked on the Change Management process for releasing database code.
• Designed new meaningful shared documentation directory .Documented various repeatable ERRORS during on call, this helped lookup and troubleshooting time.
• Implemented backup and recovery through RMAN tool.
• Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Automatic Segment Management.
• Deciding and implementing the naming conventions of data file, redo log files, tablespaces, and segments.
• Working performance of the views and SQL queries.
• Responsible for the database backup and recovery operations and strategies of the databases.
• Expertise and support in creating data guard and logical standby setup.
• Expertise in maintaining and applying patches (PSU/CPU) and bug fixe patches.
• Expertise in creating and suggesting the best approach to duplicate and refresh the databases.
• Responsible to provide support as per SLA.
• Worked on Cassandra administration and related technologies.
• Installed and configured Cassandra DataStax Enterprise and OpsCenter monitoring.
• Supports/works on Cassandra's database administration.
• Supports full life cyle of system deployments.
• Hands on experience in configuring snapshot and incremental backups on Cassandra databases.
• Attended Cassandra trainings and webinars from Datastax
• Migrated data from Oracle database to NOSQL using Sqoop.
• Experience in automation tools Jenkins and GitHub.

Confidential, Milpitas, CA

Sr. Oracle DBA

Environment: Oracle 11.x, 10.x, IBM AIX, RHL,OEL, Linux X86 64 and Windows 2008, Golden Gate, OEM 12C, RMAN,Putty, Win SCP, Secure CRT, VNC Viewer, Hummingbird, SharePoint and Toad for Oracle.

Responsibilities:

• Supporting Production/Stage/Test/Dev databases running for different applications like Oracle 11i E-Business Suit, Agile, Demantra, BI, SOA, ESSBASE and OBIEE.
• Providing 24x7 supports for the production and development databases size from 150 GB to 2+ TB.
• Experience in using RMAN for Backup, Recovery management, duplication database.
• Installing, configuring, administering and tuning Oracle database for 11g, 10g databases on Linux, AIX and windows environment.
• Installing and Expertise in OEM 12c and OEM Grid Control, Change Management Pack, plugins, monitoring and setup alert/SMS bases on groups.
• Oracle software deployments, and software maintenance including planning and applying Oracle PSU/CPU, bug fix patches.
• Installed and configured Oracle agile application (Agile PLM 9.3.3) also upgraded from agile version 9.3.1.
• Installed and configured Oracle Demantra application (7.3.1.0).
• Installed Oracle OBIEE (11.1.1.7) and performed the related configuration.
• Installed Informatica 9.5.1 hotfix 2 and performed the related configuration.
• Installed Informatica PWC client, DAC and OBIEE client.
• Providing 24x7 supports for the production and development databases size from 150 GB to 2+ TB running on 2 and 3 node RAC cluster with ASM.
• Data Guard physical and logical standby setup and maintenance.
• Analysis of AWR/ADDM reports and finds the bottlenecks and provides the better solutions; Resolving performance issues caused by problematic queries and tune them for better performance.
• Monitor and resolve application design issues and guide application team; CPU, Memory and IO Utilization monitoring at Server level; Space administration including capacity planning.
• Perform data model changes for various implementations of projects without affecting the daily database loads and usage by business users.
• Involve in discussion with development people for suggestions on project to improve the performance when the system goes live.
• Disaster Recovery Configuration, Testing and Coordination.
• Manage and mentor technical teams for good service delivery on all operational tasks and projects. Manage the communication and interaction with business customers and technology peers for all Database related tasks and services.
• Writing and Maintaining shell scripts, SQL and PL/SQL code.
• Expertise in implementation of projects, gathering requirements, interacting with client, working along with teams, capacity planning, designing including creation of Logical Storage Structures and projecting future requirements for expansion.
• Expertise in replication tools Oracle streams, golden gate and shareplex setup and maintenance.
• Application, Database Performance Tuning and Monitoring.
• Contacting Oracle support and raise SR on critical database issues. Resolving ad-hoc database issues requested by Client.
• Oracle alert log and trace files monitoring, tkprof trace file generation and analysis, DB hang analysis, resolving table locking and dead lock issues.

Confidential

Senior System Analyst (Sr. Oracle DBA)

Environment: Oracle 10.x, 11.x Sun Solaris 2.9, 2.10 Sun Enterprise Sun, Linux and AIX.

Responsibilities:

• Configured, implemented 10g/11g RAC with ASM disk on Linux/AIX Servers.
• Good working knowledge in database backup/recoveries using RMAN.
• Implemented/Set-Up OEM grid control and registered all the databases for monitoring.
• Implemented transparent data encryption (TDE).
• Implemented Heterogeneous Database connections - Oracle to SQL Server.
• Migrated & upgraded oracle databases (Standalone/RAC environments) from Oracle 10gR2 to oracle 11gR2.
• Expert in 10g Oracle RDBMS installation, upgrade, configuration, backup, recovery, archiving & purging activities.
• Performed database cloning/set-up on VM Servers.
• Monitoring and optimizing the Performance of the database, capacity planning and SQL tuning.
• Configuring the Streams replication (Capture, Propagation and Apply processes) to replicate the data from the production systems to the operation data stores databases.
• Involved in design and implementation of oracle 10g Data-guard both physical/logical standby databases.
• Perform DR Test by every quarter.
• Implemented Load balancing in RAC environment.
• Schema & Tables refresh from Production to Development and Test Environments.
• Loading data using SQL Loader and Data Pump utilities.
• Writing monitoring/health check scripts to alert team of database uptime/downtime status, sizing issues
• Management of schemas, objects & Partitioning of tables & indexes.
• Installation and configuration of Oracle Grid Control and deploying the monitoring the agents on all the database servers hosts.
• Involved in the applying the patches for the oracle enterprise database servers, the grid control servers and the oracle management agents.
• Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Write scripts for creation of users, creation and assignment of roles, analyze space requirements and maintain tablespaces and other database objects and also did the patch management for oracle upgrade.
• SQL tuning and Database tuning has been done based on reports generated by AWR,ADDM, Statspack, Explain Plans and monitor the database performance on daily basis.
• Writing Perl and Shell scripts to automate manual DBA tasks.
• Applying incremental DDL and DML patches into Production, Development, UAT, Prod-Fix & IST Environments.
• Support & Maintenance of Production/Development Databases on various servers with on-call support for Production applications.
• Involved in Creating & refreshing Materialized Views as per requirements.
• Coordinate with Unix Administrators for space management and other issues.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export / Import utilities).
• Refreshed databases and tables using data-pump, Exp/Imp, SQL Loader utilities and created customized shell scripts according to requirements. Worked in database, applications, memory and disk tuning.