Create and Set Up Database Server
Plan and configure reliable database servers with the right platform, access controls, storage, backups, and operational foundations.
Database Administrator
PostgreSQL
MySQL
MongoDB
AWS
Linux
Elasticsearch
ETL
DBA
Profession
3+ years
Experience
Mid-Senior
Level
IT
Field
0
1
0
1
0
1
10101
01010
10101
Know Me
About My Journey
I'm an IT Enthusiast & DBA Professional
IT professional with 3+ years of experience in database administration, data engineering, and cloud infrastructure. Skilled in PostgreSQL, MySQL, MongoDB, Apache Spark, Pentaho (PDI), AWS, and Linux.
Expertise includes performance tuning, query optimization, indexing, backup & recovery, replication, and high availability (HA/DR). Experienced in managing high-volume data pipelines and ensuring reliability, scalability, and data integrity in production systems.
Industry Focus
Database administration for a US-based software company serving the healthcare insurance industry.
Connect on LinkedIn
What You Get?
What I Do
01 / 08
Featured DBA Projects
MySQL 5.7 to 8.4 Version Upgrade
Problem
Upgrade an outdated MySQL environment while preserving application compatibility.
Approach
Used available and custom Python tools with Pentaho ETL to migrate and resolve collation, deprecated-feature, ownership, datatype, and data-format issues.
Outcome
Delivered a modernized MySQL environment with compatibility issues addressed during the upgrade.
MySQL to PostgreSQL Server Migration
Problem
Move a database workload between different database platforms without losing data.
Approach
Built custom tools for automated datatype matching, SQL modification, and lossless data transfer.
Outcome
Created a repeatable cross-platform migration process with preserved data integrity.
Slow Query, Deadlock & Critical Activity Tracker
Problem
Detect freezing queries, deadlocks, and critical database activity before they affect operations.
Approach
Created automated pipelines with triggered remediation alongside manual intervention workflows.
Outcome
Improved visibility into critical activity and established faster automated response paths.
Automated Time-Based Access Control
Problem
Manage temporary database access without relying on repeated manual administration.
Approach
Created an automated pipeline that manages time-limited database access through a Slack workflow.
Outcome
Made temporary access more controlled, repeatable, and easier to operate.
Architecture
Database Topology
A dependable request path from application traffic to a protected primary database and read replicas.
ApplicationClient traffic
→
Load BalancerRoute requests
→
Primary DBRead / write
→
Read ReplicasScale reads
Monitoring and access controls protect every layer.
Replication
Keep a synchronized standby ready for read scaling, maintenance, and controlled failover.
PrimaryWAL / binlog
⇒
ReplicationStream changes
⇒
ReplicaStandby / reads
Replication lag and health are continuously monitored.
Backup & Recovery
Automated backups create a repeatable recovery path with retention, validation, and restore testing.
Production DBLive data
→
Backup JobSchedule / verify
→
Object StorageEncrypted copies
→
RestoreRecovery test
Recovery point objective and recovery time objective guide the design.
High Availability / Disaster Recovery
Health checks and a standby environment reduce downtime when a primary service or region fails.
Primary RegionActive workload
⇄
Health ChecksDetect failure
⇄
DR RegionFailover target
Documented failover and rollback procedures keep recovery controlled.
ETL Pipeline
Move trusted data from operational sources into an analytics destination through observable stages.
SourcesDBs / APIs
→
ExtractCollect data
→
TransformClean / validate
→
WarehouseReports / insights
Scheduling, retries, and data quality checks make the pipeline reliable.
Get in Touch
Let's Connect
I'm always interested in hearing about new projects and opportunities.