| Looking for Terra DBA requirement at Remote, Remote, USA |
| Email: [email protected] |
| From: Deepthi 630-480-4203, Thoughtwave software solutions [email protected] Reply to: [email protected] Dear Staffing Partner, Pradeep is a Terra DBA /Developer having 9+ years of experience and available for projects immediately. He is located in North carolina and looking for positions anywhere in the USA, if you'd like to receive his resume, please reply to this email with job details or contact me AT 630-480-4203 Profile: 9+ 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 Warehouseenvironment. Strong experience in Teradata 17.10/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. Experience on Teradata Workloadmanagement 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 DB Objects, 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 shell scripting. Administration of the production boxes over a period to identify the bottlenecks and workload balancing of the system. Proficient in writing SHELL 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. 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.. Hands on experience and configuration of Teradata Query grid (Current version 2.17) data analytic fabric. Keywords: business intelligence database Idaho |
| [email protected] View all |
| Wed Nov 01 22:31:00 UTC 2023 |