Senior Database Engineer

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.

Data Modeling and Optimization:

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.

Cloud Infrastructure Management:

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.

Data Integration and Warehousing:

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.

Monitoring and Maintenance:

Monitor database performance and proactively identify and resolve issues to minimize downtime.

Implement backup and recovery strategies to safeguard data integrity and availability.

Database Support:

Perform regular database maintenance tasks such as backups, restores, and integrity checks.

Monitor database performance and identify areas for optimization.

Qualifications:

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