Summary:

Certified SQL Server DBA having over six 6 years of SQL DBA experience in the areas of Database Administration, Development, and Technical Support with detail oriented, analytical and troubleshooting experience in different Microsoft products like SQL Server, Reporting Services, Data Modeling, and Operating Systems. Depth knowledge and experience in Database Administration, Reporting Services, Data Modeling including gathering and analyzing business requirement. Solid work experience in managing medium to large databases in 24/7 data processing environment including backup/recovery, performance tuning, developing and managing reports using SQL Reporting Services SSRS , Monitoring, Performance Tuning, Stored Procedures, Triggers, Functions, Constraints and Views etc. Work experience entails strong knowledge on using different database third party tools Idera, SpotLite, RedGate, SQLFront, MySQL Admin, ERWin and Quest Data Modeler.

Technical Skills:

• Database: SQL Server 2008r2/ 2008/2005/2000, MS Access 2010, 2003 2000, MySQL 4.0.3, 5.0.1
• Database Migration: MySQL 4.0.3, 5.0.1 , MS Access
• SQL Tools: Query Analyzer, OSQL, iSQL, Query Execution Plan
• ETL Tools: SSIS, DTS, BCP
• Reporting: SSRS SQL Server Reporting Services/Server
• Data Modeling: Toad Data Modeler, SSDD, ERWin, VISIO 2003/2007
• Programming: SQL, T-SQL, Store Procedures, Trigger, Functions, HTML, ASP, ASP.net
• Operating System: Windows Server 2008 R2/ 2008/2003/2000, Windows XP/NT4.0, MS-DOS, VMware
• Hardware/Storage: SAN, RAID

Professional Skills:

• Experience in ETL Data Warehousing, database testing using Informatica for Workflow process
• Strong experience on Windows Operating Systems 2008, 2003, 2000 , and RedHat Linux
• Working experience on AD Active Directory
• Working experience on IIS Web Server and Deploying applications
• Profound insight to determine priorities, schedule work, and meet critical deadlines
• Experienced in working client-server, web-based, stand-alone and database related applications on windows and UNIX platform.
• Expertise in coordinating with clients by writing, analyzing, reviewing and reporting

Database:

• Strong Database Administration experience with MS SQL Server 7.0, 2000, 2005, 2008,2008 R2 , MS Access 2000, 2003, 2007
• Data Modeling using tools like Toad Data Modeler, ERWin, SSDD SQL Server Database Diagram
• SQL/T-SQL Programming, Stored Procedure, Trigger, Function
• Strong work experience and knowledge with SQL Server Database High availability using Clustering, Standby, Replication, Database Mirroring, Log shipping, and Database Snapshot
• Database Monitoring, Performance Tuning, Query Optimization, Backup/Recovery, Security Management
• Upgraded databases from SQL Server 2000 to SQL Server 2005/2008 and SQL Server 2005 to SQL Server 2008/2008 r2
• Migrated MySQL, and MS Access databases to SQL Server 2005 and 2008
• Deployed databases to development, test and production environment

Web/Application Server Administration:

• Strong knowledge and experiences administering Web Server IIS-Internet Information Services including installing, and configuring and monitoring
• Application Deployment to development, test and production environment

Operating Systems:

• Working experience on Operating Systems O/S include Windows Server 2008 R2/ 2008/2003/2000 Server, Windows 2000/XP/7 and MS-DOS.
• Working experience also includes installing, configuring, and administering the above operating systems

Networking:

• Designed and Managed network using HUB, ROUTER, and SWITCH
• Administered user accounts in AD Active Directory in Windows 2000/2003/2008/2008 R2 Server
• Managed file and backup server

Professional Experiences:

Confidential

SQL Database Administrator/DBA

Responsibilities:

• Tools Used: SSMA SQL Server Migration Assistant for MySQL, Access, and ODBC/DB Link
• My-SQL 4.1.0/5.1.23 databases to SQL Server 2008 R2
• MS Access 2003/2000/97 databases into MS SQL Server 2008 R2
• Database Migrated development, testing and production environment
• SQL Server 2008 and 2008 R2 to SQL Server 2012
• SQL Server 2000/2005 to 2008/2008 R2
• Database Upgraded development, testing and production environment :
• Installed, Configured, and Managed SQL Server 2008 R2, 2008, and 2005 in development, test, and production environment

Database Programming:

• Written T-SQL, Trigger, and Stored-Procedures
• Assisted Database Developers to re-write and optimize SQL queries, Stored Procedures
• Tools Used: Query Analyzer

DTS/SSIS:

• Exported data from SQL Server to multiple destination/format such as Flat file, CSV file, MySQL, Access, ODBC/OLEDB data sources
• Import data from multiple sources such as Flat file, CSV file, MySQL, Access, ODBC/OLEDB data sources to SQL Server

Database High Availability:

• Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2005
• Installed, Configured and Maintained Database Mirroring using automatic fail-over option
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Configured and Maintained Replications Transactional
• Technology Used: Clustering, Database Mirroring, LogShipping, and Replication

Report Development:

• Installed, Configured, and administered SQL Server Reporting Services SSRS
• Developed, Deployed, and Managed Reports
• Managed Reports Security
• Tools Used: Developed Reports using BIDS Business Development Studio , and Report Builder 3.0, 2.0

Data Modeling:

• Worked on more than 10 data modeling projects and generated E-R Diagram
• Backward Forward Engineering with data modeling tools mentioned above
• Tools Used: ERWin, Quest Data Modeler, VISIO, SQL Server Data Diagram

Patch Management:

• Applied SP Service Pack on SQL Server 2000, 2005, 2008 and Windows Server 2008, 2003, 2000
• Applied HOT Fixes on SQL Server 2000, 2005, 2008 and Windows Server 2008, 2003, 2000

Database Monitoring/Performance Tuning:

• Strong on database Monitoring and Performance tuning
• Monitor SQL Server Error Log, space usage, Events, Jobs, customer complaints, Daily routine works
• Tools Used: SQL Server Error Log, Windows Event Logs, Profiler, Query Execution Plan, Index Tuning Advisor, Database Tuning Advisor, System Monitor, Perfmon, Counter etc

Backup/Recovery:

• Strong knowledge and working experience in Database Backup and Disaster Recovery
• Experienced with Point-in-Time Recovery
• Extensive knowledge on Restoring Databases using backups
• Experienced on Backing up databases to different medias such Local Drive, Network Drive, File Server, TAPE Media

Environment: SQL Server 2008 R2/2008, IIS 8.0/7.5, Windows Server 2008 R2/2008 , Toad Data Modeler, ASP, ASP.net, Java, ETL, Microsoft Word, Excel, PowerPoint.

Confidential

SQL Database Administrator/DBA

Responsibilities:

• Managed Development, Test, and Production databases
• Installed, Configured, and Managed SQL Server 2008, 2005, 2000 in development, test, and production environment

Backup/Recovery:

• Strong knowledge and working experience in Database Backup and Disaster Recovery
• Experienced with Point-in-Time Recovery
• Restored Database from backup
• Used DBCC to check database conditions, Rebuilding indexes and other database Maintenance purposes as well
• Strong working experience in creating, modifying tables, Index Cluster/Non-Cluster , Constraints Unique/Check , Views, Developed Different Maintenance Plans for database monitoring
• Developed Different Maintenance Plans for database monitoring
• Monitor Server Activity, Error Log, space usage, and solving problem as needed

Data Modeling:

• Worked on more than 10 data modeling projects and generated E-R Diagram
• Backward Forward Engineering with data modeling tools mentioned above
• Tools Used: ERWin, Quest Data Modeler, VISIO, SQL Server Data Diagram

Patch Management:

• Applied SP Service Pack and HOT Fixes on SQL Server 2000, 2005
• Applied Patch on Windows Server 2008 and 2003 Enterprise Edition

Database Monitoring/Performance Tuning:

• Strong on database Monitoring and Performance tuning
• Monitor SQL Server Error Log, space usage, Events, Jobs, customer complaints, Daily routine works
• Tools Used: SQL Server Error Log, Windows Event Logs, Profiler, Query Execution Plan, Index Tuning Advisor, Database Tuning Advisor, System Monitor, Perfmon, Counter etc

Database High Availability:

• Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2008
• Installed, Configured and Maintained Database Mirroring using automatic fail-over option
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Configured and Maintained Replications Transactional

Report Development:

• Installed, Configured, and administered SQL Server Reporting Services SSRS
• Developed, Deployed, and Managed Reports
• Managed Reports Security
• Tools Used: Developed Reports using BIDS Business Development Studio , and Report Builder 3.0, 2.0

Database Upgraded

• SQL Server 2005 to SQL Server 2008
• SQL Server 2000 to 2005/2008
• development, testing and production environment :

Database Migrated

• Tools Used: SSMA SQL Server Migration Assistant for MySQL, Access, and ODBC/DB Link
• My-SQL 4.1.0/5.0.1 databases to SQL Server 2005 and 2008
• MS Access 2003/2000/97 databases into MS SQL Server 2000, 2005, and 2008, 2008 R2.
• development, testing and production environment

Database Programming:

• Writing T-SQL, Trigger, and Stored-Procedures
• Assisted Database Developers to optimize SQL queries and Stored Procedures

DTS/SSIS:

• Export Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP
• Export Import data from/to databases like My-SQL, and Access to/from SQL Server

Environment: SQL Server 2008 R2/2005, IIS 6.5, 7.0, Windows Server 2003 R2/2008 R2, Toad Data Modeler, ASP, ASP.net, Java, ETL, SQL Server Reporting Services, , Microsoft Word, Excel, PowerPoint