Senior Database Engineer

Remote

Full Time

Senior Manager/Supervisor

Position: Senior Database Engineer
Department: Hosting Services (Platform)
Reports to: Director of Hosting Technology
Location: United States
Type: Full-time / Work-from-home
Functions: Information Technology
Compensation: $115,000 - $135,000
Open through: May 24, 2024

Tessitura is a nonprofit company dedicated to helping arts and cultural organizations thrive.

CRM lies at the heart of our mission and our technology platform. With Tessitura in their toolkit, organizations can achieve their goals with ease.

The Tessitura community includes over 800 cultural institutions in ten countries. Our staff provide 24/7 support and offer guidance to grow revenue and build lifelong engagement.

Job Summary
The Hosting Services (Platform) division maintains Tessitura Network's mission critical hosting environments for 600+ organizations world-wide. Under the direction of the Director of Hosting Technology, the Senior Database Engineer manages database infrastructure and services that support our customer-facing applications, taking ownership of data integrity, security, and performance. The Senior Database Engineer will design, implement, and maintain highly available large-scale cloud-based production database infrastructure. They will lead the design and evolution of Tessitura database infrastructure and will work with the Senior Database Administrator to actively develop, monitor, and improve the performance and reliability of database systems. They will work closely with systems engineers, application developers and other technical staff to optimize existing database architecture.

The successful candidate will have 5+ years experience or equivalent combination designing and administering multiple Microsoft SQL Server databases in a 24x7 enterprise production environment to include installing, configuring, monitoring, upgrading, and maintaining complex database systems. They bring an automation-first mindset and are proactive in identifying, recommending, and implementing strategies and solutions.

Specific Responsibilities:

Lead the design, implementation, and maintenance of highly available large-scale cloud-based production database and infrastructure
Own the strategic direction of platform database infrastructure, working closely with Platform, Software Engineering, and Product teams to ensure cloud-first, scalable solutions
In collaboration with Platform team and Senior Database Administrator, define and implement observability (alerting, metrics, monitoring) of database infrastructure and schema
Identify technical opportunities, solutions, and best practices and make recommendations to leadership and peers
Automate common database tasks to reduce toil and increase database reliability
Lead the development and revision of standard processes relating to staff and customer access, data retention, and development
Provide operational support and incident management for database functions
Maintain and troubleshoot database systems (primarily Microsoft SQL Server) in production, staging, and sandbox environments
Own the backup and recovery process for all production databases
Create, update, and audit documentation as required
Monitor, manage, and resolve escalated issues
Follow defined processes for incident and change management
Participate in on-call schedule
Travel two to three times per year for meetups and conferences as needed

Required Skills and Experience:

5+ years experience developing and maintaining highly available multi-tenant transactional Microsoft SQL Server databases in 24x7 enterprise environment, including server architecture, migration, performance tuning, backup, and recovery
Experience with Basic and Always On availability groups
Expertise in optimizing database performance at query, schema, and instance levels
Demonstrated experience in working with at least one scripting language such as PowerShell, Perl, Python, Ruby, etc. to automate manual tasks
Knowledge of database security and data privacy regulations
Understanding of underlying operating systems, storage and networking
Ability to lead cross-functional teams and communicate effectively with peers and upper management
Strong communication (written and verbal), organization, planning, leadership and management skills. Comfortable with presenting to all levels of management.

Preferred Skills:

Experience with multiple RDBMS (e.g. Microsoft SQL Server, MySQL, PostgreSQL, etc.)
AWS Cloud database experience, sch as Amazon RDS, Redshift or DynamoDB
Experience with Infrastructure as Code using CDK, CloudFormation, or Terraform
Experience converting single-tenant applications to multi-tenant
Experience mitigating from Microsoft SQL Server Standard to Microsoft SQL Server Enterprise
Knowledge of Microsoft SQL Server Licensing
Certifications in PostgreSQL, Microsoft SQL Server, or AWS

How to apply
Please apply by using the online form. If you have any questions or need assistance, please contact us at [email protected]

Our company is committed to building a team that represents a variety of backgrounds, perspectives, and skills, as well as providing a workplace of mutual respect, free of any discrimination of harassment. We seek to recruit, develop, and retain the most talented people from a diverse candidate pool.

Diversity, Equity, Accessibility, and Inclusion (DEAI) Commitment
At Tessitura, our mission is to enable arts and cultural organizations to achieve their goals. We recognize that having a diverse team is not only critical to our commitment to adopt equitable behaviors, it will also fuel collaboration, innovation and creativity as we deliver on our mission.

Creating an environment where everyone feels safe and comfortable in bringing their authentic selves to work is both our pledge and our passion.

Ultimately, providing an accessible and inclusive workplace will allow the Tessitura community to thrive.

Equal Opportunity
Tessitura is an equal opportunity employer and does not unlawfully discriminate against employees and applicants for employment based on race, color, sex, religion, national origin, citizenship status, age, genetic information, sexual orientation, creed, marital status, gender identity and expression, physical or mental disability of an otherwise qualified individual, membership or application for membership in a uniformed service, engaging in legally protected activity, or any other characteristic protected under applicable law. Tessitura also provides reasonable accommodations to applicants and employees in accordance with applicable law. Subject to its legitimate business requirements, Tessitura bases all personnel actions, such as recruitment, hiring, training, promotion, transfer, layoff, recall, compensation and benefits, discipline, termination, and educational, recreational, and social programs, solely on an individual’s qualifications, merit, and performance.

Apply for this position

Required*

Apply with

First Name*

Last Name*

Email Address*

Phone*

Address

Resume*

We've received your resume. Click here to update it.

Attach resume or Paste resume

Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

Cover Letter*

Are you 18 years of age or older?*

Earliest start date?

Tessitura Network is a fully distributed company and we rely heavily on written communication across our team and with our members. Candidates for every job must show us that they have good written communication skills. Therefore, a cover letter describing your skills and qualifications will be required and resumes without cover letters will be rejected.

Did you submit a cover letter above?* NoYes

How did you hear about this opportunity?*

I have the legal authorization to work in the U.S.* YesNo

Are you able to perform, with or without reasonable accommodation, the essential functions of the job or occupation for which you are applying?*

Tessitura is an equal opportunity employer and does not unlawfully discriminate against employees and applicants for employment based on race, color, sex, religion, national origin, citizenship status, age, genetic information, sexual orientation, creed, marital status, gender identity and expression, physical or mental disability of an otherwise qualified individual, membership or application for membership in a uniformed service, engaging in legally protected activity, or any other characteristic protected under applicable law. Tessitura also provides reasonable accommodations to applicants and employees in accordance with applicable law. Subject to its legitimate business requirements, Tessitura bases all personnel actions, such as recruitment, hiring, training, promotion, transfer, layoff, recall, compensation and benefits, discipline, termination, and educational, recreational, and social programs, solely on an individual’s qualifications, merit, and performance.* Acknowledged

I certify that all information provided by me in this application is true and complete to the best of my knowledge. I understand that any misstatement, omission, falsification, or factual misrepresentation in this application may disqualify me from consideration for employment or, if hired, may result in disciplinary action up to and including termination of employment.

I acknowledge and agree that this application is not a contract or a legal guarantee of employment. If hired by TESSITURA NETWORK, INC., I understand that my employment will be at will and not for any specific term, and that either I or TESSITURA NETWORK, INC. may terminate my employment at any time. with or without reason or advance notice. I further understand that no employee or representative of TESSITURA NETWORK, INC. (other than the CEO or other high-ranking official) has the authority to enter into any agreement for a specified period of employment, or to make any statement contrary to the provisions outlined above.

If hired, I agree to comply with all rules, regulations, and operating procedures established by TESSITURA NETWORK, INC.

I have read and fully understand the above statements and I seek employment under those conditions.*

The following questions are entirely optional.

To comply with government Equal Employment Opportunity and/or Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.

Gender

Race/Ethnicity

Human Check*

Submit Application

Thanks for visiting our Job Board. Our open positions are listed here.

Senior Database Engineer

Apply for this position