About The Position
We are looking to add a Database Administrator (Intermediate) with a solid background in PostgreSQL to join our growing CloudOps team. As an Explorance DBA, you will be joining the Global CloudOps Team out of our Montreal office. You will be responsible for the implementation, configuration, maintenance, and performance of critical PostgreSQL database systems to ensure the availability, performance, and security of our SaaS applications. This is a hands-on position requiring strong technical and troubleshooting skills, as well as excellent interpersonal and communication skills.
Requirements
- 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.
- Strong knowledge of PostgreSQL architecture, administration, and troubleshooting.
- Proficiency with PL/pgSQL and PostgreSQL database programming concepts.
- Working knowledge of Linux operating systems and proficiency with shell scripting (Bash).
- Experience with database performance tuning and optimization techniques.
- Experience with backup, recovery, and disaster recovery planning.
- Strong understanding of database security principles and best practices.
- Strong analytical, troubleshooting, and problem-solving skills.
- Ability to organize and plan work independently.
- Results-oriented team player with strong communication skills.
- Ability to manage multiple priorities across geographically distributed teams.
Nice To Haves
- Experience with Microsoft SQL Server administration.
- Knowledge of Redis and distributed caching technologies.
- Experience with database monitoring and observability solutions.
- Experience with ETL processes and data integration.
- PowerShell scripting and process automation experience.
- Understanding of fundamental design principles behind scalable applications.
- Experience supporting cloud-hosted database environments.
- Experience with database capacity planning, performance monitoring, and operational optimization.
Responsibilities
- Install, configure, administer, and maintain PostgreSQL databases across development, testing, and production environments.
- Design and implement database architectures and data models that align with business and application requirements.
- Ensure high levels of database performance, availability, reliability, and security.
- Participate in database upgrades, migrations, and infrastructure improvement initiatives.
- Apply database design best practices to support scalability, maintainability, and performance.
- Configure, monitor, troubleshoot, and optimize PostgreSQL high-availability solutions, including streaming replication, logical replication, Patroni, and other automated failover technologies.
- Develop, document, and implement backup and recovery strategies.
- Ensure disaster recovery readiness and data protection standards are maintained.
- Regularly validate backup integrity and recovery procedures.
- Monitor database performance and proactively identify bottlenecks and optimization opportunities.
- Analyze and optimize query execution plans using PostgreSQL tools such as EXPLAIN and ANALYZE.
- Recommend and implement indexing, schema, and configuration improvements.
- Review deployment scripts and provide recommendations to improve performance and reliability.
- Implement and manage database security controls, including encryption, auditing, and logging capabilities.
- Manage user access, permissions, and database security policies.
- Support compliance with organizational security standards and best practices.
- Monitor databases for security vulnerabilities and unauthorized access.
- Develop and enhance database monitoring solutions to improve visibility and operational efficiency.
- Automate routine database administration tasks using shell scripting, PowerShell, and other appropriate tools.
- Continuously improve database operations, maintenance procedures, and documentation.
- Support capacity planning and resource utilization analysis.
- Diagnose and resolve production database issues in support of service-level objectives.
- Support application development teams with database design, query optimization, and troubleshooting.
- Perform scheduled maintenance and support release deployment activities as required.
- Follow and participate in Explorance development standards and guidelines.
- Work closely with CloudOps, Development, and Infrastructure teams to support business initiatives.
- Collaborate effectively with global teams across North America, EMEA, and APAC.
- Participate in cross-functional projects involving application architecture, migrations, and operational improvements.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
