Specialist Software Engineer - Database Engineer
Societe Generale
Responsibilities
Job Summary:
We are seeking a proficient and detail-oriented Database Developer to design, develop, and maintain database systems, implement data integrations, and support application teams with optimized SQL solutions. This role involves working with ETL processes, ensuring database performance and integrity, and supporting various business-critical systems and data flows.
---
Key Responsibilities:
@Database Development & Optimization
- Design, develop, and maintain SQL Server databases.
- Create and manage stored procedures, functions, triggers, and views.
- Optimize complex SQL queries to improve system performance.
- Develop common usage functions and procedures for application use.
@ETL and Data Integration
- Understand business data requirements and create data mapping documentation.
- Design and implement ETL packages for data ingestion and transformation.
- Integrate data from multiple sources
- Manage linked server integrations with system
@Database Operation and Maintenance
- Monitor and control storage across over 100 databases.
- Run maintenance scripts (e.g., index rebuilds, tempdb cleanup).
- Maintain and update ETL (SSIS) packages aligned with BackOffice/Satellite changes.
- Manage access permissions and ensure secure database access.
- Support version control and deployment of database objects.
@Developer & Application Support
- Work closely with development teams to provide SQL support and guidance.
- Assist with troubleshooting database-related issues in applications.
- Collaborate with application teams to implement database-level improvements.