Database Administrator PGSQL & MSSQL

Join a Montreal headquartered company that helps organizations around the world create a personalized journey of impact and fulfillment for their people. Explorance offers innovative Feedback Analytics solutions because we believe that each experience matters.

We are looking to add a Database administrator with a solid background in Postgres to join our growing CloudOps team.

As an Explorance DBA, you will be joining the Global CloudOps Team out of our Chennai 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 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
• Linux knowledge and bash experience
• 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 MS SQL Server.
• Proficient in PSQL, 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.