PostgreSQL Database Inf./ Linux Systems Administrator Resume

SUMMARY

Talented, skilled, passionate and motivated Linux Systems Administrator/PostgreSQL DBA with a strong desire of learning and implementing new technology. Responsible for the design, implementation, integration and optimization of various operating systems like openSUSE, Ubuntu, RHEL 6, 7 and AWS. Efficient expertise not limited to systems administration but also design, installation and optimization of corporate Software Defined Network environment. Excellent, meticulous, reliable, efficient and innovated team player and an excellent motivator. Instrumental in vital administrative tasks.

TECHNICAL SKILLS

Linux/Unix (Redhat/Centos 6 and 7)
Ubuntu
Windows
OpenSUSE
PostgreSQL 9.5, 9.6, 10, 11.
DevOps (In Progress)
AWS PostgreSQL Aurora and PostgreSQL RDS

PROFESSIONAL EXPERIENCE

Confidential

PostgreSQL Database Inf./ Linux Systems Administrator

Responsibilities:

Manage over 800 Community/Open Source PostgreSQL databases/Linux servers across all environments from TEST to PROD.
Assessed PostgreSQL servers, evaluate server configurations and make recommendations for optimum performance.
Successfully upgraded PostgreSQL servers from version 9.5 to version 10
Create and maintain database objects such as tables, views, indices, constraints.
Configured vacuum and vacuum full both on databases and tables.
Install and configure pg repack for vacuum full without locking table or database
Use standalone backend mode to vacuum PostgreSQL databases in case transaction ID wraparound. (Vacuum freeze)
Develop, implement and maintain database backups and PITR recovery using PG BASEBACKUP and PG BACKREST procedures for the processing environments, and ensured data integrity, security, and recoverability is possible at all times.
Extensively use EXPLAIN, EXPLAIN ANALYSE and PG STAT to optimize databases and tune slow running transactions
Assist in training clients/staff on PostgreSQL database operations
Configured streaming, logical replication and monitored replications from MASTER TO SLAVE
Used PgAdmin4 to manage databases
Communicate with customers to schedule upgrade to the latest version of application.
Schedule Radimetrics software/PostgreSQL upgrade and migration as per internal protocols.
Remotely perform server pre - check to verify if server meets minimum requirements for upgrade and migration
Check disk space, CPU and memory prior to upgrades.
Monitor upgrade Radimetrics process.
Remotely expand disk to meet server requirements for upgrade.
Perform disk space expansion (LVM and standard partition) prior to upgrade.
Troubleshoot server in case of issues by reading and interpreting log files.
Configure pgbadger for analyzing logs.
Schedule cron jobs (backups, vacuum) to run periodically as per requirement.
Configure pgbouncer for connection pooling.
Contribute in the development of upcoming Radimetrics software

Confidential

Linux System Administrator

Responsibilities:

Experience in System Administration, Installation, Upgrading, Patching, Configuration, and Trouble shooting.
Configure Storage, Disk Management, Logical Volume Management (LVM) and logical partitioning.
Experience working with TCP/IP file transfer protocol
Use Nagios as monitoring tool for PostgreSQL servers and PostgreSQL databases.
Configuration of LVM (Logical Volume Manager) to manage volume group, logical and physical partitions and importing new physical volumes.
Troubleshoot connectivity to Servers and Network systems
Monitor system backups and restore files as per protocol.
Configure hostnames/domain name, static IP address
Install/Configure new PostgreSQL server servers running Redhat6 and 7
Create users/roles account and assign permissions on files, directories, databases, schemas and directories.
Maintain and Deploy Redhat systems to provide optimum functionality for daily operations.
Perform maintenance of file systems, create cron jobs for periodic processes.
Maintained System Security and ensured systems are up to date with current patches and backups/restores were completed without flaw.
Coordinated and/or undertake troubleshooting of Linux Virtual systems, software, Network, hardware, and resolution of related user problems.
Involve in complete Administration tasks on Redhat Linux 6/7 and documentation for the projects executed.

Confidential

System Administrator/Linux Administrator

Responsibilities:

Build Virtual Linux machines and provision multiple server
Create and managed Linux instances for server availability for scale up/down.
Installed, monitored and supported Web and Application Servers on Linux environments.
Created new file systems, mounting file systems and unmounting file systems.
Created and maintained user profiles, security access rights, disk space and process monitoring.
Experienced in system administration including Installation, Configuration, Testing, Troubleshooting, and Performance monitoring and tuning of systems
Troubleshoot network instability by verifying DNS/domain configurations.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship