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 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 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, 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 Administrator Leader

    3 weeks ago

    Toronto, Canada Tata Consultancy Services Full time

    About the RoleTata Consultancy Services (TCS) is seeking an experienced PostgreSQL Database Administrator to lead our database team. As a key member of our team, you will be responsible for building, implementing, configuring, managing, documenting, and tuning PostgreSQL 11 and above databases with Red Hat Linux.Responsibilities:Serve as a technical expert...

  • PostgreSQL Database Expert Wanted for Cloud Infrastructure

    5 days ago

    Greater Toronto Area, Canada CC Pace Full time

    Job DescriptionWe are seeking a highly skilled PostgreSQL Database Engineer to join our team at CC Pace. As a key member of our Database Operations group, you will be responsible for managing, maintaining, and securing databases in the AWS Cloud.Key Responsibilities:Install, upgrade, and manage database servers and schemas in a cloud environment.Develop and...

  • Database Administrator

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

  • Database Operations Engineer

    7 days ago

    Greater Toronto Area, Canada CC Pace Full time

    Job DescriptionWe are seeking an experienced Database Operations Engineer to join our team at CC Pace. This is a remote position that requires a strong background in SQL Server, MySQL, and PostgreSQL database management and administration.The successful candidate will partner with product support and DevOps CSM to keep databases secured, healthy, and...

  • Database Administrator

    4 weeks ago

    Toronto, Canada Tata Consultancy Services Full time

    Tata 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.As a Database Administrator, you will be responsible for building, deploying, and administering distributed Oracle DBMS, Oracle Exadata...

  • Database Administrator

    3 months ago

    Toronto, Canada CareRx Full time

    Key Responsibilities:_ - Oversee and manage all aspects of our MS SQL, PostgreSQL and other databases. - Monitor and improve database performance and capacity proactively, anticipate and prevent any potential database issues for data accuracy and security. - Utilize extensive experience with Data Warehouse and SQL to develop and maintain database structures,...

  • Cloud Database Engineer

    4 weeks ago

    Toronto, Canada LanceSoft, Inc. Full time

    Job OverviewLanceSoft, Inc. is seeking a highly skilled Cloud Database Engineer with expertise in PostgreSQL to join our team.

  • Database Administrator

    4 weeks ago

    Toronto, Canada SmartTrade Full time

    smartTrade Technologies is a software publisher specializing in the trading and finance sector. Its clients primarily include investment banks, stock exchanges, brokers, and pension funds. smartTrade enables real-time computerized management of financial flows among these different stakeholders. Joining smartTrade means becoming a part of an innovative and...

  • Database Administrator

    2 months ago

    Toronto, Canada SmartTrade Full time

    smartTrade Technologies is a software publisher specializing in the trading and finance sector. Its clients primarily include investment banks, stock exchanges, brokers, and pension funds. smartTrade enables real-time computerized management of financial flows among these different stakeholders. Joining smartTrade means becoming a part of an innovative and...

  • Db2 Database Administrator

    7 days ago

    Toronto, Canada AstraNorth Full time

    5+ years experience in a database administration role, with primary focus on DB2 and the ability to manage Oracle or PostgreSQL - Completion of a post-secondary college diploma or university degree in a related discipline or a combination of education, training and experience deemed to be equivalent - Certificate from IBM or Oracle on Database Administration...

  • PostgreSQL Dba

    7 months ago

    Toronto, Canada Dawn InfoTek Inc. Full time

    Dawn InfoTek Inc. is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors. We have been dedicated to delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients. We are currently seeking competent individuals to fulfill the role of DBA to join our...

  • Db2 Database Administrator

    6 days ago

    Toronto, Canada Q1 Technologies Full time

    "- 3+ years experience in a database administration role, with primary focus on DB2 and the ability to manage Oracle or PostgreSQL - Completion of a post-secondary college diploma or university degree in a related discipline or a combination of education, training and experience deemed to be equivalent - Certificate from IBM or Oracle on Database...

  • Database Administrator

    3 months ago

    Toronto, Canada SmartTrade Full time

    smartTrade Technologies is a software publisher specializing in the trading and finance sector. Its clients primarily include investment banks, stock exchanges, brokers, and pension funds. smartTrade enables real-time computerized management of financial flows among these different stakeholders. Joining smartTrade means becoming a part of an innovative and...

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

  • Postgres Database Administrator in Cloud Infrastructure

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

  • Oracle Database Administrator

    5 days ago

    Toronto, 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...

  • Oracle Database Administrator

    6 days ago

    Toronto, 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...

  • Oracle Database Administrator

    5 days ago

    Toronto, 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...