Senior Database Administrator

Geotab - Atlanta, GA

Full-time - Mid Level

Remote - Atlanta, GA

Professional, Scientific, and Technical Services

About the position

Geotab is seeking a Senior Database Administrator to ensure the smooth operation of the Geotab database. This role involves maintaining database performance, security, and growth, while collaborating with various teams to support both development and production environments. The ideal candidate will be adaptable to evolving technology and market demands, and will play a crucial role in enhancing the company's data management capabilities.

Responsibilities

• Perform database/application performance monitoring and tuning in both development and production-support capacities.
• Ensure existing database systems perform well and are properly configured/maintained.
• Establish and maintain sound backup and recovery policies and procedures in conjunction with 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 to databases as required.

Requirements

• 5-8 years of experience in database administration.
• Post-Secondary Diploma/Degree or equivalent experience required, with a specialization in Engineering, Computer Science, or a related field highly valued.
• Expert level experience with PostgreSQL database administration.
• Experience with CockroachDB and SQL Server is a nice to have.
• Expert level experience with Google Cloud - specifically GCE, Cloud Spanner, and CloudSQL.
• Proficiency with Powershell and Bash scripting.
• Problem-solving skills and ability to think algorithmically.
• Thorough knowledge of data backup, recovery, security, integrity, and SQL.
• Familiarity with database design, documentation, and coding.
• Previous experience with DBA case tools (frontend/backend) and third-party tools.
• Familiarity with programming languages API.
• Experience working within a technical or engineering organization/knowledge of the high-technology industry is an asset.
• High accuracy and meticulous attention to detail.
• Excellent proofreading abilities.
• Ability to work well under pressure and respond to fast-changing priorities and deadlines.
• Highly organized and able to manage multiple tasks and projects simultaneously.
• Strong team-player with the ability to engage with all levels of the organization.

Nice-to-haves

• Experience with CockroachDB and SQL Server.
• Familiarity with programming languages API.
• Experience working within a technical or engineering organization.

Benefits

• 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