Summary
An IT professional with over 8+ years of experience in Information Technology. 4+ years of experience in Oracle Database Administration, Systems Analysis, Design, Development, Implementation and extensive experience in Supporting and Content Management solutions using the Documentum product suite.
Experience in Database design, creations, modification and deletions of table spaces, data-files, rollback segments and schemas, Create Schema Tables, Indexes, views, sequences, synonyms, roles and users. Planning Backup/Restoration Strategy for 24x7 Production Support
Experience in installing, migration/upgrade, cloning, applying patches and configuring Oracle 10g/9i/8i
Expert in performance tuning in SQL, database server configuration, Shared Pool and Buffer Cache.
Configured and supported Oracle8i, 9i, 10G, DataGaurd on various environments.
Excellent command in creating Backups and Recovery procedures and Implementing BACKUP and RECOVERY strategies for off-line and on-line Backups.
experience in monitoring, performance tuning and trouble shooting
Highly skilled in routine maintenance for Oracle database.
used OEM Grid Control Diagnostic and tuning packs to tune the application and SQL queries
Good experience with SQL, PL/SQL, Partitioning, Data modeling, Logical and Physical Database Design.
Excellent Knowledge in latest Oracle 10g technologies like ASM, AWR, ADDM, Temporary tablespaces groups, Flashback technology, Data pump, SQL tuning adviser, SQL access advisor, undo advisor and Segment adviser.
Worked on Security Administration, Roles, Profiles
Experience in Oracle database capacity planning, space management and storage allocation experience in configuring and customizing web applications like WebTop, Web Publisher using WDK, DFC and Java
Experience in First Doc support and ability to interact with Business and Technical staff as required.
Experience in doing Configuration and value mapping.
Experience in application support and ability to interact with Business and Technical staff as required.
Experience in basic and advanced replication using materialized views.
Experience in business analysis like interacting with business group, gathering user requirements and creating functional specifications and design documents.
used Workflow manager to design, develop and implement workflows to meet business requirements


Employment

June, 2007 -  July, Present
Oracle DBA

Merck and Co., Inc is a global research-driven pharmaceutical company dedicated to putting patients first. Merck discovers, develops, manufactures and markets vaccines and medicines to address unmet medical needs.

Responsibilities : Established capacity planning in anticipation of growth and changes to the system environment.
Performed software Installation, system configuration, instance creation, database creation, objects creation, database parameter sizing.
Installed, applied patchsets
Upgrade of Database from 9.2.0.6 to 10.2.0.2

Configured 10 RAC with ASM in Dev Database, UAT and Prod Database and supported it.
Responsible for supporting application developers on best possible implementation of database schema/objects and data integrity. Design and development of PL/SQL scripts for data extraction, data transformation and data migration. Created Users/Roles, granted/revoked Permissions/Roles, defined quota on Tablespaces for users and effective management of Locally Managed Tablespaces, Dictionary-Managed Tablespaces and Temporary Tablespaces.
Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications
Developed Stored Procedures, Packages, Functions and Triggers using PL/SQL..
Implemented automated procedure to monitor archive log destination, database users, security and objects and storage and capacity planning.
Defined and tested backup and recovery policies and procedures.
Used RMAN for fast backup strategy and Export and Import utilities for logical backup.
Ensured that the database systems are reliable, available and functioning at peak efficiency at all times
Managed and maintained multiple 24x7 production databases
Provided Production DBA support round the clock and handled Severity 1 Bugs, Escalated and critical issues for customers
Monitored database activity, OS/hardware statistics and bottleneck
Developed the technical documentations and operation manuals to support the use and operation of the database system
Environment : RHEL, AIX 5.2, Oracle 9i, 10G, Toad, SQL plus, Oracle Enterprise Manager OEM, RMAN, Unix, ASM, Solaris10, RAC AIX 5.1, 5.2, Shell Scripting, HP-UX, Erwin, RAC, Replication, Sybase, Data Guard, Replication, SQL Server 2000, JAVA, WebLogic

August, 2006 -  June, 2007
Oracle DBA

The Florida Power and Light FPL is a power utility company in south Florida and provides on-line facilities to their customers to transact business like new power connections request, automatic Bill pay and problems reporting, company news etc.

Responsibilities
Collected requirement from business and customers
Developed stored procedures, advanced queries, triggers, views, indexes and functions
Developed queries for data and audit analysis by using triggers and stored procedure
Generated database SQL scripts and deployed databases, installation and configuration
Assisted the application development group like check/tune SQL queries
Maintained and managed daily operation of development, production and test Oracle 9i databases
Wrote UNIX shell scripts to perform batch routines and daily system performance and health checks.
Performed Oracle database administration tasks, user administration, schema creation and maintenance, data validation, backup and recovery procedure
Monitored the production databases for performance and tuned the databases where necessary to provide optimal response times
Provided on-call support regarding production-related database problems
Involved in documenting the environments and processes.

Environment : Sun Solaris, HP UX, Oracle 9i, Linux, SQL Plus, DB2

June, 2004 -  July, 2006
Oracle DBA

Created users and gave them pertinent access privileges based on their rolls in the company.
Monitored disk usage and user sessions using OEM and Toad
Analyzed requirements and prepared system flows, specifications and database designs.

Implemented and maintained database through DBA activities include database backups Cold, Hot
Import/Export, incremental, database recovery, tuning, installation, database creation, logical and physical database designs.
Created and scheduled nightly batch jobs for running reports
Worked with users to determine system requirements.
Monitoring application performance

Database activities include allocation and maintenance of Rollback Segments, Automatic Undo Management, table spaces, data files, redo log files, mirroring of redo log files across multiple disks, Data Replication
Experienced in using utilities like Export/Import and SQL Loader.

Coordinated with other team members in establishing tasks and deadlines.
Developed PL/SQL objects to process the data come from data feeds through SQL Loader.

Description : This project was to maintain various production/development/testing databases. Perform all databases related activity to ensure maximum availability of database. Environment : Oracle 9i, PL/SQL, SQL Plus, Windows NT, Linux 9.0, OEM

December, 2003 -  March, 2004
Documentum Consultant

Baptist Health is South Florida's largest faith-based, not-for profit health care organization, with an outstanding reputation for medical and service excellence. Baptisthealth .net reflects that commitment to excellence with information you can trust on a wide assortment of health topics. The requirements of this project were to design automated life cycle, workflow and security management. Content Management Solution was to manage company documents and publishing websites consisting financial information like latest policy updates. The project is dealt with migration of Documentum suite, customizing the existing setup as per user requirements.
Responsibilities
Worked aggressively in business analysis interacting with business group, gathering user requirements and creating functional specifications and design documents.
Designed and implemented Workflows and Lifecycles in the process of storing document using Documentum Application Builder
Interacted with the business groups and system architects in evolving the final design of the migration process.
Supporting for validators, testers and end users
Created users, groups, custom object, object types, registered tables and ACL s by using DQL and API on Documentum Administrator
Used Documentum Administrator to create the publishing configuration for publishing content to the website using Web Cache, site caching service
Created custom XML templates and rules files for content creation by authors using Web publisher interface.
Monitored and assigned tasks to the group for implementing seamless migration of the Documentum Suite
Installing, configuring and maintaining the Doc base and was responsible for gathering scripts and executing the dm clean and dm file scan utilities for docbase cleaning Removing Orphaned Content Files

Configured Web Publisher, Web Cache source and target
Involved in upgrading the environment and installing patches for e-Content Server
Used LDAP server for user level security
Using Web Publisher 5.3 created Web Publisher Editor Templates, XML Component Templates, Rules Files and XSL Presentation Files ; Reduced normal user time to publish content on web

Environment : Documentum Content Server 5.3, DAB, DQL, API, DFC, WDK 5.3, WebLogic 8.1, Documentum Administrator 5.3, Web publisher 5.3, Oracle 10g, HTML, XML, XSLT, JSP.

January, 2003 -  December, 2003
Documentum Consultant

Bank 1 offer financial solutions in many categories, Personal Finance, Commercial Banking, Business Banking and Private Client Services. The Card Services is a part of Personal Finance Division. The project involved using the Documentum Suite to collect and manage different types of content in 1 single system and feed combined content to different systems to promote credit cards to consumers based on a pre-defined strategy

Responsibilities
Created users, groups, ACL s and custom objects and object types using DQL and API
Setup the Thumbnail Server for image previews on application
Developed custom pages using HTML, XML and JSP
Registered the tables in DCTM Repository with DQL
Designed and implemented Workflows and Lifecycles in the process of storing document using Documentum Application Builder
Used Type based Business objects for development to define type- specific behavior for customization of WebTop
Querying registered tables, created and changed objects and groups as per requirement
Responsible for maintaining the Full Text Indexes, checking for corrupt indexes and indexing the failed documents in a batch and installing the latest filters for the Full Text Environment
Maintained user level security for an existing LDAP server
Involved in project life cycle to meet the deliverables on time and resolved customers issues in a timely manner
Creative and adaptable team player in fast-paced technology environments

Environment : Documentum Administrator 5.3 SP1, e-Content Server 5.3 SP1, Documentum Application Builder 5.3, Work Flow Manager, Apache Tomcat, WDK, webtop, DFC, API, DQL, XML, JSP, SQL Server 2000

August, 2002 -  December, 2002
Documentum Consultant

GlaxoSmithKline plc is a British based pharmaceutical, biological and healthcare company. GSK is a research-based company with a wide portfolio of pharmaceutical products covering anti-infectives, central nervous system CNS, respiratory, gastro-intestinal/metabolic, oncology and vaccines products. It has a Consumer Healthcare operation comprising leading oral healthcare products, nutritional drinks and over the counter OTC medicines.

Project involved Creation and maintenance of Docbases, users, groups, ACLs, DQL queries scripting and API. The application was designed in a multi-tiered architectural frame work
Responsibilities
Creating users, groups, ACL s using Documentum Administrator and object types, custom objects using Documentum Application Builder
Maintenance of Docbroker, Docbase and Docapps
Installed, configured, maintained the Docbase and was involved in gathering scripts and executed the dmclean and dmfilescan utilities to clean Repository Removing Orphaned Content Files
Maintained user level security for an existing LDAP server
Involved in project life cycle to meet the deliverables on time and resolved customers issues in a timely manner
Customized interfaces for WebTop using XML, JSP and DFC
Registered the tables in DCTM Repository with DQL
Created workflow templates using Business Project Manager for routing documents to meet the business process life cycle
Used DCM for distribution of current documents to the right people in a timely, consistent manner and to manage document changes
Queried the registered tables, created and changed objects and groups

Environment : Documentum 5.3, Content Server 5.3, Web sphere 5.1Documentum Administrator 5.3, J2EE, JSP, XML, WebTop 5.3, DocApp Installer, WDK, Apache Tomcat, DFC, DQL, API, SQL Server 2000

2002 -  July, 2002
Developer

The web application is used to order business cards online by sending employee details to the printing press. This is done by getting data like phone numbers and departments etc., dynamically from database for user s forms. This project had 2 sections, namely User and Administrator. The user has to select the language in which he wants to use the business cards. By that he goes to that particular language form. When he fills all the required data and submits, the data is stored in the database and this data is used to get into the required press format template. This required format is mailed to the printing press. In the administrator view, administrator can insert new Marconi departments or branches. This application supported printing of the data template to printing press
Responsibilities
Involved in coding of server side components using Serve lets
Developed necessary triggers, views and stored procedures for making efficient application
Involved in various levels of testing like unit, integration and regression testing
Participated in the design, development and implementation of the system
Interacting with the client to acquire requirements and analyzing the requirements and Project flow approvals
Developed GUI using HTML and JSP for dynamic page generation
Created server-side JAVA architecture using Java, Serve lets, JSP
Developed and deployed the different Enterprise Java Beans for maintaining the Business logic at server side and processing the client request
Environment
Java, J2EE, EJB, Java Serve lets, Struts, JSP, XML, Web logic and Oracle under Solaris 7, UML

March, 2001 -  January, 2002
Software Developer

Vasundara Infotech manufactures the network equipments and provides service to a major telecommunication company worldwide. High availability clusters are fault tolerant server systems, required to run 24x7 In the event of a failure of any node in the cluster, the other nodes in the cluster take over the functionality of the failed node. These cluster software is used for DNS server, proxy and web servers based implementations

Responsibilities : Worked as a software developer in a project team developing High Availability Cluster software
Converted Requirement specification into Design requirements for the development team
Involved with Business Analyst to create new Functionality requests and resolved product ion issues
Perform manual testing to verify the functionality of all features of the User Interface
Involved in Deployment and application support
Worked in the interchange of data between Business Layer and Database Layer
Environment : C/C++, Java, Shell scripts, Heartbeat, DRBD, RedHat 2.4

Vasundara Technologies, Bangalore May 00 Feburary 01
Software Developer
Project outlays the implementation of Global Positioning System by, a general interference circuit which can have connection to most GPS vendors. The software is developed in such a way that there is no conflict between map of software and its LLA. The software is compatible with all the GPS vendor hardware. This software gives considerable accuracy speed and path. This project has a wide range of applications like mobile communications, pilot based applications, Remote controlling of devices, vehicles and remote monitoring, navigation monitoring and position control

Responsibilities : Developed and designed embedded software for GPS receivers using embedded C/C++.
Involved in developing code to upload into IC using LPC2000 flash utility V20.0 programmer
Involved in code testing involved in production support issues

Environment : Embedded C/C++, LPC2000 flash utility, 32 - bit Processor LPC2129ARM7 TDMI

September, 1999 -  April, 
Software Intern

Education

Skills
Platforms Windows 2000/XP/NT, Windows 95/98, UNIX., Red hat Linux, Solaris 8/9. Languages SQL, PL/SQL, C, C++, Java, Unix shell scripting. Databases Oracle 8i/9i/10g/ Enterprise Standard Edition, SQL Sever, MS-Access. DB2 Internet Technologies HTML, DHTML, XML, XSL, Java Script, JSP and Servlets Documentum Documentum Content server 5.3 SP2, D6, First Doc 4.2.1 WDK, Webtop, ocumentum Application Installer Documentum Application Builder DAB, Documentum Administrator, Desktop Client, Workflow Manager, Web Publisher, DFC, DQL Application/Web Servers Apache Tomcat, BEA Web Logic 8.1, IBM Web sphere Office Software MS-Word, MS-Excel, MS-PowerPoint, MS-Windows, Project, Adobe Photoshop Programming Interfaces Eclipse, Text Pad Scanning Solution Kofax Accent Capture, Input Accel
SQL*PLUS, TOAD, Erwin, Sql Navigator, Putty, OEM, RMAN, EBU, SQL* LOADER, Imp/Exp and Data pump.
Business Objects BO, Crystal Reports 8.0.


Miscellaneous
Sri Software vision is to take the modern technology to a position where it can produce safe and reliable software products and in the process help the country to set a mark in today's Safety-Critical market. The objective of this position was to be involved in various projects and help each team member to come up with solutions in the given time frame.
Responsibilities
Involved in various projects on web applications using Java and JSP
Involved in the analysis, design and development of various projects
Designed use cases using UML and class diagrams using Rational Rose
Debugged and rectified existing bugs
Developed and implemented user interfaces as per prototype
Involved in unit testing and coding automated test scripts
Developed JSP pages to handle contents from forms to retrieve data from the database
Environment : Java, JSP, JavaScript, JDBC, Oracle, PL/SQL, SQL, HTML, DHTML, XML