Skip to content
View nicolasegpla's full-sized avatar
:octocat:
Focusing
:octocat:
Focusing

Block or report nicolasegpla

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
nicolasegpla/README.md

Hi, I'm Nicolas 👋

Software Developer transitioning into Database Engineering, with a strong focus on PostgreSQL, SQL, Linux, database administration, and database operations.

I have 3 years of professional software development experience, mainly working with React and TypeScript, along with practical experience using PostgreSQL, Python, Docker, Linux, and AWS.

My current goal is to specialize in PostgreSQL database engineering and administration, building hands-on experience in database design, security, backup & recovery, monitoring, performance, and operational reliability.

Current Focus

  • PostgreSQL administration
  • SQL and relational database concepts
  • Database design and data modeling
  • Users, roles, and permissions
  • Backup and recovery
  • Query optimization and performance
  • Monitoring and maintenance
  • Linux-based database operations
  • Dockerized PostgreSQL environments

Database Engineering Lab

I am currently building a hands-on PostgreSQL Database Engineering Lab designed around realistic junior DBA / Database Engineer tasks.

The lab includes practical exercises involving:

  • PostgreSQL installation and configuration
  • Database and schema management
  • Users, roles, and privileges
  • Backup and restore workflows
  • Monitoring and troubleshooting
  • Query analysis and optimization
  • Database security
  • Maintenance tasks
  • Linux and Docker operations

The goal is to simulate real-world database administration responsibilities and document my progress through practical tickets and exercises.

Core Stack

  • Databases: PostgreSQL, SQL
  • Database Operations: Administration, Backup & Recovery, Security, Monitoring, Performance
  • Systems: Linux
  • Automation: Python
  • Infrastructure: Docker, AWS
  • Software Development: React, TypeScript, JavaScript, FastAPI

Engineering Background

Before focusing on databases, I worked primarily as a frontend developer building production applications with React and TypeScript.

That experience gave me a strong understanding of how applications interact with databases, APIs, infrastructure, and production systems.

Today, I apply that software engineering background to my specialization in database engineering and PostgreSQL.

Tech

Currently Learning

  • Advanced SQL
  • PostgreSQL administration
  • Relational database design
  • Backup and recovery strategies
  • PostgreSQL performance tuning
  • Database security
  • Monitoring and troubleshooting

Pinned Loading

  1. cortex cortex Public

    Full-stack business application built with React, TypeScript, FastAPI and PostgreSQL/Supabase. Includes database schema management, authentication, CRUD operations, backups and Docker-based develop…

    TypeScript