Send me more jobs like this

DB2 Admin + Q-Replication

Keywords / Skills : DB2, DBA, DB2 LUW, TSA, DB2 HADR, TSA automation, DB2 Admin, Q Replication

6 - 9 years
Posted: 2019-10-15

IT/Computers - Software
Project Leader/ Project Manager
Posted On
15th Oct 2019
Job Description
DB2 Admin + Q-Replication (5+ Years)

Work Location – Bangalore

Skills Required

• B.E\B.Tech\MCA in Computer Science or any other discipline.

• 6-9 years of experience as a DB2 DBA

• Responsible for developing and maintaining the database standards, conventions, best practices and technical details for SOPs/ Work Instructions and ensure they are followed to maintain a viable system.

• Complete understanding of DB2 architecture.

• Staying abreast of the most current release of DB2 LUW (V10.1, V10.5, V11) and TSA(3.2.X.X,4.1.x.x) including compatibility issues with operating systems, third party software and utilities

• Keeping the database up to date in technology, on patches and supporting the roll-out of new versions & features

• Support of daily operations including job monitoring and troubleshooting of DB2 databases

• Configure, troubleshoot and ensure high availability using DB2 HADR and TSA automation

• Perform database maintenance tasks - Backup, restore, roll forward recovery, reorg, runstats, table move, compression and refresh activities

• Monitor, troubleshoot and tune database environments.

• Work with application development teams and assist with problem resolution

• Consult and review SQL code, perform analysis and provide recommendations

• Capacity planning for all the database systems.

• Execute upon key DB2 team initiatives and provide technical support as needed for upgrades, installations, New system build, refreshes, proofs of concept, backups, disaster recovery, capacity planning and other complex projects as needed

• Write and debug complex Shell scripts

• Assist in developing solutions to complex problems with ingenuity and innovation while ensuring Solutions are consistent with organizational objectives

• Understand Medtronic policies, standards, and guidelines regarding databases, database development and management to comply with HIPAA, SOX, Corporate audit requirements and other regulations.

• Participate in projects & work with project management, project and infrastructure teams to confirm scope, resource plan, and technical tasks

• Work with auditors and regulators to ensure database systems are compliant with all regulations.

• Identify opportunities of process improvement & automation and implement solutions to optimize the system, resource utilization for maximum performance.

• Engage vendor support/technical staff to assess solution options and to analyze and resolve or escalate issues.

• Able to work independently as well as cooperatively across teams

Preferred (Optional) Skills

• Experience supporting DB2 databases on UNIX preferably on AIX for SAP.

• Excellent working knowledge and hands on experience in UNIX.

• Good working knowledge of storage

• Demonstrated capability working with SAP tools including Solution Manager

• Demonstrated ability for setting, and executing toward, strategic direction across areas of responsibility.

• Good oral and written communication skills.

• Ability to explain complex technical solutions and architecture strategies to non-technical resources

About Company

Similar Jobs
View All Similar Jobs

Walkin for you