RARR Technologies Hiring for DB2 Database admin at Faridabad, Haryana Full Time

Full Job Description
Job Details – DB2 Database admin

Job ID :
RARR Job 2996

Job Title :
DB2 Database admin

Job Type :
Permanent

Job Location :
Total Experience :
8 – 12 Years

Skills :
DATABASE ADMINISTRATION, DB2

Posted – 21/02/2023

Job Description :
Job Description:
Proactively provide Database structure, usability and performance improvements review query performance reports such as Oracle or SQL Server Access Plans for inefficiencies and performance issues.
Analyze Database activity, performing application Database performance tuning, and maintaining test and production Databases
Good in DB2 (z/os) + JCL + DB2 utilities suite.
DB2 (z/os) vs DB2 for Windows and Linux.
Hands-on experience on Microsoft ACCESS forms and macros.
Creating custom scripts as needed for automation and Debugging code.
Provide updated SQL queries or indices to improve performance.
Work with Solution Architects and physical DBAs to request the implementation or modification of Databases in development, test, QA and production environments
review data volumetric information on an on-going basis, and notify physical DBAs of any changes from current levels and improve Database performance.
Provide consultation and advice on new queries and stored procedures.
Review new queries and stored procedures on an exception basis, at Exelon request, where special skill, knowledge or techniques are required.
Participate in the creation and maintenance of test data sets to support various test requirements, including but not limited to system tests, performance tests and in-scope user acceptance tests.
Provide assistance in the deployment of Database Changes, and support the back out of failed changes; maintain data dictionary systems and document all changes to Databases.