ECCO Select · 2 days ago
Database Developer #10953
ECCO Select is a talent acquisition and consulting company specializing in people, process and technology solutions. The Senior SQL Server Applications Developer will design, implement, and support SQL Server database applications while collaborating with technical teams and business stakeholders to ensure optimal database performance and security.
Information ServicesInformation Technology
Responsibilities
Design, develop, and maintain SQL Server database applications to support complex business and system requirements
Develop, analyze, and optimize T-SQL queries, stored procedures, functions, and scripts to ensure efficiency and scalability
Conduct query optimization and performance tuning efforts (indices, reviewing execution plans, analyzing deadlocks, resolving blocking issues, etc.)
Implement and manage database deployment procedures and conduct release management activities related to database changes
Monitor and troubleshoot database systems to ensure optimal performance, reliability, and security, identifying and resolving issues proactively
Partner with application and development teams to continuously enhance database structures and improve application query performance
Provide expert technical support and troubleshooting for database-driven applications deployed in production environments
Maintain comprehensive technical documentation, including data models, change logs, runbooks, and support procedures
Ensure all projects and support activities comply with established security practices and protocols
Respond promptly to priority incidents and participate in release windows as required by production support responsibilities
Qualification
Required
Extensive hands-on experience with Microsoft SQL Server and T-SQL at a senior developer level
Expertise in database design, implementation, and maintenance for high-volume production systems
Strong background in query optimization and performance tuning, including experience with indexing, execution plan analysis, troubleshooting deadlocks, and resolving blocking queries
Proficient use of SQL Server Management Studio (SSMS) in daily development, troubleshooting, and support roles
In-depth understanding of database security concepts, such as roles, permissions, auditing, secure database design, and enforcement of least privilege policies
Demonstrated experience providing technical support for complex, production SQL Server database applications
Skilled analytical thinker and effective problem solver, able to resolve complex production issues systematically and under pressure
Excellent communications skills, both written and verbal, necessary for effective technical documentation and stakeholder collaboration
Experience working collaboratively within Agile/Scrum teams or similar dynamic project environments
Strong attention to detail, organizational skills, and ability to manage concurrent priorities
Must be a U.S. citizen and available to work onsite, full time (5 days per week) in downtown Washington, D.C
Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field (or equivalent experience)
7+ years of hands-on work experience as a SQL Server Database Developer or in a similar database engineering role
U.S. citizenship is required for this position due to project requirements
Preferred
Experience with SQL Server Integration Services (SSIS)
Familiarity with C#/.NET development and Visual Studio for integrated application/database solutions
Background working in Agile teams, familiarity with user stories, sprints, iterative releases, and DevOps coordination
Benefits
401(k)
Dental insurance
Health insurance
Vision insurance