Lead PostgreSQL Database Administrator

2 months ago


Mississauga, Canada Cognizant Full time

**Lead PostgreSQL Database Administrator**:
At Cognizant, our global community sets us apart—an energetic, collaborative and inclusive work environment where everyone can thrive. And with projects at the forefront of innovation, you can build a multifaceted, rewarding career and draw inspiration from dedicated colleagues and leaders. Cognizant is right where you belong.

**What you’ll do**:

- Install, configure, and maintain PostgreSQL databases, including upgrades, patches, and user roles/security permissions.
- Lead all aspects of database migrations (e.g., Oracle/other RDBMS to PostgreSQL, on-prem to cloud) and manage performance tuning and index management.
- Conduct backup, recovery, PITR, and configure DR replication, streaming replication, WAL replication, and failover.
- Automate tasks with shell scripting, and set up monitoring tools for database health and performance.
- Configure Transparent Data Encryption (TDE) and audit plugins to improve security. - Manage PostgreSQL partitioning, system catalogs, and high availability setups (e.g., Patroni or other 3-node clusters).

**What You Bring to the Role**:

- Proficiency with PostgreSQL installation, configuration, and performance tuning (shared_memory, work_mem, maintenance_work_mem, buffer cache, etc.).
- Experience with backup and recovery tools such as BART, BARMAN, and other PostgreSQL utilities.
- Knowledge of tools like PGAdmin4, PGPool, PEM, ORA2PG for migrations and management.
- Familiarity with disaster recovery and high availability configurations, including streaming replication and Patroni clusters.
- Solid grasp of Linux OS and any major cloud platform (AWS, Azure, Google Cloud).
- Expertise with additional PostgreSQL management tools and cloud platform certifications.

**Working arrangements**:
We strive to provide flexibility wherever possible. Based on this role’s business requirements, this is a remote position open to qualified applicants in Ontario and/or Nova Scotia, where our hubs are located. Regardless of your working arrangement, we are here to support a healthy work-life balance though our various wellbeing programs.

Note: The working arrangements for this role are accurate as of the date of posting. This may change based on the project you’re engaged in, as well as business and client requirements. Rest assured; we will always be clear about role expectations.



  • Mississauga, Canada Chamberlain Group Full time

    Job Requirements: - Identify, develop, implement, and maintain/administer the myQ ecosystem databases. Accountable for the operational health of the Microsoft SQL and Couchbase NOSQL database platforms supporting myQ today and any new database technologies in our future. - Implement policies, procedures, guidelines, standards, and best practices with...


  • Mississauga, Canada opentext Full time

    **OPENTEXT - THE INFORMATION COMPANY** As the Information Company, our mission at OpenText is to create software solutions and deliver services that redefine the future of digital. Be part of a winning team that leads the way in Enterprise Information Management. **The Opportunity**: This position is responsible for managing tens of highly available...


  • Mississauga, Canada Sialka Cloud Solutions Full time

    Education: Bachelor's degree - Experience: 1 year to less than 2 years **Tasks**: - Collect and document user's requirements - Data Science - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration...


  • Mississauga, Canada MAX Agency Full time

    We are looking for a Database Administrator with sharp problem solving skills capable of working out complex, multiple layered challenges. This may be the position for you if you are a skilled problem solver with fine-tuned decision-making abilities. Key responsibilities Establish the baseline for system performance, recognize deviation, and suggest and...


  • Mississauga, Ontario, Canada PointClickCare Full time

    About PointClickCarePointClickCare is a leading North American healthcare technology platform that enables meaningful care collaboration and real-time patient insights. With over 20 years of experience, the company has been focused on realizing its vision: to help create a world in which providers and plans can confidently deliver frictionless...


  • Mississauga, Canada Run Straight Consulting Ltd. Full time

    **Management Systems (erp or db)**: - MS SQL Server **Credentials (certificates, licences, memberships, courses, etc.)**: - Microsoft Certified Systems Engineer (MCSE) **Business Equipment and Computer Applications**: - Microsoft Visual Studio **Work Setting**: - Consulting firm **Specific Skills**: - Collect and document user's requirements -...

  • Database Analyst

    3 days ago


    Mississauga, Canada CAN INTELLIGENT SOLUTIONS CORP Full time

    **Tasks**: - Collect and document user's requirements - Data Science - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration policy, standards and models - Research and document data...

  • Database Administrator

    7 months ago


    Mississauga, Canada Delta Shutters Inc. Full time

    Education: College, CEGEP or other non-university certificate or diploma from a program of 1 year to 2 years - Experience: 1 year to less than 2 years **Tasks**: - Collect and document user's requirements - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management...


  • Mississauga, Canada GoRight Fleet Solutions Full time

    We are seeking a talented and experienced Database Administrator to work out of our Mississauga, Ontario location. What’s in it for you? - Comprehensive Benefits - featuring 100% reimbursement on medical and dental, vision, AD&D, affordable STD/LTD, Life and Dependent Life Insurance - CareerPath - Company paid personal and professional development - RRSP...


  • Mississauga, Canada AG Marketing & Development Group Inc Full time

    Education: Bachelor's degree - Experience: 3 years to less than 5 years **Tasks**: - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration policy, standards and models - Research and document...

  • Analyst, Database

    7 months ago


    Mississauga, Canada A.P.H INTERNATIONAL LTD. Full time

    Education: Bachelor's degree - Experience: 1 year to less than 2 years **Tasks**: - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration policy, standards and models - Research and document data...

  • Database Analyst

    7 months ago


    Mississauga, Canada Reiwatakiya Full time

    Education: Bachelor's degree - Experience: 2 years to less than 3 years **Tasks**: - Collect and document user's requirements - Data Science - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data...

  • Analyst, Database

    7 months ago


    Mississauga, Canada 1702858 Ontario Inc OA Eurocan Srl Full time

    Education: Bachelor's degree - Experience: 1 year to less than 2 years **Tasks**: - Collect and document user's requirements - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Lead and co-ordinate teams of data administrators in the...

  • Database Specialist

    6 days ago


    Mississauga, Ontario, Canada Rama Gaming House Full time

    About UsRama Gaming House is a leading casino and entertainment provider, seeking an experienced Database Specialist to join our team.Job DescriptionWe are looking for a highly skilled Database Specialist to develop and implement strategic database solutions that meet the needs of our business. As a key member of our IT team, you will be responsible for...


  • Mississauga, Canada IKO Industries Ltd. Full time

    IKO Industries Ltd. is a market leader in the manufacturing of roofing and building materials. IKO is a Canadian owned and operated business with production facilities worldwide and has many years of unparalleled success in the roofing materials industry. Quality, integrity, and trustworthiness are the values that underlie this success, and we have built...


  • Mississauga, Canada AGMD GROUP Full time

    Education: - Expérience: - **Education**: - Bachelor's degree - ** Tasks**: - Design and develop database - Operate database management systems to analyze data - Develop and implement data administration policy, standards and models - Research and document data requirements, data collection and administration policy, and data access rules - ** Work...


  • Mississauga, Canada AG Marketing & Development Group Inc Full time

    Education: - Expérience: **Education**: - Bachelor's degree **Tasks**: - Design and develop database - Operate database management systems to analyze data - Develop and implement data administration policy, standards and models - Research and document data requirements, data collection and administration policy, and data access rules **Work conditions...


  • Mississauga, Canada Six side Logistics Full time

    Education: Bachelor's degree - Experience: 3 years to less than 5 years **Tasks**: - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration policy, standards and models - Research and document...


  • Mississauga, Ontario, Canada Cognizant Full time

    Job SummaryWe are seeking a highly skilled Lead Oracle Database Security Strategist to join our team at Cognizant. This role involves developing and implementing robust Oracle database security measures, ensuring the integrity and confidentiality of sensitive data.About YouYou will have a minimum of 10 years of experience in Oracle DBA Security...

  • Database Analyst

    2 weeks ago


    Mississauga, Canada Rama Gaming House Full time

    Work Term: Permanent - Work Language: English - Hours: 40 hours per week - Education: College, CEGEP or other non-university certificate or diploma from a program of 3 months to less than 1 year - Experience: 1 year to less than 2 years - or equivalent experience - ** Work setting**: - Casino - ** Tasks**: - Data Science - Develop and implement a strategic...