Mavensoft Technologies

Offer DBA support for applications running on AIX, zOS, and Linux platforms, support Java-based applications using JDBC and SQLJ, and create/manage JCL jobs to automate database and system tasks.. Develop and maintain UNIX shell scripts for monitoring, work with ETL tools to extract DB2 data, and develop ETL routines using DB2 utilities and other data warehousing tools.. Provide ongoing technical assistance and education for DB2, COBOL, JCL, and SQL, conduct performance analysis, implement recovery strategies using RMAN, and support schema development and system configuration.. Specific DBMS Skills: Extensive knowledge of DB2 on z/OS and AIX, SQL construction and optimization, and database connectivity.. Experience with z/OS, OMVS, CICS, AIX security, and scripting.

db2 database administrator

Job Title: Sr. DB2 Database Administrator Duration: 6 Months (contract on W2) Location: Salem, OR (Remote) Description Seeking a highly experienced Senior DB2 Database Administrator for a part-time role. Client provides critical technology systems and services to over 18,000 agency staff across the state, supporting essential functions such as client service program eligibility, medical and social assistance, and health protection. Scope Of Work As part of the Technology Platform – Data Resources Management Team (DRM), the Senior DB2 Database Administrator will: <ul><li>Administer and manage the enterprise DB2 environment, providing expert consultation to management, DRM staff, technical, and business stakeholders.</li><li>Contribute to the Mainframe Modernization project, managing IBM DB2 databases for Unix and Mainframe operating systems.</li><li>Perform data refreshes in development, test, and UAT environments, assist in deprecating legacy DB2 databases, and troubleshoot and resolve DB2 job and database issues.</li><li>Plan and implement DB2 upgrades and patches, support data export and loading, and provide support for batch jobs on zOS, including scheduling, monitoring, and troubleshooting.</li><li>Offer DBA support for applications running on AIX, zOS, and Linux platforms, support Java-based applications using JDBC and SQLJ, and create/manage JCL jobs to automate database and system tasks.</li><li>Design, implement, maintain, tune, and support DB2/UDB databases on AIX and z/OS platforms, manage tables and indexes, and provide on-call support for OLTP applications on the zOS platform.</li><li>Develop and maintain UNIX shell scripts for monitoring, work with ETL tools to extract DB2 data, and develop ETL routines using DB2 utilities and other data warehousing tools.</li><li>Provide ongoing technical assistance and education for DB2, COBOL, JCL, and SQL, conduct performance analysis, implement recovery strategies using RMAN, and support schema development and system configuration. </li></ul>Key Responsibilities: <ul><li>Data Operations: Diagnose and resolve complex issues, assist with major system crashes, and establish procedures for problem resolution. Communicate effectively with customers and coordinate training for assigned infrastructure functions.</li><li>Data Construction: Manage daily operations, including installation, performance monitoring, security, backups, and scheduling. Plan and schedule product installations, resolve performance issues, and maintain relational database integrity.</li><li>Planning: Oversee strategic planning for resource utilization, new technologies, disaster planning, and system performance. Manage data-related decisions, establish metadata standards, and integrate new technologies. </li></ul>Required Skills and Qualifications: <ul><li>Extensive Knowledge: Theories, principles, and practices of Information Systems Technology, project administration methods, information systems architecture, and database management.</li><li>General Knowledge: Business systems, organizational structures, and trends in IS technology.</li><li>Skills: Administering multi-system projects, identifying project scope, assigning tasks, developing plans, policies, and procedures, analyzing organizational needs, and designing data structures.</li><li>Specific DBMS Skills: Extensive knowledge of DB2 on z/OS and AIX, SQL construction and optimization, and database connectivity. Experience with z/OS, OMVS, CICS, AIX security, and scripting. </li></ul>Please Apply Online. To learn more about Mavensoft visit us at www.mavensoft.com

START NEW SEARCH