What are the responsibilities and job description for the Database Administrator position at AM Best Company?
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
