Senior System Operation Expert - Digital Sales (Data Engineer Expert) - SQL Server, PostgreSQL

Database Administration:

• Design, implement, and maintain complex database systems (e.g., Oracle, MySQL, PostgreSQL).
• Ensure high levels of performance, availability, and security of databases.
• Perform regular database maintenance, backups, and disaster recovery planning.
• Monitor database performance, implement changes, and apply new patches and versions when required.
• Manage database security and permissions.

ETL Development:

• Design, develop, and optimize ETL processes to extract, transform, and load data from various sources into data warehouses.
• Analysts to understand data requirements and translate them into robust ETL workflows.
• Ensure data integrity, quality, and consistency across different data sources and destinations.
• Implement best practices for ETL process design, development, and deployment.
• Performance Tuning and Optimization:
• Analyse and resolve database performance issues.
• Optimize SQL queries and ETL processes for efficiency and speed.
• Implement indexing, partitioning, and other optimization techniques to enhance database performance.

Documentation and Compliance:

• Create and maintain detailed documentation of database configurations, ETL processes, and data workflows.
• Ensure compliance with data governance and security policies.
• Implement and enforce data privacy and security measures.