The Senior Database Engineer is responsible for managing and optimizing MySQL databases on AWS, improving database architecture, and collaborating with developers to enhance data workflows. The role requires extensive experience in SQL and AWS services, along with strong documentation and communication skills.
Senior Database Engineer
PlanHub is the leading pre-construction SaaS platform and marketplace helping general contractors, subcontractors, and suppliers connect and grow their businesses. Built with tradespeople in mind, PlanHub is designed around the user workflow to help boost productivity, maintain deadlines, increase revenue, and create relationships. Easily post projects or submit bids with anytime-anywhere collaboration for every commercial construction trade.
We’re currently seeking a Senior Database Engineer to join our team. This role will focus on building and optimizing data collection systems and processing pipelines. The primary responsibility will involve managing/supporting/improving the OLTP databases of PlanHub.
What you will be doing:
- Design, configure, and manage MySQL databases hosted on AWS RDS and Aurora.
- Troubleshooting, Root Cause Analysis, Slow query log analysis and query tuning.
- Work on improving the existing database systems and architecture.
- Modernize the data tier on AWS towards a highly scalable, available and performant database architecture and data flows with the SaaS platform and external data sources.
- Perform database code deployment and tooling.
- Define, develop, and optimize queries for product.
- Assist software developers with query optimizations.
- Implement reports as needed to support internal business stakeholders.
- Collaborate with the application development and BI teams to maintain and modernize our data architecture.
- Review and troubleshoot reported issues.
What you will need to be successful:
- 7+ Designing, configuring, and managing MySQL databases hosted on AWS RDS and Aurora.
- 5+ Years of experience with Troubleshooting, Root Cause Analysis, Slow query log analysis and query tuning.
- 5+ Utilize AWS CLI for infrastructure tasks including provisioning, monitoring and scaling of RDS/Aurora instances.
- Experienced with Modernization of software to support exponential growth and improve QOS in AWS Cloud infrastructure.
- Maintain comprehensive and clear technical documentation, including runbooks, diagrams and wikis.
- Experienced in designing and implementing OLTP database solutions.
- Degree in Computer Science or related technical discipline or equivalent experience.
- Hands-on experience with Bash / Python scripting.
- Self-motivated and willing to "do what it takes" to get the job done.
- Ability to plan, organize and work on multiple projects with minimal supervision.
- Collaborate with developers to optimize database interactions and ensure efficient data workflows.
- Support database upgrades, patching, and migrations with minimal downtime.
- Strong written and verbal communication skills and the ability to convey technical details to non-technical stakeholders.
Nice to have:
- Good to have experience with GUI ETL tools: Informatica/SSIS/Apache NiFi/AWS Glue etc...
- Good to have experience with Snowflake, AWS Redshift, AWS Lake Formation, or similar Data Warehouse / Data Lake tools
- Experience working with NoSQL such as MongoDB, ElasticSearch is good to have.
- Experience in data warehousing inclusive of dimensional modeling concepts and demonstrate proficiency in Python, Perl, or similar
What's in it for you:
The opportunity to join a dynamic team that landed into the top list of Inc. 5000 in 2024 You can make an immediate impact as PlanHub moves to dominate the industry!
PlanHub offers:
- An awesome culture where you will be empowered, make an impact, and learn a ton
- Remote friendly
- Open time-off policy
- 401(k)/RRSP plan with company match
Top Skills
Apache Nifi
Aws Aurora
Aws Cli
Aws Glue
Aws Lake Formation
Aws Rds
Aws Redshift
Bash
Elasticsearch
Informatica
MongoDB
MySQL
Python
Snowflake
Ssis
Similar Jobs
.png)
Artificial Intelligence • Cloud • Legal Tech • Software • Generative AI
Ensure availability, restorability, and performance of production AWS-hosted databases. Monitor, tune queries and indexes, troubleshoot production issues, collaborate with developers on schema/design, maintain backup/restore and disaster recovery, contribute to IaC and capacity planning, document configurations, and leverage AI-assisted tools to improve processes.
Top Skills:
Amazon AuroraAmazon RdsAWSCopilotCursorInfrastructure As CodeMs Sql ServerMySQLPostgresSQL
Fintech • Software • Financial Services
The Senior Database Developer will improve and maintain databases for a cloud payments platform, ensuring high performance and security, while mentoring junior developers.
Top Skills:
AWSAzure DevopsC++DockerElk StackGCPGrafanaJavaKubernetesPostgresRabbitMQRedisSQL Server
_0.png)
AdTech • Marketing Tech
Responsible for database administration, data engineering, and operations within the Data Lake and Data Warehouse. Lead ETL design, troubleshoot production issues, and mentor junior engineers.
Top Skills:
Apache AirflowAws (Secrets ManagerCoalesceDatastageEc2)InformaticaJavaKmsPythonS3SnowflakeSparkSQLTalend
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
