Database developer (Remote)/12 Months

Title: Database developerDuration: 12 MonthsLocation: San Diego,CA, 92121 (Remote)Job DescriptionThe Software Technology Solutions department is responsible for developing and maintaining on-premise and hosted software solutions that provide integration, reporting, and analytics capabilities for the company's portfolio of products. Using industry best practices, the department is responsible for delivering high-quality, robust software applications that meet present and future requirements.Database developerThe database developer is responsible for the design and development of database objects and procedural code to support various products for the organization. The database developer also creates programs to populate and maintain the data in the department's transaction processing and data warehousing systems. This involves the creation of ETL programs along with the supporting stored procedures, functions, triggers, and constraints. The position requires extensive hands-on experience developing database queries, ETL, and associated code in a Microsoft SQL Server environment.III. Specific Duties, Activities, and Responsibilities Understand and apply database design and development principles for both transactional and dimensional schemas to support application requirements.Design, plan, and develop programs to optimally extract, transform, and load data from data sources to the target systems.Maintain source code for database and ETL projects. Ensure that projects build successfully in a continuous integration environment.Diagnose and resolve database performance issues.Follow and improve development processes including but not limited to conducting peer/code reviews, complying with organizational standards, ensuring code maintainability, following build processes, implementing unit tests, and following other industry standards best practices.Experience with automatic code deployment (Octopus) tool is a plusEducation or Equivalent BS in Computer Science or Information SystemsExperience or Equivalent 9+ years of experience working with Microsoft SQL Server with emphasis on database code development.V. Knowledge, Skills, and Abilities RequirementsData modeling tools such as ER/Studio or ERWinDatabase design skills including normalization and data warehouse designT-SQL development skills including stored procedure, function, and trigger creationExcellent query optimization and performance tuning skillsStrong SSIS skillsDetailed analytical skillsStructured troubleshooting skillsExperience in the healthcare industry is a plusVI. Toolset Microsoft SQL Server 2014 and aboveMicrosoft SQL Server Integration Services (SSIS)Microsoft Visual Studio 2014 and aboveMicrosoft SQL Server 2014 to 2019 migration experience is a plusEmbarcadero ER/Studio is a plusMicrosoft SQL Server Reporting Services (SSRS) is a plusExperience with automatic code deployment tools (Octopus) is a plusVII. Physical/Mental Requirements Ability to communicate clearly both verbally and in writing.Ability to analyze complex application and business operational issues.VIII. Any Additional/Important Information The database developer will be additionally be responsible for the following tasks:Analyzing requirements to create software designsEstimation and timely completion of tasksDocumenting developed modulesSupporting application developers and software testersCreating and executing unit tests for developed codeFollowing quality assurance processes