Database Administrator
Apply NowCompany: A.M. Best
Location: Oldwick, NJ 08858
Description:
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
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