Search Jobvertise Jobs
Jobvertise

Sr. Database Developer
Location:
US-CA-San Diego - 92121
Jobcode:
JOB44929
Email this job to a friend

Report this Job

Report this job





Incorrect company
Incorrect location
Job is expired
Job may be a scam
Other







Apply Online
or email this job to apply later

Position: Sr. Database Developer
Location: San Diego, CA
Duration: 12+ Months Contract
Total Hours/week: 40.00
hybrid work week
local candidates preferred

Job Description
I. Department Overview
The 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 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
8+ years of experience working with Microsoft SQL Server with emphasis on database code, ETL 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 with data modeling tools such as ER/Studio or ERWin.
Experience using version control systems (e.g., TFS, Git).
Familiar with Agile software development process.
Working experience with Azure DB technologies and Azure deployments is a plus.
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 is a plus
Physical/Mental Requirements
Ability to communicate clearly both verbally and in writing.
Ability to analyze complex application and business operational issues.
Ability to multi-task and respond to quickly-shifting priorities.
Ability to work in a team and/or independently.
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.
Participate in daily team stand-ups, planning sessions, etc.

Alex Roy
MillenniumSoft, Inc
8301 Arlington Blvd, Suite # 504
Fairfax, VA 22031
Fax: 703-991-4551
Phone: 703 459 9282 X 101

Apply Online
or email this job to apply later


 
Search millions of jobs

Jobseekers
Employers
Company

Jobs by Title | Resumes by Title | Top Job Searches
Privacy | Terms of Use


* Free services are subject to limitations