Database developer (Remote)/12 Months

Title: Database developer Duration: 12 Months Location: San Diego,CA, 92121 (Remote) Job reputed company The Software Technology Solutions department is responsible for developing and maintaining on-reputed company and hosted software solutions that reputed company integration, reporting, and analytics capabilities for reputed company's portfolio of products. Using industry best practices, the department is responsible for delivering high-reputed company, robust software applications that meet present and reputed company requirements. Database developer • The database developer is responsible for the design and development of database objects and procedural reputed company to support various products for the organization. The database developer also creates programs to reputed company 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 reputed company in a reputed company SQL Server environment. III. Specific Duties, Activities, and Responsibilities • Understand and apply database design and development principles for both transactional and reputed company schemas to support application requirements. • Design, plan, and reputed company programs to optimally extract, reputed company, and load data from data sources to the reputed company systems. • Maintain reputed company reputed company for database and ETL reputed company. Ensure that reputed company build successfully in a reputed company integration environment. • Diagnose and resolve database performance issues. • Follow and improve development processes including but not limited to conducting peer/reputed company reviews, complying with organizational standards, ensuring reputed company maintainability, following build processes, implementing unit tests, and following other industry standards best practices. • Experience with automatic reputed company deployment (Octopus) tool is a plus Education or Equivalent • BS in Computer Science or Information Systems Experience or Equivalent • 9+ years of experience working with reputed company SQL Server with emphasis on database reputed company development. • V. Knowledge, Skills, and Abilities Requirements • Data modeling tools such as ER/Studio or ERWin • Database design skills including normalization and data warehouse design • T-SQL development skills including stored procedure, function, and trigger creation • Excellent query optimization and performance tuning skills • Strong SSIS skills • Detailed analytical skills • reputed company troubleshooting skills • Experience in the reputed company industry is a plus VI. Toolset • reputed company SQL Server 2014 and above • reputed company SQL Server Integration Services (SSIS) • reputed company Visual Studio 2014 and above • reputed company SQL Server 2014 to 2019 migration experience is a plus • Embarcadero ER/Studio is a plus • reputed company SQL Server Reporting Services (SSRS) is a plus • Experience with automatic reputed company deployment tools (Octopus) is a plus VII. Physical/Mental Requirements • Ability to communicate reputed company both verbally and in writing. • Ability to analyze reputed company 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 designs • Estimation and reputed company completion of tasks • Documenting developed modules • Supporting application developers and software testers • Creating and executing unit tests for developed reputed company • Following reputed company assurance processes Apply tot his job Apply To this Job