Database Administrator, PostgreSQL
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
PostgreSQL Database Administrator at TEHORA, ensuring database performance and cloud environment security. Involves administration, optimization, and cloud database management.
Responsibilities:
- Administer PostgreSQL databases
- Perform quality assurance and support the development of data models
- Act as a performance, data operations and connection-management consultant
- Advise teams on SQL query optimization
- Contribute to the development of SQL coding rules and naming conventions
- Create base schemas or containers in on-premises or cloud environments
- Support the development of scripts for provisioning, updating or deploying database environments
- Monitor cloud database service consumption and advise on cost optimization
Requirements:
- Minimum 8 years' experience as a systems development or maintenance analyst working with a relational DBMS
- At least 5 years' experience with PostgreSQL version 14 or later
- Experience administering databases in a cloud environment
- Participation in a project using DbUp or an automated data-deployment tool
- Experience with Azure Database for PostgreSQL or CI/CD pipelines is an asset
- Ability to explain technical concepts clearly to non-technical audiences and to document work precisely
- Excellent command of French, both spoken and written
Benefits:
- Remote work and flexibility to accommodate family obligations
- Entrepreneurial culture that encourages creativity and innovation
- Flexible hours (depending on the type of employment contract)
- Sick leave and leave for family events
- Suitable IT equipment
- Motivating and rewarding workspace
- Social and environmental initiatives
- On-the-job learning program
- Career progression
- SALARY
- The salary will be calculated based on the average hourly rate corresponding to your profile.
- WORK LOCATION
- Remote work from Canada. Occasional presence in Québec may be required depending on the needs of the engagement.
- WHY JOIN TEHORA?
- TEHORA is a multidisciplinary Quebec firm recognized for the excellence of its professional, technical and project-management services at the national and international levels. Our mission is to support clients in delivering their projects through the excellence of our know-how and our creativity.
- Since its creation in 2017, our team of professionals has experienced rapid growth in response to strong demand for multidisciplinary project management in transportation, civil engineering, IT and more.
- Our collaborators work on mandates both internally and on client sites.
- TEHORA stands out for its corporate culture, focused on employee well-being and diversity.
- At TEHORA, every team member is an important contributor to our collective success. Our people have the flexibility to balance work and personal life while pursuing a fulfilling career.
- We offer a motivating work environment. The variety of projects, high level of autonomy and direct client interaction are valued. This proximity is possible thanks to our flat organizational structure, which fosters trust and effective communication between our team and clients.
Similar Jobs
Database Administrator, SQL Server
Database administrator managing SQL Server databases in a modern environment. Collaborating with development and infrastructure teams for optimal data management.
Senior Administrateur de bases de données Oracle
Senior Oracle Database Administrator managing cloud-based Oracle databases for public sector projects. Administering, securing, and migrating databases in modern environments.
Administrateur de bases de données, Oracle
Oracle database administrator working with complex requests in a technological environment. Focusing on optimizing and maintaining Oracle databases while ensuring data integrity and performance.
Administrateur de bases de données, MySQL
Database Administrator managing MySQL databases, ensuring security and performance in a cloud environment. Collaborating on data models and optimizing SQL queries with a focus on cloud operations.
Administrateur de bases de données, IDMS
Database Administrator managing IDMS databases for TEHORA, supporting critical data operations. Responsibilities include maintenance, monitoring, and providing expert guidance on data structure adjustments.
Senior Grants Administrator – Pre-Award Administration
Senior Grants Administrator for Bouvé College Office of Research supporting pre-award administration and assisting faculty with grant proposals. Managing and coordinating grant submissions and compliance checks.
Senior CMMS Administrator
CMMS Maximo Administrator managing, configuring, and optimizing maintenance management systems for JLL. Ensuring data integrity and user adoption to maximize operational efficiency.
Senior Director, Fund Administration – Loan Servicing
Senior Director managing loan servicing for private credit clients at Juniper Square. Overseeing team development, system selection, and operations for AI-native servicing capabilities.
PowerCampus Implementation Engineer
PowerCampus Implementation/Administrator Engineer for a U.S. BPO company serving LATAM clients. Leading system implementations and providing technical support for PowerCampus environments.
Active Directory Administrator
Active Directory Administrator responsible for Microsoft Active Directory environments in a global context. Collaborating with international teams to ensure high availability and compliance.
Senior Manager, Learning Management System Administration – Training
Senior Manager overseeing Learning Management System Administration and Training for Vertex Pharmaceuticals. Focusing on training operations, project management, and collaboration with cross-functional teams.
Part-Time Faculty, Doctor of Business Administration
Part-Time Faculty guiding doctoral learners at Capella University in business administration courses. Responsible for ongoing mentorship, feedback, and participation in doctoral committees.
Technical Success Administrator – Emergency Call Management
Technical Success Administrator focusing on Emergency Call Management at Motorola Solutions. Supporting cloud integration and providing technical assistance to ensure customer satisfaction and software usage.
Utilization Management Administration Coordinator, Phone Intake
Utilization Management Administrative Coordinator providing non-clinical support and assisting healthcare providers with referral authorizations. Responsible for gathering and processing requests accurately and efficiently.
Director, Research – Business Administration – Radiology
Director of Research/Business Administration oversees financial and operational issues in the Radiology department. Managing grants, budgets, and personnel for research functions.
Coordinator of Patient Administration
Field position coordinating patient administration with ZOLL medical devices and healthcare professionals. Ensuring continuity of service and optimal patient care within assigned accounts.
Administrador Microsoft Exchange
Administrar sistemas Microsoft Exchange en la industria bancaria con un enfoque en soluciones cloud. Se busca un perfil con sólida experiencia de 6 años y conocimientos avanzados en protocolos de correo.
Contract Administrator
Contract Administrator responsible for managing contracts with vendors and clients. Working remotely and supporting business growth through effective compliance processes and reporting.
ERP Administrator – Microsoft 365 Dynamics
Senior ERP Systems Administrator managing Microsoft Dynamics 365 Business Central for Cutsforth LLC. Responsible for system configuration, optimization, and user training in a remote setting.
Maximo Administrator
IBM Maximo Administrator responsible for administration, configuration, and support of IBM Maximo Application Suite. Managing operational support for asset management operations within Azure and OpenShift environments.