Database Administrator

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.

#LI-SP1