Database Administrator

Tata Consultancy Services; City of Albany (NY); On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

Discretionary annual incentive

Comprehensive medical coverage

Family leave benefits

Commuter benefits

Certification & training reimbursement

Vacation & holidays

401K plan

Job summary

Tata Consultancy Services seeks a DB2 DBA to install, configure, and upgrade DB2 LUW on Linux servers. You will manage encryption, authentication, and backups, and optimize database performance while supporting multiple environments.

The role requires hands-on experience with HADR, monitoring tools, and scripting. Salary ranges reflect US market rates for a senior DB2 specialist.

Qualifications

• Bachelor's degree in Computer Science or equivalent.
• DB2 DBA experience on Linux systems.
• Experience with backup, recovery, and HADR.

Responsibilities

• Install, configure, and upgrade DB2 LUW servers on Linux.
• Implement disaster recovery using HADR.
• Manage encryption with DB2 native encryption and Guardium.

Skills

DB2 DBA

Linux

Shell scripting

DB2 LUW

Education

Bachelor of Computer Science

Tools

Erwin

Job description

Job Description

• DB2 LUW Database server installation, configuration and upgrade on Linux servers.
• Database disaster recovery setup (HADR).
• Database server encryption using DB2 native encryption and IBM Guardium.
• Manage database authentication and authorization.
• Database monitoring and performance optimization; db2expln, db2advis, db2top, db2diag, db2pd etc.
• Database backup and log management; database restoration from incremental/full backup image.
• Database storage space (tablespaces) and memory (bufferpools) management; database capacity planning.
• Design and implement database changes according to business requirement; roll-out changes to various database environments with releases.
• Triggers/Stored procedure/Functions/indexes creation based on application requirement.
• Logical data modelling and ERD generation using Erwin.
• Data loading and error resolution using load and import utilities.
• Data Profiling and cleansing using SQL statements.
• Perform database maintenance activities such as runstats, reorg, snapshots, prun logs etc.
• Knowledge of bash/shell scripting and cron scheduling.
• Basic knowledge of ETL and associated processes.

Job Description

Must Have Technical/Functional Skills

DB2 DBA

Roles & Responsibilities

Technical Skills

• DB2 LUW Database server installation, configuration and upgrade on Linux servers.
• Database disaster recovery setup (HADR).
• Database server encryption using DB2 native encryption and IBM Guardium.
• Manage database authentication and authorization.
• Database monitoring and performance optimization; db2expln, db2advis, db2top, db2diag, db2pd etc.
• Database backup and log management; database restoration from incremental/full backup image.
• Database storage space (tablespaces) and memory (bufferpools) management; database capacity planning.
• Design and implement database changes according to business requirement; roll-out changes to various database environments with releases.
• Data movement across various database environments.
• Triggers/Stored procedure/Functions/indexes creation based on application requirement.
• Logical data modelling and ERD generation using Erwin.
• Data loading and error resolution using load and import utilities.
• Data Profiling and cleansing using SQL statements.
• Perform database maintenance activities such as runstats, reorg, snapshots, prun logs etc.
• Knowledge of bash/shell scripting and cron scheduling.
• Basic knowledge of ETL and associated processes.

Generic Managerial Skills, If any

Good to have team management skills to lead the initiative if required.

Salary Range: $120,000 -$150,000 year

TCS Employee Benefits Summary

Discretionary Annual Incentive.

Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.

Family Support: Maternal & Parental Leaves.

Insurance Options: Auto & Home Insurance, Identity Theft Protection.

Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.

Time Off: Vacation, Time Off, Sick Leave & Holidays.

Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Qualifications: BACHELOR OF COMPUTER SCIENCE