Database Administrator
Who we are:
Who you are:
We are always looking for amazing talent who can contribute to our growth and deliver results! Geotab is seeking a Database Administrator who will be responsible for keeping the Geotab database up and running smoothly at all times. This position provides a seamless flow of information throughout the company, considering both backend data structure and frontend accessibility for end-users. If you love technology, and are keen to join an industry leader — we would love to hear from you!
What you'll do:
As a Database Administrator your key area of responsibility will be database/application performance monitoring and tuning in both a development and production-support capacity. You will ensure existing database systems perform well and are properly configured/maintained, establish and maintain sound backup and recovery policies and procedures, and implement and maintain database security. You will need to work closely with DevOps and support teams.
To be successful in this role you will be a self-starter with strong problem-solving skills and the ability to think algorithmically. In addition, the successful candidate will have high accuracy, meticulous attention to detail, and be a strong team-player with the ability to engage with all levels of the organization.
How you'll make an impact:
-
Perform database/application performance monitoring and tuning in both a development and production-support capacity.
-
Ensure existing database systems perform well and are properly configured/maintained.
-
Establish and maintain sound backup and recovery policies and procedures in conjunction with the system administrators.
-
Implement and maintain database security.
-
Create and implement plans for database growth and changes; create and document database development and testing standards.
-
Perform database patch management and version control.
-
Develop the required tooling and monitoring in production.
-
Troubleshoot poor performance of queries and produce recommendations, such as indexes, IO subsystem requirements, memory, configuration, SQL query changes etc.
-
Work with DevOps and support teams to ensure that the changes can be applied programmatically to databases as required.
-
Participate in a 24x7 on-call rotating schedule.
What you'll bring to the role:
-
3 - 5 years of required previous experience in the following areas: PostgreSQL database administration, CockroachDB, Google Cloud (specifically GCE, Cloud Spanner and CloudSQL), and powershell/bash scripting.
-
Post-Secondary Diploma/Degree; a specialization in Engineering, Computer Science, or a related field is highly valued.
-
Thorough knowledge of data backup, recovery, security, integrity and SQL.
-
Familiarity with database design, documentation and coding, as well as DBA case tools and third party tools.
-
High accuracy and meticulous attention to detail.
-
Able to work well under pressure and respond to fast-changing priorities and deadlines.
-
A strong team-player with the ability to engage with all levels of the organization.
Why job seekers choose Geotab:
Flex working arrangements
Home office reimbursement program
Baby bonus & parental leave top up program
Online learning and networking opportunities
Electric vehicle purchase incentive program
Competitive medical and dental benefits
Retirement savings program
*The above are offered to full-time permanent employees only
How we work:
Other employment statements:
Geotab will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. Additionally, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the Company's legal duty to furnish information.
We are committed to accommodating people with disabilities during the recruitment and assessment processes and when people are hired. We will ensure the accessibility needs of employees with disabilities are taken into account as part of performance management, career development, training and redeployment processes. If you require accommodation at any stage of the application process or want more information about our diversity and inclusion as well as accommodation policies and practices, please contact us at careers@geotab.com. Geotab provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Geotab complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training. Geotab expressly prohibits any form of workplace harassment or discrimination based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of Geotab's employees to perform their job duties may result in discipline up to and including discharge. If you would like more information about our EEO program or wish to file a complaint, please contact our EEO officer, Klaus Boeckers at HRCompliance@geotab.com. For more details, view a copy of the EEOC's Know Your Rights poster. By submitting a job application to Geotab Inc. or its affiliates and subsidiaries (collectively, “Geotab”), you acknowledge Geotab’s collection, use and disclosure of your personal data in accordance with our Privacy Policy. Click here to learn more about what happens with your personal data.Apply for this job
*
indicates a required field