| Hot list by Hari- Sr Teradata Administrator OR Analyst is having 15 years available immediately at Remote, Remote, USA |
| Email: [email protected] |
|
From: Hari Inkollu, Thoughtwave Software and Solutions Inc [email protected] Reply to: [email protected] Dear Staffing Partner, Siva is a Teradata Administrator/Analyst is having 15+ years of experience and available for projects immediately. He is located in Apex, NC and looking for positions anywhere in USA , if you'd like to receive his resume, please reply to this email with job details or contact me AT 630-225-9452. SUMMARY: 15+ years of experience in Business Intelligence, Global Data Ware Housing and Development worked with cross-functional team environment with people from multiple business units, vendors, countries, cultures and working as Mainframe Developer, Business Analyst, Teradata DBA and DWH/BI Architect. Excellent knowledge in Relational Database (OLTP) and Data warehousing systems (OLAP), Cloud Services. Involved in Data modeling using Dimensional Data modeling - Star Schema Modeling, Snowflake Modeling. Experience with Data Mapping, Data profiling and Data mining activities as a part of building new Data Warehouse environment. Strong experience in Teradata 17.20/16.20/15.10, application performance tuning, Teradata SQL optimization, detailed design, application support, tuning and optimizing bad queries and handling database maintenance works. Proficient in using Teradata Administrator for managing Databases, Users, Tables, Indexes, statistics, managing permissions (Roles & Profiles), addressing the user issues such as resetting passwords, unlocking user IDs etc. Extensive experience on Teradata Workload management concepts, worked with TASM and TDWM. Worked with various user groups and developers to define TASM Workloads, developed TASM exceptions, implemented filters and throttles as needed basis. Responsible for administration DBObjects, creating physical data model, maintaining database, control standards for central and local database, overseeing all database programming, performance tuning, monitoring and software installs and upgrades, backup/recovery (DSA with storage Data Domain), disaster recovery plans . Automated and scheduled the jobs using UNIX scripting. Proficient in Teradata AMP and client-based administration utilities such as Ferret, Check Table, DIP, PMON etc. Administration of the production boxes over a period to identify the bottlenecks and workload balancing of the system. Proficient in writing scripts, Stored Procedures, Macros in order to automate and simplify the day to day activities. Error handling and troubleshooting of Teradata load/unload utilities like FastLoad, MultiLoad, FastExport, Tpump, Arc/Restore. Working closely with DEV team and assisting them in data modeling. Experience in leading team to support DBA activities (24X7) as part of a scheduled rotation with other team members. Hands on experience and configuration of Teradata Querygrid (Current version 2.09 & 2.11) data analytic fabric. Analysis, Design & Development of Application packages / Systems for the Banking/Telecom industry in COBOL, Python, Unix script. Expertise in designing Test plans, Test Scenarios, Manual Test Cases Automated Test Scripts and UAT Design Documents. Having strong experience in DB2 and Teradata, MS SQL Server databases. Very strong on SQL query optimization techniques like EXPLAIN feature, STATISTICS, Secondary Indexes (USI, NUSI), Partition Primary Index (PPI), Volatile, global temporary and Derived tables etc.. Well versed with Agile Software Process: Participated in daily scrum, Sprint planning meeting, Sprint review meeting and Sprint retrospective. Proficient in using Erwin data Modeler for Data Modeling and using Star Schema, Snowflake Schema, Fact and Dimension tables, Physical and Logical data modeling for Data Warehousing and Data Mart. Thanks, Hari - Thoughtwave Software & Solutions, Inc. Phone: 630-448-6681x 102, Direct: 630-225-9452 Email: [email protected] Web: http://www.thoughtwavesoft.com Keywords: business intelligence microsoft Idaho North Carolina Hot list by Hari- Sr Teradata Administrator OR Analyst is having 15 years available immediately [email protected] hotlist |
| [email protected] View All |
| 06:50 PM 30-Sep-24 |