Database Administrator

$60,300 - $146,800/Yr

CGI - Charleston, SC

Full-time - Mid Level

Charleston, SC

Professional, Scientific, and Technical Services

About the position

The Database Administrator at CGI will play a crucial role in supporting the International Affairs group, focusing on U.S. security and foreign relations. This position involves managing Oracle databases, ensuring their performance, security, and availability while collaborating with various clients in the federal space. The role requires a proactive approach to problem-solving and a commitment to maintaining high standards in database management.

Responsibilities

• Scheduled night/weekend on-call work needed for configurations and troubleshooting during outage windows.
• 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.

Requirements

• An interim Secret clearance is required to begin working onsite with our client, and a Secret clearance must be maintained throughout the project duration.
• 4-year degree in Computer Science or a similar field.
• 8-10 years IT Industry Experience.
• 8+ years in managing Oracle Databases including licensing, right-sizing, etc.
• Experience with Linux.
• Desire and ability to work within a team environment of DevOps Engineers, Developers and DBAs.
• Willingness and desire to share knowledge and help teammates.
• Experience migrating Oracle databases to a Cloud environment, such as AWS or Azure.
• Experience migrating Oracle databases from Windows to Linux.

Nice-to-haves

• Oracle DBA Cert Associate
• Oracle DBA Cert Prof
• Analytical Thinking
• Database Design
• Database Tuning

Benefits

• Competitive compensation
• Comprehensive insurance options
• Matching contributions through the 401(k) plan and the share purchase plan
• Paid time off for vacation, holidays, and sick time
• Paid maternity and parental leave
• Learning opportunities and tuition assistance
• Member assistance and wellness programs