Summary




More than 10 years of database design and development experience in MS SQL
Server 6.5, 7.0, 2000, 2005 and 2008. An industrious, versatile team player with good communication s skills who has a demonstrated track record of working Independently to get things done.




Achievements

Database Design and Development :
Responsibility Include : System Analysis , System Design , Coding , Testing
Implementation and Documentation , Database Design and Development using
Sybase .
Sybase Database Administrator : Using transact SQL to manipulate database .
Triggers and Stored Procedures were used to maintain business logics and rules . Maintained more than half million records for IT department . Providing
Ad Hoc database reports to project managers .
Involved in designing , development and enhancement of the SkillQuest database using Sybase . Erwin tool had been used for data modeling . Logical and Physical design . Applied business rules to application data , data validation and referential integrity . Stored procedures and triggers are used .
Involved in the development and enhancements of reports for domestic clients .
This includes displaying and formatting domestic IT associates' skills profiles and skills summary reports and other reporting data for project managers and VPs .
involved in migrating production data from intranet web server to
Sybase server and de-normalization of Sybase database tables and creating indices to improve query performance . Generating ad hoc skills summary reports using Oracle or Sql server and Access .


Employment

June, 2000 -  2005

Additional Administrative tool besides sql server administrative tools : DBArtisan
Database modeling tools : ERStudio, Erwin
Reporting Tool : Sql server reporting services
Data warehouse data mining development tools : Visual studio, sql server analysis services

Sullivan and Cromwell LLP., New York

October, 2006 -  April, 2009
SQL Server Database Administrator

Responsibilities
Provide 24/7 dba support for over 40 sql servers 2000 and 2005, development server, staging servers and production servers.
Physical and logical data design along with backend programming DTS packages, SSIS, stored procedures, triggers, views, functions, etc.
Create ad hoc complex management reports as required. Handle distributed queries, distributed transactions, remote procedure calls and replication.
Design and develop reports using sql server reporting services
Design and developed data warehouse and provide trend analysis reports to the management
Create SSIS and schedule the task to import and export files
Create and design Access application linked with sql server 2005
Design, develop and maintain OLAP cubes for data warehouses.
Design and develop analysis service projects
Design and develop SSRS
Maintain production databases in support of custom and third-party applications in clustered server environment
Maintaining all production servers, clustered servers with high availabilities
Create disaster recovery plans
Script and perform production releases
Develop SQL processes for data loading, migration and application interfaces
Design, document, develop and maintain data management and reporting scripts

Work directly with users in support of reports and metrics across the organization
Create, test and conduct SQL performance tuning on SQL Server databases
Provide guidance for the development, maintenance and performance of scalable systems
Provide supports to company applications and third party applications and troubleshoot application issues. Interact with users to resolve application issues in a timely manner

Created the first data encryption application for the firm

Created a comprehensive monitoring sql server system that send out customized email alerts daily to verify data integrity, server disk space, production job status, etc. using distributed transactions.
Migrated over 100 sql databases from sql server 2000 server to 2005 Servers.
Converted over 1000 dts to SSIS.
Designed and developed complex SSRS reports
Maintained over 40 servers in good standings.
Created scripts to perform any specific tasks
Provided and resolved all kinds of production servers issues in a timely manner.
Standardized productions maintenance schedules on all production servers for a fast troubleshoot

September, 2005 -  October, 2006
SQL Server Database Administrator

Daily Responsibilities
Provide daily support to the company s applications and troubleshoot any related issues
Logical and physical database design and development
Create stored procedures, views, triggers, functions
Create ad hoc complex management reports as required.
Design and develop reports using sql server reporting services
Design and developed data warehouse and provide trend analysis report to the management
Create, test and conduct SQL performance tuning and partitioning on SQL Server databases
Responsible for production releases
Troubleshoot and resolve sql servers issues like diskspace issue, deadlock issues.
Responsible for all production databases maintenance jobs backup, reindexing etc..
Troubleshoot and fix failed production jobs.
Maintain all production servers in good standing.

November, 2002 -  August, 2005
Sql Server DBA/Web Application Developer

SQL Server DBA : Logical and physical database design and development.
Developed DTS packages, stored procedures, triggers, functions and views. Performed database backups and maintenance.
Lead database developer : Designed and developed databases for company websites. satellite and radio communication java application and DMD financial, marketing and sales asp.net application.
Data Warehouse design and development.

Perform OLAP cube development and produce effective and reliable reporting applications. Proficient experience in both normalized OLTP database design and dimensional star schemas for data warehouses. Extensive ability in meeting the real world needs of both large and small systems.
OLAP cube development to produce efficient and reliable reports and applications. Office up to version 2003 : Expert level in Access, Excel, Word, VBA, OLE Proficient knowledge in ODBC/JDBC

April, 2001 -  2002
Database Administrator and Application Developer

Logical and physical database design, performance tuning, triggers and stored procedures and replication. Provide DBA support.
Generating Ad Hoc Database Report. Generating reports on customer order processing and shipping, general accounting and manufacturing and production planning
Using DTS to automate jobs and transferring data
Designed and developed Access database for Bear, Mark and Uphand Law Firm
Generate Reports using crystal reports

April, 1998 -  April, 2001
Database Administrator and Application Developer

Education

Training

Microsoft certified database design and developer
Microsoft certified database administrator
Sun Certified Java Programmer