SUMMARY:

• Oracle Database Installation, configuration, maintenance, Production support.
• Involved with installation and maintenance of ORACLE 11g RAC.
• Oracle Database 12C Administration.
• Applying AD Patch, CPU Patch, Troubleshooting if any errors.
• Cloning Oracle Applications and Databases between DEV,UAT,CAT and Production Environments.
• Monitoring Concurrent Manager and troubleshooting.
• DBA on Call, 24X7 Production Support.
• Troubleshooting the EBS Application issues related to OACORE,APACHE,adcmctl,adforms etc.
• Experienced in adpatch, adadmin, adctrl utilities for oracle applications.
• Creating, Updating, Altering Tablespace, Indexes, Tables, Views, Synonyms, Profile, Role,Privileges.
• Configuring and Monitoring Database backup and performing backup validations
• Monitoring all Database Metrics using Oracle enterprise manager 11g,12C.
• Implemented AWS solutions using EC2, S3, RDS, EBS, Elastic Load Balancer, Auto scaling groups,AWS CLI.
• Working on AWS Services like IAM,Security groups,AWS Snapshots and creating volume from the snapshots, DNS configuration in Route 53(DNS load balancer), Cloud Watch Monitoring.
• Configuring OEM agent and discovering targets, Assigning the pre - defined templates.
• Troubleshooting Agent and OEM issues.
• Experience in Oracle Forms and Reports.
• Knowledge on ASM.
• Having sound knowledge on Oracle Database Architecture.
• Good knowledge on shareplex.
• Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, AWR and ADDM.
• Experience in supporting multiple DBMS platforms such as Oracle 9i,10g,11g,12c,DB2.
• Good experience in understanding of database architecture and strong in UNIX.
• Experience in installing & configuring Solaris Zones, Containers & Branded Zones on Solaris 10.
• Experience in Implementing and Supporting High Availability Cluster environments usingVeritas Cluster Services.
• Installation and configuration of Oracle and MySQL Database on Unix Servers.
• Installation and configuration of Oracle RAC ASM using multipath software on RedHat cluster nodes.
• Experience into the configuration management tools like Chef,Puppet and Ansible.
• Experience in installing, configuring, supporting and troubleshooting Unix/Linux Networking services like NIS, LDAP, DNS, NFS, DHCP, FTP, SSH and SAMBA.
• Creating and Managing user accounts, system security, performance tuning, change management,Documents and procedures.
• File system management on Red Hat Linux and Solaris servers using LVM/SVM/ZFS utilities.
• Experience in compiling and tuning the Linux Kernel on database servers.
• Managed packages using RPM/YUM on Red Hat Linux and maintaining patching on Solaris servers.
• Installed and Configure Java (JDK) tools on the servers.
• Good knowledge on JVM.
• Installed and configured the complete LAMP on the VMs and also have very good knowledge on
• Single Sign on Authentication with Siteminder and LDAP implementation on middle ware servers for multiple applications.
• Resolving system errors and crashes, huge file sizes, file system full errors.
• Installing network Printers and rectifying the printer problems over the network
• Good experience with Audit control and Compliance management on the Linux infrastructure using ESM and Symantec Audit control tools especially on PCI implemented servers.
• Experience in configuring the Networking and protocols such as TCP/IP, Telnet, ftp, SSH, rlogin
• Familiarity with ITIL concepts and services, specifically change control, incident management, service delivery, problem management, and knowledge management.
• Problem determination and troubleshooting, Security using SSH.
• Experience in database version upgrades and cross-platform migrations to Linux Environments.
• Performing hot backup, cold backup refresh of databases, Ensuring proper online and offline backup, periodical reading and checking of backups taken.
• Database backups and recovery using User managed backups (Cold & Hot).
• Database backups and recovery using RMAN.
• Database Cloning (Manual and RMAN).
• Managing and scheduling jobs in Crontab.
• Performed the Database Masking at Table level.
• Database refresh using Export/Import & Data pump.
• Good Knowledge and Administration of RAC Resources using ‘srvctl’ utility.
• Hands on experience in Installing GRID and RDBMS,Creating Databases of 10g & 11g.
• Well versed in Unix,Linux Operating system, Oracle Database.
• Create Service Requests and Follow up with the Oracle for Technical Support
• Excellent communication, problem-solving, interpersonal, organizational skills.
• Good Experience in supporting application teams in development/testing environments

TECHNICAL SKILLS:

Operating Systems: Windows 2000/NT/XP, UNIX, LINUX, Sun Solaris,Ubuntu

Languages: SQL, PL/SQL, shell script,C,PythonDatabases: Oracle 9i,10g,11g,12C,SQL Server,MongoDB

Oracle Applications: 11i,R12,Oracle EBS

Tools: Oracle Enterprise Manager 11g/12c,RMAN,Export/Import,Golden Gate, Datapump,Dataguard SSH, Putty, SQL Developer, FileZilla,Toad etc

Certifications: Oracle Certified Associate(OCA) in 11g, ITILV3 Foundation

AWS Cloud: IAM,Security groups,AWS Snapshots and creating volume from the snapshots, DNS configuration in Route 53(DNS load balancer), Cloud Watch

WORK EXPERIENCE:

Confidential, Schaumburg, IL

Oracle Applications DBA/ Oracle DBA

Environment: RMAN,EXPDP/IMPDP,RAC,ASM,AWR,TKPROF,SQL/PLSQL,Windows, Netbackup,OEM,Toad,Unix,Red Hat Linux

Responsibilities :

• Managers and processes, Patching, User management issues and space management issues related to Oracle Applications
• Have troubleshooted and fixed the Concurren issues
• Analyzed and applied various CPU patches, PSU patches etc.
• Created new instances using Rapid clone (DEV/QA/PATCH Instances).
• Expertise working on oracle 11gR2 RAC, 12C environment
• Experience in Real Application Cluster environment (RAC) with ASM and file systems
• Monitor and Schedule backups.
• Database Refresh using Recovery Manager.
• Logical Backup using Data pump.
• Generated Statspack/AWR reports from Oracle 10g/9i database and analysed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth
• Resolve Tickets on daily basis.
• Expertise in OracleGoldenGate installation, configuration, troubleshooting Confidential issues.
• Experience in using Confidential in moving large volumes of transactional data, with minimal impact to online systems.
• Knowledge of theOracleGoldenGate installation, configuration, troubleshooting GG issues
• Expertise in Oracle Golden Gate software.
• Job scheduling using cron utility and Shell Scripting for automating DBA tasks.
• Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements
• Provided tuning recommendations and future memory requirements to Primary DBA team to make the changes in Database like table reorg, add enough spaces to database
• Created a purge script to remove more than one year old data
• Hands on Docker Images,Containers,Network,Volumes,Dockerfile,Docker Compose,Link,Swarm,Registry.
• Administration and Monitoring of RAC nodes.
• Monitoring tools by using nagios,Splunk,Zabbix etc.
• Monitoring of databases using OS Scripts and OEM.
• Pro-active monitoring of database by analyzing AWR reports.
• Installed and Maintained OEM Agents 11g to monitor the Databases.
• Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible.
• Monitored the production Oracle alert logs for database errors.
• Applying Application Patches, Databases Patches, Troubleshooting if any errors.
• Cloning Oracle Applications and Databases between DEV and Production Environments.
• Creating modifying and maintaining file system on Redhat and Solaris servers
• Creating root disk mirroring using zfs file system on Solaris servers
• Creating root file system mirroring on Solaris servers
• Configuring NFS on Solaris and Linux(Redhat) servers
• Hands on TCP/IP networking knowledge with IPV4/V6.
• Knowledge on Security concepts such as data encryption, TLS, key management, and permissions management.
• Updating patches /kernel on Solaris /Linux servers to avoid vulnerabilities
• Installing / Configuring Storix backup software in Linux servers
• Building Oracle RAC cluster nodes in Linux
• Installing VERITAS volume manager on Solaris servers
• Creating vxfs file system on Solaris and Linux servers.
• Experienced in Oracle Application R12 utilities like adctrl,adadmin etc.
• Creating Users,Adding Responsibilities,Monitoring managers from Application end.
• Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, AWR and ADDM
• Analyzing the long running queries and communicating the information to end users.
• Experienced in SQL,PLSQL and Unix shell scripting.
• Job scheduling using OEM/crontab.
• Managing daily and weekly scheduled backups.
• Involved with installation and maintenance of ORACLE 11g RAC.
• Creating Users, Roles and Managing Security & administration.
• Handling escalated issues and Change management issues.
• Consistently interacted with client and team in resolving various queries/issues.

Confidential , Pleasanton, CA

Oracle DBA/ Oracle Apps DBA

Environment: EXPDP/IMPDP, RMAN, ASM, RAC,Backup, AWR,Crontab,Linux,Database

Responsibilities :

• Interacting with the client for requirement gathering and detailed understanding of the functional aspects.
• Involved in Resource and Time estimation for creating/Installing Dev and Prod Database servers.
• Involved in PL/SQL and UNIX shell scripting and automating them using Cron Utility.
• Preparing the server provisioning sheet based on client requirement.
• Monitoring Concurrent Managers & its operations like starting, stopping the concurrent managers & Troubleshooting problems, resolved the view log/out files issues of concurrent requests.
• Applying patch on Applications using Adpatch utility on Patch instance
• Oracle Applications Utilities like AD Administration, AD controller, Autoconfig, AD Relink, Auto Patch, f60gen and managed passwords using FNDCPASS.
• Maintenance of File System and taking appropriate backups for security and consistency.
• Performed research for patches for specific problems and downloaded Patches. Done Patch analysis, applied Patches (one-off, mini-packs) and checked the Patch impact, Managing Patch history till go-live.
• Reduced the timelines of patching using features like defaults file and merge patch.
• Troubleshooting several worker issues while patching.
• Monitoring table spaces for space usage and adding required space whenever it reaches threshold.
• Validating the new server for Oracle Installations and fixing the issues by working with Unix team.
• Installation and Creation of databases for new Development and Production environments.
• Creation of oracle users, oracle roles, granting privileges and profiles etc.
• Creation of Table spaces, data files and assisted Application team while configuring the application.
• Monitoring, troubleshooting & reporting daily backup status for all critical production UNIX servers enterprise-wide.
• Administered Linux servers for several functions including managing Apache server, mail.
• Installed and configured Sudo for users to access the root privileges.
• Cloning Oracle Databases between DEV,UAT,CAT and Production Environments.
• Creating, Updating, Altering Tablespace, Indexes, Tables, Views, Synonyms, Profile, Role, Privileges.
• Configuring and Monitoring Database backup and performing backup validations
• Monitoring all Database Metrics using Oracle enterprise manager 12C
• Monitoring Alert log and User trace files for errors.
• Migrating the required Databases/Schemas from Old environments.
• Performing Logical Backup of Databases using Data-pump Utility for Tables, Table spaces and Full Databases
• Configuring RMAN backups to tape and scheduling the cronjobs.
• Configuring OEM agent and discovering targets
• Managed table spaces, resizing and adding new, monitoring database growth.
• Automating schema backups by using Data pump scripts.
• Scheduling the cronjobs for Housekeeping activities of Archive logs and Trace files.
• Daily Health Check of the Database (OEM Reports)
• Performed schema refreshes during testing.
• Monitoring the operating system response in terms of CPU usage, disk space etc.

Confidential

Oracle Apps DBA/ Oracle DBA

Environment: Cloning, Datapump, EXP/IMP, ADPATCH, OPATCH, RMAN, OEM, Linux

Responsibilities :

• Physical cloning of database and oracle ebiz apps from production to QA, Dev, PET environment.
• Controlling and monitoring the user access to the database.
• Monitoring alert log and trace files for errors.
• Managing Import/Export depending upon requirement.
• Hot/Cold Backups of database.
• Unix Shell scripting in ksh for automating backup and recovery, Import and export procedure of databases, getting system alerts.
• Resolving user issues and performance issues due to high CPU usage.
• Configuring listeners and tnsnames.ora files.
• Applying application and database patches in Prod, QA, Dev, PET environment with adpatch and opatch utility.
• Deploying database related codes in oracle apps.
• Monitoring database and application related alert like DB locks, concurrent manager, Workflow mailer issues, application server swap issues.
• Bring down oracle ebiz application and related database during data center move and during network change.
• Performed Failover operations/DR in Data Guard Environment.
• Refreshed the test databases with production data.
• Troubleshoot application failures including performance and database connectivity problems and job failures.
• Managed the SGA, db buffers, shared SQL area, and log buffer based on the requirements.
• Cloning Oracle Databases between DEV,UAT,CAT and Production Environments.
• Creating, Updating, Altering Tablespace, Indexes, Tables, Views, Synonyms, Profile, Role, Privileges.
• Configuring and Monitoring Database backup and performing backup validations
• Monitoring all Database Metrics using Oracle enterprise manager 12C
• Monitoring Alert log and User trace files for errors.
• Migrating the required Databases/Schemas from Old environments.
• Performing Logical Backup of Databases using Data-pump Utility for Tables, Table spaces and Full Databases
• Configuring RMAN backups to tape and scheduling the cronjobs.
• Configuring OEM agent and discovering targets
• Managed table spaces, resizing and adding new, monitoring database growth.
• Automating schema backups by using Data pump scripts.
• Scheduling the cronjobs for Housekeeping activities of Archive logs and Trace files.
• Daily Health Check of the Database (OEM Reports)
• Performed schema refreshes during testing.
• Monitoring the operating system response in terms of CPU usage, disk space etc.
• Experienced in adpatch, adadmin, adctrl utilities for oracle applications.

Confidential, Miami,FL

Oracle Apps DBA/Oracle DBA

Environment: Crontab, Oracle 11g, OEM, Oracle RAC, Bakcups, ADCTRL, ADADMIN, R12

Responsibilities :

• Monitored the production Oracle alert logs for database errors.
• Controlling and monitoring the user access to the database.
• Monitoring alert log and trace files for errors.
• Managing Import/Export depending upon requirement.
• Hot/Cold Backups of database.
• Resolving user issues and performance issues due to high CPU usage.
• Configuring listeners and tnsnames.ora files.
• Applying Application Patches, Databases Patches, Troubleshooting if any errors.
• Cloning Oracle Applications and Databases between DEV and Production Environments.
• Experienced in Oracle Application R12 utilities like adctrl,adadmin etc
• Resolve Tickets on daily basis.
• Monitor and Schedule backups.
• Prepared backup strategy and disaster recovery management of the databases by using in-house tools written using UNIX Shell Scripts.
• Database Refresh using Recovery Manager.
• Logical Backup using Datapump.
• Administration and Monitoring of RAC nodes.
• Monitoring of databases using OS Scripts and OEM.
• Pro-active monitoring of database by analyzing AWR reports.
• Installed and Maintained OEM Agents 11g to monitor the Databases.
• Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible.
• Creating Users,Adding Responsibilities,Monitoring managers from Application end.
• Analyzing the long running queries and communicating the information to end users.
• Job scheduling using OEM/crontab.
• Managing daily and weekly scheduled backups.
• Involved with installation and maintenance of ORACLE 11g RAC.
• Creating Users, Roles and Managing Security & administration.
• Handling escalated issues and Change management issues.
• Consistently interacted with client and team in resolving various queries/issues.
• Coordinated with UNIX and storage team for server migrations.
• Responsible for Backup and recovery of the databases using RMAN Tool (Recovery Manager), and Database Flashback using GRP (Guaranteed Restore Point).
• Installed and configured ORACLE Enterprise Manager to manage databases
• Upgrading the database to version 11g from 10g and 9i on RHEL 5.8
• Backed up and Recovered of the Oracle Database and Archive logs using RMAN; configure and restart backups or restored if needed.
• Installation of Oracle 11gR2 Grid infrastructure and Oracle Database.
• Performed Daily Monitoring of Oracle Instances, monitored users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Participating in 24*7 production on-call support routine and Working with Oracle Support.