Senior SQL Server Developer: Performance & Modeling

Staffing Spot, Inc.; Phoenix (AZ); In loco; USD 110.000 - 150.000; Tempo pieno

Descrizione del lavoro

Staffing Spot, Inc. is seeking an experienced SQL Server database engineer to design, optimize, and maintain complex databases in a fast-paced environment.

You will implement data structures, define schemas, and ensure data integrity while collaborating with developers and analysts to deliver reliable data services. The role requires deep knowledge of T-SQL, indexing, and performance tuning, with hands-on experience in Tableau reporting and ETL processes.

Competenze

• 8+ years’ experience with Microsoft SQL Server ( mandatory and no substitution of Oracle or other DBs).
• 7+ years’ experience with Data modeling and database design.
• 7+ years’ experience in developing of DB objects like tables, views, complex stored procedures, and user defined functions.
• 7+ years’ experience with performance tuning of SQL Queries.
• 3+ years’ Agile development
• Experience with Tableau reporting
• Experience with ETL
• Strong hands-on experience with Microsoft SQL Server.
• Excellent knowledge of SQL, T-SQL, joins, subqueries, CTEs, and window functions.
• Experience developing stored procedures, functions, views, and triggers.
• Strong understanding of indexing, execution plans, and query optimization.
• Experience with database design, normalization, and relational database concepts.
• Knowledge of transactions, locking, blocking, and deadlock troubleshooting.
• Experience with database backup, recovery, and performance monitoring.
• Strong analytical and problem-solving skills.

Mansioni

• Design, develop, and maintain databases using Microsoft SQL Server.
• Write and optimize complex SQL queries, stored procedures, functions, and views.
• Perform database performance tuning and query optimization.
• Develop and maintain indexes, triggers, and database objects.
• Analyze execution plans and troubleshoot slow-running queries.
• Design database schemas, tables, relationships, and constraints.
• Implement data integrity, security, and access control.
• Support database troubleshooting, debugging, and production issues.
• Work closely with backend developers, business analysts, QA, and reporting teams.
• Participate in database deployments, code reviews, and documentation.

Conoscenze

SQL Server

Data modeling

DB design

Query optimization

T-SQL

Performance tuning

Stored procedures

Views

Tableau

ETL

Indexes

Data integrity

Deadlock troubleshooting

Strumenti

Tableau Desktop

SQL Server Management Studio

Descrizione del lavoro

Staffing Spot, Inc. is seeking an experienced SQL Server database engineer to design, optimize, and maintain complex databases in a fast-paced environment.

You will implement data structures, define schemas, and ensure data integrity while collaborating with developers and analysts to deliver reliable data services. The role requires deep knowledge of T-SQL, indexing, and performance tuning, with hands-on experience in Tableau reporting and ETL processes.