Senior Database Administrator (DBA)

Job Description : 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.

Required Skills and Qualifications

Technical Expertise :

Skills :

Soft Skills :

Preferred Qualifications

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.

Required Skills :