Database Administrator

4 weeks ago


Calgary Alberta DJ, CA Princeton IT Services, Inc Full time

Position Title: Senior Database Administrator

Location: Calgary, Canada/remote

Job Type: Contract

Job Summary
We are seeking a skilled and experienced Database Administrator to work on a data migration project. The successful candidate will have a strong background in database administration, particularly with MySQL and Redshift databases, and extensive experience with data migration, consolidation, and optimization processes. This role requires meticulous attention to detail, strong problem-solving skills, and the ability to collaborate effectively with cross-functional teams.

Candidate Requirements

  • Hands-on experience with AWS MySQL Aurora 5.7 or above, including 24x7 production support and on-call troubleshooting.
  • Experience with database migrations and agile development methodology.
  • Self-motivated, able to work independently, and collaborate effectively with developers during software deployments and data migrations.
  • Excellent written and verbal communication skills for a collaborative, cross-functional environment.

Minimum Skills And Experience

  • Bachelor of Science degree in Computer Science or equivalent.
  • 8+ years as a MySQL, Redshift DBA, with expertise in design, implementation, backup, recovery, monitoring, and performance tuning.
  • Strong understanding of database consolidation techniques and best practices.
  • Experience with data migration tools and techniques, such as AWS Database Migration Service (DMS) or similar.
  • Proficiency in SQL and database performance tuning.
  • Develop a comprehensive strategy for merging the two databases into a single Aurora MySQL database while minimizing downtime and ensuring data integrity.
  • Experience with 24x7 support, troubleshooting, and managing databases in cloud environments (AWS).
  • Experience with cloud-based services (AWS Cloudwatch, DataDog, Percona Monitoring Management PMM).
  • Expertise in high-availability database features, replication, disaster recovery, and live production schema changes.
  • Proficiency with cloud-specific technologies (S3, Route 53, CloudFormation), version control tools (GitHub), and database life-cycle management.
  • Knowledge of database security, backup retention policies, and scaling databases.
  • Experience with managing the full life cycle of database schema design and implementation, which includes script management from development through production releases.
  • Experience implementing database schema changes in a live production environment requiring minimal downtime and zero performance impact.
#J-18808-Ljbffr
  • database developer

    3 weeks ago


    Calgary, Alberta, D3J, CA Western Heritage Services Inc. Full time

    Education:Bachelor's degreeor equivalent experienceTasksCollect data to identify areas for improvement within an organization's IT infrastructureDevelop and implement a strategic blueprint to follow when deploying databases within their organizationDevelop and maintain computer databasesDocument customers' requirements for projectsEnact measures...

  • Database Manager

    3 weeks ago


    Calgary, Alberta, D3J, CA Meta Cannabis Co. Full time

    We are looking for an experienced Database Manager to oversee the Product Team and manage databases of product entries across various POS/ERP systems within our organization. Reporting directly to the Senior Director of Procurement, the Database Manager will be responsible for ensuring efficient database and product management for multiple business units...

  • System Administrator

    1 month ago


    Calgary, Alberta, D3J, CA Dehavilland Full time

    Posted Friday, August 2, 2024 at 6:00 AM | Expires Monday, August 19, 2024 at 5:59 AMDe Havilland Aircraft of Canada Ltd. (‘DHC’) is a proudly Canadian aerospace company currently transitioning its corporate headquarters to Calgary, AB. DHC is undertaking a consolidation of its underlying subsidiary companies under a single brand currently offering...

  • Office Administrator

    1 month ago


    Calgary, Alberta, D3J, CA Forge Performance Group Full time

    Forge Performance Group is a Recruitment & Talent Management solutions team located in Calgary, AB. We are dedicated to connecting our clients with highly skilled professionals well-matched to their unique hiring needs, culture, and goals. This opportunity is posted on behalf of one of our clients, an Engineering firm located in North Calgary Industrial....


  • Calgary, Alberta, D3J, CA Accoravillage Full time

    MaKami College is seeking a dedicated individual to join our team at the Marlborough Mall Campus in Calgary, Alberta, Canada. As a public post-secondary institution, MaKami College has been a cornerstone in student education for over 20 years, offering a variety of programs both in-person and online. We are committed to growth and expansion, with a focus on...


  • Calgary, Alberta, D3J, CA About Staffing Full time

    Connecting you to Human Resources jobs in Calgary! About Staffing is an Alberta-based recruitment company that connects jobseekers to employers across Canada. Established in [Year], About Staffing is a BBB Accredited Business and a proud member of the Calgary Chamber of Commerce. Our wonderful not-for-profit client, located in NE Calgary, is excited to add a...


  • Calgary, Alberta, D3J, CA WHOLESALE WAREHOUSE LTD. Full time

    Job Description Work Term: Permanent Work Language: French Hours: 40 hours per week Education: Secondary (high) school graduation certificate Experience: 1 year to less than 2 years Work Setting Retail/wholesale establishment/distribution centre Tasks Coordinate the activities of the HR department in order to ensure they meet the organization's...


  • Calgary, Alberta, D3J, CA Accoravillage Full time

    Strategic Group owns and develops office, retail, and residential properties across Canada. Beyond real estate, we own businesses in construction, building services, oilfield services, hospitality, pet care, agriculture, technology, and corporate finance.Strategic Group is seeking a Residential Property Administrator to join our Property Management team in...


  • Calgary, Alberta, D3J, CA Canadian Pacific Railway Full time

    Our Canadian defined benefit and defined contribution pension plans and US retirement plans provide important financial security for employees and beneficiaries, which is a key factor in attracting and retaining talented railroaders at CPKC. As an administrator of several retirement plans, we must ensure data accuracy in HR and pension database. Areas of...


  • Calgary, Alberta, D3J, CA Vista Projects Limited Full time

    Thanks for your interest in working with Vista Projects. For more than 30 years, the success of our company has hinged on the quality of our people. That's why we go to great lengths to ensure we're hiring talented individuals to join our team and candidate testing is a big part of our process.Candidate TestingWe have found a direct correlation...


  • Calgary, Alberta, D3J, CA Canadian Pacific Railway Full time

    Our Canadian defined benefit and defined contribution pension plans and US retirement plans provide important financial security for employees and beneficiaries, which is a key factor in attracting and retaining talented railroaders at CPKC. As an administrator of several retirement plans, we must ensure data accuracy in HR and pension database. Areas of...


  • Calgary, Alberta, D3J, CA Dehavilland Full time

    Posted Friday, August 16, 2024 at 6:00 AM | Expires Saturday, September 7, 2024 at 5:59 AMDe Havilland Aircraft of Canada Ltd. (‘DHC’) is a proudly Canadian aerospace company currently transitioning its corporate headquarters to Calgary, AB. DHC is undertaking a consolidation of its underlying subsidiary companies under a single brand currently offering...


  • Calgary, Alberta, D3J, CA Scotiabank Full time

    Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.Purpose of Job:To work closely with the Relationship Managers in the management of the overall book of business by providing effective and efficient client service and in the execution of business development related activities. The role is a dedicated...

  • Business Analyst

    1 month ago


    Calgary, Alberta, D3J, CA Tykans Group Inc Full time

    Act as a central point of contact for business requirements, analysis, and documentation on projects. Collect customer requirements, document all details, recommend options to customers based on prior analysis and assist in making decisions, apply corrections if needed. Balance your workload in an environment with competing work priorities Responsible...

  • Office Manager

    4 weeks ago


    Calgary, Alberta, D3J, CA Gilder Search Group Full time

    Our client, a dynamic and entrepreneurial consulting company dedicated to driving innovation and providing high-quality services to the Oil and Gas Industry, is seeking a highly skilled Office Manager/Administrative Assistant to join their team. As they continue to expand and take on new challenges, this role is essential in contributing to their success.As...

  • High School

    4 weeks ago


    Calgary, Alberta, D3J, CA Almadina School Society Full time

    The High School Office Manager will manage the full range of administrative support to school Administrators, ensuring continuity is maintained between staff, pupils, parents, professionals, volunteers, visitors, and all stakeholders. Under the direction of the Principal and Vice Principal, the successful candidate will be responsible for managing processes...


  • Calgary, Alberta, D3J, CA Waste Connections of Canada Full time

    R360 Canada, an affiliate of Waste Connections, offers a variety of services to clients in the energy, environmental and industrial sectors. These services are delivered via our network of facilities, along with our specialized equipment and assets. We are equipped to process, recover, recycle and dispose of waste and other materials safely and...

  • Farm Soil Sampler

    4 weeks ago


    Calgary, Alberta, D3J, CA Farmers Edge Inc Full time

    Farmers Edge is a global leader in agriculture technology! Our mission is to create the world's most comprehensive digital platform to empower and connect stakeholders across the ecosystem. We're passionate about sustainable farming and put innovation at the forefront of everything we do. Together, we're leading the next agricultural revolution...


  • Calgary, Alberta, D3J, CA Accoravillage Full time

    10201 Southport Rd SW, Calgary, AB T2W 4X9, Canada Req #37Thursday, August 1, 2024Welcome to Rejuvenation!Rejuvenation Medical Group is Western Canada’s fastest-growing family of dermatology and multi-disciplinary medical offices. We specialize in skin health, dermatologic concerns, and an array of cosmetic and aesthetic services for all skin...


  • Calgary, Alberta, D3J, CA sait.ca Full time

    SAIT's School for Advanced Digital Technology (SADT) is committed to preparing our students to thrive in the borderless, global economy. We offer an exciting range of media and technology programs built on a foundation of applied, technology-immersed experiences and enhanced with work-integrated learning opportunities.The OpportunityThe School for...