MS SQL Database Administrator (Finance)
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.
- 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.
- 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.
- 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.
- 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
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.
- Provide feedback on database schema design and indexing strategies to enhance query performance.
- Work closely with our support team, SaaS ops team, consultants, partners, and customers to advise on database-related issues and approaches during customer implementations.
- Analyze query execution plans and recommend optimizations.
- Perform database performance tuning, indexing, and query optimization as a broader part of ongoing performance analysis and benchmarking.
- Participate in building and maintaining our continuous performance testing infrastructure and help to minimize time and cost associated with running performance and benchmarking tests.
- Assist in preparing and developing high availability and disaster recovery readiness of database systems.
- Act as a bridge between engineering, operations, and customer support and success teams on database-related topics and issues.
- Document best practices for SQL usage and database management.
\n
Competencies:
\n
- A bachelor's degree in Computer Science or like engineering disciplines or equivalent experience.
- At least 4-7 years of experience in database administration or similar role.
- Experience with on-premise and cloud-based deployments of SQL Server (Azure, RDS, GCP).
- Expertise in SQL Server security best practices.
- Solid TSQL programming experience.
- Ability to analyze and interpret database query plans and to tune and optimize database performance.
- Familiarity with performance monitoring tools (e.g., SQL Server Management Studio, Azure Monitor).
- Skilled troubleshooter, experienced with analyzing and isolating complex problems to a series of repeatable steps.
- Experience with Azure Data Factory (ADF) and/or SSIS a plus.
- C# and .NET programming skills a plus.
- Strong skills in Microsoft Office with exceptionally strong skills in Excel (for analysis) and PowerPoint (for content preparation).
- Have a customer-focused demeanor.
- Ability to explain technical concepts to non-technical stakeholders and effective collaboration with cross-functional teams.
