Hot Requirements :Mainframe DBA Remote No H1B, CPT and OPT at Remote, Remote, USA |
Email: [email protected] |
From: Princy Jain, Maintec [email protected] Reply to: [email protected] Mainframe DBA Remote role Morgan Stanley Responsibilities: Creating and Managing DB2 objects like Databases, Table spaces, Tables, Indexes etc. in Production and development regions. Performed data maintenance using LOAD, UNLOAD, REORG and RUNSTATS. Monitoring health check jobs like Imagecopy, Runstats, DDL$DML reports etc. Converting Segmented and Partitioned table spaces into UTS. Rebalancing of Partitions. Space Management and Monitoring. Performed End-to-End Release activities. Prepared test environments and performed data refresh. Identified problematic SQL and optimized SQL queries that helped improve application performance. BIND/REBIND plan and packages. Creating and scheduling utilities like COPY, Reorg, RUNSTATS and QUIESCE. Running Adhoc Reorgs, Runstats and Rebinds in Productions Environment. Altering of DB2 Objects on Production and Test Environments. Analyzed index requirements and designed appropriate indexes. Implementing and scheduling production DB2 jobs. Ensured proper backup and recovery by maintaining DB2 image copies and recovery JCLs. Granting/Revoking privileges on DB2 objects for Application Users. Supporting the Application team to resolve the DB2 issues. Implementing and scheduling production DB2 jobs. Reviewing the Jcl's, DDL's, Grants, Changes and Scheduling details created by the team members. Performed Pre and Post Validations for Z/OS Migrations. Disaster recovery to recover the data using recovery procedures and analyzing the DB2 log. Developing and maintaining database standards and naming conventions. Monitoring on daily, weekly and monthly batch cycles. Provided 24*7 production support on rotation basis. Requirements: DB2 DBA ON MAINFRAME Z/OS. : 10+yrs. Keywords: zos Hot Requirements :Mainframe DBA Remote No H1B, CPT and OPT [email protected] |
[email protected] View all |
Fri Jun 21 18:41:00 UTC 2024 |