Oracle Database Administrator

Found in: Appcast US C2 - 1 week ago

New York, United States MDS (Micro-Data Systems) Full time

Oracle Database Administrator

Duration: Contract Role with Potential to Hire Permanently

Location: New York, NY 10012 - Hybrid 2-3 Days per week Onsite


Responsibilities


Database Installation and Configuration

  • Install, configure, and upgrade Oracle database software
  • Create and configure databases


Database Maintenance

  • Perform routine maintenance tasks such as space management, data file management, and statistics gathering
  • Monitor and manage database storage, including data files, tablespaces, and redo logs
  • Review alert log and standby logs.


Patch and Upgrades

  • Apply patches, and updates, to the Oracle database software to address security vulnerabilities and compliance
  • Plan and execute database upgrades to newer versions while minimizing downtime


Backup and Recovery

  • Develop and implement backup and recovery strategies using Oracle Recovery Manager (RMAN), Data Pump and Oracle Flashback
  • Perform regular backups and test recovery procedures to ensure data integrity and minimize downtime


High Availability and Disaster Recovery

  • Implement high availability solutions such as Data Guard, data guard broker and test failover.
  • Configure standby databases for disaster recovery and failover scenarios


Performance Monitoring and Tuning

  • Monitor database performance metrics using tools like Oracle Enterprise Manager (OEM), and AWR reports and ASH reports.
  • Identify and resolve performance bottlenecks through SQL tuning, index optimization, and memory management


Troubleshooting and Problem Resolution

  • Diagnose and resolve database-related issues, including errors, performance problems, and data corruption
  • Utilize diagnostic tools like Oracle Trace, explain plan, and TKPROF for troubleshooting
  • Use MyOracleSupport (MOS) to diagnose errors and create tickets.


Security Management

  • Manage database security, including user access controls, roles, and privileges
  • Implement encryption, auditing, and compliance controls to protect sensitive data


Capacity Planning

  • Monitor database growth trends and plan for future capacity requirements
  • Forecast resource needs and recommend hardware upgrades or scaling options as needed


Database Design, Development, and SDLC

  • Design and implement database schemas, tablespaces, tables, indexes, constraints, and data files
  • Optimize database design for performance, scalability, and data integrity
  • Create Views, Stored Procedures, Functions, Materialized Views, External Tables and Packages
  • Moving Data and Database Objects across environments
  • Create releases for application fixes


Documentation and Reporting

  • Maintain accurate documentation of database configurations, procedures, and operational processes.
  • Generate reports on database performance and health as required.


Communication and Collaboration

  • Strong communication skills and ability to work collaboratively with other IT teams, developers, and stakeholders


Skills and Tools


Required

  • Oracle Enterprise Manager (OEM)
  • Oracle SQL Developer / TOAD
  • Oracle Recovery Manager (RMAN)
  • Oracle Data Pump
  • Oracle Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM)
  • Oracle Data Guard
  • Unix and Shell Scripting
  • Monitoring and Alerting Tools (OEM + Shell Scripts)
  • SQL*Loader
  • PL/SQL


Good To Have

  • Oracle DBA Certifications
  • References
  • AwsRDS
  • Oracle Real Application Clusters (RAC) for High Availability
  • Oracle Grid Infrastructure (This is RAC + ASM (Automatic Storage Management)
  • Oracle GoldenGate

  • Oracle Database Administrator

    4 days ago

    New York, United States Mds (micro-data Systems) Full time

    Oracle Database Administrator Duration: Contract Role with Potential to Hire Permanently Location: New York, NY 10012 - Hybrid 2-3 Days per week Onsite Responsibilities Database Installation and Configuration Install, configure, and upgrade Oracle database software Create and configure databases Database Maintenance Perform routine maintenance tasks...

  • Oracle Database Administrator

    1 week ago

    New York, United States MDS (Micro-Data Systems) Full time

    Oracle Database Administrator Duration: Contract Role with Potential to Hire PermanentlyLocation: New York, NY 10012 - Hybrid 2-3 Days per week OnsiteResponsibilities Database Installation and Configuration Install, configure, and upgrade Oracle database softwareCreate and configure databasesDatabase Maintenance Perform routine maintenance tasks such as...

  • Senior Oracle Database Administrator

    7 days ago

    New York, United States CareerBuilder Full time

    Job Title: Senior Oracle Database Administrator Duration: 06 Months (Contract to Hire) Location: McLean, VA (Hybrid) Looking for an Oracle Database Administrator (Minimum 10+ years) and has good experience in Aurora Postgres platforms. Need someone with good experience in Cloud (AWS) mainly in CFT/Lambda functions. Need someone with hands-on automation...

  • System Database Administrator-Oracle DB

    Found in: beBee S US - 2 weeks ago

    New York, United States Atechstar Full time

    JOB DESCRIPTIONYour Role and ResponsibilitiesAdminister maintain tune and troubleshoot Oracle databases to provide high availability and reliability to the databases and applications running on them. Administer databases running on RAC in Exadata environments. Work with application teams product teams and onshore DBA team to design provision maintain...

  • System Database Administrator-Oracle DB

    Found in: beBee jobs US - 3 weeks ago

    New York, New York, United States Atechstar Full time

    JOB DESCRIPTIONYour Role and ResponsibilitiesAdminister maintain tune and troubleshoot Oracle databases to provide high availability and reliability to the databases and applications running on them. Administer databases running on RAC in Exadata environments. Work with application teams product teams and onshore DBA team to design provision maintain and...

  • Oracle Database Engineer

    7 days ago

    New York, United States NYC IT Inc Full time

    Job DescriptionJob Description MANDATORY SKILLS/EXPERIENCE • Minimum 12 years of hands- o n experience in database engineering. • Ability to work independently. • Experience in implementing/managing Oracle Databases in a RAC environment with at least 2 years of production support. • Experience in Implementing Grid Infrastructure release 19 or...

  • Oracle Database Engineer

    2 days ago

    New York, United States NYC IT Inc Full time

    Job DescriptionJob Description MANDATORY SKILLS/EXPERIENCE • Minimum 12 years of hands- o n experience in database engineering. • Ability to work independently. • Experience in implementing/managing Oracle Databases in a RAC environment with at least 2 years of production support. • Experience in Implementing Grid Infrastructure release 19 or...

  • Oracle Database Engineer

    6 days ago

    New York, United States NYC IT Inc Full time

    Job DescriptionJob DescriptionMANDATORY SKILLS/EXPERIENCE Minimum 12 years of hands- o n experience in database engineering. Ability to work independently. Experience in implementing/managing Oracle Databases in a RAC environment with at least 2 years of production support. Experience in Implementing Grid Infrastructure release 19 or higher on a Redhat Linux...

  • Oracle Database Engineer

    2 days ago

    New York, United States NYC IT Inc Full time

    Job DescriptionJob DescriptionMANDATORY SKILLS/EXPERIENCE Minimum 12 years of hands- o n experience in database engineering. Ability to work independently. Experience in implementing/managing Oracle Databases in a RAC environment with at least 2 years of production support. Experience in Implementing Grid Infrastructure release 19 or higher on a Redhat Linux...

  • Oracle Database Developer

    Found in: Appcast US C2 - 5 days ago

    New York, United States Baanyan Software Services, Inc. Full time

    Minimum 12 years of hands- o n experience in database engineering.Ability to work independently.Experience in implementing/managing Oracle Databases in a RAC environment with at least 2 years of production support.Experience in Implementing Grid Infrastructure release 19 or higher on a Redhat Linux environment.Experience implementing ASM cluster Filesystem...

  • Oracle Database Developer

    4 days ago

    New York, United States Baanyan Software Services, Inc. Full time

    Minimum 12 years of hands- o n experience in database engineering.Ability to work independently.Experience in implementing/managing Oracle Databases in a RAC environment with at least 2 years of production support.Experience in Implementing Grid Infrastructure release 19 or higher on a Redhat Linux environment.Experience implementing ASM cluster Filesystem...

  • Oracle Database Developer

    Found in: Appcast Linkedin GBL C2 - 5 days ago

    New York, United States Baanyan Software Services, Inc. Full time

    Minimum 12 years of hands- o n experience in database engineering.Ability to work independently.Experience in implementing/managing Oracle Databases in a RAC environment with at least 2 years of production support.Experience in Implementing Grid Infrastructure release 19 or higher on a Redhat Linux environment.Experience implementing ASM cluster Filesystem...

  • Database Administrators

    2 days ago

    New York, United States Priority Groups Full time

    Job DescriptionJob DescriptionOverview:ESO Consultants is currently seeking Database Administrators to join our team. This role entails various responsibilities including database technical design, storage configuration, backup and recovery, troubleshooting, and performance monitoring. Additionally, Database Administrators will be involved in the development...

  • Database Administrators

    2 weeks ago

    New York, United States Priority Groups Full time

    Job DescriptionJob DescriptionOverview:ESO Consultants is currently seeking Database Administrators to join our team. This role entails various responsibilities including database technical design, storage configuration, backup and recovery, troubleshooting, and performance monitoring. Additionally, Database Administrators will be involved in the development...

  • Oracle DB Administrator

    Found in: Resume Library US A2 - 1 week ago

    Rochester, New York, United States LaBella Associates Full time

    LaBella Associates was established in 1978 and is a certified Great Place To Work. We are headquartered in Rochester, NY with offices across New York, Ohio, Pennsylvania, Connecticut, Maine, Virginia, North and South Carolina, and Madrid, Spain. LaBella is a multi-disciplined architectural and engineering firm dedicated to client satisfaction through...

  • Oracle DB Administrator

    Found in: Resume Library US A2 - 1 week ago

    Vestal, New York, United States LaBella Associates Full time

    LaBella Associates was established in 1978 and is a certified Great Place To Work. We are headquartered in Rochester, NY with offices across New York, Ohio, Pennsylvania, Connecticut, Maine, Virginia, North and South Carolina, and Madrid, Spain. LaBella is a multi-disciplined architectural and engineering firm dedicated to client satisfaction through...

  • Database Administrators

    20 hours ago

    New York, United States RightTalents LLC Full time

    Title: Database Administrators Location: New York, NY (Onsite) Duration: 12 Months Working Hours Per Day: 7.5hrs Note: Looking for candidates to work on our W2 Scroll down for a complete overview of what this job will require Are you the right candidate for this opportunity JOB SPECIFICATIONS: Database technical design, storage configuration, space...

  • Database Administrators

    Found in: Appcast Linkedin GBL C2 - 2 weeks ago

    New York, United States RightTalents LLC Full time

    Title: Database AdministratorsLocation: New York, NY (Onsite)Duration: 12 MonthsWorking Hours Per Day: 7.5hrsNote: Looking for candidates to work on our W2JOB SPECIFICATIONS:Database technical design, storage configuration, space management, backup and recovery, disaster recovery, troubleshooting.Development and maintenance of integrated databases and...

  • Database Administrators

    Found in: Appcast US C2 - 2 weeks ago

    New York, United States RightTalents LLC Full time

    Title: Database AdministratorsLocation: New York, NY (Onsite)Duration: 12 MonthsWorking Hours Per Day: 7.5hrsNote: Looking for candidates to work on our W2JOB SPECIFICATIONS:Database technical design, storage configuration, space management, backup and recovery, disaster recovery, troubleshooting.Development and maintenance of integrated databases and...

  • Oracle DBA

    2 days ago

    New York, United States Software People, Inc. Full time

    Job DescriptionJob DescriptionPhone/Skype Hire. REMOTELocation: REMOTEDuration: 12+ months (High Possibility of Further Extensions)ResponsibilitiesInstall, configure, customize, create, implement, and support Oracle databases in Non-RAC and RAC environments, and software and related tools/products for the database systems at OTI.Implement Grid Infrastructure...