Position overview
As a Database Engineer, you will be responsible for designing, implementing, and maintaining our data systems to ensure optimal performance, reliability, and scalability. You will collaborate closely with cross-functional teams to understand business requirements and translate them into effective database solutions. The ideal candidate will have a strong background in MS SQL, SSIS, Snowflake, and AWS, with a passion for innovation and a drive to excel in a fast-paced environment.
Roles & responsibilities
Database Design and Development:- Design, develop, and implement MS SQL databases to support business applications and processes.
- Utilize SSIS for ETL processes, including data extraction, transformation, and loading from various sources into the data warehouse.
- Develop and maintain data models to ensure efficient storage and retrieval of information.
- Optimize database performance by fine-tuning queries, indexing strategies, and database configurations.
- Deploy and manage database solutions on AWS, including EC2 instances, Glue, and S3 storage.
- Implement best practices for security, scalability, and disaster recovery in a cloud environment.
- Design and build data pipelines to integrate data from disparate sources into Snowflake data warehouse.
- Ensure data quality and consistency across all stages of the ETL process.
- Monitor database performance and proactively identify and resolve issues to minimize downtime.
- Implement backup and recovery strategies to safeguard data integrity and availability.
- Perform regular database maintenance tasks such as backups, restores, and integrity checks.
- Monitor database performance and identify areas for optimization.
Education: Bachelor's degree in computer science, Information Technology, Data Analytics, or related field.
Skills:
- 5+ years of experience in database engineering, with expertise in MS SQL Server, SSIS, Snowflake, and AWS.
- Strong SQL programming skills and proficiency in MS SQL Server database administration tasks.
- Experience with cloud-based technologies, particularly AWS services like EC2, Glue, and S3.
- Familiarity with data warehousing concepts and best practices. Knowledge of best practices and IT operations in an always-up, always-available service.
- Excellent problem-solving skills and ability to troubleshoot complex database issues.
- Strong communication and collaboration skills, with the ability to work effectively in a team environment.
Preferred Qualifications:
- AWS or Snowflake certifications.
- Experience implementing RESTful API's supporting system integrations.
- Familiarity with code repository solutions.
- Experience working with JIRA and Agile methodologies.
- Knowledge of scripting languages such as Python or PowerShell for automation tasks.
- Experience in the Automotive is a plus.
- Able to work in a global, multicultural environment.
- German language capability a plus.
Physical requirements
- Must be able to lift 15 pounds at times.
- While performing the duties of this job the employee is required to talk, hear, walk, sit, stand, climb stairs on occasion with prolonged periods of sitting at a desk and working on a computer.
- Must be able to effectively work and complete tasks in an open office/noisy environment.