Leidos Holding
PostgreSQL Aurora Developer and Administrator
Leidos Holding, ASHBURN, VA
Description
The National Security Sector within Leidos is seeking an Oracle PostgreSQL Aurora Database Administrator with strong experience in development and database migrations to support the Passenger Systems Program Directorate (PSPD) within Customs and Border Protection (CBP). PSPD supports the Department of Homeland Security (DHS) and CBP critical missions, specifically screening and processing travelers at the ports of entry (POEs) into the United States. The ideal candidate will have deep understanding of Oracle and Postgres databases as well as expertise in designing implementing and managing robust database systems. This role requires proficiency in database migration strategies, performance tuning and problem solving in high demand environments.
**This position REQUIRES onsite support in Ashburn, VA, 2 times a month**
Primary Responsibilities:
Basic Qualifications:
Preferred Qualifications:
Pay Range: Pay Range $104,650.00 - $189,175.00
The Leidos pay 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.
About Leidos Leidos is a Fortune 500® innovation company rapidly addressing the world's most vexing challenges in national security and health. The company's global workforce of 47,000 collaborates to create smarter technology solutions for customers in heavily regulated industries. Headquartered in Reston, Virginia, Leidos reported annual revenues of approximately $15.4 billion for the fiscal year ended December 29, 2023. For more information, visit www.Leidos.com .
Pay and Benefits Pay and benefits are fundamental to any career decision. That's why we craft compensation packages that reflect the importance of the work we do for our customers. Employment benefits include competitive compensation, Health and Wellness programs, Income Protection, Paid Leave and Retirement. More details are available here .
Securing Your Data Beware of fake employment opportunities using Leidos' name. Leidos will never ask you to provide payment-related information during any part of the employment application process (i.e., ask you for money), nor will Leidos ever advance money as part of the hiring process (i.e., send you a check or money order before doing any work). Further, Leidos will only communicate with you through emails that are generated by the Leidos.com automated system - never from free commercial services (e.g., Gmail, Yahoo, Hotmail) or via WhatsApp, Telegram, etc. If you received an email purporting to be from Leidos that asks for payment-related information or any other person a l information (e.g., about you or your previous employer), and you are concerned about its legitimacy, please make us aware immediately by emailing us at [email protected] .
If you believe you are the victim of a scam, contact your local law enforcement and report the incident to the U.S. Federal Trade Commission .
Commitment to Diversity All qualified applicants will receive consideration for employment without regard to sex, race, ethnicity, age, national origin, citizenship, religion, physical or mental disability, medical condition, genetic information, pregnancy, family structure, marital status, ancestry, domestic partner status, sexual orientation, gender identity or expression, veteran or military status, or any other basis prohibited by law. Leidos will also consider for employment qualified applicants with criminal histories consistent with relevant laws.
The National Security Sector within Leidos is seeking an Oracle PostgreSQL Aurora Database Administrator with strong experience in development and database migrations to support the Passenger Systems Program Directorate (PSPD) within Customs and Border Protection (CBP). PSPD supports the Department of Homeland Security (DHS) and CBP critical missions, specifically screening and processing travelers at the ports of entry (POEs) into the United States. The ideal candidate will have deep understanding of Oracle and Postgres databases as well as expertise in designing implementing and managing robust database systems. This role requires proficiency in database migration strategies, performance tuning and problem solving in high demand environments.
**This position REQUIRES onsite support in Ashburn, VA, 2 times a month**
Primary Responsibilities:
- Design, develop and maintain database solutions in Oracle and PostgreSQL.
- Plan and execute database migrations from Oracle to PostgreSQL, ensuring data integrity and minimum down time
- Develop stored procedures, functions, triggers to meet application requirements
- Analyze existing Oracle structures, stored procedures, and application code for migration to Postgres
- Convert Oracle PL/SQL scripts, triggers, packages etc. to Postgres PL/PGSQL equivalents
- Experience with tools like AWS DMS, SCT and CDC process
- Validate functions, procedures converted correctly to Postgres and behaves as expected by writing test cases and using unit testing frame works
- Trouble shoot and resolve database issues in development, testing and production environments. Create and maintain comprehensive documentation for database design, migration, processes and administration tasks.
Basic Qualifications:
- BS/BA degree with a minimum of 8+ years of relevant experience or 6+ years of relevant experience with Masters Degree; OR 4 years of directly related experience in lieu of degree
- Must be a US Citizen
- Must be able to maintain and obtain a CBP Background Investigation prior to start
- 8 years expertise in Oracle Database and PostgreSQL development and administration.
- Proven experience in database migrations (data and PL/SQL code) from Oracle to PostgreSQL
- Proficiency in SQL, PL/SQL and PL/PGSQL
- Hands on experience with Postgres tools PGADMIN, PSQL, QPM and other important Postgres extensions
- Knowledge of database tuning, indexing strategies and query optimization
- 2+ years of experience with cloud database solutions (AWS, Aurora etc.)
Preferred Qualifications:
- Certification in Oracle/AWS
- Knowledge of application development languages like python and Shell scripting
- Strong problem-solving skills and the ability to work collaboratively in a team environment.
- Top Secret or Full CBP Background Investigation
Pay Range: Pay Range $104,650.00 - $189,175.00
The Leidos pay 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.
About Leidos Leidos is a Fortune 500® innovation company rapidly addressing the world's most vexing challenges in national security and health. The company's global workforce of 47,000 collaborates to create smarter technology solutions for customers in heavily regulated industries. Headquartered in Reston, Virginia, Leidos reported annual revenues of approximately $15.4 billion for the fiscal year ended December 29, 2023. For more information, visit www.Leidos.com .
Pay and Benefits Pay and benefits are fundamental to any career decision. That's why we craft compensation packages that reflect the importance of the work we do for our customers. Employment benefits include competitive compensation, Health and Wellness programs, Income Protection, Paid Leave and Retirement. More details are available here .
Securing Your Data Beware of fake employment opportunities using Leidos' name. Leidos will never ask you to provide payment-related information during any part of the employment application process (i.e., ask you for money), nor will Leidos ever advance money as part of the hiring process (i.e., send you a check or money order before doing any work). Further, Leidos will only communicate with you through emails that are generated by the Leidos.com automated system - never from free commercial services (e.g., Gmail, Yahoo, Hotmail) or via WhatsApp, Telegram, etc. If you received an email purporting to be from Leidos that asks for payment-related information or any other person a l information (e.g., about you or your previous employer), and you are concerned about its legitimacy, please make us aware immediately by emailing us at [email protected] .
If you believe you are the victim of a scam, contact your local law enforcement and report the incident to the U.S. Federal Trade Commission .
Commitment to Diversity All qualified applicants will receive consideration for employment without regard to sex, race, ethnicity, age, national origin, citizenship, religion, physical or mental disability, medical condition, genetic information, pregnancy, family structure, marital status, ancestry, domestic partner status, sexual orientation, gender identity or expression, veteran or military status, or any other basis prohibited by law. Leidos will also consider for employment qualified applicants with criminal histories consistent with relevant laws.