What are the responsibilities and job description for the Sr. Database Developer position at MILLENNIUMSOFT?
Title : Sr. Database Developer
Location : San Diego, CA
Contract Term : 12 Months
Weekly 40.00 hours
1st Shift
Client : Medical Device Company
Job Category : Engineering
Employment Type : Contract on W2 (Need US Citizens Or GC Holders Only)
No H1B’s
Description : Department Overview
The Software Technology Solution 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.
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.
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.
- Develop or modify procedures to solve complex database design problems, including performance, scalability, security and integration issues.
- Troubleshooting and tuning complex SQL statements and making recommendations on indexing strategies.
- 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.
- Troubleshoot issues in an efficient and systematic manner to identify and resolve underlying causes as well as take a proactive approach to solving problems creatively using available resources.
- Support of production systems.
- Work with peers to prioritize and complete daily tasks and Production issues.
- Participate in daily team stand-ups, planning sessions, etc.
Position Requirements
Education or Equivalent
Experience
Preferred to have
Toolset
Physical / Mental Requirements
Any Additional / Important Information
The database developer will be additionally responsible for the following tasks :
