SUMMARY:

• Having 7+ years of experience as a IT professional with expertise in Netezza,, Unix/ Linux, Data Architecture, Data Modeling, application development/ support and DBA.
• Having around 4 and half years of experience in Netezza database administration and data warehouse development.
• Expertise in Netezza features and tools.
• Expertise in writing SQL queries and optimizing the queries in SQL Server 2008, Netezza.
• Experienced in Data Transformations, Data Loading, Database Modeling and Performance Tuning.
• Databases migration from one host to another.
• Expertise in NZBACK and NZRESTORE from Storage Managements like TSM & SAN
• Good experience in using NZSQL and NZLOAD utilities.
• Experience in building Data Warehouse life cycle development.
• Experience in performance tuning techniques on Targets, Sources, Mappings and Sessions.
• Experience in implementing update strategies, incremental loads and change data capture.
• Good experience in performance tuning techniques on Targets, Sources, Mappings and Sessions.
• Experience in technical design and documentation.
• Experience in writing SQL and PL/SQL and extensively used SQL, Transact SQL and PL/SQL to write stored procedures, functions, packages and triggers.
• Experience in communicating with customers and business partners for their business needs.
• Strong leadership, excellent communication, analytical, design and development skills with customers, end users and colleagues.

TECHNICAL SKILLS:

Languages: C, Java, SQL, PL/SQL, Shell Scripting

Databases: Netezza V 6.0/7.0/7.1/7.2, MSSQL Server 2000/2005/2008/2012/2014, IBM DB2 v 8.0/9.1/9.5, MS Access 2003/2007/2010

Operating Systems: Redhat Linux, UNIX (Solaris, HP - UX, IBM-AIX), Windows XP/2000/NT/98/95.

Data Modeling Tools: Power Designer 16.0/15.0, Erwin 8.1/7.2

ETL Tool: Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Repository Manager)9.0.1, 8.6/8.1/7.1/6.2

PROFESSIONAL EXPERIENCE:

Confidential, Schaumburg, IL

Netezza DBA/Developer

Environment: NetezzaMako 7.2.05 ( N3001 -10,N3001-05), Twim-fin 7.2.0.5( TF 6 ), Aginity Work bench, Netezza performance portal, TSM

Responsibilities:

• Performing daily activities like server status, health check, stats and clean-up version tables and generating skew report.
• Executing the scripts provided by the production support, Dev and QA environment team.
• Production backups and monitoring the status through Netezza Admin tool.
• Taking hot backups for Dev and QA environment for validation and reporting.
• Migrating table to BigData environment using external tables.
• Changing distribution key for tables with high skew after discussing with Datamodular.
• Performance tuning the query especially for production support team.
• Recording Group and User level permission and grant permission if there is any job failure because of permission.
• Create BOE user and adding them to right groups and validating there access and reset the password if we face authentication error.
• Communicating with Production support, Dev, QA and TSM server team.
• Taking Backups and restoring the tables based on request.
• Running scripts to create objects and populate data on objects.
• Backup and Restore of database objects.
• Nzevents creation and monitoring.
• Checking the pg logs, dbos logs, etc. with respective to error the application faced.
• Creating Cluster Based Table, materialized views to enhance the performance.
• STOP and START the Netezza appliances in case of issues.
• Prepared best practices documentation for teams in writing NZSQL.
• Conducted sessions to help explain teams about the Netezza architecture and design.
• Using NZ Admin tool to check the hardware issues as well as data skew, stats, backup, database size.
• Writing shell scripts and automating tasks.
• Worked in estimating storage management and capacity planning.
• Worked as an On Call DBA for production support and keep the system available.
• Prepared NZ RunBook to guide less experienced DBA’s.
• Worked with IBM folks on server upgrades like (NPS,FDR,DRDB and PMR)
• NZSESSION for monitoring and Performing Manual and online vacuum.

Confidential, Branchville, NJ

Netezza Database Administrator/Developer

Environment: Netezza Striper 7.1.0.2/7.2.0.5- p2 (N2002-005, N2002-002), IBM Clear Case, Aginity work bench 4.5, Tectia 6.1.0.668, Cognos 10, Toad 3.8.,Informatica Power Center 9.5.1, SSIS 2008/2012

Responsibilities:

• Based on Requirements creating new objects from data models / altering/ dropping physical database/ table/ external table/ views/ materialized views objects in development and production environments.
• Created Cluster Based Tables based by coordinating with Teams.
• Participated in designing the Informatica mappings and database.
• Migrated data from SQL Server to Netezza using NZ Migrate utility.
• Setup event rules for managing workload on the database server.
• Allocated resource groups for the app teams understating their requirements and work load.
• Worked on performance tuning Informatica source queries and session parameters.
• Worked with IBM Cognos reports and Cubes and helped tuning them.
• Monitoring workload and tuning them.
• Co-ordinate with application team to gather information about their business requirements and suggest the key selection during complex queries.
• Creating new user / new group and provide necessary Grant/Revoke privileges to nz user or nz group ids.
• Using “NZSQA” utilities to monitor the workload and resource allocations.
• Scheduled maintenance scripts on a weekly basis using CRONTAB.
• Monitoring catalog size and performing manual vacuum for the ongoing jobs and check issues
• Wrote stored procedures using NZPLSQL.
• Used NZSESSION to monitor the running queries/process/threads and killing them if needed
• Improving the query performance by generating statistics up to date using Genstats.
• Health monitoring of Netezza hardware and working with IBM Support PMR’s if any issues.
• Setting up Backup policy’s for databases by coordinating with Teams.
• Used EXPLAIN for performance tuning the queries to improve SQL and analyze the cost of the SQL.
• Installing patches for NPS.
• Attend calls to co-ordinate with application teams.
• Applying key distribution based on the tables relations as well as based on query.
• Running scripts to create objects and populate data on objects.
• Backup and Restore of database objects.
• Nzevents creation and monitoring.
• Checking the pg logs, dbos logs, etc. with respective to error the application faced.
• Creating Cluster Based Table, materialized views to enhance the performance.
• STOP and START the Netezza appliances in case of issues.
• Prepared best practices documentation for teams in writing NZSQL.
• Conducted sessions to help explain teams about the Netezza architecture and design.
• Using NZ Admin tool to check the hardware issues as well as data skew, stats, backup, database size.
• Writing shell scripts and automating tasks.
• Worked in estimating storage management and capacity planning.
• Worked as an On Call DBA for production support and keep the system available.
• Prepared NZ RunBook to guide less experienced DBA’s.

Confidential, Dallas, Texas

Senior Netezza Developer

Environment: Netezza 6.0.8(TF 12, TF 24), Informatica 9.1, Aginity work bench 2.1, Oracle 10g, Toad 9.6, Cognos 9, Microsoft VISIO 2010.

Responsibilities:

• Participated in gathering requirements, analysis, design, modeling, development, testing and implementation needed for loading and updating the warehouse.
• Used NZSQL/NZLOAD utilities and developed LINUX Shell scripts to load data from flat files to Netezza database
• Performed various DML, DDL...etc operations on Netezza database by using AginityNetezza work bench.
• Implemented LINUX functions using korn shell scripts for code optimization.
• Wrote several Netezza SQL scripts to load the data between Netezza tables.
• Used AUTOSYS job scheduler.
• Created Release manuals (RM) to move the code to QA to production.
• Involved in UAT support to resolve the issues encountered during the catch up loads and regular data loads.
• Involved in fixing invalid mappings, testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions Converted Oracle stored procedures to NZSQL equivalent.
• Improved the performance of batch with optimizing and tuning the Netezza SQLs to Redesigning Informatica mapping to handle multiple updates and deletes.
• Reclaiming the space for tables, databases using Netezza groom.
• Managing the data skew at all the Netezza tables.
• Status reporting to the client on a daily basis.
• Performed Unit Testing, User Acceptance testing to verify whether the data was loaded into target is accurate to meet the user requirements.
• Tracking tasks for their timely completion.
• Providing status reports to IBM management on a periodic basis and performed escalations to the PMO when required.
• Participating in User Meetings, gathering requirements and translating user inputs into technical specification documents.
• Participated in the preparation of Best Practices documentation.
• Coordinating deliverables from offshore development team

Confidential

Database Developer

Environment: Windows NT 4.0/2000 Oracle 9i, PL/SQL, SQL Plus, Shell Scripting

Responsibilities:

• Created database objects including tables, indexes, clusters, sequence roles and object views.
• Designed and implemented the entire database system using E-R Diagrams.
• Developed complex stored procedures, packages, triggers.
• Loading data into database tables from flat files.
• Preparing several reports based on the Client requirement by writing SQL queries.
• Created users and established the application security by creating roles.
• Involved in SQL Tuning of PL/SQL modules.
• Designed and developed validation procedures for query and update of data.
• Implemented shell scripts for scheduling batch jobs, diagnostics.