Mainframe Systems Programmer/Mainframe Database Administrator (DBA)

Candidates local to Los Angeles, CA 90020 would be preferred.

Hello,

We at AgreeYa solutions are focused on hiring highly skilled professionals who are excited by the opportunity to make a true impact on their careers as well as on our clients' businesses. We power our client s success and drive our consultants career growth.

We are seeking an experienced and outstanding Mainframe Systems Programmer/Mainframe Database Administrator (DBA) one of our esteemed clients. Kindly have a look at the below JD and reach us with your updated resume.

The job description is as follows:

Job Title :: Mainframe Systems Programmer/Mainframe Database Administrator (DBA)

Job Location :: Los Angeles, CA 90020 (Hybrid)

Position Description ::

• A Mainframe Systems Programmer/DBA is responsible for leading and/or supporting the most complex database upgrade projects, modification, installation, testing, implementation, maintenance and enhancements of new or existing system software products.
• This classification must plan, install, configure, test, implement and manage core database products, software products in support of the Client s database architecture and business needs.
• Special organizational or functional industry position titles for Systems Programmer/DBA include, but are not limited to, DB2 Systems Programmer/DBA, IMS Systems Programmer/DBA and ADABAS/NATURAL Systems Programmer/DBA.

Skills Required ::

• The Mainframe Systems Programmer/DBA for Legacy Systems manages different types of databases, such as hierarchical (IMS), relational (DB2), and file-based (ADABAS), and is responsible for planning and upgrading the database environments on a County-established basis.
• Verifying the health of all the databases; database administration technical consulting for application and operations teams for the purpose of project planning/development.
• Maintenance on production database systems.
• Performance of technical reviews for existing systems that utilize one of the following database management systems (DBMS): ADABAS, DB2 or IMS; performance of evaluations for the purposes of selecting new or fine-tuning existing DBMS software.
• Consultation with project development teams to provide recommendations on database design.
• Development of logical and physical database designs.
• Creation of overviews of logical database designs.
• Creation of physical databases; database capacity planning.
• Development and use of backup and recovery procedures for databases.
• Database performance monitoring; database space monitoring.
• Database reorganizations.
• Database replication.
• Database compression and database partitioning.
• The following technology skill sets are required to perform in this classification. IBM: Z/OS, IMS, DB2, ADABAS, SMP/E, JCL, IMS DB/DC, CICS, ACF2, ASSEMBLER/COBOL/REXX, IBM FILE MANAGER, DELTA/IMS, NATURAL/ SUPERNAT, ENTIREX, CA SPOOL, IMS & DB2 BMC Tools, N20/TRIM.

Skills Preferred ::

• Skills in assessing, planning and migrating DBs to Cloud Environment.
• Skills in transferring, validating and maintaining DBs in a Cloud environment.
• Skills in Installing, Configuring and Supporting Oracle Enterprise Edition Database 19c as a backend for both public facing web applications and internal data warehousing on Linux operating system.
• Skills in Installing and configuring MySQL and PostgreSQL databases.
• Skills in Installing and Supporting Microsoft SQL server instances.
• Knowledge in Configuring and supporting Oracle gateways connecting SQL Server, MySQL and PostgreSQL server instances to the Oracle database.
• Knowledge in Oracle Spatial implementation and support.
• Mastery in building custom extracts, transform and load (ETL) utilities with Crons, SQLLoader and PL/SQL.
• Skills in Database Administration services such as patch install, cloning, backup and recovery of databases and script development (Unix shell scripting and PL/SQL).
• Skills in Troubleshooting and resolution of ETL Jobs

Experience Required ::

• This classification must have a minimum of seven (7) years of experience as a Systems Programming/ DBA, with at least three (3) years of that experience in a lead role.

Experience Preferred ::

• 4 years of DB Administration experience, specifically in a Oracle/MySQL/PosgreSQL environments.
• 3 years of experience in transferring, validating, maintaining DBs in cloud environment.

Education Required ::

• This classification requires the possession of a bachelor s degree in an IT-related or engineering field.

Contact :: Deepak Soni at AgreeYa Solutions

ABOUT AGREEYA SOLUTIONS:
AgreeYa Solutions is a global provider of software, solutions, and services to over 200 larges to small organizations in the US, Europe, India, China, Korea, UAE, Singapore and Mexico across various industries. Headquartered in Folsom, California (US) and 6 Global Delivery Centers, AgreeYa s flexible Global but Local approach delivers world class technology and business solutions around Portal and Enterprise Social Collaboration (SharePoint and Social tend), Cloud & Infrastructure (Distend), Mobility (Envelop), Application Development & Management, Product Engineering, Independent Software Testing, IT Staffing (Workforce Solutions) and Risk and Compliance Staffing Solutions. Along with this end-to-end portfolio of services, AgreeYa leverages mature quality processes based on ISO 9001-2008 and SEI-CMMI standards to become a trusted IT partner for our customers and have been recognized by Gartner as Cool Vendor for Enterprise Mobility; by Sacramento Business Journal as Top Software Companies; by Silicon India as the Top 5 Outsourced Product Development Companies; and by DiversityBusiness.com as Top 500 Diversity-Owned Businesses in the United States with Minority Business Enterprise certification from (NCMSDC)