Remote Senior SQL DBA
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.
Responsibilities
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 We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to ~~~ learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: ~~~/. Skills and 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