Senior Database Administrator

Geotab - Atlanta, GA

Full-time - Mid Level

Remote - Atlanta, GA

Professional, Scientific, and Technical Services

About the position

The Senior Database Administrator at Geotab is responsible for ensuring the smooth operation of the company's database systems, focusing on both backend data structure and frontend accessibility. This role involves performance monitoring, tuning, and implementing growth plans for databases, while collaborating closely with various engineering teams. The ideal candidate will adapt to evolving technology demands and engage effectively with all organizational levels.

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; document database development and testing standards.
• Perform database patch management and version control.
• Develop 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.
• Work with DevOps and support teams to ensure that 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 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 have the flexibility to adapt to growing technology and market demands.
• 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.
• Technical competence using software programs, including 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

• Experience with CockroachDB and SQL Server.
• Familiarity with programming languages API.

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