Porsche Cars North America
IT Database Engineer
Porsche Cars North America, Atlanta, Georgia, United States, 30383
TasksTasks
Position overviewAs 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 & responsibilitiesDatabase 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.
QualificationsQualifications
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 requirementsMust 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.
Position overviewAs 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 & responsibilitiesDatabase 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.
QualificationsQualifications
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 requirementsMust 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.