SUMMARY:

• Optimized performance impacting batch loads, critical business reports (Micro strategy) and saved a lot of resources and time which helped business to complete the loads and reports way before the SLA deadline.
• With the saved resources, we were able to push more workload with the same capacity.
• Optimized workload settings which helped to avoid AWT flow control situation, helped tactical queries to meet the required SLAs and helped to resolve critical report delay issues.
• New workload was setup to accommodate business requirements without impacting other workloads.
• Demonstrated experience with designing data architectures for integrated projects and ensuring the table structure (with proper Indexes, PPIs, SET, MULTISET etc.) is designed perfectly to get maximum performance and make the best used of sophisticated Teradata optimizer.
• Closely working with the business, data modelling, ETL team and translation business requirements into technical requirements.
• Successfully planned, tested and implemented the Data Stream architecture solution for Backup and Recovery replacing the current backup and recovery solution which we had. Also, planned and implemented the Backup and Restore strategy along with retention.
• Worked on NetVault, TARA and Arcmain.
• Successfully implemented the PDCR retention specific to our company requirements.
• Installation and maintaining PDCR.
• In - depth knowledge of ResUsage and DBQL.
• Fastload, Multiload, Fast Export, BTEQ, Tpump, TSET, Visual Explain, Teradata Administrator, GDO, Viewpoint, DBSControl, DIP, CTL, Reconfig, statistics wizard, index wizard, etc.
• Involved in yearly protegrity key rotation process and working on protegrity related issues.
• Performance report analysis
• Monitoring KPIs and working on KPIS and ensure all business SLAs are met.
• Capacity planning and Performance monitoring
• All Teradata DBA administration tasks on Linux environment including shell scripting (creation of reusable components).
• Support Security audits for Teradata, Aster.
• Streamlining process, creating new processes and procedures and documenting as per industry best practices, services and methodologies.
• Setting up various alerts through Viewpoint
• Experience in software development methodology and software development life cycle (SDLC).
• Mentoring and guiding development team during the complete life cycle to develop projects.
• Investigates and provides insights about new Teradata features and new technologies to meet organization business needs.
• Working on POCs for new features and implement them accordingly if it benefits the business.
• Teradata training for Business teams
• Providing Teradata training sessions for Business users and guiding them to script performance efficient SQLs.
• All Aster database administration tasks
• Database/Schemas/User/table/view creation.
• Managing access rights through roles
• Space management
• Automation - Table and user retention process
• Software upgrades
• Moving data from one system to another Aster system
• Installing and configuring database connectors to connect to various data sources and extract data from Aster.
• Installing Aster functions used for various analytics as per business requirements.
• Successfully installed Asteron Hadoop
• Successfully configured LDAP.
• Installed and configured required database connectors to connect to various sources from Aster
• Installed required Aster analytics functions.
• Excellent knowledge of Hadoop architecture and various components such as HDFS, Name Node, Data Node, YARN Resource manager, Zookeeper, H-Base, Sqoop, Oozie, Hive etc.
• Provisioning, managing and monitoring Hadoop cluster using Ambari.
• Maintaining security policy controls for HDFS, YARN, HBASE, Hive and SOLR.
• Upgrading Hadoop cluster
• Commissioning and decommissioning nodes
• Currently working on Kerberos POC.

PROFESSIONAL EXPERIENCE:

Associate Lead Consultant

Confidential

Responsibilities:

• Leading a team of 8 Performance DBAs for Confidential .
• Achieved required business critical SLAs by optimizing various loading jobs, application and reporting queries with various performance optimization techniques (Stats, PPI, Indexes, Join Indexes, Horizontal and vertical partitioning, derived tables, volatile tables etc.)
• Saved millions of CPU due to which our client is able to run more workload on the system with the same capacity.
• Analyzing workload and recommending suggestion so that system performs at its optimal best.
• Database design.
• Guiding the development, application teams, and Business IT users to rewrite queries and provide suggestions to make the best of sophisticated Teradata optimizer.
• Responsible for presenting performance reporting (weekly, monthly, quarterly) and analysis using PDCR and Tableau.
• Was also leading a team of 3 Performance DBAs for Confidential and a team of 2 Performance DBA for Confidential
• Coaching team members.

Production support DBA

Confidential .

Responsibilities:

• Actively involved in software and hardware upgrades.
• Responsible for monitoring the system, management of users, space, access, statistic collection, database clean up, roles and profiles, databases/table creation and defining the indexes depending on the details from DA document, suggesting PPI, SI etc.
• Preparing backup strategies, monitoring scheduled backups, restoring objects as per user requirements using NetVault and TARA GUI.
• Viewpoint alert configuration.
• PDCR installation and maintenance.
• Responsible for preparing and presenting weekly, monthly and quarterly reporting (using PDCR).
• Shell scripting.
• 24*7 support.

ERP consultant

Confidential

Responsibilities:

• Worked as an Oracle Applications DBA responsible for end to end maintenance of Oracle Applications business suite.
• Implement and maintain database security (creating and maintain user, profiles, roles, assign privileges)
• Monitoring the system through OEM, managing tablespaces (adding datafiles), monitoring jobs.
• Configuring Enterprise Manager Grid Control
• Cloning, upgrade of Oracle Application business suite and troubleshooting.
• Patch management and version control.
• Set up and maintain documentation and standards.

Oracle DBA/Oracle Applications DBA

Confidential

Responsibilities:

• As an Oracle Apps DBA, was responsible to monitor and maintain Oracle Applications business suite.
• Cloning, Upgrade of Oracle Applications business suite.
• Implement and maintain database security (create and maintain user and roles, assign privileges)
• Installation, configuration and upgrading of Oracle database and standby databases.
• Backup using RMAN and traditional backup.
• Perform general technical troubleshooting and give consultation to development teams.
• Shell scripting.
• 24*7 Support.