Oracle/SQL Administrator

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 deployed disaster recovery plan for SDE servers, and Oracle databases using combinations of RMAN, export/import, Data Pump, Online, and cold backups.
Scripted and scheduled shell scripts and batch scripts for monitoring SDE on SQL Server and Oracle database
Installed, updated, and managed FlexLM single user and multi-user license files.
Perform server consolidation of over 5T from Solaris 10 to Linux.
Wrote PL/SQL programs to automate database maintenance activities.
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
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.
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.
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
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.
Database Administration in Microsoft SQL Server
Performance monitoring and tuning of OLTP/OLAP database server and databases in MS SQL Server .
Must 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 Administrator
Nice To Have
ArcGIS
ArcGIS Server, Portal
Oracle Utilities