SUMMARY:

• Highly creative and results - focused senior IBM DB2 and Netezza/Greenplum Big Data Architect candidate eager to offer 19+ years of progressive experience in leading complex worldwide projects, planning and implementing highly transactional databases and extremely large data warehouses using bleeding edge technologies, and building forward-thinking teams to provide superior customer experience.
• I would like to leverage my finance skills and find a bridge between finance and IT so complex models can be built to cater to the needs of the business.
• Around 19 Years of Experience in Information Technology
• 16 Years of Experience as DBA, 12 years working on DB2 UDB Administration on Unix (AIX/Solaris/Linux) and Windows, 4 years working on Netezza/Greenplum and 3 years in Oracle/SQL Server, 1 year experience in Paraccel
• Expertise in DB2 UDB, Big Data Netezza(Twinfin/Striper), Greenplum and Paraccel/Matrix (Columnar)
• Strong Expertise in Unix/Perl Scripting
• Migration Project experience from Oracle/SQL Server to DB2 UDB
• Concrete Knowledge and Experience in Business/Data Modeling, Documentation, Re-engineering, Development, Testing and Implementation
• Expertise in Data Database Design, Data Modeling and Data Warehousing
• Good Communication, Team and Interpersonal Skills
• Project Management/Team Management experience
• Can independently handle critical work requiring extreme planning, coordination and execution
• Have presented OPTIM tool at the IBM IOD Conference

TECHNICAL EXPERTISE:

HARDWARE: HP 3000, RS/6000, SOLARIS, IBM ES/9000, Z/OS, UNISYS 2200, IBM PC AND COMPATIBLES

OS: MVS S/370, S390, OS/2, UNIX - SOLARIS, LINUX, AIX, HP, WIN 98/NT

LANGUAGES: PERL, HIVE, ASP,L, JAVA, PL/SQL, DELPHI, COBOL, JCL, SQL, T-SQL,

DATABASES: DB2 UDB, NETEZZA, ORACLE, SQL SERVER, GREENPLUM, PARACCEL

TOOLS: ERWIN, TOAD, AGINITY, OPTIM PERFORMANCE MANAGER, SPUFI, WEBSPHERE INFORMATION INTEGRATOR, PVCS, VIASOFT, APACHE, CGI, SED, AWK, SED, MS EXCEL, MS WORD, MS ACCESS, MS VISIO, MQSERIES, HADOOP CLUSTERS, HDFS, MAPREDUCE

SECURITY: SSH, SSL, PGP

ADMIN TOOLS: SMIT, VMSTAT, IOSTAT, TOP, SAR, SMART DBA, DB2 PERFORMANCE EXPERT, SNAPVIEW, GREENPLUM PERFORMANCE MONITOR

NETWORKING: FTP, IFCONFIG, NETSTAT, HTTP, ETHTOOL

PROFESSIONAL EXPERIENCE:

Confidential

OS AND TOOLS: LINUX, AIX, SOLARIS, FEDERATION, PERL, DB2 ON DPF, ERWIN, TSM, SAN, SNAPVIEW, NETBACKUP, MS OFFICE, NETEZZA, PARACCEL

TEAM MANAGER

Responsibilities:

• Involved in the DB2 UDB, Netezza, Oracle and Greenplum database administration and managed work from business continuity teams from Offshore for about 15 applications.
• Documented and Established procedures for support and maintenance, backup and recovery, federation, MQT’s, replication etc. Involved in a few data warehousing projects from conceptual design, data modeling through implementation and continuous day to day support.
• Also involved in creating PMR’s to work with vendors on issues and upgrades. Also involved in creating PMR’s to work with vendors on issues and upgrades.
• Served as a Business Continuity Manager for Global Markets and Risk Technology domain
• Established Baselines and standards for DB2, Netezza and Paraccel
• Have worked with business data users to define the use of data within the risk application areas.
• Involved in identifying and recommending remediation of control gaps and implement effective risk controls of our data processes and systems.
• Involved in the design and architecture plan and hardware recommendation based on the Business Requirements
• Led user acceptance testing of data control, quality, cleansing and archival processes by working with several groups.
• Proactive monitoring of incoming data feeds and recommending optimal and efficient methods of storing data based on their data classifications.
• Involved in the backup/restore from DB2 UDB utilizing TSM, Nebackup for SAN/NAS
• Involved in the Design, Creation and Maintenance of DB2 Objects
• Involved in the Configuration and administration of HADR, SQL and Q Replication
• Involved in writing stored procedures and triggers for various requirements
• Expert in System level Performance Tuning and helped Application Developers with SQL query optimization
• Involved in establishing the database audit process across the bank
• Involved in the database upgrades from 9.1 to 9.7 and 9.7 to 10.1
• Have performed proof of concept for DB2 10.5 (BLU )
• Involved in the Data Modeling utilizing ERWIN
• Utilized Export, Import, Load, Reorg, Runstats
• Utilized OPTIM for performance tuning in addition to script level repository
• Utilized DB2 WLM for optimizing resources in the system
• Involved in the Netezza Upgrades for OS, HPF, FDT and NPS upgrades from 4.6 to 6.0, 6.5, 7.0 and 7.1
• Involved in Netezza administration, backup/restore, nz genstats, groom, vacuum etc.
• Utilized NZLOAD, WLM, nzevent, nzresponders, schedqueues, performance tuning of SQL, database, skew and designing CBT’s, and various other tools.
• Recommended best practices, tuned for star schema and dimensional modeling for Netezza
• Recommended registry variables that can lead to performance improvements
• Exploited Netezza WLM to throttle for resources in Netezza appliances depending on the day/night for ETL and user reporting
• Involved in testing Netezza Replication
• Involved in the Oracle database administration, performance tuning, Data Guard, RAC, backup and recovery, log, writing advanced PL/SQL, administration and management.

Confidential

OS AND TOOLS: UNIX AIX, WEBSPHERE INFORMATION INTEGRATOR, PERL, DB2 UDB ESE, ERWIN, TSM, SAN, SNAPVIEW

SENIOR DATABASE ADMINISTRATOR

Responsibilities:

• Involved in the DB2 UDB database administration and served as Onshore Coordinator for 40 plus applications, participated in SDI refresh of various applications. Documented and Established procedures for support and maintenance, backup and recovery, federation, MQT s, replication etc. Also involved in creating PMR s to work with vendors on issues and upgrades.
• Involved in the backup/restore from DB2 UDB utilizing TSM on SAN
• Involved in the Design, Creation and Maintenance of DB2 Objects
• Involved in writing stored procedures and triggers for various requirements
• Supported Application Developers with SQL query optimization
• Involved in the Data Modeling utilizing ERWIN
• Utilized Export, Import, Load, Reorg, Runstats

Confidential, NJ

OS AND TOOLS: UNIX AIX, WEBSPHERE INFORMATION INTEGRATOR, PERL, DB2 UDB ESE, ORACLE, ERWIN, SQL SERVER 2000, TSM, SAN, SNAPVIEW

SENIOR DATABASE ADMINISTRATOR

Responsibilities:

• Involved in the DB2 UDB data warehouse conversion, System Administration policy setup for the Licensing Database, Service Level Management Database from Oracle to DB2 UDB.
• Documented and Established procedures for support and maintenance, backup and recovery, federation etc.
• Involved in the setup of DB2 SQL Replication, creation of MQT s based on nicknames to better manage data across systems.
• Involved in the backup/restore from DB2 UDB utilizing TSM on SAN
• Involved in the Design, Creation and Maintenance of DB2 Objects
• Involved in the Configuration and Monitoring of SQL Replication
• Involved in writing stored procedures and triggers for various requirements
• Supported Application Developers with SQL query optimization
• Involved in the Data Modeling utilizing ERWIN
• Utilized Export, Import, Load, Reorg, Runstats