Rohit Singh

• Leads the planning, analysis, design, implementation, maintenance, and control of the organization’s server-class databases. • Team / Shift Management, Work Distribution & SLA Management. • Daily Client Reporting. • Weekly review presentation to client. • Process Management & Knowledge Transfer. • System Monitoring, addressing Alerts and Routine DBA tasks. • Review of performance recommendations. • Involved in requirements gathering and data gathering to support developers in handling the design specification. • Extensive experience in writing and executing scripts for validation and testing of the sessions, data integrity between source and target database and for report generation. • Involved in loading of data into Teradata from legacy systems and flat files using complex scripts. • Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in Teradata Database. • Involved in understanding Business and data needs and analyze multiple data sources and document data mapping to meet those needs. • The mappings involved extensive use of transformations like Aggregate, Filter, Join, Expression, Lookup, Update Strategy, Expressions, Sequence Generator Transformations. • Performance tuned the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them. • Prepared Unit Test Specification Requirements.

• Working on developing best practices for Database performance optimization. • Leads the planning, analysis, design, implementation, maintenance, and control of the organization’s server-class databases. • System Monitoring, addressing Alerts and Routine DBA tasks. • Review of performance recommendations. • Suggested MVC implementations which resulted in huge savings of disk space, IO and CPU. • Performance tuned the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them.

• Created Macros as per requirements. • Handling Adhoc requests as a Development DBA. • Operation activities include daily proactive tasks in DEV and QA systems. • Handling Pre and Post Implementation activities during major releases. • Attending Weekly DBA call for any technical discussion/new process addition/change. • Documented Runbook and Conversion sheet from SQL to TD. • Monitoring and Noting down technical issues and bringing them in Weekly DBA call. • Solving ad hoc requests for access rights, query tuning, space management, Lock release etc. as per the user requirement. • Tracking Capacity requirement before any production implementation and ensuring estimated space availability, in order to ensure smooth loads after production Implementation. • Executing change requests for DDL & DML statements from the users. • PPI Maintenance activity on all Servers. • Periodically cleaning obsolete objects for space management. • PI Analysis of Skewed Tables for Space saving. • Attended SIT/UAT/Production Implementation Review meetings with development teams for different projects. • Performed SDLC migration. • Provided Development DBA support on weekends for production Implementation activity. • Implementations in SIT/UAT, IR and PROD environments. • Having Architectural review meeting for upcoming projects. • Role alignment on DEV & QA systems. • Creating / aligning of role according to the business needs. • According to developer’s need, created and Implemented (TDDEV, TDQA and TDPROD) STATS REFRESH procedure, which was supposed to be done by Development DBA Team manually. • Performing DDL check process and make sure that it should follow Standards.

• Creating Test and Development environments and granting access/privileges based on requirement without impacting the Security policies. • Performing Data copy jobs to maintain enough data in the SIT and UAT region for proper testing of codes. • Solving ad hoc requests for data backup, query tuning, space management etc. as per the user requirement. • Worked on Code Review by using Teradata Statistics wizard. • Worked on DDL QA Check Process to find out any discrepancy available in DDLs Generated. • Performing /Setting up Process like DDL generation/ QA checks. • Knowledge and worked on Backup and Recovery on TARA Server. • Worked on giving Access Rights to users on Insert and Select on Database and also used Teradata Administrator for finding out different Rights held by the user.. • Worked on Stats Collection request given by the client team. • Worked on Release Data Copy through T10 process. • Created Proxy id’s for the users. • PC skills in Windows NT & 2000 environment with Microsoft Office Products, MS Word, MS Excel, Outlook & Teradata ODBC client tools. • Performing /Setting up Process like DDL generation/ QA checks. • Handling/Setting up Process for Migration/Implementation activity. • Handling the weekly and Daily calls with client and Development teams. • Periodically cleaning up obsolete Objects from Databases by coordinating with concerned Teams.