Senior PostgreSQL Database Engineer
PerconaFull Time
Senior (5 to 8 years)
The ideal candidate will possess over 5 years of hands-on PostgreSQL administration experience in production environments, with proficiency in Python scripting for database automation and management. A strong understanding of PostgreSQL internals, optimization techniques, and performance tuning is essential, along with experience in high-availability deployments and disaster recovery strategies. Knowledge of database security best practices, monitoring, alerting, troubleshooting, indexing strategies, query optimization, and execution plans are also required. Familiarity with PostgreSQL extensions, cloud-based PostgreSQL implementations (AWS Aurora RDS), Terraform, GitHub, infrastructure-as-code, and database change management is preferred.
The Senior PostgreSQL Administrator will be responsible for designing, implementing, and maintaining PostgreSQL database infrastructure across various environments, monitoring database performance, and implementing optimizations for query efficiency. Key duties include developing and maintaining backup/recovery procedures, ensuring data integrity, implementing and managing database security measures, and creating Python scripts for automation, monitoring, and maintenance. The role also involves collaborating with engineering teams to optimize database schemas and queries, providing guidance on best practices, participating in code reviews, and planning/executing database upgrades and migrations with minimal downtime. Creating and maintaining documentation and participating in an on-call rotation for database-related issues are also core responsibilities.
Digital platform for investing and financial management
Wealthsimple provides a range of financial tools that help individuals manage their money effectively. Their services include automated investing, where users can set up investment accounts that automatically adjust based on market conditions, and commission-free stock trading, allowing users to buy and sell stocks without paying fees. They also offer cryptocurrency investments for those interested in digital currencies and a straightforward tax filing service that is designed to be quick and user-friendly. Wealthsimple stands out from its competitors by focusing on young professionals and tech-savvy individuals, providing a digital platform that is easy to navigate and understand. The company's goal is to simplify financial management, making it accessible to everyone by using technology to create a more personal and approachable experience in finance.