Position Summary:
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