Oracle \ ArcGIS Administrator Onsite

Support ESRI and Schneider Based GIS Environment & DatabasesSupport GIS related Linux/Windows server requests built to client standardsPerformance monitoring and optimization of all ArcGIS/ArcFM EnvironmentsMaintaining sync jobs and reporting failures to the Application PoCsSupport Build deploymentsMaintain configuration storesProvide ongoing database maintenance, including optimizing databases for specific applicationsUpdate database software as requiredSDE compress and rebuild indexMaintaining growth, scalability, tasks and schedulesData synchronization and replicationMaintenance of current editing workflows and version architectureMaintain client enterprise geospatial data models for Gas and Electric (Versioned and non versioned datasets)Maintain the Esri ArcGIS Enterprise (10.6.1) and planned migrationsExperienced managing Geographic Information Systems (ArcGis, MapInfo, Oracle Spatial), SAP, Oracle Applications, Oracle Fusion Middleware, MySQL, DB2 and SQL ServerInstallation, configuration, upgrade and management of GIS (ESRI’s AcrSDE, ArcFM, ArcIMS applications on Windows and Unix serversCreated and managed ArcGIS user accounts, instances, services and permissionsDesigned and Managed SDE-Oracle database storage according to vendors recommended best practices. Configured dbtune file for ArcsdeDesigned and deployed disaster recovery plan for SDE servers, and Oracle databases using combinations of RMAN, export/import, Data Pump, Online, and cold backupsImplemented Oracle Transparent Application Failure (TAF) with failover and load balancing capabilities for SDE-DatabaseScripted and scheduled shell scripts and batch scripts for monitoring SDE on SQL Server and Oracle databaseKeep up with latest SDE releases by performing server upgrades, installing patches and service packs when necessarySet 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 versioningInstalled, updated, and managed FlexLM single user and multi-user license filesUpdate spatial metadata view with Dimensional Information about GeometricsCreated Spatial indexes, Parallel Spatial Indexes, Partitioned Spatial IndexesProvide support for version activities, and perform database reorgs to improve database performanceInstallation and configuration of Oracle Application server, OC4J and mapview for Oracle SpatialUndertook 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 systemsPerformed of SDE database/repository for SQL Server and OracleMonitored 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 conditionsImplemented, and maintained Oracle partitioning to distribute file system I/O, data archiving and database performancePerform server consolidation of over 5T from Solaris 10 to LinuxWrote PL/SQL programs to automate database maintenance activitiesReviewed 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 maintenanceAssist developers in performing functional, unit and integration testing of applicationsConfigure, deploy and management of backup and recovery strategies using RMAN, shell scripts, and Tivoli onDatabase 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 ActPerforms database re-orgs and index rebuilds to reclaim spaces and optimize database performancePerformed documentation, tracking, analysis, development, and validation of functional requirements and database design in a client/Server environmentRefreshed Oracle databases and applications from one environment to anotherPerformed information gathering and documenting business rules, change management and integration related issuesLoading spatial (Points, Lines and Polygons) and non spatial data using inserts, SQL Loader, import & Export, Data Pump, and Transportable TablespacePerformed OS file system utilization monitoring, swap usage, CPU utilization, file I/O, and network tracing for OracleDeveloped, tested and deployed PLSQL programs for database automation activitiesCloning/Refreshing Of SDE database from one environment to anotherDatabase 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 ActCreating and administering database users, roles, privileges and profilesCreation and configuration of Hot Standby Database and Data Guard across multiple serversConfiguration of Oracle Names Server, and SQLNET for client connections to the database serverDeveloped, 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 dataProvided database support to application developers, application support and production usersPerformed Capacity planning and designs requirements for new databases on new/existing systemsDesigned and managed database security and audit proceduresPerformed documentation, tracking, analysis, development, and validation of functional requirements and systems designCreated and managed stored procedures, functions, packages, triggers, views, tables, indexes, table partitions, partitioned indexes; synonyms and db_linksMonitored OS file system, I/O, CPU, Swap, memory and network utilizationsManage a combination of small, medium-sized and large-scale projects in a fast-paced environmentDatabase Administration in Microsoft SQL ServerPerformance monitoring and tuning of OLTP/OLAP database server and databases in MS SQL ServerMust 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 AdministratorNice To Have: ArcGIS, ArcGIS Server, Portal, Oracle UtilitiesRequired Skills: GIS, Oracle Additional Skills: Application Engineer, Database Administrator