SQL Server Database Developer
Description:
We are seeking an experienced SQL Server Database Developer with expertise in performance tuning and a strong technical understanding of SQL Server's internal workings.
Database Development: Design, develop, and implement complex SQL queries, stored procedures, functions, and triggers for various business applications.
Performance Tuning & Optimization: Identify and resolve performance bottlenecks using advanced techniques, including index optimization, query tuning, execution plan analysis, and optimization of database configurations.
Troubleshooting & Debugging: Troubleshoot and resolve performance issues and errors within SQL Server environments.
Database Architecture & Design: Assist in the architectural design and implementation of high-performing SQL Server databases.
High Availability & Scalability: Design, configure, and maintain high-availability solutions.
Database Monitoring: Use SQL Server Management Studio (SSMS) and third-party monitoring tools to proactively monitor database performance.
Security & Compliance: Implement database security measures, ensuring that sensitive data is protected and compliant with regulatory requirements.
Documentation: Maintain thorough documentation of database configurations, changes, performance improvements, and optimization procedures.
Collaboration: Work closely with cross-functional teams to ensure the smooth operation of database systems.
Stay Current with SQL Server Updates: Continuously evaluate and apply new SQL Server features.
Cloud SQL Management: Design, implement, and maintain SQL Server databases on cloud platforms such as Microsoft Azure SQL Database.
Cloud Integration: Work with cloud providers and integration tools to ensure seamless interaction between cloud-based databases and other cloud services.
Requirements:
Experience: 5+ years of experience working with SQL Server database development, with a focus on performance tuning, query optimization, and troubleshooting.
SQL Server Expertise: Deep technical knowledge of SQL Server (2016 or later) architecture, internals, and background processes such as transaction logs, locking, and resource management.
Performance Tuning: Proven track record in identifying performance bottlenecks and resolving issues related to query performance, indexing, and database configuration.
Indexing & Query Optimization: Advanced knowledge of indexing strategies (clustered, non-clustered, filtered, and full text), and ability to optimize complex SQL queries.
High Availability & Disaster Recovery: In-depth knowledge of SQL Server high availability technologies such as Always On Availability Groups, database mirroring, replication, and log shipping.
Tools: Proficient in using SQL Server Management Studio (SSMS), SQL Profiler, and other performance monitoring tools (e.g., Redgate, SolarWinds, etc.).
Scripting: Strong ability to write and automate T-SQL scripts and working knowledge of PowerShell or other scripting languages for database management tasks.
Problem-Solving Skills: Strong analytical and problem-solving abilities, particularly in high-pressure environments.
Communication: Excellent communication skills to effectively collaborate with developers, system administrators, and business stakeholders.
Certifications: Microsoft Certified: Azure Data Engineer, Microsoft Certified: SQL Server (or similar) certifications are a plus.
Benefits:
Apply Now
We are seeking an experienced SQL Server Database Developer with expertise in performance tuning and a strong technical understanding of SQL Server's internal workings.
Database Development: Design, develop, and implement complex SQL queries, stored procedures, functions, and triggers for various business applications.
Performance Tuning & Optimization: Identify and resolve performance bottlenecks using advanced techniques, including index optimization, query tuning, execution plan analysis, and optimization of database configurations.
Troubleshooting & Debugging: Troubleshoot and resolve performance issues and errors within SQL Server environments.
Database Architecture & Design: Assist in the architectural design and implementation of high-performing SQL Server databases.
High Availability & Scalability: Design, configure, and maintain high-availability solutions.
Database Monitoring: Use SQL Server Management Studio (SSMS) and third-party monitoring tools to proactively monitor database performance.
Security & Compliance: Implement database security measures, ensuring that sensitive data is protected and compliant with regulatory requirements.
Documentation: Maintain thorough documentation of database configurations, changes, performance improvements, and optimization procedures.
Collaboration: Work closely with cross-functional teams to ensure the smooth operation of database systems.
Stay Current with SQL Server Updates: Continuously evaluate and apply new SQL Server features.
Cloud SQL Management: Design, implement, and maintain SQL Server databases on cloud platforms such as Microsoft Azure SQL Database.
Cloud Integration: Work with cloud providers and integration tools to ensure seamless interaction between cloud-based databases and other cloud services.
Requirements:
Experience: 5+ years of experience working with SQL Server database development, with a focus on performance tuning, query optimization, and troubleshooting.
SQL Server Expertise: Deep technical knowledge of SQL Server (2016 or later) architecture, internals, and background processes such as transaction logs, locking, and resource management.
Performance Tuning: Proven track record in identifying performance bottlenecks and resolving issues related to query performance, indexing, and database configuration.
Indexing & Query Optimization: Advanced knowledge of indexing strategies (clustered, non-clustered, filtered, and full text), and ability to optimize complex SQL queries.
High Availability & Disaster Recovery: In-depth knowledge of SQL Server high availability technologies such as Always On Availability Groups, database mirroring, replication, and log shipping.
Tools: Proficient in using SQL Server Management Studio (SSMS), SQL Profiler, and other performance monitoring tools (e.g., Redgate, SolarWinds, etc.).
Scripting: Strong ability to write and automate T-SQL scripts and working knowledge of PowerShell or other scripting languages for database management tasks.
Problem-Solving Skills: Strong analytical and problem-solving abilities, particularly in high-pressure environments.
Communication: Excellent communication skills to effectively collaborate with developers, system administrators, and business stakeholders.
Certifications: Microsoft Certified: Azure Data Engineer, Microsoft Certified: SQL Server (or similar) certifications are a plus.
Benefits:
Apply Now