Login
English - United Kingdom
Home
Job Search
My JoinVision
Statistics
InfoWorld
Entrepreneur
Expert Profile: xsridhar10
Profile title:
Senior oracle dba
JoinVision-ID:
xsridhar10
Citizenship:
India
Year of birth:
1976
CV
Xxxxxxxx Xxxxxxx Babu
Xxxxxxxxxxxxxxxx 10,Frankfurt, Germany
Mob: +49 017623795228;
Email: x_xxxxxxx@yahoo.com
A methodical and technically adept professional aspiring to utilize process-centered approach and successful experience of 10.5 years in IT Industry (Software Design/Database Development/Database Administration). Seeking assignment as
Senior Oracle Database Administrator(9i,10g)
Oracle Certified Associate 9i
Oracle Certified professional 9i
Passed Oracle 9i pl/sql exam with 97%
Passed oracle 9i sql exam with 98%
Passed Oracle 9i DB Fundamentals 1 exam with 90%
Passed Oracle 9i DB Fundamentals 2 exam with 90%
Summary of Profile
Oracle Certified Database Administrator.
Graduate in Computer Science Engineering.
ITIL v3 Certified.
10.5 Years Experience in Oracle 8i/9i/10g Database Administration, Oracle 8i/9i/10g Database Design & Development, Sqlserver Developer, Sqlserver DBA, Sybase sql anywhere developer,asp ,unix shell and powerbuilder programming. The Last 10 Years I have been an Oracle Database Administrator and Oracle Developer simultaneously supporting sqlserver databases as well.
Solid understanding of Oracle 8i, 9i, 10g Architecture, Concepts and Design.
Creating and Administering Oracle 8i/9i/10g Databases, Environments, Instances and Schemas.
Valid Work permit to work for any employer in Germany
At present Working as a Senior Oracle DBA at the European Central Bank, Frankfurt, Germany.
Was working previously (2001 - 2007), on assignment as an Oracle DBA at Hewlett Packard EMEA GmbH, Munich, Germany.
Very Very fluent in English & Basic German.
Technical Skills
RDBMS/DBMS
Oracle 10g/9i/8i, Sqlserver 7, Sybase sql anywhere.
Tools/Packages
Sqlplus, sqlloader, Toad, Enterprise Manager, RCS, Wincvs, OVSD, Visual Source safe, Visual studio, cmd, Reflexion.
Scripts/Languages
Unix Korn shell, Awk, Html, Asp, PowerBuilder, C#, Java , Solaris 10
Operating Systems
HP Unix 11.0, Windows NT, Windows 95/98, MS DOS, Windows 2003 Server, Windows XP , Solaris 10.
Others
Visio, UML, Internet Information Server.
Professional Experience
EUROPEAN CENTRAL BANK, FRANKFURT, GERMANY.
Senior Oracle Database Administrator (October 2007-Current)
Senior Oracle 8i/9i/10g Database Administrator /Developer.
Responsibilities:
Creating and Administrating Oracle 8i/9i/10g Databases, Environments, Instances and Schemas.
Backing up and Recovering Databases using RMAN, command line as well as customized automated scripts.
Creating Scripts to Automate Database Administration tasks.
Proficient in System Analysis and Tuning of the Oracle Database using Utilities like Enterprise Manager, Alert Log, Trace files, Stats Pack, Tuning Advisers in 10g Enterprise manager, Customized Health Scan Scripts, Explain Plan analysis, customized Stats gathering using different parameters.
Programming customized Data Retrieval Programs using PL/SQL, SQL & UNIX Korn shell using awk etc.
Applying Current Patch and performing Data Migrations.
Creating and Maintaining RAC Databases.
Performing and Assisting with Hardware Planning and Capacity Planning.
Participating in an On-call Rotation Schedule within the DBA group.
Strong customer service orientation; consulting with customers for resolving business escalations, problems and advising better standards in Database design, backups design , sql query tuning etc.
Managing multi terabyte oracle production and Development databases.
Accomplishments:
Developed best practices framework for all DB administration activities.
ITIL Certified.
HEWLETT PACKARD EMEA GMBH, MUNICH, GERMANY.
Senior Oracle Database Administrator (August 2001- September 2007)
August 2001 - September 2007
Senior Oracle 8i/9i/10g Database Administrator /Developer.
Responsibilities:
Creating and Administrating Oracle 8i/9i/10g Databases, Environments, Instances and Schemas.
Backing up and Recovering Databases using RMAN, command line as well as customized automated scripts.
Creating Scripts to Automate Database Administration tasks.
Proficient in System Analysis and Tuning of the Oracle Database using Utilities like Enterprise Manager, Alert Log, Trace files, Stats Pack, Tuning Advisers in 10g Enterprise manager, Customized Health Scan Scripts, Explain Plan analysis, customized Stats gathering using different parameters.
Programming customized Data Retrieval Programs using PL/SQL, SQL & UNIX Korn shell using awk etc.
Applying Current Patch Sets (Recent US Daylight Savings Patches etc) and performing Data Migrations.
Creating and Maintaining Primary and Standby databases.
Creating and Maintaining RAC Databases.
Creating and maintaining agents in Enterprise Manager.
Creating and maintaining targets through Enterprise Manager.
Performing and Assisting with Hardware Planning and Capacity Planning.
Participating in an On-call Rotation Schedule within the DBA group.
Strong customer service orientation; consulting with customers for resolving business escalations, problems and advising better standards in Database design, backups design , sql query tuning etc.
Designed the Database for HP's Pricing System which included different stages right from ER diagram creation, physical database objects creation, encapsulating business logic in stored procedures, views, triggers ,packages etc.
Manage a team of offshore DBA's in Bangalore, India.
Accomplishments:
Consistently received the highest performance ratings in the organization.
Implemented RMAN backups for all Mission Critical Applications in place of the cold backups used earlier by previous DBA's.
Implemented Standby database for reporting purpose for HP's Siebel Application and as a fail over when issues with the primary rarely.
Have put standards in Place for Applications teams to design their SQL's, for backups, for logs, tracefiles clean up, statistics gathering, proactive monitoring of instance health.
February 2001 - July2001
Oracle DBA for development and test databases,Power builder, ASP, Sqlserver programmer / Sqlserver DBA, Oracle Developer
Responsibilities:
Developing and Designing GUI Modules using Power builder along with using PFC's.
Developing Business Logic modules using sqlserver stored procedures, triggers etc
Maintaining Development and Test Environment Sqlserver databases, creating new test databases, managing users, data loads with DTS, and backups of the databases.
Managing the code versioning environment using Wincvs.
Creating and maintaining WEB Applications using ASP, Javascript, and VBScript.
Maintaining Business logic of the WEB Application in Oracle Stored procedures and modifying existing Business Logic in the stored procedures. Oracle database administration for the test and development servers.
Managing and creating existing data feed interfaces between different applications using java, UNIX and sqlloader.
DEDUCO SOFTWARE SYSTEMS PVT LTD, BANGALORE, INDIA
Software Engineer (April1999 - January2001)
Responsibilities:
Developing GUI Screens using Power builder 6.5 .Developing Customer Reports using Info maker with sybase sql anywhere. Using PFC's for certain Business core modules.
Oracle stored procedures development and administration for 8i development and test databases.
Assisted and supported the team in understanding the customers need in designing, developing and implementing systems.
Implemented quality processes for the projects in creating and maintaining the software requirements documents, software design documents, test cases and test plans.
Accomplishments:
Selected as the best employee of the month.
Received highest performance rating.
Attended many technical conferences held by SYBASE and ORACLE.
Attended Quality Based Courses and seminar.
Also associated with...
CAE systems pvt ltd , Visakhapatnam, India as Software Trainee (Aug 1998 - March 1999) as trainee power builder programmer and oracle 8i developer.
Projects Undertaken
PROJECT: Database Administration for HP Mission Critical Applications.
Client: Hewlett Packard EMEA
Period: August 2001 till September 2007; Team Size: 6
Role: Senior Oracle Database Administrator 8i/9i/10g
Environment:
Database: Oracle 8i, 9i, 10g
Administration & Development Tools: Toad, Sqlplus, Enterprise Manager, Visio, Unix Korn shell.
Operating System: HP-UX 11.00, Microsoft Windows 2003 Server
Description: This Project is a Continuous Project to make sure that all HP's mission critical databases are proactively monitored, maintained and Available 24/7.
Responsibilities: Was Responsible for All Database Administration Activities for many Mission Critical Applications like HP Siebel word wide, HP World wide financial claims, and HP List Pricing Tool etc. Have tuned majority of these databases solving issues with busy buffer waits, cache chain buffers, hot index blocks, tablespace fragmentation, index fragmentation, wrong histograms, stale statistics, tuning wrongly designed queries, adjusting index caching parameters, adjusting optimizer parameters etc, taking stats pack snapshots at different time intervals, maintaining customized health scan scripts. Have created 2 instance RAC databases in Oracle 10g, migrated databases from 9i into 10g. Upgraded databases from 9i to 10g, applied lots of patches including the recent day light savings patch applied in march 2007, created primary and standby databases for the Siebel Application, configured RMAN backups both onto disks and tapes in 10g, configured agents on the servers for pro active incident creation through enterprise manager, have recovered databases from single data file corruption errors to media failures. Worked on configuring hot backups in place of cold backups and in some very less critical applications used cold backups depending on the business need for recovery time frame. Also designed the whole database for HP list pricing engine by creating the initial ER diagram, creating all tables, procedures, functions, packages, UNIX shell scripts, sequences, triggers, types, using analytical functions like partition by etc. Have proactively forecasted database growth, assigning proper space to different mount points on the UNIX machine, creating cron jobs, creating oracle jobs using dbms_job. Migrated databases from 8i to 9i and then to 10g .Have resolved performance issues with Rman catalogs etc.
PROJECT: GENEPI PRICE WEB Application
Client: Compaq Americas
Period: March 2001 - July 2001; Team Size: 6
Role: oracle developer, asp developer, oracle dba
Development Environment:
Database: Oracle 8i/9i
Design tools: Visual Source safe, ASP, Java, TOAD, sqlplus, enterprise manager
Operating System: HP-UX/Windows Server 2000 Enterprise Edition
Description: GENEPI is a web based List PRICE Builder Tool used for list pricing Compaq's servers, notebooks, handhelds, and workstations.
Responsibilities: very Strong Skills in Oracle 8i/9i database administration and PL/SQL programming (triggers, functions, procedures, views), Complex Queries using Oracle internal functions like Partition by etc. Database Import, Export and other administration activities, tuning on the development and test environments,migrating from 8i to 9i etc. UNIX scripts for scheduling Oracle Jobs. Oracle Instance was on HP-Unix 9000 Server, Oracle 8i. I was the complete Owner of database design for our new Pricing Project with team strength of 6.I had Liased with the Business users, understood the specifications, Read the BRD and designed all relevant tables. Normally i had followed all the normalization concepts but where required i had denormalized the tables keeping in mind the case by case need. I had written lot of stored procedures, functions, triggers to encapsulate the business logic. Our application GUI is on ASP. All the queries which should be called from the GUI have been written by myself and gave to the GUI developers. So in a nutshell I was the Main database guy in the team to help them in all DB related matters. For example when a Database Refresh needs to be done on the Integratión Environment with the Production Data, its my responsibility. If some body had any issues with the query performance or a bug then its my responsibility. I was also the team lead for the Indian Offshore team liasing between them and the business users. Maintained legacy applications in ASP by developing asp webpages and bugfixing.
PROJECT: COMPAQ PRICE LIST- CPL
Client: COMPAQ EMEA
Period: February 2001 - July 2001 (Development); Team Size: 5
Role: sqlserver developer, sqlserver dba , power builder programmer
Development Environment:
Database: MSSQL Server 7, PowerBuilder 7
Design tools: Microsoft Visio, Power builder, PFC
Web Server: IIS 4.0/5.0
Operating System: Windows 2000/Windows Server 2000 Enterprise Edition
Description: CPL is Compaq's Pricing Application. Customers use to List Price and Analyse past pricing trends using this tool. CPL used to send the List Prices to Compaq's SAP system. CPL also used to generate lot of customer reports used for communication with higher management.
Responsibilities: Responsible for Requirements Gathering and Analysis, Proof of Concepts, Prototyping, Architecture and Implementation. Responsible for High Level Architecture and Low level Architecture including Object Modeling and Data Modeling. Testing coordination. Release Management and coordination with various teams involved in the release. Data Maintenance using DTS Packages, performance tuning and Problem Solving for data errors and Application Errors. Writing complex queries that are used to generate. Analyze, design and implementation of new features for CPL. Set up and maintenance of various Test instances of CPL for Trade Customers and HP IT Delivery teams. Provide 3rd Level Support of the application; Documentation and User Guide Preparation. I have also shown initiative in solving problems without being asked and there are many instances when I saved lot of time for customers...be it a long running stored procedure or some application problem. I also took care of Production servers, creating, deleting databases, maintaining user permissions. .and where required I have documented processes so as to enable others to work smoothly. Because of my initiative, hard work and good analytical skills I was esteemed very much in the organization.
PROJECT: SALES FORCE
Client: Nestle, Belgium
Employer: Deduco Software systems Pvt Ltd, Bangalore, India.
Period: April 1999 - January 2001; Team Size: 6
Role: Software Engineer
Development Environment:
Powerbuilder, PFC, Sybase Sql anywhere,oracle developer,oracle dba.
Description: SALES Force was a PDA based tool used by sales representatives of Nestle to list down the inventory of nestle products with all distributors and super markets, analyzing the data, creating reports etc.
Responsibilities: Team Member of the development team involved in creation of business modules with Power builder 6.5/7 and stored procedures in sybase sql anywhere. The new version was migrated to power builder pfc and oracle. Was involved in administration design and development of the test and development oracle databases for the new version. Was also creating complex reports using sybase info maker. Was creating software specifications document, software design document, test cases , code review, commenting and explaining the code etc.
Trainings Attended
Lot of oracle trainings over the years and ORACLE 10g New Features for Administrators , February 2007.
ITIL v3 , Darmstadt,Germany April 2008.
Programming in Java
Programming in Power builder & PFC's
Communication Skills
Educational Qualification
B.E (4 Year Bachelor Degree in Computer Science & Engineering), Nagarjuna University,India (1998)
Personal Particulars
Date of Birth: May 10th 1976
Languages Known: English, German, and Telugu
Current Address: Mailander Str 10, 8th floor, Frankfurt-60598, Germany.
Permanent Address: 2-171, Indira Gandhi Nagar, near old Dairy farm, Visakhapatnam.A.P.India
preview of the first page of the CV
Experience Profile
Field of activity
Experience [years]
Produktmanagement/Support
0.1
Quality Management
0.2
Software Development
1.7
Systemadministration/Betrieb
8.0
Skill
Experience [years]
Oracle
8.0
Unix General
4.3
SQL
4.0
PL/SQL
4.0
MS SQL Server
0.4
ASP
0.4
VBScript
0.3
JavaScript
0.3
Java
0.2
Career aspiration
Type of occupation:
Regular employee or Freelancer
available from:
01/05/2009 at 100 %
Desired position(s):
Co-worker
Desired field of activity:
Systemadministration/Betrieb
Mobility:
low
Assignment location:
Germany