SUMMARY

• Over 20 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/Windows NT and AWS environment.
• Over 4 year experience as a No-SQL Cassandra DBA/Architect.
• More than 3 year experience in MS SQL Server Administration, Configuration, performance tuning, client/server connectivity, and writing Stored Procedures in MS SQL Server v2000, v2008, v2012.
• More than 2 year 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 support for data grid/IBM cloud env.
• 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.
• Strong analytical, technical and business skills in architecting and designing using ETL applications.
• Experience of Apache, Tomcat and WebLogic. Extensive experience with Oracle database and application.
• Support on Oracle Data Integrator to transform data between environment.
• 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, 10g to 11g and to 12c.
• Database migration experience from MySQL, Sybase 12.x, DB2 to Oracle and UNIX to Linux.
• Cassandra database support on AWS and Solaris env.
• 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;
• Supporting load XML data into Oracle XML DB.
• 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.
• Installing, Configuring, Administering Oracle XML DB.
• Working experience on HP-UX admin.
• Patrol/Tivoli implementation to monitor database alerts.

TECHNICAL 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, Cassandra, MS SQL Server 2000, 2008 and 2012, 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, Weblogic, Websphere.

Database Admin Tools: OEM (Oracle Enterprise Manager), Keep tool, TOAD, RDA, OpsCenter, Wily

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, Oracle data Integrator, Informatica, 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, Warren, NJ

Senior Oracle/Cassandra DBA Lead

Responsibilities:

• Project design/support for various applications.
• Configure/manage high availability Real Application Cluster on Solaris.
• Database software installation/maintenance on exadata storage servers.
• Oracle Shareplex configuration/support.
• Oracle 12c/ASM Installation and configuration on Sun Solaris servers.
• Oracle /Os patch installation and support.
• Performance tuning support for various applications.
• Database upgrade from 11g to 12c.
• No - SQL Cassandra Database configure and support on Solaris servers.
• No-SQL Cassandra instance setup/support on Amazon Web Services cloud env.
• Supporting data migration between environment using cloning Cassandra clusters.
• Monitor Cassandra instances using DataStax OpsCenter and Wily setup.
• Install and support Oracle DB on AWS.
• Shell programming for daily maintenance and pro - active monitoring.
• Database support for application releases.
• Support ETL solution using Oracle SQL Loader, DataStax Cassandra loader.
• Backup implementation/support using RMAN.
• Database cloning for QA support.
• Experience of Apache, Tomcat and WebLogic with Oracle database and application.
• Cassandra Architect/data modelling support.

Confidential, Parsippany, NJ

Senior Database Admin Lead

Responsibilities:

• 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.
• No-SQL Cassandra Database configure and support on Solaris SPARC.
• Cassandra Architect/data modelling support.
• Support ETL solution using Cassandra loader.
• Setup Cassandra monitoring with datastax opscenter.
• 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.
• Expense of Apache, Tomcat with web technologies.
• Performance tuning on Oracle database application.
• Backup and restore using RMAN and SMU utility.
• SQL/PL-SQL performance tuning.
• Installing, Configuring, Administering Oracle XML DB.
• Tablespace freespace maintenance on DATAMART database.
• Supporting load XML data into Oracle XML DB.
• Data guard implementation/support for multiple 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.
• Co-ordinated for Informatica upgrade from V8.6.1 to 9.0.1 and 9.1.0.
• Worked on Oracle Data Integrator to transform data between environment.
• Experienced in Lead, Design and Develop the ETL processes for Data Warehouse systems.
• Define and implement ETL development standards and procedures for data warehouse environment.
• Installing and maintaining SQL Server 2012 database systems. Backup strategy implementation, resolving system issues, opening cases with technical support to resolve issues, monitor system availability, updating system documentation, system and database recovery, etc.
• Working with SQL server development and systems teams to perform application and database tuning

Confidential, Warren, NJ

Senior Oracle/Cassandra DBA Lead

Responsibilities:

• 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.
• CDC data setup, maintenance and monitoring for data grid/IBM cloud 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.
• Data transfer support from DB2 to Oracle.
• 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.
• Installing, Configuring, Administering Oracle XML DB.
• Supporting load XML data into Oracle XML DB.
• Installing and maintaining SQL Server 2008 database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Working with SQL server development and systems teams to perform application and database tuning.
• Worked with Transparent Encryption, table compression, database compression and merge statements using SQL server 2008.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).

Confidential, Lansing, MI

Senior Oracle DBA/Architect

Responsibilities:

• 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, Mahwah, NJ

Senior Oracle DBA/Architect

Responsibilities:

• Supporting major Confidential 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.
• IBM DataStage ETL tool experience to develop jobs for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• 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.
• Installing, Configuring, Administering Oracle XML DB.
• Supporting load XML data into Oracle XML DB.
• Support loading external XML files to Oracle.
• 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.