Sql Developer

- Create and maintain database objects to include databases, tables, indexes, stored procedures, triggers, SQL Agent Jobs, etc. using Microsoft SQL Server 2016 Enterprise Edition
- Install and configure SQL server to include non-standard ports and named instances
- Document database objects and processes
- Produce ad hoc database reports on short notice
- Conduct database performance monitoring and make database changes as necessary to improve performance
- Ability to produce production-quality T-SQL code complete with internal documentation rapidly with a minimum of supervision
- Ability to quickly analyze existing T-SQL code and make improvements to enhance performance, take advantage of new SQL features, close security gaps, and increase robustness and maintainability of the code.
- Solid understanding of normalization and denormalization of data, database exception handling, transactions, profiling queries, performance counters, and debugging techniques
- Familiar with SQL security techniques such as data encryption at the column level, Transparent Data Encryption (TDE), signed stored procedures, and assignment of user permissions
- Strong attention to detail with the ability to make accurate estimates and meet deadlines
- Strong communication skills, with an ability to express technical concepts in business terms
- Importing data from various sources into an MS SQL Server database with an eye for repeatability and automation
- Writing complex stored procedures
- Analyzing, cleaning and de-duping data and building stored procedures to do the same
- Transforming source data into standardized formats for inclusion in the master database
- Validating processed results generated by other developers
- Generating data analytics reports