Chickasaw Nation Industries - Annapolis, MD

posted 3 months ago

Full-time - Mid Level
Annapolis, MD
Professional, Scientific, and Technical Services

About the position

The DATABASE PROGRAMMER ANALYST II is responsible for designing, developing, and implementing database applications within an Oracle 19c environment. This role is critical for ensuring the integrity, performance, and security of the database systems that support various applications. As a federal contractor, the company adheres to strict regulations, including maintaining a drug-free workplace in compliance with the Federal Controlled Substance Act. The position requires a minimum of five years of relevant IT experience and the ability to obtain a government security clearance. In this role, the analyst will implement and administer the physical Oracle database architecture, focusing on aspects such as availability, server-side accessibility, recoverability, reliability, security, and performance. The analyst will also design, develop, and maintain processes for complex data transformations and loads into a data warehouse. Hands-on experience with PL/SQL, Java scripting, SQL*Plus, SQL*Loader, TOAD, and UNIX shell scripting is essential. The analyst will create and maintain the logical and physical data models, troubleshoot daily program issues, and assist users in accessing and manipulating data. The position requires working in an agile development environment, providing troubleshooting and debugging assistance, and adhering to product and process compliance. The analyst is expected to take responsibility for their own self-development by engaging in available training opportunities. Daily activities should be planned in accordance with company policies and supervisor instructions to maximize personal output. The job description is not exhaustive and may evolve over time, reflecting the dynamic nature of the role and the organization.

Responsibilities

  • Implements and administers physical Oracle database architecture, ensuring availability, security, and performance.
  • Designs, develops, and maintains processes for complex data transformations and loads into a data warehouse.
  • Works hands-on with PL/SQL, Java scripting, SQL*Plus, SQL*Loader, TOAD, and UNIX shell scripting.
  • Creates and maintains comprehensive database operational infrastructure, including crons, scripts, programs, and jobs.
  • Troubleshoots daily program problems to assist users in accessing and manipulating data.
  • Provides support to the team to adhere to product and process compliance.
  • Works in an agile development environment and applies associated concepts.
  • Provides troubleshooting and debugging assistance for system analysis and issue resolution.
  • Plans daily activities to maximize personal output within company policy and supervisor's instructions.

Requirements

  • Bachelor's degree and a minimum of five (5) years' relevant experience, or equivalent combination of education/experience.
  • Ability to obtain government security clearance.
  • Strong knowledge of Oracle database architecture and administration.
  • Experience with PL/SQL, Java scripting, SQL*Plus, SQL*Loader, TOAD, and UNIX shell scripting.
  • Ability to design and maintain logical and physical data models.

Nice-to-haves

  • Experience in a federal contracting environment.
  • Familiarity with agile development methodologies.
  • Knowledge of compliance regulations related to federal contracts.

Benefits

  • Training and development opportunities.
  • Health insurance coverage.
  • Flexible work hours.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service