Software Engineer - Database Developer Carnegie Learning

Responsibilities:



This developer will design, implement, maintain and optimize databases and applications which power the company?s core products. The developer will be a key member on several related projects, including:

Convert production transactional data management into a flexible shared-purpose database
Update the Learning Management System (LMS), our roster and curriculum data management and reporting system written in Java, to access the database.
Maintain and enhance data flow between database and other reporting systems
Interface between the product database and internal ERP and CRM systems and external customer web portal


Collaborate on innovative solutions with other software engineers, researchers, quality assurance engineers, project managers, interface designers, and internal operations process owners to develop best of breed hosted instructional software and reporting solutions on schedule and on budget. Typical tasks through the development life-cycle include:

Define system requirements by consulting data administrators and system users about the types of information needed, performance, storage and security requirements
Determine how data should be organized, who should have access to different data and how it should be accessed and displayed
Design, develop and maintain data models and database architecture
Construct, install and test the database system and related applications
Integrate data flows between independent systems or databases
Maintain internal documentation and help draft end-user documentation
Prepare reports on databases and consult with others to assess the system performance
Modify existing databases, as user needs change
Customize databases for specific needs



Requirements:

BS degree in Computer Science, Computer Engineering, or related field required (or equivalent experience)
5 years of experience building, optimizing and maintaining database and database applications, including internet based transactional systems supporting >10000 concurrent users
Proven experience with sizing database hardware, performance tuning, debugging databases, resolving locking issues and deadlock avoidance

Experience with large scale implementation using PostGres, MySQL, Oracle running on Linux

Experience with Java programming language including JDBC and Swing
Experience with commercial report generation packages
Experience interfacing and synchronization between multiple databases, ETL and reporting is desired
Ability to accurately estimate projects and individual work
High commitment to quality
Self directed
Excellent verbal and written communication skills
Experience with complete software development lifecycle, including requirement assessment and QA testing is desired
Must be eligible to work in the United States

Location:	1200 Penn Avenue Suite 150 Pittsburgh, PA 15222 United States