Information Technology

Senior Database Developer

Information Technology / Full Time / Greater Toronto Area
Apply Now

ATS is the industry leader in using technology to revolutionize engineering and design processes. We create tools to help engineers and architects to integrate complex systems quickly and accurately for North America’s most exciting building projects.

ATS has a strong work ethic committed to delighting clients and providing them with exceptional service. Our thriving and motivated culture is the heartbeat of our organization. We hope you will become a part of it!

As our Senior Database Developer, you will:

  • Lead the DBA team in the planning, development, and maintenance of databases systems for all of the applications
  • DB migration between environments
  • Design, implement, maintain and automate and improve the data migration processes
  • Work with various teams for performance tuning and optimization, query optimization, index tuning, caching, buffer tuning, etc
  • Be strategic, self-motivated, creative, and highly communicative individual, capable of adapting quickly to a fast-paced and evolving environment
  • Manage MySQL in different environments and perform configuration & backup
  • Perform database health monitoring and diagnostics
  • Generate reports by combining data from multiple sources/engines (MySQL,  MongoDB)
  • Automation for generating reports


As the Senior Database Developer, you must have:

  • At least 6 -8 years of experience as a MySQL DBA in a high volume, high impact transactional environment
  • At least 5 years of experience with complex schema in MySQL database in the following areas:
    • Query optimization
    • Schema design
  • Create processes to ensure data integrity and identify potential data errors
  • Team leadership/leadership experience
  • Document and update procedures and processes
  • Maintain and collaborate with deadlines and deliverables
  • Strong analytical, problem solving and decision-making skills

As the Senior Database Developer, the required skill set is:

  • Data integration with other CRM/ platforms like Cloud For Sales, SAP, etc
  • Custom XML Output generation
  • AWS RDS Cluster Management and Data Backup and Restore
  • Knowledge in MySQL, MongoDB &
  • Python & R scripting knowledge
  • PowerBI
  • Custom ETL Scripting

 

Your Life and Career at ATS:

ATS is dynamic, industrious, innovative and collaborative. We believe diverse and inclusive organizations create work environments that are inventive and open-minded, where people spark new ideas and explore alternatives. At ATS, we offer the following to make sure you have a rewarding and enjoyable experience:

TO APPLY: Please email hr@atsspec.com and include your resume and salary expectationsNO PHONE CALLS PLEASE.

To learn more about our company visit our web page: https://www.atsspec.com/ and our promotional video: http://youtu.be/MPyk3BdN-8

Allied Technical Sales Inc. values diversity and is proud to be an Equal Opportunity Employer. We are committed to the principles and practices of employment equity and encourage all qualified individuals, including women, persons with disabilities, visible minorities, and Aboriginal Peoples to apply. Should you be individually selected to participate in an assessment or selection process, accommodations are available upon request in relation to the materials or processes to be used.

 

INDATS