PROCESSING APPLICATION
Hold tight! We’re comparing your resume to the job requirements…

ARE YOU SURE YOU WANT TO APPLY TO THIS JOB?
Based on your Resume, it doesn't look like you meet the requirements from the employer. You can still apply if you think you’re a fit.
Job Requirements of Senior Database Administrator (DBA):
-
Employment Type:
Full-Time
-
Location:
Chicago, IL (Onsite)
Do you meet the requirements for this job?
Senior Database Administrator (DBA)
About the job Senior Database Administrator (DBA)
Role Overview
The Database Administrator (DBA) will play a critical role in the Teradata migration project by managing and optimizing the existing database environment. The DBA will oversee data integrity, ensure optimal performance, and maintain database security during and after the migration to the Dell Managed Colo environment. This includes supporting ETL processes, query optimization, and ensuring seamless integration with interfacing systems.
Key Responsibilities
- Database Management: Maintain and monitor the Teradata database environment during migration, including production, development, and test nodes.
- Data Migration Support: Perform extraction, transformation, and loading (ETL) processes while ensuring data accuracy, integrity, and quality during the migration.
- Performance Tuning: Optimize database performance by identifying and resolving bottlenecks, ensuring efficient data flow.
- Schema Design: Assist in refactoring and updating schemas, stored procedures, and queries for compatibility with the target platform.
- Data Validation: Conduct comprehensive data validation and reconciliation to verify the success of migration efforts.
- Integration Support: Collaborate with teams to integrate the target database with upstream and downstream systems such as Hadoop, Tableau, SAS, and Talend.
- Backup and Recovery: Ensure data security by managing backup and recovery processes using tools such as NetBackup and TARA.
- Compliance and Security: Maintain compliance with security and regulatory standards during all phases of the project.
- Documentation: Create and maintain detailed documentation of database configurations, migration processes, and troubleshooting protocols.
- Post-Migration Support: Provide support to resolve any database issues during the stabilization phase after migration.
- Education: Bachelors degree in Computer Science, Information Technology, or a related field.
- Experience: 7+ years of experience in database administration, with significant exposure to Teradata environments.
- Proficiency in Teradata (v14.1 or later) database systems.
- Experience in database performance tuning and query optimization.
- Strong knowledge of ETL processes and tools.
- Familiarity with backup and recovery strategies using tools like NetBackup and TARA.
- Working knowledge of interfacing systems such as Hadoop, Tableau, SAS, and Talend.
- Proficient in SQL scripting for query tuning and automation.
- Understanding of data migration methodologies and challenges.
- Knowledge of regulatory compliance and data security protocols.
- Strong analytical and problem-solving abilities.
- Excellent communication and collaboration skills to work with cross-functional teams.
- Certification in database technologies (e.g., Teradata Certified Professional) Optional.
- Experience with modern platforms like ECS object storage and PowerFlex compute environments.
- Familiarity with scripting languages like Python or Bash for automation.
- Knowledge of additional database systems and cloud technologies.
Work Environment
The DBA will collaborate with architects, developers, and operations teams in a dynamic and fast-paced environment. This role demands attention to detail, a proactive approach to problem-solving, and a commitment to ensuring the seamless performance of database systems during and after migration.
Recommended Skills
- Analytical
- Apache Hadoop
- Attention To Detail
- Automation
- Bash (Scripting Language)
- Cloud Technologies
Help us improve CareerBuilder by providing feedback about this job: Report this job
Job ID: lg7ddqr
CareerBuilder TIP
For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.
By applying to a job using CareerBuilder you are agreeing to comply with and be subject to the CareerBuilder Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.