BriefCase
BriefCase

Db2 Database Admin Job in Rarr Technologies

Db2 Database Admin

Rarr Technologies 4+ weeks ago
Apply Now
Job Summary
  • 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.
Experience Required :

8 to 12 Years

Vacancy :

2 - 4 Hires

Similar Jobs for you

See more recommended jobs