Database Developer -(SQL Server)
Technology
eSolutionsFirst, LLC1 month ago
Service contractFully remote
Job description
Database Developer – SQL Server
6- 10 Months Contract – Later extension
Location: Vienna, VA / Open for 100% remote job
Note :-
The primary focus is maintaining and supporting the existing environment; however, the resource should be comfortable operating in an organization that is actively transitioning toward a modern cloud data ecosystem.
The ideal candidate is a seasoned, hands-on developer who can come into a complex existing environment, learn it quickly, solve problems independently, and provide reliable coverage for business-critical data processing.
JOB DESCRIPTION:
Engagement Overview
- We are seeking an experienced, hands-on Database Developer.
- This resource will help maintain and support our existing on-premises data environment while the organization advances a broader cloud data transformation.
- The immediate priority is ensuring the stability, reliability, and continuity of business-critical legacy data solutions during this transition.
- The consultant must be able to become productive quickly in a large, mature Microsoft SQL Server environment, work effectively with existing code and processes, and independently troubleshoot and resolve production issues.
- This is a highly hands-on technical role.
- We are looking for an experienced developer who is comfortable working in an established legacy environment—not someone who requires greenfield development or modern cloud technologies to be effective.
- Maintain, support, troubleshoot, and enhance existing Microsoft SQL Server-based data solutions, including the enterprise data warehouse and operational data stores.
- Develop and modify complex T-SQL queries, stored procedures, views, functions, and other database objects.
- Maintain and troubleshoot SSIS packages, SQL Server Agent jobs, ETL processes, integrations, and scheduled/batch workloads.
- Provide hands-on production support, including diagnosing failed jobs, processing issues, data discrepancies, and performance problems.
- Quickly understand unfamiliar existing code, business logic, data flows, transformations, job dependencies, and downstream impacts.
- Perform SQL performance analysis and tuning, including query optimization, execution-plan analysis, and indexing.
- Support data validation and reconciliation and safely recover or rerun failed processing when necessary.
- Implement enhancements and corrective solutions while following established development, testing, change-management, and deployment practices.
- Create and maintain documentation of database processes, data flows, dependencies, production procedures, and changes.
- Work collaboratively with Data Engineering & Operations team members, DBAs, application teams, and other technology partners.
- Participate in knowledge transfer and help ensure appropriate team coverage of critical legacy processes.
- 5+ years of hands-on database development and production support experience in complex enterprise environments.
- Advanced Microsoft SQL Server and T-SQL development and troubleshooting skills.
- Strong hands-on experience with SSIS, SQL Server Agent, ETL, and scheduled/batch processing.
- Demonstrated ability to troubleshoot and safely modify complex existing and unfamiliar code.
- Strong production-support experience, including root-cause analysis, incident resolution, data validation, and recovery of failed processes.
- Experience tracing dependencies across database objects, jobs, ETL processes, source systems, and downstream consumers.
- Strong SQL performance-tuning skills, including execution plans, indexing, and query optimization.
- Experience with enterprise data warehouses, operational data stores, and large-volume data processing.
- Ability to work independently, prioritize effectively, and become productive quickly with limited ramp-up time.
- Strong technical documentation and communication skills.
- Experience supporting hybrid on-premises and cloud data environments.
- Snowflake development or production-support experience.
- Git, Azure DevOps, Visual Studio database projects, or comparable development tooling.
- Financial services, wealth management, or other regulated-industry experience.
Keywords
Microsoft SQL ServerBusiness logicDevOpsSqlGitMicrosoft Visual Studio
Interested in this role?