France - Remote
The job ad is older than 1 month and may no longer exist.
Job's description
Did you know that about 10% of all insurance payouts are flowing directly into the pockets of fraudsters? The future of insurance starts with Decisions Made Better.
Shift Technology harnesses the power of AI to enable the world’s leading insurance organizations to make better decisions. Our products automate and optimize decisions from underwriting to claims, resulting in increased operational efficiency, reduced costs, and superior customer experiences for millions of people around the globe.
Our culture is built on innovation, trust, and a drive to transform the insurance industry by imagining and innovating solutions that impact insurers and their customers - like you! We come from more than 40 different countries and cultures and together we are creating the future of insurance.
We are in search of a Senior Database Administrator, with some Data Engineering skills, to strengthen our Infrastructure team. This pivotal role involves managing around 500 SQL Server database instances (as a team), hosting several terabytes of data. The position also requires contributing to the development and enhancement of in-house tooling and database administration-related code.
We are seeking a seasoned professional with substantial database administration experience, particularly in high-volume, data-intensive environments, with strong proficiency in Microsoft Azure.
Responsibilities:
- Oversee the administration of SQL Server instances
- Develop and maintain T-SQL scripts for effective database management
- Utilize Powershell and Python for daily database operations
- Collaborate in the development and improvement of in-house DBA related tools
- Facilitate the migration of existing infrastructure to cloud-based solutions, particularly Microsoft Azure
- Partner with cross-functional teams to optimize system performance, capacity, reliability, and scalability
- Formulate and implement backup, recovery, and archiving strategies
- Monitor database performance, promptly identify, and rectify any issues
- Initiate and spearhead all SQL and NoSQL-related projects
- Manage SQL Server and ElasticSearch servers and instances
- Define, implement and automate technical standards for servers, instances, and databases
- Implement measures to boost quality and productivity after performance and resources monitoring
- Document database architecture
- Provide technical support for infrastructure and business application incidents
- Improve query performance through tuning, managing statistics, indexes, and partitioning
- Collaborate with the development team on data modeling
Qualifications:
- Minimum of 5 years of experience in database administration, ideally in a high-volume, data-intensive setting
- Proficient in SQL Server instance administration
- Experience in writing T-SQL scripts
- Solid expertise in Powershell and Python scripting languages
- Familiarity with cloud technologies, specifically Microsoft Azure
- Proven track record in developing in-house tools and DBA related code
- Comprehensive understanding of database structures, principles, theories, and practices
- Team player with the ability to collaborate effectively across departments
- Excellent communication skills in English
- Prior experience in data engineering in Azure is highly desirable
Preferred Skills:
- Experience with Azure Data Factory, Azure Synapse, and Azure Databricks would be a significant plus
RECRUITMENT PROCESS
#LI-RH1 #LI-REMOTE
Please note this position could be based anywhere in FRANCE or SPAIN.
To support our employees at every stage of their careers and lives, we provide a competitive total rewards and benefits package. Here are the global benefits we’d like to highlight:
Additional benefits may be offered by country - ask your recruiter for more information.
At Shift we strive to be a diverse and inclusive workforce. We hire and trust people without regard to race, color, religion, marital status, age, national or ethnic origin, physical or mental disability, medical condition, pregnancy, genetic information, gender identity or expression, sexual orientation, or other non-merit criteria.
Shift Technology is committed to providing reasonable accommodations for qualified individuals with disabilities in our application and employment process. Should you require accommodation, please email accommodation@shift-technology.com and we will work with you to meet your accessibility needs.
Shift Technology does not accept unsolicited CVs from recruiters or employment agencies in response to the Shift Technology Careers page or a Shift Technology social media post. Any unsolicited CVs, including those submitted directly to hiring managers, are deemed to be the property of Shift Technology.