MS SQL Database Administrator

Profisee is looking for a DBA and specialist in Microsoft SQL Server to provide advisory and support services to our engineering and SaaS ops teams before, during and, after product releases.

Profisee provides Microsoft-centric master data management (MDM) solutions and, in a time of exponential growth of corporate data, being able to monitor, analyze, and maintain database performance and stability is essential.

If you have a deep background in Microsoft SQL Server and understand how to make it perform and keep it performing, we have a great opportunity for you to grow and become a key member of our performance and stability engineering team.

Profisee takes great pride in delivering high quality software to our customers and with increasing growth in our customer base and shift to cloud-based deployments, maintaining stability and performance is of paramount importance.
\n

\n
Objectives
\n


* During the first 30 days, begin to learn the broader Profisee Platform which employes a microservices architecture that uses SQL Server as the central storage and data management for our MDM platform.

\n


* Within the first 60 days, get up-to-speed on our existing load, test automation systems and existing performance benchmarks and environments.

Become knowledgeable with the current state of continuous testing at Profisee.

During this time, you will work closely with our support and SaaS ops team on how we deploy, manage, and support databases across our various tenants within our SaaS solution.

Work collaboratively with members of our support and engineering teams to get versed in the types of issues the product faces in the real world.

\n


* By month 3, you will have gained an understanding of our core data management subsystem - the Common Data Platform (CDP) - and how we use it to manage dynamic database queries issued by our application services and external applications to read and write data to our platform.

\n


* In months 3 - 6, working with R&D Technical Leadership Team (TLT), you will begin to formulate a plan of attack for remediating identified issues within the CDP and database subsystem and shifting the process left to proactively help engineering avoid performance problems before product release rather than reactively addressing issues in the field.

\n


* Ongoing, you will be responsible for proactively reviewing product requirements and engineering designs to spot areas of database performance risks and make recommendations to our engineering teams avoid performance and stability risks and continue to look for ways to improve stability, scalability, and performance.

\n

\n
Key Responsibilities:
\n


* Bring expertise and guidance to our software engineers in writing high performance and secure dynamic SQL and help build tests that evaluate and vet approaches for solving complex data access challenges.

\n


* Provide feedback on database schema design and indexing strategies to enhance query performance.
...