Sanjeev Kumar Pandey

Netezza Resposiblities :

• Netezza Appliances (Striper, Mako and NPS) Regular Maintenance & Monitoring make sure optimum performance & High availability.
• Helping to move data to AWS cloud also worked on Amazon DynamoDB to maintain non- relational Data.
• Implemented WLM on QA/DR & PROD Appliances also setup Resource flip for Resource Groups Business hours and off-Business hours.
• Managing the hardware, configuration settings, system status, access, disk space, usage, upgrades, and other tasks.
• Performing scheduled Monthly Maintenance on all Netezza Appliances (Vacuum, Power Cycle Hardware, Scan and Grooms & Check and Purge Orphan Tables).
• Implemented Best Practices to improve performance & availability.
• Perform Data refresh using nz_migrate/backup & restore between Prod to lower environments DEV, QAE and UAT. Also, within the system too.
• Helped the Development team to develop Logical data models with proper types and Distribution Keys. Then Implemented Physical data models on DEV, QA/UAT & PROD.
• Performing scheduled Software upgrade NPS 7.2.1.2-P1 to NPS 7.2.1.4-P3 [Build 105] and recently to NPS 7.2.1.9 [Build 40] on all Appliances.
• Setup Automated NZBackup & NZRestore PROD to DR Diff & Full.

Teradata Responsibilities :

• Administered Teradata Servers across the globe, monitor the performance of databases and make tuning changes, researched and evaluated alternative solutions related query performance and recommended the most cost-effective design solutions.
• Responsible for Patch upgrades, performance monitoring, responding to Alerts, tuning, creating appropriate Indexes, and creating Incidents with Teradata and assistance/follow up with the CSR.
• Developed Shell Scripts, Stored Procedures and Macros in order to automate to run based on the frequency.
• Responsible for Implementing compression across tables in the system and analyzing the impact.
• Responsible for producing Daily, Weekly and Monthly system health reports.
• Run different monitoring scripts to know the health of the database and pinpoint suspected issues and fix it before it happens to fail.
• Worked towards database health reporting and capacity management.
• Administered and supported Teradata systems across multiple global environments ensuring high availability and performance.
• Performed Teradata system monitoring, space management, CPU usage tuning, and proactive workload management using TASM.
• Analyzed and optimized SQL queries using Explain plans, collected stats, and implemented secondary indexing to enhance performance.
• Managed Teradata Viewpoint for workload alerts, query performance analysis, and system health monitoring.
• Automated Teradata health checks and space usage reports using shell scripting.
• Coordinated with application teams and Teradata support (CSR) for patching, upgrades, and incident resolution.
• Implemented Multivalue Compression (MVC) across large fact tables to improve I/O efficiency and storage utilization.
• Created and maintained access rights, profiles, and role-based security, ensuring data governance and compliance.
• Designed and implemented disaster recovery strategy including full and incremental backups using NetBackup and Teradata BAR utilities.
• Led capacity planning efforts and provided recommendations to accommodate future data growth.

• RESPONSIBILITIES AS LEAD SENIOR NETEZZA DBA:
• Netezza Appliances (Striper, Mako and NPS) Regular Maintenance & Monitoring make sure optimum performance & High availability.
• Helping to move data to AWS cloud also worked on Amazon DynamoDB to maintain non- relational Data.
• Implemented WLM on QA/DR & PROD Appliances also setup Resource flip for Resource Groups Business hours and off-Business hours.
• Managing the hardware, configuration settings, system status, access, disk space, usage, upgrades, and other tasks.
• Setup NZ Alerts including Long Running Queries on QA/DEV & PROD Appliances Performing system.
• Monitoring, User & Application security utilizing NZ_Admin, Aginity & NZ_Portal utilities. UNIX commands & Writing Cron scripts.
• Release Management Ad-hoc Monthly Releases as needed and Scheduled Quarterly Release on QA/DR & PROD Servers.
• Performing scheduled Monthly Maintenance on all Netezza Appliances (Vacuum, Power Cycle Hardware, Scan and Grooms & Check and Purge Orphan Tables).
• Implemented Best Practices to improve performance & availability.
• Perform Data refresh using nz_migrate/backup & restore between Prod to lower environments DEV, QAE and UAT. Also, within the system too.
• Helped the Development team to develop Logical data models with proper types and Distribution Keys. Then Implemented Physical data models on DEV, QA/UAT & PROD.
• Performing scheduled Software upgrade NPS 7.2.1.2-P1 to NPS 7.2.1.4-P3 [Build 105] and recently to NPS 7.2.1.9 [Build 40] on all Appliances.
• Setup Automated NZBackup & NZRestore PROD to DR Diff & Full.

• RESPONSIBILITIES AS NETEZZA DBA:
• Netezza PROD/DR/Lower env’s, Appliances (TF, ST & Mako’s) Regular Maintenance & Monitoring to make sure optimum performance & availability.
• Data refresh from PRD to lower env for Data modelers and development teams for validation of releases.
• Perform release activities into QAE and then PRD Bi-weekly.
• Monitoring Long Running Queries alerts and investigating queries and contact users and management.
• Performing system Monitoring,User & Application security utilizing NZ_Admin, Aginity & NZ_Portal utilities. UNIX commands & Writing Cron scripts.
• Implemented Best Practices to improve performance & availability.
• Perform System Administration tasks like creating Linux ID’s, Deploying.
• Installing Netezza clients, Managing Netezza system, System notifications and events, Managing Netezza users and groups, Backup and restoring databases, Collecting and evaluating history data & Workload management.
• Managing the hardware, configuration settings, system status, access, disk space, usage, upgrades, and other tasks.
• Managed Software upgrade NPS 7.2.0.2-P1 to 7.2.1.9-P2 all three PROD Appliances. Dealing with Vendor resolving PMR, System & Software Upgrades.
• Interact with client daily basis with updates and issue resolutions as client facing role Worked with Team of four offshore DBA for 24/7 coverage.

• RESPONSIBILITIES AS NETEZZA DBA:
• Netezza Warehouse Performance Appliances (Striper N2002-040, Mako N3001-030) Maintain 3 Production server and One Development server.
• Maintaining a total 72 databases with a total 295 TB in size.
• Performance Backup & Restores, Host Backups and Data & Object migrations within the Appliance.
• Maintaining GRA according to workload on server Groom the database periodically and Generate Statistic.
• Upgrading NPS with the latest release and applying patches with the support.
• Database and database object creations, User, Group, resource group and manage them Database copy or migration from one Netezza server to another Netezza server SPU/SPA monitoring and coordinating SPU and disk fail-over.
• Monitor the locks and release the locked objects.
• Identify space skew for a particular SPU.
• Distribution key handling on tables with huge data.
• Generating statistics on tables (Express & Full).
• Disk self-test and throughput checking.
• Taking all types of Backups like DDL, total data, tables alone, Schema, Global and full database etc.
• Migration of all the objects from one database to another.
• Monitoring the alerts, Jobs scheduling, space utilization.

• RESPONSIBILITIES AS ORACLE DBA:
• Installing and maintaining the Oracle database software.
• Setting up database user accounts.
• Training users on how to access the information in the database.
• Finding and debugging malfunctioning programs affecting the database integrity.
• Creating autonomous database backups.
• Regularly updating the database security protocols.