Principal DB Developer
5 months ago
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 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.
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 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.
- 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.
-
Java Developer with Mongo DB
4 days ago
San Francisco, United States Diverse Lynx Full timePosition: Java Developer with Mongo DB Location: San Francisco, CA Duration: ContractRequired Skill: Contribute to all stages of software development lifecycle Design, implement and maintain Java-based applications that can be high-volume and low-latency Analyze user requirements to define business objectives Envisioning system features and functionality...
-
Design Build Regional Sales Director
2 months ago
San Diego, United States HNTB Full timeWhat We're Looking For At HNTB, you can create a meaningful career while building communities that matter to all of us. For more than a century, we have been delivering solutions for some of the largest, most complex infrastructure projects across the country. With our historic growth, it is an exciting time to join our team of employee-owners. The...
-
Design Build Regional Sales Director
1 month ago
San Diego, United States HNTB Corporation Full timeWhat We're Looking For At HNTB, you can create a meaningful career while building communities that matter to all of us. For more than a century, we have been delivering solutions for some of the largest, most complex infrastructure projects across the country. With our historic growth, it is an exciting time to join our team of employee-owners. The...
-
San Jose, United States Semiconductor Engineering Full timeRambus, a premier chip and silicon IP provider, is seeking to hire an exceptional Senior Principal Systems Architect to join our Memory Interface Chip team in San Jose. Candidates will be joining some of the brightest inventors and engineers in the world to develop products that make data faster and safer.As a Senior Principal Systems Architect, the...
-
Principal Software Development Specialist
3 weeks ago
San Diego, California, United States Dynamic Solutions Technology LLC Full timeDynamic Solutions Technology, LLC is a leading provider of strategic services that cater to the IT and Service needs of commercial and government clients. We are seeking a full-time Software Engineer II to support contract work in San Diego, CA.Salary Range: $120,000 - $180,000 per annumAbout the Role:We are looking for an experienced software engineer to...
-
FaceTec Software Development Expert
3 weeks ago
San Diego, California, United States FaceTec, Inc. Full timeExciting Opportunity at FaceTec, Inc.We are a leading provider of 3D Face Authentication software, revolutionizing digital identity and trust. As a pioneering force in the industry, we seek an exceptional NodeJS Developer to join our San Diego Development Team.The ideal candidate will have expertise in developing large-scale web applications, REST APIs, and...
-
Principal / Sr Principal Engineer Aeronautical
3 weeks ago
San Diego, United States Northrop Grumman Full timeRequisition ID: R10178763 * Category: Engineering * Location: San Diego, California, United States of America * Clearance Type: Secret * Telecommute: Yes-May consider hybrid teleworking for this position * Shift: 1st Shift (United States of America) * Travel Required: Yes, 10% of the Time * Relocation Assistance: Relocation assistance may be available *...
-
Sr. Project Manager
3 months ago
San Diego, United States LVI Associates Full timeJob DescriptionJob DescriptionPosition: Sr. Project Manager / Principal - Land DevelopmentLocation: San Diego, CABase Salary: $165,000 - $195,000SummaryA top 10 ENR Design Firm is seeking a Sr. Project Manager / Principal with an interest in residential land development and other site civil design (health-care, military, hospitality, education, recreation)....
-
Sr. Project Manager
3 months ago
San Diego, United States LVI Associates Full timeJob DescriptionJob DescriptionPosition: Sr. Project Manager / Principal - Land DevelopmentLocation: San Diego, CABase Salary: $165,000 - $195,000SummaryA top 10 ENR Design Firm is seeking a Sr. Project Manager / Principal with an interest in residential land development and other site civil design (health-care, military, hospitality, education, recreation)....
-
Principal Application Engineer
1 month ago
San Diego, United States IC Resources Full timeI’m representing a company specialising in innovative RF front-end solutions, particularly for applications in Wi-Fi and 5G (UHB) networks, they are looking for a Principal Applications Engineer to join their team. Based in San Diego, offering a competitive base salary along with additional compensation components to further elevate your earnings. Their...
-
Principal Application Engineer
1 month ago
San Diego, United States IC Resources Full timeI’m representing a company specialising in innovative RF front-end solutions, particularly for applications in Wi-Fi and 5G (UHB) networks, they are looking for a Principal Applications Engineer to join their team. Based in San Diego, offering a competitive base salary along with additional compensation components to further elevate your earnings. Their...
-
Senior Principal Chief Engineer
3 weeks ago
San Diego, California, United States Northrop Grumman Full timeOverviewNorthrop Grumman is a pioneering leader in the development of advanced systems for national defense. Our innovative spirit and commitment to excellence have enabled us to be at the forefront of many technological advancements in our nation's history.We are seeking a highly skilled Senior Principal Chief Engineer to join our team and contribute to the...
-
Software Engineering Principal Position
3 weeks ago
San Diego, California, United States Northrop Grumman Full timeOverviewNorthrop Grumman Aerospace Systems has an opening for a highly skilled Principal Software Engineer to join our team in San Diego, CA or Oklahoma City, OK.This position requires experience with cloud-based development and expertise in Java Enterprise Edition (JEE) environments. As a principal engineer, you will lead the development of complex software...
-
Principal Application Engineer
4 weeks ago
San Diego, United States IC Resources Full timeI’m representing a company specializing in innovative RF front-end solutions, particularly for applications in Wi-Fi and 5G (UHB) networks, they are looking for a Principal Applications Engineer to join their team.Based in San Diego, offering a competitive base salary ($$$) along with additional compensation components to further elevate your...
-
San Diego, United States Northrop Grumman Full timeRequisition ID: R10174922 * Category: Engineering * Location: San Diego, California, United States of America * Clearance Type: Secret * Telecommute: No- Teleworking not available for this position * Shift: 1st Shift (United States of America) * Travel Required: Yes, 10% of the Time * Relocation Assistance: Relocation assistance may be available * Positions...
-
Software Principal Engineer
7 days ago
San Diego, California, United States Northrop Grumman Full timeWe are seeking a highly skilled Principal Software Engineer to join our team in San Diego, CA or Oklahoma City, OK.This is an exciting opportunity to work on revolutionary systems that impact people's lives around the world. Our pioneering and inventive spirit has enabled us to be at the forefront of many technological advancements in our nation's history.As...
-
San Diego, United States Northrop Grumman Full timeRequisition ID: R10177935 * Category: Engineering * Location: San Diego, California, United States of America * Clearance Type: Secret * Telecommute: Yes-May consider hybrid teleworking for this position * Shift: 1st Shift (United States of America) * Travel Required: Yes, 10% of the Time * Relocation Assistance: Relocation assistance may be available *...
-
Principal Database Architect
3 weeks ago
San Diego, California, United States MILLENNIUMSOFT Full timeMILLENNIUMSOFT is seeking a highly skilled Principal Database Architect to join our team in San Diego, CA.The estimated salary for this position is $125,000 per year, based on industry standards and location.Job Description:We are looking for a talented Principal Database Architect to lead the design and development of database systems that meet the needs of...
-
San Diego, United States Northrop Grumman Full timeRequisition ID: R10169391 * Category: Engineering * Location: San Diego, California, United States of America * Clearance Type: SAP * Telecommute: No- Teleworking not available for this position * Travel Required: Yes, 10% of the Time * Relocation Assistance: Relocation assistance may be available At Northrop Grumman, our employees have incredible...
-
San Diego, California, United States Northrop Grumman Full timeJob OverviewWe are seeking a skilled Principal Electronics Engineer Comms Systems Developer to join our team at Northrop Grumman. This position will be based in Rancho Bernardo, CA and will involve working on the design, development, integration, and testing of electronic equipment and systems.Key ResponsibilitiesResearch and develop new electronic equipment...