Cloud OPS Database Administrator
Portland, OR 
Share
Posted 29 days ago
Job Description

Trimble Viewpoint | Cloud OPS Database Administrator (DBA)

Reports to: Trimble Viewpoint Cloud OPS

Department: Trimble Viewpoint Cloud OPS

Location: Remote

Job Summary

You'll be an integral part of the SRE team at Viewpoint, who are responsible for the health of the infrastructure and work to empower the engineering team to design highly scalable, robust, and performant applications. We heavily use SQL Server, and our multi-region deployments are multi-terabyte, high throughput, and highly available.

We are looking for a DBA, but you must have competency with T-SQL, automating and optimizing processes, and being able to write in T-SQL.

Duties and Responsibilities

  • Administering the production SQL Server and Azure SQL Database estate

  • Performing daily checks, such as checking backups, database integrity, index performance

  • Ensuring the availability and security of databases and infrastructure

  • Maintaining database standards and access

  • Overseeing installation, patching, upgrades, and maintenance of the SQL estate.

  • Assisting with the optimization and tuning of database systems

  • Supporting the Development team with database and SQL-related queries/issues

  • Escalating issues where necessary to the DBA, Infrastructure, project teams or the IT management team

  • Participating in the on-call rota

  • On an occasional basis, provide cover for releases

Qualifications

Required Knowledge, Skills, Abilities, and Qualities

  • BS degree in a field directly related to software development, and 5+ years of relevant technical experience in application design and programming or an equivalent combination of education and experience

  • Proven experience in a DBE and/or DBA role, with a focus on tooling, automation, and database systems operation

  • Advanced T-SQL (to be understandable by others and to be clear and neat.) skills with practical experience in automating processes

  • Strong experience running MSSQL at TB scale on a cloud provider (Azure SQL, AWS RDS) focusing on high throughput and low latency

  • Understanding of execution plans, concurrency, indexing and performance tuning

  • Ability to troubleshoot database performance issues in a production environment

  • Experience collaborating with software engineers to define best practices related to the database, including schema design, query optimization, and CICD practices

  • Experience in High Availability and Disaster Recovery Methods

  • Experience in the automation of systems and infrastructure

Trimble is proud to be an equal opportunity employer. We welcome and embrace our
candidates' diversity and take affirmative action to employ and advance individuals
without regard to race, color, sex, gender identity or expression, sexual orientation,
religion, age, physical or mental disability, veteran status, pregnancy (including
childbirth or related medical conditions), national origin, marital status, genetic

information, and all other legally protected characteristics. We forbid discrimination and
harassment in the workplace based on any protected status or characteristic. A criminal
history is not an automatic bar to employment with the Company, and we consider
qualified applicants consistent with applicable federal, state, and local law.

The Company is also committed to providing reasonable accommodations for
individuals with disabilities, and individuals with sincerely held religious beliefs in our job
application procedures. If you need assistance or an accommodation for your job,
contact
Julie Phan, Benefits Analyst ator 408-481-8138 or email People Experience at

It is Trimble's policy that candidates are entitled to equal employment opportunities without regard to race, color, religion, sex, national origin, age, marital or veteran status, sexual orientation or the presence of a medical condition or disability.

 

Job Summary
Company
Start Date
As soon as possible
Employment Term and Type
Regular, Full Time
Required Education
Bachelor's Degree
Required Experience
5+ years
Email this Job to Yourself or a Friend
Indicates required fields