Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Sr. Oracle DBA - OMS/GIS

RIT Solutions

Support Oracle OMS and eSRI Based GIS Environment & Databases

Support Oracle OMS and GIS related Linux/Windows server requests built to client 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 client 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 ArcSDE, 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 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 Must Have

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

Nice To Have

• administration and testing of Enterprise GIS and Database Projects • ArcGIS • ArcGIS Server, Portal • Oracle Utilities

Vacancy posted 4 days ago
Similar jobs that could be interesting for youBased on the Sr. Oracle DBA - OMS/GIS in New York, NY vacancy
  •  ...in computer science, Data Science, or AI/ML (preferred) 10+ years of experience as a Database Developer/DBA in a fast-paced agile environment 7+ years as an Oracle Developer/DBA with expert-level PL/SQL and SQL skills 2+ years of hands-on experience with Generative AI,... 
    Senior

    Compunnel, Inc.

    New York, NY
    5 days ago
  • A leading IT consulting firm is seeking an experienced Oracle DBA to manage and support Oracle databases in a remote setting. The ideal candidate will have over 5 years of experience with Oracle ERP systems and OCI services. Responsibilities include monitoring database... 
    Senior
    Remote job

    Charter Global

    New York, NY
    2 days ago
  • To support a hybrid work environment, the full-time Senior Oracle DBA will administer and monitor Oracle Database environments while managing Oracle GoldenGate replication and ensuring the performance and security of Oracle Exadata infrastructure. Key Responsibilities... 
    Senior
    Full time

    Virtual Vocations Inc

    New York, NY
    2 days ago
  •  ...partners Develop strong internal cross functional relationships with Merchandising, Production, Technical design, Gap Inc Sourcing (GIS), Visual Merchandising and Marketing to ensure product concept to store and site execution is a seamless customer experience Partner... 
    Senior
    Geographic information system
    Seasonal work

    FashionUnited

    New York, NY
    2 days ago
  • $80 - $88 per hour

    Sr. Data Scientist Geospatial Data Scientist Remote Compensation: $80 - $88 per hour About The Role Our client is seeking a Geospatial...  ...maintain geospatial data quality, coverage, and accuracy Apply GIS tools (QGIS, ArcGIS, or equivalent) for spatial analysis and visualization... 
    Senior
    Geographic information system
    Hourly pay
    Remote work

    Brooksource

    New York, NY
    3 days ago
  • Sr.NET Developer Location: Remote Remote position This resource should have a strong Microsoft .NET development background with extensive...  ...exposure to PowerShell scripting. Some basic understanding of GIS and the core concepts involving location. Some exposure to... 
    Senior
    Geographic information system
    Remote work

    My3Tech Inc

    New York, NY
    1 day ago
  • $110.8k - $144.1k

     ...partners Develop strong internal cross functional relationships with Merchandising, Production, Technical design, Gap Inc Sourcing (GIS), Visual Merchandising and Marketing to ensure product concept to store and site execution is a seamless customer experience Partner... 
    Senior
    Geographic information system
    Minimum wage
    Seasonal work

    Gap

    New York, NY
    5 days ago
  •  ...and multi-disciplined capabilities encompass all aspects of the Engineering, Procurement, Construction Management, Field Inspection, GIS Integrity, Staffing Services and more. Position Description The Senior Designer - Pipeline/Mapping will be responsible performing detail... 
    Senior
    Geographic information system
    Work at office
    Local area
    Worldwide

    Gulf Interstate

    New York, NY
    1 day ago
  • $700 per month

     ...experience. A minimum of 3-5 years of experience with Transportation Agencies. Associate or Bachelor's Degree desired. Demonstrated GIS (Geographic Information System) experience a plus. Proficiency in OpenRoads, OpenBridge, and Bluebeam Revu. Proficiency in Microsoft... 
    Senior
    Geographic information system
    Temporary work
    Work at office
    Local area

    mcfa

    New York, NY
    1 day ago
  • Weill Cornell Medicine - Qatar is seeking a Senior Procedural Radiologist Assistant to perform gastrointestinal fluoroscopy under supervision. Candidates must have over 7 years of experience, strong communication skills, and a New York State License in Radiographic Technology...
    Senior
    Geographic information system

    Weill Cornell Medicine - Qatar

    New York, NY
    3 days ago
  •  ...Oracle Database Administrator Administering AMI’s MDMS Oracle database environments Setup and administer Oracle Exadata machines Plan...  ...0 years experience working as an oracle database administrator (dba) Experience working with Oracle Exadata and Exalogic. Experience... 

    Samprasoft

    New York, NY
    5 hours ago
  • $115k - $135k

    UDC is seeking a full-time Senior GIS Consultant with experience configuring, deploying, and managing Esri's Utility Network integrations. The Senior GIS Consultant will provide delivery of high-quality advisory services to a broad portfolio of clients within the energy... 
    Senior
    Geographic information system
    Full time
    Temporary work
    Work experience placement
    Shift work

    UDC

    New York, NY
    5 days ago
  •  ...Oracle GoldenGate DBA The candidate will be responsible for the GoldenGate portion of the company's Data Hub, enabling streaming of data from critical systems to where it is needed. Required Skills/Experience: seeking a highly motivated DBA with extensive knowledge... 

    Samprasoft

    New York, NY
    6 hours ago
  • $114.4k - $218.4k

     ...workshops, and seminars. Understand our customers. Demonstrate advanced industry knowledge and its relevance to the application of GIS. Identify key stakeholders and business drivers within organizations and gain access to executive, enterprise-level decision makers.... 
    Senior
    Geographic information system
    Local area

    Esri

    New York, NY
    a month ago
  • $115k - $125k

     ...of experience in forest management or ecological research and strong quantitative skills. The role includes responsibilities such as GIS analysis, contractor coordination, and overseeing planting execution. Competitive salary of $115,000 - $125,000 annually with additional... 
    Senior
    Geographic information system
    For contractors

    Carbon, Inc.

    New York, NY
    2 days ago
  •  ...Job Description Oracle DBA-GoldenGate Focus JOB DESCRIPTION We are seeking a highly skilled Oracle GoldenGate-focused Oracle DBA Contractor to support mission-critical enterprise data replication, database administration, and cloud integration... 
    For contractors
    Weekend work
    Afternoon shift

    3B Staffing LLC

    New York, NY
    4 days ago
  • $500 per month

     .... This is an exciting opportunity to leverage your expertise in Oracle PL/SQL, BizTalk, and Work Management Systems (WMS) to deliver seamless...  ...data exchange between applications like WMS, Oracle CIS, GIS, and Designer XI. Collaborate with teams to optimize data flow... 
    Senior
    Geographic information system
    Hourly pay
    Extra income
    Full time
    Contract work
    Work at office

    VTS3

    New York, NY
    27 days ago
  •  ...monitoring, CAT modeling, pricing support, and strategic risk decisions using advanced analytics. You will leverage machine learning and GIS insights to drive profitable growth and strengthen catastrophe resilience while collaborating with cross-functional teams on data #J... 
    Senior
    Geographic information system

    REINO ANIMAL

    New York, NY
    2 days ago
  • Bluehawk, LLC seeks a senior Geospatial Analyst to provide advanced GIS support for DoD/IC missions. You will develop and integrate complex geospatial datasets for operational planning and intelligence production, while leading technical projects and mentoring junior staff... 
    Senior
    Geographic information system

    Bluehawk, LLC

    New York, NY
    2 days ago
  • Infinite Medical P.C. seeks a Gastroenterology Nurse Practitioner/Physician Assistant to join our team in Queens, NY. You will provide comprehensive GI care for residents in a skilled nursing facility, working with a dedicated healthcare team to deliver compassionate, patient...
    Senior
    Geographic information system

    MedElite

    New York, NY
    2 days ago
  •  ...disciplinary workstreams in a dense urban setting. The role emphasizes leadership, collaboration with clients and stakeholders, and applying BIM, GIS, automation, and data environments to drive reliable delivery and value across North America. #J-18808-Ljbffr Mott MacDonald
    Senior
    Geographic information system

    Mott MacDonald

    New York, NY
    2 days ago
  • Minimum of 7 years of Oracle Apps DBA experience, including a minimum of 2 years of experience in installation, upgrade, patching, and support of Oracle databases 11g/12c and preferably two years' experience administering Oracle E-Business Suite R12. Strong knowledge of... 

    TechDigital Group

    New York, NY
    2 days ago
  • Ability to Analyze Query plans, Trace files etc. Troubleshooting Performance / Scalability issues including SQL tuning Experience with Oracle utilities Knowledge of UNIX / Linux server OS Qualifications: 5 yrs. of experience as Database Administrator in Oracle product... 

    Cygnus Professionals

    New York, NY
    2 days ago
  • Salvo Health is seeking a Director of Business Development to lead two critical growth engines: opening health systems as a net-new go-to-market channel and expanding the GI MSO pipeline. You will own relationships, pipeline, and deals—from prospecting through close—while...
    Senior
    Geographic information system

    Salvo Health

    New York, NY
    3 days ago
  • ## (Remote) Sr Account ExecutiveApplylocations: Vermont, United States: British Columbia, Canada: Arkansas, United States: Arizona, United...  ...II certification, and interoperability with meter data systems, GIS, and financial tools, Systems & Software delivers stability,... 
    Senior
    Geographic information system
    Remote job
    Contract work

    MediSolution

    New York, NY
    5 days ago
  • Mano Lani LLC is seeking a Senior Training and Development Specialist to design and deliver technical training for GIS, data management, real property, and related business applications. You will work with subject matter experts to translate technical processes into practical... 
    Senior
    Geographic information system
    Remote job

    Mano Lani

    New York, NY
    3 days ago
  • Oracle DBA Location: NYC & Chicago, IL (Remote) - local candidates Duration: 6 Months Contract Job Description: We are seeking an experienced Oracle Database Administrator with a strong background in PostgreSQL, MariaDB, MySQL, and general SQL. The ideal candidate will... 
    Contract work
    Local area
    Remote work

    Veracity

    New York, NY
    3 days ago
  •  ...seeking an experienced Database Administrator with strong skills in Oracle EBS and NoSQL databases. This remote position requires expertise...  ...vulnerabilities. Ideal candidates will have over 8 years of DBA experience and must be US citizens or Green Card holders. Join a... 
    Remote job

    Tier One Technologies, LLC.

    New York, NY
    5 days ago
  • T&M Associates is seeking a senior technology leader to drive GIS, software development, and systems integration projects across public and private sectors. The role blends remote flexibility with in-office collaboration and requires occasional travel (10-15%) for client... 
    Senior
    Geographic information system
    Work at office
    Remote work

    T&M Associates

    New York, NY
    5 days ago
  •  ...own architecture, UI, and networking for an industry leading native iOS app built to support the logistics industry, with a focus on GIS/navigation. We're looking for a product-minded engineer who takes ownership, challenges assumptions, and values rigorous automated testing... 
    Senior
    Geographic information system
    Remote work

    Perceptive Recruiting, LLC

    New York, NY
    1 day ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Sr. Oracle DBA - OMS/GIS. Be the first to apply!