Description
The Leidos Spatial Solutions team has an opening for an experienced Database Administrator (DBA) to manage aspects of Oracle and Postgres databases including installation, configuration, design and data migration within Dissemination Systems. This DBA position is tailored towards a Database admin.
Primary Responsibilities:
- Supporting Oracle database migration from on premise to AWS Cloud leveraging RDS managed service.
- Supporting the development of data migration strategy and its implementation.
- Modifying functions with Oracle to produce additional data outputs.
- Modernization of databases to utilize and implement Spatial functionality.
- Supporting the analysis and evaluation of system improvements, optimization, development, and/or maintenance efforts.
- Supporting the development of long term and short-term requirements for database administration and design.
- Documentation of database procedures and best practices.
- Manage and maintain Oracle databases including migration of version updates.
- Maintain and optimize spatial data in Oracle.
- Potential to convert Oracle database to PostgreSQL.
Want more jobs like this?
Get Data and Analytics jobs in Fenton, MO delivered to your inbox every week.
Basic Qualifications:
- Experience with cloud-first, AWS native architectures and RDS managed service in particular
- Prior experience using, optimizing and upgrading Oracle SQL/PLSQL, and SQL in general.
- Understanding of databases, primarily Oracle and/or other relational and non-relational/NoSQL databases such as PostgreSQL and MongoDB.
- Bachelor's Degree in a related discipline w/ 4-6 years of relevant experience or Master's Degree in a related discipline w/ 2 years. Additional experience may be considered in lieu of degree.
Preferred Qualifications:
- Knowledge in complex application integration
- AWS certifications, like associates and developer
- CompTIA Security+ or equivalent certification
- Experience in either software development projects or software integration projects in a service-oriented environment (Cloud, SOA, Web-Services) or virtualization environment.
- Experience as a Database Administrator to include tasks such as data migration, data replication, user administration, backup and recovery, performance tuning, issue investigation, issue resolution, and general administration.
- Prior experience with Postgres database modernization/maintenance/sustainment.
- Prior experience with AWS cloud formation templates
- Prior experience with configuration management tools and processes.
- Prior experience with Oracle Spatial or PostGIS.
- Prior experience with JavaScript, Perl, and/or Python scripting.
- Team Collaboration tools (Jira, Confluence)
- Active TS/SCI with Polygraph
Original Posting Date:
2024-07-23
While subject to change based on business needs, Leidos reasonably anticipates that this job requisition will remain open for at least 3 days with an anticipated close date of no earlier than 3 days after the original posting date as listed above.
Pay Range:
Pay Range $81,250.00 - $146,875.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.