Database Engineer
Where
- Hillsboro, OR
What you'll be doing
- Perform extensive analysis of database entities, relationships and attributes. Participate in both data design and data processing sessions for assigned projects and teams. Create migration/conversion designs that meet the projects business, system and data requirements. Create written data migration/conversion plans and data file/data model specifications that meet the projects business, system and data requirements. Reverse engineer existing migration/conversion processes and data models including designing and utilizing microsoft SQL server profiler traces. Design and develop ETL processes using transact-SQL and microsoft SQL server integration services. Optimize ETL processes and T-SQL code performance using microsoft SQL server best practices and query/index/table performance tuning. Research and review data for presentation, accuracy and compliance within the business/system needs. Review with team members/client and other database engineers the content, accuracy and completeness of data models, file specifications and migration/conversion processes. Communicate and collaborate with client management and client data specialists in the design and delivery of data migration/conversion processes. Respond to data design and data processing problems and find solutions in a timely manner. Identify appropriate resources and work with them to research and resolve any open data-related issues. Mentor staff by reviewing deliverables and offering team assistance whenever needed.
What your background should be
- Minimum four (4) years of technical expertise in database and ETL development with microsoft SQL server primarily T-SQL and DTS/SSIS. Extensive development experience in analysis, modeling and design of database solutions. Technical understanding of network, PC, and platform operating systems, including microsoft windows server 2003/2008/2012. Technical understanding of the different phases of the software development life cycle. Strong understanding of relational database structures, theories, principles, and practices.
Required Schooling / Training
- Bachelor degree in computer science, information technology
Who is the client company
- A provider of financial services technology.
- If you are interested in this position, send your resume to apply@kochdavis.com