Database Architect

We need following candidate:

Title: Database Architect

Duration: 12+ Months

Remote Work (Occasional Onsite visits in Washington, DC for meetings)

**** Active DHS Clearance ****

**Job Description:**
**Overview:**
As a Database Architect, you will be responsible for designing the database architecture and data migration strategy for migrating an Oracle database to Amazon Web Services (AWS). Additionally, you will evaluate alternative database providers and recommend the most suitable solution based on technical requirements and business objectives.
**Responsibilities:**
1. **Database Architecture:** Design the database architecture for the migration project, including schema design, data modeling, indexing strategies, and partitioning schemes. Ensure the architecture meets scalability, performance, and reliability requirements.

2. **Oracle Migration Strategy:** Develop a comprehensive migration strategy for moving the Oracle database to AWS. Define the migration approach, including data extraction, transformation, and loading (ETL), as well as schema conversion and application reconfiguration.

3. **AWS Database Services:** Evaluate AWS database services such as Amazon RDS (Relational Database Service), Amazon Aurora, and Amazon DynamoDB. Assess the suitability of each service for hosting the migrated database based on factors such as performance, scalability, and cost.

4. **Alternative Database Providers:** Research and evaluate alternative database providers to Oracle, such as MySQL, PostgreSQL, or Microsoft SQL Server. Compare features, performance, licensing costs, and compatibility with AWS services to identify the best-fit solution.

5. **Data Migration Tools:** Identify and select data migration tools and technologies to streamline the migration process. Evaluate tools for data extraction, transformation, and loading, as well as schema conversion and data validation.

6. **Performance Optimization:** Optimize database performance by tuning database parameters, query optimization, and index optimization. Identify and resolve performance bottlenecks to ensure optimal performance in the cloud environment.

7. **High Availability and Disaster Recovery:** Design high availability and disaster recovery solutions to ensure business continuity and data protection. Implement replication, failover, and backup strategies to minimize downtime and data loss.

8. **Security and Compliance:** Implement security best practices to protect sensitive data and comply with industry regulations. Configure access controls, encryption, and auditing mechanisms to ensure data security and compliance with privacy requirements.

9. **Documentation and Training:** Create comprehensive documentation of the database architecture, migration strategy, and best practices. Provide training and guidance to project teams and stakeholders on database architecture and migration procedures.
**Qualifications:**
- Bachelor's degree in computer science, engineering, or related field.
- Extensive experience in database architecture, design, and administration, with a focus on Oracle databases.
- Strong expertise in AWS cloud services and experience with cloud-based database solutions.
- Familiarity with alternative database providers such as MySQL, PostgreSQL, or Microsoft SQL Server.
- Excellent analytical and problem-solving skills, with the ability to troubleshoot complex database issues.
- Strong communication and collaboration skills, with the ability to interact effectively with technical and non-technical stakeholders.

**Additional Information:**
This position offers the opportunity to work on a challenging and high-impact project that involves designing and implementing database solutions in a cloud environment. The ideal candidate will have a deep understanding of database technologies, strong problem-solving skills, and a track record of delivering successful database migration projects.