BCforward · 1 week ago
ArcGIS - Oracle DBA
Brooklyn, NY
Contract
Onsite
Mid, Senior Level
3+ years expBCforward is seeking an experienced Oracle DBA with a focus on Geographic Information Systems. The role involves managing and optimizing databases, including installation, configuration, and performance tuning of Oracle and SQL Server databases, while ensuring data integrity and security.
Information TechnologyRecruiting
Hiring Manager
Saleha Shaik
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
Required
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
Preferred
administration and testing of Enterprise GIS and Database Projects
ArcGIS
ArcGIS Server, Portal
Company
BCforward
BCforward is an information technology consulting and staffing firm.
5001-10000 employees
H1B Sponsorship
BCforward has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (3)
2024 (8)
2023 (8)
2022 (6)
2021 (6)
2020 (1)
Funding
Current Stage
Late StageLeadership Team
Justin P. Christian
Founder/CEO
Jennifer Franklin
Vice President of Solution Delivery
Recent News
2026-01-16
vcnewsdaily.com
2025-06-04
2025-06-04
Company data provided by crunchbase