* Teradata APP DBA*
Hi, I am Suman Bakshi from SourceChip,Inc working as a Sr Recruiter in IT Recruitment team. We have very urgent requirement with our client in Houston,TX with Oil and Gas Domain client, need very stron Teradata App DBA's with oil and gas experience must. If you have any qualified consultants available please share us profile, visa requirement H1 ,Us Citizens,Green Card,GC-EAD. *Visa copy both the pages and Passport copr or number must for submissions.* Contract Long Term Teradata APP DBA LOCATION: Houston, TX, United States # of Openings: 1 Hourly Rate :Negotiable Interview :Skype Hire *Responsibilities* • Provide day-to-day application database administration support to multiple Integrated Operation programs • Create, Coordinate and Execute change request, build scripts based on Feedback from Data and Integration Analysts • Perform Dev, Test and Prod migrations according to COP standards • Follow Integrated Data Warehouse (IDW) governance when creating database, schema, tables and views • Adhere to Data Warehouse architecture, standards and processes as defined by the Data Architecture team • Review and optimize performance of the tables, views, stored procedures, indexing, stats, etc. • Provide capacity and performance trend analysis and proactively take steps to address concerns with design and solution recommendations • Perform performance tuning on complex queries with efficiency of PI/SI indexes, Join Index, PPI, Using Explain plan for analysis using Teradata Explain, Visual Explain, data distribution among AMPs and index usage, collect statistics, revision of correlated sub queries, etc. • Analyze DBQL entries specific daily to identify long-running queries, high CPU and I/O usage, spool usage, noting accounts, assessing SQL for troubleshooting and provide recommendations • Proactively review user access, permissions, table and view usage, object & security roles across environments; coordinate closely with the BU IO teams to clean up discrepancies and underutilized items • Instill best practices for code development and documentation • Perform peer review on vendor’s design and drive design changes to meet COP Database Management standards *Qualifications & Skills * • Proficient knowledge in Teradata concepts, logical/physical database design, and security model • Experience using Teradata utilities: TPT, TPump, BTEQ, fastload, fastexport, multiload • Experience with the Atana Suite of productivity tools • Full life-cycle experience in Data Warehousing Data Integration, and Data Management • Ability to translate business requirements and into Technical and Data Model designs • Ability to coordinate with SMEs, stakeholders, manage timelines, escalation and status • Ability and willingness to provide day-to-day and occasional after hours’ support • Demonstrated analytical and problem solving skills • Acts independently to plan and execute own work program • Must be able to prioritize requests and multi-task • Strong customer service, communication, and project management skills • Takes ownership of actions and follows through on commitments • Manages tasks to effectively and efficiently complete work responsibilities of self and others • 2-3 years’ experience in Oil and Gas Industry Thanks & Regards, Suman G Bakshi (Sam) SourceChip,Inc | Email- s...@sourcechip.net |Phone-732-917-4895 https://www.linkedin.com/in/sumanbakshi -- You received this message because you are subscribed to the Google Groups "Hot List" group. To unsubscribe from this group and stop receiving emails from it, send an email to directclienteq+unsubscr...@googlegroups.com. To post to this group, send email to directclienteq@googlegroups.com. Visit this group at https://groups.google.com/group/directclienteq. For more options, visit https://groups.google.com/d/optout.
