Job Title: Lead Oracle DBA
Location: Denver, CO
Work Authorization: USC, GC, or H1B
Interview: Phone - Person can work REMOTE if not open to working in Denver
PROJECT: Lead migration from AIX platform to RedHat Linux platform in a major Data Warehouse (55TB) environment - MUST HAVE EXP
Duties:
* Implements database software installs, upgrades, and patches
* Conducts regular database performance testing and tuning
* Conducts regular SQL tracing and tuning.
* Capacity planning for database storage and memory
* Recommends and implements dimensional models, including aggregation
and indexing strategies
* Implements and maintains operational and disaster recovery procedures
* Manages database security, user accounts and access privileges
* Writing and maintaining UNIX shell scripts for database monitoring and
job automation
* Performs complex bug verification, release testing for assigned
products
* Works with fellow DBAs and other internal teams to establish,
implement and document database standards
* Confers with internal department managers regarding problems with and
the capabilities of various internally-used databases
* Flexibility to adapt to and willingness to learn new technologies.
* Advise on database concepts and functional capabilities
* Share responsibility with fellow DBAs for 24/7 on-call support
* Recommends systems changes to programming management
* Demonstrated effective oral and written communication skills with the
ability to communicate technical information to non-technical personnel.
* Working positively and having fun within a team environment
* Maintain hot and cold backups using RMAN and maintains backup and
recovery documentation
* Ability to work within change control processes
* Maintain detailed project plans for and occasionally lead DBA projects
* Working on multiple Oracle database projects in a fast paced and
dynamic environment.
Skills:
* The candidate must have at least 7 years of experience in managing
Oracle relational database systems in the Unix environment.
* The ideal candidate will have experience supporting Data
Warehouse/Data Mart environments.
* Strong conceptual and analytic skills.
* Skilled in SQL programming, knowledge of operating systems and UNIX
scripting languages.
* Knowledge of database security management and data integrity concepts,
knowledge of ETL and query tools, and experience in code migration, database change management and data management through the various stages of the development life cycle.
Education:
* A Bachelor's degree in business or computer science or equivalent
experience is required.
Required Skills:
* Change Control
* Change Management
* Data Integrity
* Data Management
* Database
Additional Skills:
* MS SQL Server
* Performance Testing
* Project Plans
* RMAN
* Shell Scripts
* Switch Capacity
* Unix Shell
* Database Systems
* ETL
* Informix
* Life Cycle
* Relational Database
* Scripting
* SQL
* SQL Server
* UNIX
* Backups
* Capacity Planning
* Databases
* Disaster Recovery
* Documentation