Geospatial Data Analyst

PROFESSIONAL SUMMARY

Over *+ 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 on Windows, Linux,Hp-Unix.

Summary of Key Strengths

Multitask oriented and the ability to prioritize to meet deadlines.

Analytical skills combined with outstanding leadership ability, creative problem solving skills.

Good experience in Oracle installation and Migration.

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

Installation, up gradation and patch implementation for oracle servers

Database design, implementation and maintenance.

Planning and managing the backup and recovery of the databases.

Database monitoring and tuning.

Migration and up gradation of databases to 11g (11.2.0.1).

Proficient in monitoring alert log files.

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.

Reorganizing database using Oracle and third party tools like DBMS_REDEFINATION, MOVE, OEM and export/import methods.

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 Skill Set

Database Products Oracle 9i,10g,11g,11gR2, SqlServer

2008,2010,2012,Postgres,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

Arc Catalog 9.3,9.3.1,10,10.1,10.2.

ArcGIS Server 9.3,9.3.1,10,10.1,10.2.

Python, ArcFM, FME, Erdas Apollo.

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

Languages C, C++,J2EE.

Tools Toad,Sql-Developer.

CERTIFICATION

Certified Introduction to SQL(1Z0-051)

Certified Oracle Database 11g: Administration I OCA (1Z0-052)

Certified Oracle Database 11g: Administration II OCP (1Z0-053)

Project Profile

Client: PG&E (Pacific Gas and Electric Company), Aug 2012 - Till Date

San Francisco, California

Role: ArcSDE Administrator

Description:

This gas conversion project contains land base and gas data. The data, which is in the raster, vector and data base like .xls and .mdb, is integrated and digitized in AutoCAD and final migrated to ArcGIS.

Responsibilities:

Installation of Oracle11g software and creation of databases.

Installation of ArcSDE10 and creation of ArcSDE services.

Downgrade ArcFM data to ESRI.

Written SQL scripts to monitor the tablespaces usage.

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,ArcCatalog10,10.1,ArcSDE10,10.1, Oracle11gR2,python.

Client: DEWA (Dubai Electricity and Water Authority), Jun 2011- Aug 2012

Role: ArcSDE Administrator

Description:

This project involves analyzing existing systems and reporting the findings and recommendations regarding the current state of the GIS implementation at DEWA .It involves understanding the DEWA’s business process, interacting with DEWA GIS users, gathering requirements and enhancements .It involves migrating the existing database to ArcFM UT 10.0 oracle 11g with data restructuring and data model changes.

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.

Client: KSDI (Kerala spatial data Infrastructure), Aug 2012 - Nov 2013

Role: Database Administrator

Description:

KSDI is a GIS Project for Kerala state government to integrate all department's GIS Data. The application is designed to maintain centralized database. The application is allowed to edit and upload the database .The Public users are allowed to view the data through Erdas Apollo services.

Responsibilities:

Data model Design and implementation for postgres.

Installation of postgres database.

Installation and configuration of postgis.

Installation of Erdas Apollo server.

Creation of users, roles and profiles.

Created table and data dictionary for the tables.

Configuring the backups of Postgres Database.

Loading Vector data to postgres.

Creating Raster services in Erdas Apollo Server.

Environment: PostGres 8.4, Postgis, Erdas Apollo Server, Java.

Client: Target US Aug 2011 - Feb 2012 Minneapolis, Minnesota

Role: ArcSDE Administrator

Description:

Keystone is a GIS Project for Target retailer to generate report for property development. The application is used as decision making system to establish new stores and upgrade existing stores. Reports such as Ring Analysis and Time Analysis based on population on proposed sites using ESRI Business Analyst Data can be generated.

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 ArcInfo,ArcgisServer.

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.

Client: Land Transport Authority (LTA Singapore) Jan 2010 - July 2011 Singapore

Role: ArcSDE Administrator

Description:

LTA has two main applications Geographic Data Management (GDM) and Traffic Accident Analysis Management (TAAM) and both are customized GIS applications which run in a client server environment. GDM application acts as the agent to manage the authority’s GIS Data in a common repository. Authority will be sharing the GIS Data information to internal and external parties through the GDM Application. The Purpose of the GDM Application is to store and maintain the complete Singapore GIS Data and serve different Internal and External parties based on privileges.

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

Client: ROPME, Kuwait Aug 2008 - Dec 2009

Role: GIS-DBA

Description:

Regional Organization for the Protection of the Marine Environment (ROPME) is concerned with disseminating information and knowledge for the protection of ROPME sea area. ROPME Integrated Information Systems has been designed to provide different types of outputs: spatial, graphical, and tabular which would allow preparing information for decision and policy makers, scientific and research institutes, agencies responsible for managing ROPME coastal zone.

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

Client: Abu Dhabi Municipality Jan 2007 - Aug 2008

Role: Jr GIS-DBA

Description:

GIS(Geographical Information Systems) Web Site enables public access SDD stakeholders to view data and metadata, to download (and eventually pay for) data where applicable. This web mapping solution is accessible to all users with basic GIS functionalities and the authorized users are allowed to download data, measure, save URL, digitize etc.

Responsibilities:

Involved in Oracle 10g Installation.

Involved in Installation of ArcSDE 9.3.1 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.

Environment: C#.Net,Asp.Net, Oracle 10g, ArcGIS Server 9.3 and ArcSDE 9.3.

EDUCATIONAL QUALIFICATION

Masters of Computer Applications from Acharya Nagarjuna University

Contact this candidate