Senior Oracle DBA with ArcGIS at NYC

2 weeks ago

New York, United States Absolute IT Full time
Job DescriptionJob Descriptiononsite 2-3 days a week in NYC DL VISA LNKEDIN

Must Have 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
  • ArcGIS
  • ArcGIS Server, Portal
  • Oracle Utilities

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

  • Oracle DBA with GIS

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

    3 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

    3 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

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

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

  • Oracle DBA

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

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

  • KIPP NYC Senior Director, Schools

    2 weeks ago

    New York County, New York, United States KIPP NYC Public Schools Full time

    Job Description Position Overview: Reporting to the Chief Schools Officer, the Senior Director, Schools (SD, Schools) is an integral member of the CSO’s team, composed of the Principal Managers, Regional Operations, KIPP Forward, the Culinary Program, and Leadership Development. The SD, Schools will support and drive organizational priorities and...

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

  • System Database Administrator-Oracle DB

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

  • KIPP NYC Senior Manager, Operations, Leadership Development

    1 week ago

    New York County, New York, United States KIPP NYC Public Schools Full time

    Job Description About the Team: The Leadership Development Team aims to develop a school leadership pipeline that builds and sustains high performing schools. With a structured on-ramp to leadership, targeted coaching, and an equitable process for promotions, leaders will develop the skills to thrive. There are three programs operated by the Leadership...

  • Oracle Cloud Database Administrator

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

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

    3 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 Database Engineer

    2 weeks ago

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

  • Oracle Database Engineer

    3 days ago

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

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

  • Adult Inpatient Psychiatrist

    3 weeks ago

    New York City, United States NYC Health + Hospitals Full time

    NYC Health + Hospitals Harlem is seeking a full-time Psychiatrist to join its dedicated behavioral health team serving Harlem. This position will provide direct psychiatric evaluations, assessments and treatments to adult patients admitted to inpatient care. The Psychiatrist will also be teaching and supervising trainees. This position also has the...

  • Senior Oracle Developer

    3 weeks ago

    New York, United States Latitude, Inc. Full time

    Job DescriptionJob DescriptionWe are seeking an experienced and talented Senior Oracle Developer to join our dynamic team. As a Senior Oracle Developer, you will play a key role in designing, developing, and maintaining our Oracle-based applications and databases. Your expertise in Oracle technologies and strong problem-solving skills will contribute to the...

  • Senior Java Developer

    1 week ago

    New York, United States Nexwave Inc Full time

    Job DescriptionJob DescriptionJob Title: Senior Java Developer (W2 Only | C2H) Location: NYC, NY ( Hybrid/3days onsite weekly )Job Description:Need Experience with the below given Skills:Java/J2EE, JavaScript Frameworks, Spring Framework (Online/UI & Batch), RESTful Web Services/API, GIT/Bitbucket and Oracle/Postgress SQL. CI/CD, Springboot, Docker and...