Sr. Database ConsultantContract (6+ months- could potentially go perm down the line)2-3 days/week remote2 days onsite will be the norm when they returnBoston - Preference for local candidates- can be 100% remoteInterview process: 2 rounds MAYBE 3ProjectWill be sharing the workload with the current Sr. DBA as they're going through a large Database projectHave a legacy accounting and trading platform been around for 15 years.Implemented new accounting platform Geneva accounting about 6 years agoNow they want to retire the OMS portion of the legacy system and implement EZE castleBecause of the organic growth within the firm, there are a lot of queries tied to the legacy systemsMoving to a Vendor agnostic architecture moving forward.Project falls into 4 bucketsCompleting Geneva accounting system implementationMoving reportingImplementing the new OMS only executionVendor Agnostic- building a data warehouse, collect from vendor/trading systems and expose to other parts of the firmMajority of the work within this position, helping with data work between systems and internal movesRetiring the old systemArchiving old dataUnplugging it etc.Have been making fairly good progress within those 4 buckets and have come up with various challenges.Increase to capacity internally in order to be able to move quicker specifically around DWH, but could also help figure out an archiving strategy/TechSQL Server 2016 primarilyFairly complex environment, Dev, QA and Prod all on different versions of SQL.Deployment process is fairly manualWould like to look at internal process, need someone who's been around the blockMust hit the ground running in a matter of weeks, not monthsExpert level T-SQLWould ideally like them to be able to read codeData Modeling tools: Visio is what they us, relate to diagrams- Visio experience would set them apartJira/Confluence for Tracking and documentationSVN for source controlFinancial services experience is a must