Jobs at Flex People Solutions Inc.

View all jobs

PostgreSQL DBA

Montreal, QC

We are recruiting for a DBA for a long term contract with a Global IT Services Provider supporting to a financial client in Montreal.

The position is an intermediate database application DBA/Infrastructure Engineer on the DB team. The team is tasked with producing business critical transactional database systems as well as large Data Warehouses/Data Marts to meet scalability, stability and performance requirements for applications within the Financial/Trading area.

Work will include designing, enhancing and developing databases across different database environments. The job will involve considering all aspects of the project life cycle and includes proof-of-concept evaluations, coding, designing, testing, implementing, deploying, and continued support of project releases as well as on-call Level 2 support. Collaboration with the Firm’s engineering teams is expected for storage/communication solutions.

Major Roles & Responsibilities:

  • Database Infrastructure Engineering for stability and scalability, capacity planning
  • Application DBA functions: plan & execute database schema changes, bottlenecks analysis, outage prevention/resolution, server/database performance improvements, database maintenance, database recovery, etc.
  • Database development (stored procedures, ETL, tools) and queries/stored procedures review and optimization
  • Enforce database security, standards & guidelines

The candidate will have the ability to propose/review innovative solutions and implement them in production to achieve significant improvements. They will be an expert in performance optimization on server, database, query, data structures and data flow levels, with advanced database architecture knowledge and hands on expertise in Database and Data Warehouse design. They will have excellent Database Administration skills including in depth knowledge of new and existing features to provide effective solutions for critical systems. They will act as a leader in outage resolutions and multi-team global turnovers. They will be the escalation point for major issues.

Required Knowledge:

  • At least 5 years’ experience in PostgreSQL, SQL or DB2 and have exceptional hands-on application DBA skills
  • Experience with scripting language such as: Python
  • Experience with Linux/Unix
  • Strong knowledge base of relational database performance and tuning such as: proper use of indices, database statistics/reorgs, de-normalization concepts.
Powered by