Freelance Oracle Performance Tuning Jobs in Minnesota

Note: This position is contingent upon contract award.
Lyntris is a defense technology company that connects sensing to action across the connected battlespace. Lyntris brings together the talents of Accelint and Vitesse teams under one mission, with each contributing deep expertise within their domain. Combining differentiated hardware, software and mission expertise, Lyntris helps customers sense threats, make sense of complex conditions and act with greater speed, precision and confidence in contested environments.
Lyntris supports U.S. and allied defense organizations across every branch - including Navy, Army, Air Force, Space Force and allied partners - spanning strategic, operational and tactical missions and every domain: Space, Air, Land, Sea and Cyber. With more than 200 active defense programs, Lyntris works at every level of the mission, from national command authority to the tactical edge.
Solutions are designed by operators who understand the mission, engineered for the conditions that degrade or defeat standard systems, and built on an open, modular architecture that integrates into existing programs without requiring them to start over. Lyntris moves faster than the traditional defense cycle - with integrated design, build and test capabilities in-house - and delivers systems that sustain and endure long after initial fielding.
Job Description

• Senior Systems Engineer

• Full Time

• Onsite/Hybrid Preferred

The Senior Systems Engineer is responsible for standing up and maintaining AWS infrastructure supporting all aspects of PLM software implementations to meet customer required security, functionality, and performance requirements on all Production and non-Production environments. They are responsible for installing application software including updates and patches, performing upgrades, and applying application security updates. This resource is also responsible for performance tuning and scaling implementations into containerized solutions, automating workloads with ansible playbooks, and driving efficiency in the team through the use of emerging cloud-based technology and automation tools. This role involves supporting PLM application development projects for DoD customers. The ideal candidate has 5 to 8 years of experience in AWS infrastructure set-up and maintenance on both RedHat Linux & Windows environments. The ideal candidate must also hold relevant AWS certifications and CompTIA Security +. They must have the ability to work independently and have demonstrated ability to collaborate with cross-functional teams. This candidate must have a propensity and excitement for learning new applications in the PLM space.
Duties & Responsibilities

• Collaborate with cross-functional teams to understand business & security requirements and translate them into technical solutions.

• Plan, Implement, and Refine cloud-based infrastructure (AWS) with a mind for performance/scalability/cost savings, including evaluation of things like switching from monolithic to cluster, establishment of a load balancer, and backup/recovery plans.

• Utilize Ansible playbooks for automation, and secure applications with Public Key Infrastructure (PKI), managing TLS/SSL certificates, and enforcing secure authentication mechanisms.

• Responsible for administering RDS Oracle and RDS PostgreSQL databases, including initial data seeding, schema configurations, running scripts, query execution for troubleshooting, and optimizing database performance for application-specific needs

• Install and perform upgrades of PLM application software, applying critical patch sets, and fixing security vulnerabilities on a regular basis with all infrastructure and applications included in the technical stack.

• Oversee the rehosts/data refreshes on non-production environments as needed.

• Conduct comprehensive testing, including unit, integration, and system testing ensuring application infrastructure and performance is maintained.

• Oversee the debugging and resolution of complex application/customization defects and issues that may require performance and infrastructure related investigations and solutions.

• Develop and maintain technical documentation for all environment infrastructure.

• Establish and maintain certifications in relevant PLM, Cloud, and Security platforms/technology.

• Performs other duties as assigned.

Required Qualifications

• Currently hold Security + certification.

• Currently hold relevant AWS certifications.

• Bachelor's degree in information technology, computer science, software engineering, or other engineering discipline.

• Minimum 5 years of experience working with and setting up AWS cloud services to host enterprise applications.

• Experience managing Ansible playbooks.

• Experience with AWS licensure.

• Experience with AWS services including EC2 (compute configurations), S3 (storage management), RDS (database administration), Fleet Manager (remote access and automation), Secrets Manager (credential security), and CloudWatch (logging, monitoring, and alerting)

• Experience maintaining and optimizing performance of enterprise applications hosted in the cloud.

• Experience diagnosing networking related issues.

• Experience managing Active Directory and AppStream.

• Experience collaborating with AWS Technical Support.

• Experience setting up and working with Virtualized Environments.

• Experience with installation and maintenance of database systems (e.g. Oracle, SQL Server, PostgreSQL) and SQL scripting.

• Proficiency in Red Hat Enterprise Linux Version 8+ and Windows Server administration using CLI for OS-Level configurations including file system manipulation and storage configurations

• Excellent problem-solving skills and attention to detail.

• Strong communication and interpersonal skills.

• Strong documentation skills.

• Ability to work independently and as part of a team.

• Propensity and excitement for learning new applications in the PLM space.

• Currently holds an active U.S. national security clearance or be able to receive and maintain one.

Preferred Qualifications

• Experience writing or updating code using languages like JAVA, Python, C++, C#, etc.

• Experience with and certifications in Agile software development methodologies.

• In-depth understanding of the aerospace and defense industry.

• Knowledge of DoD software development policies, cybersecurity requirements, and RMF compliance framework.

• Experience with administration of at least 1 mainstream PLM application (PTC Windchill, Arena, FlexPLM, Siemens Teamcenter, Oracle PLM, Agile PLM, etc.)

Physical Requirements

• Prolonged periods sitting at a desk and working on a computer.
• Must be able to lift up to 15 pounds at times.
• This position is hybrid located in St. Paul, MN.
• Fully remote candidates may be considered with increased expectation for travel.
• This position may require the ability to travel up to 10%.

Work Environment
Hybrid work arrangements are strongly preferred for this role to support regular in-person collaboration with program and project teams. Fully remote candidates may still be considered; however, remote employees should expect increased travel requirements to support onsite team engagement. Employees may telework on designated days or as needed with supervisor approval, provided they maintain established communication expectations and effectively meet job responsibilities. Travel may be required 1-2 times per month to customer sites, subcontractor locations, and other company offices.
Clearance Requirements
Some positions will require access to U.S. National Security information. Positions that require this access will be required to receive and maintain a U.S. government personnel security clearance (PCL). In order to qualify for this position, the candidate must be a US Citizen and either currently possess this National Security eligibility or be able to complete the investigation application process with a favorable determination and maintain that eligibility throughout their employment.
Pay Scales & Benefits
The listed pay scale reflects the broad, minimum to maximum, pay scale for this position for the location for which it has been posted and is not a guarantee of compensation or salary. Other compensation considerations may include, but are not limited to, job responsibilities, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, or other applicable factors.
Benefits include...
Paid Time Off
Paid Company Holidays
Medical, Dental & Vision Insurance
Optional HSA and FSA
Base and Voluntary Life Insurance
Short Term & Long-Term Disability Insurance
401k Matching
Employee Assistance Program
The pay range for this role is:
130,990 - 165,673 USD per year (Remote (United States))