Oracle Database Administrator
ITA is developing a next generation Passenger Service Solution for the Airline Industry. A PSS holds much of the important state that's managed by an airline: which seats are available, which tickets have been purchased, who is on which flight, and much, much more. ITA runs relational databases from several different RDBMS vendors that sit behind our PSS products. We're looking for a new member to join the Database Administration Team which maintains these databases.
Our databases run in a clustered Linux environment. The DBA team expends lots of effort to ensure that the databases that ITA runs are highly available, upgradable, and performing to requirements. They help us to meet these goals while managing hundreds of different database nodes across ITA's multiple datacenters. The DBAs work closely with the Data Architect team, and support the engineering teams which develop and extend the core applications.
We're looking for someone to join this team who is a computer scientist at heart who happens to have expertise in Oracle. While knowledge of Oracle is a key requirement of the job, we're ultimately looking for someone who knows how to leverage that knowledge to help us integrate Oracle into our application stack in a way that's consistent with how we run our homegrown apps.
Responsibilities:
- Install and configure Oracle 11G Real Application Clusters
- Architect and deploy highly available systems
- Advise and support application engineers
- Perform upgrades of application schemas
- Certify, plan and perform Oracle system upgrades
- Create tools for automation of administration tasks
- Identify and troubleshoot performance bottlenecks in both application and system architecture
- Perform automated and on demand RMAN backups
- Perform data pump exports and migrate data between environments
- Replicate data using Oracle DataGuard
- Participate in 24x7 on call rotation
Qualifications:
- Experience with PostgreSQL databases a plus
- Experience with NFS storage architecture a plus
- Expert in administration of Oracle 10Gr2 or 11G databases
- Expert in Oracle SQL
Knowledge and Skills:- Strong familiarity with Oracle RAC and DataGuard
- Familiarity with Oracle ASM and RMAN
- Strong familiarity with Oracle PL/SQL
- Familiarity with shell scripting and the linux environment
- Familiarity with a high level scripting language such as Perl or Python
- Excellent oral and written communications skills with the ability to interact calmly with customers, vendors, and ITA engineers during crises
- Ability to cope with handling critical situations in a prescribed, proceduralized manner
- Detail-oriented and organized with the flexibility to manage multiple priorities effectively
- Strong troubleshooting and analytical skills
- Willingness to learn and adapt in a fast-paced and constantly evolving environment
