Department of State - Consular Report of Birth Abroad

Image

The Consular Report of Birth Abroad (CRBA) Division is responsible for processing the birth children of U.S. Citizens and Non-Citizen Nationals whose children are born abroad.

Harris Corporation was an American technology company, defense contractor, and information technology services provider that produced wireless equipment, tactical radios, electronic systems, night vision equipment and both terrestrial and spaceborne antennas for use in the government, defense and commercial sectors.

A security clearance allows an individual filling a specific position to have access to classified national security information up to and including the level of clearance that they hold as long as the individual has a ‘need to know ‘ the information and signed a non-disclosure agreement.

Supported the Consular Report on Birth Abroad (CRBA) on an Oracle 11g Database. This support involved writing and supporting complex Oracle packages in a server farm of over 280 Oracle servers located throughout the U.S. Embassy and Consulate services abroad. This involved having a deeper understanding of Oracle Replication/Datastreams and architecture.

The CRBA Application is a "fat backend Oracle system" that relies heavily on database objects such as triggers, stored procedures and packages. This contract required a knowledge of oracle back-end systems for the maintenance of the application system. In addition, the architecture of the system was global due to embassies and consulates world-wide as the system replication module ensured the integrity of the data.