Overview
Remote
On Site
$65 - $70 hourly
Contract - W2
Contract - Temp
Skills
Macros
Stored Procedures
Reporting
Data Integration
FastExport
Collaboration
Unit Testing
Technical Support
Migration
Oracle
Informatica
Backup
Recovery
Disaster Recovery
Capacity Management
Management
Database
Regulatory Compliance
SQL
Database Architecture
Extract
Transform
Load
Data Warehouse
Teradata
BTEQ
FastLoad
MLoad
TPump
Performance Tuning
Query Optimization
Scripting
Unix
Shell
Python
Data Modeling
Analytical Skill
Conflict Resolution
Problem Solving
Communication
Agile
Big Data
Apache Hadoop
Apache Spark
Scheduling
BMC Control-M
CA Workload Automation AE
Data Governance
Business Intelligence
Tableau
Microsoft Power BI
Artificial Intelligence
Messaging
Job Details
RESPONSIBILITIES:
Kforce has a client in Armonk, NY that is seeking a Senior Teradata Developer/DBA.
Responsibilities:
* Design and develop Teradata databases, tables, views, macros, and stored procedures
* Write and optimize complex SQL queries for ETL processes and reporting
* Implement data integration solutions using Teradata utilities (BTEQ, FastLoad, MultiLoad, TPump, FastExport)
* Collaborate with data analysts and business teams to translate requirements into technical solutions
* Perform unit testing and troubleshoot data issues within Teradata systems
* Support migration and conversion projects (e.g., Oracle/Informatica to Teradata or Big Data environments)
DBA Duties:
* Install, configure, and maintain Teradata database systems
* Monitor system performance and perform tuning for optimal efficiency
* Manage user access, roles, and security policies
* Implement backup, restore, and disaster recovery strategies
* Conduct capacity planning and manage space allocation (Permanent, Spool, Temporary)
* Maintain database integrity and ensure compliance with data governance standards
* Provide on-call support for urgent incidents and performance issues
REQUIREMENTS:
* Bachelor's degree in Computer Science, Information Technology, or related field
* Teradata certification is a plus
* 3-5+ years of experience in Teradata development and administration
* Proficiency in Teradata SQL and database architecture
* Strong knowledge of ETL processes and data warehousing concepts
* Hands-on experience with Teradata utilities (BTEQ, FastLoad, MultiLoad, TPump)
* Experience with performance tuning and query optimization
* Familiarity with scripting languages (Unix Shell, Python)
* Understanding of data modeling (logical and physical)
* Analytical thinking, problem-solving, communication, and ability to work in Agile environments
Preferred Skills:
* Exposure to Big Data technologies (Hadoop, Spark)
* Experience with scheduling tools (Control-M, Autosys)
* Knowledge of data governance and security best practices
* Familiarity with BI tools (Tableau, Power BI)
The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.
We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.
Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.
This job is not eligible for bonuses, incentives or commissions.
Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
By clicking ?Apply Today? you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.
Kforce has a client in Armonk, NY that is seeking a Senior Teradata Developer/DBA.
Responsibilities:
* Design and develop Teradata databases, tables, views, macros, and stored procedures
* Write and optimize complex SQL queries for ETL processes and reporting
* Implement data integration solutions using Teradata utilities (BTEQ, FastLoad, MultiLoad, TPump, FastExport)
* Collaborate with data analysts and business teams to translate requirements into technical solutions
* Perform unit testing and troubleshoot data issues within Teradata systems
* Support migration and conversion projects (e.g., Oracle/Informatica to Teradata or Big Data environments)
DBA Duties:
* Install, configure, and maintain Teradata database systems
* Monitor system performance and perform tuning for optimal efficiency
* Manage user access, roles, and security policies
* Implement backup, restore, and disaster recovery strategies
* Conduct capacity planning and manage space allocation (Permanent, Spool, Temporary)
* Maintain database integrity and ensure compliance with data governance standards
* Provide on-call support for urgent incidents and performance issues
REQUIREMENTS:
* Bachelor's degree in Computer Science, Information Technology, or related field
* Teradata certification is a plus
* 3-5+ years of experience in Teradata development and administration
* Proficiency in Teradata SQL and database architecture
* Strong knowledge of ETL processes and data warehousing concepts
* Hands-on experience with Teradata utilities (BTEQ, FastLoad, MultiLoad, TPump)
* Experience with performance tuning and query optimization
* Familiarity with scripting languages (Unix Shell, Python)
* Understanding of data modeling (logical and physical)
* Analytical thinking, problem-solving, communication, and ability to work in Agile environments
Preferred Skills:
* Exposure to Big Data technologies (Hadoop, Spark)
* Experience with scheduling tools (Control-M, Autosys)
* Knowledge of data governance and security best practices
* Familiarity with BI tools (Tableau, Power BI)
The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.
We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.
Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.
This job is not eligible for bonuses, incentives or commissions.
Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
By clicking ?Apply Today? you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.