Develop and maintain complex stored procedures, views and functions on MariaDB, MySQL, DB2 AS400 and DB2 LUW databases.
Program and write SQL code to support the creation of tables, views, stored procedures, functions, reports and triggers.
Analyze data requirements for business applications; develop data models and data migration/conversion strategies for internally hosted applications.
Acquire business knowledge for: debugging model/data related issues, explaining the models to application teams or business.
Maintain and enhance technical aspects of database and data warehouse systems.
Provide operational and system support as well as technical expertise to software developers and database administrators.
Utilize software development principles and experience to support the full lifecycle of software products.
Work with application teams to identify ways to optimize the database tier and work to implement improvements for future releases.
Develop application and database standards/architecture to help ensure the scalability, performance and maintainability of applications.
Create standards to monitor and enhance capacity and performance.

Required Skills

Ability to be flexible and work well with changing priorities.
A self-starter who thrives with minimal supervision.
Understanding of performance tuning and database constraint concepts such as indexes, primary keys, etc.
Experience addressing production issues that involve SQL Database performance *Proven database query optimization, performance tuning/monitoring experience *Knowledge of physical database structures and best practices *Thorough understanding and hands-on application of the software development lifecycle and related methodologies.
Experience working with Agile development methodologies.
Strong time management skills with ability to participate in multiple projects/work streams simultaneously as well as strong analytical/problem solving skills.
Have the ability to express yourself well, verbally and on email.
Ability to work with all levels of staff, management and external vendors