What are the responsibilities and job description for the Database Architect position at Tri-Force Consulting Services, Inc.?
Title : Database Architect 4 (757035)
Location : RichmondVA 23219
Client : Virginia Information Technology Agency
Note : This is a hybrid position
Job Description :
- The Investment Decision Support team is seeking an experienced Senior ETL Developer with strong database programming and analytical skills to actively participate in the following scope of work :
Assist with overall ETL Support (development production support documentation) and other development efforts as needed. Activities may include :
ETL Production Support Monitor and maintain existing ETL processes.
Code Data Movement Provide support in the design development and implementation of ETL packages with SSIS.
Development SQL Development support to include creation of stored procedures views etc.
Performance Tuning Review existing SQL Queries Execution Plans Partitions and Index(s) to determine performance enhancements for long running queries.
Data Manipulation Provide alternative options to existing data manipulation techniques. Examples would be converting Excel manipulation activities into SSIS packages that reduce process / cycle time of data preparation.
Required Skills
7 years of experience in ETL SQL development
Experience with SQL Server Integration Services
Experience writing technical documentation (requirements process maps etc.)
Excellent communicator and be able to produce clear and concise documentation
Demonstrated experience working in a team environment
Demonstrated experience working independently with only high level guidance
Additional Preferred Skills
Experience with data governance best practices / procedures
Investment / financial market industry experience
If you are : bright motivated skilled a differencemaker able to get things done work with minimum direction
enthusiastic a thinker able to juggle and multitask communicate effectively and lead then
we would like to hear from you. We need exceptionally capable people for this role for our client
so get back to us and tell us why you think you are a fit.
About Us :
Since 2000 TriForce Consulting Services ( ) has been an MBE / SDB certified IT Consulting
firm in the Philadelphia region. TriForce specializes in IT staffing software development (web and mobile apps)
systems integration data analytics system automation cybersecurity and cloud technology solutions for government
and commercial clients. TriForce works with clients to overcome obstacles such as increasing productivity
increasing efficiencies through automation and lowering costs. Our clients benefit from our three distinguishing
core values : integrity diligence and technological excellence.
TriForce is a sixtime winner among the fastestgrowing companies in Philadelphia and a fourtime winner on the
Inc. 5000 list of the nations fastestgrowing companies.
7 years of experience in ETL SQL development Experience with SQL Server Integration Services Experience writing technical documentation (requirements, process maps, etc.)
Education
Bachelor's and / or Master s degree in computer science, IT or relevant degree.
Key Skills
Fund Management,Drafting,End User Support,Infrastructure,Airlines,Catia
Employment Type : Full Time
Experience : 5 years
Vacancy : 1
