Shridhar Khanal
PostgreSQL Database Administrator | Data Engineer
4+ years specializing in PostgreSQL performance tuning, high availability architectures, and cloud-based database solutions. Passionate about scalable systems and data reliability.
📍 Kathmandu, Nepal
📧 mr.shridharkhanal7@gmail.com
🔗 Always open to interesting opportunities and collaborations
-- Optimized Query
SELECT
u.name,
COUNT(o.id) AS orders,
SUM(o.total) AS revenue
FROM users u
LEFT JOIN orders o
ON u.id = o.user_id
WHERE o.created_at > '2024-01-01'
GROUP BY u.id
HAVING COUNT(o.id) > 10
ORDER BY revenue DESC
LIMIT 100;Get to Know Me
Shridhar Khanal
PostgreSQL Database Administrator
Kathmandu, Nepal
With over 4 years of specialized experience in PostgreSQL administration and database engineering, I specialize in designing and maintaining high-performance database systems that handle mission-critical fintech workloads. My expertise spans performance tuning, high availability architectures, and automated disaster recovery solutions.
My passion lies in optimizing complex queries, implementing robust replication systems, and designing scalable database architectures that achieve 99.9% uptime with minimal recovery times. I've successfully managed multi-terabyte PostgreSQL clusters with zero-downtime migrations and improved query performance by 30-60% through strategic indexing and configuration tuning.
Years Experience
Databases Optimized
Performance Improvements
Uptime Achievement
My Tech Stack
A comprehensive toolkit for building and maintaining enterprise-grade data infrastructure
Database
Scripting & Automation
Cloud & Infrastructure
Tools & Platforms
Also experienced with
Featured Projects
A selection of projects that showcase my expertise in database engineering, backend development, and DevOps
Work Experience
A timeline of my professional journey and the impact I've made at each organization
PostgreSQL Consultant
- ▸Architected and implemented high availability solutions ensuring 99.99% uptime for mission-critical databases.
- ▸Optimized database performance through advanced tuning, indexing strategies, and query optimization.
- ▸Designed and executed comprehensive disaster recovery and business continuity strategies.
- ▸Provided technical consulting on PostgreSQL best practices and infrastructure planning.
Database Administrator
- ▸Optimized PostgreSQL database performance, reducing average query execution time by 30% through indexing and configuration tuning.
- ▸Designed and deployed high-availability architecture using streaming and logical replication, achieving 99.9% uptime.
- ▸Led the migration and major version upgrade of multi-terabyte PostgreSQL clusters with zero downtime using logical replication.
- ▸Implemented automated backup, WAL archiving, and disaster recovery procedures reducing recovery time by 40%.
Database Administrator
- ▸Enhanced query performance and system throughput using advanced indexing and query plan analysis.
- ▸Configured and maintained database replication, failover, and monitoring systems for fintech-critical workloads.
- ▸Designed and developed ETL pipelines for transferring data from PostgreSQL to MSSQL using Python and SSIS, improving reporting and analytics workflows.
- ▸Automated database maintenance, health checks, and vacuum operations using Python and Bash, reducing manual work by 60%.
Testimonials
What Colleagues Say
Here's what my colleagues and clients say about working with me
"I highly recommend Shridhar Khanal for his exceptional skills in database management and administration. His proactive approach, keen attention to detail, and commitment to excellence make him a valuable asset to any team."
Sagar Dhakal
Software Engineer, Cloco Nepal
"A great professional with strong commitment and passion for work. He never complains about pressure but solves problems efficiently with a positive attitude. His SQL knowledge and logical thinking are commendable."
Rabin Acharya
Data Engineer, Infinite Solutions
"Shridhar Khanal is an outstanding Database Administrator with expertise in database design, performance tuning, and security. His work ensures smooth operations and reliability in data infrastructure."
Amrit Karki
Software Engineer, John Snowlabs
"Shridhar Khanal's expertise in database management and administration is remarkable. His proactive mindset, problem-solving skills, and meticulous attention to detail set him apart as a top professional."
Suman Sharma
Software Engineer
"An exceptional Database Administrator and Python Developer, Shridhar excels in SQL, PostgreSQL, and Python. His technical and digital marketing skills make him a well-rounded and invaluable asset to any team."
Yubraj Adhikari
Flutter Developer
Let's Work Together
Looking for PostgreSQL expertise, database optimization, or need help scaling your infrastructure? Let's connect and discuss how I can help.
Location
Kathmandu, Nepal