SQL Server Developer

Bright Vision Technologies is looking for a SQL Server Developer for a client based in Jacksonville, FL for a long-term contract

SQL Server Developer – ELT, Unix, Stored Procedures
Location: Jacksonville, FL
Duration: Long term

In-Person interview is required for the final round at Jacksonville, FL

We are seeking a Senior PL/SQL Developer to join the Analytics Platform team. This role is critical in supporting the transition from ETL-based Data Warehousing to Netezza and requires deep expertise in SQL Queries, Unix Shell Scripting, Stored Procedures, and ELT Development in RDBMS.
Responsibilities:

• Write and optimize complex SQL queries to support ELT processes in relational databases (RDBMS).
• Develop and optimize stored procedures, functions, and triggers for high-performance data processing.
• Create and manage shell scripts in Unix/Linux environments to automate data processing and job scheduling.
• Work with large-scale data pipelines, transformations, and batch data processing.
• Utilize Netezza SQL (nzsql) for data manipulation and performance tuning (preferred).
• Optimize SQL queries, indexing strategies, and bulk data loading for efficiency.

Required Skills & Experience:

• 5 years of technical design and coding experience in the IT industry.
• Expertise in advanced SQL for ELT development and relational database management (RDBMS).
• Hands-on experience in Unix/Linux shell scripting for automation and data movement.
• Strong understanding of data warehouse architecture, ELT processes, and batch processing of large datasets.
• Experience building and optimizing stored procedures for high-volume data processing.
• Familiarity with Netezza SQL (nzsql) for query execution and optimization (preferred).

Location:
Jacksonville, FL (100% onsite)


Ideal Candidate Profile
A Senior Developer as an Oracle PL/SQL or SQL developer with handling the below stuff.

1. Advanced SQL & Data Warehousing Expertise
   • Core Skills:
     • Writing complex SQL queries for ELT/ETL pipelines in Netezza (preferred) or similar RDBMS (SQL Server, Oracle).
     • Designing optimized data models (fact/dimension tables) for analytics.
     • Handling high-volume batch jobs (e.g., nightly claims processing).
   • Tools: Netezza, SQL Server, SSIS, or similar ETL tools.
2. Unix/Linux Scripting for Automation
   • Automating data pipelines (e.g., cron jobs, error handling, file transfers).
   • Example: “Scripted daily data ingestion for 10TB healthcare datasets using Bash.”
3. Stored Procedure Development
   • Building reusable, efficient stored procedures for data transformations and batch workflows.
   • Example: “Created stored procedures to automate provider data aggregation, reducing runtime by 30%.”
4. MVC Code Integration
   • Collaborating with application teams to connect .NET MVC applications (C#, ASP.NET) to the data warehouse via APIs or direct SQL calls.
   • Example: “Integrated a member analytics dashboard (built in ASP.NET MVC) with Netezza via stored procedures.”
5. Healthcare Data Experience (Nice-to-Have)
   • Familiarity with healthcare datasets (claims, EHR, HL7) and compliance (HIPAA, PHI).

Understanding of healthcare analytics use cases (risk modeling, population health).

Would you like to know more about our new opportunity? For immediate consideration, please send your resume directly to Sreedhar at Sreedhar@bvteck.com

BvTeck is proud to be an equal opportunity workplace dedicated to pursuing and hiring a diverse workforce.