PostgreSQL Database Administrator

19 hours ago

Greater Toronto Area, Canada CC Pace Full time
Job Title: PostgreSQL Database Administrator

CC Pace is seeking a highly skilled PostgreSQL Database Administrator to join our team. As a key member of our Database Operations group, you will be responsible for managing, maintaining, and securing our databases in the AWS Cloud.

Key Responsibilities:
  • Install, upgrade, and manage database servers and schemas.
  • Set and maintain enterprise database standards.
  • Manage database access and develop processes for optimizing database security.
  • Performance tuning of database systems particularly RDS/Aurora PostgreSQL and MySQL.
  • Create database backups and restore database from backups.
  • Plan capacity for database servers, diagnose and troubleshoot database errors.
  • Create and manage database reports, visualizations, and dashboards.
  • Write complex PL/SQL, understand complex queries, able to tune complex queries.
  • Automate repeating database tasks and be available for on-call support.
Requirements:
  • Bachelor's degree in computer science or related field and 12+ years of IT industry experience.
  • 10+ experience in database administration roles in MSSQL, MySQL and Amazon Aurora PostgreSQL.
  • Experience with Linux and Windows Server environments.
  • Extensive experience with database technologies (MySQL, MSSQL, PostgreSQL).
  • Experience with AWS cloud services.
  • Solid understanding of RDS cluster, taking snapshot of RDS instance, monitor database performance issues and resolve them, and participate in On-Call rotation as needed.
  • Experience with cloud database infrastructure management and administration.
  • Extensive experience in HA/DR in major enterprise database systems.
  • Experience in SQL Server Reporting Services.
  • Good verbal communication and writing skills.
Preferred Qualifications:
  • AWS certified professional who has experience in RDS, IAM, EC2, VPC and Storage.
  • Experience in troubleshooting performance issues from infrastructure and database engine.
  • Experience working with clients and other department leads within the organization.
  • Expert in writing PL/SQL and PostgreSQL performance tuning and optimization.

CC Pace is an equal opportunity employer and welcomes applications from diverse candidates. We offer a competitive salary and benefits package, as well as opportunities for professional growth and development.

  • PostgreSQL Database Administrator

    1 week ago

    Greater Toronto Area, Canada CC Pace Full time

    Job SummaryWe are seeking a highly skilled PostgreSQL Database Administrator to join our Database Operations team at CC Pace. As a key member of our team, you will be responsible for managing and maintaining our PostgreSQL databases, ensuring they are secure, healthy, and up-to-date to meet our Service Level Agreements (SLAs).Key ResponsibilitiesInstall,...

  • PostgreSQL Database Administrator

    1 week ago

    Greater Toronto Area, Canada CC Pace Full time

    Job SummaryWe are seeking a highly skilled PostgreSQL Database Administrator to join our Database Operations team at CC Pace. As a key member of our team, you will be responsible for managing and maintaining our PostgreSQL databases, ensuring they are secure, healthy, and up-to-date to meet our Service Level Agreements (SLAs).Key ResponsibilitiesInstall,...

  • PostgreSQL Database Administrator

    3 weeks 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

    1 month 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

    1 month 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

    1 month 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 weeks ago

    Greater Toronto Area, Canada, Ontario 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 Architect

    6 days ago

    Greater Toronto Area, Canada CC Pace Full time

    Job Title: PostgreSQL Database AdministratorCC Pace is seeking a highly skilled PostgreSQL Database Administrator to join our team. As a key member of our Database Operations group, you will be responsible for managing, maintaining, and securing our PostgreSQL databases in the AWS Cloud.Key Responsibilities:Design, implement, and manage PostgreSQL database...

  • PostgreSQL Database Architect

    6 days ago

    Greater Toronto Area, Canada CC Pace Full time

    Job Title: PostgreSQL Database AdministratorCC Pace is seeking a highly skilled PostgreSQL Database Administrator to join our team. As a key member of our Database Operations group, you will be responsible for managing, maintaining, and securing our PostgreSQL databases in the AWS Cloud.Key Responsibilities:Design, implement, and manage PostgreSQL database...

  • PostgreSQL Database Architect

    2 days ago

    Greater Toronto Area, Canada CC Pace Full time

    Job Title: PostgreSQL Database AdministratorCC Pace is seeking a highly skilled PostgreSQL Database Administrator to join our team. As a key member of our Database Operations group, you will be responsible for managing, maintaining, and securing our databases in the AWS Cloud.Key Responsibilities:Design, implement, and maintain high-performance PostgreSQL...

  • PostgreSQL Database Architect

    2 days ago

    Greater Toronto Area, Canada CC Pace Full time

    Job Title: PostgreSQL Database AdministratorCC Pace is seeking a highly skilled PostgreSQL Database Administrator to join our team. As a key member of our Database Operations group, you will be responsible for managing, maintaining, and securing our databases in the AWS Cloud.Key Responsibilities:Design, implement, and maintain high-performance PostgreSQL...

  • PostgreSQL Database Administrator

    3 weeks ago

    Greater Toronto Area, Canada CC Pace Full time

    Job SummaryCC Pace is seeking a highly skilled PostgreSQL Database Administrator to join our team. As a key member of our Database Operations group, you will be responsible for managing, maintaining, and securing our databases in the AWS Cloud.Key ResponsibilitiesDatabase Server Management: Install, upgrade, and manage database servers and schemas to ensure...

  • PostgreSQL Database Administrator

    3 weeks ago

    Greater Toronto Area, Canada CC Pace Full time

    Job SummaryCC Pace is seeking a highly skilled PostgreSQL Database Administrator to join our team. As a key member of our Database Operations group, you will be responsible for managing, maintaining, and securing our databases in the AWS Cloud.Key ResponsibilitiesDatabase Server Management: Install, upgrade, and manage database servers and schemas to ensure...

  • PostgreSQL Database Administrator

    2 weeks ago

    Toronto, Ontario, Canada CC Pace Full time

    Job SummaryWe are seeking a highly skilled PostgreSQL Database Administrator to join our Database Operations team at CC Pace. As a key member of our team, you will be responsible for managing, maintaining, and securing our databases in the AWS Cloud.Key ResponsibilitiesInstall, upgrade, and manage database servers and schemas.Set and maintain enterprise...

  • PostgreSQL Database Administrator

    2 weeks ago

    Toronto, Ontario, Canada CC Pace Full time

    Job SummaryWe are seeking a highly skilled PostgreSQL Database Administrator to join our Database Operations team at CC Pace. As a key member of our team, you will be responsible for managing, maintaining, and securing our databases in the AWS Cloud.Key ResponsibilitiesInstall, upgrade, and manage database servers and schemas.Set and maintain enterprise...

  • PostgreSQL Database Administrator

    2 weeks ago

    Toronto, Ontario, Canada Royal Bank of Canada Full time

    Job SummaryWe are seeking a highly skilled PostgreSQL Database Administrator to join our Data and Analytics team at Royal Bank of Canada. As a key member of our team, you will be responsible for overseeing the creation and maintenance of database and transaction processing environments for application testing, pre-production verification, and production...

  • PostgreSQL Database Administrator

    2 weeks ago

    Toronto, Ontario, Canada Royal Bank of Canada Full time

    Job SummaryWe are seeking a highly skilled PostgreSQL Database Administrator to join our Data and Analytics team at Royal Bank of Canada. As a key member of our team, you will be responsible for overseeing the creation and maintenance of database and transaction processing environments for application testing, pre-production verification, and production...

  • PostgreSQL Database Specialist

    3 weeks ago

    Toronto, Ontario, Canada Royal Bank of Canada Full time

    Job SummaryWe are seeking a highly skilled PostgreSQL Database Administrator to join our team at the Royal Bank of Canada. As a key member of our Data and Analytics team, you will be responsible for overseeing the creation and maintenance of database and transaction processing environments for application testing, pre-production verification, and production...

  • PostgreSQL Database Specialist

    3 weeks ago

    Toronto, Ontario, Canada Royal Bank of Canada Full time

    Job SummaryWe are seeking a highly skilled PostgreSQL Database Administrator to join our team at the Royal Bank of Canada. As a key member of our Data and Analytics team, you will be responsible for overseeing the creation and maintenance of database and transaction processing environments for application testing, pre-production verification, and production...

  • Database Administrator

    4 months ago

    Toronto, Canada Compest Solutions Inc Full time

    **Job title**: Database Administrator **Location**:Toronto, ON (On-site) **Max Rate CAD$39/hr on T4** **Job summary** **Required Skills**: **1.SQL DBA Administration** **2.PostgreSQL DB Administration** **3. Mongo DB Administration** Experience: 10 Years - Experience in Database Administration in **SQL Server (2012,2014, 2016, 2017)**: - Experience in...