Jobs

    Database Administrator - Saskatchewan, Canada - AMTRA Solutions

    AMTRA Solutions
    AMTRA Solutions Saskatchewan, Canada

    1 week ago

    Default job background
    Insurance
    Description

    Our Saskatchewan-based partner requires the support of 4 Sybase Administrators who will provide Sybase database support services including configuring and responding to system and performance alerts 24x7, routine maintenance such as patching, and actioning database-related service requests across production and non-production environments.

    These Sybase Administrators will collaborate with the Database Platform Administrators, System Administrators, and Application Support teams as required to maintain system availability targets.

    Key Responsibilities:

    Monitoring and Alerting Setup:

    • Set up monitoring and alerting systems for Sybase ASE 16 SP4, Replication Server 16 SP3, and SAP IQ 16.1 on both Oracle Solaris SPARC and Linux servers.
    • Configure alerts for critical system metrics such as CPU utilization, memory usage, disk space, and replication lag.

    Patch Management:

    • Develop and implement a patch management strategy for keeping Sybase ASE, Replication Server, and SAP IQ up-to-date with the latest service packs and patches.
    • Schedule regular maintenance windows for applying patches while minimizing downtime for critical business applications.

    Performance Tuning:

    • Conduct regular performance-tuning exercises to optimize the performance of database servers.
    • Identify and address performance bottlenecks by analyzing query execution plans, index usage, and system resource utilization.

    Backup and Recovery Management:

    • Implement and maintain backup and recovery procedures for all production databases.
    • Perform regular backups and validate the integrity of backup files to ensure data recoverability in case of disasters.

    High Availability and Disaster Recovery (HA/DR) Testing:

    • Plan and execute periodic HA/DR testing to validate the failover and recovery capabilities of the systems.
    • Document test results and identify areas for improvement in the HA/DR setup.

    Incident Response and Resolution:

    • Establish a 24x7 on-call rotation for responding to production-affecting incidents.
    • Develop runbooks and escalation procedures for efficiently resolving incidents and minimizing impact on business operations.

    Capacity Planning:

    • Monitor database growth trends and forecast future capacity requirements.
    • Work with infrastructure teams to procure additional hardware resources as needed to accommodate growth.

    Documentation and Knowledge Sharing:

    • Maintain up-to-date documentation for all systems, including configuration settings, troubleshooting procedures, and disaster recovery plans.
    • Conduct regular knowledge-sharing sessions to disseminate best practices and lessons learned among team members.

    Security Compliance:

    • Ensure that database servers comply with relevant security standards and regulations.
    • Implement access controls, encryption, and auditing mechanisms to protect sensitive data from unauthorized access or disclosure.

    Vendor Support Coordination:

    • Engage with vendors for technical support and assistance with troubleshooting complex issues.
    • Keep abreast of new product features and enhancements through vendor communications and forums.

    Work Arrangements: This role can be done completely remotely and will need to support core CST working hours. Additionally, there will be a 24/7 rotational support schedule.

    Contract Employee Rate: $60-$80/hr.


  • Saskatchewan Polytechnic

    Research Officer

    19 hours ago


    Saskatchewan Polytechnic Saskatchewan, Canada

    **Competition Number** · - P13771**Posting Title** · - Research Officer**Classification** · - Band 9**Location** · - Saskatchewan Polytechnic Administrative Offices**Other Location(s)** · **Building** · - Saskatoon Campus, 4th Ave.**Other Building** · **Date Posted** · - 03/24/20 ...


  • eHealth Saskatchewan Saskatchewan, Canada

    **Who is eHealth Saskatchewan?** · eHealth Saskatchewan is a Treasury Board Crown Corporation with a unique blend of healthcare, information technology, and citizen services. Our vision is "Connected healthcare, accessible to everyone, everywhere" with a mission to "Collaborate t ...

  • eHealth Saskatchewan

    Information Analyst

    1 week ago


    eHealth Saskatchewan Saskatchewan, Canada

    **Who is eHealth Saskatchewan?** · eHealth Saskatchewan is a Treasury Board Crown Corporation with a unique blend of healthcare, information technology, and citizen services. Our vision is "Connected healthcare, accessible to everyone, everywhere" with a mission to "Collaborate t ...

  • SWEP

    Lean Coordinator

    1 week ago


    SWEP Saskatchewan, Canada

    At SWEP, we believe our future rest on give more energy than we take - to our planet and to our people. · As the world ́s leading supplier of efficient heat transfer technology, we are driving the conversion to sustainable energy usage in heat transfer. We are dedicated to consta ...


  • eHealth Saskatchewan Saskatchewan, Canada

    **Who is eHealth Saskatchewan?** · eHealth Saskatchewan is a Treasury Board Crown Corporation with a unique blend of healthcare, information technology, and citizen services. Our vision is "Connected healthcare, accessible to everyone, everywhere" with a mission to "Collaborate t ...

  • Saskatchewan Polytechnic

    Technical Writer

    1 week ago


    Saskatchewan Polytechnic Saskatchewan, Canada

    **Competition Number** · - P13224**Posting Title** · - Technical Writer / Technology Adoption Coordinator**Classification** · - Band 9**Location** · - Multiple Locations (Please check posting details)**Other Location(s)** · - Saskatchewan Polytechnic Saskatoon Campus, Saskatchewa ...

  • PrecisionIT Incorporated

    Sybase Administrator

    2 weeks ago


    PrecisionIT Incorporated Saskatchewan, Canada

    PrecisionIT is seeking Sybase Administrators for 6+ month, remote contract opportunities with our client in Saskatchewan. · Duties: · The Sybase Administrators will provide Sybase database support services including configuring and responding to system and performance alerts 24x7 ...


  • Sunnybrook Welding & Machine Shop Ltd. Saskatchewan, Canada

    We are looking for a skilled salesperson to join our team (can be located anywhere within your sales territory). We prefer an individual seeking a long-term career and loves being part of a team. We are looking for an ambitious, motivated, self-driven salesperson with at least fi ...


  • ClientSolv Technologies Saskatchewan, Canada

    ClientSolv Technologies is an IT solution firm with over a decade of experience serving Fortune 1000 companies, public sector and small to medium sized companies. ClientSolv Technologies is a woman-owned and operated company that is certified as a WMBE, 8a firm by the Federal gov ...

  • Iron Systems

    Sybase Database Admin

    14 hours ago


    Iron Systems Saskatchewan, Canada

    Iron Systems is an innovative, customer-focused provider of custom-built computing infrastructure platforms such as network servers, storage, OEM/ODM appliances & embedded systems. For more than 15 years, customer have trusted us for our innovative problem solving combined with h ...

  • University of Regina

    Executive Assistant

    2 weeks ago


    University of Regina Saskatchewan, Canada

    Executive Assistant · Posting Summary Competition Number A/S Position Title Executive Assistant Faculty/Department Faculty of Kinesiology and Health Studies Unit KHS-Dean's Office Employee Group Out of Scope Collective Agreement Consideration Open to the Public. CUPE 5791 Job Fa ...


  • ClientSolv Technologies Saskatchewan, Canada

    Company Description ClientSolv Technologies is an IT solution firm with over a decade of experience serving Fortune 1000 companies, public sector and small to medium sized companies. ClientSolv Technologies is a woman-owned and operated company that is certified as a WMBE, 8a fi ...

  • University of Regina

    Executive Assistant

    2 weeks ago


    University of Regina Saskatchewan, Canada

    Executive Assistant · Below you will find the details for the position including any supplementary documentation and questions you should review before applying for the opening. To apply for the position, please click the Apply for this Job link/button. If you would like to bo ...


  • Saskatchewan Polytechnic Saskatchewan, Canada Full time

    Job Duties/Qualifications, Skills and Abilities(QSA) · Job Duties Job Duties 1. Select, design, update and construct training aids/materials. · 2. Prepare and deliver lessons, assignments, lectures and demonstrations. · 3. Evaluate students through the use of exams, assignments a ...


  • Saskatchewan Polytechnic Saskatchewan, Canada

    Job Duties/Qualifications, Skills and Abilities(QSA) · Job Duties Job Duties This position will be instructing in areas such as: · • IIS administration and Web development using ASP.NET, C#, and Visual Studio · .NET · • Database administration, structures query language using SQL ...


  • Saskatchewan Polytechnic Saskatchewan, Canada

    Job Duties/Qualifications, Skills and Abilities(QSA) · Job Duties Job Duties Job Duties · 1. Managing incoming phone calls on the 1--- phone line in a professional and courteous manner. · 2. Route phone calls to appropriate Sask Polytechnic divisions/departments. · 3. Tracking an ...

  • Saskatchewan Polytechnic

    Logistics Clerk

    2 days ago


    Saskatchewan Polytechnic Saskatchewan, Canada Full time

    Job Duties/Qualifications, Skills and Abilities(QSA) · Job Duties Job Duties · • Shipping and receiving the majority of items entering or leaving the campus. · • Banner and computer database research and data entry. Record and filing. · • Pickup and delivery of supplies, interna ...

  • Saskatchewan Polytechnic

    Librarian

    1 week ago


    Saskatchewan Polytechnic Saskatchewan, Canada Full time

    Job Duties/Qualifications, Skills and Abilities(QSA) · Job Duties Job Duties 1. Develop and deliver library-related instruction in various formats to meet the needs of all learners (e.g., research guides, videos, handouts, quizzes etc.) · 2. Collaborate with instructors and instr ...


  • Saskatchewan Polytechnic Saskatchewan, Canada Full time

    Job Duties/Qualifications, Skills and Abilities(QSA) · Job Duties Job Duties The Coordinator of Counselling and Student Health will report directly to the Director, Counselling, Accessibility and Health, within the division of Student Services at Saskatchewan Polytechnic. The pur ...


  • Saskatchewan Polytechnic Saskatchewan, Canada Part time

    Job Duties/Qualifications, Skills and Abilities(QSA) · Job Duties Job Duties 1. Responds to information requests in a professional and service oriented manner and provides appropriate referrals.2. Provides a variety of clerical support functions which may include, but is not limi ...