Senior SQL Developer

ISN Software Corporation

$100K — $130K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 6+ years of experience using T-SQL programming for complex queries, stored procedures, and functions.
  • 4 years of experience working in a large OLTP environment.
  • Extensive experience with Microsoft SQL Server as a database platform.
  • Proven track record in designing databases from inception to deployment.
  • Solid knowledge in performance tuning, query optimization, and data analysis.

Responsibilities

  • Create complex queries to extract insights from large data sets.
  • Reverse engineer existing SQL code and analyze data flow for improvements.
  • Perform performance tuning and optimization on critical queries.
  • Develop and design essential database objects like tables and indexes.
  • Analyze query performance and strategize improvements based on findings.
  • Collaborate with development, QA, and business teams, as well as interact directly with customers.
  • Leverage AI-powered tools and automation to enhance productivity throughout the Software Development Life Cycle.

Benefits

  • 100% company-paid health, dental, vision, and life insurance premiums for employees and their dependents.
  • Employee assistance program for mental health and wellness support.
  • 4% matching contribution for retirement plans.
  • Generous paid time off policy that increases with tenure, up to 30 days.
  • 13 paid holidays each year for work-life balance.
  • Reimbursed monthly cell phone expenses and transportation costs.
  • Engagement in team-building activities and community service initiatives.
  • Professional development opportunities to support career advancement.
Full Job Description
Job Summary: As a member of ISN's Product Development team, the Senior SQL Developer is responsible for writing efficient SQL code on the ISNetworld SQL Server databases. The position will also expose individuals to complete Software Development Life Cycle.

Who should apply?
  • 6+ years' experience in using T-SQL programming language, including writing queries, stored procedures, and functions
  • 4 years' experience in large OLTP environment
  • Extensive Microsoft SQL server experience
  • Proven experience in designing databases from scratch
  • Experience with database design, performance tuning, query optimization, indexes, data migration tools, and data analysis
  • Bachelor's degree in Computer Science or related field from an accredited university and/or equivalent work experience

Primary Duties & Responsibilities:
  • Create complex queries on large data sets
  • Reverse engineer existing SQL code, data flow and logic
  • 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
  • Effectively leverage approved AI-powered tools and automation to enhance productivity across daily work activities and applicable Software Development Life Cycle elements -such as requirements, design, development, testing, deployment, and /or operations.

Office Address: 3232 McKinney Ave # 1500, Dallas, TX 75204
  • Employees must be within a commutable distance to the Dallas, TX office. Relocation is required for candidates not already local to the DFW area.
  • In-person attendance is required at minimum 2 days per week during the first 90 days of employment.
  • After 90-day review, in-person attendance is required at minimum 1 day per month and required for certain meetings and tasks (collaboration with stakeholders and customers, team collaboration day, ISN events, team events, performance reviews, etc.).

ISN Benefits*
  • 100% company-paid monthly insurance premiums for employees and dependents
    • Medical, Dental, Vision, and Life Insurance
  • Employee assistance program
  • 4% retirement matching
  • Long-Term & Short-Term Disability Coverage
  • Paid time off
    • 0-1 year - 15 day (pro-rated first year)
    • 1-5 years - 20 days
    • 5-10 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
  • Team-building activities and events, including quarterly kick-off 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

Similar Jobs

More Jobs at ISN Software Corporation

More Information Technology Jobs

Find similar Senior SQL Developer jobs: