Senior Database Engineer / Administrator

CGI•Baltimore, MD

13h•$89,600 - $198,400

About The Position

CGI is in the top 5 largest global IT companies spread across 40 countries with endless opportunities to expand and grow. As a Federal CGI Partner, you have the opportunity to be a shareholder at CGI and join a family of 91,000 CGI Partners strong. CGI is seeking a Senior Database Engineer/Administrator to support enterprise database environments across Oracle, DB2, PostgreSQL, AWS RDS, Greenplum, MongoDB, ElastiCache, and Microsoft SQL Server to support a large federal agency within the CGI Civilian Business Unit. The selected candidate will provide senior level engineering, administration, performance tuning, disaster recovery, security compliance, and documentation support in alignment with federal government agency policies, enterprise standards, and internal controls. This role is responsible for ensuring database availability, resiliency, performance, and audit readiness in mission critical environments. This position is located in Baltimore, MD

Requirements

Ability to obtain and maintain US Public Trust Clearance
Bachelor's degree and a minimum of 8 years of experience in database engineering or administration across multiple DBMS platforms.
Hands on experience administering Oracle, DB2, PostgreSQL, RDS, Greenplum, MongoDB, ElastiCache, and SQL Server in enterprise environments.
Strong background in performance tuning, query optimization, indexing, parameter tuning, and platform specific monitoring tools.
Proven experience implementing and supporting high availability and disaster recovery solutions, including RAC/Data Guard, Always On, streaming replication, replica sets, RDS multi AZ, and equivalent technologies.
Demonstrated expertise with backup and recovery strategies, tools, and testing methodologies (e.g., RMAN, PITR, WAL archiving, SQL Server native backups, RDS snapshots).
Experience with security configuration, encryption, auditing, access controls, and adherence to federal or agency specific security requirements.
Ability to develop and maintain physical data models and align them with functional and nonfunctional requirements.
Ability to write automation scripts using SQL, Bash, PowerShell, Python, or equivalent scripting languages.
Experience working in Linux/Unix and Windows server environments.
Strong documentation skills and demonstrated ability to produce SOPs, runbooks, configuration guides, and audit deliverables.
Excellent communication and collaboration skills; ability to lead troubleshooting efforts and coordinate across technical teams.

Nice To Haves

Professional certifications such as Oracle OCP, IBM DB2 DBA, PostgreSQL Professional, Microsoft SQL Server certifications, AWS Database Specialty, or MongoDB DBA.
Experience with Greenplum operations, MPP tuning, and distributed database performance optimization.
Familiarity with SSA security policies, NIST 800 53, FISMA, FedRAMP, and federal audit processes.
Exposure to observability and APM platforms (CloudWatch, Grafana/Prometheus, Splunk, Datadog, AppDynamics).
Experience with DevOps and Infrastructure as Code tools (Terraform, CloudFormation, Ansible) and schema migration frameworks (Flyway, Liquibase).
Knowledge of advanced security features such as TDE, TLS configuration, row level security, data masking, and secrets management.
Experience supporting Spark clusters or integrations in enterprise analytics environments.
Prior experience supporting large federal agencies or programs with stringent availability and compliance requirements.

Responsibilities

Implement, configure, administer, and maintain Oracle, DB2, PostgreSQL, RDS, Greenplum, MongoDB, ElastiCache, and SQL Server databases in production and non production environments.
Develop and maintain complete documentation of procedures, work products, operational processes, and lifecycle activities for all supported database platforms.
Perform proactive performance tuning, monitoring, maintenance, and capacity planning to ensure optimal database performance and reliability.
Provide disaster recovery engineering and ongoing support, including backup validation, recovery testing, and compliance with SSA Backup and Recovery Executive Assurance / Internal Controls.
Deliver Tier 3 technical support, incident response, and root cause analysis for complex database issues across multiple database engines.
Support software installation, setup, configuration, patching, and integration testing activities for database products and related tools.
Develop physical data models and implement schemas, storage structures, partitioning, indexing, and other physical design elements.
Assist in the evaluation of Off The Shelf (OTS) products that rely on Oracle, DB2, PostgreSQL, RDS, Greenplum, MongoDB, ElastiCache, or SQL Server, ensuring compliance with SSA security policies and infrastructure requirements.
Establish, refine, and maintain backup and recovery strategies for Oracle, DB2, PostgreSQL, RDS, Greenplum, MongoDB, ElastiCache, Spark, SQL Server, and additional platforms as required.
Ensure all documentation, procedures, and operational artifacts are current, audit ready, and aligned with SSA standards.