MS SQL Database Administrator (Hybrid) id-12169
Brief Description
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.
Other Jobs You May Be Interested In
Remote Data Entry, No Experience, $40/hr, Part-Time
Virtual Assistant, $45/hr, Remote, No Experience, Night Job
Entry-Level Remote Data Entry, $50/hr, Evening Job
Customer Support, No Degree, $40/hr, Remote, Weekend Job
Remote Phone Job, $42/hr, Part-Time, College Student Friendly
Virtual Assistant, $40/hr, Remote, No Degree, Night Job
Part-Time Data Entry, $45/hr, Remote, College Student Friendly
Remote Moderator, No Degree, $50/hr, Evening, Weekend Job
Remote Customer Support, $42/hr, Night Job, No Experience
Live Chat Support, $40/hr, Remote, Entry Level, Part-Time
Virtual Assistant, Remote, $42/hr, Weekend, No Experience
Remote Data Entry, $45/hr, No Degree, Night Shift
Part-Time Customer Support, $40/hr, Remote, College Student
Remote Live Chat, $50/hr, Part-Time, Evening/Night Job
Entry Level Phone Job, $42/hr, Remote, No Degree Required
Weekend Data Entry, $45/hr, Remote, No Experience
Remote Virtual Assistant, $40/hr, Evening, Part-Time Job
Remote Moderator, $42/hr, Part-Time, Weekend, No Degree
Data Entry, $45/hr, Remote, Night Shift, College Student Job
Phone Support, Remote, $50/hr, No Experience, Part-Time
Virtual Assistant, No Experience, $42/hr, Remote, Weekend
Remote Customer Support, $45/hr, Part-Time, College Student
Data Entry, Remote, $40/hr, Night Shift, No Degree
Evening Virtual Assistant, Remote, $45/hr, No Experience
Weekend Customer Support, $42/hr, Remote, College Student
Remote Data Entry, $50/hr, No Experience, Evening/Night Job
Remote Live Chat, $40/hr, Part-Time, No Degree Required
Virtual Assistant, $42/hr, Remote, Weekend, Entry Level
Remote Phone Support, $45/hr, Evening, No Experience Required
Data Entry, No Experience, $50/hr, Remote, College Student
Remote Moderator, $40/hr, Weekend, No Degree, Part-Time
Live Chat Support, Remote, $42/hr, Night Shift, College Student
Phone Job, $50/hr, Remote, No Degree, Part-Time, Weekend
Data Entry, $45/hr, Remote, Evening, No Experience Required
Virtual Assistant, No Experience, $42/hr, Remote, Part-Time
Remote Customer Support, $50/hr, Night Shift, No Degree
Remote Data Entry, $40/hr, College Student Friendly, Part-Time
Live Chat Support, $42/hr, Weekend, Remote, No Degree
Virtual Assistant, Remote, $45/hr, Evening, No Experience
Remote Phone Job, $50/hr, College Student, Night Shift
Remote Moderator, $42/hr, Weekend, No Experience Required
Data Entry, No Degree, $45/hr, Part-Time, Remote Job
Customer Support, $50/hr, Remote, Evening/Night Job, No Degree
Virtual Assistant, $42/hr, Remote, Weekend, No Degree
Remote Live Chat, $45/hr, College Student, No Experience
Remote Data Entry, $40/hr, Part-Time, No Degree Required
Phone Support, $50/hr, Weekend, Remote, No Experience
Virtual Assistant, $42/hr, Evening, Remote, No Degree
Remote Customer Support, $45/hr, No Experience, Part-Time
Data Entry, $50/hr, Night Job, No Degree, Remote
Remote Moderator, $40/hr, College Student Friendly, Part-Time
Virtual Assistant, Remote, $42/hr, Weekend, No Experience
Remote Phone Job, $45/hr, Part-Time, No Degree Required
Customer Support, $50/hr, Night Job, Remote, No Experience
Data Entry, Remote, $42/hr, Evening Job, No Degree
Live Chat Support, $45/hr, Weekend, Remote, College Student
Virtual Assistant, Remote, $50/hr, Part-Time, Night Shift
Data Entry, $40/hr, No Experience, Remote, Weekend Job
Remote Phone Job, $45/hr, No Degree, College Student Friendly
Customer Support, $42/hr, Remote, Evening, No Experience
Virtual Assistant, $50/hr, Weekend, No Degree, Remote
Remote Data Entry, $40/hr, Part-Time, College Student Job
Phone Support, Remote, $42/hr, Evening/Night Shift
Virtual Assistant, No Degree, $45/hr, Remote, Part-Time
Live Chat Support, $50/hr, Remote, No Experience Required
Remote Moderator, $42/hr, College Student, Weekend Job
Data Entry, $45/hr, Remote, Night Job, No Degree
Virtual Assistant, $50/hr, Remote, Part-Time, Evening Job
Remote Customer Support, $42/hr, Weekend, No Experience
Phone Job, $45/hr, Remote, Night Shift, No Degree
Remote Live Chat, $50/hr, College Student, No Experience
Data Entry, $40/hr, Part-Time, Remote, Weekend Job
Virtual Assistant, $42/hr, Remote, No Experience, Evening
Remote Phone Support, $45/hr, Night Job, College Student
Remote Moderator, $50/hr, No Degree, Weekend, Part-Time
Objectives
- 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.
Key Responsibilities
- 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.
Competencies
- 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.
