SUMMARY

• IT experience with 6+ years in Database Administration and development with MS SQL Server technology 2008/2005/2000 , MS SQL Server 2008 (R2)
• Extensive experience with database administration, advanced data recovery, data corruption, extended SQL Server Internals and SQL Server Memory concepts
• Advanced knowledge of installation and configuration of MS SQL Server 2008 R2, 2005 and 2000 versions
• Experience in applying SQL Server database service packs, hot fixes and security patches
• Experience in database backup, recovery, disaster recovery procedures and troubleshooting
• Advanced knowledge of T - SQL, SQL
• Extensive experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC utilities
• Experience in maintaining Database Authentication Modes, Creation of Users, Configuring Permissions and Assignment of user roles
• Experience in extracting and transforming transactional information using DTS Import/Export Wizard, BCP (Bulk Copy Program), DTS (Data Transformation Services) and SSIS Packages from SQL Server
• High aptitude for creating database solutions to business problems by working closely with management, applications development staff and other users
• Experience in handling 24/7 Database Maintenance and Production Support to large organizations
• Advanced knowledge of IT troubleshooting and staff program training and mentoring
• Good knowledge of RAID systems.
• Expensive experience with Table Design, Index Design.
• Knowledge of Relational Database Management Systems and Database Design.
• Experience in writing and debugging Stored Procedures, Functions and Triggers.
• Involved in optimizing code and improving efficiency in databases including rendering, updating statistics, recompiling stored procedures
• Experience in implementing different types of Replication Models such as Transactional, Snapshot and Merge in SQL Server 2008/2005/2000 in OLTP environments.
• Experienced in creating maintenance plans, Jobs and Sending Alerts using SQL Mail.
• Experienced in data normalization and de-normalization.
• Experienced in using tools like SQL Profiler and performance counters for Monitoring and Tuning MS SQL Server Performance.
• Involved in using SQL2008 features like creating DB partitioning, file groups and Database Snapshots.
• Strong interpersonal and communication skills

TECHNICAL SKILLS

Programming Languages: T-SQL, C,C++, MySql, PHP

Database Application Software: SQL Server 2000/2005/2008 , MS Access, MySql.

DB Utilities: SQL Server Management Utilities, Query Analyzer.

GUI: DTS Import/Export, SQL Server Integration Services SQL Server Management Studio.

Reporting: MS Access, Excel, MS SQL Server Reporting Services 2005/2008, SSIS, SSAS

ETL Tools: SSIS,DTS

Application Software: Microsoft Office, Microsoft Excel, Macros, Visual Studio.

Web Technologies: HTML, XML.DOS,VB, Shell Scripting.

Modeling Tool: ER-Win.

Operating Systems: Windows Vista/XP/NT/2000/2003,Windows 7.

Web Services: IIS Administration

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

SQL Server DBA/ Mysql-PHP Developer

Responsibilities:

• Developed custom database and web-based user interface using MYSQL/PHP for company’s limousine service to manage reservations, track utilized hours, calculate and generate invoices for all transactions, calculate driver payments.
• Maintained secure database with custom login page and individual login details with different authentication levels.
• Monitored database cPanel and made necessary updates and changes.
• Provided technical support, troubleshooting and database application training to employees.
• Installed and configured SQL Server 2008 on Windows 2003 server
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008
• Implemented and managed alerts, SQL verification and permissions/restrictions
• Created groups, roles and user logins, and assigned user privileges and access
• Archived and backed up data on daily and weekly basis
• Provided training and consultation to employees on database usage
• Utilized various recovery models to proactively prevent database crashes, and to recover data in the event a crash occurred
• Successfully decreased database/server/IT troubleshooting issues by 97%
• Created SSIS package for SQL Server maintenance tasks
• Managed IT troubleshooting

Environment: SQL Server 2005/2008 Enterprise Edition, HTML, Enterprise Manager, T-SQL, MS PowerPoint, MS Project & Windows 2003 server, MySQL, PHP

Confidential, Denver, CO

SQL Server DBA

Responsibilities:

• Successfully migrated from SQL Server 2005 to SQL Server 2008 on development and testing environment..
• Experience in patch installation and roll back.
• Expertise in data cleansing, mapping columns, lookup with various SSIS objects.
• Converted all existing DTS package of MS SQL 2005 to SSIS packages by using package migration wizard and deployed new package in different server.
• Migrated new database structures, such as tables, indexes and stored procedures from development to the production environment.
• Monitored database system details within the database, including stored procedures and execution time and implement efficiency improvements.
• Installed and configured edition of SQL Server 2008 like Enterprise edition.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, mirroring, database integrity verification, indexing and statistics updates.
• Designed new reports and customized existing reports of older version to new version.
• Responsible for resolving blocking and locking issues.
• Successfully implemented database mirroring between primary server and mirror server.
• Used clustering for the high availability environment.
• Implemented log shipping in standby mode to support DR servers.

Environment: Microsoft Windows Server 2008 Enterprise Edition, Microsoft Windows 2003 Server, MS SQL Server 2005, 2008, Microsoft SQL Server Integration Services, Microsoft SQL Server Reporting Services, Microsoft Office 2003.

Confidential

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2005.
• Upgraded SQL Server 2005 and SQL 2008.
• Involved in the DB Migration process from one Data Center to another data center.
• Installed and Configure SQL 2008, SQL 2008 Active-Active Cluster on Windows 2008 production servers.
• Day-to-day Technical Support on MS SQL Server 2005 and 2008 Servers Platform for Production, Test and Development Environments (Clustered/non-clustered).
• Implement code changes and configuration changes (if needed) and other administrative activities.
• Created Snapshot and Transactional replication.
• Technical support to users for various purposes like Access change, performance issues and storage space managements on RAID/SAN drives.
• Prepare RCA (Root Cause Analysis) using Profiler Trace, Performance counters with System Monitor.
• Implement Database Mirroring for Disaster Recovery.
• Recommend possible remedies for better performance.
• Perform Backup and Restore operations using Idera SQL Safe during off-hours for the Development team
• Work in cooperation with developers/team for achievement of efficient database access for applications.
• This includes activities like designing, adding, eliminating, or maintaining indexes, organizing tables, recommending SQL changes to application development teams.
• To ensure all scheduled administrative/business jobs are running/completed for daily/adhoc business cycle on Microsoft SQL Servers in Production, Dev and QA Environment.
• Setting up Transactional and snapshot Replication for Production Environment.
• Running various DBCC commands for administration of database objects and system performance.
• Transformed data from various data sources like MS Access, MS Excel.

Environment: MS SQL Server 2005, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), SQL Server Query Analyzer, SSAS, SSIS, SSRS, OLAP, OLTP, ETL, T-SQL.

Confidential

SQL Server DBA

Responsibilities:

• Maintained and monitored SQL Server 2005 regularly to ensure uninterrupted operations
• Managed logins and users, including permissions and restrictions, for MS SQL Server
• Implemented proper security procedures for database and server
• Assisted in analysis, design, development, change management, deployment and user training
• Used Performance Monitor and SQL Profiler to enhance database performance
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery
• Monitored performance during Beta-Testing phase of applications
• Managed proactive and reacting tuning of database in various project stages
• Implemented Log Shipping

Environment: SQL Server 2005, HTML, Enterprise Manager, T-SQL,XML, MS PowerPoint, MS Project & Windows 2003 server.

Confidential

Jr. SQL Server DBA/Developer

Responsibilities:

• Installed and configured SQL Server 2005 on Windows NT
• Developed SQL queries for data management
• Created checks and constraints to ensure data integrity across databases
• Imported and exported data between servers using Data Transformation Services (DTS)
• Developed SQL queries to fetch complex data from different tables in remote databases
• Improved application performance by monitoring and tuning queries using SQL Server Enterprise Manager and Query Analyzer tools
• Created stored procedures and functions to support efficient data storage and manipulation
• Configured various publishers and subscribers for Snapshot and Merge replications
• Designed flow charts and data flow diagrams for upper management usage in business analytics and finance control
• Managed and resolved all network and server related troubleshooting issues

Environment: SQL Server 2000/2005 Enterprise Edition, HTML, Adobe Dreamviewer, Enterprise Manager, T-SQL, XML, MS PowerPoint, MS Project & Windows 2003 server.

Confidential

SQL PROGRAMMER

Responsibilities:

• Responsible for system analysis, design, testing and documentation
• Responsible for developing SQL procedures, packages, triggers and other database objects
• Responsible for performance tuning activities like Optimizing SQL queries, explain plan, creating indexes
• Responsible for Table Design, Index Design.
• Worked in Database structure changes, table/index sizing, transaction monitoring, and data conversion.

Environment: SQL Server 2000, SSMS, T-SQL, MS PowerPoint