Tasks
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.
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.
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.
At a Glance
Porsche is an equal opportunity employer and we take pride in our diversity. In order to provide equal employment and advancement opportunities to all individuals, employment decisions at Porsche will be based on merit, qualifications and abilities. Porsche does not discriminate in employment opportunities or practices on the basis of race, color, religion, sex, pregnancy, status as a parent, national origin, age, disability, family medical history, ancestry, medical condition, genetic information, sexual orientation, gender, gender identity, gender expression, marital status, familial status, registered domestic partner status, family and medical leave status, military status, criminal conviction history, or any other characteristic protected by federal, state or local law.
If you are an applicant from the state of California, please review the California Applicant Privacy Notice here.