What are the responsibilities and job description for the Database Developer position at Adroitts Inc?
Job Description
We are seeking a highly motivated Database Developer to contribute to the development and administration support of a large federal IT project. The candidate should have a solid understanding of database development, design and management, and should be able to perform quality control, transform data via ETL processes, debug and analyze code, and work with team members to ensure a high quality end product.
The ideal candidate for this position is someone who:
- Has excellent analytical, problem solving, and debugging skills
- Works both independently and as a part of a team
- Is able to effectively collaborate with a development team, business analysts, and project managers
Core Responsibilities:
- Provide development and administration support for numerous MS SQL databases (or similar RDBMS) in different environments
- Develop stored procedures, functions, packages, triggers and views using T-SQL
- Utilize SQL Management Studio to develop or modify database indexes, schema modification, and unit testing
- Work with product owner or business analyst to fully understand business requirements and convert into appropriate technical solutions
- Contributing member of a cross-functional team in charge of delivering new features and capabilities on an iterative basis
- Ability to digest existing SQL data models and modify or enhance as needed
- Provide accurate estimates of effort required to complete assignments
- Conduct code reviews to ensure all code passes organizationally-mandated code reviews and audits
- Proactively and regularly make recommendations for system improvements
- Complete assignments according to the established deadlines
- B.S. or M.S. in Computer Science or equivalent work experience
- Minimum of 5 years of experience in database schema design, development and management
- Deep knowledge of relational database’s objects, MS SQL Server Integration Services and SQL Scripts
- Familiarity with performance tuning and optimization
- Experience working in an Agile software development life-cycle
Preferred Qualifications:
- Data migration skills and working experience with ETL concepts and tools
- Developing/instantiating conceptual, logical, and physical data models, ER Diagram
- Understanding of Azure platform capabilities for the design and development of modern applications
- Experience in government health care programs