Database Engineer II at U.S. Renal Care

, Ohio, United States -

Full Time

Start Date

Immediate

Expiry Date

23 Jun, 26

Salary

0.0

Posted On

25 Mar, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL Server, DBA, Data Pipelines, Query Optimization, T-SQL, Azure, CI/CD, Performance Analysis, Schema Management, Security Best Practices, Backup and Restore, Replication, SSIS, SSRS, GitHub, Capacity Planning

Industry

Hospitals and Health Care

Description

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

Responsibilities

This role involves partnering with Production DBAs and development teams to ensure secure, scalable, and performant database deployments, combining traditional DBA operations with hands-on engineering tasks like data pipeline management and query optimization. The engineer will also serve as the direct backup for the Production DBA, covering operational support and incident response for a hybrid on-premise and Azure cloud environment.