Database Developer - SQL / SSIS / ETL Envision is seeking a Database Developer with expert level SQL / SSIS / ETL Developer skills for our 4–6-month remote role in Jefferson City, MO.NO C2C OR THIRD PARTIES ALLOWEDTop Skills
Develop and maintain ETL processes using Microsoft SSIS and SQL agent jobs, minimum of five years of experience.
SQL Server query and stored procedure development.
SQL Server query performance tuning.
Design of databases, including relationships, indexes, views, tables, and fields.
Develop and support complex stored procedures and custom functions.
Analyze, solve, and correct production issues and provide documentation.
Strong data investigation and problem-solving skills.
Knowledge of data warehousing, data architecture, and design concepts with practical experience in the implementation of these concepts.
SQL Server 2016/2019 or prior versions
Familiar with Azure DevOps.
Nice to Have:
Experience with developing and maintaining ETL jobs.
Additional details:
Must have the ability to work effectively in a team environment between technical and non-technical resources. This project resource will be updating complex, multi-faceted data mining and automated aggregation tasks to ensure compliance, stability, and efficiency. This is not limited to stored procedures, database jobs, and ETLs.
Role / ResponsibilitiesThis SQL Server database admin is more than admin - he/she is an expert in knowing ETL and SSIS package/job development, maintenance, and architecture for jobs/tasks communicating and working across multiple databases and environments.
We have emergent needs to re-architect and re-write some critical ETL processes that pull data from our source applications, and feed all of our supporting applications and mandatory reporting needs - driven by federal requirements, state statutes, and departmental and organizational policies.
This admin also is key in understanding what database design issues exists, and how those can be corrected to best create modern, stable, reliable, and consistent data, data flows, and data processes.
Further this person will create documentation, diagrams, and data/process flows that explain the ETLs.
This person will review existing ETLs to identify concerns and mitigate risks in new ETLs/SSIS packages. This person is collaborative, but open to feedback and understanding of business needs.
Additional Information
Envision, LLC is proud to be an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
There are currently no related jobs. Please sign up for Job Alerts.
Loading...
Login to save this search and get notified of similar positions.
About Jefferson City, MO
Explore exciting job opportunities around Jefferson City, Missouri! This charming city, nestled along the majestic Missouri River, offers a unique blend of history, culture, and growth for job seekers. Known for its stunning State Capitol building and vibrant arts scene, Jefferson City boasts a plethora of opportunities for career advancement in state government, healthcare, education, and more. With delicious local cuisine, fascinating art galleries like the Capital Arts Gallery, and outdoor adventures in nearby Binder Park, Jefferson City is an inviting place to live and work. Don't miss the chance to be a part of this thriving community – browse our job listings today and start your journey towards a rewarding career in this enchanting region.
Are you sure you want to apply for this job?
Please take a moment to verify your personal information and resume are up-to-date before you apply.
