Database Administrator

Type of Requisition:

Regular

Clearance Level Must Currently Possess:

Secret

Clearance Level Must Be Able to Obtain:

None

Public Trust/Other Required:

None

Job Family:

IT Infrastructure and Operations

Job Qualifications:

Skills:

Amazon Relational Database Service (RDS), Oracle Database, RMAN

Certifications:

None

Experience:

5 + years of related experience

US Citizenship Required:

Yes

Job Description:

DATABASE ADMINISTRATOR PRINCIPAL

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:

• Education and Experience:
  • 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.
• Technical Skills:
  • 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 Dyn