What are the responsibilities and job description for the Senior SQL Server Developer position at Bright Vision Technologies?
Bright Vision Technologies has an immediate opportunity for a Senior SQL Server Developer based out of Jacksonville, FL.
Job Title: Senior SQL Server Developer – ELT, Unix, Stored Procedures
Location: Jacksonville, FL (Onsite)
Duration: Long term contract
Interview Mode: In-Person interview is required for the final round at Jacksonville, FL
Visa Type: OPT/CPT/H4EAD/L2 EAD/TN Visa/H1B Transfer [must be on our W2]
Job Description:
Responsibilities:
Required Skills & Experience:
Ideal Candidate Profile:
Core Skills:
Would you like to know more about this opportunity? For immediate consideration, please send your resume directly to Dinesh at dinesh@bvteck.com or contact us via phone at 1-908-765-8099.
At BVTeck, we are committed to providing equal employment opportunities and fostering an inclusive work environment. We encourage applications from all qualified individuals regardless of race, ethnicity, religion, gender identity, sexual orientation, age, disability, or any other protected status. If you require accommodations during the recruitment process, please let us know.
Job Title: Senior SQL Server Developer – ELT, Unix, Stored Procedures
Location: Jacksonville, FL (Onsite)
Duration: Long term contract
Interview Mode: In-Person interview is required for the final round at Jacksonville, FL
Visa Type: OPT/CPT/H4EAD/L2 EAD/TN Visa/H1B Transfer [must be on our W2]
Job Description:
- 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).
Ideal Candidate Profile:
- A Senior Developer as an Oracle PL/SQL or SQL developer with handling the below stuff.
- 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.
- 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.”
- 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%.”
- 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.”
- 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 this opportunity? For immediate consideration, please send your resume directly to Dinesh at dinesh@bvteck.com or contact us via phone at 1-908-765-8099.
At BVTeck, we are committed to providing equal employment opportunities and fostering an inclusive work environment. We encourage applications from all qualified individuals regardless of race, ethnicity, religion, gender identity, sexual orientation, age, disability, or any other protected status. If you require accommodations during the recruitment process, please let us know.
