Senior SQL Database Administrator at Unanet (Remote)

| Remote
Sorry, this job was removed at 11:10 p.m. (MST) on Friday, January 20, 2023
Find out who’s hiring remotely
See all Remote jobs
Apply
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
As a member of our Cloud Operations Team, you will be responsible for building and maintaining high performance/availability databases for Unanet's entire product offering. You will join a team of highly talented, rapidly moving engineers and administrators involved in nearly every aspect of the SaaS delivery and customer experience lifecycle.
We are looking for an experienced DBA with extensive experience designing, testing, and supporting next-generation database solutions in Postgres enterprise and SQL Server environments. You should be proficient in an assortment of technologies, including AWS Aurora (Postgres) and MS SQL Server on both Windows and Linux operating systems on AWS. You should also be passionate about solving problems, forward-thinking, and able to evaluate impacts across the environment.
Your First 90 Days
In your First 30 Days , as your familiarity with our product line grows, your responsibilities and influence will grow as well. You will become immersed in all facets of the daily operation of the production cloud database environment, including processes for provisioning new customers, pushing schema updates, reviewing metrics and alerts, troubleshooting, and blameless incident postmortems. You will work with our development leaders of our GovCon ERP product to build knowledge of the database schema. Further, you will collaborate with members of both the Product Development and Cloud Development teams to help ensure operations can support new functionality.
Within your First 60 Days , you will take the lead in database metric reviews and alerting capabilities, including formulating recommendations on enhancing our observability into database activity. You will work with development leaders of our CRM product to build knowledge of the database schema. During this period, you should become familiar with all existing JIRA items relating to database/SQL performance issues. You, along with the rest of the Cloud Support team, will be responsible for supporting production environments.
Within your First 90 Days , you will help drive changes to the operational and development roadmap as we continue onboarding new and existing customers into our hosted production environments. You will work with development leaders of our A/E ERP product to build knowledge of the database schema. During this time, you will begin implementing query/database performance improvements. You will become the primary point of contact for triaging newly reported query or database-related issues. You will work our Director of Information Security to become familiar with the compliance requirements and ongoing projects to secure our production databases.
What You'll Do
  • Design, test, provision, configure, and maintain databases for our production environments; this includes building high-performance, highly-available database systems capable of scaling as our customer base grows
  • Build and maintain infrastructure that supports highly-available database platforms \
  • System Performance Tuning
  • SQL Query Performance Tuning
  • Familiarize yourself with the database schemas for our products to assist development with query construction and optimization
  • Participate in capacity monitoring to help plan for platform growth
  • Mentor Database Administration skills in other team members
  • Design and manage backup solutions to meet established retention, RPO, and RTO policies
  • Disaster Recovery planning and testing
  • Establish metrics and observability of database platforms
  • Secure our customers' data through continued database vulnerability scanning and hardening

Who You Are
  • 7+ years of hands-on experience as a production DBA managing an environment with 1,000+ customers
  • Experience with relational databases (e.g., SQL Server, Aurora or Postgres)
  • Performance optimization experience (SQL queries, hardware sizing, etc.)
  • Experience planning and architecting production database infrastructure
  • Experience hardening production database environments
  • Experience working in an AWS hosted environment
  • Driven, humble, and autonomous, capable of assisting with backlog creation and prioritization
  • A quick study, strong communicator, and ability to adapt to fast-paced environments
  • Detail-oriented, with excellent documentation skills, and ability to successfully manage multiple priorities
  • Troubleshooting skills that range from diagnosing hardware/software issues to large scale failures within a complex infrastructure

Your Differentiators
  • Bachelor's Degree in Computer Science or equivalent
  • Working knowledge of Agile Development practices (e.g., SCRUM, TDD)

Our Team
You will be an integral member of our Cloud Ops Team, which included associates, admins and engineers. You will report to our Director of Cloud Ops, but will collaborate extensively with Cloud Development and the Product Development teams.
We have an open and collaborative environment where everyone works together to deliver what is needed, from product features to operational needs (e.g., health checks). We value open and direct communication, taking calculated risks that will push us forward, and investing in our people.
Our Stack
  • Production and Continuous Integration footprints in AWS
  • Front-end applications leverage .NET, Vue.js, React, Java
  • APIs comprise of .NET, Java, GoLang
  • Backend comprises of MS SQL Server, Oracle, AWS Aurora
  • Developing CI/CD Pipeline leveraging Kubernetes (EKS), Golang, Postgres, Terraform

Our Values
  • We are a Team. Employees, customers, and partners working together.
  • We are Customer-Focused. Customers are the heart of everything we do.
  • We are Driven. Seeking exceptional outcomes.
  • We Own our Success. Every employee has a stake in our company.
  • We do the right thing and have fun in the process.

The salary range for this opportunity is $130,000 - $145,000 per year. You will be eligible for discretionary bonus compensation, subject to plans that may be in effect from time to time. You will further be eligible to participate in Unanet's employee benefits plans and programs. For more details on Unanet's benefits offerings, please visit https://unanet.com/employee-benefits .
Unanet is proud to be an Equal Opportunity Employer. Applicants will be considered for positions without regard to race, religion, sex, national origin, age, disability, veteran status or any other consideration made unlawful by applicable federal, state or local laws.
Read Full Job Description
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

An Insider's view of Unanet

What are some social events your company does?

In a remote-first world, our Culture Committee's focus has been on creative interactions to bring our teams together. We have monthly events like trivia, bingo, Lunch & Learns, and social hours. We also bring our employees together outside of the monthly events with coffee chats, summer events, and holiday celebrations.

Megan

Employee Experience and Operations Manager

What projects are you most excited about?

My team is working through consolidating our ticketing systems. We are already realizing the benefit of transparency across the organization. Our consolidated system gives everyone at Unanet a clear view of all aspects of a customer lifecycle. The next steps will be linking our LMS so that our customers have on place for all things Unanet!

Scott

Director, Technical Support

How has your career grown since starting at the company?

I have been able to grow my career by communicating my goals with my manager, who has given me opportunities to demonstrate my capabilities. With his support, encouragement of having transparent conversations, and Unanet delivering upon their professional development practices, I have been able to obtain my current role as Director of UX!

Trista

Director, User Experience

How do your team's ideas influence the company's direction?

My team sets the tone with prospective customers for long-term partnerships by developing trusting, collaborative relationships focused on solving some of the toughest organizational challenges. Because Sales is on the front line, we understand market needs, thereby influencing Unanet's product and services to better serve its customer-base.

Donna

Regional Vice President, Sales

How does the company support your career growth?

We focus on 'owning your own career.' Our team has offered development sessions educating our employees on how they can drive their own development, have professional development conversations, and build their own individual development plans. This ultimately culminates into successful internal growth opportunities.

Stacy

Chief Human Resources Officer

More Jobs at Unanet

Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
View Unanet's full profileSee more Unanet jobs