What are the responsibilities and job description for the Senior Database Architect position at 9th Way Insignia?
Job Details
9th Way Insignia is a service-disabled, veteran-owned small business bringing transformative technology to our government customers so they can achieve their missions. Our specialties include cybersecurity, cloud modernization, software development, data analytics, enterprise architecture, enterprise IT, analytics, process automation, and artificial intelligence. Learn more about 9th Way Insignia at
Team (Project) Introduction
This project supports the Department of Veterans Affairs' Enterprise Data Warehouse (EDW) environment. The team is composed of experienced Oracle database administrators, developers, and business intelligence professionals. Working closely with Oracle Commercial Professional Services, the team analyzes the current environment, provides access to logs and metrics, and implements performance tuning recommendations. The team follows agile principles, provides frequent updates, and aims to improve the EDW environment in preparation for cloud migration.
Professional Level Information
The Senior Database Architect position aligns as an Engineer 3 at 9th Way Insignia. An Engineer 3 typically plans and directs research or development work on complex projects, provides technical leadership, and collaborates with teams in designing and implementing advanced systems. This individual has strong technical skills, deep subject matter expertise, and leads resolution of complex challenges.
Responsibilities
- Serve as the senior Oracle technical expert for the EDW optimization and cloud migration readiness task.
- Provide guidance and direction to junior resources, including Database Administrators, Developers, and Senior Developers.
- Coordinate directly with Oracle Commercial Professional Services to ensure access to system data, logs, ETL pipelines, and performance metrics.
- Review, validate, and quality-assure deliverables in partnership with the Project Manager.
- Oversee schema analysis, partitioning strategies, indexing, and tuning recommendations.
- Lead the integration of Oracle GoldenGate configurations and data replication enhancements.
- Ensure deliverables align with 9th Way Insignia standards and meet customer expectations.
- Provide technical expertise in performance diagnostics, storage optimization, and query tuning.
- Support the creation of migration readiness assessments, optimization plans, and implementation roadmaps.
- Other duties as assigned.
Requirements
- Master's degree in Computer Science, Electronics Engineering, or other engineering or technical discipline is required.
- An additional 5 years of relevant experience may be substituted in lieu of the degree.
- A minimum of 10 years of experience in the field.
- Extensive experience in Oracle database architecture, including schema design, indexing, materialized views, and performance tuning.
- Strong understanding of ETL workflows and business intelligence tools.
- Experience working with Oracle GoldenGate and data replication in hybrid environments.
- Demonstrated leadership in technical projects and mentoring of junior engineering staff.
- Must be able to obtain a Public Trust Tier 2/Moderate clearance. Existing clearances are preferred.
- Must be available to work onsite 8 hours a day, Monday through Friday at 1800 G Street NW, Washington, DC.
Preferred/Desired
- Oracle certifications related to database administration or architecture.
Location
This position is onsite at 1800 G Street NW, Washington, DC. Must be onsite Monday through Friday for 8 hours per day.
Salary Range
$120,518 - $150,000 USD
9thWay Insignia's range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.
Clearance/Background Investigation
Applicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to classified information.
Benefits
Eligible employees will have access to our comprehensive benefits package which includes Medical, Dental, Vision, Voluntary Life Insurance, 401(k), Basic Life A&D, STD, LTD, PTO, Telehealth, paid holidays, FSA, HSA. Additional resources include our Employee Assistance Program (EAP) and Traveling Assistance.
Legal
We're an equal employment opportunity/affirmative action employer that empowers our people to fearlessly drive change - no matter their race, color, ethnicity, religion, sex (including pregnancy, childbirth, lactation, or related medical conditions), national origin, ancestry, age, marital status, sexual orientation, gender identity and expression, disability, veteran status, military or uniformed service member status, genetic information, or any other status protected by applicable federal, state, local, or international law. .
Team (Project) Introduction
This project supports the Department of Veterans Affairs' Enterprise Data Warehouse (EDW) environment. The team is composed of experienced Oracle database administrators, developers, and business intelligence professionals. Working closely with Oracle Commercial Professional Services, the team analyzes the current environment, provides access to logs and metrics, and implements performance tuning recommendations. The team follows agile principles, provides frequent updates, and aims to improve the EDW environment in preparation for cloud migration.
Professional Level Information
The Senior Database Architect position aligns as an Engineer 3 at 9th Way Insignia. An Engineer 3 typically plans and directs research or development work on complex projects, provides technical leadership, and collaborates with teams in designing and implementing advanced systems. This individual has strong technical skills, deep subject matter expertise, and leads resolution of complex challenges.
Responsibilities
- Serve as the senior Oracle technical expert for the EDW optimization and cloud migration readiness task.
- Provide guidance and direction to junior resources, including Database Administrators, Developers, and Senior Developers.
- Coordinate directly with Oracle Commercial Professional Services to ensure access to system data, logs, ETL pipelines, and performance metrics.
- Review, validate, and quality-assure deliverables in partnership with the Project Manager.
- Oversee schema analysis, partitioning strategies, indexing, and tuning recommendations.
- Lead the integration of Oracle GoldenGate configurations and data replication enhancements.
- Ensure deliverables align with 9th Way Insignia standards and meet customer expectations.
- Provide technical expertise in performance diagnostics, storage optimization, and query tuning.
- Support the creation of migration readiness assessments, optimization plans, and implementation roadmaps.
- Other duties as assigned.
Requirements
- Master's degree in Computer Science, Electronics Engineering, or other engineering or technical discipline is required.
- An additional 5 years of relevant experience may be substituted in lieu of the degree.
- A minimum of 10 years of experience in the field.
- Extensive experience in Oracle database architecture, including schema design, indexing, materialized views, and performance tuning.
- Strong understanding of ETL workflows and business intelligence tools.
- Experience working with Oracle GoldenGate and data replication in hybrid environments.
- Demonstrated leadership in technical projects and mentoring of junior engineering staff.
- Must be able to obtain a Public Trust Tier 2/Moderate clearance. Existing clearances are preferred.
- Must be available to work onsite 8 hours a day, Monday through Friday at 1800 G Street NW, Washington, DC.
Preferred/Desired
- Oracle certifications related to database administration or architecture.
Location
This position is onsite at 1800 G Street NW, Washington, DC. Must be onsite Monday through Friday for 8 hours per day.
Salary Range
$120,518 - $150,000 USD
9thWay Insignia's range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.
Clearance/Background Investigation
Applicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to classified information.
Benefits
Eligible employees will have access to our comprehensive benefits package which includes Medical, Dental, Vision, Voluntary Life Insurance, 401(k), Basic Life A&D, STD, LTD, PTO, Telehealth, paid holidays, FSA, HSA. Additional resources include our Employee Assistance Program (EAP) and Traveling Assistance.
Legal
We're an equal employment opportunity/affirmative action employer that empowers our people to fearlessly drive change - no matter their race, color, ethnicity, religion, sex (including pregnancy, childbirth, lactation, or related medical conditions), national origin, ancestry, age, marital status, sexual orientation, gender identity and expression, disability, veteran status, military or uniformed service member status, genetic information, or any other status protected by applicable federal, state, local, or international law. .
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Salary : $120,518 - $150,000
