PROFESSIONAL SUMMARY:

• Having 17 Years of IT experience as a Software Engineer with Working experience on projects using Confidential DBA, Confidential, ORACLE database, EBS and People soft application performance tuning.
• Work on Installation, Upgrade, Migration, Patching, perform export and import, performance tuning of 11g, 12c, 19c Standalone and RAC Databases which use ASM and file system storage accordingly.
• Work on supporting databases and administration of ORACLE Confidential machines
• Work on supporting databases hosted on AWS CLOUD and ORACLE CLOUD
• Installed and configured Confidential on ORACLE databases for data replication.
• Involved in solving Confidential issues like lagging issues.
• Experience on database capacity planning, data archival, partitions and data compression solutions for very large critical production databases
• Extensive experience of database and application PERFORMANCE tuning with holistic approach including rewriting of PL/SQL programs and SQL’s.
• Monitored and Tuned database using OEM, AWR, ADDR, and ASH.
• Setup standby database for disaster recovery using Data Guard (physical & logical standby) for high availability.
• Extensive experience in creating and maintenance database object like table partitions, views, materialized views, Indexes, Constraints, Sequence and Synonyms
• Implemented Hot, Cold, and RMAN backup, Refresh, Recovery, and cloning of databases.
• Worked with logical backups using data pump, export/import utilities.
• Monitored availability of listener, database, alert log file, trace file.
• Involved in user management and database security by granting appropriate Roles, Privileges, and Profiles.
• Used SQL*Loader to load data from flat files
• Experienced in writing Cron jobs in UNIX, Linux.
• Experienced in production support with quick response time
• Co - ordinate, consolidate and report the status of high priority task to management
• Setting up QAT, DEV, PRE-PROD environment by following the standard practices
• Experience in designing databases, build and deployment of critical applications

TECHNICAL SKILLS:

Environment: Oracle 9i/10G/11gR2/12cR1/12cR2/19c, RAC, ASM, EBS, PeopleSoft, SAP, SQL, PL/SQL, SQL Developer, OEM, Linux, IBM-AIX, JIRA, service now.

PROFESSIO PROFESSIONAL EXPERIENCE:

Confidential, Baton Rouge, LA

Responsibilities:

• Resolving performances issue on RAC databases at CLUSTER, O/S and DATABASE Level
• Database Tuning - Tuning Memory, I/O and resource contention. Optimizing SQL query for better performance
• Database refreshes of very large database to NON-PROD environments on regular basis
• Monitoring space, wait events, locks and long operations running on the database
• Monitoring the alert log for the database performance and resolving the performance issues.
• Partitioning big tables and Indexes for optimal performance (also implemented sub-partitions). Also use exchange partition concepts in transferring data
• Monitoring sessions related to users specific, Sessions related to application specific for tuning the performance of the database
• 24*7 ON-CALL production Support for mission critical production systems
• Solving all type of DBA problems like data file & Log file Corruption, database crash
• Worked dedicatedly with application team and provided solutions which increased performance of Jobs like Billing, nVision reports etc.
• Solution provided saved customer a lot in terms of time by improving the performance of application from hours to seconds.
• Provided database archival solution of database size around 20TB

Confidential, Houston, TX

Responsibilities:

• Worked dedicatedly with application team and provided solutions which increased performance
• Provided standard quality of service using ORACLE Most advanced concepts like REFERENCE PARTITION, table COMPRESSION and BLOB movements e.t.c
• Successfully resolved network issues and technically proved by doing CROSSBRID TESTING .
• Partitioning big tables and Indexes for optimal performance (also implemented sub-partitions). Also use exchange partition concepts in transferring data
• Done some in depth study of ORACLE provided new features and was able to successfully implement them in terms table storage cells(at BLOCKS Percentage, DATA MOVEMENT in BLOCKS and PARALLEL READ on BLOCKS)
• Being ORACLE DBA, Worked on coding (PL/SQL Developer Job) and wrote efficient queries using ORACLE provided analytical functions which will execute in less time for the reporting section of application

Confidential

Software Engineer

Responsibilities:

• Migrated the Databases from Traditional Servers to Confidential servers using different technical methodologies
• Administration of storage servers (cell servers), MS, RS, CELLSRV using cellcli commands
• Experience in providing support on infiband switches & ILOM
• Experience in tunning to use Confidential features like cell offloading, storage indexes, flash cache and hybrid columnar compression etc
• Working on generating Exacheck reports and resolving performance issues

Confidential

Software Engineer

Responsibilities:

• Installing Confidential . And configured database for data replication on standalone and cluster environments.
• Creating the initial Confidential configuration for database replication and Online synchronization.
• Implemented ONE-ONE and ONE-MANY configurations
• Configuring Column mapping and Data filtering using Confidential .
• Replicating table of one master database into 4 other databases using Confidential replication.
• Worked on 24/7 and resolved ‘N’ number of issues during the configuration and maintaince as we have limited support from vendor.

Confidential, Atlanta, GA

Responsibilities:

• Resolving performances issue on RAC databases at CLUSTER, O/S and DATABASE Level
• Worked and stabilized LOGICAL standby Issues, Provided Standard Document for Team,
• Database Tuning - Tuning Memory, I/O and resource contention. Optimizing SQL query for better performance
• Refreshing staging and development schema with production data by using RMAN and Exp/Imp utility.
• Monitoring space, wait events, locks and long operations running on the database
• 24*7 ON-CALL production Support for mission critical production systems
• Tuning the SQL statement by analysing the explain plan along with AWR, ASH and ADDM Reports

Confidential, San Antonio, TX

Responsibilities:

• 24*7 production Support for mission critical production systems
• Installation of Oracle 9i/10g and 11g database creation
• Upgrading/migrating the databases from lower version to higher versions. (9i-10g, 10g-11G,)
• Implementing Security features as specified by the Client’s Security policy.
• Partitioning big tables and Indexes for optimal performance (also implemented sub-partitions). Also use exchange partition concepts in transferring data
• Compression, Archiving the data from the tables and backing up the archived data for the Business requirement
• Generating stats pack reports on regular basis to identify the database performance at peak load
• Reorganizing the database objects by archiving the data and moving the tables within the tablespace, rebuilding the indexes.
• Managing batch processes running against the database, Cron jobs placed within the oracle server.
• Design & developed table structures, PL/SQL Stored Procedures & Database Triggers to Implement Business rules & Security.
• Reorganizing the database objects by archiving the data and moving the tables within the tablespace, rebuilding the indexes.
• Migrating the data from one database to the other using Export / Import, EXPDP and IMPDP Utilities.
• Archiving the data from the tables and backing up the archived data for the Business requirement.
• Migration of archive files system to ASM disks.

Confidential, Houston, TX

Software Engineer

Responsibilities:

• Configuring alerts for DB health check, generating snap reports on regular basis and for monitoring space usage.
• Enrolling and Administering the Database objects and performance tuning.
• Managing Users, Monitoring sessions related to users specific, Sessions related to application specific for tuning the performance of the database.
• Configuring various cronjobs within the Oracle Server
• Monitoring and performing the backups using COLD, HOT and RMAN backup strategies
• Performing logical backup using the Traditional import/export and data pump.
• Extensive experience in Running SQLLOADER
• Experience in writing Analytical queries using Analytical Functions and writing
• Created and customized analytical reports for existing system using Crystal Reports
• Maintains of Data in Database i.e. removing of duplicate Data and Monitoring Trace files
• Involved in Running Weekly and Monthly Saving report and daily Tasks such a sending status of pinging and loading of files from customer
• Taking weekly Back Up of Data Base using RMAN
• USING OF Diagnostic tools for evaluating performance of SQL STATEMENT - EXPLAIN PLAN,SQL TRACE, TKPROF
• Application and SQL performance tuning
• Trouble shooting 24*7 production environment issues.