Application Database Administrator More Details

Information Technology Strategies, LLC; United States; Remote; USD 80,000 - 110,000; Full time

Job summary

An established industry player is seeking a skilled Application Database Administrator to enhance and support database configurations for critical government projects. In this role, you will work with Oracle EBS, manage database schemas, and collaborate with infrastructure teams to optimize database performance. Ideal candidates will have extensive experience in database administration and a strong understanding of various programming languages. This position offers a unique opportunity to contribute to vital government initiatives while enjoying a supportive work environment with comprehensive benefits. If you're passionate about technology and eager to make a difference, this role is for you.

Benefits

Medical/Vision options

Dental and Orthodontia plan

Vision Materials plan

Paid Life Insurance

401K Retirement Program

Paid Vacation

Paid Holidays

Sick Leave

Floating Holidays

Bereavement Leave

Qualifications

• 5+ years of experience with database query languages.
• 3+ years of hands-on experience in database schema design.
• Experience with cloud/infrastructure integration.

Responsibilities

• Enhance and support Oracle EBS database configurations.
• Administer database schemas and ensure data accuracy.
• Provide post-production support and troubleshoot issues.

Skills

Oracle

PL/SQL

SQL Server

Database Schema Design

Shell Scripting

Python

Java

PowerShell

JavaScript

Database Optimization

Education

Bachelor's Degree in Computer Science or related field

Certifications (e.g., Oracle Certified Associate)

Tools

Oracle Enterprise Manager

UNIX/Linux

Windows Server

Job description

Information Technology Strategies, Inc. is a government IT solutions provider servicing commercial and government initiative in various parts of the United States. We are currently seeking an Application Database Administrator to work for our company.

Summary:

• Client Agency is Defense Logistics Agency.
• Must be eligible to obtain a U.S. Government SECRET / TOP SECRET Clearance. (Basic Federal Clearance requirements are U.S. Citizenship, clear criminal history check, no recent or pending bankruptcies)
• Will be responsible for the enhancement of configuration and providing post-production support for our Oracle EBS R12.2.x ERP project.
  • Will be involved in all activities related to the administration of database schemas and their objects. This includes:
  • Enhancing and supporting the configuration of Oracle EBS databases.
  • Working with infrastructure database administrators to designing, implementing, deploying, and maintaining the Oracle database infrastructure in a client/server environment, data center, and Cloud environment.
  • Utilizing Oracle Enterprise Manager (OEM) and associated tools to manage the database environment including disaster recovery.
  • Providing comprehensive post-production support for Oracle EBS database environments, including troubleshooting and issue resolution.
  • Administering database schemas and their associated objects.
  • Projecting long-range requirements for database schema administration and design in collaboration with Infrastructure DBAs.
  • Designing, creating, and maintaining database schemas within a client/server environment, adhering to best practices.
  • Conducting rigorous quality control and auditing of database schemas to ensure data accuracy, appropriate data use, and proper permissions.
  • Advising users on access protocols for various client/server databases (e.g., SQL Net).
  • Designing, implementing, and maintaining complex database schema objects, considering user requirements, access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods.
  • Working with database administrators for database optimization efforts, upgrading, updating, patching, and other maintenance efforts.
  • Supporting query optimization and other optimization techniques.
  • Applying comprehensive knowledge of database technologies, development methodologies, and front-end programming languages such as Java, JavaScript, HTML, CSS, and potentially PL/SQL for specific UI elements, as well as Oracle Forms and Oracle APEX.
  • Performing database programming tasks and providing support for systems design initiatives.

Requirements:

• Must be eligible to obtain a U.S. Government SECRET / TOP SECRET Clearance. (Basic Federal Clearance requirements are U.S. Citizenship, clear criminal history check, no recent or pending bankruptcies)
• Must have 5+ years of progressive experience of database query languages such as Oracle, PL SQL, SQL Server, and MS Access.
• Must have 3+ years of hands-on experience and expertise in Database Schema design, administration and management.
• Must have experience working on various operating systems such as UNIX/Linux and Windows Server, and be proficient in programming languages such as Shell scripting, Python, Java, PowerShell, or JavaScript.
• Experience being responsible for administering, operating, maintaining, and securing a large-scale computer database in a large organization for at least two projects.
• Previous experience withERP or large-scale government systems with at least two projects involving database operations and security.
• Experience with performance tuning, system patching, and cloud/infrastructure integration.
• The ability to troubleshoot and optimize complex database environments.
• Excellent oral and written communication skills.

Preferences:

• Currently one of the following certifications: IAT-II security certification: CCNA Security, CySA+, GICSP, GSEC, Security+ CE, CND, SSCP, CASP+ CE, CCNP Security, CISA, CISSP, CISSA, GCED, GCIH, or CCSP
• DFARS 252.239-7001 Information Assurance Contractor Training and Certification.
• Currently hold or be willing to obtain one of the following certifications: Oracle Cloud Infrastructure (OCI) Foundations 2020 Certified Associate, Oracle Certified Associate (OCA), Oracle WebLogic Server 12c Administrator, Oracle Java SE 8 Programmer I, Oracle Enterprise Manager 12c Essentials (OEM 12c), Oracle Business Intelligence Publisher (BIP) 12c R1: Fundamentals, Oracle Planning 202x Certified Implementation Specialist (CIS), and Oracle Identity Governance 12c: Essentials.

Work With Us

IT-Strat is a technology consulting company that holds various contract vehicles including best in class vehicles. IT-Strat has supported multiple clients including the Department of Homeland Security (DHS), Customs and Border Protection (CBP) and Immigration and Customs Enforcement (ICE via both prime and meaningful subcontracts). Additionally, IT-Strat has prime contracts with Defense Information Systems Agency (DISA), Defense Logistics Agency (DLA) and many others. We maintain relationships with multiple large businesses.

IT-Strat was established in 2002. We are a certified Woman Owned Small Business. IT-Strat also successfully graduated as an SBA 8(A) company. It was an 8(a) company from 2008 through 2017 and currently still has 8(a) contract vehicles.

Benefits We Offer:

• Four Medical/Vision options including an HSA plan
• Dental and Orthodontia plan
• Vision Materials plan
• Paid Life, Short-Term Disability, and Long-Term Disability
• 401K Retirement Program with company contribution
• Paid Vacation, Holidays, Sick Leave, Floating Holidays, Bereavement Leave
• Semi-monthly pay cycle

Information Technology Strategies (“IT-Strat”) is an Equal Employment Opportunity employer, and it is our policy to consider applicants for employment without regard to sex, race, color, creed, religion, national origin, sexual orientation, marital status, age, disability, veteran status, alienage, ancestry, and any other factors prohibited by law. Employment selections are based on company and client requirements and the qualifications and skills of the candidate. IT-Strat is committed to actively capitalizing on the diversity of skills, talents, and perspectives of our employees.