Oracle Dba

3 weeks ago

Toronto, Canada ThoughtStorm Inc Full time

**Must Have**:
Extensive hands-on experience in the use of z/OS and related software packages and tools

Extensive experience with large-scale IMS and DB2 database systems development, capacity planning, performance tuning and database administration technology

Experience with mainframe development, PL/I, Cobol, and Assembler.

Senior Database Administrator (x1)

Description

**The Data Management Office (DMO) is seeking to hire one (1) Mainframe Database Administrator to deliver**:

- Support on preparation, installation, configuration and user test of mainframe z/OS, IMS and DB2 version upgrade:

- Review IBM documentation on upgrade for the most current hardware requirements, software requirements, prerequisites, and installation information
- Review the service that has been applied to the current system. Determine if critical service has been included in the new IMS release. If not, acquire the appropriate service for the new release.
- Review the functions and enhancements for the new version.
- Determine the availability of updates to IBM IMS and DB2® Tools, aids, and related products.
- Assess the impact of version upgrade to the existing IMS to DB2 Driver mirroring program and provide mitigation if required.
- Prepare a migration / test plan.
- Prepare a fallback plan. Review and update fallback plan with peers to ensure completeness.
- Backup IMS and DB2 databases before upgrade.
- Test IMS utilities.
- Follow up any problem related to version upgrade.
- Conduct analysis on the performance of transactions and batch jobs before and after the upgrade.

Â- Systems maintenance release development
- Work with development, architecture and BA teams to review requirements for IMS/DB2 database change
- Design IMS/DB2 database change according to requirements, review with stakeholders and implement in different mainframe regions according to release schedule
- Develop compression/uncompression program
- Develop program to load initial seed data
- Support development and testing

Â- IMS/DB2 to Oracle replication
- Assess the impact of maintenance release IMS/DB2 database change to the existing IMS/DB2 to Oracle replication program
- Enhance Information Builders Inc. IMS Data Replicator (IDR) program to include new IMS/DB2 database change introduced by maintenance release
- Support testing of IMS/DB2 to Oracle replication

Â- IMS Transaction Manager and IMS/DB2 database administration.
- Support IMS maintenance level update
- Optimization of IMS transactions and batch jobs to have better response time
- Support on MTO IMS user exits in Assembler
- Support IMS log extraction to fulfill Freedom of Information (FOI) request
- Maintenance of DB2 mirror for Driver data
- Monitor the health of IMS transaction by analyzing IMS log and trace, IMS DB, batch job, DB2 database, space usage, CPU utilization, connectivity for DBMS and Transaction, security alerts.
- Information request/data request/FOI fulfillment
- IMS/DB2 trouble shooting and performance tuning
- Support Disaster Recovery of IMS and DB2 data

**Skill Set Requirements**:

- Extensive hands-on experience in the use of z/OS and related software packages and tools
- Extensive experience with large-scale IMS and DB2 database systems development, capacity planning, performance tuning and database administration technology
- Extensive experience with administration of IMS Transaction Management
- Extensive experience with analysis and troubleshooting with IMS Log, trace and DUMP
- Extensive experience with analysis and troubleshooting with DB2 monitoring tools and statistics reports
- Experience with disaster recovery in z/OS, IMS DB/DC and DB2

Â- Experience with mainframe development, PL/I, Cobol, and Assembler.

Â- Expert experience in implementing IDR in a high volume, mission critical mainframe environment

Experience with IMS/DB2 to Oracle replication

**Skills**:
Experience and Skill Set Requirements

**Mainframe environment 40%**

Â- Extensive hands-on experience in the use of z/OS and related software packages and tools

Â- Extensive experience with large-scale IMS and DB2 database systems development, capacity planning, performance tuning and database administration technology

Â- Extensive experience with administration of IMS Transaction Management

Â- Extensive experience with analysis and troubleshooting with IMS Log, trace and DUMP

Â- Extensive experience with analysis and troubleshooting with DB2 monitoring tools and statistics reports

Â- Experience with disaster recovery in z/OS, IMS DB/DC and DB2

**Development and Implementation 40%**

Â- Experience with mainframe development, PL/I, Cobol, and Assembler.

**IMS/DB2 to Oracle Replication 20%**

Â- Expert experience in implementing IDR in a high volume, mission critical mainframe environment

Â- Experience with IMS/DB2 to Oracle replication.

**Job Type**: Fixed term contract
Contract length: 12 months

**Salary**: $65.00-$85.00 per hour

Schedule:

- Monday to Friday

Abi

  • MySQL Dba with Oracle Dba Exp

    4 weeks ago

    Toronto, Canada LTIMindtree Full time

    **Job Title: - MySQL Database administration with Oracle DBA experience** **Term: Full Time/Contract** **Job Description: - ** - MySQL & Oracle Database administration - Software Installation and Maintenance. - Data Extraction, Transformation, and Loading. - Specialized Data Handling. - Database Backup and Recovery. - Security. - Authentication. -...

  • Senior SQL DBA

    3 weeks ago

    Toronto, Canada CB Canada Full time

    Senior SQL DBA On behalf of our client in the Technology Sector, PROCOM is looking for a Senior SQL DBA. Senior SQL DBA – Job Description Ensure system availability 7/24 to critical Enterprise Application database(s) abiding by ITSM policies and procedures for Change, Incident and Problem investigation Installation of Microsoft SQL, Postgres and Oracle...

  • Database Administrator

    4 weeks ago

    Toronto, Canada CGI Full time

    **Responsibilities**: - Create, review, execute Database script as per the request in production and non - production environments. - Database monitoring and enhance database alerting - Troubleshoot any database related issues in production and non-production environments. - Support database automations activities - Security: auditing, role separation -...

  • DBA Evening Coordinator

    3 weeks ago

    Old Toronto, Canada Computer Methods International Corp. Full time

    Computer Methods International Corp. (CMiC) is a Software Development firm specializing in enterprise financial and cost management systems designed for the Construction and Engineering industries.THE OPPORTUNITYAn opening currently exists for a DBA Evening Coordinator. Duties and responsibilities (may include, but are not limited to, the following)Must...

  • DBA Evening Coordinator

    3 weeks ago

    Old Toronto, Canada Computer Methods International Corp. Full time

    Computer Methods International Corp. (CMiC) is a Software Development firm specializing in enterprise financial and cost management systems designed for the Construction and Engineering industries.THE OPPORTUNITYAn opening currently exists for a DBA Evening Coordinator. Duties and responsibilities (may include, but are not limited to, the following)Must...

  • DBA Evening Coordinator

    3 weeks ago

    Old Toronto, Canada Computer Methods International Corp. Full time

    Computer Methods International Corp. (CMiC) is a Software Development firm specializing in enterprise financial and cost management systems designed for the Construction and Engineering industries.THE OPPORTUNITYAn opening currently exists for a DBA Evening Coordinator. Duties and responsibilities (may include, but are not limited to, the following)Must...

  • DBA Evening Coordinator

    5 days ago

    Old Toronto, Canada Computer Methods International Corp. Full time

    Computer Methods International Corp. (CMiC) is a Software Development firm specializing in enterprise financial and cost management systems designed for the Construction and Engineering industries.THE OPPORTUNITYAn opening currently exists for a DBA Evening Coordinator. Duties and responsibilities (may include, but are not limited to, the following)Must...

  • DBA Evening Coordinator

    3 weeks ago

    Toronto, ON, Canada Computer Methods International Corp. Full time

    Computer Methods International Corp. (CMiC) is a Software Development firm specializing in enterprise financial and cost management systems designed for the Construction and Engineering industries. THE OPPORTUNITY An opening currently exists for a DBA Evening Coordinator. Duties and responsibilities (may include, but are not limited to, the following)...

  • Oracle Dba

    4 weeks ago

    Toronto, Canada Covetus Full time

    **Skills and Responsibilities**: - Build/Configure OCAC Exadata DB, ODI, AWR reporting/tuning/optimization of Database, - Deploy code (stored procedures, SQL scripts), - Setup DB traces for Performance Testing to capture various performance metrics, perform database backup/restores). Exadata Oracle Compliance Studio/...

  • Oracle Database Administrator

    4 weeks ago

    Toronto, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Senior** **Database Administrator **for one of our clients. **Position: Senior Database Administrator** **Location: Toronto, Ontario (Hybrid)** **Duration: Long Term Contract** **Must Have** - More than 10 yrs. Oracle DBA experience - Approved experience with Oracle 12c & 19c...

  • Oracle Database Administrator

    4 weeks ago

    Toronto, Canada ydc pro Inc Full time

    Hi All, We are Hiring for Sr. Oracle Database Administrator Position for Toronto Location Work type: Contract and Hybrid Must haves: - More than 10 yrs. Oracle DBA experience - Approved experience with Oracle 12c & 19c using multi-tenant architecture - Oracle 19c RAC - Grid infrastructure/ASM - RMAN backup and Restore - Data Encryption using ASO/TDE -...

  • Oracle DBA

    3 weeks ago

    Toronto, Canada Tata Consultancy Services Full time

    TCS is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity and is reflected in our people stories across our workforce implemented through...

  • Oracle DBA

    3 weeks ago

    Toronto, Canada Tata Consultancy Services Full time

    TCS is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity and is reflected in our people stories across our workforce implemented through...

  • Oracle DBA

    3 weeks ago

    Toronto, Canada Tata Consultancy Services Full time

    TCS is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity and is reflected in our people stories across our workforce implemented through...

  • Database Consultant

    3 weeks ago

    Toronto, ON, Canada REALIGN LLC Full time

    Job Type: Contract Job Category: IT Job Title: Oracle OFSAA Consultant We are seeking a proficient and experienced Oracle OFSAA (Oracle Financial Services Analytical Applications) Consultant to join our dynamic team. As an Oracle OFSAA Consultant, you will be responsible for providing end-to-end solutions, implementation, and support related to Oracle...

  • Oracle DBA

    3 weeks ago

    Toronto, Canada Tata Consultancy Services Full time

    TCS is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity and is reflected in our people stories across our workforce implemented through...

  • Oracle DBA

    3 weeks ago

    Toronto, Canada Tata Consultancy Services Full time

    TCS is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity and is reflected in our people stories across our workforce implemented through...

  • Oracle DBA

    1 day ago

    Toronto, Canada Tata Consultancy Services Full time

    TCS is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity and is reflected in our people stories across our workforce implemented through...

  • Oracle DBA

    4 weeks ago

    Toronto, Canada Tata Consultancy Services Full time

    TCS is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity and is reflected in our people stories across our workforce implemented through...

  • Oracle DBA

    3 weeks ago

    Toronto, Canada Tata Consultancy Services Full time

    TCS is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity and is reflected in our people stories across our workforce implemented through...