Name  M.S.AMARNATH
Professional Summary
5+ Yrs of experience in handling DBA related activities and PLSQL Application Development. Installation of Oracle Database for the Production environment on Solaris and Windows 2000.Responsible for upgrades of Oracle Database on Solaris and Windows base. Creation of Database Stored Procedures functions and triggers. Database administration includes creation of tablespace, adding data files, periodical backups, and database recovery as needed. Creating and designing the Logical and Physical Databases as per the specific needs. Creating primary database objects (tables, views, indexes) for application developers. Export and Import of Database (Table / Database). Planning hot and cold backup strategies. In addition, support numerous Production database backup and recovery scenarios using RMAN utilities. Analyzing redo logs using log miner. Administration of the development databases on a day - day basis. Involved in complete and incomplete recoveries on multiple tasks. Good knowledge on performance tuning. Expertise in supporting Large Application Production systems. Handling the database administration activities for 100GB+ data. While establishing new medical shops of our hospital, as an Administrator, I have implemented Overall Project review and designed. Since we are setting up a new hospital at Mumbai, as an Administrator I have created the database and designed the project, participated in creating and implementing of schemas, database objects, system designing, Preliminary investigations, Recovery and other DBA tasks.

Education

Degree	University	Year of Passing	
M.Sc.IT	VINAYAKA MISSION'S RESEARCH FOUNDATION DEEMED UNIVERSITY (VMRF-DU), SALEM	2005	
B.Sc	ANDHRA UNIVERSITY, VISAKHAPATNAM	2001	

Experience

Organization	Designation	Duration 	
Seven hills Hospitals Ltd	Senior DBA	Aug 2003-Dec 2006	
Srinivasa Hi-tech Systems	Programmer/Junior DBA	Jul 2001-Jul 2003	
Technical Skills
Operating Systems	Sun Solaris, Linux, MS-DOS, Windows NT, 2000,XP, 98	
Languages	PL/SQL, SQLPLUS	
Databases	Oracle 10g, 9.2	
GUI	MSOffice	
Utilities	SQL*Loader, Import, Export, SQL*Plus	
Tools	Developer 2000, Reports 6i /Forms 6i, PL/SQL, SQLPLUS, TOAD, Oracle Database 10g Express Edition, Informatica.	
Domain Knowledge	Health Care 	
ERP	HMS (HOSPITAL MANAGEMENT SYSTEM)	

Trainings 
Sl#	Title	Location	Organized by	Duration	
1	Green Belt	Visakhapatnam	SIX-SIGMA	2006	
2	CIOL Group IT Award	Visakhapatnam	CIOL GROUP	2005	
3	Oracle DBA 9i	Visakhapatnam	DATA SOFT SOLUTIONS	2004	
4	Oracle DBA 10g	Visakhapatnam	NIMAI KRSNA COMPUTERS	2006	
5	Higher Diploma in Software Engineering	Kakinada	APTECH	1998-2001	
6	Type writing in Higher and Lower	Kakinada	SBTET	2000-2001	

Organization: Seven hills Hospitals Ltd

ROLE:  Senior DBA

1.	Daily maintaining Logical Backup, Weekly once online and monthly twice offline Backups.
2.	Data guard Configuration, Recovery Manager (RMAN) deployment.
3.	Performance and Tuning at OS, RDBMS and SQL levels.
4.	Adjusting extent size of rapidly growing tables and indexes.
5.	Maintaining archived Oracle data.
6.	Performing some DBA tasks on daily basis such as checking sessions, security etc.
7.	Checking Procedures, Triggers and alert logs.
8.	Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
9.	Planning and coordinating the testing of the database, software, and application releases.
10.	Creating documentation of the database environment.
11.	Involved in system design, development, documentation, maintenance, production and administration of relational databases.
12.	Controls migrations of programs, database changes, reference data changes and menu changes through the development life cycle.
13.	Creating and designing the Logical and Physical Databases as per the requirements and specifics tailored to the Projects needs.

Organization: Srinivasa Hi-tech Systems. 

ROLE: Programmer/Junior DBA

1.	Involved in designing of front-end application and generating of forms and report for end user.
2.	Does the feasibility study like developing the Oracle forms; reports then design flow charts, proto types, database tables etc.
3.	Creating code for Oracle Forms, Reports and tests it. 
4.	Retrieval of Queries from the Management and End-users.
5.	   ERP package.  
6.	Creates and maintains database required for the development of our Organization.
7.	Doing a peer review of tables and raising unsolved queries.
8.	Interacted with the developers on application bugs.
9.	Sound communication skills with management and our team members to improve our organization.

Projects Overview:

1.		
Client	Seven hills Pharmacy Centre	
Role	Senior DBA	
Organization	Sevenhills Hospitals Ltd	
Duration	May 2006 to Aug 2006	
Team Size	Project: Seven hills Pharmacy Centre	Module:  Pharmacy,Administration,Human Resource etc.	
Environment
(with skill versions)	Software
	Languages   : Sql,Pl/Sql
Database      :Oracle 10g 
Tools            :Developer
O/s                :Windows,Sunsolaris
GUI	   :D2k Forms, Reports

Project Description:

This package is developed to provide solution for Sevenhills 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. It should also deal with the System Related Activity like Tracking of User, Creating User Group Master, and User Master. Maintenance of company documents, User defined error message, Generating Daily Statistical Summary. 

This Package contains the following main modules.
•	Pharmacy
•	System Administration
•	HR and Payroll

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.

2.		
Client	Sai Rag Hospital	
Role	Programmer	
Organization	Srinivasa Hi-tech Systems	
Duration	Sep 2001 to Feb 2002	
Team Size	Project: Hospital Management	Module: Registration, Pharmacy, Billing etc.	
Environment
(with skill versions)	Software
	Languages   : Sql,Pl/Sql
Database      :Oracle 9i
Tools            :Developer
O/s                :Windows
GUI	   :D2k Forms, Reports

Project Description:

This package is developed to provide solution for corporate hospitals. This Package contains the following main modules.
•	Registration
•	Pharmacy
•	Billing
•	Diagnostics
•	System Administration
•	HR and Payroll

Role:

•	Involved in designing of Tables, Queries.
•	Involved in generating Forms, Reports and Interacted with hospital staff for retrieval of required information.
•	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.

3.		
Client	Nagarjuna Chits and Finance (NCF) Limited	
Role	Programmer	
Organization	Srinivasa Hi-tech Systems	
Duration	Mar 2002 to Aug 2002	
Team Size	Project: Chits and Finance	Module: Cash/Bank, Receipt/Payments, Journal Voucher	
Environment
(with skill versions)	Software
	Languages    : Sql,Pl/Sql
Database      :Oracle 9i
Tools            :Developer
O/s                :Windows
GUI	   :D2k Forms, Reports

Project Description:

This Module must deal with Cash/Bank, Receipt/Payments, Journal Voucher and General Ledger etc. Books like Cashbook, Bankbook and Ledger book can be generated. This module generates reports like Trail Balance, Balance Sheet and Profit and Loss statement. The Financial Accounting Screens describe about the Account Payable, Account Receivable and General Ledger

Role: 

•	Involved in System design, creating algorithm, flow charts etc.
•	Involved in gathering a data like Master Tables, Reports etc.
•	Created, managed and executed application with my Colic’s.
•	Involved in designing of front-end application and generating of forms and report for end user.
•	Doing a peer review of the tables and raising unsolved queries.

4.		
Client	Tata Max Cellular Limited	
Role	Programmer	
Organization	Srinivasa Hi-tech Systems	
Duration	Sep 2002 to Feb 2003	
Team Size	Project: Customer Information System (CIS).	Module: Registration, Adminstration etc.	
Environment
(with skill versions)	Software
	Languages    : Sql,Pl/Sql
Database      :Oracle 9i
Tools            :Developer
O/s                :Windows
GUI	   :D2k Forms, Reports

Project Description:

The objective of this project is to develop a website for IDEA customers for browsing information and to update their details. The system is to maintain customer information that includes Master Data, Data Transformations, Generating Reports and On line Bill Payment. Project contains Administrative module that allows Insertion, Deletion, Updating and Maintenance of data, user module that allows user to browse and can edit information regarding his bank Accounts details, Tariff Plans, Mode of Pay, Requesting Services. And this system also gives the facility of help text to clarify various doubts for customer. This system has the capability that it can work efficiently and effectively.

Role:

•	Designed the Data Modeling.
•	Normalized the data structure.
•	Created the databases Tables.
•	Written stored procedures, functions and packages for Fetching, Inserting and updating loan information.
•	Exception Handling.
•	Unit Testing

Personal Details

Date of Birth: 		13th October1980	13th October1980	
Sex:	Male	
Marital Status:	Married.	
Passport no:	A 6530232		
Languages Known:	Telugu, English, and Hindi		
Nationality:	Indian	
Mobile:		98484-03393	
Address:	Flat no: 303,Kutir Apartments, Balaji Nagar, Siripuram, 
Visakhapatnam.Pin code: 530003	
Email	b4u_amar2003@yahoo.com,b4uamar2003@gmail.com