Senior Database Developer

Seeking a Database Developer to assist in the design and maintenance of various databases develop and optimize ETL pipelines and workflows develop and optimize SQL scripts and stored procedures to support data conversion validation and ongoing processing needs.

At a high level the resource will develop maintain and optimize enterprise database solutions and will support data integration conversion migration reporting and database performance while ensuring the accuracy reliability and integrity of enterprise data. The resource will also provide production support and collaborate with cross-functional project teams throughout the system development lifecycle using Agile methodologies.

Job responsibilities

Design and maintain various databases including stored procedures indexing and data models.

Develop and optimize ETL pipelines and workflows using SSIS Python PySpark and SQL Server.

Execute large-scale data migrations including cleansing validation and transformation across enterprise systems.

Develop and optimize SQL scripts and stored procedures to support data conversion validation and ongoing processing needs.

Build data ingestion and transformation workflows across raw staging curated and analytics layers.

Build and maintain various reporting solutions using SSRS and PowerBI.

Design and implement logical and physical data models (ERDs) for various applications.

Develop stored procedures views SQL scripts and other database components supporting transactional and reporting systems.

Provide production support including troubleshooting performance issues and on-call support when needed.

Collaborate with cross-functional teams and participate in Agile ceremonies development activities code reviews and release cycles.

Provide knowledge transfer.

Desired Skills

10 years of experience in database development or data engineering.

Expertise in SQL Server T-SQL and performance tuning.

Experience with ETL tools (SSIS) Python or PySpark.

Strong background in data modeling and data integration.

Experience with reporting tools (SSRS PowerBI).

Working knowledge of DevOps tools such as Azure DevOps GitHub or Jenkins.

Experience supporting critical applications in financial government or legal industries.