Oracle Application DBA (Infrastructure)
- Job Category: Engineering/Technical
- Education: Bachelors Degree
- FT/PT: Full-Time
- Company: CGI
Position ID: J0421-2699
CGI has an immediate need for a Oracle Application DBA (Infrastructure) to join our financial services team in Knoxville, TN. This is an exciting opportunity to work in a fast-paced team environment supporting one of the largest leaders in the secondary mortgage industry. We take an innovative approach to supporting our client, working side-by-side in an agile environment using emerging technologies.
We partner with 15 of the top 20 banks globally, and our top 10 banking clients have worked with us for an average of 26 years!
We have over 73,000+ CGI Members in 40 countries and over 5k+ loyal Clients who are leveraging our end-to-end services across the globe
CGI is looking for a seasoned Oracle DBA (Infrastructure) with both application and infrastructure support experience. This is a position within the Enterprise DB Support team responsible to support multiple business portfolios across multiple platforms and a great opportunity to pick up new skills supporting our clients Cloud transformation initiative.
Bachelor degree in Computer Science, Information Systems or related field
Your future duties and responsibilities:
Release management and on-call support for Production databases. This involves providing DB Support for multiple Application teams for Development release.
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.
Install and configure Oracle Enterprise Edition 12c and higher.
DB upgrade and Patching
Create new databases, adhering to naming conventions and established standards
Maintain database baseline configuration documentation, including security controls, profiles, role, etc.
Provision database users with approved access requests
Monitor both logical and physical replication to reporting and standby databases
Setup/Support for Dataguard. Verify backups and regularly test restore capability
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 DB Administration tasks and/or automate them via Shell/Python/Sql.
Database migrations from On-prem to AWS RDS (Oracle-Oracle, Oracle-Postgres, Sybase-Postgres)
Required qualifications to be successful in this role:
Minimum 7+ years overall with at least 5 years as ORACLE DBA.
4-5+ years of experience in Oracle 12c/19c including Backup, Dataguard, RAC/ASM, OEM, Performance Tuning, and fundamental database administrations.
1-2 years of coding experience of Unix shell scripting or Python
1-2 years of AWS experience, e.g. RDS, Aurora, etc.
Experience administering a large enterprise database environment.
Experience with MS SQL server, PostgreSQL will be an added advantage
AWS Big Data
500 West Summit Hill Drive
Knoxville TN 37902
Job Link: Apply Here!