Job added in hotlist
Applied job
Contract job
90-day-old-job
part-time-job
Recruiter job
Employer job
Expanded search
Apply online not available
View more jobs in Charlotte, NC
View more jobs in North Carolina

Job Details

Database Developer - SQL

Location
Charlotte, NC, United States

Posted on
Apr 11, 2023

Apply for this job






Profile

Description

If you have a desire to make a difference and have a 'real' impact, we want to talk to you!

Humana's Pharmacy Org is seeking a Senior Software engineer who is self-motivated, Tech savvy, curious and loves the challenge of solving problems that improve people's lives. You'll collaborate with a fun and close-knit agile team to architect, implement, test, and continuously deliver new features and products to our customers.

Responsibilities

Responsibilities:


In this role, you will lead the design, development, and support of our Humana Pharmacy applications
Writing complex Stored Procedures, User Defined Functions (UDFs), Triggers, Common Table Expressions (CTEs), Table Variables and Views
Tuning T-SQL queries (DDL, DML and DCL) to improve the database performance and availability
Objects creation such as Tables and Views, Table Normalization, User Created Data Types, User Profiles, Data Dictionaries, Data Integrity, Performance Tuning, Indexes and appropriate Triggers to facilitate efficient data manipulation and data consistency
Documenting steps needed to migrate database objects between various environments including Development, UAT, Staging, and Production
Ability to create new and modify existing reports and using Data Transformation Services (DTS)
Remediation of issues found during testing candidates need to be problem solvers and troubleshoot existing code based on specifications provided
Providing Production support responsibilities for the existing SSIS Packages
Participating in design and code reviews to maintain our high development standards
Ensure high quality software through adherence to Test Driven Development (TDD) as the foundation of development and enabling CI/CD and DevSecOps practices
A proven team player, you'll have the opportunity to provide hands-on leadership while taking an active role in collaborative assessments and design
Collaborate with and across Agile teams to design, develop, test, implement, and support technical solutions in full-stack development tools and technologies
Troubleshoots business and production issues by gathering information (for example, issue, impact, criticality, possible root cause); engaging support teams to assist in the resolution of issues; formulating an action plan; performing actions as designated in the plan; interpreting the results to determine further action; performs root cause analysis to prevent future occurrence of issues; and completing online documentation


Required Qualifications


Required Qualifications:
Bachelor's Degree in Computer Science, Engineering, Management Information Systems, or equivalent education or work experience
Senior SSIS developer with a strong technical background in SQL Server who has extensive knowledge in designing, developing, testing and maintaining SQL data and ETL packages using SSIS
9 years of experience with SQL Server/T-SQL programming in creation and optimization of stored procedures, triggers, and user defined functions
8 years of experience developing and architecting complex SSIS packages
Professional development experience using SQL, SSIS, SQL Job Agent, Python, SSRS, APIs, JSON, XML, PowerShell, Windows task scheduler
Ability to write high performing complex queries
Experience managing and monitoring database server environments, familiar with SQL profiler
Best practices for data development within a PCI environment
Strong understanding data modeling
Deep understanding of relational database design concepts and SQL programming
Conceptual, logical, and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts)
Experience working with clients to develop and document system requirements
Experience writing SQL/Functions/Procedures in transactional database systems such as Oracle, SQL Server, DB2


Preferred Qualifications


Technical background in SQL Server who has extensive knowledge in designing, developing, testing and maintaining SQL data and ETL packages using SSIS
Experience with SQL Server/T-SQL programming in creation and optimization of stored procedures, triggers, and user defined functions
Experience using SQL, SSIS, SQL Job Agent, Python, SSRS, APIs, JSON, XML, PowerShell, Windows task scheduler
Experience managing and monitoring database server environments, familiar with SQL profiler
Strong understanding data modeling
Deep understanding of relational database design concepts and SQL programming
Conceptual, logical, and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts
Master's Degree


Additional Information

Work-At-Home Requirements


WAH requirements: Must have the ability to provide a high-speed DSL or cable modem for a home office. Associates or contractors who live and work from home in the state of California will be provided payment for their internet expense.
A minimum standard speed for optimal performance of 25*10 (25mpbs download x 10mpbs upload) is required.
Satellite and Wireless Internet service is NOT allowed for this role.
A dedicated space lacking ongoing interruptions to protect member PHI / HIPAA information


#LI - Remote

Scheduled Weekly Hours

40

Humana complies with all applicable federal civil rights laws and does not discriminate on the basis of race, color, national origin, age, disability, sex, sexual orientation, gender identity or religion. We also provide free language interpreter services. See our ****

Company info

Sign Up Now - InformationTechnologyCrossing.com

Similar Jobs:
Description We have an exciting opportunity to join our team and be a part of modernization our Data Ecosystem at Humana from an on prem solution to a cloud solution. As a Senior Software Engineer you will be able to utilize your...
Software Engineer 2 (Remote - US)
Location : Charlotte, NC
Description The Software Engineer 2 codes software applications based on business requirements. The Software Engineer 2 work assignments are varied and frequently require interpretation and independent determination of the approp...
Job Information Humana Senior Enterprise Architect - Experience & Analytics (Remote, Virtual, Home office) in Charlotte North Carolina Description Do you thrive on working on the cutting edge technology solutions? Working with tea...
By using Employment Crossing, I was able to find a job that I was qualified for and a place that I wanted to work at.
Madison Currin - Greenville, NC
  • All we do is research jobs.
  • Our team of researchers, programmers, and analysts find you jobs from over 1,000 career pages and other sources
  • Our members get more interviews and jobs than people who use "public job boards"
Shoot for the moon. Even if you miss it, you will land among the stars.
InformationTechnologyCrossing - #1 Job Aggregation and Private Job-Opening Research Service — The Most Quality Jobs Anywhere
InformationTechnologyCrossing is the first job consolidation service in the employment industry to seek to include every job that exists in the world.
Copyright © 2024 InformationTechnologyCrossing - All rights reserved. 21 192