Backend Developer

Consolidated Analytics, Inc.; Tennessee; On-site; USD 90,000 - 120,000; Full time

Job summary

Consolidated Analytics, Inc. seeks a Backend Developer with 5+ years of experience in database development and SQL. The role emphasizes MS SQL Server expertise, complex queries, and robust schema design to support mortgage and financial services data solutions.

You will collaborate with software teams to deliver scalable database systems, optimize SQL performance, and ensure data integrity and security across platforms. A strong telecom of team and independent work is expected.

Qualifications

• Bachelor’s degree in computer science, Information Technology, or related field.
• Minimum of 5 years of hands-on experience in database development.
• Extensive experience with MS SQL Server.
• Proficiency in writing and optimizing complex SQL queries and stored procedures.
• Strong understanding of database schemas, normalization, and database design principles.
• Experience with performance tuning and optimization.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills.
• Ability to work independently and as part of a team.

Responsibilities

• Design, develop, and maintain complex SQL queries and procedures.
• Develop, implement, and optimize database schema and database objects.
• Collaborate with software developers and other stakeholders to create efficient and scalable database solutions.
• Perform troubleshooting, debugging, and optimization of SQL code and database systems.
• Ensure data integrity and security.
• Conduct database performance tuning and optimization.
• Create and maintain documentation for database systems, processes, and procedures.
• Participate in code reviews and provide constructive feedback.
• Stay updated with the latest developments in database technologies and industry best practices.

Skills

MS SQL Server

SQL development

SQL queries

Education

Bachelor's degree in computer science

Tools

Azure SQL

AWS RDS

PostgreSQL

Job description

Backend Developer

Consolidated Analytics, Inc. Chennai, Tennessee, United States

About this position

At loanDNA, we believe great leadership starts with the right people. Our team is built on industry veterans and forward-thinkers who bring a powerful mix of mortgage expertise, technical skills, and a passion for innovation.

We hire leaders who understand the complexities of the mortgage and financial services industry and embrace emerging technologies - AI, automation, and advanced analytics to deliver smarter, faster solutions for our clients.

From evaluating loan quality and collateral to shaping disposition strategies and optimizing performance, our leadership team combines hands-on experience with cutting-edge insight. Their perspective spans the full mortgage lifecycle, ensuring clients benefit from strategies that are both practical today and built for tomorrow.

Job Summary:

We are seeking a highly motivated and experienced SQL Developer with a minimum of 5 years of hands-on experience in database development, SQL queries, schemas, and database design. The ideal candidate must have extensive experience with MS SQL Server and preferably other database systems.

Responsibilities:

• Design, develop, and maintain complex SQL queries and procedures.


• Develop, implement, and optimize database schema and database objects.


• Collaborate with software developers and other stakeholders to create efficient and scalable database solutions.


• Perform troubleshooting, debugging, and optimization of SQL code and database systems.


• Ensure data integrity and security.


• Conduct database performance tuning and optimization.


• Create and maintain documentation for database systems, processes, and procedures.


• Participate in code reviews and provide constructive feedback.


• Stay updated with the latest developments in database technologies and industry best practices.

Requirements:

• Bachelor’s degree in computer science, Information Technology, or related field.


• Minimum of 5 years of hands-on experience in database development.


• Extensive experience with MS SQL Server.


• Proficiency in writing and optimizing complex SQL queries and stored procedures.


• Strong understanding of database schemas, normalization, and database design principles.


• Experience with performance tuning and optimization.


• Excellent problem-solving skills and attention to detail.


• Strong communication and collaboration skills.


• Ability to work independently and as part of a team.

Preferred Skills:

• Experience with cloud-based database solutions (e.g., Azure SQL, AWS RDS).


• Knowledge of data modeling tools.


• Experience with database security best practices.


• Familiarity with Agile/Scrum development methodologies.


• Familiarity with other database systems such as MySQL, PostgreSQL, Oracle, etc. is added advantage.


• Experience with data warehousing and ETL processes is a plus.