MANISH KUMAR JAISWAL

+1-805-***-****

aczike@r.postjobfree.com

Netezza DBA Blog – https://dbasadda.blogspot.com

Working as a Lead Database Administrator with over Eight years of experience in the IT industry and over 8 years of extensive experience working as an Oracle DBA / Netezza DBA, Two years as a Postgres DBA. His expertise lies in the Design, Installation, Administration, Performance Tuning, Backup, Recovery, Production support, Troubleshooting, Implementation, testing, Cloning, Upgrades, Patching, multi-node installation & Migration of Oracle 9i/10g/11g and 12c databases on UNIX (HP-UX, Sun Solaris, Linux and AIX). He has team lead experience managing teams both onsite as well as offshore. He has experience in managing large databases sizes ranging from 30GB to 5TB and has excellent knowledge in RAC, Data Guard, Export/Import, expdp/impdp, RMAN, SQL*Loader, Oracle Enterprise Manager (OEM). He has strong experience working in a production environment along with design continuity of business plan for database and provides support and recommendation with high quality. He has excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Operating Systems: HP-UX 11.23i, Solaris 9.0/10, RHEL 5.6, AIX 5.1, 6.1

Databases: Netezza 6.0.2/7.0.2/7.2.0 Oracle 10g R2, 11g R1, R2, 12c.

Applications: Connect: Direct Server, FA Select., secure y FTP+

Remote Proxy (FTP secure), OAS (Oracle Application Server 10g), Oracle RDBMS 8i, 9i, 10g R2, 11g R2, 12c Oracle Data Guard 10g y 11g R2, 12c Oracle Grid Control 10g R2, 12c SQL, PL/SQL, Performance Reports AWR, ASH, ADDM.

Languages: SQL, PL/SQL, Shell scripting in Kron-shell, C-shell,

Tools: OEM, RMAN, SQL*Plus, SQL*Loader, Oracle Export/Import, Toad,

MKS, JIRA, CA Remedy for ticket management, Netezza Admin tool,

Aginity Netezza Workbench, Golden Gate

PROFESSIONAL EXPERIENCE:

Catalina Marketing Oct 16 – Till Date

Role: Lead Database Administrator

Project Vault Retailer Integration, St. Petersburg FL

Description: Catalina Marketing is the largest promotion and coupon supplier to retailers and consumer in the world and throughout the United States. I am working as a DBA. There are more than 50 production and Test/DEV/QA DB with RAC, Golden Gate configuration and monitoring, ASM in Oracle 10g, 11g and 12c and Data warehousing on IBM Netezza 7.0.2.5 /IBM PureData 7.2.0.5.

Responsibilities.

Supported 100+ production instances of large databases of Oracle and Netezza.

Managing Oracle Database with RAC and Non-RAC with ASM file system.

Experience in High Availability of system with GRID infrastructure.

Monitoring and handling of Extract, Pump and Replicat process on Oracle Golden Gate.

Netezza Full and Incremental Backup, Restore, NZ_DDL_Backup, Schema Backup and Prod to Dev refresh databases.

Users, Roles, grants, Groups, Security and Resource utilization of Netezza.

LDAP configuration on IBM Puredata systems (MAKO 7.2.0.5).

Call Home setup, Netbackup Client Installation, FailOver Testing on IBM Puredata systems (MAKO 7.2.0.5).

NZ online and Manual Vacuum Health Check, Cluster Health check in Puredata.

Netezza Monitoring setup like SNMPV2, Check Views, Disk Monitor, Table Size Skew, NZ Portal configuration.

Netezza Maintenance activity like Hostbackup, Nz groom, NZ Gather Stats, Performance Load report.

Expert technical design and Netezza database administration knowledge and automation of all backup, restore Monitoring and maintenance activity.

Experience in applying critical patches and patch sets whenever required.

Experience in Oracle Enterprise Manager (OEM) Grid Control, TOAD, RMAN.

Exposure in nznackup, nzrestore, nz_migrate and all IBM utility.

Experience in communication IBM and oracle support

Loads databases, reorganizes as necessary, and assists in monitoring database performance

Developing and Implementing Disaster Recovery (DR) Plan using Datagaurd.

I along with team implemented physical Standby database using Datagaurd.

Daily Health Check Up of the Database using staspack, AWR, ADDM & ASH.

Rebuilding of Indexes for better performance, maintenance of Oracle Database.

Maintaining security of databases and users.

Automation of Startup Shutdown on all Production and Development Database.

Installation and configuration of Oracle Client software and Tools.

Restoration of Data for users in the event of requirement or system crash.

Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints.

Environment: Oracle 10g/11g and 12c RAC and non RAC production databases and standby databases on Linux 5, 6 platform and Data warehousing on IBM Netezza 6.0/7.0. Postgressql 9.3, 9.4

Guitar Center ITO Jul 15 – Oct 16

Role: Lead Database Administrator

Project Guitar Center ITO, Thousand Oaks, CA

Description: Guitar Center is the largest chain of musical instrument retailers in the world with 269 locations throughout the United States. I am working as a DBA. There are more than 50 production and Test/DEV/QA DB with RAC, Golden Gate configuration and monitoring, ASM in Oracle 10g, 11g and 12c and Data warehousing on IBM Netezza 7.0.2.5 /IBM PureData 7.2.0.5.

Responsibilities.

Supported 50+ production instances of large databases of Oracle and Netezza.

Configuration of Golden Gate in RAC and Non-RAC environment.

Setup Golden Gate monitoring using JAGENT in OEM 12c.

Configuration of Golden gate on NFS and DBFS.

Managing Oracle Database with RAC and Non-RAC with ASM file system.

Experience in High Availability of system with GRID infrastructure.

Monitoring and handling of Extract, Pump and Replicat process on Oracle Golden Gate.

Netezza Full and Incremental Backup, Restore, NZ_DDL_Backup, Schema Backup and Prod to Dev refresh databases.

Users, Roles, grants, Groups, Security and Resource utilization of Netezza.

LDAP configuration on IBM Puredata systems (MAKO 7.2.0.5).

Call Home setup, Netbackup Client Installation, FailOver Testing on IBM Puredata systems (MAKO 7.2.0.5).

NZ online and Manual Vacuum Health Check, Cluster Health check in Puredata.

Netezza Monitoring setup like SNMPV2, Check Views, Disk Monitor, Table Size Skew, NZ Portal configuration.

Netezza Maintenance activity like Hostbackup, Nz groom, NZ Gather Stats, Performance Load report.

Expert technical design and Netezza database administration knowledge and automation of all backup, restore Monitoring and maintenance activity.

Experience in applying critical patches and patch sets whenever required.

Experience in Oracle Enterprise Manager (OEM) Grid Control, TOAD, RMAN.

Exposure in nznackup, nzrestore, nz_migrate and all IBM utility.

Experience in communication IBM and oracle support

Upgraded the databases to version 11g from 10g. Installed, Setup, Configured Oracle version 11g, 12c on RHEL 6

Up-gradation and Migration of Database from 10g to 11g, 12c and then applying patches whenever required.

Handling 11g RAC on nodes for high availability.

Experience in Working with RAC Databases.

Hands on experience in troubleshooting RAC environment, using srvctl, crs_stat and crs_profile.

Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, STATSPACK.

Loads databases, reorganizes as necessary, and assists in monitoring database performance

Developing and Implementing Disaster Recovery (DR) Plan using Datagaurd.

I along with team implemented physical Standby database using Datagaurd.

Daily Health Check Up of the Database using staspack, AWR, ADDM & ASH.

Rebuilding of Indexes for better performance, maintenance of Oracle Database.

Maintaining security of databases and users.

Automation of Startup Shutdown on all Production and Development Database.

Installation and configuration of Oracle Client software and Tools.

Restoration of Data for users in the event of requirement or system crash.

Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints.

Environment: Oracle 10g/11g and 12c RAC and non RAC production databases and standby databases on Linux 5, 6 platform and Data warehousing on IBM Netezza 6.0/7.0. Postgressql 9.3, 9.4

Media Math, NY Oct 13 – Jun 15

Role: Lead Database Administrator

Project: MathTag, NY

Description: MediaMath is a US based leading provider of online advertising project. Working as a Lead DBA. There are more than 20 production and Test DB with RAC and single Instance in Oracle 10g, 11g and 12c and Data warehousing on IBM Netezza 6.0 and PostgreSQL.

Responsibilities:

Installation and configuring of Oracle 10g/11g, RAC, ASM Production and Development database server as per the business need.

Manage all the Production/Standby databases through OEM Grid control window.

Silent mode installation of the Grid Agent on the client Production Databases.

Monitor the Performance and Alerts through OEM Grid control.

Do works over RAT utility on Dev/Test database before Go-live any Patch/Upgrade.

Upgraded the Production and Standby Databases from Version 11201 to 11203.

Applying hot patches to the Prod/Dev databases through OPatch utility.

Monitoring and maintenance of Dataguard.

Resolving the out of sync issues of Standby Database.

Exposure in nznackup, nzrestore, nz_migrate and all IBM utility.

NZ online and Manual Vaccum Health Check, Cluster Health check in Puredata.

Netezza Monitoring setup like SNMPV2, Check Views, Disk Monitor, Table Size Skew, NZ Portal configuration.

Netezza Maintenance activity like Hostbackup, Nz groom, NZ Gather Stats, Performance Load report.

Expert technical design and Netezza database administration knowledge and automation of all backup, restore Monitoring and maintenance activity.

Generate the Hang analyze, System State Dump report while the DB becomes hung or unresponsive and with the help of that report I back the DB to the normal state without bounce the DB.

Environment: Oracle 10g/11g and 12c RAC and non RAC production databases and standby databases on Linux 5, 6 platform and Data warehousing on IBM Netezza 6.0.Postgressql 9.3, 9.4

Oceaneering International services Limited Sep 12 – Sep 13 Role: Oracle DBA

Project: Oceanet

Description: Oracle DBA on more than 200 production and Test Databases with RAC and single Instance Oracle 10g, 11gR2 and 12c, Netezza 6.0 on Linux 5 platform, which is using PeopleSoft application with Financial, HR and Portal environment.

Responsibilities:

Installation, upgradation and Maintenances of Oracle Databases on Linux & Windows platforms.

Backup of database Logical and Physical and also using RMAN.

Perform database monitoring, capacity planning and performance tuning.

Recovery of database in case of database crash, disk/media failure, etc.

Provided System support for both development and 24/7 production environment.

Prepared plans for up gradation of all critical Production Databases from 9i to 10g on Linux and DATAGUARD implementation.

Performed capacity planning and sizing of databases based on input from business.

Exposure in nznackup, nzrestore, nz_migrate and all IBM utility.

NZ online and Manual Vaccum Health Check, Cluster Health check in Puredata.

Netezza Monitoring setup like SNMPV2, Check Views, Disk Monitor, Table Size Skew, NZ Portal configuration.

Netezza Maintenance activity like Hostbackup, Nz groom, NZ Gather Stats, Performance Load report.

Experience in applying critical patches and patch sets whenever required.

Experience in Oracle Enterprise Manager (OEM) Grid Control, TOAD, RMAN.

Configuration of tnsnames.ora, listener.ora and sqlnet.ora files after upgrading databases.

Performed database cloning from old system to new system.

Used EXPORT/IMPORT for table level and full database de-fragmentation.

Transported tablespaces between production and development databases.

Recovery of database in case of database crash, disk/media failure, etc.

Provided System support for both development and 24/7 production environment.

Prepared plans for up gradation of all critical Production Databases from 9i to 10g on Linux and DATAGUARD implementation.

Performed capacity planning and sizing of databases based on input from business.

Performed database cloning from old system to new system.

Used EXPORT/IMPORT for table level and full database de-fragmentation.

Environment Oracle 10g, 11g RAC, Netezza 6.0 and non RAC production databases Linux/ Windows NT platforms with PeopleSoft Application 8.52, Weblogic

CMC Limited Sep 10 - Sep 12

Role: IT Engineer

Project: Numonyx

Description: 43 live, 42 QA, 9 DEV, 34 T&I databases at WWDC and some RAC databases. Databases designed in oracle 10g with J2EE front on Sun solaries 5.9 and HP UNIX. The companies neither make NOR flash memory devices, which are used in cell phones, digital still cameras, MP3 players, and PCs.

Responsibilities:

24/7 Production Database Administration Support

Implemented Golden Gate for Standby Configuration and developed procedures for Replication.

Monitored the growth of the database objects for capacity planning.

Has primary responsibility for Oracle Database and Application performance tuning, physical/logical design and optimization and availability.

Used Flashback Technology-Query, Table, Drop and Database to undo specific transactions, provided point-in-time recovery of database objects, recovered database objects and rewind entire database to a particular time respectively.

Perform requirements gathering, data mapping, metadata management and database modeling.

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.

Checking CRON jobs. Monitoring Application specific background processes.

Performing Online and Offline database backups on schedule.

Developing & Implementing Disaster Recovery (DR) plan using Datagaurd.

Scripting of Automated backup for Cold / Hot backups.

Implementation and Configuration of OEM & Oracle Management Server for maintenance and monitoring.

Environment: HP BL460c Gen8 Blades with (2) 8-core 2.2GHz Intel Xeon E5-2660.CPU’s and 800GB, OEL6.4 x86-64 S/w: Oracle 11gR2 Tools: OEM .Grid, Nagios, Monolith, Putty and Net Backup.

E-net systems India Pvt. Limited Jun 08 - Sep 10

Role: Oracle DBA

Project: BSNL Amc.

Description: Database designed in oracle 9i/10g with D2K front on Linux environment, it’s a billing systems database generates bill of customer and also contains customer details and its bills with call time.

Responsibilities:

24/7 Production DBA Support

Perform requirements gathering, data mapping, metadata management and database modeling.

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.

Maintaining security of databases and users.

Reading Alert Log and User trace Files and Diagnosing the Problem.

Automation of Startup Shutdown on all Production and Development Database.

Backup and recovery using RMAN Utility.

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.

Checking CRON jobs. Monitoring Application specific background processes.

Performing Online and Offline database backups on schedule.

Developing & Implementing Disaster Recovery (DR) plan using Datagaurd.

Restoration of Data for users in the event of requirement or system crash.

Scripting of Automated backup for Cold / Hot backups.

Environment: Oracle 9i/10g production/test databases and standby databases on Linux 5 platform. OEM, Putty, Toad 9.0

EDUCATIONAL QUALIFICATIONS:

Bachelor of Technology in Commuter Science and Information Technology in 2008 from MJRU, Bareilly, India

Contact this candidate