PROFESSIONAL SUMMARY:

• Over 13 Years of Experience working wif Oracle Database Administration on Unix/AIX/Linux/Windows
• Expertise in Delphix for Database Virtualization.
• Experience Working on Exadata machines (Half Rack and Full Rack).
• Setup Oracle Dataguard and participated in regular Disaster Recovery exercises.
• Experience using single node, multi node(2 and 4) RAC env and Grid Control.
• Installed and configured Oracle 12c Multi - Tenant Container Database and Pluggable Database format
• Experience using PL/SQL to perform data aggregations, creating stored procedures for data access
• Supported Oracle GlodenGate in Oracle to Oracle homogeneous environments and heterogeneous (Oracle to SQL Server) environments
• POC using Gloden gate for cloud migration of Oracle 12c Databases.
• Experience managing SQL Server databases.
• Migration experience from Oracle 11gR2 to 12CR2, 11gR1 to 11gR2, 9i to 10g and 8i to 9i using In Place, New Home and Datapump methods.
• Concrete Knowledge and Experience in Data Analysis, Requirements Gathering, Design, Development, Testing and Implementation.
• Expertise in Database Design, Data Modeling and Data Warehousing.
• Excellent experience in Oracle 11.x, 10.x, 9.x, 8.x and Administered various Production Databases on Solaris, HP-UNIX, Windows NT, Windows 2000 and Windows2003.
• Installation and Administration of several Instances/Databases wif high volume of data, including 9iAS on Windows NT 4.0, 10g on Solaris and 11.x on Solaris
• Tuning Databases and SQL. Tools used include Stats pack, OEM-Tuning pack.
• Expertise in designing and implementing backup and recovery strategies using RMAN as well as OS backup methods in accordance wif SLA’s.
• Used RMAN for duplication, cloning and setup of lower Level Environments(dev,QA, CIT,Pipeline etc)
• Worked on SQL Loader, d eveloped scripts to export & import data from SQL server and IBM UDB.

TECHNICAL SKILLS:

Operating systems: Unix (RHEL 7.x,6.x, AIX5.x, Sun Solaris2.25, HP-Unix 9000, Linux AS), Windows 2000/9X/NT/XP/2003 S E

RDBMS: ORACLE 12c/11x/10x/9x/8x, SQL Server 2000,2005,2008 & 2012 DB2UDB 8.x, Sybase

Oracle Tools: SQL Loader, SQL* Plus, RMAN, Import, Export, Datapump, PL/SQL (Packages, procedures, functions and triggers), Opatch, OEM

Tools: & Utilities: SQL Developer, Quest tools including TOAD for Oracle, ERWIN, Business Objects, Crystal Reports, COGNOS, PERL, Siebel, Gloden Gate, Delphix, JIRA, Rally, Ansible Tower, Bit Bucket, Subversion, Putty

Hardware: HP 3000, RS/6000, SOLARIS, IBM PC, DL380, Disc Array

PROFESSIONAL EXPERIENCE:

Confidential

DB Virtualization Application Architect

Environment: Oracle 12c, Exadata, RHEL7.x, Delphix, RMAN, PL/SQL, Java, SQL Server

Responsibilities:

• Onboarding Oracle Exadata Databases to Delphix Data Virtualization platform
• Onboard Delphix Application to BoA internal entitlements and Access Request systems.
• Trained DBA’s and Power users for Delphix Onboarding and maintenance.
• Duplicating and maintaining multiple environments based on release schedules.
• Scripting several jobs for reporting and maintenance tasks using API’s and Shell scripts.
• Tuning queries and PL/SQL code used by applications for better performance and quicker access
• Worked wif various development and Testing teams to design, test and implement Database virtualization
• Assisted wif POC’s of various Test data synthesis tools incl infosys, CA and IBM.
• AWS
• Smoke Test Suite development and Automation.

Senior Database Administrator

Confidential

Environment: Oracle 11G, Solaris, RMAN, PL/SQL, Java, C++, Siebel

Responsibilities:

• Migrating Databases from Sun Solaris to RHEL servers.
• Upgrading of the Oracle databases from Version 11.1.0.7 to 11.2.0.3
• Installed & tested several patches prior to applying in production.
• Duplicating and maintaining multiple environments based on release schedules.
• Scripting RMAN ONLINE/OFFLINE backups, validate and other maintenance tasks.
• Tuning queries and PL/SQL code used by applications for better performance and quicker access
• Worked wif various development and Testing teams to design, test and implement applications
• Implemented features like hints and parallelism for improving performance of long running queries and reports
• Software and firmware maintenance of the Exadata storage servers in the Database machine including routine health check, patching and upgrades according to the suggestions from Oracle support department.
• Integration of Exadata monitoring into our existing IT monitoring framework. Provide and implement performance and tuning recommendations of all components in the Exadata machines.
• Gloden Gate Implementations

Database Administrator

Confidential

Environment: Oracle 10G, Windows 2003, RMAN, PL/SQL, PERL, GAWK .Net & COGNOS

Responsibilities:

• Upgrading of the Oracle databases from Version 8.x to 10.2.0.3
• Upgrading and patching from 10.2.0.3 to 10.2.0.5 patchset 9
• Upgrading SQL Server databases from and 2008
• Scripting RMAN ONLINE/OFFLINE backups, validate and other maintenance tasks.
• Tuning queries and PL/SQL code used by applications for better performance and quicker access
• Worked wif various development and Testing teams to design, test and implement applications
• Assisted in Data modeling and Database designing for new databases & applications.
• Determined hardware and operating system requirements for upgrading Oracle databases to 11G.
• Implemented features like table partitioning, hints and parallelism for improving performance of long running queries and reports
• Supported Enterprise backups using Backup Exec
• Implemented high availability using CA’s XOSOFT and ARC server
• Tested Dataguard as part of 11GR2 Upgrade plan.
• Designed and implemented data loads & Transformation to use SQL LDR and Pl/SQL Packages( Previously using CENTURA).
• Automated refreshing of Data from Production to UAT and Development databases using Datapump imports and exports.

Database Administrator

Confidential

Environment: Oracle 10G, Windows 2003, Oracle ASM technology, RMAN, PL/SQL

Responsibilities:

• Implemented ASM technology to improve database performance
• Managed data from various sources like SQL server databases, Access databases etc.
• Implemented and regularly tested RMAN based Backup and recovery techniques
• Developed scripts to schedule regular RMAN backups.
• Developed various ad-hoc reports for both Accounting as well as Marketing Departments.
• Upgrades and patches applied
• Daylight Savings Time Changes patch tested and applied successfully.
• Multiplexed control file, ad redo logs in ASM disk groups
• Expanded disk arrays to facilitate database expansion
• Implemented password security features for users in the database
• Successfully tested importing data from Oracle 7i to Oracle 10g
• Proactively managed databases to identify and fix potential performance and management problems
• Debugged Oracle stored procedures, packages to fix the errors using TOAD and SQL Navigator tool.
• Performance tuning in accordance wif various baseline metrics using Enterprise Manager Database Control Advisors including SQL tuning advisor, Mean time to recover (MTTR) advisor and undo management advisor.
• Designed and implemented backup/recovery strategies according to SLA.
• Designed and implemented table and index partitioning for proper distribution of data in table.
• Performed PL/SQL Code reviews wif other developers to code performance improvement.
• Involved in hardware decisions for new requirements

Database Administrator

Confidential

Environment: Oracle 10G, Developer 2000, TOAD 8.5, Erwin 4.x, PL/SQL (Packages, Procedures, functions, triggers), Informatica Power center 7.x, Unix Script, Business Objects.

Responsibilities:

• Performed user discussions to obtain the business requirement details for system analysis.
• Performed data modeling, created logical dimensional STAR, SNOWFLAKE schemas, Entity Relationships diagrams, Normalization, physical schemas scripts using Oracle Designer.
• Created tables, views, stored procedures, triggers, packages using SQL and PL/SQL in Oracle 10g database.
• Proactively managed databases to identify and fix potential performance and management problems
• Used External tables in Oracle 10g database to simplify and improve data loading speed wifout using SQL Loader.
• Administrated instances of the databases, wif high volume of data and high availability (7/24) requirements.
• Debugged Oracle stored procedures, packages to fix the errors using TOAD and SQL Navigator tool.
• Performance tuning in accordance wif various baseline metrics using Enterprise Manager Database Control Advisors including SQL tuning advisor, Mean time to recover (MTTR) advisor and undo management advisor.
• Designed and implemented backup/recovery strategies according to the service level agreements (SLA’S)
• Designed and implemented table and index partitioning for proper distribution of data in table.
• Performed PL/SQL Code reviews wif other developers to code performance improvement.
• Performed data loading activities into Oracle data warehouse using INFORMATICA ETL tool, ETL metadata repository and using scripts, programs based on SQL, Pl/SQL.
• Used Business Intelligence tools such as Business objects for ad hoc query and reporting purpose. Also created reports in Crystal Reports, Oracle Reports