PROFILE SUMMARY:

• Oracle database consultant with 15 yrs. of professional IT experience specializing in Oracle Database, Servers, and Storage systems.
• Experienced in Consultancy, Planning and administration of high end database environment like Oracle, Microsoft sql server.
• Have extensive experience in implementing and administration of Oracle CC&B (customer care and billing) , Informatica (power exchange), OEM (Oracle Enterprise manager and Dynatrace.
• Have rich experience working with automating database activities using shell scripting Puppet, Automic etc. Sound knowledge of cloud computing using AWS.
• Knowledge of Big data (Hadoop) and no SQL databases.
• Over fifteen years of IT experience, Data Architecture, Development, Data management, Hadoop Big Data and Data Warehouse architecture experience including multi terabyte databases.
• Over five years of leadership experience with significant focus to data management, administration and data warehouse management.
• Experience with multiple development methodologies including Waterfall, Agile and DevOps.
• Oracle, Microsoft SQL and CC&B Administration
• All kinds of oracle database backups and recovery (rman cold, hot, expdp, exp/imp, physical clone)
• Disaster Recovery and replication techniques (dataguard, goldengate, power exchange)
• High Availability of database (Oracle RAC, Veritas)
• Monitoring and scheduling tools (OEM, JIRA, BMC, Remedy, Shell scripting)
• Expert in OEM (Oracle enterprise administration), BI publisher.
• Performance tuning ( Sql and database Instance tuning)
• Management and administration of oracle database in SAP environment.
• Data subsetting. Data encryption etc.
• Automation of dba activities using shell scripting, puppet and automic
• Proficient in AWS services like VPC, EC2, S3, ELB, AutoScalingGroups(ASG), EBS, RDS, IAM, CloudFormation, Route 53, CloudWatch, CloudFront and CloudTrail.
• Experience in database administration domain of OLTP, Data Warehouse, ETL, Reporting, SAP systems using Oracle 12c/11g/10g/9i/8i including ASM on Unix/windows platform. Handled more than 1000 databases of various sizes ranging from 40GB to 35TB.
• Proficient in installation, migration and upgrade of Oracle database on various platforms using Silent method, GUI and OEM provisioning.
• Experience in oracle database upgrades, PSU and security patching
• Configuration and administration of SAP based databases. BR Tools and bundle patches.
• Proficient in disaster recovery, database design, administration, backup and recovery, user management and plan maintenance.
• Have experience in SQL Server 2005, 2008 basic administration.
• Exposure of SQL Server high availability concepts like mirroring, replication, log shipping etc.
• Exposure in SQL Server maintenance plan creation, Jobs, database refresh, logins transfer, job rectification using T - Sql, patching etc,
• Have sound knowledge on Oracle Customer Care and Billing (CC&B) architecture, installation, deployment, data migration and administration, infrastructure, cutover & operations skills. Good knowledge in Oracle utilities application framework (OUAF).
• CC&B Application administration , server buildup, managed support, Product Implementation / Integration, setting up environments, Cloning and applying latest Product patches, Use r Creation , planning and managing day - to - day admin activities and interaction with client to facilitate smooth implementation
• Have experience in working hand to hand with oracle cc&b product team at current client at Confidential regarding configuration/installation automation using puppet, automic Delivery, support and administration for cc&b version 2.5.0.1.
• Weblogic administration and AD Authentication setup
• Experience in all kind of database backups. Expertise in backups and restore using RMAN with tools and technologies like Commvault, Legato, Veritas, TDP, EMC and HP StoreOnce.
• Expertise in RMAN backup/restores, migration using rman duplicate, cross platform, active duplicate etc
• Database migration from normal file system to ASM using RMAN.
• Database Refresh/Cloning, schemas and tables from production to Test/Dev environment using backups.
• Experience in Data Pump and Exp/Imp utility.
• Expertise in configuring and maintaining physical standby (dataguard) including manual and broker based switchover, switch back, failover and failback.
• Have migrated 35 TB of database at Oncor using cross platform database migration using RMAN and dataguard with almost zero downtime.
• Experience in configuration and administration of oracle golden gate (table and schema level replication)
• Experience in configuration of administration of Informatica (power exchange/power center).
• Experience in 10g streams for bidirectional/unidirectional data replication.
• Installation, configuration and administration of Oracle 11g RAC two node clusters on Linux
• Experience in Oracle 10g two node RAC on Solaris, Linux and windows
• Experience in working with Unix team on Veritas HA for databases.
• Extensive experience in configuration and administration of OEM 11g & 12C cloud for monitoring and performance tuning.
• Have configured OEM 12C with multi node OMS in a load balancer model.
• Experience in integration of OEM 12c with LDAP and BMC for ticketing purpose.
• Experience in database installation/creation using OEM provisioning.
• Experience in scheduling backup jobs using rman and datapump using OEM.
• Exposure to monitoring, ticketing and change control tools like BMC, remedy
• Worked with Puppet team for automation of Oracle grid and DB creation.
• In dept knowledge of Dynatrace administration for application monitoring.
• Experience in configuring application targets under OEM like oracle utilities, Weblogic, Peoplesoft, BMC etc
• Instance Tuning, memory tuning, IO tuning, sql tuning
• Experience in performance tuning that includes database tuning, design tuning, memory tuning, I/O tuning.
• Expert in finding out bad performing sql’s using AWR, ASH, Top sql’s
• Expert in finding solution for sql’s which worked better earlier but performing bad now based on logical I/O, hash value from cache or history and profiling those sqlid based COE.sql.
• Experience in finding solutions for database slowness based on event, state of sessions running using views like session, process, sql history, sql text etc
• Exposure in Cloud tools and technologies like Dockers and Nutanix
• Have worked closely in automating database installation, db creation using template and many customer oriented application using shell scripting, Puppet and Automic.
• Have used JIRA, Remedy, BMC as remedy tools for ticketing and CRQ’s knowledge of AWS services in compute, storage, database, security etc.
• Have done end to end implementation of Oracle CC&B version 2.5.0.1 and 2.5.0.2 including Weblogic, CCB frame work, hibernate, jdk, Oracle client etc.
• Experience in supporting oracle administration for SAP environment like BR tools, bundle patching etc
• Participating in technical team & CAB meeting
• Excellent understanding of Technology and Product/Project Life Cycle management.
• Business Delivery Management following ITIL service Management best practices.
• Understanding of ITIL (Process, Change, Incident and Problem Management) processes in live environment
• Delivering and implementing the project as per scheduled deadlines; extending post-implementation and maintenance support to the technical support team and client.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, Texas

Oracle & CC&B Consultant

Responsibilities:

• Involving multiple critical application projects to understand the database design, architecture for production to non-prod databases.
• Installation, Configuration and Administration of Oracle 11g RAC 2 node clusters on Linux
• Converted a single instance database to Oracle 11g RAC
• Configuration of ASM for large databases
• Database upgrade from Oracle 10g to 12C &11g, 9i to 10g and applied Oracle patches
• Experience working with application team for resolving performance and other issue during the application upgrade and batch jobs for major application like CCB, MAXIMO, FIM, Cognos, Informatica, etc
• Apply numerous PSU, CPU, Patch set and one off patches to RAC, ASM and databases and rolling patch on cluster ware and RAC Database
• Implementation of Active Data Guard and Stand by for high availability/disaster recovery purpose and maintains fail over and switch over
• Migration database from Non ASM to ASM instance.
• Automated Grid Installation and database creation using Puppet
• Configuration of RMAN Backup and Recovery with Tivoli/TSM backup, HP Store One Catalyst on Sun Solaris, Linux and AIX etc.
• Excellent experience in performance tuning using OEM, STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR and ADDM reports

Environment: Oracle database 12C/11g/10g/9i, RAC, Data Guard, RMAN, Solaris 11/10, Linux 7/6/5, AIX 7/6, Windows server, VCS, Oracle Enterprise Manager 12c, Jira, Remedy.

Confidential, Dallas, Texas

Oracle - Consultant

Responsibilities:

• Provides L3 - L1 support for more than 700 databases running on Oracle 12C, 11g, 10g, 9i and 8i databases ranging from 60GB-11TB on AIX, Sun Solaris, and Windows server
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Supported high availability database infrastructure including Oracle RAC and Data Guard technology
• Experience in Configuring 11g Golden Gates for UNI/Bi Directional Replication for schema and objects level.
• In-depth knowledge on various Oracles DBA support tasks and tools, like Oracle Enterprise Manager (OEM), Oracle Diagnostics Pack, Oracle Performance/Tuning Pack
• Configuration of RMAN Backup and Recovery with Tivoli/TSM backup, VERITAS Net Backups, HP Store One Catalyst, Commvault on Sun Solaris, Linux and AIX etc.
• Maintains backup and recovery solutions using Oracle RMAN, Commvault and Tivoli/TSM backup
• Recovered many databases using RMAN backup and hot backup due to database crashed
• Performed full and incremental backups using RMAN, Commvault and Implemented Data pump for full database backup and schema levels
• Downloaded patch from metalink & applied to databases
• Oracle support by creating iTARs and coordinating with them to resolve Oracle issues

Confidential

Senior Oracle DBA

Responsibilities:

• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Installation, migration, upgrade from 8i/9i to oracle10g including RAC.
• Creation of database including dataguard for production environment.
• Backup and Recovery using RMAN over Veritas
• Testing recovery strategies by simulating database crashes on development systems.
• Quarterly security patching on all Oracle environment including standby and 10gRAC.
• Performance and tuning for production and non prod databases.
• Database refresh using data pump, exp/imp, RMAN, cold backup, hot backup.
• Responsible for monitoring and maintenance of Sql, Oracle, UNIX environment.
• Worked on SQL2005 mirroring, replication, log shipping, maintenance plan creation, database refresh using backup, logins transfer, job rectification using T-Sql, patching,
• Creation of small utilities using shell scripting for maintenance task.
• Installation and configuration of 10g OEM Grid .

Confidential

Senior Oracle dba

Responsibilities:

• Installation of oracle software on different platform.
• Creating database for Production/Testing/Development
• Database migration, upgrade, patching.
• Monthly review of Database for performance optimization
• MIS Reports as defined by Confidential and monthly review
• Monitor various Application Batch Process
• Direct Coordination/Interaction with Oracle for support and Bug Fixing
• Replicating data from one database to another database
• Creating new users and manage roles and privileges
• Creation of Database Objects as per the Requirement
• Managing Import/Export Depending up on Requirement.
• Managing Rollback Segments, Redo logs, Control files, and Tablespaces.
• Auditing on users, Lock Management and space management.
• Monitoring Users, tablespace, rollback segments and tuning SGA.
• Materialize view refresh from different server to MIS(report ) server
• Taking full backups of databases by RMAN with veritas netbackup.
• Regularly restore from tape device to check for the consistency of the device.
• Testing Recovery Strategies by Simulating Database Crashes on Development Systems
• Continuously Monitor the System response time and detect for any bottlenecks along with possible solutions.
• Package and Patch Administration, Adding Patches as per requirement.
• Environment creation also included installation of COBOL, CICS, Websphere and linking them with oracle.

Confidential

Oracle DBA

Responsibilities:

• Installing/upgrade/patch oracle databases on Windows/Solaris
• Creating database and tablespaces.
• Maintaining system security, defining of roles, profiles etc.
• Creating users and database links.
• Configuring Recovery catalog for RMAN
• Backup and recovery strategy for database.
• Involve in creating partition for big table (Range and Hash)
• Monitoring and optimizing the performance of the database.
• Involve in database tuning and tuning SQL Statement.
• Solving problems of database crashes.