Trisian-Global Consulting LLC is seeking a proactive, self-sufficient Entry Level SQL Developer with strong fundamentals working with SSMS.
Permanent Position: W2 Only, No C2C, No OPT, No Sponsorship. This position is on-site in Memphis, TN. No Remote, must be willing to relocate if necessary.
ESSENTIAL FUNCTIONS AND RESPONSIBILITIESAbility 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 exporting 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.Communicate with internal users on specific requests.Participate in meetings, documentation, task, and time tracking.QUALIFICATIONS, SKILLS, AND ABILITIESEducation and Experience: Bachelor's degree and 1 year of demonstrated experience in SQL development using SSMS, SSRS, and SSIS.
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 the interview, create view, update original table while viewing newly created one, create stored procedures with parameters, and handle joins to update.
#J-18808-Ljbffr