Remote SQL Server Application Performance DBA (PostgreSQL) - 100% Remote in Washington, DC at National General Insurance

Job Description

Job Title/Position: Remote SQL Server Application Performance DBA (with PostgreSQL experience)

** 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.  Ideal candidate will have at least one year of experience with PostgreSQL.

Key Responsibilities:

• Have a solid understanding of SQL Querying and DB Development/Design
• Directs root cause analysis on complex incidents and leads the problem management discussions related to incidents
• Have a good understanding of PostgreSQL and able to diagnose PostgreSQL performance issues
• Have a good understanding of PowerShell
• Develops reports of overall health of the portfolio of databases, escalating substantive capacity utilization variations from forecast to management
• Analyzes trending data and provide performance recommendations addressing specific application/system performance issues
• Authors complex scripts and tutors other DBA’s in scripting skill and usages
• Designs and implements code to support the DBMS environment
• Reviews and approves data modeling processes and DBMS specific requirements for basic and intermediate application database requirements
• Leads logical data modeling processes for complex applications database requirements and converts logical data models into physical data models
• Acts as client advocate, ensuring smooth implementation of application architecture and database standards

Supervisory Responsibilities:

This job does not have supervisory duties

Preferred Qualifications:

Education and Experience

• Bachelor’s Degree or equivalent
• 5 or more years of related experience  

Certificates, Licenses, Registrations

• None

Functional Skills

• Have a good understanding of PostgreSQL and able to diagnose PostgreSQL performance issues
• Have a good understanding of PowerShell
• Expert knowledge in database performance monitoring and tuning of multiple DBMSs
• Solid knowledge of multiple DB monitoring tools
• Basic capacity planning analyses of volume metrics and trends for currently existing databases, based on resource utilization and projected business plans
• Demonstrates mastery of data modeling in practical applications of a difficult nature
• Expert knowledge of physical database design
• Has the ability to install software using vendor-supplied and company-developed procedures

Desired Skills

SQL DM, SentryOne Plan Explorer, YellowBrick, Qlik Replicate (formerly Attunity), Python, PowerShell

#LI-PJ1

#LI-Remote

#Remote

National General prides itself on offering our employees a robust Total Rewards package which includes base salary.  The base range offered for the role is: $82,000-$110,000 and may vary based on internal equity, and job-related skills, knowledge and experience; among other factors.  Other financial components may be added as part of the competitive compensation package, in addition to a full range of benefits, dependent on the level and position offered.

National General Holdings Corp. is an Equal Opportunity (EO) employer – Veterans/Disabled and other protected categories. All qualified applicants will receive consideration for employment regardless of any characteristic protected by law. Candidates must possess authorization to work in the United States, as it is not our practice to sponsor individuals for work visas.

In the event you need assistance or accommodation in completing your online application, please contact NGIC main office by phone at (336) 435-2000.