CGI Technologies and Solutions, Inc. Oracle Data Architect in Baltimore, Maryland

Oracle Data Architect

CGI-experience the commitment

Find similar career opportunities

Category:Information Technology

City:Baltimore, Maryland, United States

Position ID:J0916-1318

Employment Type:Full Time

Meet our professionals

CGI: An employer of choice

Position Description:

CGI is seeking to hire an Oracle Data Architect in support of it's Strategic Banking Client in Baltimore MD.

Your future duties and responsibilities:

-Database structural requirements must be determined by analyzing client operations, applications, and programming, reviewing objectives with clients, and evaluating current systems.

-The position requires Strong Oracle SQL experience with RDBMS design and/or architecture is important. In this role, you will be responsible for writing stored procedures, functions, triggers, and adhoc queries using PL/SQL.

Required qualifications to be successful in this role:

• Must have 8+ years hands on RDBMS design or and architecture experience

• Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions.

• Ability to present the pros and cons of various design and SQL coding techniques

• Understanding of star-schema data warehousing concepts and implementations

• Ability to interact with both Business and Technology colleagues

• Good knowledge in optimization techniques of application and handling big amount of data

• Determines database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems;

• Coordinates new data development ensuring consistency and integration with existing data warehouse structure

• Good experience of large-scale data migration projects with multiple data sources and familiar with Extract-Transform-Load patterns and processes

• Experience writing stored procedures, functions, triggers, and adhoc queries using SQL

• Experience with performance tuning of complicated queries and procedures

• Familiarity with Oracle execution plans and statistics

• Experience with Oracle SQL Developer client

• Should have experience with source code and version control using Git or SVN

• Must have worked on Financial applications using RDBMS design and or architecture


Git/SVN, Oracle SQL


Bachelor’s Degree


Initial HR screening followed by project business and technical interview; followed by client interview as last step.

What you can expect from us:

At CGI, we’re a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 65,000 professionals located in 40 countries. Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve results for our clients - and for our members. Come grow with us. Learn more at

This is a great opportunity to join a winning team. CGI offers a competitive compensation package with opportunities for growth and professional development. Benefits for full-time, permanent members start on the first day of employment and include a paid time-off program and profit participation and stock purchase plans.

We wish to thank all applicants for their interest and effort in applying for this position, however, only candidates selected for interviews will be contacted.

No unsolicited agency referrals please.

All CGI offers of employment in the U.S. are contingent upon the ability to successfully complete a background investigation. Background investigation components can vary depending upon specific assignment, or upon any US government security clearance if required. Qualified applicants will receive consideration for employment without regard to their race, color, religion, sex, gender Identity, sexual orientation, national origin, age, disability, veteran status, pregnancy, or other status protected by law. CGI will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with CGI’s legal duty to furnish information.

Have you been referred by a CGI Member for this application?* Yes No

CGI Member’s E-Mail (*

Referral First name

Referral Last name

By checking this box you agree to allow us to contact the CGI member who referred you to obtain additional information about your application and to confirm your referral.*

Are you interested in this job?

In the US, CGI is committed to a policy of equal employment opportunity. We recruit, employ, train, compensate, and promote without regard to race, ancestry, color, sex, religion, creed, age, national origin, citizenship status, disability, medical condition, military and veteran status, marital status, sexual orientation or perceived sexual orientation, gender, gender identity and gender expression, familial status, political affiliation, genetic information, or any other legally protected status or characteristics.

CGI is committed to the principles of equal employment opportunity and to compliance with US laws and regulations. Click here at to access our US EEO/Affirmative action policy.

Applicants have rights under Federal Employment Laws:

  1. EPPA at

  2. FMLA at

  3. Consolidated EEO Is The Law at

If you need an accommodation in order to complete the application process, click here at .

We make it easy to translate military experience and skills! Click here at to be directed to our site that is dedicated to veterans and transitioning service members.