USA Jobs, Careers and Recuitements
Job Target Job Search

Contact Information

Contact Name: DAVE

Job Details: Oracle Database Administrator Date: Aug 26 2019

Job Reference: 3628
Job Category: IT Jobs [ View All IT Jobs Jobs ]
Company Type Recruiter
Employment type: Full Time, Contract
Degree: High School
Experience: 3 years
Location: Albany, New York, 12202
Job Skills: Oracle Database Administrator
Share Job with Others

Job Tools

Job Description

• Provide overall database architecture, design, installation, configuring, technical support and maintenance of Oracle Databases in a Storage Area Network (SAN) and Cluster Server environment.
• Performing installation, configuration, customization, creation, implementation and support.
• Setup/ administer Oracle database security environment.
• Carry out DB Performance Tuning, troubleshoot DB problems and work with Oracle support on problems and questions.
• Schedule RMAN (backup/ recovery).
• Install and configure, customize Oracle server and clients.
• Schedule, install and configure Oracle upgrades.
• Monitors, performs and troubleshoots ETL (Extract, Transform and Load) jobs to ensure data integrity utilizing FTP (File Transfer Protocol), Command Scripts, Task Scheduler, DTS (Data Transformation Services), and SSIS (SQL Server Integration Services).
• Install, configure, customize Oracle related system level software.
• Design, develop and create all database file system layouts and Oracle databases.
• Monitor software notifications and updates.
• Manage distributed databases and configure client/ server and Web-based environments.
• Provide technical assistance and troubleshooting support to developers.
• Review database design specifications and application coding routines to ensure adherence to best practices for database usage.
• Ensure database performance is maintained at optimal levels and can support defined business requirements.
• Create/ maintain referential integrity relationships/ constraints.
• Provide problem diagnosis and resolution and schedule database backups.
• Diagnose and resolve backup failures.
• Configure, analyze application SQL to do SQL Tuning for performance improvement opportunities.
• Develop/ maintain Oracle database operational procedures.
• These activities will encompass all project life cycle phases including production support (24/7) and documentation of all tasks in accordance with Department of Education standards.
• The servers and databases support applications that display Special Education student and staff data. The applications involved are in Visual Studio .Net with Oracle Server for data management and Active Directory for Identity management.
• 84+ Months of Experience in Database Management performing installation, configuration, customization, implementation and support of Oracle Database on Unix/ Linux.
• 84+ Months of Experience with Oracle RMAN, Data Guard, Oracle Advanced Security Option and Label Security.
• 84+ Months of Experience in managing and administering Oracle database in a RAC and stand-alone environment.
• 84+ Months of Experience in Managing distributed databases, ESB and SOA.
• 84+Months of experience and expertise in monitoring and troubleshooting ETL, DTS, SSIS and Data warehouse
• 84+ Months of experience configuring Oracle RAC Cluster, ASM and GRID Infrastructure on Enterprise Unix/ Linux.
• 84+ Months of hands-on experience in Oracle Performance Tuning, Query Optimization and Production support.
• 84+ Months of hands-on experience writing complex Stored Procedure, Functions in PL/T-SQL, Shell Scripts.
• Bachelor’s Degree from a recognized university.
• Oracle IT Professional Certification.

Copyright © 2019 Jobxoom All rights reserved. Use of this site is subject to certain Terms and Conditions.