Database Administrator Resume
New Jersy, NJ
PROFESSIONAL SUMMARY
1. Solid Industry experience of 4+ Years in high traffic and high volume Database applications with MySql, SQL Server 2000/2005/2008, NoSQL, Oracle 9i/10g.
2. Expert in Testing Web/ Window based applications, Test Plan Creation, Automation & Defect Management
3. Experienced in Unit testing, Black - box testing, Functional testing, System Integration testing, GUI testing, Smoke Testing, Regression testing, Load Testing and Acceptance testing.
4.. Industry experience in developing applications on .Net Platform, AJAX, JavaScript, PHP, Ruby on Rails and XML
5. Hands on experience in Performance Tuning, Optimization, SSIS Packages, ETL tools and Reporting Services.
6. Worked on all stages of Software Development Life Cycle (SDLC) and Quality Assurance Lifecycle (QALC).
PROFESSIONAL EXPERIENCE
Confidential,USA Volunteer Database Administrator ( )
- Creating and Managing the Database of Volunteers in MySql.
- Developed application to maintain the data and appointments of Blood Donors.
- Migration of Data from InTouch (Medical Database) to e-Donor Database for online appointments.
- Created Crystal Reports for managing Blood Drives, Volunteers and Donors.
Confidential,INDIA, Sr. Database Developer & Quality Engineer ( )
- Manage and organize Requirements coverage, Test Case Management, Test Execution Reporting, Defect Management, and Test Automation Using Mercury Quality Centre.
- Completed Migration of application from SQL Turbo by Full Text Search Engine of SQL SERVER 2005
- Design and develop SSIS packages, stored procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
- Designed and developed of the Reusable component (The ISBN Converter) for HCL Technologies
- Developed Client Server application to manage data using Batch Processing System.
- Performed and Created Unit Test Cases.
- Developed guidelines to achieve 100% score in PQA Audits to bring project at top place
Confidential,USA, Programmer Analyst ( )
- Completed Migration of Database Servers from MSQL 2000 to MSQL 2005
- Created new security policies, new groups and permissions to access the database.
- Migrated DTS packages in SQL SERVER 2000 to SSIS in SQL SERVER 2005.
- Interacted with customers directly and solve their problems meeting deadlines.
Confidential,Software Developer ( )
- Responsible for Database Administration of Order & shipment information system (OASIS) of PEARSON
- Designed, coded and performed system integration testing for the OASIS application.
- Prepared detailed Unit Test Cases / Test Plan/Alpha Testing/Beta Testing with end clients.
- Developed Application incorporating data logging in SQL-SERVER 2000.
- Responsible for creating triggers and stored procedure to maintain success or failure of batch process
Confidential,Engineering Intern (June, 06—Dec’06)
- Developed RFID (Radio Frequency Identification) based automated billing system application for Shopping Mall
- Responsible for front-end coding and deployment of application in .Net platform.
- Designed and developed Tables, Stored Procedures, Views, Triggers, Functions, DTS Packages and Optimization of. Database in MS-SQL Server 2000
Academic Projects
Online Bookshelf Project (Ruby on Rails):
Developed online bookshelf website using Ruby on Rails, MySQL, JavaScript, CSS and AJAX. This Application
Allows users to browse books and check out books by adding them to a shopping cart. Administrative users can add, edit, delete users, orders and books. Search capability is provided withAmazon Web Services and Ruby gems.
Mini-Craigslist (Web Application Development using AJAX):
Developed and designed ‘Mini- Craigslist’ website using PHP, AJAX and MySQL. The website is designed on the lines of
The website allows users to post local classifieds for jobs, apartments, classes, goods and
Services. The website provides for adding posts, browse posts, user accounts and authentication.
Quality Testing of Flight Reservation Application:
TECHNICAL SKILLS
- Languages: C#, Visual Basic, Vb.Net, ASP.Net, UNIX, Ruby on Rails, PHP,JavaScript.
- Web Development: ASP.NET, VBScript, Web Services, HTML,AJAX
- ETL: SQL Server Integration Services, SQL Server DTS.
- Databases/RDBMS: MySQL,MS SQL Server 2008/2005/2000, Oracle 9i/10g,NoSql.
- IDE: Visual Studio.NET 2008/2005/2003, Visual Studio 6.0
- Platforms and OS: DOS, Windows 95/98/Me/2000/XP, .Net and UNIX
- QA Tools: Selenium, Bugzilla, LoadRunner, Mercury Quality Center & Quick Test Professional(QTP)