Interclypse is seeking an experienced PostgreSQL Subject Matter Expert (SME) to lead our database team. The ideal candidate will have a robust background in database administration, architecture, and PostgreSQL development. The SME will be responsible for ensuring the performance, integrity, and security of the unit’s PostgreSQL databases.
Responsibilities will consist of, but not limited to, the following:
- Design and implement database architectures that support business requirements and achieve high performance, availability, and security.
- Oversee the installation, configuration, and maintenance of PostgreSQL databases.
- Conduct performance tuning of database systems, including queries, stored procedures, and indexing strategies.
- Develop and implement database backup, recovery, and failover procedures.
- Assist in the design and development of data models and database solutions.
- Collaborate with development teams to optimize database code in application layers.
- Provide guidance on database best practices to IT staff and other stakeholders.
- Ensure database infrastructure is up-to-date with the latest technology trends and security patches.
- Develop and maintain documentation regarding database configurations, architectures, and procedures.
- Serve as the point of contact for database-related queries and technical support.
Our favorite candidates are resilient problem solvers, cooperative teammates, and passionate innovators.
Why You Might Like This Job:
- You’re tired of working for a massive organization.
- You want to work for an established company that values your stable career.
- You want to work with a team that loves their job and making cool stuff.
- You want to be part of a team focused on making a positive impact.
- You want to grow your skills in management or work toward becoming an expert.
- You want to have the option for career mentorship, both in technology and in business.
- You value a company with a strong culture of growth and support
Interclypse provides a uniquely cultivating environment where mentorship and continued learning create extraordinary professionals. Our goal is to empower our talent by putting you in the driver’s seat of your career.
Required Skills and Experience
- Strong expertise in PostgreSQL database administration, tuning, management, and security.
- Proficiency in SQL and experience with PL/SQL or similar procedural language.
- Familiarity with database design, documentation, and coding.
- Previous experience with Linux/Unix and scripting languages such as Bash, Python, or Perl.
- Knowledge of high availability and disaster recovery options for PostgreSQL.
- Good understanding of hardware performance, memory and I/O.
- Strong analytical and problem-solving skills.
- Excellent communication and mentoring skills.
Desired Skills and Experience
- PostgreSQL certification (e.g., PostgreSQL Certified Engineer).
- Experience with cloud services (AWS, Azure, OCI) and containerization technologies (Docker, Kubernetes).
- Familiarity with other database systems (e.g. Oracle and MSSQL)
Benefits:
- Employee Impact Program. Every employee has the opportunity to define and get rewarded for their contributions they can make toward the long-term health of the company, customer, and employee. This program in combination with our comprehensive time off and leave programs allow you to design a career and compensation program that enables near infinite flexibility while ensuring both company, customer, and individual health and prosperity.
- Comprehensive time off and leave programs:
- 31 Days (248 hours) of Paid Personal Time Off (PTO) for any vacation, holidays, illnesses, and birthdays
- Parental Leave: 40 Hours
- Bereavement Leave: 24 hours.
- Military Reserve Leave (up to 80 hours, see employee handbook for details).
- Jury Duty Leave 16 hours.
- Retirement: Unlimited 401K match up to 8% of your salary up to the federal maximum
- Health Insurance (Medical, Dental, Vision): Premium is 100% company paid (contact us for specific plan details).
- Health Savings Account (HSA): Interclypse contributes $750 for individuals and $1500 for families
- Vision Insurance
- Dental Insurance includes orthodontics coverage
- Life Insurance
- Accidental Death and Dismemberment Insurance
- Disability: Short-term and long-term disability coverage
- Educational support: reimbursement up to the federal max of $5,250
- Company apparel: $200 for company apparel each year
- Social events: Holiday Party, Spring Picnic, Fall Picnic, happy hours and more
Interclypse isn’t your typical company. We strive to have a positive & transformational impact on our community, our industry, and individuals. We keep this focus through our motto: "Doing What is Right". Apply today to see how you can join our winning team and start down the career path that’s right for you!
The base salary range provided is not adjusted for geographic differences associated with where the work is being performed. Actual salaries will vary depending on factors including but not limited to location, candidate’s experience and education/training, internal peer equity, and market and business consideration.
EOE AA M/F/Vet/Disability:
Interclypse is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, creed, sex, sexual orientation, gender identity, national origin, disability, or protected Veteran status.
Related terms and topics: Java, Software Development, Computer Programming, Software Engineering, C++, Design Patterns, Enterprise Integration Patterns
