This role will be responsible for ensuring optimal query performance, carrying out regular database maintenance, and addressing scalability concerns to support our growing data infrastructure. There is particular emphasis placed on RDS experience/optimization, PostgreSQL expertise, and the ability to enhance the performance and integrity of our databases.
What you will be doing:
- Administer, monitor, and optimize AWS PostgreSQL databases to ensure they are scalable, reliable, and performant.
- Monitor system and application performance, implementing tuning as needed to ensure optimal operation.
- Engage in daily interactions with Development teams and other departments to create an integrated, efficient work environment.
- Assess and provide constructive feedback on developer-driven data architecture changes, ensuring optimal database performance.
- Triage and optimize query performance to maximize database efficiency.
- Participate actively in release and deployment processes, contributing valuable expertise and oversight.
- Identify and implement internal process improvements, including redesigning infrastructure for greater scalability, optimizing data delivery, and automating manual processes.
- Conduct maintenance on RDS systems, ensuring their effective operation and longevity.
- Assessing current data schema and implementing improvements for efficiency and performance (eg. breaking up tables, removing redundant columns, reviewing indices)
- Proposing new technologies and practices as solutions or improvements to existing systems
Tech you will work with:
- Hosting and Administration: AWS RDS/Aurora
- Communication: Atlassian Jira, Slack
- Database: PostgreSQL, MS SQL Server
- DataWarehouses & Integration Systems: Snowflake, FiveTran, Celigo, Boomi
- Analytics and Logging: DataDog, Tableau
- Build and deployment tools: Git, Liquibase, Jenkins
- Languages: SQL, Python, Shell Scripting
What experience and skills we need you to have:
- 2+ years in a data/database engineer role
- 4+ years of experience working with databases and data architectures in any IT role
- Experience designing, building, deploying, and scaling databases
- Solid understanding of data architecture
- An attitude of success defined in team accomplishments
Benefits:
- Flexible PTO (including 11 holidays and your birthday off)
- 401(k) plan with employer matching
- Great health benefits with multiple plan option
- Option to choose between in office, fully remote, or a hybrid work environment for all employees
- Sabbatical program (4 weeks after 5 years of service)
- Casual dress environment (when in office)
- Catered lunches every Tuesday and Thursday
- Company events each quarter
- Signing stipend for a work-from-home setup
- Free gym membership at our office
- Annual employee development program stipend of $2,000 for each employee
- Flexible parental leave with 10 weeks paid leave for ALL new parents
- Fertility/adoption assistance
- Annual tutoring stipend for your children
- Mentorship program available immediately
- Regular team outings
- Advancement opportunities based on results, not politics
- Culture that emphasizes inclusiveness driven by our REDI Committee
Our platform provides our customers with unprecedented insight that drives informed decisions on their largest areas of spend and allows organizations to solve problems that matter for their business.
FinQuery is an equal opportunity employer to all persons, free from restrictions and prejudice based upon race, color, creed, religion, sex, domestic relationship status, parental status, family status, sexual orientation, national origin, gender identity, age, and disability status. FinQuery maintains a drug-free workplace.
