Senior Database Developer (Remote)
Saint Paul, MN - USA
Job Summary
SYSCOM is seeking an experienced Senior Database Developer to join a large-scale modernization initiative supporting a major public sector organization. Youll work with complex enterprise databases data integration ETL pipelines and reporting solutions in a fully remote environment. This one-year consulting opportunity offers the chance to make a meaningful impact while collaborating with a highly skilled technical team. Extensions may be possible based on project needs.
As a Senior Database Developer you will design develop and maintain enterprise database solutions while supporting complex data integration migration reporting and performance optimization initiatives for our client. The Database Developer will develop stored procedures views SQL scripts and other database components supporting transactional and reporting systems. The Database Developer will also execute large-scale data migrations including cleansing validation and transformation across enterprise systems build data ingestion and transformation workflows across raw staging curated and analytics layers maintain various reporting solutions using SSRS and Power BI and design and implement logical and physical data models (ERDs) for various applications. The Database Developer will also provide production support including troubleshooting performance issues and on-call support and collaborate with cross-functional teams and participate in Agile ceremonies development activities code reviews and release cycles.
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 Duties and Responsibilities will include but are not limited to the following:
- 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.
- 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.
Work Location: The work is expected to be done remotely.
Duration: One (1) year contract with extensions possible.
SYSCOM Inc. provides specialized information technology resources that possess the requisite skills and capabilities to deliver enterprise level solutions that help our clients achieve their objectives. At SYSCOM we have a proven process that brings the best and brightest resources into our organization. Our teammates have excellent verbal and written communication skills as well as coordination and organization skills. The objective of our approach is to ensure a high level of customer satisfaction.
Headquartered in Baltimore Maryland SYSCOM Inc. is a US-based company whose mission is to create and deliver the right technology solutions by teaming with our customers to understand their business needs and empower them to achieve their goals. Since 1982 SYSCOM Inc. has been providing enterprise-wide solutions for a variety of private and public sector clients.
SYSCOM Inc. is an equal opportunity employer.
Required Experience:
Senior IC
About Company
Headquartered in Baltimore, Maryland, SYSCOM, Inc. is a US-based company whose mission is to create and deliver the right technology solutions, by teaming with our customers to understand their business needs and empower them to achieve their goals. Since 1982, SYSCOM, Inc. has been p ... View more