Experiences:

• Lead on Database upgrade and migration
• Master of database Backups and Restoration
• Installing, Configuring, Updating, Deploying and Administering Databases in Test, Development and Production environment
• Deep understanding and working experience as a Database Administrator of SQL Server SQL 2000, 2005 and SQL 2008 , MS Access, Sybase, and MySQL
• Performed Data Modeling, data analysis, database design, and developing E-R diagram using ERWin, Toad Data Modeler, Visio
• Backward Forward Engineering with data modeling tools mentioned above
• Implementing business rules in Database.
• Setting up referential integrity to maintain data integrity
• Performance Monitoring and Tuning for Instance, Database, and SQL Query using execution plan, Profiler, Database and Index Tuning Tools
• Monitor Server Activity, Error Log, space usage, and solving problem as needed
• Third party tools used for Performance monitoring and tuning SpotLight, and Idera SQL Diagnostic Manager
• Strong knowledge and experience in configuring and administering High Availability Solutions like Database Mirroring, Replication, Log shipping, and Clustering
• Vast knowledge and working experience on SSIS, and DTS for data movement and manipulation
• Proven experience on SQL Server Reporting Services, using SQL/T-SQL Scripting for customized Report Generation and Management
• Create, set-up, and manage Jobs for Database Automation like index management, fragmentation management, backup, statistics etc.
• Used Microsoft Best Practices with regards to configuration of SQL data/log drive locations
• Managed Security and database Audit
• Proven experience in installing, upgrading, and maintaining Database servers, Web 2008
• Applied Service Pack SP for Databases, Operating Systems
• Migrated databases from other databases like Oracle 10g, MySQL, MS Access, and Sybase to SQL Server 2005 and 2008
• Upgraded SQL Server 2000 to SQL Server 2005/2008 and SQL Server 2005 to SQL Server 2008
• Working experience in configuring and setup Database Mail Server for database mail notification
• Moved and deployed databases in test and production environment
• Managed logins and security
• Experience in administering AD Active Directory /Domain and monitoring user activities
• Documentation: wrote so many documentations like baseline for SQL server, clustering documentation, database requirement analysis, data modeling, applying service pack, deployment documentation etc
• Working experience with SAN and RAID
• Best in providing excellent customer support, dealing with non-technical, and upper level management
• Experienced in providing end-user support on a day-to-day basis
• Enjoy working in a team environment and independently as well
• Programming: SQL, T-SQL, .Net, ASP.Net, HTML

Professional Work History

Database Administrator

Confidential

Main Responsibilities:

• Responsible for managing dedicated databases and servers
• Installed and Configured SQL Server 2000, 2005 2008 in development, test and production environment
• Installed and Configured Operating System Windows Server 2000, 2003 and 2008
• Migrated databases from Oracle 10g, MySQL 4.0.3, 5.0.15 to SQL Server 2008
• Upgraded earlier versions of SQL Server 2000 to SQL Server 2005/2008 and SQL Server 2005 to SQL Server 2008
• Migrated MS Access 2003/2000/97 databases into MS SQL Server 2000/2005/2008
• Closely work with business analyst to deploy databases and manage availability
• Rebuild Servers Restore Recover from backups
• Configured and Managed Log Shipping from Production to Standby Server Running as Reporting Server

• Configured and Managed Database High Availability: Replication, Database Mirroring, Log Shipping, and Clustering

• Wrote SQL, T-SQL, Triggers and Stored-Procedures
• Worked with developers to tune-up performance of SQL and T-SQL query
• Performance tuning optimization of servers in production, test environment
• Created and managed database security, data encryption, and applied object level security
• Developed and applied Backup strategy at my current workplace
• Setup and configured Database mail for notification purposes
• Developed Database Maintenance Plan for different important tasks
• Used DBCC and Alter statements for different database Administration tasks like check database consistency, rebuild indexes, statistics, and other jobs
• Used DMV Dynamic Management View for different database Administration tasks like find backup history, indexes fragmentation, statistics, and status of different jobs
• Exported Imported database objects from/To Oracle, MySQL, Access Database, flat files text, excel, and CSV files and MS SQL Server
• Extensive experience in using SSIS/DTS, BCP to import export data from flat files, excel, MS Access, and Other OLEDB databases to MS SQL Server databases
• Worked on more than 10 Data Modeling projects includes interviewing stakeholders, gathering/analyzing requirements, developing E-R Diagram, designing Logical Physical Database using ERWin, Toad Data Modeler and Visio

Confidential

SQL Database Administrator

Main Responsibilities:

• Installed, Configured, and Managed SQL Server 2000 2005 in development, test, and production environment
• Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2005
• Installed and Configured SQL Server Reporting Services SSRS
• Configured and Maintained Replications, Log Shipping as part of a high availability solution
• Upgraded DB from SQL Server 7.0/2000 to 2005 in testing production environment
• Applied SP Service Pack on SQL Server 2000, 2005
• Expertise in database Performance tuning and writing T-SQL and Stored-Procedures
• Responsible for creating, modifying and managing tables, Index Cluster/Non-Cluster , Constraints Unique/Check , Views, Stored Procedures, Triggers
• Export Import data from Flat file, CSV file, Oracle, MySQL, and Access to/from SQL Server Database using DTS, SSIS, and BCP
• Generated Report using SSRS SQL Server Reporting Services
• Responsible for Database Backup, Restore and Point-in-Time Recovery
• Monitor Server Activity, Error Log, space usage, and solving problem as needed

Confidential

SQL DBA

Main Responsibilities:

• Installed, Configured, updated and Administered SQL Server 2000 2005 in development, test, and production environment as required
• Supported dedicated database and Servers
• Restored and Recovered from Backups and Rebuild Servers
• Managed SQL Server Reporting services using SQL/T-SQL Scripting for customized Report Generation and Management
• Applied SSIS and DTS for data movement and manipulation
• Solved day to day problems like error log, space usage using Monitor Server Activity
• Monitored Performance and Tuning for Instance, Database, and SQL Query using execution plan, Profiler, Database and Index Tuning Tools
• Moved and deployed databases in UAT/BAT and production environment
• Administered AD Active Directory /Domain and monitoring user activities
• Created and Managed database security, data encryption, and applied object level security