Federal Aviation Administration Improves Performance and Scalability of Shared Services Center Database
 
 

Federal Aviation Administration Improves Performance and Scalability of Shared Services Center Database

Printer View Printer View

The Federal Aviation Administration (FAA) is the agency within the United States Department of Transportation with authority to regulate and oversee all aspects of civil aviation in the United States. In addition, FAA’s Enterprise Services Center is a shared services center that provides Oracle Federal Financials for agencies across the government.

 
 

 
 

Challenges

A word from Federal Aviation Administration (FAA)

  • “Once we brought Oracle Consulting in, everything clicked. We were able to migrate a large and mission-critical database on budget and with little to no disruption to our users across the government.” – Jill Thorpe, Production Support Branch Manager, Federal Aviation Administration

  • Support 40 active databases and numerous test databases, vital to FAA’s operations, including its shared services center
  • Ensure high availability of the database to meet requirements of government agency clients
  • Improve database performance and IT system scalability

Solutions

Oracle Product and Services

  • Worked with Oracle Consulting to migrate the agency’s eight terabyte database for Oracle U.S. Federal Financials to commodity servers and a four-node cluster with Oracle Real Application Clusters on Red Hat Linux
  • Benefited from Oracle Consulting’s expertise and knowledge sharing, as well as its staff resources, which enabled FAA staff to work on other critical projects
  • Completed the migration on budget and within the narrow timeframe mandated by the Federal fiscal year close schedule
  • Used Oracle Enterprise Manager to manage the entire database environment, which includes a total of 86 databases, ensuring that the database is available around-the-clock for FAA’s 5,000 shared services users
  • Established a scalable system, fostering FAA’s ability to bring additional government agencies on as clients in the shared services center
  • Realized significant improvements in database performance, for example, enabling users to process payroll in just eight hours instead of three to four days
  • Reduced overtime pay expenses by eliminating the need to clone the production database over the weekend
  • Accelerated database backup from 14 hours to as little as 4 hours