Database Administrator

2 weeks ago

North York, Canada ThoughtStorm Inc Full time

Must Have:
Expert Database administration experience in

IMS/DB2/PL1/COBOL Assembler

Or

Oracle, Microsoft Azure and PL SQL database, and Synapse database

Database Administrator

Description

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

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

- Participate in the review of project and maintenance release artefacts - Use Case, System Requirement Specification, etc.;
- Prepare and implement database changes according to design;
- Promote database changes through Development, Integration Testing, QA, UAT, Production environments;
- Prepare, install, configure Operating Systems, databases and database patches;
- Maintain, administrate, tune performance of databases, e.g., IMS, DB2, Oracle, Microsoft Azure SQL database and Synapse database;
- Provide database space calculations for the supported database environments;
- Perform reference data administration as required;
- Design and write data loading and/or conversion scripts/stored procedures;
- Maintain and enhance Mainframe to Oracle data replication utilizing Tibco IMS Data Replicator, Oracle stored procedures and GoldenGate;
- Build and test database backup/recovery scripts;
- Build and test database automation scripts;
- Deliver detailed system design documents and any other supporting documentation conforming to Ministry standards;
- Document and resolve any database problems/issues;
Provide effective knowledge transfer to Ministry staff at all stages of this assignment;
**Skill Set Requirements**:

- Expert Database administration experience, e.g., IMS, DB2, Oracle, Microsoft Azure SQL database and Synapse database
- Extensive experience with large-scale database systems development, capacity planning, configuration, maintenance, performance tuning
- Experience with database development, e.g., stored procedure, PL/I, Cobol, Assembler
- Experience with Microsoft Azure technologies, including storage account, file share, Azure key vault, Azure portal, Azure monitoring tools

Experience with IMS/DB2 to Oracle replication

**Skills**:
Experience and Skill Set Requirements

**Database Administration 50%**
- Expert Database administration experience, e.g., IMS, DB2, Oracle, Microsoft Azure SQL database and Synapse database
- Experience with Microsoft Azure technologies, including storage account, file share, Azure key vault, Azure portal, Azure monitoring tools

**Systems Development 30%**
- Extensive experience with large-scale database systems development, capacity planning, configuration, maintenance, performance tuning
- Experience with database development, e.g., stored procedure, PL/I, Cobol, Assembler

**Data Replication 20%**
- Experience with GoldenGate & IMS/DB2 to Oracle replication

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

**Salary**: From $75.00 per hour

Schedule:

- Monday to Friday

Ability to commute/relocate:

- North York, ON: reliably commute or plan to relocate before starting work (required)

Work Location: Hybrid remote in North York, ON

Application deadline: 2023-01-26
Expected start date: 2023-04-03

  • Administrator, Database

    3 weeks ago

    North York, Canada Vertex Financial Consulting Inc. Full time

    Education: Bachelor's degree - Experience: 3 years to less than 5 years **Tasks**: - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration policy, standards and models - Research and document...

  • Database Administrator

    2 months ago

    North York, Canada Ministry of Health Full time

    The Health Services I&IT Cluster, Emergency Health I&IT Solutions & Technology Management Branch is seeking a Database Administrator to provide strategic data resource management. **OPS Commitment to Diversity, Inclusion, Accessibility, and Anti-Racism**: We are committed to build a workforce that reflects the communities we serve and to promote a diverse,...

  • Database Administrator

    3 weeks ago

    North York, Canada Ministry of Children, Community and Social Services Full time

    Make the most of your expertise in data management techniques and technologies! Join the Children, Youth and Social Services I&IT Cluster as a Database Administrator. **Why work for the Ontario Public Service?** The Ontario Public Service (OPS) offers a competitive compensation package. We support career and leadership development, invest in learning...

  • Database Administrator

    2 months ago

    North York, Canada Extend Financial Ltd. Full time

    Durée de l'emploi: Permanent - Langue de travail: Anglais - Heures de travail: 40 hours per week - Education: - Expérience: **Education**: - Bachelor's degree **Work setting**: - Private company, corporation or industry **Tasks**: - Collect data to identify areas for improvement within an organization's IT infrastructure - Develop and implement a...

  • RQ06249 Database Administrator

    4 weeks ago

    North York, Canada Randstad Canada Remote Work Freelance Full time

    This is a contract position for a Database Administrator - Intermediate for our public sector client.Work location: 777 Bay Street, TorontoDuration: Nine Months7.25 hours/dayThis is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional...

  • RQ06249 Database Administrator

    3 weeks ago

    North York, Canada Randstad Canada Remote Work Freelance Full time

    This is a contract position for a Database Administrator - Intermediate for our public sector client.Work location: 777 Bay Street, TorontoDuration: Nine Months7.25 hours/dayThis is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional...

  • Database Analyst

    4 weeks ago

    North York, Canada Ostim Ltd. Full time

    We are seeking a skilled Database Analyst to join our team. Duties: - Develop and maintain computer databases - Document customers requirements for projects - Setup the IT infrastructure to allow applications to access databases - Design and develop the database - Operate database management systems to analyze data - Develop and implement data administration...

  • Database Analyst

    3 weeks ago

    North York, Canada Ostim Ltd. Full time

    We are seeking a skilled Database Analyst to join our team. Duties: - Develop and maintain computer databases - Document customers requirements for projects - Setup the IT infrastructure to allow applications to access databases - Design and develop the database - Operate database management systems to analyze data - Develop and implement data administration...

  • Database Analyst

    3 weeks ago

    North York, Canada Ostim Ltd. Full time

    We are seeking a skilled Database Analyst to join our team. Duties: - Develop and maintain computer databases - Document customers requirements for projects - Setup the IT infrastructure to allow applications to access databases - Design and develop the database - Operate database management systems to analyze data - Develop and implement data administration...

  • Analyst, Database

    4 weeks ago

    North York, Canada OSTIM LTD. Full time

    Education: - Expérience: **Education**: - Bachelor's degree **Work setting**: - Construction - Construction industry **Tasks**: - Develop and maintain computer databases - Document customers' requirements for projects - Design and develop database - Operate database management systems to analyze data - Develop and implement data administration policy,...

  • Analyst, Database

    2 days ago

    North York, Canada OSTIM LTD. Full time

    Education: - Expérience: **Education**: - Bachelor's degree **Work setting**: - Construction - Construction industry **Tasks**: - Develop and maintain computer databases - Document customers' requirements for projects - Design and develop database - Operate database management systems to analyze data - Develop and implement data administration policy,...

  • Database Analyst

    4 weeks ago

    North York, Canada Vyoma Global Inc. Full time

    Work Term: Permanent - Work Language: English - Hours: 32 hours per week - Education: College/CEGEP - Experience: 1 year to less than 2 years - or equivalent experience **Work setting**: - Consulting firm **Tasks**: - Collect data to identify areas for improvement within an organization's IT infrastructure - Data Science - Develop and implement a strategic...

  • Database Analyst

    3 hours ago

    North York, Canada Vyoma Global Inc. Full time

    Work Term: Permanent - Work Language: English - Hours: 32 hours per week - Education: College/CEGEP - Experience: 1 year to less than 2 years - or equivalent experience **Work setting**: - Consulting firm **Tasks**: - Collect data to identify areas for improvement within an organization's IT infrastructure - Data Science - Develop and implement a strategic...

  • Database Analyst

    2 months ago

    North York, Canada Harisan Technology Inc. Full time

    Education: College/CEGEP - Experience: 1 year to less than 2 years **Tasks**: - Collect and document user's requirements - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration policy, standards...

  • Database Analyst

    2 days ago

    North York, Canada Harisan Technology Inc. Full time

    Education: College/CEGEP - Experience: 1 year to less than 2 years **Tasks**: - Collect and document user's requirements - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration policy, standards...

  • Database Analyst

    2 weeks ago

    North York, Canada Harisan Technology Inc. Full time

    Education: College/CEGEP - Experience: 1 year to less than 2 years - Information technology - Computer science **Tasks**: - Collect and document user's requirements - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and...

  • Database Administrator

    2 months ago

    North Vancouver, Canada District of North Vancouver Full time

    **Job Status** - Temporary Full-Time**About Us** - Home to vast parkland and attractions including Grouse Mountain, Lynn Canyon and Capilano Suspension Bridge, the District of North Vancouver is inspired by nature, and enriched by people. Designated one of BC’s Top Employers for five years, the District offers exciting professional development...

  • Analyst, Database

    4 weeks ago

    North York, Canada Ontario Association of Architects Full time

    Work Term: Permanent - Work Language: English - Hours: 35 hours per week - Education: Bachelor's degree - Experience: 3 years to less than 5 years **Work setting**: - Associations and non profit organizations **Tasks**: - Collect and document user's requirements - Data Science - Design and develop database - Design, construct, modify, implement and test...

  • Database Analyst

    3 weeks ago

    North York, Canada SunCan Communications Corporation Full time

    Work Term: Permanent - Work Language: English - Hours: 40 hours per week - Education: Bachelor's degree - Experience: 2 years to less than 3 years **Work setting**: - Consulting firm - Server farm **Tasks**: - Collect and document user's requirements - Data Science - Design and develop database - Design, construct, modify, implement and test data models...

  • Database Analyst

    4 weeks ago

    North York, Canada SunCan Communications Corporation Full time

    Work Term: Permanent - Work Language: English - Hours: 35 hours per week - Education: Bachelor's degree - Experience: 3 years to less than 5 years **Work setting**: - Consulting firm - Information technology (IT) service provider **Tasks**: - Collect data to identify areas for improvement within an organization's IT infrastructure - Develop and maintain...