Database Administrator PostgreSQL

Join a Montreal-based SaaS company that helps organizations around the world create a personalized journey of impact and fulfillment for their people. Explorance offers innovative Experience Management solutions because we believe that each experience matters. Will we be your next one 

To be an Explorer means to join one the #1 ranked workplace in Canada, awarded by Great Place to Work®. Join a team that values trust, drive, collaboration, excellence, and a growth mindset. Live an experience that is rewarding and unique.  

Currently, we are looking to add a Database administrator with a solid background in Postgres and knowledge of MS SQL, to join our growing CloudOps team. 

As an Explorance DBA, you will be joining the Global CloudOps Team out of our Chennai, India or Amman, Jordan office.  You will be responsible for the implementation, configuration, maintenance, and performance of critical RDBMS systems, specifically Postgres and MS-SQL Server, to ensure the availability and consistent performance of our SaaS applications. This is a hands-on position requiring solid technical and troubleshooting skills, as well as excellent interpersonal and communication skills. 

Key Responsibilities include:

Database Design & Implementation

• Design, install, configure, and maintain PostgreSQL and MS SQL Server databases, ensuring high levels of performance, availability, and security
• Implement database architecture and data models that align with business requirements.
• Setup/monitoring/fixing/analyzing/troubleshooting high availability, including AlwaysOn, PG streaming replication and Active/Passive clusters

Performance Tuning & Optimization

• Monitor database performance, monitoring development and perform tuning and optimization tasks.
• Analyze query performance and make recommendations for improvements.

Backup & Recovery

• Develop, document and implement backup and recovery strategies.
• Ensure data integrity and availability through regular backups and disaster recovery plans.

Security Management

• Manage user access and permissions to ensure data security.
• Implement and monitor security measures to protect sensitive data.
• Database security (e.g. TDE) and auditing abilities (i.e. CDC)

Troubleshooting & Support

• Diagnose and resolve database-related issues promptly in support of SLAs.
• Provide support for application development teams and assist in database design and queries.

Documentation & Reporting

• Maintain documentation for database architecture, configurations, and processes.
• Prepare regular reports on database performance and security.

Collaboration

• Work closely with IT teams, application developers, and stakeholders to support data-related initiatives.
• Participate in system upgrades, migrations, and other database projects.
• Deployment code review and suggest performance enhancements
• Follow and participate in Explorance development standards and guidelines

Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 5+ years of experience as a Database Administrator, with a strong focus on PostgreSQL and knowledge of MSSQL.
• Proficient in SQL, PL/pgSQL, T-SQL, and other database programming languages. 
• Experience with database performance tuning and optimization techniques.
• Familiarity with database backup, recovery, and disaster recovery processes.
• Strong understanding of database security principles and practices.
• Excellent problem-solving skills and attention to detail.
• Ability to work independently and as part of a team.

Preferred Skills:

• Experience with on-premise and cloud-based databases (AzureSQL).
• Knowledge of Redis is a plus.
• Experience with database monitoring tools and performance analysis.
• Understanding of fundamental design principles behind a scalable application
• Experience in SSIS / SSRS / SSAS
• Experience in ETL
• Flexible, team player with a get-it-done personality
• PowerShell knowledge for process automation
• Basic knowledge of Linux

Other Requirements

• Only apply if you are a Chennai (or surroundings) resident that is interested in being part of a vibrant and highly engaged at-the-office culture.

At Explorance, we take inclusion to heart and live it each day. We put the human first in everything we do and take pride in our authenticity and culture of inclusion. We therefore encourage persons of any race, religion, ethnicity, gender identity, sexual orientation, age, immigration status, disability or other applicable legally protected characteristics to apply. We make employment-related decisions without regard to any of these characteristics. And to ensure a safe workspace for all our employees, all employment is contingent upon receipt of a satisfactory background and reference check.

About Explorance

 At Explorance, we believe that the true power of experience lies in the moments that matter, whether you're in the hiring process, advancing in your career, or navigating our technology. We're a company that not only takes diversity, equity, and inclusion to heart, but lives it each day. We provide you with resources and support that fit your unique needs, a workplace that reflects the wider world around us, and a culture where you have a voice that is valued and is empowered to succeed. That's the kind of team you'll be joining when you choose to work at Explorance. One where we choose trust over doubt, responsibility over indifference, choices over control, and a personalized journey of growth and success over a traditional cookie-cutter employment storyline. 

Are you curious to get to know more about our approach and products Check out our website or connect on LinkedIn, Facebook, and X.