System Analyst
wipro technologies ltd. (www.wipro.com)
Total years of experience :15 years, 7 months
• Client: Lloyds TSB Banking, UK
• Scope: Individual contribution on the Oracle Design and Building. I am involved in setting up the database as per the project requirement. Test/Development Databases were built as per Lloyds standard with minimal requirement to test and once all the application were tested will go for ELAB (Pre-Prod) and Production environment with a final recommendation based on the project case study and testing results. Worked with the ADM, Testing and Quality Teams on throughout life cycle of the project Gateway 2 sign-off and surrounded the database servers to oracle support team for BAU support.
• Responsibilities:
Installing, Creating and Migrating the Oracle database on 10g Release2 and 11g.
Involved in performing migration from Oracle 8i, 9i, 10g to Oracle 11g Release2 RAC database.
Configuring database entries and monitoring all of the databases
Troubleshooting on the databases for Oracle database related issues.
Developed PL/SQL packages, Oracle tables, stored procedures, functions, Cursors, triggers and UNIX Shell scripts with Business Analyst.
Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE.
Worked on Data transferring with export/import utilities and Data pump.
Database Administration tools like OEM (Oracle Enterprise Manager) and TOAD.
Taking Periodic Backup of the databases and the software using RMAN.
Monitoring and maintenance of multiple databases for production, development, testing and
Staging purposes using utilities like OEM and Toad.
Created database objects like tables, indexes, synonyms, views etc. using SQL* Plus.
Expertise in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, troubleshooting database design, Unix shell scripting, documentation and process of supporting more than a client across.
Client Supporting Description
O2-Ireland, Ireland O2 is the second largest telecommunications provider in Ireland. As the Oracle DBA I am involved in setting up and managing both development and live databases for the client’s core customer account database. The team also involved in maintaining production, development, and testing databases and performs all databases related activity to ensure maximum availability of databases. We also work very closely with the System administration and the accounts management.
QBE, UK It provides a wide range of insurance policies such as Life Insurance, Health Insurance, Motor Vehicle Insurance and General Insurance etc. We are involved in tuning many of these applications by studying the overall system performance and suggest the appropriate suggestions to improve the performance of the Oracle based applications.
Carlsberg, Denmark Carlsberg is foreign direct investment company formed to brew and market Carlsberg beer in Copenhagen, Denmark. I am involved in allocated the system storage and planned future storage requirements for the production database system.
ACI, USA ACI Worldwide is a global provider of electronic payments solutions for the world’s top financial institutions, retailers and payment processors. Our team main task is to support offshore/onsite software services such as application development, deployment and maintenance.
Arla, Denmark Arla Food is the largest producer of dairy products in Scandinavia. Our team main task to support Windows Databases.