Programming experience:
Ideally, should have experience working in a development environment like Microsoft SQL Developer. Other programming requirements vary across organizations. For example, you might be supporting applications written in Java and C#, so knowledge of these will help you collaborate with other teams. Familiarity with the .NET framework is useful, especially if you’ll be specializing in Microsoft SQL Server. A background in Unix with some experience at command line understanding Bash or Windows batch scripts is a big plus.
Database knowledge:
Specialization in Microsoft SQL Server and experience in building/supporting large data structures required As an SQL developer, you’ll need to have hands-on experience with production databases. You should be able to: Create databases with efficient structures Write optimized queries, views and triggers for integration with other applications Maintain high standards of data quality and integrity Understand issues related to network performance and security Reporting and business intelligence tools like Microsoft SQL Server Reporting Services (SSRS) and Microsoft SQL Server Integration Services (SSIS) NoSQL database systems, such as MongoDB and CouchDB Big data technologies Cloud services like Amazon AWS, Google Cloud Platform and Microsoft Azure The Software Development Life Cycle (SDLC), specifically Scrum and Agile methodology Advanced Microsoft SQL Certification(s) preferred
SQL Developer duties and responsibilities:
Development of high quality database solutions Develop, implement and optimize stored procedures and functions using T-SQL Review and interpret ongoing business report requirements Research required data Build appropriate and useful reporting deliverables Analyze existing SQL queries for performance improvements Suggest new queries Develop procedures and scripts for data migration Provide timely scheduled management reporting Investigate exceptions with regard to asset movements
SQL Developer requirements and qualifications:
Minimum of 10 years of experience as a SQL Developer or similar role Excellent understanding of T-SQL programming BS/MS degree in Computer Science, Engineering or a related subject Excellent understanding of Microsoft SQL Server Good knowledge of HTML and JavaScript 5 years of experience with SQL Server Reporting Services, SQL Server Integration Services and SQL Server Analysis Services Familiarity with the practical application of NoSQL\NewSQL databases Sense of ownership and pride in your performance and its impact on company’s success Critical thinker and problem-solving skills Team player Good time-management skills Great interpersonal and communication skills