Database Administrator

Tata Consultancy Services; Irving (TX); On-site; USD 80,000 - 125,000; Full time

Job summary

Tata Consultancy Services in Irving, TX is seeking an experienced DBA to manage Netezza, Oracle, and DB2 environments across platforms. The role focuses on performance tuning, high availability, and automation to support enterprise data needs.

You will implement backup/recovery strategies, enforce security policies, and optimize SQL workloads. A Bachelor's degree in Computer Science is required and proficiency with scripting in Shell or Python is valued.

Qualifications

• Bachelor's degree in Computer Science required.
• Experience with enterprise RDBMS administration.
• Strong knowledge of SQL tuning and performance.
• Familiarity with backup/recovery strategies.

Responsibilities

• Administer Netezza, Oracle, and DB2 environments.
• Perform end-to-end SQL tuning and optimization.
• Design automated backup and recovery solutions.
• Enforce security policies and auditing standards.
• Develop automation scripts to streamline DBA tasks.

Skills

Netezza Administration

Oracle DBA

DB2 Administration

Performance Tuning

Backup & Recovery

Security & Compliance

Scripting & Automation

Education

Bachelor's degree in Computer Science

Tools

Netezza

Oracle

DB2 LUW

Shell scripting (Bash/Korn)

Python

SQL

Job description

Job Description

Roles & Responsibilities

• Netezza Administration: Perform NPS (Netezza Performance Server) administration, including grooming, Genstats, user management, and NzAdmin/NZMigrate tool usage.
• Oracle Database Administration: Install, configure, upgrade, and patch Oracle 12c/19c/21c. Manage Oracle RAC (Real Application Clusters), ASM (Automatic Storage Management), and Data Guard for high availability.
• DB2 Administration: Administer DB2 LUW (Linux, Unix, Windows) or z/OS. Perform table space management, reorgs, runstats, and image copies.
• Performance Tuning: Perform end-to-end SQL tuning and system optimization across all three platforms.
• Backup & Recovery: Develop, test, and maintain automated backup/recovery strategies, ensuring strict RPO/RTO adherence.
• Security & Compliance: Implement database security policies, manage user permissions, and ensure compliance with auditing standards.
• Scripting & Automation: Automate repetitive DBA tasks using Shell scripting (Bash/Korn) or Python
• Salary Range: $80,000 to $125,000 per year

Qualifications

• BACHELOR OF COMPUTER SCIENCE