Jobs
>
New York City

    Senior Oracle DBA - New York, United States - Comprehensive Resources

    Comprehensive Resources
    Comprehensive Resources New York, United States

    2 weeks ago

    Default job background
    Description

    ROLE:
    Senior Oracle DBA - OMS/


    GIS

    VISA:
    No CPT,


    OPT

    LOCATION:
    Hybrid in NYC

    Experience : 11+

    Need Local or Nearby States


    JOB DESCRIPTION
    Support Oracle OMS and eSRI based
    GIS Environment & Databases
    OMS and
    GIS related Linux /Windows server requests built to ConEd standards
    Performance monitoring and optimization of all Arc
    GIS / ArcFM Environments
    Maintaining sync jobs and reporting failures to the Application PoCs
    Support Build deployments
    Maintain configuration stores
    Provide ongoing database maintenance, including optimizing databases for specific applications.
    Update database software as required.
    SDE compress and rebuild index
    Maintaining growth, scalability, tasks and schedules
    Data synchronization and replication
    Maintenance of current editing workflows and version architecture
    Maintain ConEdison enterprise geospatial data models for Gas and Electric ( Versioned and non versioned datasets)
    Maintain the Esri Arc
    GIS Enterprise and planned migrations

    Experienced managing Geographic Information Systems (ArcGis, MapInfo, Oracle Spatial), SAP, Oracle Applications, Oracle Fusion Middleware, MySQL, DB2 and SQL Server.


    RESONSIBILITIES:
    Installation, configuration, upgrade and management of
    GIS (ESRI's AcrSDE, ArcFM, ArcIMS applications on Windows and Unix servers.
    Created and managed Arc
    GIS user accounts, instances, services and permissions.
    Designed and Managed SDE-Oracle database storage according to vendors recommended best practices. Configured dbtune file for Arcsde.

    Designed and deployed disaster recovery plan for SDE servers, and Oracle databases using combinations of RMAN, export/import, Data Pump, Online, and cold backups.

    Implemented Oracle Transparent Application Failure (TAF) with failover and load balancing capabilities for SDE-Database.
    Scripted and scheduled shell scripts and batch scripts for monitoring SDE on SQL Server and Oracle database
    Keep up with latest SDE releases by performing server upgrades, installing patches and service packs when necessary.
    Set up SDE multi-user editing database, perform database compress, and re-orgs after editing. Scripted an upload process that refreshes the test SDE, and Oracle database environments to the production environment after versioning.
    Installed, updated, and managed FlexLM single user and multi-user license files.
    Update spatial metadata view with Dimensional Information about Geometrics
    Created Spatial indexes, Parallel Spatial Indexes, Partitioned Spatial Indexes.
    Provide support for version activities, and perform database reorgs to improve database performance.
    Installation and configuration of Oracle Application server, OC4J and mapview for Oracle Spatial.

    Undertook troubleshooting, research and resolution of complex database and application problems by closely monitoring and tuning database performance issues for SQL Server and Oracle databases on Unix and Windows operating systems.

    Performed of SDE database/repository for SQL Server and Oracle.

    Monitored OS file system, I/O, CPU, SWAP, memory and network utilizations on UNIX and Windows 2000 and ensures efficient use of disk storage, reclaim dead space, optimize space allocation and avoid out-of-space conditions.

    Implemented, and maintained Oracle partitioning to distribute file system I/O, data archiving and database performance.
    Perform server consolidation of over 5T from Solaris 10 to Linux.
    Wrote PL/SQL programs to automate database maintenance activities.

    Reviewed the physical model created from the logical model, ensuring the detailed physical design and data structures and databases complies with standards, guidelines, and procedure recommended for all aspects of data modeling, database design, and maintenance.

    Assist developers in performing functional, unit and integration testing of applications.
    Configure, deploy and management of backup and recovery strategies using RMAN, shell scripts, and Tivoli on

    Database security Management, session management, set up database system, session and statement auditing strategies, creating and administering database users, roles, privileges and profiles to ensure compliance with corporate security and control standards, and SOX Act.

    Performs database re-orgs and index rebuilds to reclaim spaces and optimize database performance.
    Performed documentation, tracking, analysis, development, and validation of functional requirements and database design in a client/Server environment.
    Refreshed Oracle databases and applications from one environment to another.
    Performed information gathering and documenting business rules, change management and integration related issues.

    Loading spatial (Points, Lines and Polygons) and non spatial data using inserts, SQL Loader, import & Export, Data Pump, and Transportable Tablespace.

    Performed OS file system utilization monitoring, swap usage, CPU utilization, file I/O, and network tracing for Oracle.
    Developed, tested and deployed PLSQL programs for database automation activities.
    Cloning/Refreshing Of SDE database from one environment to another.
    Database security Management, Session management.

    Performed object level, session, logon and system wide database audits of users to ensure user compliance with corporate security and controls standard, and SOX Act.

    Creating and administering database users, roles, privileges and profiles.
    Creation and configuration of Hot Standby Database and Data Guard across multiple servers.
    Configuration of Oracle Names Server, and SQLNET for client connections to the database server.
    Developed, deployed and maintained database backup/recovery environment (Cold and Hot) using RMAN, scripts and third party tools.

    Respond quickly to refresh data; verify of correct backup strategy; develop recovery procedures; support recovery from loss of data caused by user or system error.


    Perform application refreshes on request:

    Refresh data from one environment to another at the request of the application development staff; provide application development staff optimal development environment with current data.

    Provided database support to application developers, application support and production users.
    Performed Capacity planning and designs requirements for new databases on new/existing systems.
    Designed and managed database security and audit procedures
    Performed documentation, tracking, analysis, development, and validation of functional requirements and systems design.
    Created and managed stored procedures, functions, packages, triggers, views, tables, indexes, table partitions, partitioned indexes; synonyms and db_links.
    Monitored OS file system, I/O, CPU, Swap, memory and network utilizations.
    Manage a combination of small, medium-sized and large-scale projects in a fast-paced environment.
    Database Administration in Microsoft SQL Server
    Performance monitoring and tuning of OLTP/OLAP database server and databases in MS SQL Server .


    TECHNICAL SKILLS
    3+ years of experience with creating stored procedures in SQL
    advanced SQL development in Oracle SQL Developer
    Backend Database
    optimal oracle database design
    Senior Database Administrator

    Nice To Have
    Arc
    GIS
    Arc
    GIS Server, Portal
    Oracle Utilities

    Thanks & Regards,
    Gowri Shankar

    Email:


    #J-18808-Ljbffr
  • Elajika

    Oracle DBA

    1 week ago

    Elajika New York, United States Full time, contract

    HiWe have urgent requirementsTitle Oracle DBA Location New York NYVISA OPTDuration 6MonthsOur client is seeking a Junior Oracle DBA to be part of working on existing version of the enterprise system application software. This role is to take over existing processes and responsibi ...

  • Atechstar

    Oracle DBA

    2 weeks ago

    Atechstar New York, United States Full time, Part time, contract, training

    JOB DESCRIPTION Your 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 applicat ...

  • The Dignify Solutions LLC

    Oracle DBA

    2 weeks ago

    The Dignify Solutions LLC New York, United States

    The Adobe AEM DAM Developer codes software applications based on business requirements. · The Adobe AEM DAM Developer work assignments are varied and frequently require interpretation and independent determination of the appropriate courses of action. · The Adobe AEM DAM Develope ...

  • The Dignify Solutions LLC

    Oracle DBA

    2 weeks ago

    The Dignify Solutions LLC New York, United States

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

  • Diverse Lynx

    Oracle DBA, Oracle

    2 weeks ago

    Diverse Lynx Jersey City, United States

    data ingestion and analytics objectives. · 7 year or more experienced DB professional · Familiarity with DBMS technology, including Oracle, MongoDB and MySQL · Excellent written and verbal communication skills · Strong attention to detail and problem-solving skills · Diverse Lyn ...

  • DONNELLY & MOORE

    Oracle DBA with GIS

    3 weeks ago

    DONNELLY & MOORE New York, United States

    Our Utility Client in NYC is looking for an Oracle DBA with GIS experience for a 12+months project. This is contract role will need the consultant to have an onsite presence so locals are preferred. · Assignment Details · Support OMS and GIS Environment & Databases · o OMS and E ...

  • Priority Groups

    PeopleSoft Oracle DBA

    1 week ago

    Priority Groups New York, United States

    Job Description · Job DescriptionOverview: · ESO Consultants is currently seeking a skilled individual for the position of PeopleSoft Oracle DBA. The role involves analyzing data requirements, defining database architecture, testing databases, and maintaining Oracle Databases acr ...

  • Seneca

    Senior Oracle DBA

    2 weeks ago

    Seneca New York, United States

    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: $ $75.00 · Required Skills & Experience: · Experience managing Geographic Information Systems ...

  • Crossfire Consulting

    Senior Oracle DBA

    2 weeks ago

    Crossfire Consulting New York, United States

    Must Have: · 3+ years of experience with creating stored procedures in SQL · advanced SQL development in Oracle SQL Developer · Backend Database · optimal oracle database design · Senior Database Administrator · Nice to Have: ArcGIS · ArcGIS Server, Portal · Oracle Utilities · JO ...

  • Adjacent Soutions

    Oracle DBA Migration

    1 week ago

    Adjacent Soutions Jersey City, United States

    Job Description · Job DescriptionOur client has a requirement to migrate Japanese legacy system from 11g Oracle RAC database to a 19c Oracle RAC Multitenant database.This DBA role is for a Contractor whom knows the migration of 19c Multitenant. This client is a well respected Fin ...

  • INSPYR Solutions

    Senior Oracle Apps DBA

    2 weeks ago

    INSPYR Solutions New York, United States

    Title: · Senior Oracle DBA · Location: · Houston, TX ONSITE) · Duration: · Direct Hire Role · Work Requirements: · US Citizen, GC Holders or Authorized to Work in the U.S. · Job Description: · Minimum 10 years of hands on experience in Oracle DBA skills and 5 years of Oracle ...

  • Tanisha Systems

    Oracle DBA with PL/SQL

    1 week ago

    Tanisha Systems New York, United States

    · My name is Sumit, and I am Delivery Manager at. Tanisha Systems Inc is a global contingency staffing firm servicing. We have an excellent job opportunity with one of our clients. · Role: Oracle DBA with PL/SQL · Location: Houston, TX(3 day onsite in a week) · JOB SUMMARY: · Th ...

  • Expert In Recruitment Solutions

    Sr. Oracle DBA\Developer

    1 week ago

    Expert In Recruitment Solutions New York, United States

    Sr. Oracle DBA\Developer OMS\GIS · New York, NY - Hybrid · Primary Skills · Oracle Applications,GIS · Job Description · JOB DESCRIPTION · Support Oracle OMS and eSRI based GIS Environment & Databases OMS and GIS related Linux /Windows server requests built to ConEd stand ...

  • Insight Global

    Oracle DBA

    2 weeks ago

    Insight Global Parsippany, United States

    Insight Global's hospitality client is hiring for an Oracle DBA. Candidates will be responsible for the administration and operations of the database systems, both on-prem and cloud-based, with a focus on AWS technologies and services. They will be expected to solve production is ...

  • Tech Skills Staffing

    Sr. ORACLE/ DBA/ ENGINEER

    1 week ago

    Tech Skills Staffing New York, United States

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

  • Tech Skills Staffing

    Sr. ORACLE/ DBA/ ENGINEER

    1 week ago

    Tech Skills Staffing New York, United States

    Job Description · Job 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 ...

  • Diverse Lynx

    Oracle DBA with Goldengate and Exadate ONSITE ON W2

    5 days ago

    Diverse Lynx New York, United States

    Oracle DBA with Goldengate and Exadate · New York NY ONSITE · Contract · Required Skills: Sr. Oracle DBA, Golden Gate Admin & Exadata Admin · Preferred Qualifications6+ years of IT experience in managing and administrating large Oracle databases including OLTP/OLAP/DW. · Strong ...

  • Randstad

    sr. oracle dba\developer oms\gis

    3 weeks ago

    Randstad New York, United States

    sr. oracle dba\developer oms\gis. · new york , new york · posted 6 days ago · job details · summary · $70 - $75 per hour · contract · bachelor degree · category computer and mathematical occupations · reference · job details · job summary: · JOB DESCRIPTION · Support Oracl ...

  • Randstad

    sr. oracle dba\developer oms\gis

    2 weeks ago

    Randstad New York, United States

    sr. oracle dba\developer oms\gis. · new york , new york · posted may 1, 2024 · job details · summary · $70 - $75 per hour · contract · bachelor degree · category computer and mathematical occupations · reference · job details · job summary: · JOB DESCRIPTION · Support Orac ...

  • Diverse Lynx

    SR. Oracle DBA

    2 weeks ago

    Diverse Lynx Iselin, United States

    Hello , · We are hiring for below role · Role: Oracle DBA · Location- Plano TX- (5 Days onsite & 24x7 Rotational) · Shift :- Rotational (Shift 1 (8 AM - 5 PM), Shift 2 (4 PM - 1 AM), Shift 3 (12 AM - 9 AM)) · Key Responsibilities: · Oracle Database Management: · • Plan, ins ...