SUMMARY

• Senior Technical Associate having 7.6 years of experience in IT domain as a Database Administrator and worked with Teradata, which is the leader in data warehousing realm
• Certified Teradata Database 14 Certified Professional and Teradata Database 12 Administrator
• Worked as a Technical Lead Teradata Operations and Performance DBA with extensive experience in Teradata Database, Object Management, Database/User Management, Capacity planning, Shell scripting, Space Management, Administering Backups/Restore and Performance tuning on critical Production and Non - Production systems
• Extensive practical experience of primary Teradata technology/tools - SQL Assistant, Teradata Administrator, Teradata Manager, ViewPoint, TSET and Teradata Workload Management
• Having In-depth knowledge of Backup and Archive (BAR) System and hands-on exposure with TARA, Netbackup and DSA tools for running the backup/restore. Regularly design and configure the Backup Recovery Strategy across Teradata Enterprise Systems to ensure data recoverability and availability in line with Business requirements
• Expert in generating and analyzing weekly/monthly/quarterly reports as well as adhoc reports as per requirement and presenting them to the clients and also translating the technical aspects of the reports into business functional requirements/actions
• Well versed in handling multiple systems that span over Terabytes and multiple environments providing a 24*7 system support
• Possess good experience in working and coordinating with multiple teams, Offshore and Onsite, client interactions and application teams
• Adept at providing leadership, excellent communication skills, managing and delegating multiple tasks, ability to prioritize, being attentive to details and maintaining the ability to make rational decisions in pressure situations

TECHNICAL SKILLS

RDBMS: Oracle 9i, Teradata 12, 13.10, 14.10, 15.10, 16.10, 16.20

Tools: / Utilities: SQL Assistant, Teradata Administrator, BTEQ, Viewpoint, TASM Teradata Workload Management, WinSCP, Putty, TARA GUI, Symantec Netbackup, DSA, TSET, Pier, Reliance, Service Now, Stats Manager, Packdisk, Scandisk

Languages: C, C++, JAVA, Shell Scripting

Operating Systems: UNIX, SUSE Linux 10, SUSE Linux 11, Windows

PROFESSIONAL EXPERIENCE

Confidential

Senior Technical Associate

Responsibilities:

• Worked as a Senior Teradata Operations and Performance DBA for this project spanning 912TB of Production environment
• Regularly defined and implemented the critical workload Management settings which impacted the adherence to SLA time for various applications using the TASM/TIWM. Also have setup Viewpoint alerts
• Closely monitoring database performance and resource exhaustion alerts and system health and taking appropriate action on priority using Teradata viewpoint and ensuring zero system impact
• Proactively identified, analyzed and provided resolutions for high consuming CPU/IO queries, skewed data, long running jobs, blocked sessions in all environments. Also advised respective teams for the long-term fix
• Worked on query optimization, collected statistics and analyzed poor performing queries from DBQL data. Determine which are wanted/unwanted statistics on the objects
• Scheduled and performed Weekly/Daily Backups, Restores and Data Copy on all the Environments using TARA, Netbackup and DSA
• Hands on exposure of creating, launching and managing data mover jobs to sync data between two production and non-production systems using DM command line interface and viewpoint data mover portlet
• Created backup reports and discussed with clients and application teams to work on scheduling and proposing time and parameter changes of the backups considering system workload, changes in the database sizes to acquire fastest transfer rate and also avoiding any blockings
• Responsible for reviewing DDLs and DMLs before it is implemented in the TEST/PROD system. Discussed and reviewed with the DEV team from the initial stages of the design and understand the business needs in order to select effective indexes
• I had been a key participant during migration and upgrades of Teradata system and worked on dbc backups and restoration, executed critical post data restore scripts
• Automated various dba task using shell scripting
• Experienced in error handling and troubleshooting issues/failures encountered by Teradata loading utilities likes Fastload / Multiload/FastExport/Tpump
• Active co-ordination with Client, CSR, Teradata GSC, batch and production teams during issues/ job failures and handled adhoc /scheduled outage / downtime of the systems and patch upgrades
• Provided on-call support for critical business issues, adhoc issues and upgrades
• Continuous monitoring of the batch jobs/SQL’s triggered by Business End Users on request during critical events and prioritizing tasks as per requirement
• Performed Checktable, Scandisk, Packdisk and Nparc activities on all the Production and Non-Production Systems
• Proficient in creation and dropping of users, databases, roles, profiles as per business requirement. Granted and revoked object rights and access rights
• Space management to avoid any failures in ETL batch runs and BO reporting due to Perm space or spool space issues across all systems. Also purged unwanted/unused/duplicate tables to reclaim space
• Prepared daily/weekly backup scripts, Alert scripts using Linux and scheduling the same in cron
• Key resource in presenting the changes in CAB calls for tickets and Change Requests. Hands on experience about Change management and Incident management
• Preparing the security Audit Reports and sending it to Client
• Conducted trainings on backup/restore, create new jobs, edit existing jobs using TARA and Netbackup
• Conducted knowledge sharing sessions on Viewpoint

Confidential

Project Lead

Responsibilities:

• Worked as a Technical Lead Teradata Operations and Performance DBA
• Maintained and supported high profile business critical enterprise Databases for PROD/QA/DEV running on Teradata versions 13.10 and 14.10
• Responsible for upgrading and configuring the environment by creating multiple databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance
• Primary resource for performing monthly Audit checks for CPU consumption daily/hourly, unwanted stats, missing stats, scope for MVC, duplicate objects, unused objects, skewed data tables, invalid views, views with no locking row for access clause and prepared dashboard reports
• Proactively monitor database performance and system health using viewpoint
• Analyze CPU/IO usage, Top CPU queries, AMP usage and CPU skew, Top CPU consuming users and present daily/weekly/monthly reports on the same and provide recommendations and implement and review with client and application teams
• Involved with the client and application team in the logical design and physical modeling and responsible for Creation/modification/deletion of databases, users, roles and profiles as per business requirement
• Created and managed permissions, access and privileges. Planned and designed Roles and Profiles as per business need.
• Expertise in Database/User management, Security management and Space Management
• Monthly evaluated Capacity metrics and analyzed trends to determine the future requirements from capacity perspective. Prepared capacity planning reports as per client requirements
• Managed appropriate use of free space within table spaces, reclaimed space after analyzing the objects usage and managing space within the databases in the same/different hierarchy
• Quarterly analyzed MVC and BLC on the desired tables for saving the perm space
• Expertise in TARA GUI/DSA/Netbackup/ARCmain for database and object backups, restores and recoveries. Troubleshooting job failures and reviewing their logs for root cause analysis
• Created backup reports and proposed and implemented the timings and parameters considering system workload and acquired fastest transfer rate
• Working with application developers in troubleshooting database errors/issues
• Reviewing database performance using reports generated by PDCR/DBC. Reports include daily database space usage, CPU usage, worst queries of the day, report for unauthorized access.
• Killing sessions, logging user activities. Managing rollback segments. Releasing utility locks.
• Schedule cron jobs in crontab and configure email alerts for job status
• Preparing daily/weekly backup scripts, Alert scripts using Unix/Linux and scheduling the same in cron