SQL Database Developer

  • Product
  • Bengaluru, India

SQL Database Developer

Job description

DirecTech Labs is hiring a SQL Server Database Developer to join our fast growing startup.  Join an incredible group of humans levering behavior science and AI that brings direct and social selling into the information age. We help our customers create more effective and compelling income opportunities for millions of people who will be automated out of work in the years to come. Learn more at www.directechlabs.com, and on our Youtube channel.


As a Database Developer, you will design, develop, test, and implement efficient, scalable, and highly available database applications.  You’ll possess a strong database background, problem solving skills, and ability to communicate effectively within a team.You’ll serve as our database developer in an agile project environment.


What You'll Do

  • Write and maintain functional and technical specifications

  • Provide production support for operational issues by occasional on-call duties

  • Design, develop, test, and implement technology solutions

  • Adhere to company coding, architecture, and system best practices

  • Work collaboratively within an agile SCRUM team

  • Communicate effectively with team, project managers, and IT

  • Proactive stance toward achieving team success of projects

  • Contribute to code quality initiatives

  • Tune and optimize database code performance

  • Define and drive process improvements across the team and IT

  • Assess and validate activities to determine solution will fulfill requirements

Requirements

What You'll Need

  • Expert working with Microsoft SQL Server 2012, 2014, 2016

  • Azure SQL will be a plus

  • Strong understanding of relational databases and analysis skills

  • Exceptional Knowledge of creating Optimized SQL Query, Query Optimization, Performance for database having multi- millions records per table

  • Tuning Techniques, Table Structures, Indexes, Stored procedures, Triggers, Joins

  • Experience with data warehouse implementations

  • Knowledge of logical and physical data modeling concepts (relational and dimensional)

  • Understanding of data integration issues (validation and cleaning)

  • Demonstrated ability to use data to troubleshoot business problems

  • Working with Hadoop, HDInsight or Spark will be a plus

  • Demonstrated ability to identify, assess and troubleshoot data issues

  • Excellent interpersonal (verbal and written) communication skills are required to support