www.silverlinktechnologies.com Silverlink Technologies United Kingdom (U.K) : Oracle DBA RAC, Pl / SQL, RMAN

[mskavi]

Silverlink Technologies United Kingdom (U.K) : Onsite requirement for Oracle DBA
Website: http://www.silverlinktechnologies.com

Keywords: Oracle DBA, RAC, Pl / SQL, RMAN

Designation: Onsite requirement for Oracle DBA
Experience: 5 - 10 Years
Location: United Kingdom (U.K)

Job Description:
Candidate need to have good exp in Oracle DBA activities like ASM, AWR, Statspack, Standby database, RMAN, Batch proscessing, Patch Management, Grid control.Should have exposure on Pl/SQL.

Desired Candidate Profile:
He need to join in 1Month time.
Ready to relocate to UK.

Company Profile:
Silverlink Technologies is a global IT consulting and technology services company offering industry-specific solutions, strategic outsourcing, and integration services through a unique on-site, off-shore delivery model that helps our clients to achie

Email Address: meghnad@silverlinktechnologies.com

[Guest-IJT]

Name : sandeep kumar singh
Email : sandeepkumarsingh70 AT gmail.com
Designation / Skillset : Asp.net,c#,sql server
6 Month experience

Resume :
SANDEEP KUMAR
SINGH

Interests
Net Surfing,Playing cricket
Strength

Stability under pressure, Adaptability, Self Motivation
a
Career Objective :
Looking for an entry into a highly professional organization with challenging and competitive environment, where I can use my knowledge base as well as personal attributes to achieve the organizational goal and develop my IT skills.
Professional Qualification :
*Master In Computer Application(M.C.A.).
*Post Graduate Diploma In Computer Application(P.G.D.C.A.).
Key Skill :
Programming Languages :
C, Data Structure, ASP.Net,C#.Net.
Database :
Oracle 9i,10g,SqlServer2005,2008,MSAccess.
Projects :
1.GLOBAL COURIER SERVICES(FrontEnd :asp.netBackEnd:SqlServer2008)
2. TAXI SHARING SYSTEM(FrontEnd :asp.net BackEnd:SqlServer2005).
3. FRONT DESK (FrontEnd :WindowFormApplication BackEnd:MS Access).
Summer Training and certificates :
6th month Industrial Training From CMC India Pvt. Ltd. Noida on .Net.
90 hours Training of ASP.Net ,C#.Net from HP(2010).
Diploma in Advance Programming From MANIPAL UNIVERSITY(Distance).
Academic Records :
Level Year of Passing Board/University Division Percentage
MCA 2011 UPTU 1st 72.57%
B.Sc(PCM) 2007 CSJM Kanpur 2nd 52.22%
12th 2003 UP Board 1st 65.2%
10th 2001 UP Board 2nd 51.33%
Industrial Visit:
1. R.System Noida,the leading multinational company.
2. Parle-G Bhadhurgarh.
Achievements
- Paper is selected in National Conference on Cloud Computing & Challenges conduct by Institute of Management & Research Ghaziabad in 2009.
Date: (Signature)
Sandeep Kumar Singh
-------------------------------------------------------
More Information about this submission and submitter:-
___________________________________________________
Submission ID : 4328823
Date & Time : 4th Jul 2011 1:45 PM (UTC)
IP Address : 118.94.40.112
Browser Info : Mozilla/5.0 (Windows NT 5.1) AppleWebKit/534.30 (KHTML, like Gecko) Chrome/12.0.742.112 Safari/534.30
Predicted Country : India

[Guest]

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)
Environment : 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.
Responsibilities (Production DBA) :
- 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)
Role : DBA
Environment : Redhat Linux 5.2 server, Oracle 10g ,9i,11g, SQl server 2005,2008.
Responsibilities :
- 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)
Role : DBA
Environment : 64 Bit UNIX, Oracle 8i/9i/10g , Win 2003 server, SQl server 2005.
Responsibilities :
- 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)
Role : Infrastructure, System Administrator
Responsibilities :
- 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).