Location
Nagpur | India
Job description
Job Description (Posting).
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
Provide updated SQL queries or indices to improve performance.
Work with Data 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.
Qualifications
Experience administering and migrating DB2 Databases
Provide DB2 Database Administration support
Monitor database performance performed data change requests, migration and database maintenance.
Analyze capacity and growth of databases using various automated testing tools and performance optimization.
Support developers for efficient SQL query and performance. (1.) To provide required presales support (RFP response, Solution Defense, Customer Presentation) (2.) To thoroughly understand and analyse the IT Service Management tool to be implemented for the customer project (3.) To efficiently map the customer requirements to the ITSM tool capabilties and, design the deisred process for each ITSM tool module (4.) To ensure that the desired process has been signed off by process owner and accordingly prepare function specification document and application data in adherence to quality and process compliances (5.) To prepare various types of testing scripts to test the tool and collaborate with other module consultants for data transfer and action triggers from correlated events in adifferent systems. (6.) To keep oneself updated through the latest developments in concerned skill and domain functions
Qualification
B-Tech
Skill (Primary)
EPS-Database-IBM DB2
Job tags
Salary
