Back to search
Tata Consultancy Services Linkedin · Posted 2d ago

Database Administrator

Albany, New York, United States

Linkedin
Continue to application Add your email once, then Caio opens the original posting.

Indexed description

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 & amp; 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

Free. 20 seconds. No password. See every match in this search.

Create a free Caio profile to unlock more results and save your role and location preferences.

Unlock free search
Want help applying to roles like this? Search Caio for free. If repetitive applications get heavy, Managed Job Search adds supervised execution for $99/month.
View Managed Job Search