What are the responsibilities and job description for the SQL Developer position at Crawford Thomas Recruiting?
Our client, a global cybersecurity leader that provides enterprise-level cybersecurity tools for the Managed Services Provider (MSP) industry, is seeking a SQL Developer onsite in Orlando, FL.
SALARY
$75K - 125K (flexible, based on experience) benefits, 401k, and more
LOCATION
Orlando, FL (onsite)
Position Overview
SQL Developer is responsible for keeping the database up and running smoothly 24/7. This role will ensure access is provided only to authorized users and services and is also responsible for data migration, business analysis, ETL processes, and performance tuning.
Job Duties
The SQL Developer will be responsible for, but not limited to:
Build database systems of high availability and quality depending on each end user’s specialized role Store, retrieve, migrate and manipulate data for analysis of system capabilities and requirements in multiple data platforms Design and implement database in accordance to end user’s information needs and views Resolve SQL issues with Indexes and tuning, transaction log issues, and database growth Optimize queries and SSIS packages architecture to improve performance and scalability. Write and modify complex T-SQL queries, stored procedures, views and user-defined functions. Define users and enable data distribution to the right user, in appropriate format and in a timely manner Minimize database downtime and manage parameters to provide fast query responses Provide proactive and reactive data management support and training to users Determine, enforce and document database policies, procedures and standards Perform tests and evaluations regularly to ensure data security, privacy and integrity Monitor database performance implement changes and apply new patches and versions when required Work with the application development team to establish and adhere to development standards Provide technical system support for various in-house systems
Qualifications
Minimum of six years of experience with SQL server Proficient in writing code for update queries, update data dictionaries as new fields are added to the database, and maintain a data correction log Experience managing database utilities and monitoring relationships between users and applications Knowledgeable in network hardware and software Working knowledge of enterprise SAN storage Proficient in understanding of relational databases concepts and query languages to design summary and aggregate tables which support analysis Experienced in creating and maintaining data correction logs that identify the date of the correction that was performed, tables and fields effected, submission effected, error code effected, and other pertinent metadata
WORKING CONDITIONS
The duties described below are representative of those encountered while performing the essential functions of this position. If necessary, reasonable accommodation may be requested and will be evaluated for its relationship to the essential functions that must be performed.
Job will generally be performed in an office environment, but may require travel to visit company offices and/or property locations. While performing duties of this job, would occasionally require one to stand, walk, sit, reach with hands and arms, climb or balance, stoop or kneel, talk and hear, and use fingers and hands to feel objects and tools. Must occasionally lift and/or move up to 25 pounds. Specific vision abilities required include close vision, distance vision, depth perceptions, and the ability to adjust focus.
SALARY
$75K - 125K (flexible, based on experience) benefits, 401k, and more
LOCATION
Orlando, FL (onsite)
Position Overview
SQL Developer is responsible for keeping the database up and running smoothly 24/7. This role will ensure access is provided only to authorized users and services and is also responsible for data migration, business analysis, ETL processes, and performance tuning.
Job Duties
The SQL Developer will be responsible for, but not limited to:
Build database systems of high availability and quality depending on each end user’s specialized role Store, retrieve, migrate and manipulate data for analysis of system capabilities and requirements in multiple data platforms Design and implement database in accordance to end user’s information needs and views Resolve SQL issues with Indexes and tuning, transaction log issues, and database growth Optimize queries and SSIS packages architecture to improve performance and scalability. Write and modify complex T-SQL queries, stored procedures, views and user-defined functions. Define users and enable data distribution to the right user, in appropriate format and in a timely manner Minimize database downtime and manage parameters to provide fast query responses Provide proactive and reactive data management support and training to users Determine, enforce and document database policies, procedures and standards Perform tests and evaluations regularly to ensure data security, privacy and integrity Monitor database performance implement changes and apply new patches and versions when required Work with the application development team to establish and adhere to development standards Provide technical system support for various in-house systems
Qualifications
Minimum of six years of experience with SQL server Proficient in writing code for update queries, update data dictionaries as new fields are added to the database, and maintain a data correction log Experience managing database utilities and monitoring relationships between users and applications Knowledgeable in network hardware and software Working knowledge of enterprise SAN storage Proficient in understanding of relational databases concepts and query languages to design summary and aggregate tables which support analysis Experienced in creating and maintaining data correction logs that identify the date of the correction that was performed, tables and fields effected, submission effected, error code effected, and other pertinent metadata
WORKING CONDITIONS
The duties described below are representative of those encountered while performing the essential functions of this position. If necessary, reasonable accommodation may be requested and will be evaluated for its relationship to the essential functions that must be performed.
Job will generally be performed in an office environment, but may require travel to visit company offices and/or property locations. While performing duties of this job, would occasionally require one to stand, walk, sit, reach with hands and arms, climb or balance, stoop or kneel, talk and hear, and use fingers and hands to feel objects and tools. Must occasionally lift and/or move up to 25 pounds. Specific vision abilities required include close vision, distance vision, depth perceptions, and the ability to adjust focus.
Salary : $75,000 - $125,000
