PostgreSQL Database Administrator

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

  • Postgres Database Administrator in Cloud Infrastructure

    2 weeks 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...

  • Senior Database Architect

    5 days ago

    Greater Toronto Area, Canada, Ontario Mindlance Full time

    Client : Insurance GroupTitle : Enterprise Database Architect/Database Architect/Database Platform Architect/Senior Database ArchitectLocation : Toronto, ON M5J 0A8Duration : 06 months (Contract to hire)Min 6-8 years of overall experience is required.This role involves the following:Database - 70%10% database security, Database policy and compliance...

  • Oracle Database Administrator

    4 weeks ago

    Toronto, Ontario, C6A, Ontario, Canada Tata Consultancy Services Full time

    Inclusion without Exception:Tata Consultancy Services (TCS) is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity is reflected in our...

  • Senior Oracle Database Engineer

    6 days ago

    Toronto, Ontario, Canada Tata Consultancy Services Full time

    Company OverviewTata Consultancy Services (TCS) is a leading IT services, consulting, and business solutions organization with over 55 years of experience in partnering with large businesses on their transformation journeys.We pride ourselves on our commitment to culture and diversity, reflected in our people stories across the workforce and implemented...

  • Database Systems Architect

    5 days ago

    Toronto, Ontario, Canada CI Financial Full time

    Job Title: Database Systems ArchitectAbout CI Financial: We are a global wealth management and asset management advisory services company, driven by a commitment to provide individuals and institutions with the highest-quality investments and advice.Job Summary: We are seeking an experienced Database Systems Architect to join our Infrastructure team. The...

  • Cloud Database Solutions Architect

    6 days ago

    Toronto, Ontario, Canada Extreme Networks Full time

    Company OverviewExtreme Networks is a global leader in cloud-driven networking solutions, with over 50,000 customers worldwide. Our end-to-end platform enables digital transformation efforts and delivers progress like never before.Job DescriptionWe are seeking a highly skilled Cloud Database Administrator to join our team. As a key member of our database...

  • Database Architect

    3 days ago

    Toronto, Ontario, Canada Tata Consultancy Services Full time

    Job OverviewTata Consultancy Services is a global leader in IT services, consulting, and business solutions. With over 55 years of experience, we have been partnering with some of the world's largest businesses in their transformation journeys.About UsWe deliver our unique Location Independent AgileTM delivery model, recognized as a benchmark of excellence...

  • Database Infrastructure Specialist

    5 days ago

    Toronto, Ontario, Canada CI Financial Full time

    At CI Financial, we are seeking a highly skilled and experienced Database Engineer to join our Infrastructure team. We are committed to delivering exceptional results and creating a positive work environment.This role is ideal for a motivated individual with 7+ years of experience in technical areas such as database environments, storage and backup...

  • Senior Database Solutions Architect

    3 days ago

    Toronto, Ontario, Canada CI Financial Full time

    Job DescriptionCI Financial is a global wealth management and asset management advisory services company that has consistently anticipated and responded to the changing needs of investors since 1965. We are driven by a commitment to provide individuals and institutions with the highest-quality investments and advice.About UsWe operate in a fast-paced...

  • Oracle Database Administrator

    3 weeks ago

    Toronto, Ontario, Canada Rubicon Path Full time

    About the Role We are seeking an experienced Oracle Database Administrator to join our team at Rubicon Path. In this role, you will be responsible for administering large-scale Oracle databases on RAC, ensuring high performance and data integrity. Key Responsibilities Administering large-scale Oracle databases on RAC, including setup, configuration, and...

  • Oracle Database Administrator

    2 weeks ago

    Toronto, Ontario, Canada Tata Consultancy Services Full time

    Job DescriptionTata Consultancy Services is a leading IT services company that offers a wide range of services including consulting, business solutions, and technology implementation. Our team is looking for an experienced Oracle Database Administrator to join our group.About UsWe are a global organization with over 55 years of experience in providing...

  • Oracle Database Administrator

    1 month ago

    Toronto, Ontario, Canada Rubicon Path Full time

    Rubicon Path is seeking an experienced Oracle Database Administrator to join our team.The ideal candidate will have hands-on experience administering large-scale Oracle databases on RAC and a deep understanding of change data capture (CDC) concepts and implementation.We are looking for a skilled professional who can optimize database performance, ensure data...

  • Enterprise Oracle Database Administrator

    2 weeks ago

    Toronto, Ontario, Canada Wirehead Full time

    We are seeking an experienced Enterprise Oracle Database Administrator to join our team at Wirehead. Located in Toronto, this is a contract role that offers the opportunity to work on high-profile projects and develop your skills in a fast-paced environment.As an Enterprise Oracle Database Administrator, you will be responsible for designing, implementing,...

  • Senior Database Administration Director

    2 weeks ago

    Toronto, Ontario, Canada Infotek Consulting Services Inc. Full time

    Infotek Consulting Services Inc. is seeking a seasoned professional for the role of Senior Database Administration Director, a contract-to-hire opportunity with potential for permanent employment.This leadership position involves overseeing the Database Platform CoE as a Database Platform Center of Excellence Leader.Job Profile DescriptionServant Leadership:...

  • Manager Database Administration

    3 weeks ago

    Toronto, Ontario, C6A, Ontario, Canada Infotek Consulting Services Inc. Full time

    Infotek Consulting is searching for a Manager, Database Administration - this is a contract to hire role and candidates must be interested in permanent employment. This opportunity is for a Database Platform CoE Leader Job Profile DescriptionSupervises employees as direct reports.Oversees assigning, directing and evaluating work; conducting performance...

  • Postgres DBA

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

  • Database Administration Manager

    3 weeks ago

    Toronto, Ontario, C6A, Ontario, Canada Iris Software Inc. Full time

    Greetings!Iris’s leading Insurance client is looking for DBA Manager to join their team at Toronto, ON(Hybrid) location. Job Title: DBA ManagerLocation: Toronto, ON(hybrid)Duration: Long Term Job Description:Establishes a consolidated current state of the art view of key data assets and related processes; drive the definition and implementation of a data...

  • Highly Skilled Oracle Database Administrator

    2 weeks ago

    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 many of the world's largest businesses in their transformation journeys for over 55 years.Estimated Salary Range:$120,000 - $180,000 per year based on location and experience.Job Description:We are...

  • Manager Database Administration

    3 weeks ago

    Toronto, Ontario, C6A, Ontario, Canada Iris Software Inc. Full time

    Iris client, one of the global professional services firm, headquartered in New York City with businesses in insurance brokerage, risk management, reinsurance services, talent management, investment advisory, and management consulting is looking for a Database Manager at Toronto, ON for a contract to hire role. Title: Database ManagerLocation: Toronto, ON...

  • Database Architect

    2 weeks ago

    Toronto, Ontario, Canada Rubicon Path Full time

    About Rubicon PathRubicon Path is a leading organization in the field of data management and security. We are committed to providing top-notch solutions to our clients and fostering a culture of excellence within our team.Job Title: Sr. Database AdministratorEstimated Salary: $120,000 - $180,000 per yearJob Description:We are seeking an experienced Sr....