Overview
On Site
Full Time
Skills
Oracle Cloud
Production Support
Recovery
Backup Administration
Data Compression
Clustering
Replication
Performance Tuning
Database Design
Migration
Emerging Technologies
Computer Science
Information Systems
Database Administration
Database
Microsoft Azure
PostgreSQL
MongoDB
Conflict Resolution
Problem Solving
Attention To Detail
Oracle RAC
OCI
Linux
Oracle
Command-line Interface
Oracle RMAN
Oracle Data Pump
Shell Scripting
Oracle GoldenGate
Change Data Capture
Oracle Data Guard
Microsoft SQL Server
Windows PowerShell
Scripting
PL/SQL
Collaboration
Management
Specification Gathering
Documentation
Job Details
Benefits Summary
Overview
The Database Administrator will manage Oracle, SQL Server, MongoDB databases (on-premises, Oracle Cloud Infrastructure, Azure), ensure 24/7 database production support and perform daily operations.
Responsibilities
Qualifications
Skills
Strong problem-solving skills, attention to detail, and a proactive attitude
Strong working knowledge of Oracle RAC on ODA and OCI. Data Guard experience is a must
Strong working knowledge of Linux OS command and Oracle command line tools like oadcli, srvctl, dgmgrl, lsnrctl, rman, expdp, impdp. Shell scripting is a must
Experience with Oracle Golden Gate Change Data Capture
Experience with Oracle Data Guard, SQL Server Availability Groups experience is a must. PowerShell scripting is a plus
In-depth understanding of PL/SQL, dblinks, synonyms, grants, indexes, etc
Ability to prioritize workload and work effectively under pressure
Ability to interface and collaborate with developers, peers and management to troubleshoot issues and develop solutions
Ability to fully document technical specifications and related project or systems-level documentation
- Flexible and hybrid work arrangements
- Paid time off/Paid company holidays
- Medical plan options/prescription drug plan
- Dental plan/vision plan options
- Flexible spending and health savings accounts
- 401(k) retirement savings plan with a Roth savings option and company matching contributions
- Educational assistance program
Overview
The Database Administrator will manage Oracle, SQL Server, MongoDB databases (on-premises, Oracle Cloud Infrastructure, Azure), ensure 24/7 database production support and perform daily operations.
Responsibilities
- Oversee Oracle RMAN backups and recovery, DataPump backups and restores, Data Guard; Golden Date change data capture (CDC), log mining, advanced compression, partitioning
- Responsible for SQL Server Database restores, clustering, replication and always-on
- Manage all databases: cloning, creating new DBs, monitoring, performance tuning, shell scripting, logs checks
- Application team support: provide support and guidance on best database practices, troubleshoot, implement database changes/new objects
- Recommend solutions by defining database physical structure, functional capabilities and usage. Act as an escalation point for any project or issue related to databases
- Responsible for database design and issues impacting database functionality, security, and availability, upgrades and migration projects
- Advise management on the latest industry trends, emerging technologies, and best practices to improve the functionality and efficiencies of the company databases
Qualifications
- Bachelor's Degree in Computer Science, Information Systems, or equivalent related technical field
- Master's Degree a plus with a concentration in database management
- 4+ years DBA experience with Oracle RAC on ODA and OCI
- 2+ years DBA experience with SQL Server Databases on on-prem and Azure
- 1+ years' experience working with PostgreSQL and MongoDB
- Oracle Certification is a plus
- MS SQL Server certification is a plus
Skills
Strong problem-solving skills, attention to detail, and a proactive attitude
Strong working knowledge of Oracle RAC on ODA and OCI. Data Guard experience is a must
Strong working knowledge of Linux OS command and Oracle command line tools like oadcli, srvctl, dgmgrl, lsnrctl, rman, expdp, impdp. Shell scripting is a must
Experience with Oracle Golden Gate Change Data Capture
Experience with Oracle Data Guard, SQL Server Availability Groups experience is a must. PowerShell scripting is a plus
In-depth understanding of PL/SQL, dblinks, synonyms, grants, indexes, etc
Ability to prioritize workload and work effectively under pressure
Ability to interface and collaborate with developers, peers and management to troubleshoot issues and develop solutions
Ability to fully document technical specifications and related project or systems-level documentation
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.