Reports to: Director, Data Management

Position Summary:

The Database Developer/DBA will be responsible for database design, implementation, development and maintenance of relational databases that consumes structured and unstructured data. The Developer/DBA will split duties between doing development in SQL (approximately 60%) and doing core DBA functions (approximately 40%). He/she will also need familiarity in reading Java and/or scripting languages that collects data from social media sources such as Facebook, forums, and blogs.

The Database Developer/DBA will support reporting needs of client services, data needs of modelers, and support data requirements from engineering.

In addition the Database Developer/DBA is responsible for all administrative tasks of the relational database that a DBA would perform.

This position provides a great opportunity for professional growth as it allows for developing databases and related ecosystems from the ground up.

Required Knowledge and Skills

• Significant background in creating complex functions/stored procedures/triggers in SQL
• Experience in database modeling tools
• Database optimization, backup and recovery, performance monitoring, security
• Database normalization concepts
• Strong analytical skills
• Good written and verbal communication skills
• Ability to set goals, and achieve scheduled deadlines
• Ability to work independently with minimal supervision as well as work in an agile team environment

Experience: Required
• 6-9 years of experience in database development with PostgreSQL or other RDBMS like MySQL, Oracle, etc.
• Experience in logical and physical database design and implementation
• Experience writing complex stored procedures
• Experience in ETL operations
• Experience with database system scaling
• Experience with database performance tuning
• Some experience with core DBA functions like backups, disaster recovery, security
• Familiarity with Java and/or scripting languages such as Python, Perl, etc.
• Minimum of a Bachelor’s degree in related field

Desired (not required):

• Experience in data warehousing and business intelligence tools such as WebFocus, Cognos, Business Objects
• Experience with NoSQL databases like Hadoop
• Experience working with marketing data