PostgreSQL/MSSQL Database Administrator

As our software continues to grow, we're looking for a PostgreSQL Database Administrator to help maintain, optimize, and support the databases behind our business-critical applications.

This is a hands-on technical position working closely with our software development team to ensure our databases remain secure, reliable, and high performing.

Responsibilities

• Administer and maintain PostgreSQL and MSSQL databases in development, test, and production environments.
• Monitor database health, performance, and availability.
• Optimize SQL queries and database performance.
• Create and maintain indexes, backups, and recovery procedures.
• Assist with database upgrades, migrations, and deployments.
• Troubleshoot database performance and connectivity issues.
• Work closely with software developers on database design and application performance.
• Monitor database security and user permissions.
• Develop and maintain database documentation.
• Participate in on-call support as needed.

• 3-7 years of PostgreSQL/MSSQL database administration experience.
• Strong SQL skills.
• Experience with database backup and recovery.
• Experience tuning PostgreSQL for performance.
• Understanding of indexing, query optimization, and database design.
• Experience working in Linux environments.
• Ability to troubleshoot production issues independently.
• Strong communication and organizational skills.

Preferred Qualifications

Experience with any of the following is a plus:

• PostgreSQL replication
• PgAdmin
• Linux system administration
• Bash, PowerShell, or Python scripting
• Git
• Docker or Kubernetes
• Cloud platforms (AWS, Azure, or Google Cloud)
• High-availability database environments

Pulled from the full job description

• 401(k)
• Health insurance
• 401(k) matching
• Paid time off, We're looking for someone who enjoys solving technical problems, takes ownership of their work, and wants to grow alongside a rapidly expanding technology company. You'll work directly with experienced software engineers and leadership while helping build the database infrastructure behind our next generation of products.

Why Prodigy?

At Prodigy, you'll have the opportunity to make a meaningful impact on products used across the country. You'll work in a collaborative environment where good ideas are valued, technical excellence is appreciated, and your contributions directly influence the success of the company.

Pay: $100,000.00 - $125,000.00 per year, * 401(k)

• 401(k) matching
• Health insurance
• Paid time off

Prodigy Solutions develops enterprise technology solutions for correctional facilities across the United States, including inmate communications, trust accounting, tablets, kiosks, video visitation, and other mission-critical software platforms.