A.M. Best

Database Administrator

Tewksbury, NJ, US

Onsite
Full-time
about 1 month ago
Save Job

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 * 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

How strong is your resume?

Upload your resume and get feedback from our expert to help land this job

People also searched: