Oracle and PostgreSQL DBA - Fulltime role at Irving, TX

Overview

On Site
$40,000 - $60,000
Full Time
Accepts corp to corp applications

Skills

Database administration
Database design
Database security
Disaster recovery
Migration
Data integrity
Database
Performance monitoring
Oracle
Production support
Linux
PostgreSQL
Query optimization
Replication
SQL
Scripting
Unix
Performance tuning
Bash

Job Details

We are seeking a highly skilled and experienced Oracle and PostgreSQL Database Administrator (DBA) to join our dynamic team. The ideal candidate will be responsible for the performance, integrity, and security of our databases. This role involves installation, configuration, maintenance, performance monitoring, security, backup and recovery, and troubleshooting. The DBA will work closely with developers and other IT staff to ensure optimal database performance and data integrity.

Install and configure new PostgreSQL databases on various platforms (physical, virtual, cloud).
Set up database clusters, replication, and high availability solutions.
Configure database parameters and optimize for performance.
Perform regular database maintenance tasks such as vacuuming, analyzing, and reindexing.
Monitor database health and performance using various tools.
Implement and maintain database security measures, including access control and encryption.
Optimize SQL queries and database schema for improved efficiency.
Regularly perform database backups and test recovery procedures.
Manage disaster recovery plans and ensure business continuity.
Troubleshoot database issues and provide timely solutions.
Assist developers with database design and query optimization.
Implement and maintain database security policies and procedures.
Ensure compliance with relevant data privacy regulations (e.g., GDPR, HIPAA).
Regularly audit database security and access controls.

Roles & Responsibilities:
Minimum 3 years of Oracle, PostgreSQL database management systems in testing, implementation, maintenance and administration in a multiple platform environment.
Upgrades of Oracle, PostgreSQL , database migrations and updates and application of database patches.
Backup and restores, export and import of data to and from Oracle, PostgreSQL run time configuration of Oracle, PostgreSQL.
Develop and implement backup and recovery strategies to protect against data loss.
Monitoring at server, database, collection level, and using various monitoring tools related to Oracle, PostgreSQL.
Strong understanding of PostgreSQL architecture and internals.
Proficiency in SQL and database/data design and architectural principles and methodologies.
Familiarity with Linux/Unix operating systems.
Scripting skills (e.g., Bash, Python) for automation.
Supports multiple services and multiple databases of medium complexity with multiple concurrent users, ensuring control, integrity and accessibility of data.
Implements multiple projects along with the production support.
Will perform on-call support for critical needs.
Experience with database monitoring tools.
Implement performance tuning strategies to ensure optimal database response times.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.