Database Administrator

2 weeks ago

Saskatchewan, Canada AMTRA Solutions Full time

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.

  • Database Analyst

    3 weeks ago

    Fort Saskatchewan, Canada Lacsay Solutions Inc. Full time

    Work Term: Permanent - Work Language: English - Hours: 32 to 40 hours per week - Education: Bachelor's degree - 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...

  • Sybase DB Administrator

    4 days ago

    Regina, Saskatchewan, Saskatchewan, Canada TEEMA Full time

    Title: Sybase DB Administrator x 4 Duration: 6 months (potential for extension)Start Date: ASAP The Sybase Administrators 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...

  • Onboarding Administrator

    7 days ago

    Fort Saskatchewan, Canada Golderado Contracting Corp Full time

    **Onboarding Administrator** At Golderado, we're constantly pushing the limits of what we've done in the past - propelling ourselves toward bigger and better opportunities, while exploring new market sectors and services. So, it only seems natural that we'd hire people who have their own voice and aren't afraid to use it. These are people who are...

  • Administrative Assistant

    3 weeks ago

    Fort Saskatchewan, Canada Golderado Contracting Corp Full time

    **Administrative Assistant** At Golderado, we're constantly pushing the limits of what we've done in the past - propelling ourselves toward bigger and better opportunities, while exploring new market sectors and services. So, it only seems natural that we'd hire people who have their own voice and aren't afraid to use it. These are people who are...

  • Administrative Assistant

    3 days ago

    Fort Saskatchewan, Canada Golderado Contracting Corp Full time

    **Administrative Assistant** At Golderado, we're constantly pushing the limits of what we've done in the past - propelling ourselves toward bigger and better opportunities, while exploring new market sectors and services. So, it only seems natural that we'd hire people who have their own voice and aren't afraid to use it. These are people who are...

  • Administrative Assistant Estimating

    4 weeks ago

    Fort Saskatchewan, Canada Golderado Contracting Corp Full time

    **Administrative Assistant Estimating** At Golderado, we're constantly pushing the limits of what we've done in the past - propelling ourselves toward bigger and better opportunities, while exploring new market sectors and services. So, it only seems natural that we'd hire people who have their own voice and aren't afraid to use it. These are people who are...

  • Administrative Assistant Estimating

    7 days ago

    Fort Saskatchewan, Canada Golderado Contracting Corp Full time

    **Administrative Assistant Estimating** At Golderado, we're constantly pushing the limits of what we've done in the past - propelling ourselves toward bigger and better opportunities, while exploring new market sectors and services. So, it only seems natural that we'd hire people who have their own voice and aren't afraid to use it. These are people who are...

  • Data Entry Administrator

    7 days ago

    Fort Saskatchewan, Canada Golderado Contracting Corp Full time

    **Data Entry Administrator** At Golderado, we're constantly pushing the limits of what we've done in the past - propelling ourselves toward bigger and better opportunities, while exploring new market sectors and services. So, it only seems natural that we'd hire people who have their own voice and aren't afraid to use it. These are people who are...

  • Administrative Assistant

    3 weeks ago

    Fort Saskatchewan, Canada Golderado Contracting Corp Full time

    Administrative AssistantAt Golderado, we're constantly pushing the limits of what we've done in the past - propelling ourselves toward bigger and better opportunities, while exploring new market sectors and services. So, it only seems natural that we'd hire people who have their own voice and aren't afraid to use it. These are people who are simultaneously...

  • Data Entry Administrator

    1 week ago

    Fort Saskatchewan, Alberta, Canada Golderado Contracting Corp Full time

    Data Entry AdministratorAt Golderado, we're constantly pushing the limits of what we've done in the past - propelling ourselves toward bigger and better opportunities, while exploring new market sectors and services. So, it only seems natural that we'd hire people who have their own voice and aren't afraid to use it. These are people who are simultaneously...

  • Data Entry Administrator

    2 weeks ago

    Fort Saskatchewan, Canada Golderado Contracting Corp Full time

    Data Entry AdministratorAt Golderado, we're constantly pushing the limits of what we've done in the past - propelling ourselves toward bigger and better opportunities, while exploring new market sectors and services. So, it only seems natural that we'd hire people who have their own voice and aren't afraid to use it. These are people who are simultaneously...

  • Payroll Administrator

    4 days ago

    Fort Saskatchewan, Canada Golderado Contracting Corp Full time

    **Payroll Administrator** At PME, we're constantly pushing the limits of what we've done in the past - propelling ourselves toward bigger and better opportunities, while exploring new market sectors and services. So, it only seems natural that we'd hire people who have their own voice and aren't afraid to use it. These are people who are simultaneously...

  • Payroll Administrator

    3 weeks ago

    Fort Saskatchewan, Canada Golderado Contracting Corp Full time

    **Payroll Administrator** At Golderado, we're constantly pushing the limits of what we've done in the past - propelling ourselves toward bigger and better opportunities, while exploring new market sectors and services. So, it only seems natural that we'd hire people who have their own voice and aren't afraid to use it. These are people who are...

  • Payroll Administrator

    4 weeks ago

    Fort Saskatchewan, Canada Golderado Contracting Corp Full time

    **Payroll Administrator** At Golderado, we're constantly pushing the limits of what we've done in the past - propelling ourselves toward bigger and better opportunities, while exploring new market sectors and services. So, it only seems natural that we'd hire people who have their own voice and aren't afraid to use it. These are people who are...

  • Recruitment Administrator

    3 days ago

    Fort Saskatchewan, Canada Golderado Contracting Corp Full time

    **Recruitment Administrator - Summer Student** At Golderado, we're constantly pushing the limits of what we've done in the past - propelling ourselves toward bigger and better opportunities, while exploring new market sectors and services. So, it only seems natural that we'd hire people who have their own voice and aren't afraid to use it. These are people...

  • Payroll Administrator

    3 weeks ago

    Fort Saskatchewan, Canada Golderado Contracting Corp Full time

    Payroll AdministratorAt Golderado, we're constantly pushing the limits of what we've done in the past - propelling ourselves toward bigger and better opportunities, while exploring new market sectors and services. So, it only seems natural that we'd hire people who have their own voice and aren't afraid to use it. These are people who are simultaneously...

  • Administrative Assistant

    3 days ago

    Fort Saskatchewan, Canada Heartland Housing Foundation Full time

    **Company Background** Operating 11 facilities including seniors’ lodges, apartment buildings, and an affordable family housing complex, Heartland Housing Foundation is known as a strong, collaborative organization and a leader in the social fabric of the region. At Heartland Housing Foundation we are committed to our culture of service and excellence as...

  • Research Officer

    4 weeks ago

    Saskatchewan, Canada Saskatchewan Polytechnic Full time

    **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/2023**Closing Date** - 04/04/2023**JIQ #** - 50010**Start Date** - 05/01/2023**End Date** -...

  • Executive Assistant

    7 days ago

    Fort Saskatchewan, Canada Golderado Contracting Corp Full time

    **Executive Assistant** At Golderado, we're constantly pushing the limits of what we've done in the past - propelling ourselves toward bigger and better opportunities, while exploring new market sectors and services. So, it only seems natural that we'd hire people who have their own voice and aren't afraid to use it. These are people who are simultaneously...

  • Project Hse Advisor

    4 weeks ago

    Fort Saskatchewan, Canada CAM Industrial Solutions LLC Full time

    Provide field and administrative Health, Safety, and Environmental support to the site maintenance, small projects and to CAM’ leadership. The split between field and administrative support should be approximately 70% field & 30% administrative. **Field Responsibilities**: - Demand and promote CAM CORE attitude from all employees - Attend Start of Shift...