Database Administrator

$60,300 - $146,800/Yr

Cgi Technologies And Solutions - Charleston, SC

Full-time - Mid Level

Charleston, SC

Professional, Scientific, and Technical Services

About the position

The Database Administrator will support the International Affairs group at CGI, focusing on U.S. security and foreign relations. This role involves managing Oracle databases, ensuring their performance, security, and availability, while collaborating with a team of DevOps engineers and developers. The position requires a commitment to maintaining a Secret clearance and involves scheduled night and weekend on-call work for troubleshooting and configurations.

Responsibilities

• Install and configure Oracle Enterprise Edition 19c and higher.
• Create new databases, adhering to naming conventions and established standards.
• Maintain database baseline configuration documentation, including security controls, profiles, and roles.
• Monitor databases for performance issues and notify application administrators in case of degradation or unavailability.
• Tune database parameters and SQL as needed using Oracle tools, profiles, and indexes.
• 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 or vulnerabilities.
• Perform data exports and imports as needed to support database users.
• Create and maintain shell scripts to support administrative tasks.

Requirements

• 4-year degree in Computer Science or a similar field.
• 8-10 years IT Industry Experience.
• 8+ years in managing Oracle Databases including licensing and right-sizing.
• 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.

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