Database Engineer (Oracle, PL SQL)

Seeking a Database Engineer with both PL SQL and Oracle hands-on knowledge. The selected candidate will assist, define, and oversee database organization, standards, controls, procedures, and documentation.

Provides recommendations in the definition, design, and creation of a database environment. Develops applications to help solve database solutions to business problems, data architectures, database management system facilities and capabilities, and the operation and tuning of databases.

Designs, implements, and maintains databases with respect to access methods, access time, batch processes, device allocation, validation checks, organization, protection and security, documentation, and statistical methods.

Maintains database dictionaries and integrates systems through database design. Maintains and documents shell scripts and batch processes.

Lead and mentor less experience Administrators.

ESSENTIAL FUNCTIONS :

Maintains and documents shell scripts and batch processes. Develops and applies procedures for periodic database backup.

Executes processes in SQL for databases such as stored procedures / functions / packages, database job, materialized view, view, synonyms, and DB link.

Analyzes impact on database before making any changes to database.

• Leads most technical aspects of implementing project release upgrades for assigned systems which includes : properly following a project life cycle, the development of project plans, completing all appropriate documentation and notifications in order to obtain resolution within the established timeframes.
• Develops applications to help solve database solutions to business problems, data architectures, database management system facilities and capabilities, and the operation and tuning of databases.

Provides recommendations in the definition, design, and creation of a database environment.

• Develop and implement techniques to prevent system problems, troubleshoot incidents to recover services, and support root cause analysis.
• Designs, implements, and maintains databases with respect to access methods, access time, batch processes, device allocation, validation checks, organization, protection and security, documentation, and statistical methods.

Although this position is 100% remote, we are seeking candidates that reside in the EST or CST timezones only. Want to learn more?

Then you should contact Elite Technical right away for consideration!

Required Skills

• Education Level : Bachelor's Degree. In lieu of a Bachelor's degree, an additional 4 years of relevant work experience is required in addition to the required work experience.
• Experience : 8 years experience as a Database Administrator, resovling day to day database issues, debugging, route cause identification etc-
• Must have experience in both Oracle and PL SQL
• Ability to maintain, document and create shell scripts and batch processes
• Big Plus : Healthcare Insurance experience and / or Facets
• Proficient with SQL performance and tuning
• High-level of analytical and troubleshooting skills.
• Proficient in Microsoft Office applications
• Excellent communication skills both written and verbal
• Knowledge of structured query language (SQL), Advanced
25 days ago