Remote Work - Need SQL Architect
Remote Work - Need SQL Architect
Steneral Consulting
United States
See who Steneral Consulting has hired for this role
100% Remote
Need active and Valid LinkedIn
Key’s From The Manager
Stored Procedures, Table-Valued Functions, and Dimensions
Requirements
Microsoft SQL experience (2016, 2019) -
Stored Procedures
BI Tools
Need active and Valid LinkedIn
Key’s From The Manager
Stored Procedures, Table-Valued Functions, and Dimensions
Requirements
Microsoft SQL experience (2016, 2019) -
Stored Procedures
- Creation and maintenance of stored procedures.
- Experience with creating stored procedures that move data across SQL servers into data warehouse database to create/maintain historical/audit tables.
- Experience with working with large datasets (~10Mil+)
- Finding long running queries and improving them in reasonable ways
- Indexes (clustered/nonclustered)(row, columnstore)
- Restructuring Queries
- Investigating SQL plans to optimize large queries
- Experience with things usually associated with a database administrator
- Root cause analysis on errors
- Identifying issues occurring within the SQL databases
- Performance Configuration for Server/Databases
- Awareness of Filegroups & tempdb resources
- Creation of fact/dimension (Type 2)
- Experience using SQL Server Agent to:
- Create jobs and monitor jobs
- Knowledge of Table Valued Functions, Scalar Valued Functions
- Experience using Microsoft SQL features to replicate data across servers/databases or implementing custom solutions to achieve similar results.
- Such as Change Data Capture, Change Tracking, or Replication
- Experience parsing JSON, but preferably within SQL.
BI Tools
- Experience preparing data for use inside a Business Intelligence (BI) tool, such as Qlik.
- Experience using BI Tools, preferably Qlik.
- Experience in SSRS.
- Experience with Postgres, or specifically Greenplum.
- Experience using and creating documentation in Confluence.
- Experience setting up and using Git, preferably for SQL based code.
-
Seniority level
Entry level -
Employment type
Full-time -
Job function
Engineering and Information Technology -
Industries
IT Services and IT Consulting
Referrals increase your chances of interviewing at Steneral Consulting by 2x
See who you knowGet notified about new Software Architect jobs in United States.
Sign in to create job alertSimilar Searches
Explore collaborative articles
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
Explore More