Remote SQL Server Application Performance DBA - 100% Remote

National General Insurance
Washington, DC
Dec 01, 2022
Dec 10, 2022
Full Time
Job Title/Position: Remote SQL Server Application Performance DBA ** NOTE: We are not looking for a standard SQL Server DBA, but a DBA that has application performance experience. This is a must have. Location: 100% Remote (preference given to East Coast candidates) Job Summary: The Remote SQL Server Application Performance DBA performs activities aimed at improving database performance and efficiency. The individual provides trending data on and makes recommendations for performance issues for application and database environments, ensuring stability, and also provide assessment of new or changed products. Key Responsibilities: Have a solid understanding of SQL Querying and DB Development/DesignDirects root cause analysis on complex incidents and leads the problem management discussions related to incidentsDevelops reports of overall health of the portfolio of databases, escalating substantive capacity utilization variations from forecast to managementAnalyzes trending data and provide performance recommendations addressing specific application/system performance issuesAuthors complex scripts and tutors other DBA's in scripting skill and usagesDesigns and implements code to support the DBMS environmentReviews and approves data modeling processes and DBMS specific requirements for basic and intermediate application database requirementsLeads logical data modeling processes for complex applications database requirements and converts logical data models into physical data modelsActs as client advocate, ensuring smooth implementation of application architecture and database standardsSupervisory Responsibilities: This job does not have supervisory duties Preferred Qualifications: Education and Experience Bachelor's Degree or equivalent5 or more years of related experienceCertificates, Licenses, Registrations NoneFunctional Skills Expert knowledge in database performance monitoring and tuning of multiple DBMSsSolid knowledge of multiple DB monitoring toolsBasic capacity planning analyses of volume metrics and trends for currently existing databases, based on resource utilization and projected business plansDemonstrates mastery of data modeling in practical applications of a difficult natureExpert knowledge of physical database designHas the ability to install software using vendor-supplied and company-developed proceduresDesired Skills SQL DM, SentryOne Plan Explorer, YellowBrick, Qlik Replicate (formerly Attunity), Python, PowerShell #LI-PJ1 #LI-Remote #Remote