PostgreSQL DBA
Centerfield develops intelligent digital advertising technology focused on real time biddable media which enables targeting and acquisition of high performing, high life time value customers for its clients across numerous industries. The Company’s sophisticated marketing technology platform leverages Big Data and optimizes each part of the customer acquisition process from initial view through offline sale in real time for the highest possible return on advertising spend.
Job Description
We’re looking for a highly motivated PostgreSQL Database Administrator/Developer. Ideal candidates must have solid experience administering PostgreSQL installations, including creating and maintaining replication/clusters as well as query and index optimization. You will be responsible for the day to day operation and maintenance of our PostgreSQL infrastructure and will also be asked to contribute in the design and administration of our NOSQL installations which include Druid.io, Redis and MongoDB.
· Build and administer a cluster of PostgreSQL databases
· Experience with PostgreSQL functions and query language
· Experience with query and index optimization
· Participate in with an energetic team on a rapid, agile development schedule.
Skills/Attributes Required
· 3+ years’ experience with database administration, design and development using PostgreSQL
· Experience with MS SQL Server
· Advanced knowledge of data modeling
· Advanced SQL language knowledge
· Comfortable with successfully delivering complex solutions in tight timeframes that hit the mark on the initial delivery.
· Excellent written and verbal communication skills.
· Able to communicate effectively in business terms with business partners up to the VP level.
* Effective self-management skills, in particular the ability to multitask and prioritize.
· Must be able to work independently as well as in a team environment
Preferred:
o Experience with NOSQL technologies such as Druid.io, MongoDB and Redis
o Experience with small to medium project management including developing estimates, schedules requirements documentation, and test plans.
o Experience in testing new data and reports for consistency, accuracy, and fit-for-purpose.
Skills/Attributes Desired
· C#, .NET
· Business Intelligence/Data Mining
· NoSQL technologies