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
