TRADER-Logo-w-Maple-Leaf-RED
OpportunitiesPerformance & Services DBA

Performance & Services DBA

Toronto, ON

Toronto, ON

Performance Services & DBA – JOB DESCRIPTION 

 

Overview 

 

Effective sub-second data throughput and performance is the lifeblood of our organization.  We are looking to add to our team an Performance DBA to focus our services work in conjunction with our development, architecture and DEVOPS team to systematically enhance and build scalable solutions which are highly performant.  

 

The Performance DBA plays a unique technical leadership role in augmenting the engineering organization. He/she owns and communicates the performance characteristics and methods in providing highly available and responsive database management systems, code and troubleshooting methods.. You will have deep knowledge in the steps required to build and troubleshoot existing database systems including  the journeys and benefits, while understanding the pitfalls of multiple scenarios that cause database outages in a highly demanding scaling environment. It is required that this role has a strong software engineering and infrastructure background and expertise that includes practice of good software development techniques, clean coding, best practices, cloud-native application design with an emphasis on the performance requirements that leads to sub-second delivery. The Performance DBA takes accountability in identifying and addressing bottleneck’s, performance characteristics and, ensuring the software products and solutions designed and built are scalable, secure, performant, testable, and maintainable. The role is a full-lifecycle role covering design, development, and operations responsibilities.

 

Job Responsibilities:

  • Design, code, deploy, and operate performance specific DBA upgrades and technology.
  • Communicate implications and tradeoffs of design decisions, issues, and plans to engineering teams, architecture group and devops teams.
  • Engage with product development teams, understand their needs, develop, and implement platform capabilities and services that improve developer experience, accelerate time to market, and ensure compliance to a reference architecture for cloud-based services.
  • Coach and mentor development teams on performance techniques with hands-on ability to implement best practices or suggest improvements.
  • Designs/engineers system-operating capacity (such as bandwidth, disk space, storage, and CPU utilization) to ensure high availability and performance of end-user applications and systems.
  • Breaks down strategic problems, and analyses data and information to provide insights and recommendations.
  • Performs capacity workload modeling and availability analysis for customer facing applications, systems and environments and recommends changes/enhancements for improving performance and reliability.

 

Data Engineer Qualifications / Skills:

  • Knowledge of best practices and IT operations in an always-up, always-available service
  • Excellent problem solving and troubleshooting skills, beyond the data including data access techniques 
  • Process oriented with great documentation skills
  • Excellent oral and written communication skills 
  • Enterprise DB Postgres Database Administration Certification.
  • Knowledge of administering NoSQL databases such as MongoDB, Couchbase, ElasticSearch, or Costmos
  • Experience in data modeling tools and performance tools.
  • Has strong Python programming skill and be able to develop dba applications for system automation and integration.
  • Implementation and ongoing support of high availability architecture not limited to Active/Active and Active/Passive Clusters

 

Technology Stack:

  • AWS mandatory, Azure is nice to have
  • Docker, Postgres, Cosmos, MS SQL

 

 

Education, Experience, and Licensing Requirements:

  • Experience with database replication is a plus.
  • Enterprise DB Postgres Database Administration Certification.
  • Knowledge of administering NoSQL databases such as MongoDB, Couchbase, ElasticSearch, or HBase
  • Experience in data modeling tools such as Oracle Data Modeler, Erwin, Toad, Visio, etc.
  • Has strong Python programming skill and be able to develop dba applications from an performance perspective