Database Administrator

Apply

Brand: Leapfrog Online
Location: Chicago - N. State
Full Time / Part Time: Full time
Post Open Date: 08/07/2019

iProspect’s Technology Team runs like an agile startup team even though we’re a 50-person team with Engineering and Product backgrounds. We believe that hiring people from different backgrounds and experiences builds a stronger team. Our culture is one that fosters teaching and learning and as a result, we focus on building and developing talent as a means to build great software and systems. We’re an Open Source shop. We use Ruby, Python, and JavaScript; PostgreSQL, RabbitMQ and Redis; Consul, Ansible, Terraform, and Prometheus.  We do use some commercial tools, though, like SQL*Server and Tableau.

We like to be open-minded and pragmatic. We use Agile/Scrum to run our teams, but more importantly, we dedicate a lot of effort to team development—making sure teams have the resources and environment most conducive to their success.

Responsibilities

  • Acquires and applies intermediate knowledge of database design and management including modeling, creation and maintenance of database objects.
  • Applies in-depth understanding of database tools and utilities in at least one DBMS platform
  • Demonstrates highly developed SQL and database performance tuning skills.
  • Performs evaluation, modification and integration functions associated with vendor supplied database software.
  • Ensures business continuity by developing and implementing highly available database systems, and database backup and recovery plans and procedures.
  • Liaises with database software vendors and external technical support on issues.
  • Serves as a resource to less experienced team members on escalated issues of a routine nature.

Qualifications

Minimum

  • Bachelors Degree in a relevant field or equivalent work experience
  • 4+ years of relevant database design or administration and/or systems/development life cycle experience
  • Experience as a DBA working with PostgreSQL
  • Experience and knowledge with ETL & bulk data import/export
  • Experience with data partitioning and data sharding
  • Experience with technical programming languages
  • Experience with database design and database management systems
  • Experience in Linux server provisioning and configuration
  • Experience with Python and Linux shell scripting

Preferred

  • Experience as a DBA with AWS Cloud databases, especially AWS RDS for PostgreSQL
  • Has designed and implemented AWS Cloud databases and database clusters for highly-available applications, disaster recovery, and performance
  • Experience with AWS database migration
  • Experience with Ansible and Terraform, or other provisioning and configuration management tools
  • Experience in Windows server provisioning and configuration
  • Experience as a DBA with Microsoft SQL Server
  • Experience with Microsoft Active Directory administration
  • In-memory databases knowledge (Redis)
  • Elasticsearch knowledge
  • Replication of large amounts of data between geographical regions

About the Company

As a performance marketing agency, iProspect helps brands uncover new customers and revenue by delivering relevant experiences and connecting data. We’ve built a proprietary technology platform that delivers experiences at each step of a consumer’s journey and collects a rich stream of data to learn what treatments increase the likelihood of a valuable outcome for our clients. We use distributed systems to solve complex compute problems, develop data architectures to support analysis and uncover insights, and use those insights to deliver optimal consumer experiences at scale. Our platform is a high-volume processing system supporting some of the largest companies in the US in ways their internal teams, agencies and IT consultants simply cannot.

Perks

iProspect is a great place to work. We have competitive pay, a matching 401k package, life & disability insurance as well as bonus potential. We focus on education, training and inclusivity on our teams in our day-to-day work, and by encouraging and financially supporting our employees to attend relevant training and conferences. We have a casual environment and strive to maintain a work/life balance, including flexible work scheduling options and parental leave. We moved into a brand-new office space at 515 N. State in Chicago’s River North at the end of May. The Grand and State Red Line stop is right outside the front door and there are lots of great lunch spots within walking distance. 

The real perk of this job is the ability to contribute to a profitable and growing company that strives to give employees the ability to master their craft, increase their skills and be autonomous in their work. We are a small enough division that you can witness and be rewarded for your contributions but are part of large network that allows us to partner with Fortune 100 companies. We support an individual's contribution to the community at large with multiple philanthropic activities and encourage employees to be part of their larger working collective by attending and supporting prominent conferences.

What's Next

Consider your background, what you know, what you want to learn in your career, and how you feel you fit this position. If you think you would be a good fit, we’d love for you to send us your resume.