SUMMARY:

• Extensive experience in developing Oracle N - Tier Application, Real-time Application Clustering (RAC) using the latest Oracle Software (Oracle 10gR2).
• Thorough knowledge of Oracle database Architecture components including maintenance & enhancing the performance of database.
• Expert in ORACLE Database Administration including design of database, planning / implementing, backup / recovery strategies using RMAN & Performance tuning.
• Experience in installation and configuration of Oracle software in very large databases.
• Capacity Planning, space utilization and Data modeling & designing using Erwin / Visio.
• Planning and Managing Tablespace, Physical & Logical database layouts.
• Proficient in monitoring, optimizing & enhancing the performance of the Database.
• Expertise in tuning the database for optimal performance based on application changes, Memory, Disk usage.
• Extensive experience in integrating and configuring Oracle (11gR2 / 10gR2 / 9i) database with ArcGIS (10 / 9.3.1 / 9.2 / 9.1 / 8.3 ) software.
• Expert in ArcSDE commands, tuning the ArcGIS layers & ArcIMS AXL File for better performance.
• Expertise in writing server side PL/SQL Stored Procedures, Packages and Triggers etc in Oracle database.
• Successfully maintained multiple databases.
• Expertise in managing Oracle Net connectivity with TCP/IP network.
• Expertise in Migration & Upgrading the Oracle Production database from Oracle 9i (32 bit) to Oracle 10gR2 (32 bit) to Oracle 11gR2 (64 bit) .
• Team Leadership qualities and enjoy working in a team environment.
• Ability to handle multiple tasks independently as well as in a team, as a good team player within a specified time.

PROFESSIONAL SKILLS:

RDBMS & DBMS:

Oracle (11gR2 (64 bit) / 10gR2 /9i /8.x / 7.x), MS SQL Server 2005, MS Access

Development Tools:

Developer2000, Designer2000, VB 5/6, Crystal Reports 6.0/7.0/8.0, PB 6.5

Internet Tools:

Java2.0, JDBC, Servlet, JSP, ODBC, Apache Server, XML, ASP

GIS Tools:

ArcGIS tools 10 / 9.3.1 / 9.2 / 9.1/8.3 (ArcIMS, ArcSDE, ArcInfo), PLTS 10, ArcGIS Data Viewer 10, XTools

Case Tools/OOP:

ER/Win 3.5, Visio Pro 2000, Power Designer 6.1, Rational Rose (Clearcase, RUP)

Application Servers:

BEA Weblogic, IBM Websphere

Operating Systems:

Linux RHEL 5.6 (64 bit), Windows bit),Windows 9x / NT / 2000 / XP (32 bit)

Other:

Toad 10.x / 9.x / 8.x

PROFESSIONAL EXPERIENCE:

Confidential

Sr. GIS Database Administrator

Client:

Confidential,

Responsibilities:

Installation Oracle software, managing, and Integrating Database with ArcGIS server (Middleware Applications Software such as ArcIMS, ArcSDE, ArcGIS) on the Oracle10gR2 Database for all GIS environments (Development, Edit, UAT (Staging), Production).

Managing & maintaining other databases: RNS, AMS, TPD, DHR database & ArcSDE services.

Creating and Maintenance of Database Table spaces, Users, Roles & Schemas.

Managing and administering database security, Instance startup / shutdown, and database recovery.

Managing & maintaining all specified oracle and SDE instances, during service patch update on the server side.

Integration and Maintaining connectivity of ArcSDE 9.x and with Oracle10g database.

Performance Tuning & Monitoring the database.

Granting permissions to GIS users on each individual datasets.

Installing ArcGIS software, creating SDE instances.

Upgrading ArcSDE to latest version & applying latest patches.

Upgrading SDE license keys, creating SDE services.

Monitoring SDE services on all servers and Maintaining ArcSDE services on GIS dev database server.

Monitoring & maintaining Linear referencing & Centerline data process in GIS Edit db server.

Monitoring Compress job for any errors/warnings.

Monitoring private version checked out in GIS Edit SDE instance to avoid loosing any edited data.

Assisting GIS analyst in GIS layer updates, data cleaning, performance tuning, and data fixes, creating right (grid) size spatial index and uploading metadata into SDE layer in GIS database.

Uploading all the latest datasets by creating new layer structures & importing into all GIS database environments.

Assisting GIS editors in all kinds of ArcSDE issues like edit Versions conflict/lock, permission issue, connectivity issue etc.

Resolving the hanged versions issues without loosing the data.

Assisting different agencies (DHR, TPD) in debugging and fixing any ArcSDE & database issues.

Environment: Oracle 11gR2, Oracle 10gR2, Oracle 9i, PL/SQL, ArcGIS 10, 9.3.1 / 9.2 / 9.1 / 8.3 (ESRI Software: ArcIMS, Arc/Info, ArcSDE, ArcGIS Data Reviewer 10, PLTS), Microsoft SQL server 2005, Quest TOAD 10, ActiveX Connector, XSLT (XML DOM), IIS Server, JavaScript, Linux RHEL 5.6, Windows NT/2000/XP, MS Access

Confidential

GIS Database Administrator

Client:

Confidential,

Developing & Maintaining Database of following projects:

• DCGUIDE Production, Development & Testing database
• DCGIS Production & Development database
• MAR Production database
• FEMS Production & Development database
• EIC (EMERGENCY INFORMATION CENTER) Production & Testing database.
• VECTOR PROPERTY MANAGEMENT (VPM) Production & Development database
• DCGIS TOOLS Production database
• CITRIX SERVERS

Responsibilities:

• 24 x 7 Support for all the Database and ArcGIS (Middleware Applications Software).
• Installation of Oracle software, Integrating and managing the clustered database using RAC (Clusterware) on Oracle10gR2 Database.
• Planning & Designing of Logical and physical database structure / layout.
• Data Modeling using Visio 2003.
• Creating and Maintenance of Database Tablespaces, Users, Roles & Schemas.
• Integration and Maintaining connectivity of ArcSDE 9.x and ArcSDE 8.3 with Oracle10g and Oracle 9i databases respectively.
• Managing and administering database security, Instance startup / shutdown, and backup / recovery using RMAN.
• Performance Tuning & Monitoring the database.
• Creating PL/SQL Packages, Stored Procedure, Triggers, Functions according to the requirement of Application development team.
• Continuous tuning of the databases & database SQL statements.
• Managing & maintaining connectivity of ArcIMS, ArcSDE and Oracle database.
• Resolved the issues/questions raised by the Application Development team by research & debug.
• Complete responsible for maintenance of all Databases (Production, Staging & Engg.).
• Managing & maintaining the Citrix servers.

Environment: Oracle 10gR2 using RAC, Oracle 9i, PL/SQL, ArcGIS 9.2 / 9.1 / 8.3 (ESRI Software: ArcIMS, Arc/Info, ArcSDE), Quest TOAD 8.3, ActiveX Connector, XSLT (XML DOM), IIS Server, JavaScript, Windows NT/2000/XP, Citrix Server, MS Access

Confidential

GIS Database Administrator

Client:

Confidential,

Developing & Maintaining Database of following projects:

1 DCGUIDE Production, Development & Testing database

2 DCGIS Production & Development database

3 FEMS Production & Development database

4 EIC (EMERGENCY INFORMATION CENTER) Production & Testing database.

5 VECTOR PROPERTY MANAGEMENT (VPM) Production & Development database

Responsibilities:

• 24 x 7 Support for all the Database and ArcGIS (Middleware Applications Software).
• Installation of Oracle software, Integrating and managing database on Oracle 9i Database.
• Planning & Designing of Logical and physical database structure / layout.
• Data Modeling using Visio 2003.
• Creating and Maintenance of Database Tablespaces, Users, Roles & Schemas.
• Integration and Maintaining connectivity of ArcSDE 8.3 with Oracle 9i databases respectively.
• Managing and administering database security, Instance startup / shutdown, and backup / recovery.
• Performance Tuning & Monitoring the database.
• Creating PL/SQL Packages, Stored Procedure, Triggers, Functions according to the requirement of Application development team.
• Continuous tuning of the databases & database SQL statements.
• Managing & maintaining connectivity of ArcIMS, ArcSDE and Oracle database.
• Resolved the issues/questions raised by the Application Development team by research & debug.
• Complete responsible for maintenance of all Databases (Production, Staging & Engg.).
• Managing & maintaining the Citrix servers.

Environment: Oracle 9i, PL/SQL, ArcGIS 8.3 (ESRI Software: ArcIMS, Arc/Info, ArcSDE), Quest TOAD 8.3, ActiveX Connector, XSLT (XML DOM), IIS Server, JavaScript, Windows NT/2000/XP, Citrix Server, ASP.NET, Java 1.5, MS Access

Confidential

Oracle DBA

Client:

Confidential,Arlington, VA

Confidential,provides high-quality service to Competitive Local Exchange Carriers (CLECs). The actions include, the adoption of carrier-to-carrier service measurements and standards, scoring mechanisms to determine whether CLECs are receiving non-discriminatory treatment, bill credits for unsatisfactory performance, monthly reporting requirements etc.

Responsibilities:

Performance tuning: monitoring long running transactions using explain plan, utlstat, tkprof Oracle Enterprise Manager and other Database tools to boost database performance.

Performance tuning of the Stored Procedure, SQL Queries.

Working with development team: Participate in database design and data modeling.

Writing SQL Stored Procedures, Triggers, Functions etc.

Generating database performance reports and application timing statistics using third party tools: and SQL Profiler.

Keeping track of Alert log files and trace files.

Adding / resizing data files.

Environment: Windows NT 4, Oracle 8i, Quest TOAD, SQL*PLUS, PL/SQL, Transact SQL, SQL Profiler, SQL Query Analyzer, Quest Spotlight, DBTools

Confidential

Oracle Developer

Clients:

Confidential,Denver, CO

Data Mart project is to support the current planning cycle specific to the development of Comprehensive Plan and to produce an output representing the implementation plan for engineering.

Responsibilities:

• Designed E-R Diagram and Data Model using ERWin/PowerDesigner.
• Developed a Data Store and Data Entry screens for the acquisition of defined components from individual plans in Forms6i.
• Refreshed development and Test databases using export, import.
• Deployed all the web-enabled screens in Oracle Web Application Server 9i.
• Optimised the Query System for better performance.
• Completed Unit Testing & Integration testing.
• System upgrade from version 2.5 to version 6i for Reports and Forms.
• Environment: Forms 6i and reports 6i, Oracle8.0, ERWin/PowerDesigner, Windows NT
• VantagePoint Networks (A John Deer Company), Ft. Collins, CO
• Crop Management System
• Vantage Point Network created a website for farmers and crop consultants in USA.
• Responsibilities:
• Completed System Study, Analysis & Design for the Client/Server application system.
• Creating Tables, Monitoring Tablespaces & Users.
• Maintained data model in Erwin.
• Created and maintained user securities and roles.
• Designed and Coded stored procedures and triggers
• Continuous tuning of the databases and C/S systems
• Environment: JDK1.2, Swing, Symantec Visual caf, Oracle 8i, Microsoft SQL Server 6.5,Windows NT Server 4.0, ESRI MapObjects 2.0, ESRI Internet Map Server 2.0, ESRI SDE 3.0.2, Visual Source Safe for Source Code Control, SQA for defect Tracking
• Confidential,Santa Clara, CA (Offshore) Feb.’2000 - Oct.’2000
• Oracle DBA
• Project 1: Confidential,is a Community of teacher’s & students. This is web-enabled portal, which is capable of being deployed in an Internet environment.
• Responsibilities:
• Completed implementation of two new Client Server systems on the LAN/WAN, which required use of Oracle Replication.
• Created and maintained user securities and roles
• Established the physical and logical backup schedules for the databases.
• Designed and Coded Packages, stored procedures and triggers
• Performed design and development of manipulations of note database in an Oracle database using JDBC and Oracle drivers.
• Dynamic objects were created through the use of Pro*C
• Performed Load Testing to verify the performance of the server under the stress of many clients.

Environment: Java, Servlet, JSP, J2EE, Apache web Server, IBM Web Sphere, Oracle 8.0, ER/Win, Pro*C, LDAP server, JNDI, Windows NT