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 on-site in Orlando, FL.
SALARY
$75K - 125K base (flexible, based on experience) quarterly bonus, benefits, 401k, and more
LOCATION
Orlando, FL (Onsite Monday-Friday)
Position Overview
The SQL Developer is responsible for keeping the database up and running smoothly. 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 a 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 an 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, updating data dictionaries as new fields are added to the database, and maintaining 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 relational database concepts and query languages to design summary and aggregate tables that support analysis Experienced in creating and maintaining data correction logs that identify the date of the correction that was performed, tables and fields affected, submission affected, error code affected, and other pertinent metadata,
SALARY
$75K - 125K base (flexible, based on experience) quarterly bonus, benefits, 401k, and more
LOCATION
Orlando, FL (Onsite Monday-Friday)
Position Overview
The SQL Developer is responsible for keeping the database up and running smoothly. 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 a 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 an 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, updating data dictionaries as new fields are added to the database, and maintaining 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 relational database concepts and query languages to design summary and aggregate tables that support analysis Experienced in creating and maintaining data correction logs that identify the date of the correction that was performed, tables and fields affected, submission affected, error code affected, and other pertinent metadata,
Salary : $75,000 - $125,000