I will automate postgresql or sql server maintenance vacuum reindex and analyze
AWS Database Engineer, Data Pipelines and Cloud Cost Optimization
About this Gig
A database that never gets maintained slows down over time: tables bloat, indexes fragment, queries get slower, and disk fills up faster than it should. This gig fixes that.
I set up and manage the routine maintenance that keeps PostgreSQL and SQL Server databases running fast and reliable: VACUUM and ANALYZE tuning (or autovacuum configuration) for PostgreSQL, REINDEX strategy to fix index bloat without long locks, SQL Server maintenance plans and jobs (index rebuild/reorganize, statistics updates, integrity checks), backup verification and job scheduling, alerting so you know about problems before they cause downtime, and a clear runbook so your team understands what runs, when, and why.
Whether you have never set up maintenance jobs or inherited a database that has been neglected for years, I will audit the current state, fix what is broken, and automate what should be automated.
Engines: PostgreSQL (including Amazon Aurora and RDS) and Microsoft SQL Server, on any cloud or on-prem.
Message me with your engine, approximate database size, and current pain points before ordering so I can confirm scope.
Expertise:
Cloud Administration
Cloud provider:
Amazon Web Services
Other Cloud Computing Services I Offer
FAQ
Will this cause downtime?
No. Maintenance jobs are scheduled during low-traffic windows, and REINDEX work uses concurrent/online methods wherever the engine supports it to avoid long locks.
Do you work with Amazon Aurora and RDS?
Yes. Most of my work is on Aurora PostgreSQL and RDS, plus self-managed Postgres and SQL Server on EC2 or on-prem.
What do you need from me to get started?
Your engine and version, database size, current backup/maintenance setup if any, and read access (or a staging copy) so I can assess before making changes.
