Sr. Oracle DBA\Developer OMS\GIS

2 weeks ago

New York, United States Cleo Consulting Full time
Job DescriptionJob DescriptionJob Title: Sr. Oracle DBA\Developer OMS\GISJob Location: New York, NYDuration: 12 MonthsPartial Remote work

TECHNICAL SKILLS

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

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.
  • 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 map view 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 modelling, 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.

  • Oracle DBA with GIS

    1 week ago

    New York, United States DONNELLY & MOORE Full time

    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 DetailsSupport OMS and GIS Environment & Databaseso OMS and EGIS related Linux /Windows server requests built to standardso Performance monitoring and...

  • Senior Oracle DBA

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

  • Senior Oracle DBA

    1 week ago

    New York, United States Crossfire Consulting Full time

    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 JOB DESCRIPTION Support Oracle OMS and eSRI based GIS Environment & Databases o OMS and GIS...

  • Sr. Oracle DBA

    2 weeks ago

    New York, United States Godspeed Workforce Full time

    Job DescriptionJob DescriptionJob Title: Sr. Oracle DBALocation: Irving Place, New York, NY (Hybrid)Duration: 12+ monthsInterview: Video (Teams) InterviewVisa Requirements: Open to Green Card (GC) / US Citizens (Must be local)Job Description:As a Senior Oracle Database Administrator (DBA) at Con Edison, you will be responsible for managing and maintaining...

  • Senior Oracle DBA

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

  • PeopleSoft Oracle DBA

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

  • Oracle DBA

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

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

  • OMS Developer

    1 week ago

    New York, United States BAMM USA Full time

    PURPOSE OF THE JOB: The applicant will work on local/global Structured Equity Derivatives Sales OMS. The role if front office facing and the candidate needs to be an analyst programmer who work with the desk to optimize the OMS platform. Main Technologies used are Java MAIN DUTIES: Gathering new business requirements Manage local developments end to end...

  • OMS Developer

    2 days ago

    New York, United States BAMM USA Full time

    PURPOSE OF THE JOB: The applicant will work on local/global Structured Equity Derivatives Sales OMS. The role if front office facing and the candidate needs to be an analyst programmer who work with the desk to optimize the OMS platform. Main Technologies used are Java MAIN DUTIES: Gathering new business requirements Manage local developments end to end...

  • Sr. ORACLE/ DBA/ ENGINEER

    2 weeks ago

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

  • System Database Administrator-Oracle DB

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

  • Oracle DB Administrator

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

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

  • System Database Administrator-Oracle DB

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

  • Principal Software Developer

    2 days ago

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

  • Oracle DBA

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

  • Oracle DBA

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

  • Oracle Cloud Database Administrator

    2 days ago

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

  • Oracle Developer

    3 weeks ago

    New York, New York, United States QData Full time

    Minimum 8 years of experience in Oracle PLSQL Development Minimum 3 years of experience in Micrsoft SQL Minimum 3 years of experience in Linux / Unix Shell scripting Good Knowledge using FTP SFTP clients Good Knowledge using Jira DevOps Oracle SQL Developer tools Should have extensive experience to design Oracle packages procedure materialized views as well...