SQL Server Database Developer

March 6

Apply Now

Receive Emails with Similar Jobs

Ally

WebsiteLinkedInAll Job Openings

Ally is a leading digital financial services company that offers a variety of banking and investment products. Ally Bank, its direct banking subsidiary, provides services such as checking and savings accounts, credit cards, auto financing, investment options, and life insurance. Known for eliminating overdraft fees and offering high-yield savings accounts, Ally aims to simplify finances and help customers manage their money confidently.

Auto Financing • Auto Servicing • Dealer Services • Commercial Finance • Ally Bank

10,000+ employees

🏦 Banking

💳 Fintech

💸 Finance

📋 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.