Database Administrator

General Dynamics Information Technology

1d•$140,250 - $189,750•Hybrid

About The Position

Advance how our customers operate while you advance your career. Join GDIT as a Database Administrator Principal and build an impactful career in enterprise IT, collaborating with people who are driven and resourceful like you. MEANINGFUL WORK AND PERSONAL IMPACT As a Database Administrator Principal, the work you’ll do at GDIT will be impactful to the mission of Homeland Security Task Force National Coordination Center. You will play a crucial role in care and feeding of the law enforcement data in 100s of Terrabytes. We are seeking a proactive and skilled Oracle Database Administrator (DBA) to assist with migrating Oracle databases to AWS cloud-based database services. This role focuses on supporting migration efforts, database maintenance, and ensuring database performance, reliability, and security in the AWS environment. The ideal candidate should have hands-on experience with Oracle databases and some familiarity with AWS database services, with a desire to grow their skill set in cloud-based database technologies. ● Migration Support: Collaborate with senior DBAs and cloud architects in analyzing existing Oracle workloads and planning database migration to AWS. Assist in executing database migration processes using tools like AWS Database Migration Service (DMS) and Schema Conversion Tool (SCT). Perform initial validations of schema conversion and data accuracy post-migration. AWS Database Configuration: Help configure AWS database services such as Amazon RDS, Amazon Aurora, or Amazon DynamoDB based on business requirements. Assist in setting up backup and recovery processes for cloud databases. Work on tuning database instances for optimal performance in AWS. Data Migration and Transformation: Support ETL processes for extracting, transforming, and loading data from Oracle to AWS cloud databases. Ensure data integrity and validation during migration by reconciling transformed data. Database Monitoring and Maintenance: Oracle Databases (19c) on the classified and unclassified sides along with Oracle Identity and Access Management servers and associated services. Monitor cloud database operations using AWS tools such as CloudWatch and Performance Insights. Troubleshoot performance bottlenecks, connection issues, and database errors. Implement indexing or partitioning strategies as directed to improve performance. Oracle backup and recovery using RMAN Install/patch Oracle Software/Create New Oracle instances, and standby database management. Security and Compliance: Assist in the implementation of security best practices, including configuring IAM roles, database encryption, and access controls. Ensure compliance with organizational standards and guidelines for cloud database deployment. Documentation and Collaboration: Contribute to the documentation of database migration processes, configurations, and issue resolutions. Work collaboratively with senior team members, developers, and cloud engineers to ensure successful migration and integration. Provide insights and recommendations to improve processes for future migrations. WHAT YOU’LL NEED TO SUCCEED Bring your technology expertise and drive for innovation to GDIT. The Database Administrator Principal must have:

Requirements

Bachelor’s degree in Computer Science, Information Technology, or a related field.
5+ years of experience in Oracle database administration.
Some hands-on experience with AWS database services or other cloud-based database technologies.
Proficiency in Oracle database administration, including schema management, PL/SQL, Linux shell scripting, SQL-Plus, Oracle Enterprise manager, RMAN and performance tuning.
Basic knowledge of AWS RDS, Aurora, or DynamoDB.
Experience with database migration processes, preferably using AWS DMS or other migration tools.
Familiarity with SQL query optimization and troubleshooting.
Basic understanding of AWS cloud fundamentals (e.g., EC2, S3, IAM) and database monitoring tools.
Strong problem-solving skills with attention to detail to manage risks.
Excellent communication and teamwork skills for working with cross-functional teams.
A willingness to learn and grow in the AWS cloud database ecosystem.
Ability to prioritize tasks and handle multiple responsibilities effectively.
Security clearance level: Secret is required
US citizenship required

Nice To Haves

Exposure to AWS migration tools, such as Schema Conversion Tool (SCT) and AWS DMS.
Familiarity with cloud automation tools such as CloudFormation or Terraform.
Relevant certifications (preferred but not required): AWS Certified Database – Specialty Oracle Certified Associate (OCA) AWS Cloud Practitioner or Solutions Architect Associate
Experience working with databases such as PostgreSQL, MySQL, or Redshift is a plus.

Responsibilities

Migration Support: Collaborate with senior DBAs and cloud architects in analyzing existing Oracle workloads and planning database migration to AWS.
Assist in executing database migration processes using tools like AWS Database Migration Service (DMS) and Schema Conversion Tool (SCT).
Perform initial validations of schema conversion and data accuracy post-migration.
AWS Database Configuration: Help configure AWS database services such as Amazon RDS, Amazon Aurora, or Amazon DynamoDB based on business requirements.
Assist in setting up backup and recovery processes for cloud databases.
Work on tuning database instances for optimal performance in AWS.
Data Migration and Transformation: Support ETL processes for extracting, transforming, and loading data from Oracle to AWS cloud databases.
Ensure data integrity and validation during migration by reconciling transformed data.
Database Monitoring and Maintenance: Oracle Databases (19c) on the classified and unclassified sides along with Oracle Identity and Access Management servers and associated services.
Monitor cloud database operations using AWS tools such as CloudWatch and Performance Insights.
Troubleshoot performance bottlenecks, connection issues, and database errors.
Implement indexing or partitioning strategies as directed to improve performance.
Oracle backup and recovery using RMAN Install/patch Oracle Software/Create New Oracle instances, and standby database management.
Security and Compliance: Assist in the implementation of security best practices, including configuring IAM roles, database encryption, and access controls.
Ensure compliance with organizational standards and guidelines for cloud database deployment.
Documentation and Collaboration: Contribute to the documentation of database migration processes, configurations, and issue resolutions.
Work collaboratively with senior team members, developers, and cloud engineers to ensure successful migration and integration.
Provide insights and recommendations to improve processes for future migrations.

Benefits

Growth: AI-powered career tool that identifies career steps and learning opportunities
Support: An internal mobility team focused on helping you achieve your career goals
Rewards: Comprehensive benefits and wellness packages, 401K with company match, and competitive pay and paid time off
Flexibility: Full-flex work week to own your priorities at work and at home subject to approval by customer.
Community: Award-winning culture of innovation and a military-friendly workplace

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume