Job Overview
We are seeking a highly skilled Lead Database Engineer to join our dynamic technology team in a remote capacity. In this pivotal role, you will leverage your expertise in PostgreSQL databases—both on-premise and cloud-based—to enhance our robust, 24⁄7 SaaS platform. This position is ideal for individuals who excel in a DevOps environment and are passionate about guiding and mentoring team members across various functions.
Key Responsibilities
- Design, implement, and uphold critical PostgreSQL database systems that underpin our 24⁄7 SaaS offering.
- Spearhead data operations, ensuring that security, management, and usage practices align with industry best practices and business objectives.
- Engage in project management and agile methodologies to contribute to effective solution delivery.
- Mentor and support database team members, providing guidance on optimal database design and performance.
- Collaborate with cross-functional teams and stakeholders to foster effective communication and teamwork.
- Ensure database operations meet high availability, scalability, and recoverability standards.
- Conduct performance tuning and capacity management to satisfy performance demands.
- Provide guidance to developers and engineers on database development, query optimization, and index management within an automated pipeline.
- Assist in development and testing activities, including test data configuration, automated testing scenarios, and refreshing development/test environment data.
- Keep abreast of emerging database technologies to enhance our database systems continuously.
- Ensure adherence to HIPAA security policies in all database-related processes.
- Offer on-call support for production databases and manage escalations as necessary.
Required Skills
- 10+ years of relational database administration experience.
- 3+ years of direct experience with highly available PostgreSQL databases.
- Proficient understanding of RDBMS principles, database design, and normalization.
- Extensive experience with PostgreSQL architecture, high-availability technologies, and performance tuning.
- Expertise in query optimization, indexing, materialized views, and partitioning.
- Skilled in PL/PgSQL, triggers, and stored procedure development in PostgreSQL.
- Experience with PostgreSQL in a Linux environment.
- Familiarity with .NET clients using PostgreSQL is advantageous.
- Experience with cloud-based RDBMS solutions is a plus.
- Knowledge of agile development and DevOps principles is highly regarded.
Qualifications
- Bachelor's degree in Information Systems, Engineering, or a related field (or equivalent experience).
Career Growth Opportunities
This position offers significant potential for professional growth, allowing you to expand your technical skill set and leadership capabilities in a supportive and collaborative environment.
Company Culture And Values
Our organization is committed to fostering a culture of innovation and collaboration, where every team member’s contributions are valued. We embrace a DevOps culture that prioritizes continuous improvement and stakeholder engagement.
Compensation And Benefits
- Competitive salary ranging from \(110,000 to \)150,000 per year.
- Comprehensive health, dental, vision, life, and disability insurance.
- Retirement plan with company contributions.
- Annual profit-sharing program.
- Professional development and training opportunities.
- A collaborative and supportive work atmosphere with structured onboarding and mentorship programs to ensure your success.
Employment Type: Full-Time