Overview
Experienced managing Geographic Information Systems (ArcGis, MapInfo, Oracle Spatial), SAP, Oracle Applications, Oracle Fusion Middleware, MySQL, DB2 and SQL Server.
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 .
Must Have
3+ years of experience with creating stored procedures in SQL
advanced SQL development in Oracle SQL Developer
a seasoned Oracle Database Administrator
Senior Database Administrator
Nice To Have
administration and testing of Enterprise GIS and Database Projects
#J-18808-Ljbffr
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 .
Must Have
3+ years of experience with creating stored procedures in SQL
advanced SQL development in Oracle SQL Developer
a seasoned Oracle Database Administrator
Senior Database Administrator
Nice To Have
administration and testing of Enterprise GIS and Database Projects
#J-18808-Ljbffr