We cannot sponsor this role. Must be able to work W2 after 6 months.
Role:
SQL Developer Location:
Onsite Duration:
Contract to hire
Conversation Salary:
$65-70 an hour
Compensation:
Based on
Experience Summary:
Capstone IT is helping our client find an experienced SQL Developer to join a leading natural gas transportation company responsible for supporting critical pipeline operations and enterprise business systems. This role is ideal for someone with advanced SQL Server development skills who also has an interest or background in database administration. You will design, optimize, and maintain complex SQL solutions supporting pipeline operations, regulatory reporting, scheduling, accounting, asset management, and enterprise applications. This position will expand into SQL Server Application DBA responsibilities including data modeling, designing and maintaining tables and indexes, query tuning, refactoring, and maintaining complex stored procedures. Key Responsibilities Design, develop, and optimize complex SQL Server stored procedures, views, functions, and triggers. Write efficient T-SQL queries for large, highly transactional databases. Troubleshoot and improve SQL performance using execution plans, indexing strategies, and query optimization. Develop ETL processes and automate data movement between enterprise systems. Support business reporting and analytics by building reliable database objects. Collaborate with application developers, business analysts, and infrastructure teams to deliver scalable database solutions. Participate in database design, schema modifications, and data modeling. Coordinate with System DBA's to request database maintenance, backups, restores, security, and disaster recovery planning. Monitor database health and recommend improvements for performance and reliability. Support production deployments and troubleshoot database-related production issues. Ensure data integrity, compliance, and security across critical business systems. Required Qualifications 5+ years of Microsoft SQL Server development experience. Expert-level T-SQL programming skills.
Strong experience developing:
Stored Procedures Views Functions Triggers Complex joins CTEs Windowing functions Experience with SQL Server performance tuning and optimization. Strong understanding of indexing strategies and execution plans. Experience working with large enterprise databases. Knowledge of database normalization and relational database design. Experience supporting production environments. Strong troubleshooting and analytical skills. Excellent communication and collaboration abilities. Nice to Have Experience with SSIS, SSRS, or Azure Data Factory. Experience with Power BI or enterprise reporting platforms. Familiarity with C#, .NET, or API integrations. Experience with source control (Git or Azure DevOps). Exposure to cloud database technologies. Industry Experience Preferred Candidates with experience supporting any of the following industries are highly encouraged to apply: Natural Gas Transportation Oil & Gas Utilities Energy Pipeline Operations Manufacturing Industrial Operations Nice to Have When working with System DBA's as the Application DBA, having SQL Server Administration experience would be a plus.
Knowledge such as:
Backup & Recovery Database Security Maintenance Plans SQL Server Agent High Availability concepts Performance Monitoring Experience supporting SCADA or operational technology (OT) systems. Familiarity with pipeline scheduling, nominations, gas accounting, or asset management systems. Knowledge of regulatory reporting and compliance data. Role Context - This Company
- This SQL Developer supports systems that directly enable a natural gas transportation operation . That makes the database work more operationally important than a typical internal reporting position.
- The developer will support data behind areas such as pipeline scheduling, accounting, regulatory reporting, asset management, and other enterprise applications. Large transactional databases and production reliability are therefore important parts of the job.
- The role also bridges development and database administration .
The employee is not replacing the System DBA. Instead, they will own the application/database layer—SQL code, schemas, tables, indexes, data models, and application performance—and coordinate with System DBAs when infrastructure-level work such as backups, restores, security, maintenance, or HA is needed. Please send your resume and salary requirements for immediate consideration! Capstone Consulting is an EEO employer.
Capstone website:
http://www.capstonec.com/ Like us on
Facebook:
https://www.facebook.com/CapstoneITStaffingSolutions/ Follow us on
Twitter:
https://twitter.com/capstone__IT/ Connect with us on
LinkedIn:
https://linkedin.com/company/capstone-consulting/
Pay:
$100,000.00 - $120,000.00 per year
Work Location:
In person