OBJECTIVE

• Seeking a challenging career in Database Administration, in an organization where me can put my work experience to use it productively and ensure teh growth of teh organization, in teh process adding value to myself and assume ever increasing responsibility in teh course of time.

SUMMARY

• Oracle Certified Database Professional wif expertise in installing, configuring, administering and managing oracle databases & implementing solutions for high availability(HA), Disaster Recovery, Cloning, and Database Security.
• Expertise in Setting up Oracle Grid Infrastructure wif ASM and CFS, RAC Database versions 10g,11g,12c on different UNIX and Linux platforms.
• Expertise in implementing High Availability and Disaster Recovery Solutions using Oracle and Non - Oracle tools.
• Experienced in Installing, Managing oracle E-business Suite R11i and R12.1 application.
• Expertise in Installing, Configuring, Troubleshooting and Tuning Gloden Gate 10g,11g on Oracle Databases
• Expertise in Managing Oracle, MS SQL, SQLite Server Databases in production, development and test environments.
• Expertise wif wide variety Third party backup and Recovery tools like CommVault, NetApp, NetBackup, TSM to perform Database & Application Backups and Recoveries.
• Expertise in implementing, Migrating and upgrade Projects from version 8i through 12c using Various Oracle Database tools like Traditional export/Import, Data pump, Gloden Gate, RMAN, Data Guard.
• Expertise in Planning and setting up Disaster Recovery, Data Center 2 and High Availability solutions for teh Databases and Applications.
• Expertise in Installing, Upgrading, Patching, Configuring and Managing Oracle Enterprise Manager 10g,11g, 12c and experienced wif other Monitoring tools such as Splunk, Fog light, Nagios.
• Expertise in Supporting Oracle E-Business Suite R12, ASCP, Siebel, OBIA/OBIEE, Informatica, Demantra, SAP Business objects, Data warehouse, SSO and custom application Databases.
• Experienced in most major Oracle Applications Modules wif recent relevant experience in Financials, HRMS, Workflows, Order Management, and CRM modules such as iProcurement, iStore, iSupplier, Channel Revenue, SCM.
• Good Experience in using tools like ADPATCH, ADADMIN, ADCTRL, ADRELINK, ADMERGE, ADCONFIG, ADMRGPCH, ADLICMGR & PTS tools to manage EBS R12 application.
• Experienced in troubleshooting Forms server, Reports server, and Apache server, Jserv, Jinitiator and Workflow.
• Experienced and having teh ability to lead team for day to day activities and for new projects.
• Efficient team player wif strong analytical, troubleshooting and good communication skills.
• Ability to quickly adapt to new environment.
• Experienced in Installing and managing Hadoop systems and Hadoop Eco system components like Hive, Impala, HDFS, Flume, Oozie, Spark, Cloudera Manager, and Hue Components.
• Knowledge in Oracle Fusion Middleware and components.
• Hands-on experience and good working Knowledge of SQLite, MS SQL Server, MySQL and Vertica Databases.
• Cloudera Trained Apache Hadoop Administrator.

TECHNICAL SKILLS

Tools: SQL*Plus, SQL Developer, Oracle Enterprise Manager (OEM), RMAN, Toad, SVN, Traditional Export/Import, Data pump, Data Guard, ASM,RAC, Oracle Gloden Gate, Developer (Forms, Reports), Net Backup, TSM, Oracle Gateway. NetApp Snap Manager for Oracle 3.x, CHEF

Operating Systems: Sun Solaris 8,9,10. RHEL 4.x, 5.x, 6.x, HP-UX 11, IBM AIX, Windows XP/2000/NT/98/95, DOS, CentOS 5.x

Database(s): Oracle, MySQL, PostgreSQL, SQL Server, SQLite, Vertica

Applications: Oracle EBS R12, ASCP, Demantra, OBIEE, SAP BO, WebLogic, Cloudera Hadoop, Tableau.

Languages: SQL, PL/SQL, C, C++, XML, JAVA, J2EE, UNIX Shell Scripting, Perl and Python Scripting, Assembly Language 8086.

PROFESSIONAL EXPERIENCE

Sr. Database Administrator/Lead

Confidential - San Mateo, CA

Environment: RHEL 5,RHEL 4,HP-UX B.11.11.11, Oracle 8i, 9i,10g,11g,12c, E-Business Suite 12.1.3, ASCP, OEM 10g,11g, 12c, NetApp SMO 3.x, Snap Vault, Snap Mirror, Commvault, NetBackup, Fog light, SQL*Plus, Toad, Xming, Putty, Shell, python. NetApp

Responsibilities:

• Installed up to 4node RAC on RHEL5, identified and resolved cluster issues during teh installation process.
• Created 11gR2 OLTP and Data warehouse Databases as per business requirements for Business applications like E-Business Suite, DSS and Data warehouse.
• Lead teh team during Oracle database upgrade project from 8i to 11.2.0.3, 11.2.0.3 to 11.2.0.4, 11.2.0.4 to 12.1.0.2 and during day to day support activities.
• Primarily Responsible for planning and managing system architecture that are required to install OBIA,ERP, Primavera, SOA,IDM,OIM,OBIEE, Web center and other applications.
• Primarily responsible in moving teh cluster and databases from Cisco’s M2 to M3 blades by Cluster Node “add and delete” methods to achieve minimum downtime to teh business and ensured teh stability of cluster.
• Worked closely wif development team to identify and troubleshoot teh performance issues of Database and tune application queries as per teh needs.
• Implemented suitable Table partition methods on huge tables based on teh usage to improve teh application design and enhance teh performance of Database and application.
• Involved in cross platform Database and application Migrations of 8i E-Business Suite database(s) having 11.5.10.2 on HP-UX to 11g wif R12.1 on Linux by following upgrade Matrix and recommended methods by Oracle.
• Performed multiple test cycles, refreshed database and Oracle EBS R12 application, automated teh data migration and cloning process to reduce teh risks and meet teh SLA during Go-Live.
• Participated in project cut over plans, validated, refined and automated DBA tasks.
• Performed thorough patch analysis of R12 application patches, applied offline and online patches based on teh analysis. Merged patches using AD Merge to minimize downtime.
• Implemented security measures, password verification functions,SHA-1 algorithm for apps password encryption and auditing for critical database applications like EBS R12.1, Data ware House, Demantra, ASCP, OBIA, and SSO as suggested by teh Integrigy and followed industry required standards by satisfying teh audit requirements.
• Added EBS R12 application nodes to minimize teh workload on teh existing Tier and configured load balancing using BigIP.
• Implemented shared appl top application systems and configured BigIP to Load balance mid-tiers
• Assigned responsibilities to users, created users, end-dated user/responsibilities based on teh application owner requests and SOX policies.
• Performed troubleshooting on all Tiers (Apache, Forms, Concurrent, Admin, Jinitiator and database)
• Automated shell scripts to monitor long running concurrent requests and address/troubleshoot issues accordingly.
• Cloned EBS R12.1 application Tier and database Tier to fix application, MEC issues and per business requirement using rapid clone and certified custom methods to reduce clone time.
• Performed extensive troubleshooting of Forms server, Reports server and Apache server, Jserv, Jinitiator and Workflows/mailer, Database.
• Supporting and maintaining 2 nodes Internal and 2 External DMZ R12 application having up to 4 node RAC databases.
• Applied product specific fix patches, family packs, maintenance packs using adpatch
• Applied rolling and Non rolling patches on RAC databases and R12 application servers
• Implemented Java Certificate Signing for EBS JAR files annually.
• Performed necessary oracle Apps Admin and sysadmin tasks.
• Used SVN for managing and version controlling of application code.
• Worked wif development team during RPD deployments/code migration and catalog deployments in OBIA/OBIEE application.
• Used Oracle Enterprise Manager 12c extensively to quickly identify teh hidden performance bottlenecks and through automated scripts.
• Performed necessary SQL Tuning on queries running poorly on database and impacting teh overall performance of teh system.
• Installed EBS R12.1 application on single and multiple node and enabled other components as per teh business needs on RHEL5.6.
• Performed regular cloning and refreshes of Database and application using oracle utilities like RMAN /Commvault / NetApp
• Applied quarterly CPU patches, one off patches on Database(s) and application(s) by proper analysis and completing pre-requisites.
• Addressed user login issues, navigation and performance issues of applications.
• Installed OEM 12c and upgraded OEM 12.1.0.1 to 12.1.0.2 and 12.1.0.2 to 12.1.0.3, applied necessary patches and Bug Fixes to address teh OEM related issues.
• Installed OATS for ensuring teh quality, scalability, and availability of you're Web applications, Web Services, packaged Oracle Applications and Oracle databases.
• Using Very Minimal downtime migrated Consumer Service’s business critical application Database Siebel using Data Guard.
• Automated daily jobs using shell script to manage and monitor proactively.
• Perform regular database health checks of teh Critical Oracle, MS SQL Server Database(s) and application(s), identify and resolve issues accordingly to minimize business impact.
• Capacity planning of databases and application TEMPhas been calculated to understand teh growth and usage of Memory and Hardware.
• Changed Character set from Western to UTF8 to support multiple languages as part of Database Migration required and resolved issues during character set conversion process.
• Performed database/schema/table refresh tasks during teh test cycles before moving to production to ensure teh performance and fix application/database bugs.
• Present weekly metrics to teh IT Management team regarding teh health and Performance of teh Database Instances and Infrastructure.
• Achieved teh Goals set by Management during each Fiscal Year to support teh business.
• Provide weekly, Monthly and quarterly performance statistics of all Database(s) to upper Management.
• Involved in meetings wif Application/Business and infrastructure team(s) for new/upcoming projects.
• Analyze teh risk and plan for better solution by working wif vendors and team members to provide business continuity of applications.
• Troubleshoot and resolve database integrity, performance and OS level issues, identify contentions, log shipping issues, etc.,
• Automated and scheduled Table Partition Maintenance tasks using PL/SQL and shell scripting to run every month.
• Implement best Workload Management in teh environment to reduce teh impact on users and daily ETL and other resource consumption jobs.
• Used Oracle and Unix Utilities like ADDM, AWR, ASH, SQLT, SQL Health Check, SQL Tuning Advisor, strace, vmstat, SAR, top to debug and troubleshoot performance issues.
• Used ADRCI utility to gather diagnostic information and worked wif Oracle Support through OWC sessions during generic errors reported in Database.
• Strong experience in using CommVault and NetApp’s Snap Manager for Oracle, Snap Mirroring and Snap Vault tool to take backups and Restore/Recover databases quickly and efficiently.
• Employed and scheduled RMAN backups for oracle databases by thoroughly understanding teh workload on teh server to minimize any performance issues.
• Installed and Managed Microsoft SQL Server 2008, 2012 for custom Business applications.
• Implement Heterogeneous database migration from Oracle to SQL Server using SQL Server Migration Assistant tool.
• Experienced in Managing Users, DB Security, Patching, Upgrading MSSQL Server 2008 and 2012 databases.
• Used Native tools like SQL Server Profiler, Database Tuning Advisor and Perfmon.
• Installed, Upgraded and performed necessary troubleshooting to address replication issues of Gloden Gate 11g and 12c.
• Implemented unidirectional Gloden Gate replication from oracle to oracle databases following teh best practices suggested by Oracle.
• Involved in capacity planning of oracle databases to forecast teh physical space and resource required for teh Database servers
• Addressed and resolved Gloden Gate issues like Extract/Replicat Hung, Mapping errors, startup, performance issues and other Extract or Replicat issues.
• Involved in end to end Datacenter 2 setup for Disaster Recovery purposes of Oracle Databases and Applications.
• Tuned teh performance of gloden gate Extract and Replicat processes using Gloden Gate performance parameters, tuning database(s), network bottlenecks and followed teh Industry Standard best practices.
• Trained by Cloudera and has good hands-on experience in Managing Hadoop Clusters.
• Involved during teh Design and building teh architecture of big data platform as per SIEA’s requirement.
• Extensive noledge and experience on Hadoop Components such as HDFS, Map Reduce, Spark SQL, Impala, Scala, Sqoop, Pig and Hive, Hue, Cloudera Manager, Oozie.
• Installed, Configured and Managed Hadoop cluster using CLI and through Cloudera Manager and implement fixes/issues if health of cluster is bad.
• Performed Partitioning, Bucketing and Indexing on Hive tables.
• Worked wif Cloudera to implement Cluster Tuning and best practices.
• Address configuration issues, bugs and Alerts from Monitoring tools such as Nagios, OEM, Splunk.
• Created separate stack in AWS cloud during Install of Chef Automate as part of POC.
• Used Chef Automation tool to deploy and automate codes per developer’s request.
• Uploaded New and Updated existing cook books to teh Chef Server.

Oracle DBA Consultant

Confidential -Wilmington, DE

Environment: IBM AIX 5.3,Linux, Solaris 10,Oracle 9i,10g,11g,OEM 11g,Teradata v13.1.0 SQL*Plus, SQL Developer, Toad, Xming, Putty, Shell Scripting, ASM, Peregrine, Enterprise change Management Systems, TSM, Veritas

Responsibilities:

• 24X7 on call Support for Prod and Non-Prod Databases for E-Business Suite and Data warehouse and DSS environments.
• Necessary Network requirements provided to Infrastructure team for Building teh 10g Grid Infrastructure on IBM AIX 5.3 and 11g Real Application Cluster Environment on RHEL5 as part of Cluster Build pre-requirements.
• Involved in storage planning by analyzing teh existing environment and its usage and suggested appropriate storage to teh critical Database(s), faster disks for redo and data files and slow disks for backups.
• Involved in doing a POC for migrating database(s) to AWS cloud, tested application and database performance, backup and recoveries.
• Implemented up to 6 nodes RAC for High Availability of Mission critical Databases of JPMC Card Services wif ASM as storage which are used for heavy reporting purpose on day to day basis.
• Performed quarterly and one-off patching on ASM, Database, and Grid Infrastructure home wif proper patch analysis before applying.
• Performed end to end testing in lower environments before moving to production, resolved performance issues and application bugs to ensure application and database availability.
• Collaborated wif respective Application teams to find teh impact and to get suitable downtime from teh business and performed complete sanity check and performance of oracle RAC Database(s) after migration.
• Followed Best practices recommended by Oracle and Maintained production run book and documentation as per Industry standards of JPMC during environment setup.
• Implemented 10g and 11g Data Guard for RAC databases residing on HP-UX, RHEL servers as Disaster recovery solutions wif standby at DR site.
• Cloned production database(s) RAC to RAC, RAC to Non-RAC, Non-RAC to RAC on to lower environments for fixing bugs and application performance testing.
• Involved in setting up DR site from teh scratch and performed necessary testing before actual implementation in production.
• Involved in annual DR drill of Database and applications by performing failover from DR site1 to site2.
• Took teh ownership of startup issue, performed troubleshooting and fixed issue during teh Disaster of critical database and been applauded by several DBA Teams and Higher Management of JPMC.
• Tested and implemented teh fastest Migration process using Gloden Gate 10g wif Minimum downtime.
• Primarily responsible for Maintaining and supporting Business Continuity Application Databases.
• Implemented Oracle Gloden Gate to enable Business continuity plan and faster replication of data.
• Used Gloden gate 11g for migration and replication of databases to maintain zero downtime during disaster recovery or during planned maintenance.
• Followed Enterprise change management process to move teh changes in production after successful implementation in Dev/Test/QA/UAT environments.
• Automated Table Partition Maintenance tasks using PL/SQL and shell scripting which are scheduled run weekly and monthly.
• Created ECM’s, WRM and maintaining good customer Relationships, maintained SLA’s in teh environment.
• Peregrine ticketing tool used to resolve teh tickets logged by users.
• Supported Regular day to day Database activities to ensure DB and Application availability round teh clock.
• Supported Teradata v13.1.0 Database during Migration of 64Tb Oracle database.
• Automated Shell Scripts for Daily jobs and for Monitoring.
• Installed and configured OEM for Monitoring.
• Scheduled RMAN backup, configured backup policies by working closely wif NetBackup and Tivoli teams for Retentions
• Managed Pager Rotation in teh Team for On-call Support.