Don't worry, we can still help! Below, please find related information to help you with your job search.
Senior Sql Developer (100% Remote)
Company | Humana |
Address | , San Antonio, 78229, Tx |
Employment type | FULL_TIME |
Salary | |
Expires | 2023-07-17 |
Posted at | 11 months ago |
The Senior Software Engineer codes software applications based on business requirements. The Senior Software Engineer work assignments involve moderately complex to complex issues where the analysis of situations or data requires an in-depth evaluation of variable factors.
Responsibilities
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:
- Ability to create new and modify existing reports and using Data Transformation Services (DTS)
- 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
- Documenting steps needed to migrate database objects between various environments including Development, UAT, Staging, and Production
- 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
- Participating in design and code reviews to maintain our high development standards
- Tuning T-SQL queries (DDL, DML and DCL) to improve the database performance and availability
- Remediation of issues found during testing candidates need to be problem solvers and troubleshoot existing code based on specifications provided
- A proven team player, you’ll have the opportunity to provide hands-on leadership while taking an active role in collaborative assessments and design
- Ensure high quality software through adherence to Test Driven Development (TDD) as the foundation of development and enabling CI/CD and DevSecOps practices
- Writing complex Stored Procedures, User Defined Functions (UDFs), Triggers, Common Table Expressions (CTEs), Table Variables and Views
- In this role, you will lead the design, development, and support of our Humana Pharmacy applications
- Providing Production support responsibilities for the existing SSIS Packages
- Collaborate with and across Agile teams to design, develop, test, implement, and support technical solutions in full-stack development tools and technologies
Required Qualifications
- Strong understanding data modeling
- Best practices for data development within a PCI environment
- Experience writing SQL/Functions/Procedures in transactional database systems such as Oracle, SQL Server, DB2
- Experience working with clients to develop and document system requirements
- 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
- Professional development experience using SQL, SSIS, SQL Job Agent, Python, SSRS, APIs, JSON, XML, PowerShell, Windows task scheduler
- 8+ years of experience developing and architecting complex SSIS packages
- Conceptual, logical, and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts)
- Deep understanding of relational database design concepts and SQL programming
- 9+ years of experience with SQL Server/T-SQL programming in creation and optimization of stored procedures, triggers, and user defined functions
- Bachelor's Degree in Computer Science, Engineering, Management Information Systems, or equivalent education or work experience
- Experience managing and monitoring database server environments, familiar with SQL profiler
Preferred Qualifications
- Strong understanding data modeling
- 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
- Conceptual, logical, and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts)
- Master's Degree
- Deep understanding of relational database design concepts and SQL programming
- 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
Additional Information:
Work at Home Guidance
To ensure Home or Hybrid Home/Office associates’ ability to work effectively, the self-provided internet service of Home or Hybrid Home/Office associates must meet the following criteria:
At minimum, a download speed of 25 Mbps and an upload speed of 10 Mbps is recommended; wireless, wired cable or DSL connection is suggested
Satellite, cellular and microwave connection can be used only if approved by leadership
Associates who live and work from Home in the state of California, Illinois, Montana, or South Dakota will be provided a bi-weekly payment for their internet expense.
Humana will provide Home or Hybrid Home/Office associates with telephone equipment appropriate to meet the business requirements for their position/job.
Work from a dedicated space lacking ongoing interruptions to protect member PHI / HIPAA information
#LI - Remote
Scheduled Weekly Hours
40Not Specified
0
-
Systems Analyst - Excel, Xml, Sql, Scripting
By CyberCoders At Salt Lake City, UT, United States 7 months ago
-
(Senior) Finance & Shared Services Manager
By Catholics For Choice At Washington, DC, United States 7 months ago
-
Paralegal - Probate Administration
By CyberCoders At Miami, FL, United States 7 months ago
-
Account Executive - Automotive Software
By ECW Search At United States 7 months ago
-
Construction Project Coordinator Jobs
By CyberCoders At River Falls, WI, United States 7 months ago