Hi All, Please submit match profiles *Visa copy and Passport number must* NEW requisition - Teradata APP DBA
The following requisition has been assigned: Contract Long Term TITLE: Teradata APP DBA STATUS: Open LOCATION: Houston, TX, United States # of Openings: 1 Requisition Details: 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 • 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- [email protected] |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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/directclienteq. For more options, visit https://groups.google.com/d/optout.
