Previous Job
Previous
SQL Developer
Ref No.: 17-00003
Location: Bohemia
Position Type:Right to Hire
Start Date: 01/13/2017
 We are looking for a SR SQL Server Developer / DBA who will be involved in managing multiple SQL databases in a highly dynamic environment.  You will be involved in migrating databases from SQL Server 2008 R2 to SQL Server 2014 and migrate SSIS packages.  You will work as part of a team in support of operational and project related activities including building database applications. Provide technical and operational support to other departments and teams as required in support of business objectives.
 
Responsibilities:
1.            Supports team in writing SQL queries. Ability to create, tune and debug SQL Code ( Tables, Stored Procedures, Views )
2.            Performs daily tasks to monitor Development, QA and Production environments
3.            Design, maintain and migrate ETL Packages (SSIS, T-SQL)
4.            Knowledge of reporting and query tools and practices
5.            When performance issues arise, determine the most effective way to increase performance including server configuration changes, or index/query changes
6.            Document the company's database environment
 
Experience:
6+ years of experience in a SQL 2008 R2 and 2014 environment. 
             •  Create database objects such as tables, views, stored procedures, Triggers etc.
             •  Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
            •  Identify columns for Primary Keys in all the tables at the design time and create them.
            •  Create functions to provide custom functionality as per the requirements.
            •  Be aware of potential blocking, deadlocking and write code to avoid those situations.
            •  Ensure that the code is well written keeping in mind any security issues such as SQL Injection.
•             Knowledge of SQL Performance tools (Idera or SQL Profiler).
•             Experience of migrating Databases
•             Experience with data replication
•             Create and Modify complex SSIS Packages.
•             Knowledge of AS400 a plus
•             Knowledge of Ecommerce a plus
•             Self-starter who is highly organized, hands-on, and a team player.
•             BE or BS Degree in one of the following subject areas: Computer Science, Information
 
Education, Certification, Licenses & Registrations:
Bachelor's degree in Computer Science or similar computing related degree.
MS SQL Certification a plus
 
Skills:
•             SQL Server 2008
•             SQL Server 2014
•             Database Administration
•             Database Tuning
•             Database Management
•             Database Security
•             RDBMS
•             Bachelor's Degree