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- 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 "SAP or Oracle Financials" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-or-oracle-financials+unsubscr...@googlegroups.com. To post to this group, send email to sap-or-oracle-financials@googlegroups.com. Visit this group at https://groups.google.com/group/sap-or-oracle-financials. For more options, visit https://groups.google.com/d/optout.
