SUMMARY:

• Cumulative Experience: 10+ Years of IT experience.
• Extensive experience in installing, configuring, and administering multiple Oracle databases in a Sun Solaris UNIX environment.
• Experience in upgrading Oracle databases to latest patch sets.
• Experience in database optimization and performance tuning.
• Experience in handling database in On Line Transaction Processing system and Decision Support Systems.
• Clone UAT and Integration databases from LIVE databases using BCV/Import Export/datapump utilities on a daily basis as well as on Demand.
• Extensive experience in planning & implementing backup strategy, especially RMAN.
• Experience in UNIX shell scripts for database monitoring and to automate routine tasks.
• Managing Database jobs, scheduler jobs and materialized views etc.
• Writing queries, stored procedures, and cursors to extract data for operations for analysis and writing triggers for transaction tracking in SQL Server 2000.
• Responsible for providing 24*7 support to the issues regarding production, development of database etc.
• Experience in GIS Software like ArcGIS, Network Engineer installation, usage and troubleshooting.
• Worked in GIS, Telecom Domain and Transport verticals.
• Worked on Replication of SQL server 2000 Databases.
• Familiar with Streams, Dataguard, RAC, etc.
• Conducted technical for more than 40 people in Philippines (Manila).
• Holding H1B Visa

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Providing 12*7 OnCall support for production databases of all versions from Oracle 9i to Oracle 11g.
• Refresh non - production databases from corresponding production instance using RMAN backup and datafiles copy using hot backup.
• Capacity planning, Space management of more than 100 databases.
• Dealing with High CPU utilization, Disk utilization and Memory utilization issues.
• Deploying Change Requests (Change management Activities) for databases.
• Supporting SQL Server environment.
• Handling all backups issues, archive backup failures issues and netbackup related errors.
• Handling all day-to-day issues in production environment.
• Supporting ERPP (Enterprise business suite) module.
• Support during scheduled maintenance issues for WebLogic, Hyperion servers also.
• Managing environment through home grown scripts
• Supporting RMAN backups.
• Worked on Database creation from scratch with UNIX Team.
• Supporting SQL Server & Mysql environments.
• Managing replication from POS to XCENTER and from sql server to oracle databases.
• Backup and recovery for MySQL databases.

Confidential

Responsibilities:

• Supported all production and non-production databases of all versions from Oracle 9i to Oracle 11g.
• Capacity planning, Space management of more than 1000 databases.
• Dealing with High CPU utilization, Disk utilization and Memory utilization issues.
• Handling refresh from RMAN backups for production to non-production environments.
• Deploying CMARs (Change management Activities) for database upgrades, Listener vulnerability fix, memory parameters change to fix ORA-4031.
• Supporting SQL Server environment for Space issues.
• Handling all user accounts related issues, account lock unlock, passwords complexities and Risk Assessments.
• Handling all backups issues, archive backup failures issues and netbackup related errors.
• Handling all day to day issues in production environment.
• Supporting VCS cluster resource failure issues.
• Support during scheduled maintenance issues for entire physical site.
• Managing environment through home grown scripts
• Supporting RMAN backups.
• Moved databases from one RMAN catalog to new RMAN Catalogs.
• Restored old RMAN backups on new server for customer to recover old data.
• Worked on Rebuilt ADF zone requests on adhoc basis.
• Worked on Database creation from scratch with UNIX Team.
• Handled Temp tablespace related issues.
• Oncall Support 12/7, working on weekends from 7am to 7pm to support production environment and on call issues.

Confidential

Responsibilities:

• Provided 24*7 support for all production and non-production databases.
• Participated in plans for refresh, weekend works, and migration to ODM environment and all performance issues on Production and non-production databases.
• Dealing with High CPU utilization, Disk utilization and Memory utilization issues. Monitoring long running full table scans & SQL queries.
• Handling refresh from production to UAT environments.
• Deploying regular baselines.
• Raising GCM (Global Change Management) and GRS (Global Requests) for significant changes in production databases.
• Creation and Management of users, profiles, roles, privileges and temp tables.
• Automated workarounds by creating baselines.
• Handling all day to day issues in production environment.
• Reorganizing the database: That is to eliminate excessive database fragmentation and to move data between different tablespaces.
• Analyzing and providing solutions to performance problems of databases.
• Trained new joinees with-in the team.
• Working as Oracle Facilitator, conducted for 40 peoples in Philippines (Manila) and locally in Hangzhou office.

Confidential

Responsibilities:

• Setup new Oracle servers from scratch, configure the server (OS patches/packages, kernel parameter settings, filesystem creation) in coordination with sys admin based on the oracle database version to be installed on the available hardware platform. Create the physical & logical structures of the database(s) and configure database backup, monitoring based on criticality of the database.
• Upgrade Oracle databases to latest patch sets. Upgrades include ground level work of identifying application dependencies in co-ordination with application team, determine the upgrade path to the target patch set, configure the Unix server in co-ordination with Unix team, install the requisite oracle server software, apply any required patches and carry out other post-upgrade tasks.
• Providing 24*7 support to production issues e.g. High CPU Load, ORA-errors, Locking issues etc.
• Dealing with High CPU utilization, Disk utilization and Memory utilization issues. Monitoring long running full table scans & SQL queries.
• Installing Statspack, Gathering Statspack report, purging snap-ids.
• Analyzing and providing solutions to performance problems of databases.
• Identify, plan, test Oracle patches and CPU (Critical Patch Updates) available on metalink for database servers in the current setup and coordinate the implementation of relevant patches.
• Perform data management tasks as required; loading, editing, restoring and removing data objects such as procedures, packages, functions, tables, indexes, synonyms, sequence, materialized views etc requested by the development/application teams.
• Creation and Management of users, profiles, roles, privileges, stored procedures, functions, triggers & packages
• Involved in space utilization and growth, tablespace usage and extents, to include allocating and planning disc storage, modifying database structure Creating primary database storage structures (tablespaces) after application developers has designed an application
• Support backup and recovery of databases. Configure RMAN backup of databases and archive logs.
• Reorganizing the database: That is to eliminate excessive database fragmentation and to move data between different databases.
• Establish, coordinate and maintain database and database environments for testing, production, and user demonstration.
• Controlling and monitoring user access to the database.
• Setup Client servers for user/application connectivity/interface to the database servers which includes Installation, Upgrade of Oracle clients on Solaris and Windows platforms.
• Interact with Oracle support to resolve issues.

Confidential

Responsibilities:

• Configured & Monitored RMAN Backups of Oracle 10g databases.
• Interact with Oracle support to resolve issues
• Monitoring the database growth.
• Writing SQL scripts for monitoring the database activities.
• Deployment of day-to-day database releases/patches.
• Providing Support to Production Environment for Oracle 9i and 10g on UNIX environment.
• Installed oracle clients on SOLARIS Platform.
• Attended one week DataStage .
• Space maintenance across tablespaces and datafiles.
• Writing shell scripts for RMAN Backups and to kick off Automatic Archiving when %age used for Archive destination will be greater that 70%.
• Creating UNIX shell scripts to automate routine tasks, e.g. to delete log files more that 90 days old & Monitoring Space requirements.

Confidential

Responsibilities:

• Creating and managing databases, planning the database design, creating users, assigning privileges in SQL Server 2000.
• Planned and implemented backup strategy.
• Monitoring Backups of all Database Servers daily.
• Monitoring Performance of Database Server and Application server.
• Optimizing stored procedures and queries.
• Worked on Replication of SQL server 2000 Databases.
• Designed DTS Packages in SQL Server 2000 to import Data from Nortel switch through DSN to SQL Server 2000.
• Extracting data in different ways for analysis of operations.
• Made Rule Engine by using procedures and cursors- In Rule Engine their are 18 parameters with threshold value for associates. If anyone cross threshold for any of 18 rules, The mail will be send to him/her and to Team Leader for his/her Team and to Team Managers as per their Team Leaders.

Confidential

Database Migration Engineer

Responsibilities:

• Preparing database for migration (Changing sequence of database, preparing required Models).
• Migrating data from various forms to Network Engineer Geodatabase.
• User Account Maintenance in Network Engineer (Creation, Deletion, etc.)
• Making Connections in Network Engineer and Work Order Implementation.
• Managing ArcSDE Services and compression of data on daily bases.

Database Administrator

Responsibilities:

• Installing, Upgrading & Configuring Oracle in Windows.
• Extensively involved in providing support to Production Environment and for migrating applications from development to production environments.
• Creating and managing databases, planning the database design, creating users, assigning privileges.
• Taking Backup & Restoring Oracle Databases.