About Rainmaker

Rainmaker Business Technologies provides Software Products and Consultancy to the Airline industry in Europe, North America, Middle East and Asia and is widely regarded as the industry leader in the field of airline operations and cost management. We are currently seeking to recruit an experienced Database Developer for a permanent position.

Job Summary

Rainmaker is looking for an experienced Database Developer to join our team. The role provides a fantastic opportunity to join a supportive and collaborative work environment with great opportunities for growth and development. The successful candidate will be responsible for designing, developing, and maintaining our SQL Server databases and ensuring the integrity, availability, and security of our data. In addition, the role will involve supporting ETL processes. The ideal candidate will have excellent T-SQL skills, database design and experience with various integration patterns and tools. This role will also provide an excellent opportunity to join a cross functional engineering team utilising the cloud and the latest technologies and techniques.

Key Responsibilities

• Design, develop, and maintain databases, including schema design, indexing, and optimization
• Develop, maintain and support ETL processes to extract, transform, and load data from various sources
• Collaborate with cross-functional teams to identify and prioritize data requirements
• Ensure data integrity, availability, and security through backups, disaster recovery, and security measures
• Troubleshoot and resolve database and ETL-related issues
• Develop and maintain documentation for database and ETL processes
• Keep up-to-date with emerging trends and technologies in database and ETL development to support the company in its Azure Cloud migration project.

Desired Skills & Experience

• Minimum 2 years’ experience in enterprise MS SQL database development & design
• Strong T-SQL skills – creating and maintaining views, functions and stored procedures that are highly optimized
• Enterprise experience with MS SSIS
• Basic database administration skills – maintaining data quality and overseeing database integrity and security
• Knowledge and experience in the latest integration design methodologies
• Strong interpersonal & communication skills; both verbal and written
• Ability to work on own initiative or in a team
• Experience working with the latest versions of SQL Server

Other Desirable Experience & Skills

The following would be beneficial but not necessary:

• Experience and Interest in automating manual processes
• Experience with SQL Server Analysis Services, OLAP Cubes & the MDX Query Language
• Experience with Reporting and Business Intelligence tools
• Data warehouse design and development experience is a nice to have
• Experience with Azure SQL
• Microsoft SQL Certifications

Working Conditions

• Full-time position, working hours are flexible
• Office-based in Dublin with the possibility of remote work
• Occasional travel may be required

Compensation

• Salary range: €50,000-€70,000 per annum (commensurate with experience)
• Income Protection
• Death In Service Benefit
• Flexible work arrangements
• Hybrid or remote working options