TrisianGlobal Consulting LLC is seeking a proactive selfsufficient developer/report analyst with strong analytical problemsolving skills wanting to be part of a highly supportive team that enjoys learning and collaborative discussion to help maintain existing applications while also benefiting from regular engagement with Development team. This position is onsite permanent in Memphis TN.
ESSENTIAL FUNCTIONS AND RESPONSIBILITIES
- Ability to read and write complex queries using SQL.
- Create database objects (tables views stored procedures userdefined functions) and modify existing reporting content in SQL.
- Experience with SQL Server Management Studio (SSMS) SQL Server Reporting Services (SSRS); creating report subscriptions and export data into excel pdf csv or XML files.
- Knowledge of import/export data from/to SQL tables.
- Create and schedule jobs to run automatically on the database using SSMS.
- Ensure appropriate standards and procedures are adhered to during the development process to support a quality deliverable.
- Communications with internal users on specific requests.
- Meetings documentation task and time tracking.
QUALIFICATIONS SKILLS AND ABILITIES
Education and Experience:
- Bachelors degree
- Minimum of 2 years of SQL development experience using SSMS
- Database: SQL Server TSQL
- Tools: SQL Server Management Studio (SSMS) SQL Server Reporting Services (SSRS)
- Languages / Frameworks: SQL (preferably TSQL) OOP (preferably .NET/C#)
Skills/Abilities:
- Review analyze and modify programming of applications systems including encoding testing debugging and documenting programs.
- Expert in developing and implementing new applications systems
- Resolve complex problems with existing applications systems
- Work within an agile software development methodology
- Work independently and in a team environment
- Interact with end users/SMEs
- Meet deadlines and deliver high quality software
Technical test
Create table from values emailed to candidate during interview
Create view
Update original table while viewing newly created one
create stored procedures with parameters
how do you handle join up to update
Remote Work :
No