SUMMARY:

• Over 8+ years of Dynamic IT career reflecting pioneering experience and high performance in Database Administration and maintenance using Confidential Netezza 6.x/7.x, Hadoop, AWS Redshift and Tableau.
• Experience in regular Database Administration activities such as Upgrades, Migration, Patches, Cloning, Backups and Recovery Manager, script development, and documentation.
• Exposure in Data Warehouse systems Netezza (NPS), Big Data, AWS Redshift and BI Tools like Tableau and Microstrategy.
• Efficient in configuring and monitoring Backups in AWS Redshift,Netezza, Hadoop and Tableau.
• Excellent interpersonal and strong analytical, problem - solving skills with customer service oriented attitude.
• Good co-ordination and communication with System Administrators, Business Data Analysts and Development teams.
• Good experience in sys admin activities like creating, activating & managing user accounts & responsibilities and profiles.
• Expertise in space management & database storage management.
• Ability to work as an individual towards the team goal.
• Flexible to move anywhere based on the requirements.
• Good Team player, highly motivated, hard working towards the commitment.
• Willingness to work in a highly dynamic environment and ready to take up challenges.
• Creative, self-motivated and committed to excellence under minimal supervision.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Have 6+ months of experience on AWS Redshift
• Worked as part of the AWS Built team, planned, deployed, monitored, and maintained Amazon AWS Cloud infrastructure consisting of multiple EC2 nodes.
• Responsible for S3 bucket creation, writing policies and IAM role based policies
• Created bucket policies to encrypt data stored in S3 buckets and generated life-cycle policies to manage cost-effective storage.
• Created and configured elastic load balancers and auto scaling groups to distribute traffic and to have a cost efficient, fault tolerant and highly available environment.
• Involved in creating IAM Users, Groups, Roles, Identify Providers and defining Policies and applying to IAM Users and Groups.
• Taking Manual snapshots and restore from snapshots
• Restores using Unload and copy commands from S3 Buckets
• Used Lambda Functions Along with API gateway to effectively maintain server less Architecture.
• Used security groups, network ACL's, internet gateways
• Designed AWS Cloud Formation templates to create custom sized VPC's, Subnets, to ensure successful Cloud deployments and database templates.
• Have 8+ years’ experience on Netezza
• Supporting the NPS twinfin and striper servers for end to end solutions
• Have used nzbackup and nzrestore to backup and restored the big databases from one server to another server during the migration.
• Extensively used nzsession, nzsystem, nz skew, nzstats and nz health utilities to monitoring the skew and distribution of all tables, NPS server issue for better performance
• Established security LDAP authentication, users and groups
• Used nz migrate, nzload to load and unload the data from text files and other databases
• Have renamed the old Netezza sever with new name
• Used nzstop, nzstart to restart the NPS and have done manual vacuum using nz manual vacuum
• Have configured history database to collect all column and table level history info.
• Created databases and designed the database objects with appropriate parameters
• Upgraded NPS 7.1.0.4 to 7.2.1.4
• Co-ordinated with NZ support to resolve many other issues, disk replacements and hardware components replacement.
• Wrote shell scripts to automate ETL jobs, nz process related jobs, groom, genstats etc
• Have monitored the performance issues, database usage, hardware components SPUs, SPA, Disks and raise PMRs with Confidential NZ support to resolve the issues and upgrades.
• Installed setup of SQL extensions and INZA on the Netezza performance server
• Have 2+ years’ experience on Tableau
• Familiar with Installation, configuration, patching and upgrading of Tableau tool across the environments
• Manage the application’s users, groups, and integration with Active Directory
• Automate monitoring & server job processes
• Should be capable of doing Tableau Server Management (like Clustering, Load Balancing, User Management etc)
• Knowledge of Tableau Licensing
• Should be familiar with tableau migration and scheduling.
• Experience in taking back ups and restoration of Tableau repository
• Good knowledge on Tableau Metadata tables and Postgre SQL
• Have 2+ years’ experience on Hadoop
• Responsible for implementation and support of the Enterprise Hadoop environment.
• Involves in designing, capacity arrangement, cluster set up, performance fine-tuning, monitoring, structure planning, scaling and administration.
• Work closely with infrastructure, network, database, business intelligence and application teams to ensure business applications are highly available and performing within agreed on service levels.
• Implement concepts of Hadoop eco system such as YARN, MapReduce, HDFS, HBase, Zookeeper, Pig and Hive.
• In charge of installing, administering, and supporting Windows and Linux operating systems in an enterprise environment.
• Accountable for storage, performance tuning and volume management of Hadoop clusters and MapReduce routines.
• In command of setup, configuration and security for Hadoop clusters using Kerberos.
• Monitor Hadoop cluster connectivity and performance.
• Manage and analyze Hadoop log files.
• File system management and monitoring.
• Develop and document best practices
• HDFS support and maintenance.
• Setting up new Hadoop users.
• Responsible for the new and existing administration of Hadoop infrastructure.
• Include responsibilities like data modeling, design and implementation, software installation and configuration, database backup and recovery, database connectivity and security.

Confidential

Responsibilities:

• Confidential Netezza (NPS) Administration.
• Good Understanding of the Netezza Architecture and underlying data distribution
• To ensure the Gen Stats updated on all respective tables in Netezza.
• Handle Materialize views, zone maps for performance tuning.
• Performance Tuning in Netezza and writing ADOC Queries (NPS Netezza Performance Server)
• Good experience on NZSQL, NZ MIGRATE, NZLOAD, NZBACKUP, NZRESTORE, NZPLSQL
• Creating and Maintain the Database on NPS.
• Creating and Monitoring Netezza event manager alerts
• Managing all kind of NZSQL utilities process.
• Creating user, groups and grant the respective permissions
• To migrate data from various NPS to another NPS system
• Data Migration and Up gradation of Netezza system.
• Writing Shell scripts.
• Query History maintenance.
• Experience with PMR - raising and providing support.
• Handling the SAN storage activity.
• Scheduling Incremental & Full Backups

Confidential

Responsibilities:

• Upgraded oracle database from 10g to 11g.
• Creating, configuring and maintaining oracle 11g database based on specifications using dbca and manual methods.
• Applying patches for Oracle databases.
• Maintaining Control file, Redo log file, Data file.
• Database refreshes using exp/imp and expdp/impdp.
• RMAN Managed and User Managed Backup and Recovery operations.
• Oracle Database refresh / Migration from Production to Development.
• Data Guard - Maintenance of Standby database.
• Proactive monitoring for production databases.
• Hands on experience on Linux installation and RPM's installation.
• Database administration tasks included performing regular Hot & Cold Backups, Job Scheduling.
• Data transferring with Export/Import, Data Pump, Transportable table spaces.
• Oracle Enterprise Manager (OEM) database control.
• Performed operations like creations of users, session management, and grating privileges to users for database security.
• Creating Materialized-views and Database Links.
• Handling Incident, Work Request and RFC via ticketing system.
• Oracle Data Integrator (ODI) Administration.
• FMW ODI11g Upgrade.
• Installation, configuration and maintenance Oracle Data Integrator (ODI), MSTR on Windows system.
• BI Tool Microstrategy Administration.
• Confidential Netezza (NPS) Administration.
• WebLogic Server setup and Administration.
• ODI and MSTR Code Deployments.
• Responsible for User Accepting testing (UAT)