Hi
Please lookup the below position and if you feel comfortable ,then please send me your updated resume
Role : Teradata DBA
Location : Houston, TX
Duration : 6+ Months
Interview : Phone / Skype
High priority requirement
Job Description
· Provide Teradata application database support for the Integrated Operations efforts.
· Position requires working with data warehousing team members, Data Architecture and Integrated Operations teams to ensure the Integrated Data Warehouse compliances are adhered to and the performance and optimization issues are addressed.
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
Job Requirement
• 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 ,
Kailash Negi
VSG Business Solutions
221 Cornwell Dr Bear, DE 19701
Email ID : kailash@vsgbusinesssolutions.com
Phone: 302-261-3207 x 102
You received this message because you are subscribed to the Google Groups "US Jobs: Requirements, Clients and Consultants" group.
To unsubscribe from this group and stop receiving emails from it, send an email to recruiters-r-us+unsubscribe@googlegroups.com.
To post to this group, send email to recruiters-r-us@googlegroups.com.
Visit this group at https://groups.google.com/group/recruiters-r-us.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment