Database Administrator (Oracle)

Job Description

ComResource is looking for a Database Administrator (Oracle).

Responsibilities:

Administer Oracle and MS-SQL databases, including planning and performing upgrades, applying maintenance, designing and maintaining physical database layout, performing reorganizations, designing and implementing backup and restore strategies, archiving strategies, maintaining database security, administering performance, managing storage, and resolving database issues.

Implement and maintain multiple databases across development, test, training, and production environments.

Actively participate in full SDLC processes from design, flowcharting, development, testing, modifying, and implementation, including ensuring proper integration with other systems.

Refresh and test environments.

Provide recommendations for enterprise architecture.

Participate in peer reviews on specifications, design, and code.

Perform database data validation and develop and test related routines.

Provide technical input and assistance in optimal database configuration to maximize system performance and availability.

Work closely with quality assurance and operations teams to ensure smooth deployment of high-quality applications.

Design and implement approaches to improve database performance, capacity, and scalability.

Work with project teams to plan integration and implementation strategies.

Provide 24x7 on-call technical support.

Participate in business requirement gathering meetings to understand functionality, processes, and technologies; determine feasibility of requests; identify best approaches; provide detailed estimates; and define technical specifications.

Essentials:

Bachelor's degree in Information Systems, Computer Science, Computer Engineering, or related field, or equivalent work experience.

3–5 years of experience installing, configuring, administering, tuning, and troubleshooting database products and features for various application suites.

Experience as a Database Administrator with recent versions of MS-SQL and Oracle database technologies in virtualized server environments, including Windows and Linux.

Experience with database backups, recovery, and cloning.

Experience with performance troubleshooting, including hardware resource contention issues.

Experience with RAC, AlwaysOn Availability Groups, and/or other high availability technologies.

Experience with application query tuning, including execution plan interpretation, SQL Profiler, and/or Extended Events.

Experience with database server software and patch installations.

Experience with configuration and support of SQL Replication, Log Shipping, or other data movement technologies, including Oracle Data Guard configuration and administration.

Experience in T-SQL and PowerShell programming.

Experience in PL-SQL and Linux shell scripting.

Experience in Linux server administration and performance review related to Oracle database needs.

Experience automating processes utilizing scripting tools such as Bash, Perl, and Python.

Ability to perform root cause analysis and recommend appropriate remedial actions.

Strong written and verbal communication skills.

Self-motivated with excellent time management and organizational skills; able to acquire new skills autonomously.

Demonstrated ability to document IT processes and provide knowledge transfer to team members.

Must be willing and able to work beyond normal hours to resolve critical system problems and/or perform production system maintenance during emergency situations.

Desired:

Experience with administration of Teradata or MongoDB solutions.

Experience with cloud infrastructure, including GCP, AWS, or Azure.

Previous retail industry experience.

Req ID: CG644727526

Full-time