PROFILE:

6 years of experience in the field of Database Technology in designing, developing, implementing and Managing Oracle, SQL Server, PostgreSQL Databases on Linux RedHat, Windows, AIX, Oracle Retail X store point of service Platforms.

TECHNICAL SKILLS:

Data bases: Oracle 10g, Oracle 11g, Oracle 12c Oracle

Database Tools: SQL*Loader, TKPROF, OEM, Toad, EXPLAIN PLAN, RMAN, STATSPACK, AWR, ADDM, ASH, SQL Developer, Grid Control

Operating Systems: Solaris 10/9/8, Sun Sparc, RHEL 5.X/4.X, OEL, HP UX 11i, Windows 2008/2012 server RedHat 7.5, AIX Team coach, Agile methodology and framework, scrum, Kanban, XP; Task backlog tracking, Capacity and velocity planning.

WORK EXPERIENCE:

Confidential, West Chester, PA

Senior Engineer/Architect

Responsibilities:

• Hands on SQL Server experience: software installation, security, backups, restore, recovery, performance tuning, Database creation, Upgrades, Patching
• Hands on EXADATA deploying, monitoring and managing Databases using EM 12c, and Migration, Patching, upgrades.
• Installation and implementation of 12c cloud control and migration of 11g grid control to 12c cloud control.
• Tuning of Oracle Databases for performance improvement using AWR, ADDM, ASH, Trace Analyzer, SQLTXPLAIN, OSWatcher and other OS related utilities like pstack, pmap, top, vmstat, iostat, prstat, strace, truss and also used Oracle Enterprise Manager (OEM) 11g and 12c to monitor single instance and RAC databases.
• Maintain and support Oracle e - business suite, PeopleSoft: Oracle Finance,HCM, CRM, SCM, MAN,HR, PORTAL.
• Configured DATA GUARD for Disaster recovery and Data Protection, Converting Standby database to Snapshot standby database for pre-go live activities
• Performed oracle Software's Installations, Creation of new standalone and clustered databases.
• Administering and setting up of 11g RAC and 12c RAC cluster ware and instances.
• Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.
• Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
• Also worked on Network data encryption to improve the security and also implemented SSL wallet to secure the connections.
• Database Services creation for distributing the applications across multiple nodes, extensively on command line utilities SRVCTL, CRSCTL, ADR, ASMCMD,
• Redefinition of tables using DBMS REDEFINITION, partitioning the tables in the production, re-defining the columns data types, and moving the LOBs to different tablespace
• Partitioned tables Maintenance, adding new partitions, exchanging one-year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
• Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active-active duplication.
• Implemented Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Golden Gate and worked with conventional EXP/IMP for migrating data from 9i to 10g.
• Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS JOBS, DBMS SCHEDULER, Crontab and $UNIVERSE.
• Designed and implemented different backup strategies like Cold, Hot, MAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.
• Handled Chained Rows and Row migration and solved the database performance issues.
• Monitor ASM, adding, deleting disks to the disk group.
• Replication and Extracting data and applying on production using Golden Gate.
• Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate.
• Worked on developing, testing, performance tuning, deployment, and support in Data warehouse system.
• Migrated 10TB database from regular file system to ASM using RMAN.
• Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster.
• Generated AWR reports using OEM 12c from Oracle 11g database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries

Confidential, Waltham, MA

Oracle Database Administrator

Responsibilities:

• Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
• Loading data from flat files to database using SQL*Loader, External Tables.
• Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Data pump import/export to move data between 10g and 10g/11g environments.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Implemented Flashback technology of the Oracle 11g, 10g along with Recycle bin for a faster recovery of the databases and database objects.
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
• Refreshed/cloned databases using RMAN utility.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Detect corrupted blocks by using DBVERIFY utility.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Implemented table partitioning to improve performance and data management.
• Implemented Security through Virtual Private Database and Fine-grained Auditing.
• Customized RMAN scripts for database backup and recovery.
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using EXPLAINPLAN, SQLTRACE, TKPROF, AWR, and ADDM.
• Created users, roles and granted privileges according to the business requirements
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, monitoring their growth rate, monitoring the effective use of SGA etc.
• Used TOAD for database management.
• Optimized data loading using SQL*Loader to load different types of data from flat files to the Oracle server.
• Configured the automated alerts for the production servers, which alerts DBA with the alert log errors and proactively space related errors.
• Cleaning the ORACLE HOME file system by cleaning the log files, alert log file and listener.log files
• Identified and trouble shot everyday issues like locking, scripts execution, Data Audits etc.
• Backup and recovery utilizing RMAN.
• Working with the application support people to resolve database related issues and running the scripts for the application support people.
• Creating users and database links, snap shots on production and development servers.
• Maintaining system security, defining of roles, profiles etc.