DATABASE ADMINISTRATOR

Diversified experience in database administration and T-SQL programming. Demonstrated ability in analyzing and troubleshooting technical issues for root cause. Completed a broad spectrum of complex projects on time and within budget. Strong organizational, interpersonal and communication skills. Areas of expertise include:

• Performance tuning and query optimization
• Database design & implementation
• Backup, restoration and disaster recovery
• SSRS, SSIS, Replication, log shipping
• SQL server installation, upgrade & configuration
• ETL,BCP, SQLCMD, OSQL, bulk insert, Profiler
• T-SQL, store procedures, triggers, views writing
• Windows batch scripting, Power shell

Software: Proficient in MSSQL 2008\2005\2000\7.0\6.5, Dbartisian, SQL Server Enterprise Manager,
SQL Query Analyzer, ERStudio, ABAT, TSM, BCP, SQLCMD, T-SQL,SSRS, SSIS
OS : Windows-2000/2003, Windows NT-4.1

Employment History

Confidential, Rye Brook, NY 03/04 to 02/11.
MSSQL DATABASE ADMINISTRATOR (DBA)

Performed database administration, installation, configuration and service pack on non-clustered environments.
Optimized complex queries, conducted performance tuning; wrote stored procedures, views, triggers, ETL. Used database tools to troubleshoot performance, quality assurance (QA) and production level issues to support billing, settlement and forecasting applications. Handled maintenance of SQL server in development, QA and production environments. Maintained backups for all databases. Designed databases and SQL functions to support applications.

• Setup and Configured Transactional and Snapshot Replication in production, Qa and Development servers, and log shipping.
• Upgraded all development, QA, production servers from SQL2000 to SQL2005, within window period, allowing application team to use new features of SLQ2005.
• Enhanced the database backup process from daily full to daily differential and weekly full, thereby reducing the space need and run time by 80%, and hourly transaction as per SLA.
• Improved the backup and recovery script for VLDB (1TB) by introducing piecemeal backup and reducing the space, runtime and recovery downtime by 80%.
• Initiated project to increase productivity by automating 4 manual processes. Increased data integrity of monthly database creation and archiving of historical databases.
• Created migration tools in batch script which is used by the entire DBA team to migrate the database objects to all production and QA servers, pulling scripts from VSS based on a label.
• Wrote new maintenance script to weekly rebuild all the indexes and update statistics and to keep each and fine tune every database.

Confidential, Rye Brook, NY 12/96 to 03/04
ApplICATION DBA/Programmer/Analyst

Diagnosed and resolved problems. Conducted performance tuning on databases, and query optimization. Wroteand debugged stored procedures, triggers, views, index, database creation modifications, optimization and ad hoc reports to support development\QA\production environment.

• Automated manual settlement process in which the system automatically created a settlement report when a customer disputed an invoice, showing the original client call registered in the system against the clients claim. The process increased productivity and accuracy, and expedited settlements, removing any manual comparison.
• Converted clipper, Sybase database to MSSQL server database for settlement application, using front-end development in PowerBuilder and reporting in SQR and batch script.
• Created financial reports in SQR, Perl for the settlement division, planning and forecasting reports. Designed monthly ETL process to load data to SQL server for data from other systems. Wrote complex rating process to rate call detail records for the settlement groups.
• Performed QA and end-user acceptance testing to insure the product satisfied end-user requirements and needs. Assisted in packaging and delivery of finished software product to clients.
• Wrote monthly archiving jobs to keep database growth and space in check, and monthly application database archiving job as per SLA.

Confidential, New York, NY 12/94 to 12/96
ApplICATION DBA/Programmer/Analyst

Designed and created database logical and physical in Xbase, and managed its maintenance, backup, restore and tuning.

• Designed and developed telephone billing system for a long distance calling card system, which
  consists of A/R, A/P, general ledger, etc. Provided user support, enhancement and troubleshooting
  of application and network problems.

PRIOR Experience

Appl. DBA Programmer/Analyst Confidential, New York, NY 09/93 to 09/94

Education

Internet Technology for e-Commerce Certificate Program - Pace University, New York, NY, 2000
(JAVA, SERVELETS, APPLETS, HTML, DHTML, PERL, DREAMWEAVER, LINUX)
Performance and Tuning Adaptive Server 11.5 - Sybase Inc., New York, NY, 1998
Advanced Transact SQL - Sybase Inc., New York, NY, 1998
Local Area Network Administration - New York University, New York, NY, 1993
Diploma in Software and Data Processing - I.C.S., India, 1988

BS: Math