Database Engineer (Entry Level to SME) TSSCI with Poly REQUIRED

CGI Federal has an exciting opportunity for Database Engineers within our Intel sector advancing the national security mission through cutting edge technology. You must have a passion for keeping pace with rapidly evolving technology advancements and leveraging your knowledge on a highly collaborative team to deliver state-of-the-art capabilities.

The Database Engineer builds maintains and optimizes basic database systems. They write SQL assist senior engineers with schema design and help secure and troubleshoot day-to-day data storage. It is a hands-on support role focused on ensuring data is accessible and error-free.

CGI Federal is growing its high-performance team whose members share a passion for building high-quality scalable advanced IT solutions in a collaborative fast-paced outcome-driven mission.

This position is located in our Arlington office; however a hybrid working model is acceptable.

Key Responsibilities (Entry Level)
Database Maintenance: Assist with routine backups software patching and system health monitoring.
Query Optimization: Write and test basic SQL queries and scripts to ensure fast and efficient data retrieval.
Database Development: Support the team by implementing minor database changes tables and views.
Troubleshooting: Help identify log and resolve basic database errors or connectivity issues.
Documentation: Maintain accurate records of database schemas data flows and system configurations.
Collaboration: Work alongside software developers and system administrators to integrate databases with web applications.

Key Responsibilities (Junior Level)
Database Maintenance: Assist in monitoring database performance health and capacity.
Query Optimization: Review and rewrite basic SQL queries to improve retrieval speed and efficiency.
Database Code: Create modify and test database objects such as stored procedures triggers and functions.
Support & Troubleshooting: Act as the first line of support for database-related inquiries resolving minor errors or bugs.
Security & Backups: Enforce data security standards manage user access permissions and assist with backup and recovery processes.
Documentation: Maintain and update technical documentation regarding database design configurations and change management.

Key Responsibilities (Mid-Level)
Database Architecture & Design: Design and evolve scalable relational and non-relational database systems (e.g. SQL Server Oracle PostgreSQL MongoDB) to meet growing enterprise needs.
Performance Optimization: Proactively identify problematic patterns rewrite complex queries implement partitioning strategies and add/remove indexes for zero-downtime scalability.
Pipeline Management: Build automate and maintain robust ETL/ELT workflows to securely ingest transform and synchronize large datasets across multiple systems.
Backup & Recovery: Architect and enforce comprehensive backup protocols and disaster recovery procedures to protect against data loss.
Technical Support & Mentorship: Act as a technical escalation point for Tier 1 support or junior engineers debug complex database errors and review database changes submitted by other developers.
Security & Governance: Ensure data compliance implement role-based access controls and establish strong data governance frameworks.

Key Responsibilities (Senior Level)
Architecture & Systems Design
Design and implement relational and object-oriented database (OODB) schemas for highly distributed large-scale production environments.
Project long-range database administration and infrastructure needs based on organizational growth and system roadmaps.
Create database parser and loading software to manage seamless zero-downtime data migrations and ingest.
Performance Optimization & Scalability
Execute granular query analysis index tuning and database refactoring to solve complex performance bottlenecks (e.g. preventing primary key integer overflows or mitigating inefficient load balancing).
Develop ad hoc queries scripts and macros in languages like Python Bash or PL/SQL to automate database operations.
Architect efficient queueing strategies caching patterns and table partitioning.
Data Security & Governance
Enforce domain controls security protocols and data governance frameworks across the database landscape.
Establish robust backup protocols disaster recovery (DR) frameworks and zero-downtime failover procedures.

Key Responsibilities (SME Level)
Architecture & Systems Design
Design build and scale enterprise databases (e.g. PostgreSQL Oracle RAC distributed NoSQL) handling hundreds of millions to billions of transactions daily.
Architect highly available multi-region disaster recovery (DR) solutions and implement zero-downtime migration frameworks.
Establish enterprise-wide database coding and architectural patterns to enforce quality and security standards.
Performance Tuning & Optimization
Execute deep-dive diagnostics into database engines to identify and eliminate latency and throughput bottlenecks.
Audit execution plans re-write inefficient SQL/PL-SQL optimize indexing and fine-tune server memory allocation.
Implement robust database load-balancing sharding and caching strategies.
Leadership & Mentorship
Act as the ultimate escalation point for complex unprecedented database incidents.
Collaborate with executive leadership and software architects to align data engineering strategy with broader business objectives.
Lead technical design and code reviews mentoring junior/mid-level database engineers and administrators.
Data Security & Governance
Implement strict data security management including compliance auditing (e.g. GDPR HIPAA PCI-DSS).
Manage encryption at-rest and in-transit robust role-based access control (RBAC) and automated threat monitoring.

All levels require an active TS/SCI with Poly

Entry Level:
Education:
oHigh School Diploma/GED with 4 years of relevant experience
oAssociates Degree with 2 years of relevant experience
oor Bachelors Degree with 0 years of relevant experience
SQL Proficiency: Fundamental understanding of SQL (Structured Query Language) for querying and managing databases.
Database Knowledge: Familiarity with relational database systems (e.g. MySQL PostgreSQL SQL Server) and basic NoSQL concepts (e.g. MongoDB).
Analytical Skills: Basic problem-solving abilities to trace the root cause of data anomalies.

Junior Level/Moderate:
Education:
oHigh School Diploma/GED with 6 years of relevant experience
oAssociates Degree with 4 years of relevant experience
oBachelors Degree with 2 years of relevant experience
oor Masters Degree with 0 years of relevant experience
Technical Skills: Foundational knowledge of relational databases (e.g. PostgreSQL MySQL SQL Server Oracle) and proficiency in SQL.
Scripting: Familiarity with basic programming or scripting languages (e.g. Python) to automate routine database tasks is often preferred.
Soft Skills: Strong analytical skills attention to detail and the ability to communicate technical database concepts to non-technical team members.

Mid-Level/Complex:
Education:
oHigh School Diploma/GED with 8 years of relevant experience
oAssociates Degree with 6 years of relevant experience
oBachelors Degree with 4 years of relevant experience
oor Masters Degree with 2 years of relevant experience
oor PhD with 0 years of relevant experience
Technical Skills:
oAdvanced command of SQL Python or Scala.
oDeep familiarity with both RDBMS (e.g. PostgreSQL Oracle SQL Server) and NoSQL environments (e.g. MongoDB Redis).
oExperience with cloud databases (AWS Azure or GCP).
Tooling & Environments: Proficiency with continuous integration deployment and version control tools (e.g. Git Jira Confluence Jenkins).

Senior Level/Exceptionally Complex:
Education:
oHigh School Diploma/GED with 10 years of relevant experience
oAssociates Degree with 8 years of relevant experience
oBachelors Degree with 6 years of relevant experience
oor Masters Degree with 4 years of relevant experience
oor PhD with 2 years of relevant experience
Expertise: Deep hands-on experience with Relational and NoSQL platforms (e.g. PostgreSQL DynamoDB) operating in Linux environments.
Tooling & Devops: Proficiency in CI/CD pipeline integration utilizing tools such as Git Jira Kubernetes and Ansible.

SME Level/Exceptionally Complex:
Education:
oHigh School Diploma/GED with 12 years of relevant experience
oAssociates Degree with 10 years of relevant experience
oBachelors Degree with 8 years of relevant experience
oor Masters Degree with 6 years of relevant experience
oor PhD with 4 years of relevant experience
Relational / Distributed DBs: Expert-level understanding of relational engine internals (e.g. PostgreSQL Oracle MySQL SQL Server) and distributed/NoSQL databases.
Programming & Scripting: Advanced proficiency in SQL PL-SQL and scripting languages like Python or Shell.
Cloud & Infrastructure: Hands-on experience with cloud-managed database services (AWS RDS/Aurora GCP Cloud SQL or Azure) and infrastructure as code tools (Terraform).
Soft Skills: Exceptional communication stakeholder management and cross-functional leadership abilities.

CGI is required by law in some jurisdictions to include a reasonable estimate of the compensation range for this role. The determination of this range includes various factors not limited to skill set level experience relevant training and licensure and certifications. To support the ability to reward for merit-based performance CGI typically does not hire individuals at or near the top of the range for their role. Compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range for this role in the U.S. is $89600.00 - $204000.00.

CGI Federals benefits are offered to eligible professionals on their first day of employment to include:
. 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 parental leave
. Learning opportunities and tuition assistance
. Wellness and Well-being programs

#CGIFederalJob
#LI-LB1
#ClearanceJobs
#CGIInternationalSecurity

Together as owners lets turn meaningful insights into action.

Life at CGI is rooted in ownership teamwork respect and belonging. Here youll reach your full potential because

You are invited to be an owner from day 1 as we work together to bring our Dream to life. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction.

Your work creates value. Youll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas embrace new opportunities and benefit from expansive industry and technology expertise.

Youll shape your career by joining a company built to grow and last. Youll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

Come join our teamone of the largest IT and business consulting services firms in the world.

Qualified applicants will receive consideration for employment without regard to their race ethnicity ancestry color sex religion creed age national origin citizenship status disability pregnancy medical condition military and veteran status marital status sexual orientation or perceived sexual orientation gender gender identity and gender expression familial status or responsibilities reproductive health decisions political affiliation genetic information height weight or any other legally protected status or characteristics to the extent required by applicable federal state and/or local laws where we do business.

CGI provides reasonable accommodations to qualified individuals with disabilities. If you need an accommodation to apply for a job in the U.S. please email the CGI U.S. Employment Compliance mailbox at . You will need to reference the Position ID of the position in which you are interested. Your message will be routed to the appropriate recruiter who will assist you. Please note this email address is only to be used for those individuals who need an accommodation to apply for a job. Emails for any other reason or those that do not include a Position ID will not be returned.

We make it easy to translate military experience and skills! Click here to be directed to our site that is dedicated to veterans and transitioning service members.

All CGI offers of employment in the U.S. are contingent upon the ability to successfully complete a background investigation. Background investigation components can vary dependent upon specific assignment and/or level of US government security clearance held. Dependent upon role and/or federal government security clearance requirements and in accordance with applicable laws some background investigations may include a credit check. CGI will consider for employment qualified applicants with arrests and conviction records in accordance with all local regulations and ordinances.

CGI will not discharge or in any other manner discriminate against employees or applicants because they have inquired about discussed or disclosed their own pay or the pay of another employee or applicant. However employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information unless the disclosure is (a) in response to a formal complaint or charge (b) in furtherance of an investigation proceeding hearing or action including an investigation conducted by the employer or (c) consistent with CGIs legal duty to furnish information.