You will assist with all development stages for the SQL databases, write SQL queries, and conduct SQL database troubleshooting. The SQL Developer will be responsible for the stability, reliability, and performance of the databases. The SQL Developer will also be responsible for the implementation, configuration, maintenance, and performance of SQL Server to ensure the availability and consistent performance of our corporate applications. This is a hands-on position requiring solid technical skills, as well as excellent interpersonal and communication skills.
Responsibilities:
Write simple to advance queries and stored procedures used for applications
Create and modify database tables, archived tables, and indexes to improve database performance and create or modify triggers for automation
Monitor and optimize performance of databases
Resolve and update IT tickets for SQL related tasks/issues in a timely and efficient manner
Database administration including installation/upgrade of SQL database, tools, user and security management, backup, restores, and replication
Develop SQL-based reports and ad-hoc queries
Produce SQL developments for warehouse management system HighJump
Work with application vendors on incidents and technical support as needed
Create/modify standard operating procedure and documentation as needed
Provide on-call and after-hours support and maintenance duties as required
Qualifications:
Bachelor's Degree in Computer Science, Information Analytics, or related technical degree desired
SQL related certifications preferred
Required minimum 3 years of professional experience as SQL Developer or data Engineer
Required minimum 2 years of professional experience in troubleshooting SQL related task and resolving performance issue.
2+ years of SQL Server Reporting Services (SSRS) experience
2+ years of SQL Server Integration Services (SSIS) experience
2+ year of MS SQL server administration
Preferred 1+ years of HighJump Development experience in SQL