Database administrator (postgresql DBA) Resume San Antonio, TX - Hire IT People

TECHNICAL SKILLS

Database administrator
Dbms
Sql server
Sql
Excel
Powerpoint
Microsoft word
Training
Mental health

PROFESSIONAL EXPERIENCE

Database administrator (postgresql DBA)

Confidential - San Antonio, TX

Responsibilities:

Extensively investigated and followed-up with application teams, and proposed solutions to resolve slowness and performance issues.
Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.
Configuring PostgreSQL Streaming Replication and logical replication for load balancing.
Experience in bash scripting.
Responsible for all backup, recovery of PostgreSQL databases using and pg dump.
Implement, configure, and troubleshoot database instances, replication, backup, partitions, storage, and access. Set user privileges within and outside the database environment
Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.
Managed the monitoring and troubleshooting of database replication issues
Collaborated with application development teams to support and resolve any issues encountered
Installed and configured Nagios as monitoring tool for disk usage, CPU utilization, list of open files etc. and sending alerts to our teams based on the same.
Migration of Data from Reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures.
Troubleshooting PostgreSQL database using Explain, explain analyzed.

DATABASE ADMINISTRATOR( postgresql DBA)

Confidential

Responsibilities:

Reviews database design and make recommendations.
Establish and maintain security and integrity controls.
Provides appropriate consulting, interfacing, and standards relating to database management, and monitors transaction activity and utilization.
Prepares and/or reviews activity, progress, and performance reports.
Plans and configures the physical database environment.
Evaluates and recommends the purchase and utilization of technologies such as DMBS/s, servers, extract and conditioning tools, metadata management, security tools and archival and recovery tools and data access.
Develops project plans for implementing database environments. Provides input to technical projects and oversees the tactical aspects of all database related tasks.
Diagnoses, resolves and implements preventive measures to prevent problems for availability, recoverability and performance of all supported database environments.
Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.
Tuning autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.
Contributed to decreasing need for downtime by developing and improving procedures for automated monitoring and proactive intervention.
Proactive managing standby replication methodologies like Streaming replication and hot standby for disaster recovery.
Scheduling daily Point in time recovery (PITR) to the development environment for proper product testing.
Proactive in updating the latest security patches to database, which are provided by PostgreSQL open source community.

Petroleum engineer

Confidential

Responsibilities:

Devise plans and methods to effectively drill fields to recover oil and gas
Develop and modify tools and designs based on performance observation
Ensure equipment is installed, operated and maintained properly for effective use
Work closely with the procurement team to procure the necessary equipment and tools for projects
Work together with geoscientists and other specialists to analyze the geologic formation containing the oil and gas reservoir
Monitor drilling operations as needed

We provide IT Staff Augmentation Services!

Database Administrator (postgresql Dba) Resume

San Antonio, TX

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship