SYED ASAD HUSSAIN
Database Consultant
Riyadh
Summary
Seeking a challenging and dynamic position in a reputed organization where my qualificaton skills and ablities will be put to maximum use to contribute to the career advancement as the organizational growth
Overview
1
1
year of professional experience
2018
2018
years of post-secondary education
4
4
Certifications
Work History
Database Consultant
Securemax
Riyadh, Riyadh Region
11.2024 - Current
- Installed and configured PostgreSQL databases using both source code and RPM packages across multiple environments (development, testing, and production).
- Managed logical and physical backups using tools like pg_dump, and pg_basebackup. Performed Point-in-Time Recovery (PITR) to restore databases to specific recovery points.
- Set up and maintained Streaming Replication (Master-Slave) and implemented Patroni with etcd for automated failover and high availability. Ensured minimal downtime during failover scenarios.
- Performed routine maintenance tasks such as Vacuum, Reindexing, Analyze, and Vacuum Full to ensure database health and performance.
- Created and managed database users, roles, and privileges to ensure secure access and compliance with organizational policies.
- Monitored database performance using tools like pg_stat_activity, pgBadger, and custom scripts. Diagnosed and resolved issues related to locks, deadlocks, and slow queries.
- Configured and managed PgBouncer for efficient connection pooling, reducing overhead and improving application performance.
- Designed and implemented disaster recovery plans, including regular backups, replication, and failover strategies.
- Upgraded PostgreSQL databases from lower versions to higher versions using pg_upgrade and applied patches to ensure security and performance improvements.
- Documented database processes, configurations, and procedures. Automated repetitive tasks using shell scripts and cron jobs.
- Designed and implemented table partitioning strategies (e.g., Range, List, and Hash partitioning) to improve query performance and manage large datasets efficiently. Migrated existing tables to partitioned tables with minimal downtime.
- Installed, configured, and maintained Redis environments to ensure high availability and performance.
- Created and managed Redis databases based on application team requirements.
- Monitored system health and performance metrics using the Redis Admin Console.
- Deployed and managed a 3-node Active-Active Redis Enterprise cluster , ensuring seamless operations and high availability.
PostgreSQL DBA Intern
Opensource DB
Hyderabad
01.2024 - 07.2024
- Installed and configured PostgreSQL databases on various environments (Linux, Windows, etc.).
- Set up and optimized database parameters for performance and scalability.
- Designed and maintained database schemas, tables, and relationships to support application requirements.
- Managed user roles and permissions, ensuring secure access to sensitive data.
- Conducted regular database backups using tools like pg_dump, pg_basebackup ensuring data availability and disaster recovery readiness.
- Configured and managed replication setups (streaming replication, logical replication) for high availability.
- Monitored replication lag and resolved replication issues.
Education
HIGH SCHOOL - CLASS 10
Sri Chaitanya School
INTERMEDIATE - CLASS 12
Abhyas Junior College
UNDERGRADUATE / B.TECH - undefined
Chaitanya Bharathi Institute of Technology
Skills
- PostgreSQL Database Management
- SQL Proficiency
- Database Maintenance
- Data Quality Assurance
- Data Backup Solutions
- IT Technical Support
- Problem-Solving
- System Reliability
- Database Performance Monitoring
Certification
Redis, Inc | RU301: Running Redis at Scale
Timeline
EDB postgres AI platform introduction [EDB]
02-2025
PostgreSQL Essentials v16 [EDB]
12-2024
Database Consultant
Securemax
11.2024 - Current
Complete MySQL Database Administration Course
04-2024
Redis, Inc | RU301: Running Redis at Scale
03-2024
PostgreSQL DBA Intern
Opensource DB
01.2024 - 07.2024
INTERMEDIATE - CLASS 12
Abhyas Junior College
UNDERGRADUATE / B.TECH - undefined
Chaitanya Bharathi Institute of Technology
HIGH SCHOOL - CLASS 10
Sri Chaitanya School
Similar Profiles
Ahmed Mohamed OthmanAhmed Mohamed Othman
Chief Accountant at The Best Chefz CoChief Accountant at The Best Chefz Co
KARIM MOHAMED FAROUKKARIM MOHAMED FAROUK
Section Manager, Central General Ledger Department at AlfanarSection Manager, Central General Ledger Department at Alfanar
Mohammed AlbalawiMohammed Albalawi
Naval Aviator at The Royal Saudi Naval ForcesNaval Aviator at The Royal Saudi Naval Forces