at Crowe LLP in Chicago, Illinois, United States
Job Description
Your Journey at Crowe Starts Here:
At Crowe, you have the opportunity to deliver innovative solutions to today's complex business issues. Crowe's accounting, consulting, and technology personnel are widely recognized for their in-depth expertise and understanding of sophisticated process frameworks and enabling technologies, along with their commitment to delivering measurable results that help clients build business value. Our focus on emerging technology solutions along with our commitment to internal career growth and exceptional client value has resulted in a firm that is routinely recognized as a "Best Place to Work." We are 75 years strong and still growing. Come grow with us!
Job Description:Database Administrator (SQL Server)
About the Role
We are seeking a highly skilled and experienced Database Administrator to join our team. The ideal candidate will have a strong background in database administration, with a specialization in Microsoft SQL Server.
A successful candidate will be responsible for the design, implementation, monitoring and maintenance of our SQL Server databases, ensuring its performance, security, and reliability. This role will work closely with our product teams to help identify areas of improvement, and to help our applications best grow to align with industry best practices. The hired candidate will be responsible for proactively managing our database instances rather than only supporting the databases.
About Kodiak Solutions
This is an exciting time to join our growing Kodiak Solutions team!Recently, Crowe LLP reached a decision to divest its Crowe Healthcare Consulting practice, now Kodiak, in a sale to TPG, a global asset management firm that will be the perfect partner to take Kodiak to the next level.The story around Kodiak is an impressive one.Derek Bang, the practice founder and inventor of the group's flagship software product for net revenue reporting, Revenue Cycle Analytics (RCA) came to Crowe nearly 20 years ago with an idea for a strategic pursuit in the Healthcare Industry through his previous experience as a Healthcare Auditor at a Big 4 firm.Crowe invested in the idea, providing the resources and support necessary to launch the RCA product and organically grow the practice to its current state, now offering a broad suite of software and services that help healthcare CFOs solve challenges across financial reporting, revenue cycle, and risk and compliance.Kodiak currently services more than 1,800 hospitals and 200,000 practice-based physicians across all 50 states. Due to the unique complexities of the business such as technology and data security, it is time for a new partner with the appropriate expertise and resources to invest in the future growth of Kodiak.The transaction will enable Kodiak to operate with greater flexibility and focus, positioning it to accelerate growth and expand its technology portfolio to better serve healthcare provider organizations across the county.About the Role
We are seeking a highly skilled and experienced Database Administrator to join our team. The ideal candidate will have a strong background in database administration, with a specialization in Snowflake.
A successful candidate will be responsible for the design, implementation, monitoring and maintenance of our Snowflake databases and warehouses, ensuring its performance, security, and reliability. This role will work closely with our product teams to help identify areas of improvement, and to help our applications best grow to align with industry best practices.Key Responsibilities
Administer, maintain, and support the Snowflake data warehouse environment, including data storage, data transfers, and computing resources to ensure optimal performance and efficiency.
Ensure the performance, security, and reliability of the database.
Troubleshoot and resolve database issues.
Collaborate with other teams to ensure database integration with other systems.
Contribute to RBAC and row level security best practices.
Design and implement role hierarchies.
Implement and manage secure access controls, roles, and permissions to safeguard sensitive data and comply with regulatory requirements.
Monitor and optimize query performance, identifying and resolving bottlenecks in the data loading processes and SQL queries.
Analyze execution plans and provide feedback to development teams.
Coordinate with Snowflake support for issue resolution, upgrades, and new feature implementations.
Manage data retention policies and perform data lifecycle management to optimize storage costs and compliance.
Lead disaster recovery planning and execution, ensuring data availability and business continuity.
Stay updated with the latest industry trends and advancements in cloud data warehousing technologies, applying new features and improvements to the Snowflake environment.
Qualifications/Requirements
Bachelor's... For full info follow application link.
EOE M/F/D/V