PROFESSIONAL SUMMARY:

• Over 8+ Years of IT Experience in the field of Database Administration in Oracle 9i,10g,11gR2,ArcSDE 9.3,9.3.1,10,10.1,10.2 and ArcGIS Server 9.3,9.3.1,10,10.1,10.2, 10.3 on Windows, Linux,Hp - Unix.
• Analytical skills combined with outstanding leadership ability, creative problem solving skills.
• Good experience in Oracle installation and Migration.
• Good experience in Oracle Spatial.
• Good experience in Microsoft SQL Server.
• Good experience in ArcSDE Installation on UNIX, windows and configuring Multiple Databases.
• Good experience in ArcGIS Server Installation and Configuration on Distributed Environment.
• Synchronization of GIS Databases.
• Automated scripting of ArcGIS/ArcSDE processes using SDE commands and python script
• Good experience in developing python script.
• Good experience with working on SDO-Geometry.
• Good experience in creation and maintains of ArcGIS Server services.
• Good experience in importing and validating 3D data to Oracle Spatial using FME.
• Installation, up gradation and patch implementation for oracle servers.
• Proficient in monitoring ArcGIS Server logs monitoring and maintaining the Security.
• Proficient in managing domain user permissions through LDAP.
• Hand on Experience in providing access on ArcGIS Server services through LDAP and Active directory.
• Strong hand on experience in code deployments on SAT and Production Application servers.
• Good Experience in Web Adaptor configuration and maintenance.
• Database design, implementation and maintenance.
• Manage and resolve design issues during development.
• Performing Oracle database administration tasks like software installation, database setup, database upgrade, patch application, database cloning, space management, performance tuning, SQL tuning, backup & recovery independently.
• Strong hands on experience in all types of backups & recoveries like export/import, manual and RMAN backup.
• Database security administration through roles, privileges, profiles and fine grained auditing.
• Configuration & maintenance of Oracle Recovery Manager-RMAN.
• Hands on experience in migrating databases across different platforms.
• Configuration of Oracle Management Servers for Database monitoring.
• Diagnose and resolve performance, connectivity, security and database corruption issues in a critical production environment.
• Proficient in using AWR, ADDM for performance tuning - SQL tuning, Memory tuning, I/O tuning.
• Proficient in Oracle partitioning, data loading using SQL Loader.
• Analyzing and fixing block corruption using RMAN and DB verify tools.
• Define, create, redefine and re-structure the databases, implement integrity control, schemas and physical organization modification granting and authorization for data access.
• Proficient in UNIX system administration relevant to Oracle database management.
• Providing on-call support for all Oracle database systems and basic UNIX system administration tasks.
• Provide advice & resolve critical database errors.
• Analyzing long running background jobs and failed jobs.
• Performed User maintenance, Activity group/Role maintenance using profile generator.
• Leading and working with other team members to implement changes to database and scheduled maintenance work, and doing knowledge transfer to team members.
• Exceptionally self-motivated, teamwork oriented, well-organized, efficient work habits and strong interpersonal skills.

TECHNICAL SKILLS:

Database Products: Oracle 9i, 10g, 11g, 11gR2, 12C, SqlServer 2008, 2010, 2012, PostgreSQL, MYSQL, DB2 UDB. GIS Products ArcSDE 8.3, 9.3, 9.3.1, 10, 10.1, 10.2 Arc Map 9.3, 9.3.1, 10, 10.1, 10.2, 10.2.2, 10.3. Arc Catalog 9.3, 9.3.1, 10, 10.1, 10.2, 10.2.2, 10.3. ArcGIS Server 9.3, 9.3.1, 10, 10.1, 10.2.10.3. ArcGIS Online, Collector for ArcGIS, ArcGIS Portal. Python, Oracle Spatial, Geo-Media, ArcFM, FME, Postgis, Erdas Apollo.

Operating Systems: Windows, UNIX, Linux, HP-Unix.

Languages: C, C++, J2EE.

Tools: Toad, Sql-Developer, Aqua Data Studio, DB Visualizer.

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, California

ArcGIS Lead

Responsibilities:

• Installation of ArcGIS Server 10.2 in cluster environment.
• Installing and configuring ArcGIS Portal.
• Resolving the Tickets assigned through Remedy.
• Interacting with client and providing the best practices.
• Maintaining the production ArcGIS Server and publishing the Services.
• Troubleshooting the ArcSDE issues.
• Coding deployments in Staging and Production Servers.
• Managing (Creating New account, granting roles) ArcGIS Online user accounts.
• Providing the access on the ArcGIS server services through LDAP and Active Directory.
• Involved in Client meeting on future enhancement and change requests.

Environment:Autocad,ArcMap10,10.2,10.2.2,10.3,ArcCatalog10,10.2,10.2.2,10.3,ArcSDE10, Arc Server 10.2,10.3,ArcGIS Online, Collector for ArcGIS, ArcGIS Portal, Oracle11gR2,OracleSpatial,python.

ArcSDE Administrator

Responsibilities:

• Installation of Oracle11g software and creation of databases.
• Installation of ArcSDE10 and creation of ArcSDE services.
• Downgrade ArcFM data to ESRI.
• Converting Oracle Spatial data to shape files using Geo-Media.
• Written SQL scripts to monitor the tablespaces usage.
• Develop python scripts for appending data in versions.
• Database monitoring (free space in table spaces, event monitor outputs, security audit reports, performance reports etc.).
• Configuring Daily Backups.
• Performing Database backups & recovery (offline & online full backups and Incremental).
• Creating the ArcSDE versions for the edit users;
• Migrating Data from PGDB to ArcSDE10 for Oracle11g.
• Killing the idle sde connections using sdemon.
• Maintaining the version locks, compressing the databases at frequent intervals.
• Troubleshooting ArcSDE for connectivity, access, performance and other issues.
• Checking the ArcSDE log files.
• Registering the data as version, creating the versions.
• Resolving the issues of reconcile and post.
• Compressing the Geo Database.
• Troubleshooting ArcSDE for connectivity, access, performance and other issues.

Environment: Autocad,ArcMap10,10.1,10.2.,ArcCatalog10,10.1,10.2.,ArcSDE10,10.1, Arc Objects, ArcGIS Online, Collector for ArcGIS, ArcGIS Portal, Oracle11gR2,Oracle Spatial, python.

ArcSDE Administrator

Responsibilities:

• Develop, and implement ArcSDE feature datasets and classes.
• Installation of oracle11g software and creating databases.
• Installation of ArcSDE10 and creating ArcSDE services.
• Downgrade ArcFM data to ESRI.
• Written SQL scripts to monitor the tablespace usage.
• Configuring Daily Backups.
• Creating the ArcSDE versions for the edit users;
• Migrating Data from PGDB to ArcSDE10 for Oracle11g.
• Killing the idle sde connection using sdemon.
• Maintaining the version locks, compressing the databases at frequent intervals.
• Troubleshooting ArcSDE for connectivity, access, performance and other issues.
• Checking the ArcSDE log files.
• Registering the data as version, creating the versions.
• Resolving the issues of reconcile and post.
• Compressing the Geo Database.
• Troubleshooting ArcSDE for connectivity, access, performance and other issues.
• Coordinate with GIS users to ensure implementation and monitoring of GIS databases.

Environment: ArcMap 9.2, 10, 10.1, Arc Catalog 9.2, 10, 10.1, ArcSDE 9.2, 10, 10.1, Oracle10g, 11gR2, python.

ArcSDE Administrator

Responsibilities:

• Installation of oracle11g software and creating databases.
• Creation of users, roles and profiles.
• Installation of ArcSDE10 and creating ArcSDE services.
• Installation of ArcGIS Server 10 on distributed Environment.
• Develop automatic installation script for Arc Info, ArcGIS Server.
• Loading GIS data into database from different sources like PGDB, Shp, xml files using ArcSDE direct connect.
• Database monitoring (free space in table spaces, event monitor outputs, security audit reports, performance reports etc.).
• Configuring Daily Backups.
• Performing Database backups & recovery (offline & online full backups and Incremental).
• Troubleshooting ArcSDE for connectivity, access, performance and other issues.
• Checking the ArcSDE log files.
• Compressing the Geo Database.

Environment: C#, .Net, ArcGIS-Flex, ArcMap10, ArcCatalog10, ArcSDE10, ArcGIS BAS Oracle10g, 11gR2, python.

ArcSDE Administrator

Responsibilities:

• Installation of oracle software and creating databases on HP-UNIX.
• Creation of users, roles and profiles.
• Written SQL scripts to monitor the tablespace usage.
• Migrated Data from oracle 9i to oracle 11gR2 UAT Database..
• Migrated Data from oracle 9i to oracle 11gR2 Prod Database.
• Installation and configuration of ArcGIS Server 9.3.1 on distributed Environment.
• Giving presentations for the Data Migration Sessions.
• Direct interaction with clients for Data verification sessions.
• Onsite and Offshore Database objects synchronization.
• Developed Sde scripts to synchronization the Edit and view database.
• Database monitoring (free space in table spaces, event monitor outputs, security audit reports, performance reports etc.).
• Configuring Daily Backups.
• Coordinate with GIS users to ensure implementation and monitoring of GIS databases.

Environment:C#.Net,Asp.Net,Vb.Net,Oracle11gR2,ArcObjects,ArcGIS Server9.3.1 and ArcSDE 9.3.1

GIS-DBA

Responsibilities:

• Involved in Database Design.
• Develop, and implement ArcSDE feature datasets and classes.
• Installation of Microsoft SQL Server 2005 software and creating databases.
• Installation of ArcSDE 9.3.1 and creating ArcSDE services.
• Configuring Daily Backups.
• Migrating Data from shape file, PGDB to ArcSDE 9.3.1.
• Checking the ArcSDE log files.
• Registering the data as version, creating the versions.
• Resolving the issues of reconcile and post.
• Compressing the Geo Database.
• Troubleshooting ArcSDE for connectivity, access, performance and other issues.
• Coordinate with GIS users to ensure implementation and monitoring of GIS databases.

Environment: C#.Net, Asp.Net, Vb.Net, Microsoft SQL Server 2005, ArcGIS Server 9.3.1 and Arc SDE 9.3.1

Jr GIS-DBA

Responsibilities:

• Involved in Oracle 10g Installation.
• Involved in Installation of ArcSDE 9.3 and creating ArcSDE services.
• Involved in Installation of ArcGIS Server 9.3.
• Involved in backup and Recovery Scenarios.
• Monitoring tablespace usage and fragmentation. configuring automatic database backups
• Configuring client database and performance tuning of the database.