Database Administrator

Back

Database Administrator

@ CGI

Position Description:

• The Operations and Architecture team supporting a large federal financial system is seeking an Oracle database administrator.
• Candidate will work with an established and experienced team of developers, application engineers, and other DBAs managing a complex on-premise solution supporting multi-site replication, 1,000s of concurrent application users, logical and physical replication, and multiple reporting solution databases.
• Scheduled night/weekend on-call work needed for configurations and troubleshooting during outage windows.

Your future duties and responsibilities:

• 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 database parameters and 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

---

Qualifications:

Required qualifications to be successful in this role:

• Candidate should have experience installing, configuring, administering and monitoring Oracle Enterprise Edition (18c or later), and working in an environment that supports at least 10 Oracle databases for multi-user applications hosted on Linux or Unix variants. 
• The role requires working with toolsets for backup and restore, monitoring (e.g., Oracle Grid Control), and both logical and physical data replication, as well as applying Oracle patches in a test environment, documenting the process, and then using the instructions as a guide for production deployment.

Desired:

• Immediate experience with Oracle Data Guard, both physical and logical replication
• Experience migrating Oracle databases to a Cloud environment, such as AWS or Azure

Skills:

• Database Administration

---

How to Apply:

Apply online at https://www.cgi.com/en/careers

Visit Site to Apply