Executive Summary

• Microsoft Certified SQL Server Database Administrator with 7+ years of experience in Database administration, Development and Technical Support with analytical and troubleshooting experience in Data Modeling, DR & HA Solutions, Backup, Performance Tuning, Maintenance Plan, Automation Jobs, SSRS, SSIS, Security, SharePoint, etc. for different SQL Server versions on different Operating Systems.
• Successfully install, configure and maintain SQL Server 2000, 2005, 2008 and 2008R2.
• Configure and maintain SQL Server and Services, Startup parameter.
• Successfully upgrade and apply service packs, patches.
• Experienced in migrating databases from Oracle, MySQL, Access and other SQL Servers to different versions of SQL Servers.
• Assist SQL developers in Query Optimizations.
• Importing and exporting data between SQL Server and other sources such as Flat file, CSV file, Oracle, MySQL, Access, ODBC/OLEDB data sources, etc. using SSIS and Import/Export Wizard.
• Experienced in creating and maintaining high availability solutions including Database Mirroring, Log Shipping, Replication, and Clustering.
• Modify, Schedule and maintain PowerShell scripts to move data faster and efficiently.
• Able to install, configure and administer SQL Server Reporting Services (SSRS) Develop, Deploy, Manage Reports and Manage Reports Security.
• Created and managed database security, data encryption and applied object level security.
• Experienced in database Monitoring and Performance tuning
• Practice of root cause analysis by using Wait Statistics, DMV, SP.
• Maintain database security by creating and monitoring user logins and groups with appropriate roles and assigning perspective server or object level permission.
• Implement and maintain Database and SQL mail.
• Create and maintain plans for automation jobs, such as Rebuild Indexes update status, DBCC commands, etc. to keep database optimized, consistent and maintain data integrity.
• Generate and execute queries against SQL Diagnostic Manager - SQLdm Repository (IDERA) to resolve Lock, Block, Dead Locks, long running queries and slow running server.
• Experience in PowerShell Importing and Updating data from others files such as Flat file, CSV file, Oracle, MySQL, Oracle, MS Access, excel ODBC/OLEDB data source etc.
• Use third party tools such as RedGate SQL Backup Pro for backup/restore and IDERA SQL Diagnostic Manager for monitoring.

Technical Skills:

Database: SQL Server 2012, 2008 R2, 2008, 2005, 2000, MS Access, MYSQL (4.0.3, 5.0.1), Oracle 10g

SQL Tools: SQL Server Management Studio, Enterprise Manager, Upgrade Advisor, Query Analyzer, SQL Profiler, Database Tuning Advisor and Index Tuning Wizard, Business Intelligence Development Studio, SQLCMD, Reporting Services Report Manager, Reporting Services Configuration and Report Builder, SQL Configuration manager, SSIS, SQL Server Data Diagram

ETL Tools: SSIS, DTS

Reporting: SSRS (SQL Server Reporting Services/Server), Report builder.

Programming Language: Transact-SQL, ASP, ASP.net, VB/JavaScript HTML, C, C++, .Net, XML.

Operating Systems: Windows NT 4.0 (Desktop/Server), Windows 2003/2008 server, Active Directory, Windows XP/7, LINUX, Ubuntu, Solaris, Red Hat, UNIX, VMware.

Monitoring Tools: Idera, System Monitor, Counter, Windows Event Logs, Activity Monitor

Web Application: SharePoint enterprise

Web Server: IIS 5.0, 6.0, 6.5, 7.0, 7.5

Other Tool: SSMA (SQL Server Migration Assistant) and ODBC/DB Link, Toad Data Modeler, RedGate, VISIO

Professional Experience

Confidential

SQL Server Database Administrator / SQL Server DBA

Job Responsibilities:

• Install, configure, and manage SQL Server 2005 & 2008 &2008R2 in development, test, and production environment.
• Install, Configure and Maintain Fail-Over Clustering using SQL Server 2008.
• Configure and Maintain Replications, Log shipping as part of a high availability solution.
• Upgrade databases from SQL Server 2005 to 2008 in testing and production environment.
• Apply SP (Service Pack) on SQL Server 2008 &2008R2.
• Responsible for creating, modifying and managing tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers.
• Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company’s databases and systems.
• Monitor Server Activity, Error Log, space usage, and solving problem as needed.
• Manage and resolve trouble tickets (Remedy) for database-related issues submitted.
• Designed DR database backup and restore plan.
• SQL Server performance statistics collection, Server monitoring and performance tuning.
• User account management and connection troubleshooting.
• Database capacity planning, Maintenance planning, SQL Agent Jobs scheduling and troubleshooting.
• Implement and maintain database security, SQL Mail Manage small, medium and large SQL Server 2008 projects.
• Experience writing SQL queries, Stored Procedures, Triggers, Functions, creating Tables, Views and Indexes.
• Audit and generate monthly management reports using third party tool.
• Create the database, tables, table spaces, data objects, setting privileges, indexes, user logins, and passwords (security).
• Promote/migrate SQL-Server objects from development to QA and QA to production instances.
• Provide support to application developers in designing and implementing physical database structures.
• Implement security, generate and review report periodically and enforce security mechanism
• Maintain database integrity of all vendor and in-house databases.
• Resolve and troubleshoot database issues, and perform upgrades, conversions and deployments.
• Proactively monitored the production database(s) and optimize stored procedures for better performance.
• Resolve locking conflicts and resource utilization

Confidential

SQL Database Engineer

Responsibilities:

• Managed dedicated databases and servers.
• Installed and Configured SQL Server 2000, 2005, 2008, 2008R2 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.
• 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.
• Used DBCC and Alter statements for different database
• Administered 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.

Confidential

SQL Database Administrator

Job Responsibilities:

• Installed, Configured, and Managed SQL Server 2000 & 2005 in development, test, and production Environment.
• Successfully migrated SQL 2000 databases to SQL 2005.
• Applied SP (Service Pack) on SQL Server 2000, 2005.
• Upgraded databases and database objects, including logins, stored procedures, and jobs from MSSQL 2000 to MSSQL 2005.
• Automated daily backup/restore processes, implemented batch jobs to automate DBA maintenance tasks.
• Implemented and maintained high availability systems (database mirroring, log shipping, Replication).
• Created and managed database maintenance plans and design and implemented backup and disaster recovery plans.
• Defined and enforced database standards, policies, security and documentation.
• Prepared database structure and configured high-performance through Analysis and Optimization.
• Diagnosed problems using tools such as SQL Profiler and System Monitor, work with vendors and developers as needed to resolve issues.
• Responsible for creating, modifying and managing tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers.
• Exported & Imported data from Flat file, CSV file, Oracle, MySQL, and Access to/from SQL Server Database using DTS, SSIS, and BCP.
• Data modeling using Toad Data Modeler and Visio.
• Generated Report using SSRS (SQL Server Reporting Services).
• Responsible for Database Backup, Restore and Point-in-Time Recovery.
• Monitored database systems performance, capacity and availability.
• Worked on data mapping and conversion; manage disk space, change control and bug fixes.
• Developed and implemented Disaster Recovery (DR) on production SQL Server 2005.
• Managed and resolved trouble tickets (Web Track) for database-related issues submitted by customers.

Confidential

SQL DBA

Job Responsibilities:

• 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 worked 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.
• Developed and applied Backup strategy.