Database Systems Engineer

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 an admin to join this team who has experience building and maintaining database environments, including storage, OS, network, and the database itself.  The ideal candidate will have experience which spans multiple different RDBMS products, including Oracle and PostgreSQL. 

Responsibilities:

• Install, configure and deploy hardware and software for Oracle 11G and PostgreSQL 8 database servers
• Architect, configure and tune storage devices for reliability and performance
• Design and administer database backup solutions
• Ensure high availability of database hardware and software
• Create tools for automation of database administration tasks
• Plan and perform hardware and software certification tests
• Participate in 24x7 on call rotation

Qualifications:

• Expert in linux systems administration
• Expert in shell scripting and the GNU toolset
• Strong familiarity with Perl and Python
• Strong familiarity with storage architecture, including file system configuration, RAID configuration and NFS
• Experience running and supporting Oracle or PostgreSQL database servers
• Experience with clustering software (RHCS, VCS) required

Knowledge and Skills:

• 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