Summary

• Over 18 years of experience in Oracle Database and Administration/ Architect on VLDB production, development databases and expertise on HP-UX Administration.
• More than 10 years experience in Oracle Team lead, project management.
• Oracle RDBMS 7.x/8i/9i/10g/11g , 12c/ASM Installation and configuration on UNIX, Linux, Sun Solaris and Windows NT servers.
• More than 2 years experience as Sybase DBA.
• Configure, install and manage High availability Oracle Real Application Cluster RAC on Linux.
• Experience in Aerospace ERP on Oracle E-Business Suite EBS and MRO environment.
• Oracle Data guard setup and administration.
• Oracle streams Master to Master replication setup, maintenance, monitor and administration.
• CDC implementation for data grid support.
• Good understanding about Oracle Goldengate software implementation and maintenance.
• Extensive Data Modeling Design OLAP/OLTP experience using Erwin 3.5, ER/Studio and Reflection-X.
• Oracle Database and network tuning and SQL query tuning using AWR, ADDM, STATSPACK, trace, RDA, SQL execution plan reports, Toad, Enterprise Manager Tool utilities.
• Logical and Physical Facts and Dimensional data modeling design experience for Data warehouse application.
• ETL Data Warehouse experience.
• Hybrid tuning technologies use data warehouse/Data mart application.
• Experience with Backup and Disaster Recovery using export, data pump, RMAN and VERITAS NetBackup.
• Backup implementation experience using ESP and Networker scheduler.
• Expertise on Database upgrade from 7.x to 9i, 8i to 9i, 9i to 10g and 10g to 11g.
• Database migration experience from MySQL, Sybase 12.x, DB2 to Oracle and UNIX to Linux.
• Oracle server/client installation, Data Integration/Data Distribution support.
• Extensive shell Korn, Born programming experience.
• Development experience with Oracle/Developer2000.
• Expertise on SQL and PL/SQL programming.
• Pioneer in working with PL/SQL including Procedures, Functions, Cursors and Triggers.
• Supporting database-related Java interface layers, and heavily involved in general architectural design decisions for all major system components.
• Expertise to implement Oracle advances security features and fine grained access control.
• Expertise to implement data encryption for financial and HRMS systems.
• Extensive knowledge in Data Warehouse and Data Mart Design.
• Quest shareplex monitoring and maintenance
• 24X7 production database support on UNIX, Linux and Solaris environment.
• Database audit implementation to monitor login, user activity.
• Experience on database patch certification and installation.
• Experienced in understanding and analyzing business requirements and working closely with various application teams and business teams to develop ETL procedures consistent across all applications and systems.
• Experience in capacity planning and space management.
• Database replication management using streams, RMAN and database mirroring.
• Extensive knowledge of Oracle functionality internals. Good consulting and communication skills, knowledge of client-relationship building techniques and project methodologies with good team building skills.
• Three years Experience in MS SQL Server Administration, Configuration, performance tuning, client/server connectivity, and writing Stored Procedures in MS SQL Server v2000, v2008.
• Experience on MySQL database server.
• Working experience on HP-UX admin.
• Patrol/Tivoli implementation to monitor database alerts.

Professional Skills:

Operating Systems: MS-DOS, Windows 95/98/NT/2000, Linux, UNIX Tru64, HP-UX, SCO , Sun Solaris, AIX.

Hardware: HP 9000 Series, SUN E450/250, Optical Jukebox, HP SureStore, L20/L40/L80 Tape Libraries, HP Disk Array, Cisco routers and switches.

Databases: Oracle 7.x/8.x/8i/9i/10g/11g/12c, MS SQL Server 2000, Sybase 10.x, 12.x, 15.x, MySQL, XML and DB2.

Languages: C, COBOL, VC SDK, MFC , Pascal, SQL, PL/SQL, MYSQL, UNIX Shell scripting Bourne, C, Korn, POSIX , Java JSP, JDBC, Servlets , HTML, Visual Basic, VB.NET, Perl 4.0.

Packages: Microsoft Great Plains, VERITAS Netbackup Datacenter, FoxPro, Office 97, Netprowler 3.5.1, Symantec VelociRaptor Firewall 1.1., Microsoft Visio, MC/Service Guard, MS Project.

Front End GUIs: OBI, Developer 2000 5.0/4.5, Forms 3.0, and Reports 2.5, Visual FoxPro, Crystal Reports.

Middleware: Oracle Application Server OAS , Apache Tomcat Version 5.0, HP Application Server.

Database Admin Tools: OEM Oracle Enterprise Manager , Keep tool, TOAD, RDA

Backup File Management: OCFS, VERITAS Cluster, VERITAS Volume Manger, VERITAS Database Editor, VERITAS Quick I/O, VxDBA

DB Other Tools: RMAN, Import/Export, Streams, Data pump, DBVerify, SQL Loader, Datastage, Sync sort, SQL Plus, SQL Developer, TKProf, Auto trace, Tuning Scripts, ADDM, AWR, SVRMGRL, Net Manager and Stats pack Performance Monitoring tool, Aqua data studio.

Other Tools: Reflection-X, Erwin, VNC Server, ZIP Plus.

Professional Experience:

Confidential

Title: Senior Database Admin Lead

• Oracle Database Administration for production, QA and development databases.
• Configure and manage High availability 2-node and 4-node Oracle 11g RAC implementation and maintenance on Linux/Solaris with ASM and non-ASM storage.
• Install and create database on Oracle 12c for Development/QA testing.
• Implement 12c OEM agent for monitoring purpose.
• Database release design/SQL review.
• Work with SME to troubleshoot and resolve database issues.
• Work on database scrub process.
• Performance tuning on Oracle database application.
• Backup and restore using RMAN and SMU utility.
• SQL/PL-SQL performance tuning.
• Tablespace freespace maintenance on DATAMART database.
• Data guard implementation and maintenance for multiple applications DB on Solaris and Linux environment.
• Oracle Goldengate software implementation on new database.
• Implement Goldengate table replication between multiple databases.
• Monitor/troubleshoot and maintenance of Goldengate replication.
• Database upgrade from 10g to 11gR1 and 11g to 12c.
• Database migration from stand-alone environment to multi-node RAC on Linux.
• Support Os/Database patching on Solaris and Linux environment.
• Backup production database and restore after scrub process to development and QA environment using RMAN and Oracle SMU technology.

Confidential

Title: Senior Oracle DBA/Lead.

• Data Modeling Design OLAP/OLTP for ERP/ Data warehousing applications.
• Oracle Database Administration for VLDB production and development databases.
• Configure and manage High availability Oracle Real Application Cluster RAC on Linux and Solaris.
• Oracle streams Master to Master replication setup, maintenance, monitor and administration.
• SHAREPLEX configuration and maintenance for table replication between databases.
• Database software installation/maintenance on exadata storage servers.
• Participated in analysis and designing of Oracle exadata Server for infrastructure and related projects.
• Health check monitoring and maintenance for Oracle exadata system.
• CDC data setup, maintenance and monitoring for data grid support.
• Oracle Shareplex configuration/support.
• Oracle RDBMS 10g/11g /ASM Installation and configuration on UNIX, Linux, Sun Solaris and Windows NT servers.
• Oracle /Os patch installation and support.
• Design ETL solution Data Warehouse application.
• Hybrid Performance tuning data warehouse/Data mart application.
• Database upgrade from lower versions to higher versions 10g to 11gR2 .
• Shell programming for daily maintenance and pro-active monitoring.
• Database support for application releases, Data Integration/Data Distribution support.
• Backup implementation/support using RMAN.
• Database cloning for QA support.
• SQL/PL-SQL performance tuning.
• EM installation/support.
• Oracle physical/active data guard installation and support.
• Database replication using RMAN.
• Enterprise release support and 24/7 on-call support.

Confidential

Title: Senior Oracle DBA/Architect.

• Design and develop methodologies to migrate multiple development/production databases from Sybase to Oracle 11g.
• DASD forecast for Oracle databases.
• Oracle database performance and tuning.
• Install oracle 11g software on UNIX servers for server and client support.
• Create and support Oracle 11g databases to replicate Sybase schema objects to Oracle.
• Support Sybase functionalities in Oracle using PL/SQL procedures, functions and triggers.
• Oracle support for pro C and COBOL program conversion from Sybase environment.
• Install and configure ODBC software for client support.
• Implemented data masking and data encryption for secure database support.
• Implement backup/restore strategy using data pump, RMAN, flashback and other technologies.
• Disaster recovery plan implementation for production database using Data guard.
• Shell script to monitor database activities and day to day maintenance.

Confidential

Title: Senior Oracle DBA/Architect.

Responsibilities

• Supporting major UPS applications like Data warehousing, PRR, Infolib, DIR, Sales ESP/ESTAT , IAS, Financial, ECM, E-Billing, SCS along with others and more than 300 production databases inside USA on different versions of UNIX, Linux, Solaris and Windows Operating System.
• Oracle RAC implementation, monitoring and support.
• Extensive Data Modeling Design OLAP/OLTP experience using Erwin, ER/Studio.
• Logical to Physical data modeling and design experience for data warehouse application.
• Experience on data warehouse/Data mart application tuning.
• Experience on Datastage ETL tool.
• Experience on SQL Loader, External table, match merge.
• Experience on table/index partition maintenance.
• Operational and production database support for data warehousing application.
• Implement, maintain and troubleshoot master replication with oracle streams.
• Shareplex Monitoring and maintenance.
• Implement Grid based monitoring solution for database applications.
• Transparent data encryption for critical data storage.
• Requirement analysis, design and manage new projects.
• Monitor, recommend and maintain SQL activity.
• Tablespace freespace maintenance.
• Implemented Oracle obfuscation Data Masking for sensitive information including financial privacy information.
• Implemented Advance fine grained access control including Audit logging for monitoring.
• Implemented row-level security mechanism on database.
• Involved re-writing PL/SQL stored procedures to increase performance.
• Supporting database-related Java interface layers, and heavily involved in general architectural design decisions for all major system components.
• Implemented PL/SQL Procedures, packages and Triggers for database monitoring.
• Implemented auditing to track database activities.
• Database refresh from production using export/import, data pump and RMAN.
• Configure and implement backup job using export, RMAN and ESP scheduler.
• Query execution plan, SQL Profiles and OEM.
• Database Performance evaluation and tuning using RDA, AWR, ADDM,
• Resolving critical technical problems affecting the whole production environment.
• Monitor Streams with OEM, scripts, Patrol and Oracle streams commander.
• Troubleshoot streams process.
• Implemented label security for Oracle database support.
• Apply streams related patches to the database.
• Quest shareplex monitoring and maintenance
• Sybase database management.
• Implement backup strategy for Sybase database.
• Sybase database performance and tuning.
• Database migration from Sybase to Oracle.
• Implement and maintain replication between Financial and HR application databases and ECM, multiple SCS, ECM databases.