Peraton
Cloud Database Administrator
Peraton, Reston, Virginia, United States, 22090
Cloud Database Administrator
Job Locations:
USRequisition ID:
2024-149814Position Category:
Information TechnologyClearance:
Public Trust
Responsibilities
Peraton is seeking a
Cloud Database Administrator
for the FRBNY Cloud Application migration team. This qualified individual will migrate Oracle databases on-premise to the AWS cloud.
This is a remote position.What you will do:Migrate databases from on-premise Oracle to RDS at AWS.Ensure integrity of the data migrations.Perform a detailed analysis of the current Oracle 12 database and document existing schema, data types, stored procedures, triggers, and other objects.Identify the data to be migrated, including tables, indexes, views, and relationships.Gather performance, security, and compliance requirements for the new Postgres SQL 15 database.Define the migration and develop a migration plan.Review existing data migration work and reuse work as suitable.Script Review and Development:Review scripts developed to convert Oracle schemas to Postgres-compatible schemas, ensuring data types and constraints are appropriately mapped.Review scripts for extracting, transforming, and loading (ETL) data from Oracle to Postgres, ensuring data integrity and consistency.Review scripts to convert Oracle stored procedures, functions, and triggers to Postgres equivalents and handle any Oracle-specific SQL syntax and features.Review scripts to recreate indexes and constraints in Postgres and optimize indexes for performance.Testing and Validation:Test migration scripts in a development environment to ensure they work as expected, validating schema conversion and data migration accuracy.Conduct functional testing to ensure the application works correctly with the new Postgres database and test all critical application functions.Conduct performance tuning of indexes and databases in general.Review database design and integration of systems, provide backup recovery, and make recommendations regarding enhancements and/or improvements.Maintain security and integrity controls.May develop stored procedures and/or triggers.Assist Database Designers or Information System Analysts in the development and creation of SQL and web-based databases and database systems.Review technical designs, reports, documentation, and other materials.
Qualifications
Required Qualifications:Bachelor's Degree and a minimum of 5 years working experience as a Database Administrator (DBA). Additional 4 years of experience may be accepted in lieu of the degree.Experience with data migrations to AWS RDS.Experience tuning SQL queries, optimizing indexing strategies, and configuring caching mechanisms to improve system performance.Familiar with a variety of database systems, such as Microsoft SQL Server, and other Database Management Systems (DBMS).Must be a US Citizen.Must be able to obtain and maintain the required agency clearance (Public Trust).Preferred Qualifications:Federal or Government contracting and consulting experience is a plus.Master's degree is a plus.AWS Database certifications.Minimum AWS Certified Solutions Architect - Associate.Benefits:At Peraton, our benefits are designed to help keep you at your best beyond the work you do with us daily. We're fully committed to the growth of our employees. From fully comprehensive medical plans to tuition reimbursement, tuition assistance, and fertility treatment, we are there to support you all the way.
Peraton Overview
Peraton is a next-generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world's leading mission capability integrator and transformative enterprise IT provider, we deliver trusted, highly differentiated solutions and technologies to protect our nation and allies. Peraton operates at the critical nexus between traditional and nontraditional threats across all domains: land, sea, space, air, and cyberspace. The company serves as a valued partner to essential government agencies and supports every branch of the U.S. armed forces.
Target Salary Range
$80,000 - $128,000. This represents the typical salary range for this position based on experience and other factors.
#J-18808-Ljbffr
Job Locations:
USRequisition ID:
2024-149814Position Category:
Information TechnologyClearance:
Public Trust
Responsibilities
Peraton is seeking a
Cloud Database Administrator
for the FRBNY Cloud Application migration team. This qualified individual will migrate Oracle databases on-premise to the AWS cloud.
This is a remote position.What you will do:Migrate databases from on-premise Oracle to RDS at AWS.Ensure integrity of the data migrations.Perform a detailed analysis of the current Oracle 12 database and document existing schema, data types, stored procedures, triggers, and other objects.Identify the data to be migrated, including tables, indexes, views, and relationships.Gather performance, security, and compliance requirements for the new Postgres SQL 15 database.Define the migration and develop a migration plan.Review existing data migration work and reuse work as suitable.Script Review and Development:Review scripts developed to convert Oracle schemas to Postgres-compatible schemas, ensuring data types and constraints are appropriately mapped.Review scripts for extracting, transforming, and loading (ETL) data from Oracle to Postgres, ensuring data integrity and consistency.Review scripts to convert Oracle stored procedures, functions, and triggers to Postgres equivalents and handle any Oracle-specific SQL syntax and features.Review scripts to recreate indexes and constraints in Postgres and optimize indexes for performance.Testing and Validation:Test migration scripts in a development environment to ensure they work as expected, validating schema conversion and data migration accuracy.Conduct functional testing to ensure the application works correctly with the new Postgres database and test all critical application functions.Conduct performance tuning of indexes and databases in general.Review database design and integration of systems, provide backup recovery, and make recommendations regarding enhancements and/or improvements.Maintain security and integrity controls.May develop stored procedures and/or triggers.Assist Database Designers or Information System Analysts in the development and creation of SQL and web-based databases and database systems.Review technical designs, reports, documentation, and other materials.
Qualifications
Required Qualifications:Bachelor's Degree and a minimum of 5 years working experience as a Database Administrator (DBA). Additional 4 years of experience may be accepted in lieu of the degree.Experience with data migrations to AWS RDS.Experience tuning SQL queries, optimizing indexing strategies, and configuring caching mechanisms to improve system performance.Familiar with a variety of database systems, such as Microsoft SQL Server, and other Database Management Systems (DBMS).Must be a US Citizen.Must be able to obtain and maintain the required agency clearance (Public Trust).Preferred Qualifications:Federal or Government contracting and consulting experience is a plus.Master's degree is a plus.AWS Database certifications.Minimum AWS Certified Solutions Architect - Associate.Benefits:At Peraton, our benefits are designed to help keep you at your best beyond the work you do with us daily. We're fully committed to the growth of our employees. From fully comprehensive medical plans to tuition reimbursement, tuition assistance, and fertility treatment, we are there to support you all the way.
Peraton Overview
Peraton is a next-generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world's leading mission capability integrator and transformative enterprise IT provider, we deliver trusted, highly differentiated solutions and technologies to protect our nation and allies. Peraton operates at the critical nexus between traditional and nontraditional threats across all domains: land, sea, space, air, and cyberspace. The company serves as a valued partner to essential government agencies and supports every branch of the U.S. armed forces.
Target Salary Range
$80,000 - $128,000. This represents the typical salary range for this position based on experience and other factors.
#J-18808-Ljbffr