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. \nIn 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. \nOngoing, 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 : \nBring 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. \nProvide feedback on database schema design and indexing strategies to enhance query performance. \nWork closely with our support team, SaaS ops team, consultants, partners, and customers to advise on database-related issues and approaches during customer implementations. \nAnalyze query execution plans and recommend optimizations. \nPerform database performance tuning, indexing, and query optimization as a broader part of ongoing performance analysis and benchmarking. \nParticipate in building and maintaining our continuous performance testing infrastructure and help to minimize time and cost associated with running performance and benchmarking tests. \nAssist in preparing and developing high availability and disaster recovery readiness of database systems. \nAct as a bridge between engineering, operations, and customer support and success teams on database-related topics and issues. \nDocument best practices for SQL usage and database management. \n \n Competencies : \nA bachelor's degree in Computer Science or like engineering disciplines or equivalent experience. \nAt least 4-7 years of experience in database administration or similar role. \nExperience with on-premise and cloud-based deployments of SQL Server (Azure, RDS, GCP). \nExpertise in SQL Server security best practices. \nSolid TSQL programming experience. \nAbility to analyze and interpret database query plans and to tune and optimize database performance. \nFamiliarity with performance monitoring tools (e.g., SQL Server Management Studio, Azure Monitor). \nSkilled troubleshooter, experienced with analyzing and isolating complex problems to a series of repeatable steps. \nExperience with Azure Data Factory (ADF) and / or SSIS a plus. \nC# and .NET programming skills a plus. \nStrong skills in Microsoft Office with exceptionally strong skills in Excel (for analysis) and PowerPoint (for content preparation). \nHave a customer-focused demeanor. \nAbility to explain technical concepts to non-technical stakeholders and effective collaboration with cross-functional teams. \n
