Apply on Employer Site

Clevanoo LLC · 1 day ago

Oracle DBA

Brooklyn, NY

Contract

Onsite

Mid, Senior Level

3+ years exp

Clevanoo LLC is seeking an experienced Oracle DBA to manage Geographic Information Systems and various database applications. The role involves installation, configuration, and management of Oracle databases, as well as troubleshooting and performance tuning across different environments.

Staffing & Recruiting

Hiring Manager

Maithili K

Responsibilities

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

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

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

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

Qualification

Oracle DBAArcGISSQLOracle SQL DeveloperDatabase AdministrationPerformance tuningSoft skills

Required

Must have ArcGIS experience

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