Database Engineer II at U.S. Renal Care

United States

<div> <p><span>USRC's greatest strength in being a leader in the dialysis industry is our ability to recognize and celebrate the differences in our diverse workforce. We strongly believe in recruiting top talent and creating a diverse and inclusive work climate and culture at all levels of our organization.</span></p> <p><span>SUMMARY</span></p> <p><span>The <strong>Database Engineer II</strong> partners closely with Production DBAs and application development teams to ensure databases are deployed to be secure, scalable, and performant. This role combines traditional DBA operational expertise with hands-on engineering skills, including data pipelines, performance analysis, query optimization, and refactoring database code to resolve systemic issues. This role requires the ability to support a hybrid database environment across on-premise and cloud solutions. This role also serves as the direct backup for the Production DBA, ensuring continuity of operations and coverage for production support activities.</span></p> <p> </p> <p><span>Essential Duties and Responsibilities include the following. Other duties and tasks may be assigned.</span></p> <p><span>Database Platform Engineering &amp; Administration</span></p> <ul> <li><span>Design and support database deployments across enterprise architectures, from single-node systems with local storage to clustered and SAN-based platforms for HA/DR and scalability, and also cloud hosted (Azure) database solutions.</span></li> <li><span>Collaborate with IT and business stakeholders to plan upgrades, patches, and maintenance activities, including regression testing and coordinated downtime.</span></li> <li><span>Support cloud-based database solutions on Azure, including managed services, storage, performance features, and integrations with analytics or AI/ML workloads.</span></li> <li><span>Install, configure, patch, and maintain Microsoft SQL Server environments supporting multiple use cases (application databases, data lake, reporting, and custom development).</span></li> <li><span>Support environments across the SDLC (Development, UAT, Production) and integrate database changes into CI/CD pipelines.</span></li> <li><span>Manage database versioning and schema changes to ensure compatibility with applications and deployment workflows.</span></li> <li><span>Implement and enforce database security best practices, including access controls, encryption in transit and at rest, and compliance with organizational standards.</span></li> <li><span>Maintain expertise across multiple SQL Server versions, native tooling, and relevant third-party products.</span></li> </ul> <p><span>Production Support &amp; Operational Excellence</span></p> <ul> <li><span>Act as the primary backup for the Production DBA, providing full coverage for production database administration, incident response, and operational support.</span></li> <li><span>Perform proactive capacity planning to ensure database availability, growth readiness, and cost efficiency.</span></li> <li><span>Monitor database health and performance, identifying trends and systemic issues rather than only point-in-time failures.</span></li> <li><span>Leverage database monitoring and observability tools (e.g., Redgate Monitor, SentryOne) to diagnose performance issues, analyze workload behavior, and proactively identify risk.</span></li> <li><span>Partner with Production DBAs to provide escalation support for complex performance and stability issues.</span></li> <li><span>Troubleshoot issues spanning database engines, application workloads, and development tools.</span></li> <li><span>Participate in after-hours or weekend support for planned releases, maintenance, or critical incidents as needed.</span></li> <li><span>Design, implement, and validate backup, restore, and recovery strategies.</span></li> <li><span>Administer database objects including tables, indexes, views, stored procedures, functions, and replication technologies.</span></li> <li><span>Configure and maintain database replication solutions to ensure downstream systems and reporting databases remain synchronized.</span></li> <li><span>Manage database users, roles, and privileges in alignment with security and audit requirements.</span></li> </ul> <p><span>Development, Performance, &amp; Code Optimization</span></p> <ul> <li><span>Act as a database subject-matter expert for development teams during design, build, and release phases.</span></li> <li><span>Review database designs and T-SQL code for performance, scalability, maintainability, and adherence to standards.</span></li> <li><span>Identify inefficient queries, indexing strategies, and data access patterns using execution plans, DMVs, and performance metrics.</span></li> <li><span>Refactor and optimize T-SQL code to resolve performance bottlenecks and reduce operational risk in production.</span></li> <li><span>Perform impact analysis for schema and code changes, including data volume, execution cost, and concurrency considerations.</span></li> <li><span>Collaborate with developers and architects to influence application design decisions that affect database performance.</span></li> <li><span>Support release planning to ensure database changes are delivered safely with minimal production impact.</span></li> <li><span>Demonstrate strong proficiency in writing, analyzing, and tuning complex T-SQL, including stored procedures, functions, and set-based solutions.</span></li> </ul> <p><span>Standards, Collaboration, &amp; Professional Practices</span></p> <ul> <li><span>Actively promotes GUEST customer service standards; develops effective relationships at all levels of the organization.</span></li> <li><span>Help define and evolve database development standards that ensure integrity, security, performance, and long-term maintainability.</span></li> <li><span>Contribute to team-based problem solving and knowledge sharing; mentor developers and junior DBAs where appropriate.</span></li> <li><span>Perform all duties in accordance with company policies, procedures, and compliance requirements.</span></li> <li><span>Maintain regular, reliable attendance and availability consistent with operational responsibilities.</span></li> </ul> </div><div>Qualifications</div><p><span>Qualifications/Requirements:</span></p> <p><span>To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.</span></p> <p><span>Requirements include:</span></p> <ul> <li><span> S. in Information Technology, Computer Science or equivalent skills work experience</span></li> <li><span> 3+ years of hands-on SQL Server Relational modeling, database development and T-SQL scripting experience</span></li> <li><span> 3+ years working in SQL Server Database DDL, DML and concepts (table, triggers, views, procedures, functions, packages, ...), T-SQL languages Management Studio, Data extraction using SSIS, and Reports development using SSRS.</span></li> <li><span> 3+ years experience administering databases and backup solutions</span></li> <li><span> 3+ years Development experience using SSIS and SSRS Integration Services</span></li> <li><span> Experience with database version control through GITHUB</span></li> <li><span> Demonstrated technical excellence working to support scientific user base to engage in problem solving and finding proactive solutions</span></li> <li><span> Proven track record of leading database transformation and development project through to successful implementation</span></li> <li><span> Significant SQL Server database test development and performance tuning experience</span></li> <li><span>Proficiency in technical writing, documenting solutions, and communicating with clients and users.</span></li> </ul>