PostgreSQL Database Administrator

2 months 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 part of the Database Operations group which focuses on managing, maintaining, and securing databases in the AWS Cloud. This position requires an extensive experience with PostgreSQL, MSSQL, MySQL, and experience with AWS Cloud services.


**This is a remote position**


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.
  • Experience as a DBA with AWS Cloud databases MSSQL, Aurora/RDS PostgreSQL and MySQL.
  • Monitor database incidents queue and act based on priority.
  • Implement and deploy database changes in Prod and QA environments.
  • Monitor MSSQL, MySQL, and PostgreSQL database performance issues and resolve them.
  • Interact with other DBA team members, product support team, and DevOps CSM and keep them aware of critical issues at hand.
  • Manage, maintain, and secure RDS Aurora PostgreSQL, MySQL and MSSQL databases.
  • Understand the PL SQL scripts provided in the change and be able to make a call if scripts are not well performant or not correct.
  • Troubleshoot and resolve SSRS issues.
  • Proactive and take ownership of highly visible issues and projects. Establish partnership with other teams and drive projects.
  • Establish database support standards to help in the areas of database support with minimal interruptions.
  • Able to provide database level technical leadership and mentor junior DBAs.


Job 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 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.


Competencies:

Action Oriented, Customer Focus, Technical Skills, Problem Solving, Personal Learning, Experience in either the Banking or Financial Industry is preferred.

  • PostgreSQL Database Specialist

    1 month ago

    Toronto, Ontario, Canada GFT Technologies SE Full time

    GFT Technologies SE is shaping the future of digital business. We are recognized as transformation leaders with a passion for technology and innovation. Our team provides sustainable solutions through IT engineering and technology consulting. We are over 12,000 solution-oriented technology professionals across 20 countries. In Canada, we have offices in...

  • PostgreSQL Database Specialist

    1 month ago

    Toronto, Ontario, Canada GFT Technologies SE Full time

    GFT Technologies SE is shaping the future of digital business. We are recognized as transformation leaders with a passion for technology and innovation. Our team provides sustainable solutions through IT engineering and technology consulting. We are over 12,000 solution-oriented technology professionals across 20 countries. In Canada, we have offices in...

  • PostgreSQL Database Specialist

    2 weeks ago

    Toronto, Ontario, Canada GFT Technologies SE Full time

    GFT Technologies SE is a leading provider of digital business solutions. Our team of experts is shaping the future of technology and innovation.Key ResponsibilitiesDesign, develop, and implement complex database solutions using PostgreSQL.Ensure database programs meet high standards of quality and compliance.Evaluate new technologies and provide technical...

  • PostgreSQL Database Specialist

    2 months ago

    Toronto, Ontario, Canada GFT Technologies SE Full time

    GFT Technologies SE is a leading provider of IT engineering and technology consulting services. We are shaping the future of digital business by delivering sustainable solutions to our clients.As a PostgreSQL Database Specialist at GFT, you will play a key role in designing, developing, and implementing complex database solutions. Your expertise will be...

  • PostgreSQL Database Specialist

    2 months ago

    Toronto, Ontario, Canada GFT Technologies SE Full time

    GFT Technologies SE is a leading provider of IT engineering and technology consulting services. We are shaping the future of digital business by delivering sustainable solutions to our clients.As a PostgreSQL Database Specialist at GFT, you will play a key role in designing, developing, and implementing complex database solutions. Your expertise will be...

  • Database Systems Administrator

    2 months ago

    Toronto, Ontario, Canada Rogers Communications Full time

    About the RoleRogers Communications is seeking a highly skilled Database Administrator to join our Technology team. As a key member of our team, you will be responsible for designing, implementing, and maintaining our database systems to ensure optimal performance and security.Key ResponsibilitiesDatabase Design and Administration: Design and implement...

  • Database Systems Administrator

    2 months ago

    Toronto, Ontario, Canada Rogers Communications Full time

    About the RoleRogers Communications is seeking a highly skilled Database Administrator to join our Technology team. As a key member of our team, you will be responsible for designing, implementing, and maintaining our database systems to ensure optimal performance and security.Key ResponsibilitiesDatabase Design and Administration: Design and implement...

  • Senior Database Administrator

    4 weeks ago

    Toronto, Ontario, Canada insightsoftware Full time

    Job DescriptionAs a Senior Database Administrator at insightsoftware, you will be responsible for designing, implementing, and maintaining a reliable and fault-tolerant database infrastructure to support our growing customer base. This role requires strong hands-on experience with Microsoft SQL 2012+ and Oracle 12+, as well as knowledge of PostgreSQL. You...

  • Oracle Database Administrator

    3 weeks ago

    Old Toronto, Ontario, Canada Tata Consultancy Services Full time

    About Tata Consultancy ServicesTata Consultancy Services is a leading IT services, consulting, and business solutions organization that has been partnering with numerous global businesses in their transformation journeys for over five decades. Our consulting-led, cognitive-powered portfolio of business, technology, and engineering services and solutions is...

  • Oracle Database Administrator

    4 weeks ago

    Old Toronto, Ontario, Canada Tata Consultancy Services Full time

    About Tata Consultancy ServicesTata Consultancy Services is a leading IT services, consulting, and business solutions organization that has been partnering with numerous global businesses in their transformation journeys for over five decades. Our consulting-led, cognitive-powered portfolio of business, technology, and engineering services and solutions is...

  • Database Systems Administrator

    1 month ago

    Toronto, Ontario, Canada Broadridge Full time

    Database Administrator Job DescriptionBroadridge is seeking a skilled Database Administrator to join our team. As a Database Administrator, you will play a critical role in designing, building, and maintaining our databases to ensure they are secure, highly available, and recoverable.Key Responsibilities:Design and implement database systems to meet business...

  • Database Systems Administrator

    1 month ago

    Toronto, Ontario, Canada Broadridge Full time

    Database Administrator Job DescriptionBroadridge is seeking a skilled Database Administrator to join our team. As a Database Administrator, you will be responsible for designing, building, running, and modernizing our databases to ensure they are secure, highly available, and recoverable.Key Responsibilities:Design and implement database systems to meet...

  • Database Systems Administrator

    3 weeks ago

    Toronto, Ontario, Canada Broadridge Full time

    Database Administrator Job DescriptionBroadridge is seeking a skilled Database Administrator to join our team. As a Database Administrator, you will be responsible for designing, building, running, and modernizing our databases to ensure they are secure, highly available, and recoverable.Key Responsibilities:Design and implement database systems to meet...

  • Database Systems Administrator

    3 weeks ago

    Toronto, Ontario, Canada Broadridge Full time

    Database Administrator Job DescriptionBroadridge is seeking a skilled Database Administrator to join our team. As a Database Administrator, you will be responsible for designing, building, running, and modernizing our databases to ensure they are secure, highly available, and recoverable.Key Responsibilities:Design and implement database systems to meet...

  • Database Systems Administrator

    1 month ago

    Toronto, Ontario, Canada Broadridge Full time

    Database Administrator Job DescriptionBroadridge is seeking a skilled Database Administrator to join our team. As a Database Administrator, you will play a critical role in designing, building, running, and modernizing our databases.Key Responsibilities:Design and implement database systems to ensure high availability, security, and...

  • Database Systems Administrator

    3 weeks ago

    Toronto, Ontario, Canada Broadridge Full time

    Database Administrator Job DescriptionBroadridge is seeking a skilled Database Administrator to join our team. As a Database Administrator, you will be responsible for designing, building, running, and modernizing our databases to ensure they are secure, highly available, and recoverable.Key Responsibilities:Design and implement database systems to meet...

  • Database Systems Administrator

    3 weeks ago

    Toronto, Ontario, Canada Broadridge Full time

    Database Administrator Job DescriptionBroadridge is seeking a skilled Database Administrator to join our team. As a Database Administrator, you will be responsible for designing, building, running, and modernizing our databases to ensure they are secure, highly available, and recoverable.Key Responsibilities:Design and implement database systems to meet...

  • Database Systems Administrator

    1 week ago

    Toronto, Ontario, Canada Broadridge Full time

    About the RoleWe are seeking a highly skilled Database Administrator to join our team at Broadridge. As a Database Administrator, you will be responsible for the design, build, run, and modernization of our databases. You will work closely with our senior technical team to ensure that our databases are secure, highly available, and recoverable.Key...

  • Database Systems Administrator

    1 month ago

    Toronto, Ontario, Canada Broadridge Full time

    Database Administrator Job DescriptionBroadridge is seeking a skilled Database Administrator to join our team. As a Database Administrator, you will be responsible for designing, building, running, and modernizing our databases to ensure they are secure, highly available, and recoverable.Key Responsibilities:Design and implement database systems to meet...

  • Database Systems Administrator

    4 weeks ago

    Toronto, Ontario, Canada Broadridge Full time

    Database Administrator Job DescriptionBroadridge is seeking a skilled Database Administrator to join our team. As a Database Administrator, you will be responsible for designing, building, running, and modernizing our databases to ensure they are secure, highly available, and recoverable.Key Responsibilities:Design and implement database systems to meet...