Entry Level Oracle Performance Tuning Jobs in Ashburn, VA

Database Administrator (Entry Level to SME) TS/SCI with Poly REQUIRED
Category: Database Administration
Main location: United States, Virginia, Arlington
Position ID:J0726-1963
Employment Type: Full Time
Position Description:
CGI Federal has an exciting opportunity for Database Administrators 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 Administrator assists in monitoring, securing, and maintaining organizational databases. They typically handle routine backups, manage user access permissions, track system performance, and provide fundamental support to senior administrators to ensure business data remains safe and accessible.
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)
• System Monitoring: Track database performance and storage space to catch minor issues before they disrupt business.
• Backup Management: Execute and verify daily or weekly data backups to prevent data loss in the event of an emergency.
• Access Control: Create and update accounts for authorized users, ensuring individuals only have access to the data necessary for their roles.
• Security & Patches: Apply basic software updates and malware protection patches to database servers.
• Routine Troubleshooting: Investigate user-reported errors, such as slow query times or access issues, and escalate complex problems to senior staff.
• Documentation: Maintain updated logs of database structures, server configurations, and recovery protocols
Key Responsibilities (Junior Level)
• Database Maintenance: Perform routine tasks such as database backups, transaction log management, and system updates to ensure optimal reliability.
• Security & Compliance: Manage user accounts, enforce role-based access permissions, and ensure the system complies with privacy standards.
• Performance Monitoring: Use diagnostic tools to track system health, monitor query speeds, and identify bottlenecks.
• Troubleshooting: Diagnose and resolve common database errors, escalating more complex architectural or infrastructure problems to senior staff.
• User Support: Assist developers, analysts, and end-users with retrieving data, generating reports, and resolving application-specific database issues
Key Responsibilities (Mid-Level)
• Performance Tuning & Optimization: Proactively monitor database health, execute query tuning, and optimize storage utilization to support high-transaction volumes.
• Architecture & Upgrades: Assist in database design, execute complex software patching, and implement scalable hardware or cloud-based solutions.
• Backup & Disaster Recovery: Design and test rigorous backup, archiving, and multi-region replication strategies to ensure business continuity.
• Security & Compliance: Administer strict database-level security, manage user access permissions, and enforce data compliance and audit trails.
• Troubleshooting: Diagnose and resolve complex database errors, conduct root-cause analysis, and assist in tier-3 escalation support.
• Team Collaboration: Provide technical leadership to junior DBAs and partner with software development teams to integrate scalable data solutions.
Key Responsibilities (Senior Level)
Advanced Database Architecture & Design
• Design, build, and deploy highly complex, integrated relational (e.g., Oracle, SQL Server, PostgreSQL) and NoSQL (e.g., MongoDB, Cassandra) databases.
• Define logical and physical database schemas, capacity constraints, and data distribution networks.
• Integrate on-premises data systems with multi-cloud environments (e.g., Azure SQL, Amazon RDS).
Performance Tuning & Optimization
• Act as the final point of escalation for complex performance bottlenecks, locking issues, and concurrency problems.
• Conduct in-depth SQL and PL/SQL query tuning using execution plans and diagnostic tools.
• Configure automated adjustments and indexing strategies for multi-terabyte (TB) databases to maintain aggressive SLAs.
High Availability (HA) & Disaster Recovery (DR)
• Design and implement complex replication, clustering, and failover frameworks to ensure zero or near-zero downtime.
• Formulate, test, and execute disaster recovery protocols to prevent catastrophic data loss during system failures or breaches.
• Manage intricate backup, archiving, and storage strategies.
Security & Compliance
• Design and enforce exhaustive database security frameworks.
• Implement and manage encryption (data-at-rest and in-transit), data masking, and strict access controls to adhere to strict corporate and regulatory mandates.
• Conduct vulnerability assessments and forensic data tracking.
Leadership & Technical Oversight
• Review complex application programs for appropriate database structure usage.
• Provide technical consulting, project management, and cross-departmental collaboration.
• Mentor and train lower-level DBAs and development teams.
Key Responsibilities (SME Level)
• Architecture & Strategy: Design and maintain multi-tier database reference architectures, data warehouses, and scalable, high-availability cloud solutions.
• Performance Tuning: Perform deep diagnostics on exceptionally complex queries, analyze statistics, and reconfigure DBMS engine parameters to resolve severe performance bottlenecks.
• Disaster Recovery: Formulate, script, and manage complex disaster recovery and backup strategies (e.g., cross-region replication, multi-AZ deployment) to ensure zero data loss.
• Security & Compliance: Oversee rigid information security frameworks, audit trails, user access controls, and compliance monitoring across all production and development environments.
• Leadership & Escalation: Serve as the final technical escalation point, mentor lower-level administrators (DBA 1-3), and provide cross-functional training
Required qualifications to be successful in this role:
All levels require an active TS/SCI with Poly
Entry 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
• Technical Knowledge: Basic understanding of relational database systems (e.g., MySQL, Oracle, or Microsoft SQL Server) and Structured Query Language (SQL).
• Soft Skills: Strong analytical problem-solving, meticulous attention to detail, and good written/verbal communication
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 Knowledge: Foundational proficiency in database management systems (e.g., Microsoft SQL Server or MySQL) and writing/debugging SQL queries.
• Problem-Solving: Strong analytical skills to investigate database performance issues and restore corrupted or lost data safely
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
• Database Platforms: Advanced proficiency in platforms such as Microsoft SQL Server, Oracle, PostgreSQL, or cloud-based engines like Amazon RDS / Azure SQL.
• Scripting & Automation: Strong scripting skills in Python, PowerShell, or Bash to automate repetitive database maintenance tasks.
• Cloud & Infrastructure: Working knowledge of Linux/Unix and Windows Server administration, alongside containerization and cloud infrastructure.
• Soft Skills: Excellent problem-solving, analytical thinking, and cross-team communication to translate complex business rules into data architecture.
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
• Technical Proficiencies: Mastery of advanced SQL, T-SQL, PL/SQL, and scripting languages (e.g., Python, PowerShell, or Bash) for automation.
• Certifications: Advanced vendor certifications are heavily favored (e.g., Microsoft Certified: Azure Database Administrator Associate, Oracle Certified Professional, or MongoDB Certified DBA).
• Soft Skills: Exceptional problem-solving skills under high-pressure scenarios, proactive continuous learning habits, and strong communication skills to present to non-technical stakeholders.
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
• Technical Proficiencies: Advanced, master-level mastery of SQL and multiple DBMS platforms (e.g., Oracle, MS SQL Server, PostgreSQL, or NoSQL). Deep understanding of cloud database infrastructures (AWS RDS, Azure SQL, GCP Cloud SQL).
• Soft Skills: Exceptional root-cause analysis, crisis management, project management, and cross-departmental communication
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 $89,600.00 - $204,000.00.
CGI Federal's 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
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 ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.
You'll shape your career by joining a company built to grow and last. You'll 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 team-one 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 US_Employment_Compliance@cgi.com. 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 loca