On Wednesday, I performed one of the biggest/hardest/scariest database migrations of my career, from CouchDB to Postgres. It took 11 intense hours to complete, the culmination of 4 and a half months of work, but it went off without a hitch (to everyone's surprise, mine most of all; I was expecting to have to debug issues along the way).
This is something my boss has been saying the company needs to do for at least 5 years. He brings it up at executive meetings and tries to get the company to allocate resources to the migration. But everybody else always had higher priorities.
Two years ago, he told me our team didn't have the skills and the engineering team would have to do it. I mean, we (I) would do the database part, but they would have to write all the code.
Last year, one of the engineers on my team and I pulled off a couple major database migrations by ourselves--again without a hitch--that had my boss going, "Actually, I think the two of you could do it!"
Then, this year, when it finally got prioritized, I actually volunteered to do it myself, because I thought I finally had the skills.
And I did! I pulled it off! It's one of the biggest engineering triumphs at our company. And my doing it meant everybody else could keep working on their major projects and nothing had to be delayed to make this happen.
On Thursday, my boss asked what would make me feel appreciated. I responded with the two most me things ever:
One, I wanted him to lead the team meeting on Friday so I could take a long walk and dial in without having to share my screen and walk us through the slide deck. (Also, it ended up being super windy, so I could barely talk at all.)
Two, when he commented that he noticed I had already started a MySQL to Postgres migration, I was like, "Yeah, that was going to be the other thing I asked for: let me focus on that next."
IOW, my reaction to being praised for work is to ask to do more work. :P
Also, also! While I was out for my walk, the VP of Engineering came back from an executive business trip and discovered we had completely eliminated CouchDB from our system. He started posting the below in Slack channels with hundreds of people across the company, so everyone could appreciate this accomplishment. (Note that CouchDB *per se* is not a problem, it's how we had it implemented at our company. I don't want to badmouth CouchDB, which is a perfectly fine database if you use it right.)
Here is what he said:
Over the past 3–5 years, it's hard to count how many times we've heard some version of "
CouchDB is a huge risk." But while many of us have voiced the concern,
Mildred actually took action.
Their work to fully remove CouchDB from our platform is a
huge win—not just for reducing technical debt, but for improving our overall security posture. This change has a direct impact on our ability to meet and maintain the compliance standards we hold ourselves to.
Even more importantly, it eliminates a system none of us had deep expertise in, which clears the path for a healthier, more sustainable platform going forward.
Thank you for your leadership and execution,
mildred_of_midgard—this is real impact.