Database Administrator
Listed on 2026-08-08
-
IT/Tech
Database Administrator, Information Security & Data Protection, Data Engineering, Data Warehousing
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 (table spaces) and memory (buffer pools) 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 & ResponsibilitiesTechnical 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 (table spaces) and memory (buffer pools) 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
#J-18808-Ljbffr(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).