Satya Amarnath Merugu Professional Summary Satya Amarnath has around 5 years of experience in 24x7 Oracle DBA, on range of Sun Solaris, Windows and Linux platforms. A highly motivated professional and a skilled communicator and a team player. He has expertise in Designing and creating physical/logical data models, Oracle Installation, Database configuration, Administration, Backup and Recovery, RMAN, and troubleshooting of Oracle 9i and Oracle 10g on different platforms covering Red hat Linux, Sun Solaris and Windows. He is also familiar with client-server environments, and scheduling jobs in crontab. He has got expertise in implementing & administering Oracle 10g databases. He has got exposure in 10g RAC and 10g AS. Education Degree University Year of Passing M.Sc.(IT) Vinayaka Mission (Deemed University, Salem) 06/2005 B.Sc Andhra University, Visakhapatnam 04/2001 Certifications Oracle Certified Associate in Oracle 10g. Experience Organization Designation Duration Satyam Computers Services Ltd Senior Software Engineer 01/2008- Till date Patni Computers Systems Ltd Senior Software Engineer 05/2007– 01/2008 Data soft Solutions DBA 01/2007-04/2007 Seven hills Hospitals Ltd Senior DBA 12/2003-12/2006 Technical Skills Operating Systems Sun Solaris, Linux, MS-DOS, Windows NT, 2000,XP, 98 Languages PL/SQL, SQLPLUS Databases Oracle 10g, 9.2 Utilities SQL*Loader, Import, Export, SQL*Plus Tools D2K Forms/Reports 6i, PL/SQL, SQLPLUS, TOAD, Oracle Db10g Express Edition, Informatica, Crystals Reports V10, OEM, Oracle Times ten. Domain Knowledge Health Care ERP HMS (HOSPITAL MANAGEMENT SYSTEM) Trainings Sl# Title Location Organized by Duration 1 Green Belt Visakhapatnam Six Sigma 2006 2 Oracle DBA 9i Visakhapatnam Data Soft Solutions 2004 3 Oracle DBA 10g Visakhapatnam NK Computers 2006 4 Higher Dip in S/w Eng Kakinada APTECH 1998-2001 Projects Profile 1. Project : Zain BI Solutions Client Zain - Bahrain Role Team Member. Organization Satyam Computers Services Ltd Duration 03/2008 to till date Environment Database : Oracle 10g O/s : Sun Solaris 5.9 Project Description: Zain (formerly MTC) is the pioneer of mobile telecommunications in the Middle East and now a major player on the African continent. Zain began life in 1983 in Kuwait as the region’s first mobile operator they have expanded rapidly. The objective of this Dataware house is to implementing a best of the breed telecom BI packaged solution (Satyam’s iDecisions™ framework) in the areas of Customer Intelligence, Sales Intelligence and CDR Analysis. In addition to this a Churn Prediction (data mining) solution is also part of implementation. Role: * Installation and Configuration of Oracle Software on Sun Solaris. * Installation Oracle Client S/W and Configuring TNS entries. * Creating Production Database, Tablespaces, Schemas, Schema Objects. * Involved in Table Partitioning and Tuning Procedures. * Involved in Database and SQL Tuning. * Loading historical Data to Production Database. * Optimization and Troubleshoot of various databases (Test and Staging). * Refreshing data using Export and Import for test and staging environments. * Configured and Designed RMAN backup strategy for Production database. * Scheduling Cron jobs for table partitioning. 2. Project : Satyam Internal Support Client Satyam Internal Role Team Member. Organization Satyam Computers Services Ltd Duration 01/2008 to 03/2008 Environment Database : Oracle 10g,Oracle 9i O/s : Sun Solaris 5.9 Role: * Installation of Oracle Software on Sun Solaris. * Configured and Designed RMAN backup strategy for various databases. * RAC Installation on Sun Solaris. * Data guard Implementation on Linux. * Involved in refreshing databases as per the requirement. * Upgrade Oracle 9i to 10g. * Exposure on Oracle Application Server. 3. Project : GE-CPS – vPayments Client GE-Money (America) Role Team Member. Organization Patni Computers Systems Ltd Duration 11/2007- 01/2008 Environment O/s : Sun Solaris 5.8 Database : Oracle 10g,Oracle 9i Project Description: This project is to administer and monitor the vPayments database of GE Money. vPayments is the facility that GE Money provides to its customer. In this customer does not have to carry the card all the times. Just by remembering the card number and secured pin number customer can do the transaction. Role: * Installation of Oracle Software, Database Creation and maintenance. * Monitoring the offshore databases for various applications. * Managing privileges and roles to ensure database security. * Handling Database change request from the application developers on need basis. * Tablespace creation and adding datafiles to the database as database grows over a period of time. * Troubleshooting database problems faced by the application developers/users. * Performing database recovery as and when required. * Developed a strategy for BCP/DRP solutions (Business Continuity Plan & Disaster Recover Plan) as part of High availability. * Database Space management. * Involved in refreshing databases as per the requirement. * Involved in maintaining & updating the database documentation. 4. Project : bMobile Client Coco Cola (Austria) Role Team Member Organization Patni Computers Systems Ltd Duration 05/2007- 10/2007 Environment Database : Oracle 10g,Oracle 9i O/s : Windows, Linux Project Description: The project is related to mobile billing that coco-cola provides to its customer. All the dealers or retailer carry the handlers and give the bill to the customer at the spot. Later all these bills will be consolidated and inserted into the database system. Role: * Creating the Server and History Databases for ORACLE 10G. * Batch Scripting and Shell Scripting for Database creation and Schemas. * OEM Configuration in 10G for Windows and Linux. * Created and implemented Backup and Recovery Scripts. * Upgrade from 9i to 10g. 5. Project : Database Support Client Kalaniketan Shopping Mall Role Senior DBA Organization Data Soft Solutions Duration 01-2007 to 04/2007 Team Size 4 Modules: Payroll, Inventory, Administration,Registration Environment Languages : Sql, Pl/Sql Database : Oracle 10g O/s : Windows, Linux GUI : D2k Forms, Reports Project Description: Managing the database of shopping mall and providing services. Role: * Creating and designing the Logical and Physical Databases as per the requirements and specifics tailored to the Projects needs. * All DBA tasks. * Designing and planning the database and Application. * Creating documentation of the database environment. * Creating code for Oracle Forms, Reports and tests it. * Involved in designing of front-end application and generating of forms and report for this Organization. * Does the feasibility study like developing the Oracle forms; reports then design flow charts, proto types, database tables etc. 6. Project : Hospital Management System Client Seven Hills Hospitals Ltd Role Senior DBA Organization Seven Hills Hospitals Ltd Duration 12/2003 – 12/2006 Team Size 4 Modules: Payroll, Inventory, Administration,Registration Environment Languages : Sql, Pl/Sql Database : Oracle 10g O/s : Windows, Linux GUI : D2k Forms, Reports Role: Senior DBA * Daily maintaining Logical Backup, Weekly once online and monthly twice offline Backups. * Data guard Configuration. * Performance and Tuning at OS, RDBMS and SQL levels. * Adjusting extent size of rapidly growing tables and indexes. * Performing some DBA tasks on daily basis such as checking sessions, security etc. * Checking Procedures, Triggers and alert logs. * Upgrade from Oracle 9i to 10g. * Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database. * Planning and coordinating the testing of the database, software, and application releases. * Involved in system design, development, documentation, maintenance, production and administration of relational databases. * Controls migrations of programs, database changes, reference data changes and menu changes through the development life cycle. * Creating and designing the Logical and Physical Databases as per the requirements and specifics tailored to the Projects needs. 7. Seven hills Pharmacy Centre Client Seven hills Software Solutions. Role Senior DBA Duration 05/2006 -09/2006 Team Size 2 Module: Pharmacy, Administration, Human Resource etc. Environment Languages : Sql, Pl/Sql Database : Oracle 10g O/s : Windows, Sunsolaris GUI : D2k Forms, Reports Project Description: This package is developed to provide solution for Seven hills Pharmacy Centers. Pharmacy Module maintains the details of giving medicines to the Customers. The User Manager module must deal with security through controlling the access to the information available in the application. Any user associated with a user group can access only those screens for which the user group has rights. This Package contains modules – Pharmacy, system admin, HR and Payroll This project was done parallel along with support project of Seven Hills Hospitals Ltd (Sl. No.4) Role: * Database administration includes creation of tablespace, adding data files, periodical backups, and database recovery as needed. * Involved in designing of Tables, Queries. * Creating primary database objects (tables, views, indexes) for application developers. * Export and Import of Database (Table / Database) * Doing a peer review of the Masters. * Created automated scripts by including timers for recording response times, and text checks for confirming the retrieval of the correct page. * Interacted with the developers on application bugs. Personal Details: Name SATYA AMARNATH MERUGU Email Id Satya_merugu@satyam.com Passport No A 6530232 Valid Upto: 11/2008 Location Secunderabad Contact Numbers Home: 9246343393