Address
Form of work
SalaryYou're a seasoned Postgres database expert and developer and are interested in taking your career to the next level while working alongside our data and engineering teams. You’ll be working in a small team supporting a large Postgres footprint. You’ll be responsible for production and development operations and play a key role in driving forward our data initiatives.
As a growing financial technology company offering real estate valuation products, software platforms and rich data and analytics, you will be an instrumental part of a small yet strong database operations team supporting data and application Development working with some of the brightest minds in the industry.
What You Will Work On
- Senior engineer supporting a large number of PostgreSQL instances running in our hybrid cloud. Everything from RDS, Aurora, RedShift, and EnterpriseDB to community edition
- Engineer solutions that are always available and support a 24/7 operations through measured SLA’s
- Manage HA architectures, disaster recovery, and backup/restore processes
- Understand and apply advanced database administration, management and performance-tuning techniques
- Repeatable builds, automation, documentation, and alerting are part of your technology wheelhouse and path to productionizing a stack
- Provide advanced technical troubleshooting for applications and database systems
- Configure and tune hardware and software to ensure optimum performance and resource utilization
- Participate in design and application review sessions
- Develop Python and shell scripts, procedures and processes for data migration and application development
- Participate in meetings and conference calls related to project and troubleshooting activities
- Provide support for database-related project activities
- Develop strong working knowledge of key applications and their interaction with the database(s)
Who We Are Looking For
- Minimum of seven (7) years experience with administering and maintaining Postgres-based applications to achieve reliability and availability SLAs
- Minimum of seven (7) years experience with PostgreSQL version upgrades, migrations, and patching running in a hybrid cloud
- Bachelor’s degree in computer information systems, computer science or related discipline preferred
- Proven experience as a Linux System Administrator, preferably in a production environment
- Tuning of SQL statements and PL/pgSQL code
- Git
- Release management and SDLC
- Experience working in a 24x7 development environment
- Database analysis and design expertise
- Data extraction, transformation, and loading
- Capable of working and managing multiple diverse projects in an agile environment.
- Enjoys complex problem-solving and solutioning with a team
Great to Have
- Experience with AWS RDS, Aurora and Redshift
- Experience with Jira, BitBucket (Git) and Confluence
- Experience working directly with application developers in terms of database design, performance tuning, and troubleshooting
- Ability to write, debug and tune SQL and PL/pgSQL, packages, procedures, functions, triggers, etc.
- Experience with database monitoring and tuning tools
- Thorough knowledge of physical and logical disk systems and their impact on database performance
- Advanced knowledge of database administration tasks such as hot and cold backups, database recovery, security, etc.
- Advanced installation and configuration experience
- Ability to write and maintain documentation describing changes and modifications to all systems and databases
- Excellent interpersonal and written communication skills
- Ability to work independently and own complex problems to resolution
What You Can Expect
Competitive compensation and immediate contribution!
Inclusive benefits package offerings 401k plans and customizable benefits including dental, vision, medical, etc. for you and your dependents.
An innovative culture that understands the importance of quality of work over quantity.
Company supported and employee-driven ambassador groups that promote diversity, working on a hybrid schedule and philanthropy.
Learning and development programs to help advance your career and personal growth.
What We Value
Wherever it leads, Whatever it takes! We believe in making the impossible possible!
Thrive personally, grow professionally―be happy!
Innovate, learn, lead- Knowledge and growth is never ending!
We believe in hiring nice people because anything is possible when you have the team's support.
Improving the lives around us- A smile could change the entire world.
Be the most trusted, respected, and loved real estate valuation company in the world.
About Us
Clear Capital is a national real estate valuation technology company with a simple purpose: build confidence in real estate decisions to strengthen communities and improve lives. Our goal is to provide customers with a complete understanding of every U.S. property through our field valuation services and analytics tools, and improve their workflows with our platform technologies. Our commitment to excellence — wherever it leads, whatever it takes® — is embodied by team members.
Clear Capital is an equal opportunity employer.
To all recruitment agencies: Clear Capital does not accept agency resumes. Please do not forward resumes to our jobs alias, Clear Capital employees, or any other company location. Clear Capital is not responsible for any fees related to unsolicited resumes.
