Database Administrator

2 months ago

Hyderabad, India Tata Consultancy Services Full time

Job Description


SN

Required Information

Details

1

Role

DBA

2

Required Technical Skill Set

DB2


Desired Experience Range

4+ Years


Location of Requirement

Hyderabad



Desired Competencies (Technical/Behavioral Competency)

Primary Skills

Job Description


The DBA team is looking to add to their current talent a self-motivated, highly experienced DB2 Administrator. The DBA team is responsible for tasks such as project management, development of best practices and repeatable procedures for deploying databases, day-to-day operational activities including break/fix, capacity management, backup and recovery, database replication setup/management and ongoing database change reviews. The team also builds and maintains large-scale and very high transactional DB2 databases on Linux platform.

Technical Skills:

RDBMS : IBM DB2 LUW 9.7,10.1,10.5 and V 11.x

Operating systems : IBM AIX, Linux & Windows

Languages : Structured Query Language, UNIX Shell Basics


Responsibilities:

Experience in DB2 Installations, configurations, administration, and upgrade of the databases to higher versions in LUW environment.

Hands on experience in DB2 Fix pack installation in standalone and HADR environments.

Updating DB and DBM cfg parameters based on requirement.

Experience in performing online, offline, incremental and Delta backups to various environments like Disk, TSM, tape, tdp_r3.

Checked the database backup image's integrity using db2ckbkp.

Experience in configuring High Availability Disaster Recovery solution.

Experience in HADR DR-Drill Activity.

  • Restoring PROD backup image in TSM/TAPE/Disk/tdp_r3 environments into same database and into DEV, Quality using redirected restore.
  • Experience in SQL tuning using db2advis and db2expln Tools.
  • Experience in data movement utilities like Export, Import and Load.
  • Database maintenance utilities like Reorgchk, Reorg, Runstats and Rebind.
  • Experience in trouble shooting database issues using db2diag, Snapshot, db2pd, and db2top, db2support, monreport.
  • Experience in generating data definition language using db2look tool from existing databases and replicating the same objects in newly created databases.
  • Daily update calls with the customer and always used to keep them in track with ongoing major activities or any issues.
  • Ensure integrity, availability, and performance of DB2 database systems by providing technical support and maintenance.
  • Monitor database performance and recommend improvements for operational efficiency.
  • Assist in capacity planning, space management and data maintenance activities for database system.
  • Perform database enhancement and modification as per the requirements.
  • Perform database recovery and backup tasks on daily and weekly basis.
  • Develop and maintain patches for database environments.
  • Identify and recommend database techniques to support business needs.
  • Assist in implementation of new features and program fixes in databases.
  • Maintain database security and disaster recovery procedures.
  • Perform troubleshooting and maintenance of multiple databases.
  • Resolve any database issues in accurate and timely fashion.
  • Monitor databases regularly to check for any errors such as existing locks and failed updates.
  • Oversee utilization of data and log files.
  • Manage database logins and permissions for users.
  • Good scripting ability and good working knowledge of Shell Scripts, Perl or Python.

Attending Daily status review calls.

Providing 24*7 Support in the Project.

Qualifications:

  • Demonstrated experience with Open Source/Linux development and production environments
  • Hands on experience with designing and implementing database replication strategies
  • Experience in designing and automating repetitive processes
  • 3-5 years plus working with DB2 technology. Certified DB2 is a plus
  • Possess creative ability, credibility, self-confidence, and independence
  • Good team player with strong analytical, communication and troubleshooting skills
  • Able to work under pressure and multi-task
  • Pro-active, dedicated, committed and responsible
  • Should be willing to work in cross skilled DB technologies.
  • Strong AWS Background or another cloud skills would be an added advantage.

  • Database Administrator

    2 weeks ago

    Hyderabad, Telangana, India 2104 Merative Technologies India Private Limited Full time

    Job SummaryWe are seeking a highly skilled Senior Oracle DBA to join our team at 2104 Merative Technologies India Private Limited. As a key member of our database administration team, you will be responsible for the design, implementation, and maintenance of our Oracle databases.Key ResponsibilitiesAdminister, maintain, tune, and troubleshoot Oracle...

  • Database Administrator

    3 weeks ago

    Hyderabad, Telangana, India Rightpath Computer Technologies Pvt Ltd Full time

    Job Title: Database AdministratorAbout the Role:At Rightpath Computer Technologies Pvt Ltd, we are seeking a skilled Database Administrator to join our team. As a Database Administrator, you will be responsible for the effective administration of database instances, ensuring optimal performance, security, and availability.Key Responsibilities: Perform basic...

  • Database Administrator

    3 weeks ago

    Hyderabad, Telangana, India Maneva Consulting Pvt. Ltd Full time

    Job Title: Oracle DBAJob Description:We are seeking a highly skilled Oracle DBA to join our team at Maneva Consulting Pvt. Ltd. The ideal candidate will have extensive experience in Oracle Exadata DB administration, performance tuning, and troubleshooting.Key Responsibilities:Administer and manage Oracle RAC and Standby databasesEnsure database security and...

  • Database Administrator

    3 weeks ago

    Hyderabad, Telangana, India Rightpath Computer Technologies Pvt Ltd Full time

    Job Title: Database AdministratorRightpath Computer Technologies Pvt Ltd is seeking a skilled Database Administrator to join our team. The ideal candidate will have experience in database administration, support, and administration of database instances.Key Responsibilities:Support and administer database instances effectivelyPerform basic tasks related to...

  • Database Administrator

    4 weeks ago

    Hyderabad, Telangana, India Rightpath Computer Technologies Pvt Ltd Full time

    Job Title: Database AdministratorWe are seeking a highly skilled Database Administrator to join our team at Rightpath Computer Technologies Pvt Ltd. As a Database Administrator, you will be responsible for ensuring the smooth operation of our database systems, providing technical support, and implementing database solutions to meet business needs.Key...

  • Database Administrator

    5 months ago

    Hyderabad, India Merative Full time

    Join a team dedicated to supporting the crucial mission of improving health outcomes. - Administer databases running on RAC in Exadata environments. - Adopt and learn new cloud technologies for use in Watson Health solutions. - Automate Manual Tasks - Documentation of work - Required Professional and Technical Expertise - 5-12 years of relevant experience, -...

  • Database Administrator

    3 weeks ago

    Hyderabad, Telangana, India Tata Consultancy Services Full time

    Job Title: Database AdministratorWe are seeking a highly skilled Database Administrator to join our team at Tata Consultancy Services. The successful candidate will be responsible for designing, implementing, and maintaining large-scale DB2 databases on Linux platforms.Key Responsibilities:Design and implement database replication strategiesConfigure and...

  • Database Administrator

    2 weeks ago

    Hyderabad, Telangana, India InfoVision Inc Full time

    Key Responsibilities:As a seasoned Oracle DBA Developer at InfoVision Inc, you will be responsible for managing and maintaining large-scale Oracle databases in a cloud-based environment. Your expertise in database administration, automation, and DevOps will be crucial in ensuring the smooth operation of our database infrastructure.Responsibilities:Design,...

  • Database Administrator

    3 weeks ago

    Hyderabad, Telangana, India UnitedHealth Group Full time

    At UnitedHealth Group, we're committed to helping people live healthier lives and making the health system work better for everyone. As a Database Administrator, you'll play a critical role in ensuring the integrity and performance of our database systems.Key Responsibilities:Comply with company policies and procedures, as well as directives related to data...

  • Database Administrator

    3 weeks ago

    Hyderabad, Telangana, India Promptora AI Full time

    **Database Administrator** **Key Responsibilities**: - Manage and maintain relational databases, including SQL Server, Oracle, and MySQL, ensuring optimal performance and security. - Design and implement effective database solutions, focusing on scalability and efficiency. - Develop and execute backup, recovery, and disaster recovery plans to safeguard...

  • Database Administrator

    2 weeks ago

    Hyderabad, Telangana, India Rightpath Computer Technologies Pvt Ltd Full time

    Job Title: Database AdministratorJob Summary:We are seeking a skilled Database Administrator to join our team at Rightpath Computer Technologies Pvt Ltd. As a Database Administrator, you will be responsible for the effective administration of database instances, ensuring high availability, performance, and security.Key Responsibilities:Administer database...

  • Database Administrator

    2 months ago

    hyderabad, India Tata Consultancy Services Full time

    TCS is Hiring for DB2 on Unix SME Location- Hyderabad Exp- 4 to 8 Job Description- DB2 Administrator on AIX /Unix environment. In summary what we are looking for is a DB2 Administrator for the following day by day activities Database Management: Ensure the integrity, availability, and performance of DB2 database systems. Provide technical support and...

  • Database Administrator

    7 days ago

    Hyderabad, Telangana, India Chiselon Technologies Pvt Ltd Full time

    About Us:Chiselon Technologies Pvt Ltd is a forward-thinking organization that aims to revolutionize the industry with its cutting-edge technology solutions.Job Description:We are seeking an experienced Database Administrator to join our team. The successful candidate will be responsible for designing, developing, and maintaining database systems to support...

  • Database Administrator

    2 weeks ago

    Hyderabad, Telangana, India Virtusa Full time

    Database Expert Wanted for High-Availability SystemsAt Virtusa, we are seeking an experienced Database Administrator to design, implement, and manage high-availability database systems. The ideal candidate will have a proven track record of building and maintaining large-scale databases, ensuring data security, privacy, and integrity.Key...

  • Database Administrator

    4 weeks ago

    Hyderabad, Telangana, India Tata Consultancy Services Full time

    Job Title: Database AdministratorWe are seeking a highly skilled Database Administrator to join our team at Tata Consultancy Services. As a key member of our database team, you will be responsible for designing, implementing, and maintaining large-scale and high-transactional DB2 databases on Linux platforms.Key Responsibilities:Design and implement database...

  • Database Administrator

    2 months ago

    Hyderabad, India Tata Consultancy Services Full time

    TCS is Hiring for DB2 on Unix SMELocation- HyderabadExp- 4 to 8Job Description-DB2 Administrator on AIX /Unix environment.In summary what we are looking for is a DB2 Administrator for the following day by day activities Database Management:Ensure the integrity, availability, and performance of DB2 database systems.Provide technical support and maintenance...

  • Database Administrator

    2 months ago

    hyderabad, India Tata Consultancy Services Full time

    TCS is Hiring for DB2 on Unix SMELocation- HyderabadExp- 4 to 8Job Description-DB2 Administrator on AIX /Unix environment.In summary what we are looking for is a DB2 Administrator for the following day by day activities Database Management:Ensure the integrity, availability, and performance of DB2 database systems.Provide technical support and maintenance...

  • Database Administrator

    1 month ago

    Hyderabad, India Ingrain Systems Inc Full time

    Job Title : Essbase DeveloperExperience: 5+ yearsWork mode : RemoteJob Description – Sr software Engineer, EssbaseThe ESSBASE DB Programmer will be responsible for designing, developing, and optimizing Essbase databases, cubes, and applications to support our organization's financial planning, analysis, and reporting needs. The ideal candidate will have a...

  • Database Administrator

    1 month ago

    hyderabad, India Ingrain Systems Inc Full time

    Job Title : Essbase DeveloperExperience: 5+ yearsWork mode : RemoteJob Description – Sr software Engineer, EssbaseThe ESSBASE DB Programmer will be responsible for designing, developing, and optimizing Essbase databases, cubes, and applications to support our organization's financial planning, analysis, and reporting needs. The ideal candidate will have a...

  • Database Administrator

    1 month ago

    Hyderabad, India Ingrain Systems Inc Full time

    Job Title : Essbase DeveloperExperience: 5+ yearsWork mode : RemoteJob Description – Sr software Engineer, EssbaseThe ESSBASE DB Programmer will be responsible for designing, developing, and optimizing Essbase databases, cubes, and applications to support our organization's financial planning, analysis, and reporting needs. The ideal candidate will have a...