Junior SQL Developer

Trisian-Global Consulting LLC is seeking a proactive, self-sufficient developer/report analyst with strong, analytical problem-solving 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 on-site permanent in Memphis, TN.

ESSENTIAL FUNCTIONS AND RESPONSIBILITIES

Ability to read and write complex queries using SQL.

Create database objects (tables, views, stored procedures, user-defined 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