CPI is a leading technology solutions provider to state, federal, and international criminal justice institutions, delivering critical information for first responders and many who support them. We pride ourselves on the quality, in-house development, and industry expertise that have allowed us to serve this industry for over 35 years. The need to grow our talented engineering teams continues as more customers trust CPI’s solutions, and we look forward to discovering more about you and whether your skills and background are a good fit.
We seek a PostgreSQL Database Engineer to join our in-house software development team. This individual will be responsible for database administration and SQL development to support mission-critical systems. The ideal candidate will have strong PostgreSQL experience, familiarity with Enterprise DB (EDB Postgres) tools, and a background working in Linux environments. Job duties will include working with the DBA team to perform data migration tasks, install, configure, manage, and monitor database systems, and convert SQL objects (stored procedures, etc.) between Oracle, Postgres, and MS-SQL.
Required Qualifications:
- 3–5 years of overall database experience, with at least 2–3 years of hands-on experience administrating and developing with PostgreSQL
- Strong SQL development skills (MS SQL, MySQL, T-SQL, P/L SQL)
- Working knowledge of Linux-based operating systems and command-line tools
- Familiarity with database security best practices
- Solid written and verbal communication skills
Preferred Qualifications:
- Experience with EnterpriseDB (EDB Postgres) products or tools
- Experience with EDB Failover Manager (EFM)
- Exposure to Oracle database environments
- Scripting experience (Bash, KSH, Python, etc.) for automation and maintenance
- Experience supporting highly available or high-performance database environments
- Experience working with JIRA
- Experience working with GIT (or other source control)
Additional skill sets around SDLC:
- Waterfall and Agile concepts
- Test Automation
- Performance Testing
In addition to these technical skills, how we work and our co-workers' approach to the job is essential. We are looking for:
- A desire to contribute to the overall success of the team - Teamwork
- The ability to quickly learn and adapt skills - Aptitude
- Confidence in technical skills - Experience
Here is a handful of things we offer:
- An engineering firm at heart. Founded and run by software engineers.
- Family-run company with family values. Dad started the company, and the three sons are leading it into the future
- CPI pays 100% of the premiums for both employee & family and offers a PPO & HSA option.
- 401(k) benefits and profit sharing
- Annual Bonus Plan
- Flexible working hours to enable work-life balance.
- A fun corporate culture
CPI is an equal-opportunity employer. Any employee of CPI must be able to pass our clients' state and federal background requirements. CPI does not currently sponsor H1-B applications.
What We Do
Computer Projects of Illinois, Inc. (CPI), is a privately held corporation that delivers market-leading software solutions to the law enforcement industry. CPI develops & maintains many different best-in-class, mission-critical criminal justice solutions to law enforcement & public safety agencies around the world with their OpenFox® Product Suite.
Why Work With Us
The work we do is unique & highly rewarding. Working in a creative environment where an excellent work-life balance ensures that all employees are happy & productive. We have fun, but at the end of the day, all of our hard work actually impacts the safety of citizens & law enforcement officers across the country. Work hard. Play hard. Save Lives.
Gallery
CPI OpenFox Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
