Logo
MILLENNIUMSOFT

Principal DB Developer

MILLENNIUMSOFT, San Diego, California, United States, 92189

Save Job

Join to apply for the

Principal DB Developer

role at

MillenniumSoft Inc 11 months ago Be among the first 25 applicants Join to apply for the

Principal DB Developer

role at

MillenniumSoft Inc Get AI-powered advice on this job and more exclusive features. I. Department Overview:

The Core Services department is responsible for developing and maintaining on-premise and hosted software solutions that provide integration, reporting, and analytics capabilities for the companys portfolio of products. Using industry best practices, the department is responsible for delivering high-quality, robust software applications that meet present and future requirements. Position :

Principal DB Developer

Location : San Diego, CA

Duration : 12 months contract

Total Hours/week : 40.00

Position Description

I. Department Overview:

The Core Services department is responsible for developing and maintaining on-premise and hosted software solutions that provide integration, reporting, and analytics capabilities for the companys portfolio of products. Using industry best practices, the department is responsible for delivering high-quality, robust software applications that meet present and future requirements.

II. Purpose

The 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 departments 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. Design, develop and maintain SQL Server Reporting Services reports. 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 standard best practices.

IV. Position Requirements

Education or Equivalent

BS in Computer Science or Information Systems

Experience Or Equivalent

5+ years of experience working with Microsoft SQL Server with emphasis on database code and Reporting Services development.

Knowledge, Skills, And Abilities Requirements

Database design skills including normalization and data warehouse design. Strong hands-on T-SQL development skills including stored procedure, function, and trigger creation. Excellent query optimization and performance tuning skills. Extensive experience developing SSRS reports. Strong SSIS skills. Detailed analytical skills. Structured troubleshooting skills. Experience in the healthcare industry is a plus.

Toolset

Microsoft SQL Server 2012 and above Microsoft SQL Server Integration Services (SSIS) Microsoft SQL Server Reporting Services (SSRS) Microsoft Visual Studio 2012 and above Embarcadero ER/Studio

Physical/Mental Requirements

Ability to communicate clearly both verbally and in writing. Ability to analyze complex application and business operational issues.

Any Additional/Important Information

The database developer will additionally be responsible for the following tasks: Analyzing requirements in order to create software designs. Estimation and timely completion of tasks. Documenting developed modules. Supporting application developers and software testers. Creating and executing unit tests for developed code. Resolving problems in the production system. Following quality assurance processes.

Responsibilities

Responsible for developing, enhancing, and sustaining software systems in a cross-functional team environment through adherence to established design control processes and good engineering practices. Demonstrates working knowledge of software engineering practices, techniques and processes and basic knowledge of technology trends and domain expertise. Understands and analyzes requirements for a single component. Translates the results of analysis into design by Designing solutions to address a specific requirement. Develop modules with moderate guidance. Has developed knowledge and skills in own job family; still acquiring / expanding fundamental knowledge and higher-level skills. Applies knowledge and skills to a variety of standard activities. Works with moderate guidance in own area of knowledge. Requires a BS degree preferably Computer Science, Computer Engineering, Mathematics, Physics or a related Engineering discipline and 5+ years' experience. Demonstrated understanding of multi-threaded software design and development. Excellent written and oral communication and interpersonal skills are essential. Demonstrated understanding of development in a process oriented/regulated environment and adhering to a quality management system. Seniority level

Seniority level

Mid-Senior level Employment type

Employment type

Full-time Job function

Job function

Engineering and Information Technology Industries

Staffing and Recruiting Referrals increase your chances of interviewing at MillenniumSoft Inc by 2x Sign in to set job alerts for Principal Developer roles.

Software Engineer - Windows on Snapdragon

Software Engineer I, Backend (Identity Decisioning)

Software Engineer, New Grad & Entry Level

Software Engineer - Java (Multi Skilled)

Software Security Engineer (Multiple Levels)

Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr