- Implement, and maintain our Microsoft SQL Server databases, including schema design, data modeling, and ETL processes.
- Ensure the performance, security, and reliability of the database.
- Monitor database performance and identify areas for improvement.
- Perform proactive capacity and performance validations on multiple databases.
- Develop and implement backup, recovery and failover procedures.
- Review vulnerabilities, install patches, and develop implementation plans as applicable.
- Review and test failover scenarios.
- Experience with migrating on-prem instances to Azure SQL Server managed instances or Azure SQL Databases, is a plus.
- Troubleshoot and resolve database specific issues.
- Collaborate with other teams to ensure database integration with other systems.
- Stay up to date with the latest trends and technologies in database administration.
- Help identify areas of improvement across our technologies, utilizing robust knowledge of best practices.
- Identify areas of efficiency & consolidation to help limit database costs.
- Document all database technical debt and manage the backlog of documented items.
- Work alongside the architecture team to help improve database design standards.
- Bachelor's degree in Computer Science or related field.
- 5+ years of experience in database administration.
- Strong experience with Microsoft SQL Server, including T-SQL, SSIS, and SSRS.
- Experience with Azure preferred including Azure SQL Databases, managed instances, and SQL Server on Virtual Machines.
- Experience with database design and implementation.
- Experience with database performance tuning and optimization.
- Strong problem-solving and analytical skills.
- Excellent communication and collaboration skills.
- Experience with single and multi-tenant designs.
Kodiak Database Administrator - Atlanta, United States - Crowe
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 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
Key Responsibilities
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.
#LI-Hybrid
Our Benefits:
At Crowe, we know that great peopleare what makes a great firm. We value our people and offer employees a comprehensive benefits package. Learn more about what working at Crowe can mean for you
How You Can Grow:
We will nurture your talent in an inclusive culture that values diversity. You will have the chance to meet on a consistent basis with your Career Coach that will guide you in your career goals and aspirations. Learn more about where talent can prosper
More about Crowe:
Crowe ) is one of the largest public accounting, consulting and technology firms in the United States. Crowe uses its deep industry expertise to provide audit services to public and private entities while also helping clients reach their goals with tax, advisory, risk and performance services. Crowe is recognized by many organizations as one of the country's best places to work. Crowe serves clients worldwide as an independent member of Crowe Global, one of the largest global accounting networks in the world. The network consists of more than 200 independent accounting and advisory services firms in more than 130 countries around the world.
Crowe LLP provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
Crowe LLP does not accept unsolicited candidates, referrals or resumes from any staffing agency, recruiting service, sourcing entity or any other third-party paid service at any time. Any referrals, resumes or candidates submitted to Crowe, or any employee or owner of Crowe without a pre-existing agreement signed by both parties covering the submission will be considered the property of Crowe, and free of charge.