Database Engineer Oracle PL SQL || Should be in EST or CST at Oracle, Arizona, USA |
Email: [email protected] |
From: Awkash Kumar, Largeton INC [email protected] Reply to: [email protected] JD :: Visa- USC/GC 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 experienced 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. 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, resolving 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 Keywords: database green card procedural language Database Engineer Oracle PL SQL || Should be in EST or CST [email protected] |
[email protected] View all |
Mon May 06 23:26:00 UTC 2024 |