N-iX is looking for a Senior Database Engineer to join our team! Our customer is the European online car market with over 30 million monthly users, with a market presence in 18 countries. The company is now merging with a similar company in Canada and needs support on this way. As a Lead Data Engineer, you will play a pivotal role in shaping the future of online car markets and enhancing the user experience for millions of car buyers and sellers.
Requirements:
- 5+ years of experience in software engineering
- Expert level experience with Microsoft database development
- Experience with database administration
- PostgreSQL experience
- Extensive knowledge of SQL Server and Azure SQL with expertise in stored procedures, functions, queries, views, and triggers
- Cloud technology experience Azure and AWS
- SQL Administration experience: upgrades, disaster recovery
- Knowledge of Microsoft products including Azure Blob/Table storage, DocumentDB and Azure Data Factory
- Knowledgeable in SQL tools like SSRS & SSIS
- Strong experience with XML-based data design
- Working experience on high-traffic websites and databases, while leveraging techniques to enable performance availability, security, and monitoring
- Ability to deliver non-relational data stores when appropriate
- Able to conceptualize a technical solution and relay it to other team members and stakeholders.
- Experience in building unit, component, and integration tests and knowledge of how to use this as a system contract between other system end points
- Know how to work with source code management and delivery platforms like Github, Azure Dev Ops, and JIRA in a distributed team environment
- Some exposure to C# development(CLR functions), including an understanding of SOLID principles
- English - Upper-Intermediate+
- Ukrainian language Advanced or higher.
Responsibilities:
- Work during the Canadian time zone
- Design and develop elegant database solutions which are end-to end: from technical analysis and data implementation/architecture, through to unit testing, development, and integration testing.
- Create and maintain schema objects, including complex store procedures, indexes, triggers, and scripts.
- Participate in thorough code-reviews and use your eye for clean data structures to support maintenance and extensibility.
- Perform root cause analysis on defects, identify corrective action, and liaise with production support to resolve issues.
- Analyse query performance and perform index tuning.
- Administration of SQL databases including security, backup, restore, upgrades, auditing and replication.
- Work with the rest of the team to evaluate the suitability of 3rd party packages and solutions.
- Maintain continuous integration and continuous deployment for data apps, while keeping data environments synchronized.
- Participate in a paid on-call rotation schedule to respond to alerts, as well as prioritize system improvements identified as part of monitoring.
We offer:
- Flexible working format - remote, office-based or flexible
- A competitive salary and good compensation package
- Personalized career growth
- Professional development tools (mentorship program, tech talks and trainings, centers of excellence, and more)
- Active tech communities with regular knowledge sharing
- Education reimbursement
- Memorable anniversary presents
- Corporate events and team buildings
- Other location-specific benefits