Billy Moses Email & Phone Number

Hyderabad

Comprehensive database management

Hyderabad

Overall 3 years of experience as an Apps DBA in Administration and support of Oracle E-Business Suite 11i Applications consisting of multi-tier architecture. Expertise in Single-node and Multi-node installation on LINUX platform, patching, and cloning. Expertise in Oracle Applications upgradation, technology-stack and RDBMS up-gradation. Patching for up-gradation and bug-fix using Adpatch. Knowledge on Oracle 9i/10g databases, Creating and Managing databases, Security/user management and Administration, Creating user accounts and granting Privileges. Knowledge in hot and cold backups. Ability to quick-grasp of new concepts and apply software methodologies as per business needs. Objective oriented approach in work management and flexible in realizing the goals. Analytical and well managing intra-personnel skills for common goals. Strong belief in inter-dependency for productive outputs.

Project Name : Maintenance and Support of Oracle Applications 11iEnvironment : E-Business Suite 11.5.10Database : Oracle 9.2.0.5Operating System : Red-Hat Enterprise Linux 4.0Role : Oracle Apps DBAClient : Procter & Gamble Hygiene and Health Care Ltd., Duration : May 2010 to till date

Checking the status of important services like concurrent manager, form server, web server, application listener, database listener are upUsed FNDCPASS to change passwordsResetting the user's passwordsUsed AD administration utilities (adpatch, adadmin, adctrl, adbldxml, adsplice, etc.,)Patching for adding new feature, bug-fix, documentation issues, testing by using AdpatchTracking invalid objects, compiling and validating the invalid objects using adadminTroubleshoot user issues like apps login issues, .dbc file issuesMonitoring tablespaces running short of free space, resizing or adding datafilesConfigured Autoconfig for Oracle Applications system maintenance Check the versions of required software'sPerform log files checking up and event monitoringCreate and Manage Application Users, assigning Responsibilities and user profiles Manage and Monitor Concurrent Jobs and Application UsersDefining and Administering of Concurrent ManagersProvided 24x7 apps dba support during the support phaseTaken backup by various backup strategies using hot backup and cold backup.Project # 2:Project Name : Maintenance and Support of Oracle Applications 11iEnvironment : E-Business Suite 11.5.10Database : Oracle 9.2.0.5Operating system : Red-Hat Enterprise Linux 4.0Role : Oracle APPS DBA

Cloning of applications from PROD to TESTCreating a copy of the production system for testing patches and troubleshooting issuesPerformed Oracle Application 11.5.10 cloning using rapid clone.Applied as Patch Applications.Migrating an existing system to new hardwareCreating a stage area to reduce patching downtimeCreating a development copy of environmentCreating a test copy of production system before upgradingRunning Pre-Clone scripts on source node Backup of Oracle database and applications file system from the source node Running the Post-clone scripts on target nodeUsed FNDCPASS to change passwordsConfigured Autoconfig for Oracle Applications system maintenanceTroubleshoot relating issues of Concurrent ManagersResolved the view log/out files apps issues

As a system administrator, I will be responsible for•Deployment/Troubleshooting on MS Windows Server 2000 /2003 environment, Antivirus like McAfee and AV•Setting up servers•Setting up of working e-mail accounts and mailing lists•Management and integration of databases•Implementing security on the intranet/extranet•Setting up of firewalls and authorisation systems•Performing periodic backup of data and automating reporting tasks, and executing hardware and software updates when necessary•Incorporating new, and upgrading existing systems•Administering the network•Allot IP addresses to each employee and ensure that the network runs seamlessly

Installation and troubleshooting of Windows Operating Systems and Application software's keeping them up-to-date and keep running properly on a day-to-day basisADMINISTRATION AND MAINTENANCE OF DOMAIN OVER 2 SERVERS, 45 DESKTOPS AND 4 LAPTOPS IN LANOBSERVATION OF NETWORK, INTERNET CONNECTIVITY, EVENT VIEWER AND AUDITINGInstallation, Configuration and Maintenance of Windows 2003 ServerConfiguration and Maintenance of Active Directory and Managing its ComponentsImplementing of Domain Users, Groups and OU'sImplementing user profiles/permissions for secure the networkImplementing scripts and group PoliciesImplementing Map Network Drives for accessing shared foldersConfiguration and Troubleshooting of MS-Outlook and Outlook ExpressImplementation of Remote assistanceAdministration of McAfee Antivirus Corporate edition in the LANImplementing of Network Shares and Permissions in the secure wayINSTALLATION AND CONFIGURATION OF PRINTERSImplementing of Backup, Recovery and Restoring Data

B.Com (Computer Applications), Commerce, Accountancy, English, It

B.Com, Computer Applications