About Clearwater Analytics® 

Clearwater Analytics® is a global SaaS solution for automated investment data aggregation, reconciliation, accounting, and reporting. Clearwater helps thousands of organizations make the most of investment portfolio data with cloud-native software and client-centric servicing. Every day, investment professionals worldwide trust Clearwater to deliver timely, validated investment data and in-depth reporting.

Clearwater aggregates, reconciles, and reports on more than $3.5 trillion in assets across thousands of accounts daily for our Fortune 500 clients.

Description

The Senior Database Administrator (DBA) will largely be responsible for providing operational database services to the organization. Primary responsibilities will include owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents, daily monitoring

to ensure service-related issues are identified and resolved, responding to database related alerts and escalations, and working with infrastructure and application development teams to define strategic solutions to new and recurring problems.

This DBA role requires a service-oriented mentality and high sense of ownership. The DBA will be expected to continually look for areas of improvement in projects, products and processes to ensure efficiency, consistency and accuracy.

Self-direction and the ability to manage and allocate your time over multiple simultaneous projects are keys for success.

Responsibilities

  • Installation, Configuration, and Maintenance of the database platforms for development, testing, staging, and production environments 
  • Disaster Recovery and High Availability configuration including Failover Clustering, Log Shipping, Replication, and Availability Groups
  • Provide support, consultation, recommendation, and assistance to multiple development teams
  • Gather metrics to report, analyze, and identify performance and resource bottlenecks
  • Database creation, migration, upgrades, refactoring
  • Identify, monitor, review, troubleshoot, and audit database processes and procedures
  • Database migration and refactoring projects
  • Participation in an On-Call and Maintenance Window rotation
  • Perform feasibility studies and estimates for the implementation of new or revised database strategies to solve business needs 

Requirements

  • Installation, configuration, and maintenance of the application database platform in development, testing, staging, and production environments

  • Disaster Recovery and High Availability configuration including Failover Clustering and AlwaysON Availability Groups. Ability to configure and troubleshoot Sql Server AlwaysON for replication.

  • Performance tuning, indexing strategies, stored procedure optimization and general maintenance of OLTP and reporting queries.

  • Detect and resolve performance and scalability issues through the use of monitoring tools like Idera, Sql Sentry, New Relic. Gather metrics to report, analyze, and identify performance and resource bottlenecks.

  • Work with multiple development teams to create and extend software architecture and design specifications based on complex requirements.

  • Implement extensive infrastructure automation via shell scripting.

  • Perform database creation, server migration, sql upgrades, OS patching.

  • Identify, monitor, review, troubleshoot, and audit database processes and procedures.

  • Perform feasibility studies and estimates for the implementation of new or revised database strategies to solve business needs

  • Participate in on-call rotation with other DBA's

Requirements/Experience

  • 5+ years’ experience in database server administration, database management and performance analytics.

  • Deep SQL Server, Postgresql/Mysql database programming and optimization skills particularly with experience in high transaction volume environments

  • Experience working on a PaaS/SaaS managing Sql Server and Cloud (AWS/GCP) databases providing critical 24x7 uptime as a Database Administrator.

  • Excellent technical troubleshooting abilities and techniques

  • Effective communication and consultation with internal and international teams and stakeholders

  • Knowledge of Security and configuration best practices

  • Bachelor's Degree in one of the following subject areas: Computer Science, Information Technology, or relevant career experience.

What we offer

  • Headquarters in the heart of downtown Boise with a developmental office in Seattle, WA.
  • Business casual atmosphere in a flexible working environment
  • Team focused culture that promotes innovation and ownership
  • Access to cutting edge investment reporting technology and expertise
  • Continual learning, professional development and growth opportunities
  • Competitive salary and benefits package; including health, vision and dental
  • Additional benefits including PTO, 401(k) with 4% employer match

 

Apply for this Job

* Required
  
  
When autocomplete results are available use up and down arrows to review
+ Add Another Education


U.S. Equal Opportunity Employment Information (Completion is voluntary)

Individuals seeking employment at Clearwater Analytics are considered without regards to race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, gender identity, or sexual orientation. You are being given the opportunity to provide the following information in order to help us comply with federal and state Equal Employment Opportunity/Affirmative Action record keeping, reporting, and other legal requirements.

Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.


Form CC-305

OMB Control Number 1250-0005

Expires 05/31/2023

Voluntary Self-Identification of Disability

Why are you being asked to complete this form?

We are a federal contractor or subcontractor required by law to provide equal employment opportunity to qualified people with disabilities. We are also required to measure our progress toward having at least 7% of our workforce be individuals with disabilities. To do this, we must ask applicants and employees if they have a disability or have ever had a disability. Because a person may become disabled at any time, we ask all of our employees to update their information at least every five years.

Identifying yourself as an individual with a disability is voluntary, and we hope that you will choose to do so. Your answer will be maintained confidentially and not be seen by selecting officials or anyone else involved in making personnel decisions. Completing the form will not negatively impact you in any way, regardless of whether you have self-identified in the past. For more information about this form or the equal employment obligations of federal contractors under Section 503 of the Rehabilitation Act, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition.

Disabilities include, but are not limited to:

  • Autism
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, or HIV/AIDS
  • Blind or low vision
  • Cancer
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or hard of hearing
  • Depression or anxiety
  • Diabetes
  • Epilepsy
  • Gastrointestinal disorders, for example, Crohn's Disease, or irritable bowel syndrome
  • Intellectual disability
  • Missing limbs or partially missing limbs
  • Nervous system condition for example, migraine headaches, Parkinson’s disease, or Multiple sclerosis (MS)
  • Psychiatric condition, for example, bipolar disorder, schizophrenia, PTSD, or major depression

1Section 503 of the Rehabilitation Act of 1973, as amended. For more information about this form or the equal employment obligations of Federal contractors, visit the U.S. Department of Labor's Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.