Dillon Software, Inc.

Senior Database Developer

Dillon Software, Inc. published 4 months ago


Senior, Contract

No office location

Location Availability

about gs16 gsx sm fd column ml8 mr8 mb8 preferred timezone fw bold gmt 07 00 mountain time section sectio

Senior Database Developer

Dillon Software, Inc. | No office location

About this job

Job type: Contract
Experience level: Senior
Role: System Administrator
Industry: Entertainment, Manufacturing
Company size: 11-50 people
Company type: Private

Remote details

Preferred Timezone: (GMT-07:00) Mountain Time


Job description

Dillon Software is looking for a highly skilled and experienced database developer to contribute toward several very large projects.  The position is actually a combination of four roles:

Database Architect - understand very complex application requirements and design appropriate data structures that meet the requirements, plan and execution database migration activities (e.g. from Oracle to PostgreSQL) with little to no downtime,

Database Optimizer - tune existing database interactions, look for suboptimal SQL and optimize it either through restating it, providing indexes, redesigning it to use other structures such as materialized views, serve as a consulting resource to other developers and clients,

Database Administrator - monitor database infrastructure in Amazon RDS, proactively looking for capacity issues; deploy new environments, create and manage credentials for developers,

Database Developer - write and deploy high-performance triggers, stored procedures and functions where appropriate

Skills & Requirements

EXPERT level skills with the following are REQUIRED for consideration:

  • PostgreSQL 9.6 and above, including plpgsql
  • Oracle 11gR2, including pl/sql
  • SQL query optimization in both PostgreSQL and Oracle environments, including the ability to accurately interpret query plans

In addition to the requirements, we would also strongly favor candidates with the following experience:

  • Oracle 12 and above
  • Data partitioning and sharding
  • NoSQL data stores, particularly DynamoDB, MongoDB
  • Redshift and other bigdata stores and analysis tools

Only individual candidates located in the United States and meeting all the requirements should apply. No agencies or firms - domestic or offshore. We will not consider or respond to candidates not meeting all the requirements. This is a remote, 1099 contractor position. If applying, please include your resumé, three recent professional references, and your hourly billing rate.

About Dillon Software, Inc.

Dillon Software is a team of 30 highly skilled system architects, designers, and developers delivering web and mobile applications to clients in the entertainment, financial and manufacturing industries.  Our core strengths are Java technologies and relational databases, web, iOS, and Android applications.  For the right candidate, we offer challenging long-term projects, a large degree of creative input, location and scheduling flexibility, and the opportunity to interact with a great bunch of people who are at the top of their respective fields.

We strive for perfection as much as possible.  Service and quality are what distinguish us from our competitors.  If you're accustomed to delivering "good enough", this is not the right position for you.  Code formatting, variable names, unit test structure, appropriate use of whitespace, spelling, and grammar in comments and written communications - all these things are very important to us.  Great code is like a race car - high functionality and performance for the intended task, but every detail is beautiful and thoroughly engineered.

Based in beautiful Whitefish, Montana, we have a diverse team of remote professionals from New York to California and points in between.  You must be very comfortable working on a geographically dispersed team - and you must have the personality type that allows others to feel comfortable working with you.


  • Join an outstanding team of seasoned developers
  • Fun, engaging long term projects
  • Startup excitement but with no funding worries

Joel Test

Source control
One-step build
Daily builds
Bug database
Bugs fixed before writing new code
Up-to-date schedule
Quiet working conditions
Best tools that money can buy
Code screening
Hallway usability testing
Learn more about Dillon Software
Senior Database Developer at Dillon Software, Inc.