PROFESSIONAL SUMMARY:

• Database Consultant with 10+ years of experience in Database Administration on Oracle 12c/11g/ 10g, RAC, 9i versions in different environments like RedHat Linux, Windows, Confidential - AIX, Sun Solaris Sparc/X86.
• Mid-level experience as Oracle E-Business Suite (EBS) Apps DBA (R12 - 12.2) . Installation 12.2.0, patching, cloning and upgrade (to 12.2.5) of Oracle E-Business Suite on Linux platform.
• Mid-level experience as SQL Server 2008, 2012 and 2014 Database Administration with SQL Always ON 2014 High Availability solution.
• Installed oracle 12c/11g/10g/9i databases on AIX, SOLARIS, LINUX, and upgraded databases from 9i to 10g & 11g, 10g to 11gR1 & 11gR2 versions and 11gR2 to 12cR2 .
• Installed Hadoop v2 on 4 node cluster and setup jobs to pull data from RDBMS - Oracle into Hadoop using SQOOP utility.
• Having experience on setting up Hive to query from Hadoop using HiveQL and apply aggregation using MapReduce jobs.
• Having experience on setting up end to end IT infrastructure on Amazon Web Services (Amazon EC2), creating Linux instances, Load Balancers, using elastic storage, network, security groups etc…
• Beginners to mid-level experience in NoSQL database MongoDB Administration. Installation, backup, recovery using mongodump/restore and data management using utilities like mongoexport/import.
• Strong experience in managing and applying security patches i.e. CPU, PSU on standalone and RAC-one database servers of 9i, 10g, 11gR1, 11gR2 and 12cR1 using OPatch and Autopatch.
• Good experience with application of Service Packs, Cumulative updates (CUs) on SQL Server.
• Good experience in implementing database security features like profiles, roles, privileges, auditing, Security Scan (Qualys) and vulnerability and compliance management using Archer GRC tool.
• Expertise in manual and automated database installation.
• Worked on GRID Infrastructure, CRS management and Real Application Clusters (RAC) in Oracle 10g, 11gR2 and 12cR1.
• Worked as Database tower lead to design, create, manage, support and enhance large databases for applications running in parallel phases such as development, system & regression testing, and production.
• Also, have experience with people management leading team of 10+ DBAs who were from mid to senior experience level.
• Ability to handle multiple projects with deadlines to meet SLAs and have good coordination skills with management, application development teams, vendors, systems administrators and other IT infrastructure management teams.
• Worked in tandem with developers as logical DBA to implement and maintain the database design, create database objects, promote data model releases to various environments and monitor application related jobs and data replication activities.
• Installed oracle software for Database, RAC, Dataguard in primary and DR sites.
• Experience in Disaster Recovery (DR) Setup, DR simulation and DR Drill using Dataguard, VMWare replication-Zerto, storage based replication-EMC Recover Point.
• Installed Oracle Agent 12c and 12c, configured database in Grid/Cloud Control. Worked extensively on Oracle Tools like OEM Cloud Control and Monitoring through 12c/13c cloud control.
• Proficient in shell scripting using AWK, SED like utilities.
• Experience with WebLogic administration
• Designed strategic and tactical solutions for database capacity planning, scheduled database refreshes, backups and formulated recovery processes using RMAN, Flashback, Data Pump, HOT/Cold methods, Export/Import and Database Cloning using 3rd party backup solutions like Tivoli Storage Manager, EMC Data Domain.
• Knowledge on Automatic Storage Management (ASM) administration, ASMCMD.
• Responsible for analyzing and tuning the performance of bad applications queries using Stats Pack, AWR and ADDM and well versed with utilities such as Explain Plan, TKPROF, SQL Trace, SQLT and Auto trace.
• Expertise experience in Golden gate, GGSCI usage, Manager, Extract, Pump & Replicate process. Used Golden Gate for database migrations and upgrades with minimal downtime.
• Experience in using Transportable tablespace for cross platform database migration.
• Experienced in using My Oracle support, raising SR, downloading patches, database patching, upgrades, and updates.
• Good managing and reporting skills, task allocation to resources and tracking the progress on daily & weekly basis.
• Sound knowledge of ITIL process - Incident Management, Change Management and Problem Management used in IT Service Delivery.
• Extensive experience in interaction with clients, excellent verbal and written communication skills and quick learner.

TECHNICAL SKILLS:

Operating System: AIX, Solaris, Linux, Windows

RDBMS: Oracle 12c, 11gR2, 11gR1, 10g, 9i . Microsoft SQL Server 2008/2012/2014 .

NoSQL Database: MongoDB 3.2

DB Tools/utilities: SQL loader, OUI, DBCA, DBUA, ASMCA, ASMCMD, EMCLI, GGSCI, OEM, NETCA, TOAD, DBArtisan, SQL Developer, Oracle Enterprise Manager 12c/13c cloud control, SQL Server Management Studio, SQOOP, Hive, ADOP, ADPATCH, ADCFGCLONE, ADPRECLONE, Oracle Designer

High Availability: Oracle Clusterware, RAC 11g/10g, Data Guard, SQL Always ON, Hadoop Distributed filesystem

Tuning Tool: Stats Pack, AWR, ADDM, Explain Plan, SQL trace, Auto trace, TKPROF, SQL Management Datawarehouse, NMON, TOPAS, TOP, VMSTAT

Backup Tool: RMAN, Data Pump, Hot/Cold, Cloning with RMAN, Export/Import, Mongoexport, Mongoimport, Mongodump, Mongorestore, SQL Server DB Backup and Restore

Infrastructure Tools: VMware Vcenter, PowerCLI, LDAP, Domain Controller, Amazon AWS command line interface on Windows and Mac, CyberArk

Oracle Products: Oracle E-Business Suite R12 12.2, Oracle WebLogic 10.3.6

Scripting: Shell, DOS, Perl, SQL, PL/SQL, T-SQL

PROFESSIONAL EXPERIENCE:

Confidential, Tulsa, OK

Consultant and Database Platform Lead

Responsibilities:

• Installed, configured, maintained and tuned Oracle 11g/12c databases, for development and production environments.
• Installed and Configured Oracle 11g and 12c with ASM setup.
• Implementing and maintaining RAC and Dataguard instances
• Database upgrades to 12c and database migrations cross platform.
• Configured and monitored various databases using OEM Cloud Control.
• Extensively used Oracle utility Recovery Manager (RMAN) to implement Oracle backup and recovery.
• Designing the Oracle backup strategy, scheduling and implementing database backup and restoration using Import/Export, hot backups, cold backups and data pump utilities.
• Experience in taking incremental and cumulative backups in daily and weekly using EMC Data Domain.
• Planning, scheduling database patches across Oracle (SPU and PSU) on RAC and non-RAC environments.
• SQL Servers (Service Packs and Cumulative updates) patch management.
• Performed databases cloning manually using scripts and Recovery Manager (RMAN) for QA Testing team, application team and for developers
• Performed databases cloning manually using storage cloning technology using EMC VMAX
• Performed Capacity planning, capacity monitoring and management
• Tuning and optimizing current and new applications using SQL Trace utility and DBMS package, and enhancing performance through regeneration and rebuild of indexes and creation of views.
• Managed users and security of database as per business requirements
• Trouble shooting performance issues using Explain Plan, TKPROF, STATSPACK, AWR, ADDM, SQLT and other infrastructure tools like VMWare Vcenter
• Monitored the database, table space management and sizing of objects and space utilization in database using shell scripts.
• Performance monitoring and Database/Instance/RAC tuning using Dictionary views, AWR, Stats pack, ADDM, ASH reports, OEM Grid Control
• Working with Oracle support to resolve like ORA errors issues
• Work on database audit, security governance, compliance, and regulatory requirements
• Documenting, testing and implementing Disaster Recovery plans

Environment: Oracle 9i, 10g, 11g, 12c GRID Infrastructure, RAC, Dataguard, OEM 12c, SQL Server 2008/2012/2014, SQL Always ON

Operating System: AIX 6/7, Solaris 10, Linux 6

Confidential

Consultant and Database Platform Lead

Responsibilities:

• Installation of Oracle EBS Vision R12 12.2 instance for proof of concept
• Upgrading EBS 12.2.0 to 12.2.5
• Applying and testing tech stack and AD patches using ADOP
• Cloning EBS instance using Rapid Clone
• Installing MongoDB 3.2 Enterprise edition on CentOS, implementing backup, recovery setup
• Testing CRUD operations on MongoDB instance
• Installation of 4 node Hadoop Cluster v2 on Linux, creation of Hadoop Distributed Filesystem (HDFS )
• Testing MapReduce jobs on dummy Datasets
• Data integration between Hadoop and Oracle 11g RDBMS using SQOOP
• Testing Hive installation and test queries on datasets on HDFS
• Hosting Web app on Amazon Web Services using Load Balanced App server on EC2 instance, MySQL DB on AWS-RDS, using Elastic storage, security group policies and auto scalable infrastructure
• Installation of Oracle WebLogic 10.3.6, creation of Domain, Admin server and Managed servers. Deploying of test application.

Confidential

Lead Oracle DBA

Responsibilities:

• Worked on Europe’s largest System integration projects of that time
• Oracle logical and physical designing (Data modelling)
• Getting database change requirement from application development team
• Creating Entity Relationship designs
• Converting logical ERD into physical designs
• Creating DB objects creation scripts from physical designs
• Batch jobs development
• Writing ETL jobs using Shell scripts and Oracle PL/SQL. PL/SQL functions, procedures, and packages development for frontend APIs
• Developing PL/SQL programs use to call by application APIs to retrieve data from database
• All business logics were implemented in these programs.
• Installed, configured, maintained and tuned Oracle 10g, 11g databases on RAC and standalone environment
• Installed and Configured Oracle 10g and 11gR2 with ASM setup.
• Configured and monitored various databases using OEM Grid Control.
• Extensively used Oracle utility Recovery Manager (RMAN) to implement Oracle backup and recovery
• Implemented replication using Golden Gate
• Maintaining Data integrity, Password Security and Resources
• Managing Users/Schemas and its privileges and roles
• Implementing database auditing and managing it
• Loading data in various formats in Database using SQL*Loader, Direct Load(Serial/Parallel)
• Proof of concepts on Oracle Architecture/Oracle Net Architecture
• Disk space management, user profile creation and user rights management
• Database tuning, performance monitoring and troubleshooting
• Resolutions of database startup problems and database objects reorganization (Index rebuild and Table reorg)
• Managing Datawarehouse environment viz. Performance tuning, designing materialized view and its refresh types
• Advising Developers on SQL Query tuning
• Coordinating with Unix Teams for Server configuration changes (i.e. Pre/Post Installation
• Tasks/Kernel Parameter/OS Memory Tuning) Apply security patches (SPU/PSU) and bug fixes on databases and Grid Infrastructure
• Coordinate with Onshore and Offshore team members
• Reporting to client, Onsite Project Manager

Environment: Oracle 9i, 10g, 11g, GRID Infrastructure, RAC, OEM 11g, Dataguard

Confidential

Lead Administrator

Responsibilities:

• Providing L1, L2 support for Sybase ASE Databases.
• Installation of Sybase Adaptive Server (Data server/ Backup Server)
• Starting and Stopping server using RUNSERVER file
• Managing Interface files using dsedit utility
• Monitoring and configuring server configuration parameters (memory etc.)
• Initializing, resizing, mirroring, re-mirroring and dropping devices
• Creating /Dropping databases, its capacity planning and setting Database Options
• Managing Database disk space (data & log) with respect to fragmentation and growth
• Creating and dropping free space thresholds
• Managing TEMPDB
• Managing System roles and logins
• Administering Database access, users and implementation of object permissions through groups and roles
• Performing data movement using BCP utility
• Performing DBCC on databases on daily and weekly basis and fixing any database inconsistency
• Planning and performing backups
• Perform periodic Database server and Backup server health check
• Proactively monitoring block errors, long running transaction, logsuspends
• Managing database auditing; validating programmer proposals for SQL logic
• Performing DR testing on the critical servers on periodic basis

Environment: Sybase 12 Adaptive server Enterprise (ASE), Sybase 15 ASE, Sybase replication server, Oracle 9i/10g

Confidential

Database Administrator

Responsibilities:

• Implementing backups (hot & cold back-ups) along with disaster recovery, exporting / importing.
• Perform periodic Database health check
• Databases, monitoring procedures, and ongoing support.
• Preparing Backup/Recovery plan and its implementation.
• Performing User managed backup/recovery (Complete/Incomplete).
• Performing backup/recovery using Oracle RMAN (Complete/Incomplete).
• Creation / Maintenance of RMAN catalog Database.
• Performing database cloning using RMAN.
• Managing Oracle Application server 10g, deploying Forms and Reports

Environment: Oracle 8i/9i/10g, Oracle Application Server 10g