@ CGI
• Install and configure Oracle Enterprise Edition 19c and higher, as released
• Create new databases, adhering to naming conventions and established standards
• Maintain database baseline configuration documentation, including security controls, profiles, role, etc.
• Monitor databases for performance issues and notify application administrators in the event of degradation or unavailability
• Tune SQL as needed using Oracle tools, profiles, indexes, etc
• Provision database users with approved access requests
• Monitor both logical and physical replication to reporting and standby databases
• Verify backups and regularly test restore capability
• Respond to audit requests for database documentation and configuration
• Monitor security posture of the database and recommend changes to resolve issues/vulnerabilities
• Perform data exports and imports as needed to support database users (application administrators)
• Create/maintain shell scripts to support the tasks above and/or automate administrative tasks
Experience with Oracle Database Administration (under Windows, Linux, AIX and/or Solaris operating systems)
Knowledge of Active Data Guard
Knowledge of other database technologies (SQL Server, Informix, DB2, MySQL, SAP Hana) is a plus
The successful candidate will also possess the following:
• A great attitude and hunger for learning
• Excellent analytical, written and oral communication skills
• Desire and ability to work within a team environment of experienced DBAs
• Willingness and desire to share knowledge and help teammates
Due to the nature of government contract, US citizenship is required.
Desired:
Experience with Oracle on AIX
Immediate experience with Oracle Data Guard, both physical and logical replication
Experience migrating Oracle databases to a Cloud environment, such as AWS or Azure
Apply online at https://www.cgi.com/en/careers
Visit Site to Apply