Pratima Patel Email & Phone Number

Amsterdam, Nh, Nl

Palo Alto, California, Us

Boston, Massachusetts, Us

Boston, Massachusetts, Us

The Cloud, Us

The Cloud, Us

Edison, New Jersey, Us

Database AdministratorManage Teradata database administration assignments for diverse industry clients. Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Ensure technical and functional designs meet business requirements.Key deliverables:• Manage the Teradata Servers across the globe, monitor the performance of databases and make tuning changes, researched and evaluated alternative solutions related query performance and recommend the most cost effective design solutions.• Use of Viewpoint database administration tools to analyze system status/performance.• Involved in taking care of day-to-day needs for the Development team with in the specified SLA and also taking care of the ad-hoc requests.• Successfully handled the needs such as creating Databases/Users/Tables/Views/Roles/Profiles etc., Access grants, Load support/assistance such as resolving the deadlock issues, creating the JI and SI, STATS collection, avoiding bad joins etc.• Reacting to alert system, if needed.• Demonstrated knowledge of Performance Data Collection and Reporting (PDCR) and Database Query Logging (DBQL)• Proficient in with installing, maintaining, using all the Teradata tools (ex BTEQ, SQL Assistant, TPUMP, TD Administrator, ODBC, MLOAD, Fastload, etc)• Responsible for implementation and release of database changes as submitted by the development team• Analyze explains/statistics/diagnostics to isolate SQL problems.• Investigating the occurred discrepancies, through DBQL and communicating to the end users.• Pursuing PG diploma in data science from UPGRAD.

San Diego, California, Us

• Providing technical support as well as identifying and resolving technical issues and delivering accurate resolutions for client issues.• Strong knowledge in Data Warehousing concepts, Teradata utilities (BTEQ,TSET,ARCMAIN,FASTLOAD, FASTEXPORT, MULTILOAD, TPUMP, Teradata Administrator, SQL Assistant, Viewpoint).• Strong skills in resolving Teradata issues, providing a workaround for the problems, SQL Tuning and Performance Monitoring.• Excellent knowledge on DBMS and OS concepts and Data structures, SQL.• Collaborating with different teams/unit for resolving production issues, performing live analysis of production as well development environment pertaining to database system performance.• Addressing technical issues pertaining to database performance,hang,database restart,individual SQL performance bottlenecks. • Used various AMP based utilities like Recovery manager, VPROC manager, Lockdisp, Showlock, Qrysessn.• Use Teradata Explain and DBQLSTEPTBL to analyze and improve query performance.• Identifying and simulating and providing resolutions/workarounds for database failures or query failures to the clients.• Investigating & Troubleshooting high priority issues on technical bridge by interfacing with international clients and providing resolutions the best way possible.• Monitoring system performance through viewpoint, session stuck, analysing workload management rulesets .• To analyze crashdumps whenever system crashes or encounters a fatal/critical error , trying to extract Offending SQL from the crashdump and minimizing the risk of database failures by recommending workarounds if any.

Bachelor Of Engineering (Be), Computer Science

Higher Secondary Certificate Exam, Physics, Chemistry, Biology