SUMMARY

• Oracle DBA professional with over 12+ years of progressively strong experience in Oracle Technologies under Solaris, Linux, AIX, HP - UX, and Microsoft Windows.
• Expertise in installing, maintaining, and administering Oracle Database 9i,10g, 11i, 12c, 19c.
• Involved in application upgrades with Oracle Database Installations/Upgrades (10g, 11g, 12c).
• Worked on most of the Application modules like Oracle Manufacturing (INV, PO, OM and BOM)
• Specialization in administering RAC Databases, OEM, Grid Control and working in high availability environment in UNIX setup.
• Monitoring long running jobs and eventually solving them by working closely with the application development team, query tuning (sqltrace, tkprof, explain plan) and troubleshooting performance related issues by tuning.
• Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.
• Experience in installing various versions of PostgreSQL database on different platforms like Google Cloud .
• Good knowledge & experience on Cloud Computing like Azure/AWS
• Hands on experience in maintaining the RAC environment with 11i and R12.
• Database Recovery using Hot & Cold Backup, RMAN.
• 24/7 Production Database Support and maintenance.
• Expertise in performance tuning using Stats pack, TK prof, OEM (Oracle Expert, SQL Analyzer) and Quest TOAD as well as performance tuning of Java based, .Net and Oracle Apps (Concurrent Manager, Server and client).
• Affected performance-tuning using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Expert in configuration and administration of Oracle 10g AS, OID, 10gAS Portal, and Oracle Vault.
• Experience on implementing Middleware Fusion and OBIEE.
• Excellent knowledge in installation and maintenance of Oracle Application Server.
• Well versed at Unix operating System and Confidential Scripting.
• Good understanding and hand-on experience with Oracle Discoverer under Oracle11i Applications.
• Experience implementing Oracle Enterprise Data Quality (ODEQ), Oracle Grid Control, Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Data Integrator.
• Cloud expertise on AWS, AZURE and other public Cloud platforms.
• Excellent knowledge in Maintenance and configuration of the oracle DB on AWS,GOOGLE and Azure platform.

TECHNICAL SKILLS

ERP: Oracle E-Business Suite R12: 12.2.4/12.1.3/12.0.611 i: 11.5.10.2.

RDBMS: PostgreSQL 13, Oracle Server EC2, RDS, 9i, 10g/11gR1,11gR2,12.1,12.2, 18c and 19c for Sun Solaris, Linux, AIX, HP-UX Oracle Linux 6, AWS, AZURE, MSSQL 2016, Sybase.

Operating Systems: RHEL4AS, RHEL7.5, Sun Solaris 2.6/2.5.1(SUN OS 5.5.1), AIX, HP-UX, Windows-XP/2000/7/8,12 and Linux env.

Languages: SQL/ PL/SQL, UNIX Confidential Programming (Bornshell, Csh, Ksh) Crontab.

Software Tools/ GUI: Oracle Developer2000, Oracle Enterprise Manager (OEM), Oracle Applications Manager (OAM), SQL*Plus and TOAD, TKPROF, STATSPACK, SQL loader, Export/Import Utility, Gluent,PGADMIN

Application Servers: Oracle 10g/9ias R2.

Others: Win SCP, FTP, Putty, Exadata.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. Oracle DBA

Responsibilities:

• Experience as a DBA designing & supporting Oracle 10g/11g/12c/19c databases in a large-scale (200+ servers) in a UNIX, Linux environment
• Created and Managed Production database as well as Development/Test environments using tools like Oracle Enterprise Manager (OEM).
• Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.
• High level understanding of RDBMS concepts as well as Data Modeling and Azure SQL concepts.
• An experienced IT professional with 5.5 years in Oracle,SQL database administration and experience in managing Azure (IAAS & PAAS) databases.
• Managing around more than 30 Virtual Machines in IAAS & SQL Servers and 100 databases on PAAS, supporting max size of 8 TB hosted in Microsoft Azure and AWS.
• Having experience in Migrating on Premises SQL Databases to SQL Azure using DMA & DMS(Offline & Online).
• Having experience in configuring Virtual machines using Azure portal.
• Having experience in creating the alerts for VMs using Azure Portal.
• Reviewing the Activity logs and troubleshooting the errors.
• Experience in working with Azure SQL, Oracle Database Import and Export Service.
• Experience in working with Point in time restores in Azure.
• Helped to tune the pipelines SQL’s for the Datafactory projects .
• Experience in upgrading oracle DB from 11G (11.2.0.4 ) to 19.11 version and fixed the various bugs and performance issues .
• Configured Long Term Retention (LTR) backups for Mission critical databases.
• Configured on-premises Sql,Oracle database backups to Azure using Microsoft Azure Backup tool and Export Import Dumps.
• Creating logins, users and assigning the permissions to the users in Azure.
• Configured Active Geo Replication, Failover Groups using Azure portal.
• Monitoring the alerts using the Operations Management Suite (OMS) in Azure portal.
• Studied and stayed current on features and functionality of PostgreSQL.
• Installing and configuring nagios check postgresql.pl plugins for Monitoring PostgreSQL instances effectively.
• Proactive in updating the latest security patches to database, which are provided by PostgreSQL open source community.
• Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.
• Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases.
• Assisted in designing and management of PostgreSQL database schemas and tables.
• Plans and coordinates the administration of PostgreSQL databases to ensure accurate, appropriate, and effective use of data, including database definition, structure, documentation, long - range requirements, and operational guidelines.
• Performance tuning of Oracle Database (Memory tuning by altering PGA and SGA values)
• Application tuning and the suggested a correction in application design and code.
• Designed a deployment solution for the vendor which helped them reduced the deployment time by 80%.
• Designed a backup monitoring solution for the Sybase instances which helped them to comply the IRM standards.
• Configuring and implementing Oracle ASM on UNIX, Linux, and Windows platforms.
• Applying PSU Patches and interim patches whenever required to make the database software up to date.
• Worked on AWS DMS for Migrating Oracle databases.
• Worked on S3 buckets and Cloud trails to monitor logs and backups.
• Worked on AWS Oracle databases for App migration into private cloud.
• Worked on AWS Database Migration Services for migrating data from Oracle to RDS.
• Supported Main DBA functions in RDS and documenting in confluence page.
• Configured and installed, involved using AWS services such as EC2, Data Pipeline, S3, RDS and EMR. Architecting new DBA solutions in AWS.
• Worked on FGA for new RDS Oracle databases and created IAM policies to the users.
• Automated RMAN Backups, Data pump, cloning, space management, database security, cloning, migration, AWS DMS, AWS KMS, AWS IAM, AWS ADG, AWS RAC, AWS RDS, AWS EC2 and documentation. Proficient in supporting databases running on AIX, O.E.L, R.H.E.L, Sun-Solaris and windows platforms.
• Daily monitoring of database storage allocation and usage as well as other resource usage
• Performs daily database and database application support which includes the following tasks: Contributing to 24x7x365 staff coverage, Oracle database and application administration
• Provide an effective cloud solution for the existing expensive H/w infrastructure and the technologies. Supporting 200+, Testing, preproduction, Production servers. Help application team to stabilize the application and fix the Performance issues.
• Involved in Application Design and the Capacity planning for the Project.
• Support the SR process and document problem resolution via Metal ink
• Apply CPU and RDBMS patches as per the requirement
• Worked as an important resource during Disaster recovery activities and other infrastructure changes.
• Install, configure, Monitors, and troubleshoot database
• Security and auditing plan development, testing and maintenance. Intent of this security plan is to establish a means of providing complete accountability for any and all use of the databases.
• Database encryption and masking.
• Database or data warehousing technology experience.

Environment: Oracle 19c 12c,11gR2/11gR1/10g, Data Guard, Gluent, AWS, Azure Cloud .Sybase, MSSQL 2016.

Confidential

SENIOR ORACLE DBA

Responsibilities:

• Proactive database Space Management. Capacity planning for the future requirement. Archive log file management, and Alert log checking
• Oracle Database Sysadmin activities like User creation and Tablespace Management, Confidential scripting etc.
• DB maintenance for severs with storage capacity ranging from 10GB to 2.5TB.
• Application Environment Health check and helped the development team to write the query including performance tuning.
• Management of Application Users and Database Link creation.
• Installed production EBS application 12.1.1 for Oracle Database 11GR2, OBIEE, WebLogic server 11g,12c, ODI, OEDQ,7) OS installation on Development and Production server including additional packages.
• Performed installation of MS SQL 2008 Database using Virtual Box 4.2 version.
• Documented and implemented the Backup policy for development and Production instance.
• Worked with Oracle Support team to resolve WebLogic and Database related issues.
• Manage the WebLogic servers (11g and 12c). Troubleshoot and fixed the issues related to WebLogic server.
• Clone of RAC and Non Rac Environment
• Data Block recovery using RMAN

Environment: Oracle ERP R12, WebLogic server, Linux, Sun Solaris, Oracle 11gR2, OBIEE, ODI, ODEQ .

Confidential, Pittsburgh, PA

Oracle Applications DBA

Responsibilities:

• Supported 80+Application servers (R12) for Development, Testing, preproduction servers.
• Management of Users & Tablespaces, Database Link creation, and Confidential scripting.
• DB maintenance for severs with storage capacity ranging from 5GB to 700 GB.
• Movement/replacement of files as per the developer’s requirement
• Applied various patches using both adpatch and used lot of techniques in minimizing the patching downtimes
• Performance tuning of SQL queries using AWR and ADDM tools of Oracle 10g.
• Troubleshooting Database performance, locks and any backup issues
• Effectively monitoring the instances and solving the p1 issues
• Application Environment Health checkup, Archive log file management
• Database Health checking, monitoring Database and Alert log checking.
• Performance Tuning and Database Clone activity using RMAN.
• Database Backup for 10g, and 11g using export & import and RMAN .
• Automation of Data Change Request (DCR).
• Code deployment into SOA server by Identifying the sequence and Dependencies.
• OBIEE: Code deployment and troubleshooting.
• Performed the point in upgrades for Oracle apps environment.
• Managed the SOA services
• Troubleshooting Oracle SOA Suite
• Deploying SOA Composite Applications check the log files for weblogic server
• Resolved service startup issues.
• Monitoring Recent Human Task Service Component Instances
• Data source creation and tuning.
• SOA server dehydration purging.
• Part of daily monitoring activities used to perform daily health checkups on the databases.
• Support the SR process and document problem resolution via Metalink.

Environment: Oracle 10g, Oracle applications 11.5.10.2, OEM, Toad, HP-UX, RACdiscoverer, Oracle Financials, Oracle Manufacturing, HRMS, Oracle Projects .

Confidential

ORACLE DBA

Responsibilities:

• Supported 25 databases with storage capacity ranging from 5GB to 700 GB
• Installation of Oracle databases on Window, Linux.
• Proactive database Space Management. Capacity planning for the future requirement.
• Archive logfile management. Database.
• Health check, monitoring Database and Alert log checking.
• Implementation of backup &recovery processes. Database backup scheduling (Cronjobs) and log monitoring.
• Automation of database backup & backup checking process using Confidential scripting.
• Users & Tablespaces maintenance, Database migration from Oracle9i to 10g, using export & import. Client-side Oracle database Installation and implementation using remote connections.

Environment: Oracle 10g, D2K, OEM, Toad, HP-UX, Payroll, Attendance System, Oracle Projects