Geotab - Atlanta, GA

posted 5 months ago

Full-time - Mid Level
Atlanta, GA
Professional, Scientific, and Technical Services

About the position

As a Senior Database Administrator at Geotab, you will play a crucial role in ensuring the smooth operation of the Geotab database systems. Your primary responsibility will be to maintain a seamless flow of information throughout the company, focusing on both backend data structure and frontend accessibility for end-users. This position requires you to perform database and application performance monitoring and tuning in both development and production environments. You will also be responsible for creating and implementing plans for database growth and changes, ensuring that existing database systems are well-configured and maintained. In this role, you will work closely with various teams, including Development, Application Support Engineering, and Site Reliability Engineering, to ensure that database systems meet the needs of the organization. You will establish and maintain sound backup and recovery policies and procedures in collaboration with system administrators, implement and maintain database security, and perform database patch management and version control. Additionally, you will troubleshoot performance issues, providing recommendations for improvements such as indexing, memory configuration, and SQL query optimizations. To succeed in this fast-paced and ever-changing environment, you must stay current with technology trends and be adaptable to the growing demands of the market. You will need to be a strong team player, capable of engaging with all levels of the organization, and possess excellent problem-solving skills to address complex database challenges effectively.

Responsibilities

  • Perform database/application performance monitoring and tuning in both 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 to databases as required.

Requirements

  • 5-8 years of experience in database administration.
  • Post-Secondary Diploma/Degree or equivalent experience required, Diploma/Degree specialization in Engineering, Computer Science or a related field highly valued.
  • Expert level experience with PostgreSQL database administration; CockroachDB and SQL Server are 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.
  • Must stay relevant to technology and should have the flexibility to adapt to the growing technology and market demands.
  • High accuracy and meticulous attention to detail.
  • Excellent proofreading abilities.
  • Able to work well under pressure and respond to fast changing priorities and deadlines.
  • Highly organized and able to manage multiple tasks and projects simultaneously.
  • A strong team-player with the ability to engage with all levels of the organization.
  • Technical competence using software programs, including, but not limited to, Google Suite for business (Sheets, Docs, Slides).
  • Entrepreneurial mindset and comfortable in a flat organization.
  • Ability to pass a comprehensive background check, including a one-time drug screening test & credit check.
  • Must be a US resident for at least 3 years.

Nice-to-haves

  • CockroachDB experience
  • SQL Server experience
  • Experience with DBA case tools
  • Familiarity with programming languages API
  • Experience in 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
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service