Aws Aurora/postgres Database Specialist

7 months ago

Toronto, Canada AstraNorth Full time

The AWS Aurora/Postgres Database Specialist with expertise will set up, maintain and monitor Aurora/Postgres database or other database systems, as required.

**Knowledge & Skills**
- 5+ years of experience in managing and maintain Aurora/Postgres databases on AWS
- 5+ years of experience implementing and managing backups, restoration, replications, and snapshots
- 10+ years hands of experience with SQL Server database administration
- Hands-on experience with database troubleshooting
- Proficient in creating technical documentations and providing knowledge transfer
- Experience in Agile product development in Scrum or Kanban would be an asset
- AWS certification(s) such as AWS Certified Database - Specialty would be an asset
- 5+ years of experience in managing and maintain Aurora/Postgres databases on AWS
- 5+ years of experience implementing and managing backups, restoration, replications, and snapshots
- 10+ years hands of experience with SQL Server and/or Azure Synapse database administration
- Hands-on experience with database troubleshooting
- Excellent communication and interpersonal skills

**Resource Responsibilities**

Ensure smooth and continuous operation of new and existing database performance and availability of the WSIB’s database systems through:

- Manage and maintain Aurora/Postgres databases on AWS.
- Optimize database performance through configuration tuning, index optimization, and query optimization.
- Implement and manage database backups, replication, and disaster recovery strategies.
- Monitor database health and performance metrics, proactively identifying and resolving issues.
- Collaborate with development and operations teams to design and implement database solutions that meet performance and scalability requirements.
- Stay updated on AWS database technologies and best practices, recommending and implementing improvements as necessary.
- Automate repetitive tasks and processes to improve efficiency and reliability.
- Provide technical guidance and support junior members of the team.

2. Identify opportunities for improving service delivery methods and procedures; review with appropriate management staff and implement improvements; work with ITC and business users to maintain, revise or improve the overall reliability, availability and serviceability of the database systems and IT operations by:

- Monitoring, considering risk and tuning databases to ensure optimal function in order to maintain the highest degree of database performance.
- Investigating cost saving opportunities, conducting research to refine, tune, modify and adjust different database technology products.
- Assessing current database architecture setup and developing strategies to optimize database capacity and performance.

3. Create and maintain libraries of all database documentation for past and current projects. This includes database standards, policies and Problem Log Knowledge base with detailed problem description, resolution and root cause for incident tickets and service requests, user procedures manuals, technical references, standards and guides.

4. Perform other related duties as assigned or required.

**Job Types**: Full-time, Fixed term contract

Schedule:

- 8 hour shift
- Monday to Friday

Ability to commute/relocate:

- Toronto, ON: reliably commute or plan to relocate before starting work (preferred)

Work Location: Hybrid remote in Toronto, ON

  • Postgres Database Architect

    3 weeks ago

    Toronto, Canada LanceSoft, Inc. Full time

    LanceSoft, Inc. is seeking a highly skilled Postgres Database Architect to join our team.**Job Summary:**We are looking for an experienced Postgres DBA to work in a team of Database engineers providing technical expertise in designing, managing, and administering Databases in Cloud (AWS & Azure) and on-premises.About the Role:As a Postgres Database...

  • Postgres Database Administrator in Cloud Infrastructure

    4 days ago

    Toronto, Ontario, Canada LanceSoft, Inc. Full time

    About LanceSoft, Inc.LanceSoft, Inc. is a leading provider of innovative technology solutions. We are seeking an experienced Postgres Database Administrator to join our team and contribute to the design, management, and administration of databases in cloud infrastructure (AWS & Azure) and on-premises.Job Description:We are looking for a highly skilled...

  • Postgres DBA

    4 days ago

    Toronto, Canada LanceSoft, Inc. Full time

    Duration: Jan 2025 to Dec 2025 Hours: 37.5 hours (8 30 AM to 5 PM EST) What You’ll Do You will work in team of Database engineers, providing technical expertise in designing, managing, and administering Databases in Cloud (AWS & Azure) and on-premises to meet business operations demands. You will engage in modernization activities to migrate application...

  • Postgres DBA

    5 days ago

    Toronto, Canada LanceSoft, Inc. Full time

    Duration: Jan 2025 to Dec 2025Hours: 37.5 hours (8 30 AM to 5 PM EST)What You’ll Do You will work in team of Database engineers, providing technical expertise in designing, managing, and administering Databases in Cloud (AWS & Azure) and on-premises to meet business operations demands. You will engage in modernization activities to migrate application...

  • Postgres DBA

    1 month ago

    Toronto, Canada LanceSoft, Inc. Full time

    Duration: Jan 2025 to Dec 2025Hours: 37.5 hours (8 30 AM to 5 PM EST)What You’ll Do You will work in team of Database engineers, providing technical expertise in designing, managing, and administering Databases in Cloud (AWS & Azure) and on-premises to meet business operations demands. You will engage in modernization activities to migrate application...

  • Postgres DBA

    4 weeks ago

    Toronto, Ontario, Ontario, Canada LanceSoft, Inc. Full time

    Duration: Jan 2025 to Dec 2025Hours: 37.5 hours (8 30 AM to 5 PM EST)What You’ll Do You will work in team of Database engineers, providing technical expertise in designing, managing, and administering Databases in Cloud (AWS & Azure) and on-premises to meet business operations demands. You will engage in modernization activities to migrate application...

  • Postgres DBA

    4 weeks ago

    Toronto, Canada LanceSoft, Inc. Full time

    LanceSoft, Inc. is seeking an experienced Postgres DBA to join our team of database engineers in a full-time capacity.We offer a competitive salary for this role, estimated at $145,000 per year, based on industry standards and the required skills.Job Description:We are looking for a skilled Postgres DBA to provide technical expertise in designing, managing,...

  • Aws Database Specialist

    6 months ago

    Toronto, Canada AstraNorth Full time

    We are looking for a skilled AWS Database Specialist to join our team. You will be responsible for designing, implementing, and managing database solutions on Amazon Web Services. You will work closely with our development, architecture, and operations teams to ensure the availability, performance, and security of our database systems. **Requirements**: -...

  • Cloud Database Engineer

    4 weeks ago

    Toronto, Canada LanceSoft, Inc. Full time

    Job SummaryWe are seeking a highly skilled Cloud Database Engineer to join our team at LanceSoft, Inc.About the RoleThis is a full-time position responsible for designing, managing, and administering databases in cloud (AWS & Azure) and on-premises environments. The ideal candidate will have experience with PostgreSQL database administration on AWS/Azure...

  • Aws Rds Dba

    6 months ago

    Toronto, Canada AstraNorth Full time

    5+ years of hands on DBA experience with Postgres, MongoDB, Db2LUW, SQL server and/or Oracle. - 1+ year hands on DBA experience with AWS RDS, Redshift, DynamoDB, Neptune, DocumentDB - Sound knowledge of DevSecOps and database automation and scripting (e.g. AWS CDK, Github Action, Ansible, shell scripting, python, SQL) - Support RDS single instance or Aurora...

  • Database Administrator @ Toronto, On

    7 months ago

    Toronto, Canada Atlantis IT group Full time

    **Role - Database Administrator** **Location - Toronto, ON - Canada** **Duration - Long Term** 1. Ensure smooth and continuous operation of new and existing database performance and availability of the WSIB's database systems through: Manage and maintain Aurora/Postgres databases on AWS. Optimize database performance through configuration tuning, index...

  • Cloud Database Architect

    2 weeks ago

    Toronto, Canada LanceSoft, Inc. Full time

    Job DescriptionWe are seeking a highly skilled Cloud Database Architect to join our team at LanceSoft, Inc.Estimated Salary: $120,000 per year, based on industry standards and the job requirements.Job OverviewLanceSoft, Inc. is a dynamic company that requires innovative solutions to meet its growing needs. As a Cloud Database Architect, you will be...

  • Postgres Dba

    3 months ago

    Toronto, Canada Capgemini Full time

    **Key Responsibilities**: - Serve as a PostgreSQL DBRE with specialized expertise in **Aurora PostgreSQL**. - Oversee **database design**, implementation, and ongoing maintenance in **high-availability environments**. - Perform **query optimization**, **performance tuning**, and troubleshoot issues to ensure **reliable database performance**. - Implement...

  • Lead Database Administrator

    4 months ago

    Toronto, Canada Broadridge Full time

    At Broadridge, we've built a culture where the highest goal is to empower others to accomplish more. If you’re passionate about developing your career, while helping others along the way, come join the Broadridge team. At Broadridge, we've built a culture where the highest goal is to empower others to accomplish more. If you’re passionate about...

  • Database Administrator

    7 months ago

    Toronto, Canada TD Bank Full time

    **Database Administrator (Postgres/Oracle)**: - 423698BR **Job Category - Primary** - Technology Solutions **Work Location** - 310-320 Front Street West Corporate **Employment Type** - Regular **City** - Toronto **Time Type** - Full Time **Province/State** - Ontario **Hours** - 37.5 **Workplace Model** - Hybrid **Pay Details** **Department...

  • Cloud Infrastructure Database Specialist

    3 weeks ago

    Old Toronto, Canada Circle Internet Services Inc. Full time

    About the RoleWe are seeking an experienced Cloud Infrastructure Database Specialist to join our team at CircleCI. This role is ideal for someone who is excited to integrate infrastructure engineering principles with database management, contributing to the stability and optimization of our production environments.The successful candidate will have a solid...

  • Aws Rds Dba

    6 months ago

    Toronto, Canada AstraNorth Full time

    **Experience (Years): 6-8** **Essential Skills**: - Amazon Web Service(AWS) Cloud Computing, - Database Administration (DBMS) - AWS RDS DBA, - AWS CDK, - Oracle/postgres/DB2, - CI CD pipeline, - Encryption, - Redshift **Job Types**: Full-time, Fixed term contract Schedule: - 8 hour shift - Monday to Friday Ability to commute/relocate: - Toronto, ON:...

  • Oracle Postgre SQL Dba

    7 days ago

    Toronto, Canada Atlantis IT group Full time

    Hello, Please review the below job description and let me know if you are available. **Oracle Postgre SQL DBA** Toronto **Responsibilities**: Translate Oracle PL/SQL constructs to Postgres PL/pgSQL, i.e., Oracle packages, global temporary files, etc. Postgres performance/tuning analysis be able to tune Postgres PL/SQL code to meet required...

  • PostgreSQL Database Administrator

    4 months ago

    Greater Toronto Area, Canada CC Pace Full time

    Qualified candidates are being considered for openings within the Database Operations group. Candidates should possess a strong background in SQL Server, MySQL and PostgreSQL database management and administration. The individual will partner with product support, and DevOps CSM to keep databases secured, healthy and up to date to meet SLAs. The position is...

  • PostgreSQL Database Administrator

    4 months ago

    Greater Toronto Area, Canada CC Pace Full time

    Qualified candidates are being considered for openings within the Database Operations group. Candidates should possess a strong background in SQL Server, MySQL and PostgreSQL database management and administration. The individual will partner with product support, and DevOps CSM to keep databases secured, healthy and up to date to meet SLAs. The position is...