Our Company:ISN was established in 2001 and is a global leader in contractor and supplier management.We work closely with a variety of householdname clients in the US Canada Europe Australia Latin America and the Middle East to connect them with safe and reliable contractors and suppliers and incorporate a level of due diligence in the contractor management process.
Job Summary: The SQL Engineer is responsible for writing efficient SQL code on the ISNetworld SQL Server databases. As a member of ISNs Product Development team the SQL Engineer will be exposed to hands on development of front end web pages in addition to writing SQL code. The position will also expose individuals to complete Software Development Life Cycle.
- Create complex queries on large data sets
- Reverse engineer existing SQL code data flow and logic
- Create stored procedures triggers functions and views
- Generate code to extract transform and load data
- Perform performance tuning of queries
- Develop and design database objects such as tables indexes constraints etc.
- Analyze query performance and identify improvement areas
- Work with development QA business teams and at times directly with customers
- Research and develop new ways to improve existing functionality
- Proactively analyze and bring forth ideas for continuous improvement
Requirements:
- Bachelors degree in Computer Science or related field from an accredited university and/or equivalent work experience
- Min 6 years experience writing SQL quires and procedures
- Recent 4 years in large OLTP environment
- Extensive Microsoft SQL server experience
- Proven experience in designing databases from scratch
- Ability to demonstrate optimizing quires during an interview
ISN Benefits*
- 100 companypaid monthly insurance premiumsfor employees and dependents
- Medical Dental Vision and Life Insurance
- Employee assistance program
- 4 retirement matching
- LongTerm & ShortTerm Disability Coverage
- Paid time off
- 01 year 15 day (prorated first year)
- 15 years 20 days
- 510 years 25 days
- 10 years 30 days
- Holidays 13 paid holidays
- Monthly cell phone reimbursement
- Complimentary parking space or monthly reimbursement for DART public transportation
- Teambuilding activities and events including quarterly kickoff meetings and community volunteer day
- Matching charitable gift program
- Professional development & training opportunities
- Wellness Program: Focuses on community financial mental nutrition physical and social health
- Business casual jeans allowed
*All benefits are subject to change with notice to the employee
Onsite Requirements:Employees must be within a commutable distance to the Dallas TX office and be willing to come into the office for required trainings events team activities and meetings.
- Day 13 Required to come onsite for key onboarding equipment set up and EDGE Training.
- At least 2 in office days per week for the first 90 days
- Ongoing Option to work remotely with at least one in office engagement required monthly (team collaboration day ISN event team event etc.. This is subject to change dependent upon business needs and the tasks associated with your role.
All job offers will be contingent on successful completion of a drug screen and background check.
ISN is an equal opportunity employer. All applicants will be considered for employment without attention to race color religion sex sexual orientation gender identity national origin veteran or disability status.
#LIDNP