Database Administrator- Netezza | AWS Redshift | AWS PostgreSQLDBA responsibility1. Application• Designing schema, access patterns, locking strategy, SQL development, and tuning.• Modifying the database structure• Optimizing application and end-user queries (reactive tuning)• Archiving data• Generating needed ad hoc reports by querying from the database• Proactive performance tuning2. Access• Enrolling users and maintaining system security• Controlling user access to the database3. Database• Parameter configuration and tuning• Cache management• Job scheduling4. Monitoring• Alerting5 Assist junior database administrators with complex operational maintenance activities6. Act as the technical point of contact for day to day production support7. work closely with the Operational team to diagnose and resolve escalated technical issues with production systems8. Work with team on performance analysis and tuning of the databases and applications9. Participates in root cause analysis by gathering and reviewing pertinent logs and collaborating with peers and management

Netezza DBA Role and Responsibilities• Supporting and managing production, development and SIT Netezza systems – TwinFin12, P3 and P6. • Manage user/Groups access to applications and systems• Loading the data from external sources• Designing and implementing Netezza Backup and Restore strategy. • Database recovery• Space Management• Standby Database Activities (Groom, update Statistics)• Performance monitoring and tuning. • Working with vendor [IBM] to perform necessary hardware replacements and maintenance. • Helped development team in migration activities from P3 to P6 and to P12. • Implemented query history collection. • Created alerts and events for monitoring purpose using nzevent. • Analyzing query plans to identify the performance issues and suggesting necessary improvements.