Contact Us 877.823.3669

SQL Developer in Orlando, FL at SNI Technology

Date Posted: 3/23/2018

Job Snapshot

Job Description

We are looking for a SQL Developer to work in clermont area for one of our major clients . (80% Developer role, 20% DBA Role)
Required Skills & Experience:

    • Has 8+ years of experience in database development and support in MS SQL Server environments.
    • Strong experience in Database Administration in SQL Server ( 2005 and 2008 )
    • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
    • Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
    • Ability to detect and troubleshoot SQL Server related CPU,memory,I/O, disk space and other resource contention.
    • Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
    • Expert experience in implementing operational automation.
    • Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
    • Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
    • SQL Development - ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )
    • Solid acquaintance with windows server, security delegation, SPNs, storage components.
    • Documentation skills for processes and procedures ( creating KBs, runbooks, topology etc )
    • SQL Database Operational support to tech users

Skills & Knowledge
1. Experience with large-scale high-volume application design, development and deployment
Implementation experience with enterprise level clustering, load balancing, fail-over, scalability and performance tuning
2. Experience with performance tuning of enterprise databases as well as daily, weekly, monthly database backups.
3. Experience in the creation and management of database objects including databases, schemas, tables, stored procedures, synonyms, and views.
4. Experience in report writing in Microsoft SSRS
5. Experience in merging complex documents with datasets as used in core business units