Job Title: Teradata DBA
Location: Hybrid in NJ
Experience: 8 10+ Years
Employment Type: Contract
We are seeking an experienced Teradata Database Administrator (DBA) to manage, support, and optimize Teradata data warehouse environments. The ideal candidate will be responsible for database installation, configuration, performance tuning, capacity planning, security, backup/recovery, and ensuring high availability of mission-critical systems in a production environment.
Key Responsibilities Database Administration & OperationsInstall, configure, upgrade, and patch Teradata Database and related utilities.
Administer large-scale Teradata data warehouse environments (DEV / QA / UAT / PROD).
Monitor database health, system performance, and resource utilization.
Perform database start-up, shutdown, and routine maintenance activities.
Manage user access, roles, profiles, and security privileges.
Analyze and tune SQL queries for optimal performance.
Monitor workload management using TASM / Viewpoint .
Identify bottlenecks related to CPU, memory, AMP usage, skew, and spool space.
Work closely with developers and data analysts to optimize ETL and reporting workloads.
Design and manage backup and recovery strategies using ARCMAIN , BAR, or enterprise backup tools.
Perform disaster recovery (DR) planning, testing, and execution.
Ensure data integrity and availability during failures or outages.
Support system failover and restore operations.
Manage database space allocation, permanent/temporary/spool space.
Perform capacity planning and forecasting for future growth.
Monitor and resolve space-related issues, skew, and data distribution problems.
Implement database security policies in compliance with organizational and regulatory standards.
Conduct periodic access reviews and audit support.
Ensure data protection, encryption, and compliance with GxP, SOX, HIPAA, or other applicable standards (if required).
Provide 24x7 production support (on-call as needed).
Troubleshoot and resolve database issues, performance incidents, and outages.
Participate in root cause analysis (RCA) and post-incident reviews.
Work with infrastructure, application, and ETL teams to resolve cross-functional issues.
Develop and maintain scripts for monitoring, automation, and housekeeping.
Maintain SOPs, runbooks, and operational documentation.
Support change management and release activities.
6+ years of hands-on experience as a Teradata DBA .
Strong expertise in Teradata architecture , AMPs, nodes, parsing engine, BYNET.
Proficiency with Teradata utilities:
BTEQ
FastLoad / MultiLoad / TPump
ARCMAIN
Teradata Viewpoint
Strong SQL and query performance tuning skills.
Experience with Linux/Unix operating systems.
Knowledge of workload management (TASM), space management, and skew resolution.
Experience with backup, recovery, and disaster recovery procedures.
Experience with Teradata upgrades and migrations .
Exposure to cloud platforms (AWS, Azure, GCP) and Teradata Vantage.
Knowledge of ETL tools (Informatica, Ab Initio, DataStage).
Scripting skills (Shell, Python).
Experience supporting large enterprise data warehouse environments.
Strong analytical and problem-solving skills.
Ability to handle high-pressure production issues.
Excellent communication and documentation skills.
Ability to work independently and in cross-functional teams.
Strong time management and prioritization skills.
Thanks & Regards,
Venkatesh Kulkarni | Sr. Lead Recruiter,
venkatesh.kulkarni@centstone.com / 332-213- 5797
CENTSTONE SERVICES LLC
Address: 3400 State Route 35, Suite 9B, Hazlet, New Jersey, 07730 USA
...Job Description We are seeking enthusiastic and reliable Spanish Instructors to lead after-school Spanish enrichment classes at... ...tutoring, or leading youth programs preferred. Strong Spanish-speaking ability (conversational to fluent). Positive classroom management...
...teammates in North America. BSRO operates more than 2,200 company-owned stores, including Firestone Complete Auto Care, Tires Plus and Wheel... ....+ Keep records and relevant financial information current.+ Manage, schedule and assign staff according to their skill level.+...
...Premier Medical Staffing Services is seeking a travel nurse RN Med Surg / Telemetry for a travel... ...6/2026~ Duration: 14 weeks ~36 hours per week ~ Shift: 12 hours ~ Employment... ...of the healthcare landscape, we offer per-diem, contract and direct hire placements to support...
...The Massachusetts Municipal Wholesale Electric Company (MMWEC) brings a competitive edge to Massachusetts municipal utilities dedicated to providing their customers with low-cost and reliable electricity. We plan, develop and manage energy resources in an evolving marketplace...
...problems in order to achieve our mission WHAT YOULL DO Teachers are entrusted with advancing the mission of Tulsa Honor... ...such as reading, writing, discussion, analysis, meaning-making, computation, and problem-solving Display that you value risk-taking, especially...