Company DescriptionInfotree's approach to every employee and customer is based around making a positive impact. We focus on over-servicing, continuous improvement and a high-quality culture. We're passionate about making successful matches for our employees and customers across the globe. Infotree prides itself in our proven track record and innovative culture with 100% focus on the employees and customersJob DescriptionONLY W2If interested, Please directly reach out to me at [email protected] or .Position Title Senior Database EngineerLocation Louisville, KY (Remote)Duration 03+ Months Job Description:SHORT TERM ASSIGNMENT UNTIL 1/1/2021, OPPORTUNITY TO BE EXTENDED BUT CANNOT BE GUARANTEEDLOCATION: WAHSchedule: Monday-Friday, 8am-5pm ESTThis candidate will be working with the Enterprise Shared Services-Business Intelligence department at Humana. One of their core objectives is to assess services being used within various departments across the enterprise.Notes from Hiring Leader:The candidate will be cleaning up code, must have a strong understanding of different databases, process improvement and SQL.Responsibilities:- Assist with shutdown of remaining CCP jobs.- Review/Overhaul/Reschedule CRM jobs to ensure accuracy prior to OE.- Assist with cleaning up/removing old tables/sprocs/views.- Export old data off the server as needed for temporary network drive retention.- Review all ETLs to validate code updates aren't needed. If items are being filtered in the ETL document why.- Source to Server Field Format/Naming Validations. This is part of the initial design plans where we want to try to match the source system field names/field formats. Reduces chances of job failures or data changes from source to ETL. Makes it easier to document jobs if field names match the source system names.- Redesign daily job check and build in loops to jobs to ETLs to handle late finishes by IT.- Using source ETL documentation add a second daily job run to catch CRM data from the second run.- Coordinate with reporting team to ensure all views are documented and any server views they need are built/available.- Create a second ESS only view group to limit select server views to the reports team so they arent visible to other teams to replicate our work with.- Assist with monthly server security audits.Required Skills:- SQL- SQL Database- SSIS- SQL Query/Server/Index Optimization- ETL End to End Job Mapping- Metadata- Humana Data and System Knowledge- Redgate KnowledgeThanks & Regards,Kajal VermaTechnical Recruiter(: Infotree Global Solutions*: [email protected] LinkedIn: Mailing Address: 215 Ann Arbor Rd, Suite 304, Plymouth, MI 48170 Additional InformationAll your information will be kept confidential according to EEO guidelines.