Oracle DBA in Scottsdale, AZ at Vaco

Date Posted: 11/16/2020

Job Snapshot

Job Description

Database Administrator
Are you a skilled database professional with a knack for production support seeking to take your career to the next level? If so, the Database Administrator role at Best Western International could be the perfect opportunity for you. We are looking for a bright, motivated Database Administrator to be part of a lean team that builds, supports, and maintains infrastructure components in our high transaction production database environments. You'll have the opportunity to help plan and maintain our dynamic Oracle and MS SQL Server relational database environments as well as to help define, organize, and secure the integrity of the RDBMS. You will be a member of a team of technology professionals in support of Best Western International's Database Services. The incumbent will lead and contribute to business projects, infrastructure strategy and design, capacity management, and support activities.

Essential Job Results
* Identify database requirements by interviewing customers; analyzing department applications, programming, and operations; evaluating existing systems and designing proposed systems.
* Responsible for participating in a 24X7 on-call rotation.
* Implement changes to database environment following pre-defined change management policies and procedures using ITIL and DevOps practices.
* Create and maintain databases required for Dev, QA, and Production usage.
* Perform capacity planning required to create and maintain the databases.
* Perform ongoing tuning of the database instances.
* Install new versions of the Oracle RDBMS and MS SQL Server and its tools and any other tools that access the database.
* Plan and implement backup and recovery strategies for the databases.
* Create and enforce security policies for the databases.
* Administer all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
* Monitor databases and make recommendations to improve monitoring practices.
* Act as the database SME on assigned internal projects.

Day- to-day:
* Ability to perform Oracle, MS SQL Server, MongoDB, Postgres (Aurora), and operating system performance monitoring.
* Experience with MS SQL Server, Oracle, MongoDB, and Postgres (Aurora)
* Experience and knowledge in deploying code into databases.
* Bash/ksh scripting a plus.
* Experience with Delphix a plus.
* Experience with AWS a plus
* Knowledge and experience with DevOps and Agile methodologies a plus.

RDBMS/OS: Oracle; MS SQL Server; MongoDB; Postegres (Aurora); Linux
* Knowledge of physical and logical database design.

Applications/Tools: Experience with the following will be considered a plus:
Nimsoft Monitoring, Quest Shareplex Replication, Commvault Backups, Toad, Oracle OEM, SQL Management Studio, Chef