Senior Oracle DBA

2 weeks ago


New York, United States Comprehensive Resources Full time

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 ArcGIS / 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 ArcGIS Enterprise (10.6.1) 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 ArcGIS 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 ArcGIS ArcGIS Server, Portal Oracle Utilities

Thanks & Regards, Gowri Shankar Email: gshankar@crincit.com

#J-18808-Ljbffr


  • Oracle DBA

    4 days ago


    New York, New York, United States Elajika Full time

    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 responsibilities of the Database Administrator (DBA) that built/maintains the Databases...

  • Oracle DBA

    3 days ago


    New York, United States Elajika com Full time

    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 responsibilities of the Database Administrator (DBA) that built/maintains the...

  • Sr. Oracle DBA

    12 hours ago


    New York, United States VTS3 Full time

    Job DescriptionJob DescriptionWe're seeking a highly skilled Senior Oracle DBA Consultant to join our Client's team in a hybrid position based in Brooklyn, NY. If you are passionate about Oracle OMS and GIS environments and have the technical prowess to support Oracle environments effectively, we want to hear from you!Key Responsibilities:Support...

  • Sr. Oracle DBA

    3 days ago


    New York, United States VTS3 Full time

    Job DescriptionJob DescriptionWe're seeking a highly skilled Senior Oracle DBA Consultant to join our Client's team in a hybrid position based in Brooklyn, NY. If you are passionate about Oracle OMS and GIS environments and have the technical prowess to support Oracle environments effectively, we want to hear from you!Key Responsibilities:Support...

  • Senior Oracle DBA

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

  • Senior Oracle DBA

    2 weeks 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,...

  • Oracle DBA

    2 months ago


    New York, New York, United States Atechstar Full time

    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 application teams product teams and onshore DBA team to design provision maintain and...

  • Oracle DBA

    1 month ago


    New York, United States Atechstar Full time

    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 application teams product teams and onshore DBA team to design provision maintain...

  • PeopleSoft Oracle DBA

    1 month ago


    New York, United States Priority Groups Full time

    Job DescriptionJob 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 across multiple server environments. Additionally, the successful candidate will be...

  • PeopleSoft Oracle DBA

    1 month ago


    New York, United States Priority Groups Full time

    Job DescriptionJob 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 across multiple server environments. Additionally, the successful candidate will be...

  • Senior Oracle DBA

    1 week ago


    New York, United States Comprehensive Resources Inc Full time

    ROLE: Senior Oracle DBA - OMS/GISVISA: No CPT,OPTLOCATION: Hybrid in NYCExperience : 11+Need Local or Nearby StatesJOB DESCRIPTIONSupport Oracle OMS and eSRI based GIS Environment & DatabasesOMS and GIS related Linux /Windows server requests built to ConEd standardsPerformance monitoring and optimization of all ArcGIS / ArcFM EnvironmentsMaintaining sync...


  • New York, United States Diverse Lynx Full time

    Oracle DBA with Goldengate and Exadate New York NY ONSITE ContractRequired Skills: Sr. Oracle DBA, Golden Gate Admin & Exadata AdminPreferred Qualifications 6+ years of IT experience in managing and administrating large Oracle databases including OLTP/OLAP/DW. Strong Oracle Database DBA experience on 12c /19c and newer versions. Experience on Exadata...


  • New York, United States Expert In Recruitment Solutions Full time

    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 standards Performance monitoring and optimization of all ArcGIS / ArcFM...


  • New York, New York, United States TEKsystems Full time

    ***6 month+ contract******W2***Must be fully covid vaccinated, even for remote rolesDescription:Our healthcare client is looking for a Sr. Oracle DBA on a 6 month contract for a migration to Exadata (OCI). The primary responsibility of the Oracle DBA will be to plan, design, and execute complex database migrations from one environment to another, such as...


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

  • Oracle DBA

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


  • 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 Data Engineer

    2 weeks ago


    New York, United States Softworld, a Kelly Company Full time

    Job Title: Oracle Data Engineer Job Location: Dorchester MA 02125 Remote Onsite Requirements: Oracle Cloud OAC Database Admin Development Workday Job Description: Looking for an experienced database developer to support Oracle cloud application including Oracle Analytical Cloud and Oracle Integration Cloud. Advanced SQL writing / development skills required...

  • Senior SQL Server DBA

    2 weeks ago


    New York, United States JSM Consulting Full time

    15+ years of experience as a SQL Server Database Administrator15+ years of experience in designing, installing, and maintaining High Availability and Disaster Recovery Solution on MS-Windows and SQL Server clustered environments.10+ years of experience tuning, monitoring, troubleshooting and baselining SQL Server database performance.10+ years of experience...