Find Jobs
Find Jobs Near You – Available Work in Your Location
Skip to job details
TC
Tata Consultancy Services Limited
Database Administrator
Career Insights for Database Administrator
See where this job fits in the broader career landscape. Knowing your career path helps you see what's possible from here.
Scorecard
Based on New York data
Review key factors to help you decide if this role fits your goals. How is this calculated?
What they do
A Database Administrator uses software to store and organize data, such as an organization's records or financial information. Ensures that users can easily access the information they need, and that data are protected from unauthorized access.
$104,070 / year median in New York
-20% projected decline
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.