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- sam@sourcechip.net |Phone-732-917-4895
https://www.linkedin.com/in/sumanbakshi
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