Us Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 12th Nov 2020
Title: DB2 System DBA – Mainframe (System programmer ) + Application DB2 DBA skills
i. Tools and Technologies :
z/OS, SMP/E, SMS, DB2, Sysview, HSM, TMON, OmegaMon, DB2 Admin, DB2Connect, Db2 Fast Load, LOADPLUS fro Db2, QMF, Log analyser
ii. System DBA role as following,
iii. Install new, upgrade, migrate, consolidate and configure database Systems, services, settings, storage, etc. in accordance with standards and project or operational requirements.
iv. Maintain installation and configuration procedures.
v. Build new DB2 subsystems
vi. Operational Role as following,
vii. Perform daily System monitoring, verifying the integrity and availability of all databases, server resources, Systems and key processes, reviewing System and database logs, and verifying completion of scheduled jobs such as backups.
viii. Support disaster recovery testing.
ix. System level performance tuning like bufferpool, EDM pool, DSNZPARm changes etc..
x. Support incident management processes including responding to alerts, 24x7x365 on-call and root cause analysis. Repair and recover from hardware or software failures. Coordinate and communicate with impacted constituencies through contacts with application support and Technical Operations Center
xi. Maintenance role as following,
xii. Apply database patches and upgrades on a regular basis, and upgrade Database administrative tools and utilities. Configure / add new services as necessary to maintain control, security and stability.
xiii. Assist in deployment, roll-out and maintenance of applications per project or operational needs.
xiv. Perform and manage periodic performance reporting to support capacity planning.
xv. Perform ongoing performance tuning, and resource optimization as required.
xvi. Configure databases memory, and disk, and IO as required.
Application DBA:
xvii. Strong Knowledge on ER Diagram.
xviii. DB2 database design and database alteration and Migration.
xix. DASD/Tape management.
xx. Capacity Planning.
xxi. Experience in Application SQL Performance Tuning..
xxii. Strong Knowledge on DB2 Utilities.
xxiii. Strong Knowledge of Troubleshooting skills on DB2 application database administration.
xxiv. Proactive monitoring in space usage and troubleshooting space management.
xxv. DB2 application users management.