Logo
Diverse Lynx

Teradata DBA

Diverse Lynx, Myrtle Point, Oregon, United States, 97458

Save Job

Role: Teradata DBA Location: Remote Contract

Database Installation and Configuration: Installing, configuring, and upgrading Teradata database systems, including software and utilities.

User and Security Management: Creating and managing user accounts, roles, profiles, and basic access privileges to control database access.

Backup and Recovery Operations: Performing routine data backups, managing recovery processes, and ensuring data integrity and availability.

System Monitoring and Alerting: Monitoring database health, performance metrics (CPU, I/O, space), and setting up alerts for potential issues.

Basic Troubleshooting: Diagnosing and resolving common database-related problems, such as connectivity issues, space constraints, or failed jobs.

Advanced Responsibilities:

Performance Tuning and Optimization: Deep-diving into SQL query optimization, analyzing explain plans, and implementing advanced techniques (e.g., join indexes, partitioning) to enhance system performance.

Workload Management (TWM/TDWM): Designing, configuring, and managing Teradata Workload Manager rules to prioritize queries, manage concurrency, and ensure service level agreements (SLAs).

Capacity Planning and Growth Management: Analyzing historical usage patterns, forecasting future growth, and planning for hardware and software upgrades to meet evolving business needs.

Disaster Recovery Planning and Testing: Developing, documenting, and regularly testing comprehensive disaster recovery strategies to ensure business continuity in the event of a major outage.

Advanced Security and Compliance: Implementing advanced security features (e.g., encryption, auditing, row-level security), ensuring compliance with data governance policies, and conducting security audits.

Thanks & Regards,

Shashi Bhushan

Diverse Lynx LLC |300 Alexander Park|Suite #200|Princeton , NJ 08540

Office: +732-452-1006 ext:344

Email: shashi.bhushan@diverselynx.com | URL: http://www.diverselynx.com

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.

#J-18808-Ljbffr