Search for More Jobs
Forward job to a friend
Apply without Registering
Apply by creating/using an account
Please enter your registered email address, and we'll email you a link to reset your password right away.
Role : Sr Teradata DBA
This position is responsible for primarily supporting Teradata environment that will include configuration, administration and maintenance of non-production and production environments. This position must have advanced working knowledge of Teradata RDBMS at both physical and logical levels. This role works closely with BI Analytics, Data Modelers, QA, ETL and other groups. Typically this role supports multiple, technically complex, mission-critical, and/or high-profile Projects. This individual must possess strong Administration Skills including the ability to make sound Database recommendations.
Essential Job Functions:
Manage/Monitor system performance, including workload management
Manage/Monitor Query performance and tuning, physical node behavior, and amp distribution
Support multiple Teradata systems including Data marts, development, and the enterprise warehouse systems and business applications.
Responsible for implementation and release of database changes as submitted by the development team.
Provide weekend /off hour Support as Required
Take care of production deployments.
Consult on physical database implementations, PPI, skew analysis, join methods, and data access paths.
Support Unix level process, scripts, and tools for system management and data movement
Support development and consult on practices of storage management, archive, restore, and disaster recovery
Work with Teradata GSC in resolving RDBMS related incidents.
Responsible for improvement and maintenance of the databases to include rollout and upgrades
Install, configure and upgrade Teradata software and related products.
Proactively monitor the database systems to ensure secure services with minimum downtime
Implement and administer access policies in conjunction with corporate standards.
Help ETL Developers to fine tune the SQL's
Manage DBMS configuration changes.
Take care of Pack Disk, Scan Disk
Backup, restore, migrate Teradata data and objects from Production to dev
Excellent communication (written and verbal). Full life cycle experience in Data Warehousing Data Integration, and Data Management.
10+ years - Overall IT experience.
10 years - DBA experience; must be proficient in both logical physical database designs.
8 Years – Teradata DBA Experience.( Teradata V15 & Higher)
3 years – Advance Shell scripting.
Proficient in Teradata Tools and client utilities including Tara Gui
Other RDBMS database experience is a plus ( Netezza, Kognitio, SQL server)
BS/MS degree, applicable certifications or equivalent experience required.
High-level problem solving and technical experience.
Advanced knowledge of Teradata Architecture and system internals
Extensive experience in administering large databases
Advance Teradata Certification
Expert understanding of business application
Expert Database Physical ,Logical design/SQL skills
Apply by creating/using an account
DIVERSANT (diversant.com) is one of the largest African-American owned IT staffing firms in the U.S. We offer rewarding career opportunities with many of the nation’s leading corporations. Our experienced recruiters understand what hiring managers look for in a candidate and provide our applicants with the proper support and guidance along the entire application and interviewing process. We offer opportunities on a contingent, contract-to-hire, and direct hire basis. At DIVERSANT, we are committed to providing the highest level of service and satisfaction to our customers, consultants, and employees.
DIVERSANT provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, DIVERSANT complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities.
WORK OPPORTUNITY TAX CREDIT
Diversant LLC participates in the Work Opportunity Tax Credit program. ADP Tax Credits administers this program on our behalf. It is vital that you follow the steps listed below in order for the tax credits to be processed. We appreciate your cooperation. Please note participation in this program is voluntary and is a required part of the employment application process. Formal application steps should still be followed.
Work Opportunity Tax Credit Applicant Instructions
• Open https://tcs.adp.com/screen/index.html?cc=diversant
Note: To change the language on screen please select a language from the dropdown box
• Click on Continue to begin
• Please answer each question including electronically signing any applicable forms
• To complete the interview and save your work, please click eSign and Finish
• If applicable, upload any available supporting documents and click Continue