Database Developer

About the role

Database Developers design, build, and optimize the data storage systems that applications depend on. They write complex queries and stored procedures, design schemas that support application requirements, tune performance, manage data migrations, and ensure data integrity. The role combines deep SQL knowledge with understanding of application behavior and business data requirements.

Responsibilities

• Designing and coding the data warehousing system to desired company specifications as defined by end users
• Conducting preliminary testing of the warehousing environment before data is extracted
• Ensures Data Quality and Accuracy
• Extracting company data and transferring it into the warehousing environment
• Follows approved life-cycle methodologies, creates design documents, and performs program coding and testing
• Develops and conducts program tests; develops test plans and data, performs and/or oversees testing to verify the program function correctly and ensure modifications haven’t caused error to other areas
• Resolves technical issues through debugging, research and investigation
• Conducts and coordinates investigative and analytical studies of complex system functions and operations to select approaches for the resolution of complex problems or improving the efficiency of existing systems
• Develops complex program documentation using structure diagrams, behavior diagrams and interaction diagrams, system and program flowcharts, test plans and conversion plans
• Reviews the development and coding of programs and systems
• Ensures appropriate documentation is utilized in information systems projects
• Performs post implementation reviews to determine if the system cost objectives of the project were achieved
• Analyzes and recommends new procedures and techniques to improve the supported systems

Skills