please send me resume at [email protected] Hi Associate,
Currently, I am recruiting candidates for one of my requirement as mentioned below. If you have a matching profile, please send me the updated resume along with contact details at the earliest. *Job Title* Teradata DBA *Project Location* Atlanta GA *Duration* 6 months /Contract * Skills Required and Job Description:* *MOI::Telephonic Followed by skype* Education/Experience Job details : • Implement and maintain database objects and security in lower life cycles . • Working knowledge on Data domain and DSA. • Participate in assessing or identifying any risks associated with the new architectural components. • Participate in any brainstorming activities or meetings pertaining to new projects on Teradata. • Participate in research solutions to various business and technical problems, evaluate alternatives and be able to present recommendations and justifications to senior staff. • Development DBA will evaluate and recommend any Teradata Database software upgrades to infrastructure team. • Development DBA will perform/Co-ordinate POC for any 3rd part application software tools which will interact with Teradata system. • Develop physical design. (Indexing,Compression, Block size, Soft RI etc.) • Designing the data security using VIEWS databases. • Compile a capacity plan – Evaluate space, CPU, concurrency etc. • User Access security (Example: Request batch-id’s, service accounts, databases to the Operation DBA team ( only Development DBA’s should request these, that is one way to make sure there is proper APP DBA involvement )) • Enforcing best practice and standards for ETL (Teradata specific) . • Work with developers to design tables necessary for ETL processing (i.e. Staging tables). • Participate in ETL code reviews (Teradata specific) and provide recommendation. • Performance tuning the ETL (Teradata) scripts. • Share knowledge sessions with ETL Developers. • Prepare QA test bed for QA testing needs. • Assist in identifying and performing any needed performance benchmarks or volume stress tests. When performed, evaluate and report on results. • Coordinating with QA leads to ensure all the QA efforts goes seamlessly. • Ensure all the QA team have proper access to perform their work. • Monitor ETL processes and work with the ETL Developers responsible for updating the Teradata system to insure data consistency and availability. • Serves as escalation point for application/database related issues. • Contribute to other technology projects requiring programming/ DBA expertise. • Perform database tuning including monitoring, troubleshooting and optimizing performance of the databases in lower life cycles. • Review and tune any SQL related to the project across lower life-cycles • Skewed/PJ/Impact CPU Queries • Frequently scanning huge table with no PPI • Spool out issues. • Identifying the Multivalue Compress(MVC) Tables. • Collect stats recommendation/Stale Stats • Evaluating the proper Index strategies wherever required • Exploring new features in Teradata • Identify the like queries with similar problems. • Quantifying and translating the performance gains into Business value in terms of CPU/IO and capacity saved. • Provide input on workload definition to help OPS DBA team define TASM policy for the project. Also discuss business expectation for both ETL and reporting SLA. • Collect and provide all information required by OPS DBA team to implement CMR . • Collect and provide all information needed by OPS DBA team for data retention and purge ( If required ). • Define statistics for all new tables and provide input to OPS DBA for ongoing stats collection policy. • Participate in production implementation walk through sessions. • Once project is in production evaluate performance and report the same and make changes to improve performance where required. • Engage with OPS DBA on all major database upgrades and get up to speed / training with all new features *Regards,* *Rupa Kumari* *Technical Recruiter* *RG Talent Inc* *39120 Argonaut way* * Suite # 157, Fremont CA 94538* *Phone : 510-443-0757 x 126* *Email : [email protected] <[email protected]> * *G-Talk :**[email protected] <[email protected]>* *URL : www.rgtalent.com <www.rgtalent.com>* -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" 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 http://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.
