Database Developer - Sql

R-304091
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:

• Documenting steps needed to migrate database objects between various environments including Development, UAT, Staging, and Production
• Collaborate with and across Agile teams to design, develop, test, implement, and support technical solutions in full-stack development tools and technologies
• 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
• Tuning T-SQL queries (DDL, DML and DCL) to improve the database performance and availability
• Writing complex Stored Procedures, User Defined Functions (UDFs), Triggers, Common Table Expressions (CTEs), Table Variables and Views
• A proven team player, you’ll have the opportunity to provide hands-on leadership while taking an active role in collaborative assessments and design
• 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
• Remediation of issues found during testing candidates need to be problem solvers and troubleshoot existing code based on specifications provided
• Ability to create new and modify existing reports and using Data Transformation Services (DTS)
• Providing Production support responsibilities for the existing SSIS Packages
• Ensure high quality software through adherence to Test Driven Development (TDD) as the foundation of development and enabling CI/CD and DevSecOps practices
• Participating in design and code reviews to maintain our high development standards
• In this role, you will lead the design, development, and support of our Humana Pharmacy applications

Required Qualifications

• 9+ years of experience with SQL Server/T-SQL programming in creation and optimization of stored procedures, triggers, and user defined functions
• Best practices for data development within a PCI environment
• 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
• Ability to write high performing complex queries
• 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
• Strong understanding data modeling
• Bachelor's Degree in Computer Science, Engineering, Management Information Systems, or equivalent education or work experience
• 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
• Experience managing and monitoring database server environments, familiar with SQL profiler
• Deep understanding of relational database design concepts and SQL programming
• Required Qualifications:
• Experience writing SQL/Functions/Procedures in transactional database systems such as Oracle, SQL Server, DB2

Preferred Qualifications

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

Additional Information
Work-At-Home Requirements

• Satellite and Wireless Internet service is NOT allowed for this role.
• A dedicated space lacking ongoing interruptions to protect member PHI / HIPAA information
• A minimum standard speed for optimal performance of 25×10 (25mpbs download x 10mpbs upload) is required.
• 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.

#LI - Remote
Scheduled Weekly Hours
40