Ask Question / Post resume

Post a reply to the thread: www.silverlinktechnologies.com Silverlink Technologies United Kingdom (U.K) : Oracle DBA RAC, Pl / SQL, RMAN

Your Message

Your Username:

Click here to log in

Notes:-
1) You can copy and paste your full resume in the box below.
2) Or you can ask your question. We try to answer, as far as possible.

Title:

[QUOTE=Guest;144814]Lalitha Margana 
 
 lalitha.valli2008 AT gmail.com 
 
Professional Summary
- Having 9+ years of total IT Experience and 5.1 years of experience as Oracle DBA and 2 years of Sql server DBA. 
- Experience on physical and logical model DB design
- Handled large databases (~ 1 TB), tuning SQL Queries and improving performances of the Databases on OLTP/OLAP
- Responsible for providing 24x7 on-call support to production environment customers. 
- Possess UNIX, Linux Knowledge.
- Having good experience in installing Oracle software, creating databases, managing archive log files, tablespaces, extents, optimizing queries.
- Good experience on Installation & configuration of Oracle 9i, 10g and 11g on Solaris, Linux and windows 2003 server platform.
- Good knowledge in performance tuning activity and Database maintenance and troubleshooting.
- Having self-disciplined, team work, ability to learn quickly & problem solving skills.
 
Functional Skills
- Adminstering tasks on Oracle single instance and RAC instances
- Checking whether all Databases/Listeners are available and running.
- Checking of Oracle alert logs and see whether there are any oracle errors requiring action.
- Monitoring of Oracle load, User sessions and Long running operations on the oracle server.
- Monitoring Oracle backup schedule and completion of backup activity.
- Routine checking of backup logs of previous day.
- Monitoring archived logs generation and backup of archived log files to tape.
- Maintaining the Disaster Recovery Oracle Database Server at remote location through synchronization of archived logs on Production Server and DR server by auto/manual.
- Maintaining/Monitoring the Oracle Standby database.
- Creation of Users, Grant of necessary Roles/Privileges and allocation of tablespaces.
- Uploading of flat files into oracle tables through SQL Loader.
- Checking Tables/Indexes which needs more extents and to allocate space/reorganize/rebuild.
- Temporary allocation / de-allocation of tablespaces to users for large table/index management.
- Backup/Restoration/Recovery and Export/Import of Oracle Database.
- Export/Import of Oracle tables/users as required from historical backup tapes.
- Database/Schema/Table Refresh for Testing Database.
- Monitoring and administrating SQL server databases using Sql Server Management Studio.
- Scheduling backups for Sql Server Databases using Sql server Agent.
- Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor using Sql server Management Studio.
 Career Synopsis
iPERINTIS sdn bhd ( Malaysia ) (FROM FEB 2011 TO TILL DATE)
[b]Environment [/b]: RHEL 4.0, 5.2, Oracle 10g (10.2.0.4), Solaris 8, 10, Oracle 8i,11g (11.2.0.1),Windows 2003,Oracle 9i, 10g.
[b]Responsibilities (Production DBA) [/b]:
- Handling Tickets on priority basis and meeting the defined SLA’s., security patches, Hot Fixes and upgrades on production Boxes on regular basis & co-coordinated testing efforts with Application Code owners.
- Setup, configure and install Oracle10g RAC on RHEL 4.0 for new customers.
- Monitoring, supporting existing databases on Solaris.
- Standby databases setup and implementation.
- Monitoring Oracle RAC instances.
- Rebuilding indexes online.
- Performed Performance Monitoring & Tuning, analyzed Query Execution Plans and created Indexes for performance.
- Diagnosing the bottlenecks and problems which cause poor performance
- Monitoring tablespace growth, invalid objects and Capacity planning.
- Re-org and Re-build of the indexes.
- Table reorgnization
- Web cache administration
- Troubleshot the connectivity from the Application to Database.
- Performing daily health checkups.
Xinthe Technologies Pvt Ltd , AP (FROM MAR 2008 TO DEC 2010) 
[b]Role [/b]: DBA
[b]Environment [/b]: Redhat Linux 5.2 server, Oracle 10g ,9i,11g, SQl server 2005,2008.
[b]Responsibilities [/b]:
- Involved in gathering business requirements from customer and creation of Software Requirement Specifications (SRS), SSFD documents.
- Communicates Architecture to Development
- Creating physical and logical models using DB visual architect
- Installed Oracle10g RAC (2-node) and configured on DELL servers (DELL PE 2950) on windows 2003 server.
- Creation of physical database design (schemas, tables, columns) from logical model.
- Create functional and technical design documents for the database
- Administering oracle RAC database instances, external storage (Dell MD 3000) 
- Coordinating with Development team.
- Applying CPU patches every quartely.
- Designed backup strategy, configured weekly full backup using OEM.
- ASM management, Test document creation and deliverables check.
- Design, develop, test and document software.
- Capacity planning for the project.
- Writing stored procedures, triggers, functions and views Documentation of the database layer
- Design and Implemented Backup strategy
- Setting up Production, Testing and UAT Environments
- Analyzing tables on a regular basis for performance.
- Responsible for resolving connectivity problems with Oracle database.
- Running tkprof, explain plan for performance issues 
- Designed proper indexing strategy on tables for optimal performance.
- Allocating system storage and planinig future storage requirements for the database
- Verifying the tape backups
- Verifying index usage
Symphony Services PVt LTD Bangalore (FROM JUNE 2006 TO FEB 2008) 
[b]Role [/b]: DBA
[b]Environment [/b]: 64 Bit UNIX, Oracle 8i/9i/10g , Win 2003 server, SQl server 2005.
[b]Responsibilities [/b]:
- Studies and Understands Business Needs
- Gather requirements and document.
- From the business model (logical) create physical DB design 
- Setting up Production, Testing and UAT Environments
- Installed Oracle 10g on Windows 2003 Server (Dell Servers)
- Monitoring Oracle RAC instances.
- Granting and revoking accces to users
- Creating Database and configuring listeners 
- Putting DBs from no archive log mode to archive log mode
- Upgrading from Production DBs from 10.2.0.3 to 10.2.0.4
- Installation and configuration of Oracle 10g AS (portal) on 2 nodes.
- Installation and administration of Weblogic 814 Web server for Pharmacovigilance Application
- Monitoring application/ server logs.
- Database Performance analysis at Application/Database level
- Running Statspack and tkprof for performance issues.
- Installing, configuring Veritas Net backup to backup oracle data, SAP data.
- Monitoring VMSTAT, IOSTAT, SAR reports on HP-UX V11.
- Configuration of Recovery Manager (RMAN) to perform backup, restore, and recovery operations 
- Loading of text files into oracle table by sql loader
- Creating primary database objects (schemas, tables, columns)
- Worked as an Application Developer.
- Creation of Tables, space management.
- Conversion DMT to LMT
- Installations of MS SQL Server2005 database server and creating new databases. Applied patches and service packs to keep the database at the current patch level. 
- Exposure in Database Cloning.
- Monitoring table growth and usage patterns.
- Experience in Data Modeling (Logical & Physical design of DB) , Normalization and building Referencial Integrity Constraints.
- Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor using Sql server Management Studio.
- Experience in Database Backup and disaster Recovery procedures.
BSNL, A.P (FROM JAN 2005 TO MAY 2006) 
[b]Role [/b]: Infrastructure, System Administrator
[b]Responsibilities [/b]:
- Install and support both server and desktop software
- Installing windows server 2003 operating system on Dell servers.
- Coordination with Hp staff for installation, configuration blade servers.
- Creating users in Active Directory
- Verify user account configuration
- Troubleshooting Desktops, servers and resolving issues.
- Raise tickets for vendors to replace faulty hardware equipment.
- Install Patches and Hotfixes
- Deploying Business/corporate portals on Oracle 10g AS.
- Web cache administration (User accounts,LDAP user creation)
- Monitoring application server homes OHS_1, OHS_2 logs/ server logs.
- Weekly backup of oracle9i AS and oracle10g AS files.
- Running Statspack and tkprof for performance issues.
- Installing, configuring Veritas Net backup to backup oracle data, SAP data.
- Monitoring VMSTAT, IOSTAT, SAR reports on HP-UX V11.
- Administering Day to Day operations (Backup , User management), Verify that a successful backup of system and data files has been completed
- As a Technical Support Engineer, I’m responsible for maintaining PC terminals and workstations in the Company. Assist in software installation and configuration.
- Installing/upgrading/removing software - OS (kernel patches, new device drivers, ...), applications (new versions, DLLs, new configurations), documentation
- Daily checking disk space, usage levels, generating system reports and anticipating growth (bdf).
Trainings Undergone
- Oracle10g Real Application Cluster
Education 
- Bachelors degree in Computer Science from Andhra University.
Highlights of achievements
 - Certified in Oracle9i database (OCP).[/QUOTE]

All times are GMT +5.5. The time now is 10:51 AM.