Database Engineer (Entry Level to SME) TS/SCI with Poly REQUIRED

Database Engineer (Entry Level To Sme) Ts/Sci 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. Your Future Duties And Responsibilities 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. Required Qualifications To Be Successful In This Role All levels require an active ts/sci with polyentry level:• Education: o high school diploma/ged with 4 years of relevant experience,o associates degree with 2 years of relevant experience, o or bachelor's 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: o high school diploma/ged with 6 years of relevant experience,o associates degree with 4 years of relevant experience, o bachelor's degree with 2 years of relevant experience, o or 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: o high school diploma/ged with 8 years of relevant experience,o associates degree with 6 years of relevant experience, o bachelor's degree with 4 years of relevant experience, o or masters degree with 2 years of relevant experience,o or PhD with 0 years of relevant experience• Technical skills:o Advanced command of SQL, Python, or Scala.o Deep familiarity with both RDBMS (e.g., PostgreSQL, Oracle, SQL Server) and NoSQL environments (e.g., MongoDB, Redis).o Experience 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: o High School Diploma/GED with 10 years of relevant experience,o Associates Degree with 8 years of relevant experience, o Bachelor's Degree with 6 years of relevant experience, o or Masters Degree with 4 years of relevant experience,o or 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: o High School Diploma/GED with 12 years of relevant experience,o Associates Degree with 10 years of relevant experience, o Bachelor's Degree with 8 years of relevant experience, o or Masters Degree with 6 years of relevant experience,o or 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. What You Can Expect From Us Together, as owners, let's turn meaningful insights into action. Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you'll 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. That's why we call ourselves CGI partners rather than employees. We benefit from our collective success and actively shape our company's strategy and direction.Your work creates value. You'll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your CGI