Remote Senior SQL DBA

Insight Global
Burlington, United States of America
3 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Burlington, United States of America

Tech stack

Query Performance
Amazon Web Services (AWS)
Software as a Service
Cloud Computing
Computer Security
Databases
System Configuration
Relational Databases
Linux Servers
Microsoft SQL Server
Software Engineering
SQL Databases
Cloud Platform System
System Availability
Database Optimization
Database Performance
Low Latency
Performance Monitor

Job description

Within our Operations group, the Database Administration team is responsible for maintaining and administering the relational database components of HealthEdge's award winning SaaS solution hosted in our private cloud. The Performance DBA will work closely with our Engineering team to optimize the performance of our software., Throughout the development life cycle, collaborate with our product engineering teams to:

Advise as to data models that allow for efficient query execution

Analyze and optimize SQL statement execution plans

Optimize use of database resources and features

Analyze the effects of application changes on database performance, and make tuning recommendations

Ensure successful application and database implementations

Provide database expertise to project teams to maximize system availability, efficiency, and security

Monitor performance testing systems and perform in-depth diagnosis and troubleshooting of performance

Advise as to optimal OS and storage configuration of Linux servers to support SQL databases

Analyze database system and query performance, and perform triage and resolution, in response to performance-related product incidents

Support DBA utilities, reorgs, index builds, exports and imports, and DBA tools

Interact with key stakeholders including Cloud Operations, Information Security, Professional Services, and support teams for service request fulfilment, implementations, and operational support related to database services

Requirements

  • 10+ years of experience administering SQL databases
  • Proficiency in methodically troubleshooting complex issues
  • In-depth understanding of SQL internals -- memory pools, wait events, locks, latches, enqueues, etc.
  • Experience with AWS and working in enterprise level cloud environments
  • Proficiency in analyzing execution plans and tuning queries
  • Skilled in the process of data modeling designed for high throughput and low latency
  • Experience analyzing and optimizing database solutions for multi-terabyte databases.
  • Experience in Unix/Linux operating systems and understanding of optimal OS configuration (e.g. kernel parameters, IO subsystem) as relates to SQL Database
  • Hands-on experience in terms of planning, installing, configuring, maintaining and troubleshooting issues is a plus
  • Experience administering SQL Server Databases

Apply for this position