Junior SQL Developer Job at Trisian-Global Consulting LLC, Memphis, TX

RXRId3EyUXVieThPR1VDTVVpV1M0ZnlabVE9PQ==
  • Trisian-Global Consulting LLC
  • Memphis, TX

Job Description

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

Job Tags

Permanent employment, Remote job,

Similar Jobs

System One

General Utility Job at System One

 ...General Utility Shift: 7:30 AM- 4:00 PM Tuesday - Saturday Location: La Crosse, WI Pay Rate: $21/hr Great entry level...  ...to work irregular and/or rotating shifts. Available to work holidays, weekends, and rotating schedules as frequently required.... 

Symmetry Financial Group - The Winifred Brown Agency

HIRE YOURSELF. WORK FROM HOME. Job at Symmetry Financial Group - The Winifred Brown Agency

 ...Our award-winning agency is looking to work with top level, self-motivated people who...  ...work ethic. This is a remote, work from home, sales role with a commission structure and...  ...you ever worked with a mentor? Would you hire yourself? COMPENSATION This is 100%... 

Whittier Health Network

Clinical Nurse Specialist- Precertification Job at Whittier Health Network

 ...Clinical Nurse Specialist / Precertification - Whittier Rehab Hospital - Bradford Department: Medical Care Evaluations Full-time, 40 hours/week, Day shift- Mon-Fri Pay Rate :$40.00-$42.00 per hour Must be RN or LPN Primary Function: Responsible for reviewing... 

Toyota of Cool Springs

Parts Delivery Driver Job at Toyota of Cool Springs

 ...businesses in a timely and professional manner. This is a full time - hourly position with a competitive compensation of $18 per hour. This...  ...in Franklin, Tennessee.Compensation & Benefits: Hourly pay rate of $18 per hour Medical, dental, and vision insurance Paid... 

Vietnam Business Forum

Tax Consultant Job at Vietnam Business Forum

 ...with people at all levels in an organizationWillingness to travelWhat youll doYoull work in teams of typically 3 5 consultants, playing an active role in all aspects of client engagement. This includes gathering and analyzing information, formulating and...