Biswas - DBA SQL

FI-TEK PRIVATE LIMITED, CALCUTTA, INDIA (DECEMBER 2000 TILL DATE)
Consultant – Support and Facilities (June 2006 till date)
 Administration of MS SQL Server 2000/2005 servers and databases. This includes management of primarily three kinds of databases upon the servers simultaneously – Development Databases where all the developers work for new modules, enhancements and bug-fixing; Test Databases where the Testing Team works for discovering any possible bugs or issues; Live Databases which are sent over to our office for any new data conversion task or for finding scopes for performance improvement.
 Performance Tuning upon the live databases. This includes scanning for performance bottlenecks, tracking poorly performing queries and tuning model/query for optimizing output time. This involves extensive interaction with the Developers as well as Project Leaders to help reach the most optimized process flow.
 Manage and supervise Software Releases to clients. This involves responsibilities like deciding new version number depending upon the extent of changes incorporated in the new release, deciding which of the new modules or reports to be made available for the client as per the requirements; and explaining the implementation team in our New Jersey office about the content of releases, explaining the sequence of applying the updates and give any special instructions about the releases.
 Acting as the Quality Manager for the organization; managing the Quality Management System for the organization under ISO 9001:2000; primary responsibilities being conducting regular Internal Quality Audits, conduct Quality Awareness Session for the employees, keep track of the performance indicators of various processes defined under the purview of Quality Management System.
 Administration of MS Visual SourceSafe for all active projects. This included maintaining regular backups of the active projects, managing new users as well as providing appropriate rights to existing users and analyzing the project-databases at regular intervals to remove any data-corruptions.

Associate Consultant – Support and Facilities (June 2004 – May 2006)
 Administration of MS SQL Server 2000/2005 servers and databases. This includes management of primarily three kinds of databases upon the servers simultaneously – Development Databases where all the developers work for new modules, enhancements and bug-fixing; Test Databases where the Testing Team works for discovering any possible bugs or issues; Live Databases which are sent over to our office for any new data conversion task or for performance tuning.
 Manage and supervise Software Releases to clients. This involves responsibilities like deciding new version number depending upon the extent of changes incorporated in the new release, deciding which of the new modules or reports to be made available for the client as per the requirements; and responsibilities like explaining the implementation team in our New Jersey office about the content of releases, explaining the sequence of applying the updates and give any special instructions about the releases.
 Performance Tuning upon the live databases. This includes scanning for performance bottlenecks and tuning model/query for optimizing output time.
 Administration of MS Visual SourceSafe for all active projects. This included maintaining regular backups of the active projects, managing new users as well as providing appropriate rights to existing users and analyzing the project-databases at regular intervals to remove any data-corruptions.
 Being also the Quality Manager for the company, the responsibilities also include managing the Quality Management System of the company.

Software Engineer – Support and Facilities (July 2003 to June 2004)
 Administration of MS SQL Server 2000/2005 servers and databases, including data modeling, disaster recovery, troubleshooting and performance tuning. This includes management of primarily three kinds of databases upon the servers simultaneously – Development Databases where all the developers work for new modules, enhancements and bug-fixing; Test Databases where the Testing Team works for discovering any possible bugs or issues; Live Databases which are sent over to our office for any new data conversion task or for performance tuning.
 Data Model Design using ERwin with extensive use of Forward and Reverse Engineering upon the SQL databases to and from the Data Models. This involves generating skeleton databases for project development and subsequently replicating any further model changes back to the data model diagram. Then finally generating a fresh skeleton database from the model for new client implementations and making them ready for data conversion.
 Making Database Upgrade Scripts comprising various model changes and updated database objects for various client sites in accordance with the Software Builds and Service Pack Releases.
 Performance Tuning upon the live databases. This includes scanning for performance bottlenecks and tuning model/queries for optimizing output time. This involves extensive interaction with the developers.
 Supervise Software Releases to clients. This involves on-site responsibilities like deciding new version number depending upon the extent of changes incorporated in the new release, deciding which of the new modules or reports to be made available for the client as per the requirements; and off-site responsibilities like explaining the implementation team in our New Jersey office about the content of releases, explaining the sequence of applying the updates and give any special instructions about the releases.
 Prepare Test Databases and coordinate with the Testing and Quality Assurance team to ensure the verity of the Software and Database Updates prior to any release
 Administration of MS Visual SourceSafe for all active projects. This included maintaining regular backups of the active projects, managing new users as well as providing appropriate rights to existing users and analyzing the project-databases at regular intervals to remove any data-corruptions.

Senior Programmer – Support and Facilities (April 2002 to July 2003)
 Administration of MS SQL Server 2000/2005 (both Development Databases, Test Databases and Live databases that are brought for upgrade and tuning)
 Preparing Development databases with new models and structures for developers and programmers to build new modules and make enhancements. This also involved making a skeleton database with some requisite architecture-related tables. The developers work on this database for building their modules and prepare the framework. The models from these databases are later on replicated to the data model and to all other development databases for the same project.
 Making Database Upgrade Scripts comprising various Model changes and updated database objects for various client sites in accordance with the Software Builds and Service Pack Releases.
 Preparing skeleton databases for new implementation. This comprised forward engineering the latest Data Model into a skeleton database or using a pre-created up-to-date skeleton database.
 Populating the skeleton databases during the Data-Conversion process with implementation-level data using various data-import methods before the database is sent for transaction data import.
 Administration of MS Visual SourceSafe for all active projects. This included maintaining regular backups of the active projects, managing new users as well as providing appropriate rights to existing users and analyzing the project-databases at regular intervals to remove any data-corruptions.
 Prepare Test Databases and coordinate with the Testing and Quality Assurance team to ensure the verity of the Software and Database Updates prior to any release
 Provide demo databases to our office at New Jersey for demonstrating our software to perspective clients. This usually contained some transaction data for demonstration. For some prestigious clients, the demo database is installed upon a Server at our New Jersey office where the clients can work using remote user network (like Citrix MainFrame XP) and get a taste of the software. In case the client demands, there might be further enhancements or implementation level changes done to the database.

Programmer – Support and Facilities (December 2000 to April 2002)
 Administration of MS SQL Server 2000/2005 (both Development Databases as well as Live databases brought for upgrade and tuning)
 Making Database Upgrade Scripts comprising various Model changes and updated database objects for various client sites in accordance with the Software Builds and Service Pack Releases.
 Preparing Development databases with new models and structures for developers and programmers to build new modules and make enhancements. This involved making a skeleton database with some requisite architecture-related tables. The developers work on this database for building their modules and prepare the framework. The models from these databases are later on replicated to the data model and to all other development databases for the same project.
 Administration of MS Visual SourceSafe for all active projects. This included maintaining regular backups of the active projects, managing new users as well as providing appropriate rights to existing users and analyzing the project-databases at regular intervals to remove any data-corruptions.
 Prepare Project Plans for Directors using MS Project and handing over them for regular updation. It also required providing support for proficient use of the project management software.
 Generating skeleton databases by forward engineering the latest Data Model for new implementations and populating the implementation-level data.
 Maintaining a Demo Database for use by the company’s executives for demonstration at various tentative client sites. This needed to be in sync with the latest released version of the software with respect to the changes in the data model.

NIIT LIMITED, CALCUTTA, INDIA (JUNE 2000 TO DECEMBER 2000)
Senior Systems Associate – Technical Support and Training (June 2000 to December 2000)
 Technical Support for Sybase SQL Server (4.x – 11.5.2) at existing client sites. This included Crash Recovery, Maintenance Tasks, and Performance Tuning. The nature of support ranged from Telephonic to On-site visits.
 Migration/Upgrade of databases including application porting. This involved migrating the existing SQL Server to a higher version along with the existing user databases. In case the client had been using applications like DWB, the application had to be setup in the new environment
 Imparting training of Database Administration and Maintenance to onsite engineers so that in case of any emergency, they can troubleshoot. This was more important at client-sites located far from our office.
 Bookkeeping and maintaining Quality Assurance Documents as per the norms of ISO for the department. This involved tracking the requisite visits by all the technical support executives and maintaining the client feedback forms declaring the work done during each visit.
 Impart Corporate Training to executives at client sites for various software. This involved setting up a small workgroup of computers usually in their premises and conduct classes.
 Provide technical support and consultancy for various software (those have a retailing partnership with us) to clients. This included products like McAfee Antivirus, Microsoft Windows Operating Systems, Microsoft Office Suite.

NIIT LIMITED, CALCUTTA, INDIA (APRIL 1999 TO APRIL 2000)
Junior Systems Associate – Technical Support and Training (April 1999 to April 2000)
 Technical Support for MS Office Suite to clients. The support was mostly provided over telephones. This also involved intra-company support to all other employees.
 Imparted Corporate Training to all levels of employees at client sites. This involved setting up a small workgroup of computers usually in their premises and conduct classes.
 Prepare Questionnaires for various exams conducted for employees of clients. This was meant to test the participants understanding of the topics and the course.
 Supervise the examinations and give scores to the Answer Sheets of the participants. In some cases, the head office of the participating clients wished the scorecards to be sent to them to assess the performance.
 Provide technical support and consultancy for various software (those have a retailing partnership with us) to clients. This included products like McAfee Antivirus, Microsoft Windows Operating Systems, Microsoft Office Suite.