Senior Oracle/cassandra Dba Lead Resume
Warren, NJ
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.
- Support Oracle/INFORMATICA upgrade.
- 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 XMLdatainto Oracle XMLDB.
- 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.
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, 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.
- Cassandra Architect/data modelling support.
- EM installation/support.
- Oracle physical/active data guard installation and 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.
- Work on database scrub process.
- 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 XMLdatainto Oracle XMLDB.
- 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 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.
- 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 XMLdatainto Oracle XMLDB.
- 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, MI, USA
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, NJ, USA
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.
- 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 XMLdatainto Oracle XMLDB.
- 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.
- • Resolving critical technical problems affecting the whole production environment.
- • 24X7 pager support for production databases.
- • Database Performance evaluation and tuning using RDA, AWR, ADDMQuery execution plan, SQL Profiles and OEM.
- 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.
- • Oracle data guard implementation, maintenance and support.
- •Query review and suggestion for major application releases.
- • Oracle database, security patch certification on different versions of Linux, UNIX and
- Solaris OS and new hardware resources.
- • New Oracle database Configuration based on requirement.
- Install oracle database software for both database and client.
- Database and ORACLE HOME cloning.
Confidential, Palo Alto, CA
Senior Oracle DBA
Responsibilities
- Coordinate to design and develop methodologies to migrate MYSQL to Oracle.
- MYSQL data ETL using CSV engine, SQL Loader and Oracle external table utility.
- Installed Oracle 10g software, created databases for maintenance and support.
- Tablespace and schema support for Oracle databases.
- Written and implemented PL/SQL cron jobs for database monitoring purpose.
- Implemented transparent data encryption for user access.
- Re-written PL/SQL stored procedures to increase performance.
- Implement and maintain replication technology using streams.
- Backup recovery implementation using RMAN.
Confidential
Senior Oracle DBA/Architect
Responsibilities
- Project requirement analysis and design.
- OLTP Data Modeling & Design using Reflection-X.
- Project database implementation and support.
- Production Maintenance and database tuning.
- Implemented transparent data encryption for user access.
- Backup-recovery implementation using export/import and RMAN.
- Implemented PL/SQL jobs for database monitoring.
- Development and implementation of UNIX cron jobs.
Confidential
Senior Database Analyst
Responsibilities
- Experience of working with high availability Database group in Aerospace ERP and MRO environment.
- Requirement analysis, designing and managing new projects.
- Database performance tuning by collect statistics with Oracle Trace, STATSPACK utility.
- Responsibility of monitoring production database (24x7).
- Oracle 9i RAC implementation.
- Experience of working with high availability Database group in Aerospace ERP on Oracle Ebusiness Suite (EBS) and MRO environment.
- Patch, clone and backup maintenance for Oracle Ebusiness Suite application.
- Expertise in ASM configuration
- Application patch implementation in the production environment.
- Expertise in designing Backup & Log archival policy with RMAN, export/import, hot/cold backup and writing scripts for their operation, handling the Block Corruption and recovery.
- Managing Incremental, Cumulative and Full database backup using VERITAS NetBackup Data Centre.
- Experience on Oracle streams replication between multiple oracle databases.
- Implement, maintain and monitor streams for master replication between Oracle and MSSQL database.
- Expertise in Oracle Advance Queuing.
- Plan and implement (failover) high availability ORACLE standby database. Backup & recovery plans.
- Experience of Configuring Physical/Logical Standby database
- Supporting QA/Development database.
- Planned and migrated Oracle database from version 7.34 to 9i.
- Implemented many ETL data migrations for both legacy systems and for daily data production loads.
- Outstanding problem solving abilities on various database issues and critical circumstances.
- OLAP and OLTP Data Modeling & Design using Erwin 3.5, ER/Studio and Reflection-X.
- Design and development experience in Data Warehouse and Data Mart.
- Pioneer in working with PL/SQL including Procedures, Functions, Cursors, Triggers, Partitions, Packages, security access etc.
- Java Authentication and Authorization services implemented for internet users on Supply chain/MRO and oracle E-Business Suited identity management.
- Written many PL/SQL for Logistics and financial reporting purpose.
- Implemented security features in database using Event triggers, Application context and Fine-grained access control.
- Implemented many shell scripts and PL/SQL jobs for database monitoring and daily maintenance.
- Implemented data masking and DBMS CRYPTO options for data encryption for user access.
- Experience in MS SQL Server installation, configuration, performance tuning, client/server connectivity, backup/recovery and writing Stored Procedures in MS SQL Server v2000.
- Responsible for investigating, project planning, recommending and implementing all new database technologies, develop IT Policies, Procedures and Manuals.
- Expertise in HP/UX system administration.
- Sybase database management.
- Experience in Symantec VelociRaptor Firewall administration with Netprowler 3.5.1.
Confidential
Software Engineer
Responsibilities
- Installed oracle 8i on Linux machine and configured oracle parameters.
- Installation and Configuration for Net8 connect to client.
- Performed OEM setup on client machine to monitor production Database.
- Created more stored procedure and packages for application.
- Responsible for configuring JDBC and checking the connectivity in client server environment
- Performed Multi-Threaded server Configuration
- Configured Partitioning the Tables
- Installed Web logic system and Configured to connect ORACLE server.
- Implemented data encryption using DBMS OBFUSCATION toolkit.
- Used SQL* Loader to Migrate the DAT files.
- Optimizing the SQL’s for maximum performance by using TKPROF and EXPLAINS PLAN.
- Performance Tuning of the Production Database and Application Severs.
- Experience on MySQL database server.
- Managing Tablespaces, Online redo logs, Archive files and Data files.
- Created Users Schema and Security Administration for the database Designed and developed all critical Stored Procedure, Functions and Packages.
- Responsible for databases Backup/Recovery using Off-line and On-line Backups.
- Monitoring the performance of Sessions, Users, and Tablespaces for the database using Oracle server Manager.
Confidential
Programmer/Administrator.
Responsibilities
- Requirement analysis, designing and managing new projects.
- Database Designing and Normalization using Analysis case tools.
- Standardizing data definitions across databases.
- Independently configured the SQL*NET V2 at the Sever end as well as at the client end to setup the client server environment with developer /2000.
- Performed the user requirement and trouble-shooting activities like create new users, daily backup connectivity issuers and tuning the SGA.
- Tuning production databases and performance monitoring by using UTLBSTAT and UTLESTAT.
- Managing Users, Profiles, Privileges and Rolls.
- Implemented label security to access database information.
- Implemented view based data masking for sensitive information.
- Created Procedure, Functions, Trigger and Views.
- Regular Backups (Different levels) & Recovery. Writing automated regular daily backup procedures.
- Developed applications using Oracle/Developer 2000.
- Administrated and developed applications using Wang COBOL system.
Confidential, Andheri
Programmer/Customer Support Engineer
Responsibilities
- Prepared of software requirement specifications.
- Involved in the development, testing, and implementation of various modules using Forms 5.0 and Report 3.0.
- Created primary database Objects - Tables, Views, Procedures, Functions, Packages and Indexes.
- Enrolling Users and maintaining system Security.
- Used SQL* Loader to Migrate the DAT files which were created from dbase Packages and Reorganized the data.
- Monitoring and turning the application.
- Backing up and restoring the database.
- Performing regular HOT/COLD backups. Used different utilities like export import for on-line backup/restore.
Confidential
Programmer/Administrator
Responsibilities
- Requirement analysis, designing and leading new projects.
- Created primary database Objects - Tables, Views, Procedures, Functions, Packages, and Indexes.
- Tuning/Optimizing SQL statement using EXPLAIN PLAN utility.
- Create databases, moving transaction logs, changing database ownership and dropping the database.
- Security issue-permissions/access rights.
- Written stored procedures for archiving data from production.
- Performed all aspects of data and DB administration including, hardware and software evaluation.
- Implementing the Backup strategy for the new database server, writing and automating scripts for compile and incremental backups.
- Prepared the proposed system, process specification, Screen Layouts, Data Stores, and Report Formats.
- Developed applications using Oracle/Developer 2000 and FoxPro.