Profile

User Profile

Please refer my website http://www.astainfotech.com

Professional Snapshot
Result-driven professional with over 4 years’ experience in the areas of Database Administration and Network / Server Administration with Advent Matrix P Ltd., Dehradun. Currently designated as Team Leader (Database) and engaged in the project Stone Matrix, a B2C2B Portal for Natural Stone Industry. Experience in the installation, maintenance and administration of Oracle databases, performance tuning, database cloning for application testing, user creation / management, and disaster recovery / database security. Strong domain knowledge in the Stone / Marble industry with track record of successfully delivering projects for US-based clients. A skilled communicator with strong leadership, team management, interpersonal, analytical and problem-solving skills.

Skill Set
Operating Systems : WIN 9x/NT/2000/XP/2003, Linux, DOS
Database : Oracle 8.0, Oracle 8i, Oracle9i MS Access, SQL Server 2000, Export /
Import, SQL* Loader, Data Porting (around 5 Lakh Records)
Languages : SQL, PL/SQL, C, C++, Java, VB 6.0
Middleware : Learning Oracle 10g DB
Web Technologies : JavaScript, HTML
Reporting : Crystal Reports
Other Tools : Toad, SQL Navigator

Organisational Experience

Since Feb’02 with Advent Matrix P Ltd., Dehradun.
(Formerly known as Keywest Business System (P) Ltd. Development unit of Advent Matrix Inc., USA)

ó Joined as Database Trainee and rose to the current position of Team Leader-Database in Jan’05.

Key Tasks Handled across Assignments

Oracle DBA
ð Installation, configuration and upgradation of Oracle database server software
ð Physical database design & creation. Devise strategy for Backups, recovery & fine-tuning.
ð Creation of tablespaces, rollback segments, user maintenance, database security imposition by creation and granting of roles and privileges, performance tuning, backups (Hot/Cold) using RMAN.
ð Creation of SQL / PL/SQL stored procedures, tuning of SQL statements. SQL Query optimisation using Oracle Explain Plan.
ð Provide technical support to application development teams.
ð Evaluate Oracle features & related products. Set up & maintain documentation and standards

Support Activities
ð Setting up and managing LAN with 20 nodes.
ð Handling implementation and administration of production database / server and ensuring maximum uptime of the network.
ð Addressing and resolving any problems arising in the network to ensure non-stop production.

Major Projects Handled;

Ø Stone Matrix (www.stonematrix.com) for the Stone Industry Duration: Since Feb’02
Team Size: 15 Role: DBA
Technologies: J2EE (JSP, Servlets, Java Mail), Merak Mail Server, Windows Advanced Server, Oracle 9i, Orion Web Server
Scope: This is a complete B2C and B2B portal for Stone Industry worldwide. The portal consists of various types of Searches, Business Transactions, Product Bids and Hot Deals. The product is much focused in satisfying the daily needs of different entities involved in Stone Business. The portal is a one-stop shop for everyone related to Stone Industry.
Responsibilities:
ü Tuning the Performance of Database (Using SQL Profiler, System Monitor, etc.)
ü Handling Backups and Recovery
ü Involved in the Design of new Forms and Searches.
ü Designing Process Flows and ER Diagrams. (Creation of triggers, indexes, procedures and functions at Back end) (This is done using ER Studio)
ü Handling Network and Production Server related Issues

Ø Web Site Development for Precision Granite Works Duration: Since Feb’06
Inc. (www.precisiongranites.com), USA
Team Size: 5 Role: Project Leader
Technologies: J2EE (JSP, Servlets), Windows Advanced Server, Oracle 9i, Orion Web Server
Scope: The site is designed for the Natural Stone Fabricator, for providing dynamic searches of products based on Colour, Price and Product Category. The customer can design the kitchen as per his requirements and send the request for quotation. On the other hand the company can view the transaction and each and every employee of the company is provided with a scheduler.
Responsibilities:
ü Tuning the Performance of Database (Using SQL Profiler, System Monitor, etc.)
ü Handling Backups and Recovery
ü Involved in the Design of Forms, Searches and Scheduler.
ü Designing Process Flows and ER Diagrams. Creation of triggers, indexes, procedures and functions at Back end, using ER Studio.
ü Handling Network and Production Server related Issues

Ø Portal (Customer/Employee Integration) for IMG Stone, Duration: Oct’02 to Jan’03
USA (www.imgdemo.com)
Team Size: 15 Role: Consultant
Technologies: J2EE (JSP, Servlets), Windows Advanced Server, Oracle 9i, Orion Web Server
Scope: This is an Internet-based web portal in which all the customer, employee and the administrator of the IMG using there login name and the password can have access to the system and they can transact according to the rights they have.
Responsibilities:
ü Performance tuning of Database using SQL Profiler, System Monitor, etc.
ü Handling Backups and Recovery
ü Involved in the Design of new Forms and Searches.
ü Designing Process Flows and ER Diagrams. Creation of triggers, indexes, procedures and functions at Back end, using ER Studio.
ü Handling Network and Production Server related Issues

Ø Web Analyzer (www.stonematrix.com/stats) Duration: Jun’04 to Aug’04
Team Size: 5 Role: Sr. Database Developer
Technologies: J2EE (JSP, Servlets, Java Mail), Merak Mail Server, Windows Advanced Server, Oracle 9i, Orion Web Server
Scope: The application tracks the number of hits / views on the sites. This also tracks that through which search engine is the site visited and what all web crawlers have crawled the site. The system also tells that which all pages are missing on the site (404 Errors).
Responsibilities:
ü Tuning the Performance of Database using SQL Profiler, System Monitor, etc.
ü Handling Backups and Recovery
ü Involved in the Design of new Forms and Searches.
ü Designing Process Flows and ER Diagrams. Creation of triggers, indexes, procedures and functions at Back end using ER Studio.
ü Handling Network and Production Server related Issues

Ø Web site for Daltile Corporation, USA Duration: Apr’05 to May’05
(http://www.adventmatrixsolutions.com/daltile/login.jsp)
Team Size: 5 Role: DBA
Technologies: J2EE (JSP, Servlets), Windows Advanced Server, Oracle 9i, Orion Web Server
Scope: This site is designed for the Natural Stone Importers. The dealer can showcase its Slabs in full view and the fabricators from various locations can search the stone slabs based on its Size, Colour, Name and Category. After searching the user can also send the request for the quote of a particular slab.
Responsibilities:
ü Tuning the Performance of Database (Using SQL Profiler, System Monitor, etc.)
ü Handling Backups and Recovery
ü Involved in the Design of Forms, Searches and Scheduler.
ü Designing Process Flows and ER Diagrams. Creation of triggers, indexes, procedures and functions at Back end using ER Studio.
ü Handling Network and Production Server related Issues

Ø Web site for Walker Zanger Inc., USA Duration: Apr’05 to May’05
(http://www.adventmatrixsolutions.com/wlk/login.jsp)
Team Size: 5 Role: DBA
Technologies: J2EE (JSP, Servlets), Windows Advanced Server, Oracle 9i, Orion Web Server
Scope: This site is designed for the Natural Stone Importers. The dealer can showcase its Slabs in full view and the fabricators from various locations can search the stone slabs based on its Size, Color, Name and Category. After searching the user can also send the request for the quote of a particular slab.
Responsibilities:
ü Tuning the Performance of Database using SQL Profiler, System Monitor, etc.
ü Handling Backups and Recovery
ü Involved in the Design of Forms, Searches and Scheduler.
ü Designing Process Flows and ER Diagrams. Creation of triggers, indexes, procedures and functions at Back end using ER Studio.
ü Handling Network and Production Server related Issues

Other Projects as DBA;
Ø Web Site for American Stone Fabricator, USA (www.amstonefab.com) using J2EE (JSP, Servlets), Windows Advanced Server, Oracle 9i, Orion Web Server
Ø Web site for YK Marble, USA (www.ykmarble.com) using J2EE (JSP, Servlets), Windows Advanced Server, Oracle 9i, Orion Web Server

Academic Credentials
§ M.Sc. (Computer Science) from Maharshi Dayanand University, Rohtak in 2003.
§ B.Sc. from HNB Garhwal University, Srinagar in 2000.

Certifications / Courses
§ OCP (Oracle Certified Professional) Oracle 8i DBA in 2004.
§ DAST (2 Years Diploma) from CMC Ltd., Dehradun in 2001.

Personal Details
Date of Birth : 20th October 1980
Contact Details : 2/8, Tyagi Road (East-1), Dehradun-248 001
Tel. (Res.) +91-135-2625180, Mobile: +91-9412051028
Passport Details : E1059111 (Issued at Bareilly. Valid up to 05/08/2012)
References : Available on request

Buyer Activity

Provider Activity