jobs

Database Administrator

Key Business Solutions   Sacramento, CA   Full-time     Information Services / Technology (IT)
Posted on April 22, 2022

Database Administrator:

Install and upgrade the DB2 UDB software on AIX which ranges from setting up environments on the development, test and production layers. Database creation and security setup in UDB EE and database upgrade and fix pack implementations. Table and index design in EE for optimal performance. Monitor maintenance jobs for the database such as reorg, runstats, backup, recovery scripts, analyze production failures and slow performance by db2 diagnosis tool such as db2top, db2pd and snapshots. Optimize SQL queries and analyze database performance issues. Perform administration tasks such as database backup and restoration, monitoring database health in terms of memory, CPU utilization, disk space, and security. Handle database refreshes and respond to the DB related requests and updates of operational procedure documents as necessary. Perform administration tasks such as database backup and restoration, monitoring database health in terms of memory, CPU utilization, disk space, and security. Masters with engg(any) with 6 months of experience in the related field is required. Should be willing to travel and relocate to implement the it projects. Send resumes to Attn: President, Key Business Solutions, Inc, 4738 Duckhorn drive, Sacramento, CA 95834.