Senior Database Engineer

About the job

Global and innovative, Fortune 100 company headquartered in Atlanta, GA is searching for a Database Engineer to join their team! 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

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

Implement backup and recovery strategies to safeguard data integrity and availability

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