- 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 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 .
- 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
-
Oracle DBA
3 weeks ago
Elajika New York, United States Full time, contractHiWe 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 ...
-
Oracle DBA
1 month ago
Atechstar New York, United States Full time, Part time, contract, trainingJOB 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 ...
-
PeopleSoft Oracle DBA
20 hours ago
Priority Groups New York, United StatesJob 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 ...
-
Oracle DBA Migration
20 hours ago
Adjacent Soutions Jersey City, United StatesJob 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 ...
-
Oracle DBA
1 day ago
PRI Technology Holmdel, United StatesJob Description · Job DescriptionOracle DBA · My name is Bill Stevens and I have a new contract to hire Oracle DBA opportunity available for a major firm whose offices are in Holmdel, New Jersey and Bethlehem, Pennsylvania that could be of interest to you, please review my speci ...
-
Oracle Developer
3 days ago
Bayforce New York, United StatesWe are seeking an experienced Oracle Developer to join our client team and contribute to a large-scale financial transformation project. The ideal candidate will have a strong skill set in working with Oracle Financial Services Analytical Applications (AFCS), SQL, and Oracle Inte ...
-
Oracle DBA
3 days ago
Andre Global Holmdel, United StatesJob Description · Job DescriptionThis is a contract-to-hire position with our Insurance Client.Location: Bethlehem, PA or Holmdel, NJ. Local candidates preferred. The Database Service is scheduled to work Monday through Friday 8:00 AM ET till 5:00 PM ET. Today we are working 3-da ...
-
Oracle Developer
1 week ago
Global Pharma Tek New York, United StatesTitle: Oracle Developer · Locations: New York City, NY / Jersey City, NJ - Onsite · Type : Fulltime Opportunity · Job Description: Proven experience working with Oracle Database, SQL and PUSQL. · Strong knowledge of database management and design. · Excellent understanding o ...
-
Oracle Developer
1 week ago
TEKsystems New York, United States*Top Skills' Details* · 1) A strong Oracle Developer with extensive experience with Oracle 19c · 2) Knowledge of the IT healthcare industry and how a hospital operates from the clinical side. · 3) Prior experience working as a PL/SQL Developer with a concentration on building ...
-
Diverse Lynx New York, United StatesOracle 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 ...
-
Sr. Oracle DBA\Developer OMS\GIS
1 month ago
Randstad USA New York, United States Freelance, Full timejob summary: · 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 re ...
-
Oracle Developer
3 days ago
raag solutions Jersey City, United StatesONLY LOCAL CANDIDIATES_ JERSEY CITY · 7-10 years' experience in Oracle Exadata, SQL, PL/SQL · •Implement ETL solutions for large volume of data by applying various data warehouse modeling techniques like Star Schema, Data partitioning, Data compression, Direct path loads etc. and ...
-
Oracle Developer
1 week ago
Saxon Global Jersey City, United StatesRole - Oracle Developer · Rate - $65/hr on C2C · Work Auth - All Except H1B · Location: Jersey City, NJ or McLean, VA as second choice - HYBRID · Primary Skills: · Database development expertise · Strong proficiency in Oracle databases · Experience with Snowflake development ...
-
Oracle Developer
1 week ago
Vantage Point Consulting Inc. Jersey City, United StatesOracle Developer for Jersey City · 7-10 years' experience in Oracle Exadata, SQL, PL/SQL · Implement ETL solutions for large volume of data by applying various data warehouse modeling techniques like Star Schema, Data partitioning, Data compression, Direct path loads etc. and t ...
-
Oracle Mantas Developer
3 days ago
Talent Hunt Group New York, United StatesRole: Oracle Mantas Developer · Location: NYC Tri State · Duration: Fulltime · Key ResponsibilitiesImplementation experience with OFSAA platform across components such asData Ingestion - OFS Ingestion Manager · Oracle FSDM - Financial Services Data Model · Behavior Detection - ...
-
Oracle Developer Oracle Data Integrator
2 weeks ago
Amerit Consulting New York, United StatesOVERVIEW: Our client, one of the largest Energy companies in US providing a wide range of Energy related products and services to its customers, seeks an accomplished Oracle Developer [Oracle Data Integrator (ODI)]. · *** Candidate must be authorized to work in USA without requi ...
-
Oracle & DB2 DBA
1 week ago
Diverse Lynx Iselin, United StatesPosition:- Senior Oracle & DB2 DBA · Client :- Freddie Mac · Location :- Maclean, VA (Onsite) · Database Administrator · Database Administrator with Oracle Database Knowledge is a senior-level position responsible for the design, implementation, and management of DB2 and Orac ...
-
Database Developer- Oracle
3 weeks ago
New York Technology New York, United StatesDatabase Developer- Oracle , SQL, Exadata · 2 Bryant Park New York New York 10038 · Only Nearby candidates · Qualifications · At least 7+ years of experience in working with relational databases · Expert level of understating and experience with Oracle Exadata · Ability t ...
-
SR. Oracle Developer
1 week ago
Insight Global New York, United StatesInsight Global is seeking a Sr. Oracle Developer to join one of their top financial clients. This individual will be joining the Prime Brokerage technology group. They will be responsible for ensuring stability by designing, tuning, monitoring and troubleshooting databases with l ...
-
Oracle HCM Developer
6 days ago
Jefferies Jersey City, United StatesDescription · Purpose of this position is primarily to develop highly custom extensions to the Oracle HCM application in the form of reports, interfaces, dashboards, and data-interactive online forms. · Employee will prepare test scripts, test scenarios, and test results document ...
Sr. Oracle DBA\Developer - New York, United States - Expert In Recruitment Solutions
![Default job background](https://contents.bebee.com/public/img/bg-user-ex-1.jpg)
Description
Sr. Oracle DBA\Developer OMS\GISNew York, NY - Hybrid
Primary Skills
Oracle Applications,GIS
Job Description
JOB DESCRIPTION
Support Oracle OMS and eSRI based GIS Environment & Databases
Must Have