Previous Job
Previous
SQL Developer
Ref No.: 18-29182
Location: Atlanta, Georgia
Title: Database Developer
Location: Atlanta , Georgia
Duration : 08 Months 
 
Responsibilities:
  • Responsible for the data modeling and RDBMS design for our high-volume application and establish standards Develop stored functions and triggers using SQL and  improve server performance by Performing code reviews of SQL and offer performance related improvements to the team, Implement and support database backup and recovery operations.
  • Should have a good knowledge in NoSQL databases (MongoDB) and have knowledge in azure SQL databases and SQL Server 2016
 
Required Skills:
  • 7+ years of professional development experience with SQL Server databases.
  • Have experience in C#, ASP.NET/MVC, JQuery and HTML so that can do some bug fixing task
  • Highly proficient with TSQL and PLSQL and related tuning with indexes and database parameters
  • Have practical knowledge in NoSQL and Azure DB
  • Practical experience developing a data warehouse using dimensional modeling techniques
  • Proficient with developing methods of loading large volumes of data automatically into a database
  • Experience in converting functional requirements into technical Specifications for Development
  • Experience with table partitioning strategies and related implementation
  • Proficient with interpreting query explain plans, reviewing data within tables and recommending indexing strategies
  • Experience with establishing methods for base-lining database performance and measuring improvements with changes
  • Capable of setting up database servers and instances from scratch on Windows
  • Experience in recommending and configuring optimal hardware solutions including storage area networks
  • Experience with Agile development practices and Scrum methodology