Oracle Database Administrator

3 weeks 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

by Jobble



  • New York, United States Technology Ventures Full time

    Must Have:10 + with oracle,3 with Aurora,5+ Shell scripts OR Ansible, 2+ Cloud Development Database Services seeking Senior Database Engineer who is responsible for database administration( cloud and on -prem) in a fast-paced operations environment supporting 24x7 business critical applications using analytical and transactional databases having Oracle...


  • 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...


  • 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...


  • New York, United States Pyramid Technology Solutions Full time

    Job Role: Oracle ERP Database Systems Administrator Location: Downey, CA (90242) - Hybrid Duration: 12 Months Contract Position Description: A Technical Architect will serve as the manager of complex technology implementations, with an eye toward constant reengineering and refactoring to ensure the simplest and most elegant system possible to accomplish the...


  • New York, United States Macpower Digital Assets Edge Private Limited (MDA Edge) Full time

    Oracle 12C/19C OCP certification. Hands on experience on Oracle 12C/19C RAC configuration and setup. Performance tuning of the database. Hands-on experience on UNIX/Linux/Ubuntu/RHEL Environments, Golden Gate, Oracle Active Data Guard, RAC (Real Application Cluster). Experience in Backup/Recovery and Configuration Management. Experience in...


  • New York, United States NYC IT Inc Full time

    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 higher on a Redhat Linux environment. Experience...


  • 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...


  • 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...


  • 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...


  • New York, United States IT Trailblazers, LLC Full time

    Job Description: Minimum of 15 years of Oracle E-Business suite experience on upgrades/cloud migrations/administration.Minimum 15 years of experience in Oracle Database Administration/upgrades/cloud migrations and performance tuning. Minimum 10 years of experience on Discoverer/Apex/Hyperion. Minimum 10 years of WebLogic Application server administration...


  • New York, United States Sterling 5 Full time

    OAS Administrator Bay area, CA (Hybrid) Long term contract Client: Stanford University Job Description for OAS Administrator Core Duties: • Oversee and support a complex WebLogic and Oracle Fusion Middleware environments, encompassing installation and configuration. • Hands on experience or knowledge in administering Oracle Analytics Service...


  • New York, United States Oracle Full time

    The Oracle Healthcare platform and infrastructure team can provide customers with the opportunity to build and operate a suite of massively scaled, integrated cloud services in a broadly distributed, multi-tenant cloud environment. OHAI is committed to providing the best cloud products that meet the needs of our customers, who are tackling some of the...

  • Database Engineer

    3 weeks ago


    New York, United States Abbtech Professional Resources Full time

    This program requires US Citizenship Based in New York City – 100% REMOTE Position Description: A successful candidate will serve as a database Engineer reporting to the Infrastructure Management division. This position is responsible for delivering and overseeing the Agency’s multi-tenant databases and service offerings as part of the Foundational...


  • New York, United States Canon Business Process Services Full time

    Canon Business Process Services currently has an opening for a HR Database Administrator! This role will be based at our Corporate Office (261 Madison Ave) in New York City. You will be required to be in the office on Tuesdays and Wednesdays. Canon Business Process Services (“Canon”) provides on-site services for hundreds of clients across the United...

  • Database Engineer

    3 weeks ago


    New York, United States Tri-Force Consulting Services, Inc. Full time

    Job DescriptionJob DescriptionTitle: Database Engineer Duration: 12 MonthsClient: Department of Information Technology and Telecommunication - New York CityLocation: New York, NYNote: This position is a remote position."The applicant is the center of our universe."Job Description:Install, configure, customize, create, implement, and support Oracle databases...

  • Senior Oracle DBA

    6 days ago


    New York, United States Seneca Full time

    A leading utility provider located in New York, NY is looking for a Senior Oracle DBA (OMS/GIS) for a 12+ month contract. This is a hybrid role in New York City. Pay Rate Range: $65.00 - $75.00 Required Skills & Experience: Experience managing Geographic Information Systems (ArcGis, MapInfo, Oracle Spatial) Proficiency in SAP, Oracle Applications,...

  • Senior Oracle DBA

    14 hours ago


    New York, United States Seneca Resources, LLC Full time

    A leading utility provider located in New York, NY is looking for a Senior Oracle DBA (OMS/GIS) for a 12+ month contract. This is a hybrid role in New York City. Pay Rate Range: $65.00 - $75.00 Required Skills & Experience: Experience managing Geographic Information Systems (ArcGis, MapInfo, Oracle Spatial)Proficiency in SAP, Oracle Applications, Oracle...


  • New York, United States Tech Skills Staffing Full time

    Job DescriptionJob DescriptionThis role is open to C2C candidates only. Key Responsibilities:Database Installation and Configuration:Install, configure, and customize Oracle databases in Non-RAC and RAC environments.Implement Grid Infrastructure release 19c on Unix/Linux platforms and manage Oracle Automatic Storage Management (ASM) cluster filesystems.Add...

  • Oracle DBA

    6 days ago


    New York, United States The Dignify Solutions LLC Full time

    Minimum 10+ Years of experience in Database Administration. Experience with AWS architecture. Experience in designing and supporting Database as a Service (DBaaS) platform . Understand end-to-end configuration, technical dependencies, and overall behavioral characteristics of DBaaS. Experience in one or more of the following: Python, Ruby, Perl, Shell, or...


  • Albuquerque, New Mexico, United States Encantado Technical Solutions Full time

    Overview: Encantado Technical Solutions is seeking a Database Administrator to support a major national laboratory. You will provide database administration activities supporting a mix of Relational Database Management Systems for very large datasets and real time data processing.   Candidate must reside in the Albuquerque as the work is completed on...