Database Engineer

Why Renovo?

Renovo Solutions is a nationwide healthcare technology management company. We offer a range of opportunities for technicians to grow within the company. With a presence in 40+ states, we provide comprehensive solutions for managing & maintaining healthcare technologies. We prioritize investing in our employees' development, offering various phases and advancement paths. Through ongoing training, mentorship programs, and a supportive work environment, we foster professional growth and promote from within. Join our team to make a difference in healthcare while advancing your career with Renovo.

Summary:

The 'Database Engineer' will work cross-functionally with all IT teams to implement database changes and ensure data availability, reliability, and performance across a modern data architecture - including application databases and data services, data lakes, and data delivery pipelines.

What you will do:

In this role, you will be tasked with implementing database changes required for software development activities, troubleshooting data related issues, and optimization processes. This will involve staying abreast of the latest advancements in database technologies and tools and proactively identifying opportunities where these innovations can be leveraged to enhance our existing code or infrastructure. Regular activities include planning, coordinating, and executing the necessary steps to seamlessly integrate changes into our current environment, while minimizing disruptions and ensuring data integrity.

Day to Day activities:

• Modify and maintain existing and future source databases including the databases for multiple in-house applications with direction or request from software development and end users
• Analyze database activity and usage and to improve database performance or correct errors
• Develop automation processes to eliminate routine manual tasks
• Codevelop tools to empower end users to make bulk data changes with appropriate governance
• Maintain systems intended for change data capture such as Microsoft SQL Server CDC or similar
• Work with the cloud infrastructure team on delivering cloud native database and data platform technologies including setup, maintenance, access control and governance, disaster recovery, and more
• Develop processes and procedures related to data development and delivery including diagrams and written documentation
• Resolve data related issues and tickets escalated from application support including report and dashboard modifications, backend data import/export, data corrections, and other support duties as assigned according to SLAs and business requirements
• Work alongside other data focused team members for the purpose of delivering data required to drive AI and machine learning workloads

Qualifications:

• Experience with Microsoft SSRS, Quick Sight, and Power BI
• Ability to work with Microsoft SQL Server databases with the purpose of optimizing performance, modifying stored procedures, and working with software development to analyze queries from ORMs for performance or other reasons
• Strong understanding of change data capture strategies and relation technologies, especially SQL Server CDC
• Proven ability to work with cloud native databases, data warehouse, data lake, and data platform technologies like AWS RDS, Databricks, AWS Aurora, and AWS S3
• Experience presenting technical problems, especially data related problems, in a fashion easily consumed by non-technical audiences
• Proven knowledge of schema migration or database change management tooling with Microsoft SQL Server and Postgres
• Ability to work autonomously and utilize ticketing tools like Jira or similar to document and deliver work according to guidelines based on agile practices
• Understanding of data collection, cleanup, and usage for the purposes of machine learning or AI driven applications

Education/Special Training:

• H.S. Diploma or equivalent required
• Computer-related bachelor's degree or equivalent data platform engineering experience
• Technical certifications that demonstrate the skills listed above such as cloud professional or specialty certifications (preferably AWS), data platform certifications (such as DataBricks), or other applicable certifications

Required Competencies:

• Accountability - takes ownership of assigned work and responsibilities, follows through, and closes the loop
• Communication - clearly expresses thoughts and ideas both in written and verbal communications, provides timely information
• Financial Acumen - Considers financial impact of all decisions
• Integrity - Can admit mistakes, is direct and truthful
• Customer Service - demonstrates a "customer-first" mentality, focused on meeting the needs of customers and captures feedback to make improvements
• Priority Setting - Prioritizes assigned schedules and workload
• Team Building - Mentors newer technicians, facilitates clear communication amongst the team, demonstrates care and respect for co-workers and colleagues
• Giving Feedback - Provides constructive feedback towards department goals and activities, helps to foster growth within the team

Safety Requirements:

• Abide and follow our Injury & Illness Prevention Program
• On time completion of safety trainings assignments

Physical Requirements:

• The Data Platform Engineer must be able to speak, hear, see, read, write, type, dial, reach, and bend. Lift 50 lbs.

Classification:

FLSA: Exempt

Note: This position description does not list every activity, duty, and responsibility of the position and may be altered by RENOVO at any time.

EEO Statement

RENOVO Solutions provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, RENOVO Solutions complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.