Overview
In this role you design, deploy and maintain high-availability, scalable databases across multi-regional environments. You ensure performance, security and 24×7 availability while coordinating upgrades, backups, and automation to support business-critical processes. You will work within IT Operations to manage D365 databases as a core system, with data warehousing and Power BI integration shaping reporting and analytics. This position offers growth in a rapidly expanding global team and a collaborative, outcomes-focused culture.
Responsibilities
- Design, deploy and support high-availability, scalable distributed databases for high-volume transactions
- Maintain data models, structures and procedures to ensure data integrity
- Lead D365 databases knowledge as a core system and support DWH usage for Power BI reporting
- Design, deploy and support SSIS packages
- ETL data between servers and data sources
- Optimize existing procedures and automate where possible
- Manage data warehouse changes and implementations
- Ensure performance, security and 24×7 availability of mission-critical databases
- Set up replication across geographically dispersed data centers
- Monitor resource usage, optimize and tweak as needed
- Follow change management processes
- Collaborate with teammates and business stakeholders
- Prepare clear documentation and coding standards
Key requirements
- Get-it-done attitude with ability to work in the weeds
- Team player with strong interpersonal skills
- Impeccable attention to detail
- Self-organised and able to meet deadlines without supervision
- Degree in Computer Science or equivalent
- D365 and/or Power BI experience
- Proficient with GIT, SVN
- 7+ years of SQL Server database administration experience
- Strong SQL Server management and shell scripting
- Experience creating and tuning database objects (tables, views, procedures, triggers)
- Knowledge of SQL Server 2012+
- Knowledge of HA and DR options for SQL Server
- Familiarity with standards and best practices in SQL Server
- Advanced T-SQL, stored procedures, SSIS and SSRS
- Ability to plan resource requirements from high-level specs
- Ability to work independently
- Experience with another DB technology (PostgreSQL, MySQL, ElasticSearch or Cassandra)
- Experience with Automation and Cloud DB management including migration
- Proficient with Windows and Linux OS
- team player
- attention to detail
- self-organization
- D365 databases
- Power BI
- SSIS
…
