Dear, We are looking for *Teradata APP DBA* in *Houston ,TX* *. **If you are interested, please share your updated resume along with desire salary to **s...@affluenttek.com <s...@affluenttek.com>*
*Tittle *: *Teradata APP DBA* *Location: Houston ,TX* *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* Regards, *Sai Charan* *IT Recruiter.* *AffluentTEK, LLC.* *PROFESSIONAL IT SOLUTION* 43676 Trade Center PL Ste 235 Dulles, VA 20166-2124. Email: *s...@affluenttek.com <s...@affluenttek.com>* Tel: *585.568.7072* Fax: *585.568.7209* Web: *www.AffluentTEK.com <http://www.affluenttek.com/>* *Please consider the environment and do not print this email unless absolutely necessary. Save Earth!!* *CONFIDENTIALITY NOTICE:* This message is intended only for the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited, and you are requested to please notify us immediately by telephone, and return the original message to us at the above address. -- You received this message because you are subscribed to the Google Groups "OracleD2K" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracled2k+unsubscr...@googlegroups.com. To post to this group, send email to oracled2k@googlegroups.com. Visit this group at https://groups.google.com/group/oracled2k. For more options, visit https://groups.google.com/d/optout.