SUMMARY

• Strongly cultured and knowledgeable in PostgreSQL database Installations, Administration, and Maintenance.
• I am passionate in what I do and seeking a robust and 3 - tiered environment where a 24/7 uptime is the standard.
• I am hardworking and passionate about my job which I possess strong technical abilities in keeping databases running, being proactive in performance tuning, troubleshooting and resolution.

TECHNICAL SKILLS

• Excellent diagnostic skills.
• Analytical Skills.
• Performance Tuning and Optimization.
• Cloude Enterprise Architect
• Superb performance tuning skill.
• MS SQL server replication.
• Shell scripting proficiency.

PROFESSIONAL EXPERIENCE

PostgreSQL Database Administrator

Confidential | Charlotte, NC

Responsibilities:

• Design disaster recovery solutions for the PostgreSQL database and oversaw QUAT before deployment to production.
• Configure new servers for development and production enabling client connection and granting access.
• Monitor database health, uptime and resolve critical and non-critical database issues with cluster control.
• Cloning the Development, TEST and UAT environments with production data as per customer's request.
• Configuring third client software pgadmin-IV to access the database server.
• Configuring the backup jobs on customer system. Experienced in performing PITR.
• Patch, Upgrade and keep the PostgreSQL DBs current. Develop and enhance scripts to automate and execute various DBA tasks.
• Assist engineering team in the design of appropriate DB Schema and indexing strategy for performance and scalability.
• Experience supporting a mission-critical database environment with 24x7 On-Call Support including weekends.
• Identifying and resolving incidents and address to user problems/concerns. Trouble shooting database issues.
• Monitor database write ahead logs for insight into current state of the system and analyze logs for performance troubleshooting using PgHero and other supporting tools like PgBadger.
• Use PSQL command line to fix long running queries for efficient SQL query execution and Identifying long running queries that are causing performance issues.
• Monitoring of syslogs, database logs, trace files, database alert files to detect and troubleshoot runtime problems.
• Use PgTune for correct parameter quantification so that new databases are sized correct with memory and other processes working at optimum.
• Monitor Pgbackrest backups making sure all incremental backups are completed and also do individual table and schema backups using pg dump.
• Execute database scripts from developers to carry out varying functions like counting rows on a table, executing functions or sequences and backing up the database servers.
• PostgreSQL Installation, Configuration, Migration, Upgrades and Patches on both Enterprise DB and community editions as well as AWS RDS deployments.
• Carryout monthly disaster recovery exercises to ensure that backups of production servers are good and can be restores in the testing servers. Point-in-time recovery is also done routinely.
• Optimize postgresql.conf for performance improvement using PgTune and postgresql website recomendations . Review all PostgreSQL logs for problems too.
• Clude enterpricing, enabling rapid development, reducing complexity and moving away from perpetualized vendor lock-in.
• Participate in the creation of development, staging, production database instances, and the migration of data and schema from one environment to another.
• Ensure night corn jobs for backups, re-Indexing & vacuuming & materialized views executed properly on 24/7 high availability Postgres production and development databases.
• Implement solutions for backup/restore, management/monitoring and perform upgrades and patching.
• Experienced in administering and maintaining medium to large enterprise database servers on Linux servers, virtual machines and public cloud.
• Create, implement and document a suite of PostgreSQL how tos and best practices to make co-workers and auditors work easy.
• PostgreSQL replication technologies Binary Streaming Replication, Logical Replication.

Database Administrator

Confidential | Columbia, MD

Responsibilities:

• Assisted in database development and was responsible for the database software installations and directory creation.
• Created database clusters and named them as per company naming convention.
• Implemented database security by granting access to users on the postgresql and host base access configuration files.
• Responsible for managing roles, creating new roles and assigning users to the roles and revoking as needed.
• Follow company policy and best practices for security and documents new processes as per SLA.
• Monitored PostgreSQL database capacity and set up new alerts that fire when a threshold is reached.
• Migrated data from production to development, and schemas the other way for testing and deployments.
• Develop Stored Procedures and Database Triggers in support of application development.
• Responsible for developing SQL code, review to ensure queries are optimized and tuned to perform efficiently prior to production release.
• Responsible for regular backups like physical and logical and recovery of databases.
• Responsible for regular maintenance on databases with scheduled crontab vacuum and manual vacuum full when required.
• Responsible for pro-active remediation of database operational problems like indexing and reindexing.
• Responsible for tuning slow running queries, giving hints tto the optimizer using the where clause and carrying out other preventative maintenance.
• Set up and controlled user profiles and access levels for each database based on the least privilege rule.
• Created scripts and processes for data integration and maintenance.
• Communicated with developers to resolve database request through SNOW tickets and emails.
• Monitored system and database health checks on a daily, monthly, and weekly schedule. Enabled new check to run using crontab.
• Purged tables on specific database columns marked for delete to free space for new inserts.

Database Administrator

Confidential | Plano, TX

Responsibilities:

• Set up and controlled user profiles and access levels for each database based on the least privilege rule.
• Create, implement and document a suite of PostgreSQL how tos and best practices to make co-workers and auditors work easy.
• Configuring third client software pgadmin-IV to access the database server. provided valuable inputs for various perfomance tuning issues.
• Creation of physical stnadby DR, logical standby reporting database, activity dataguatd & snapshot standby.
• Optimizing postgresql.conf for performance improvement.
• System Monitoring and Database Perfomance tuning using Explain plan, SQL Trace, AWR and also Cluster Interconnect Tuning (RAC)