SUMMARY

• Five years of experience as a SQL Server DBA with detail - oriented, analytical and troubleshooting experience in different aspects of SQL Server, including installation and configurations of SQL Server, Database High Availability Solutions, SQL Server Reporting Services (SSRS), data modeling, DR (Disaster Recovery) Solution, backup/recovery, performance tuning, stored procedures, triggers, functions, constraints, etc.
• Four years of experience with data modeling
• Strong knowledge on using database third party tools: SpotLite, RedGate, ERWin, Toad Data Modeler for Database Administration, Data Modeling and Performance Tuning using different Tools like Profiler, Execution Plan, PerfMon, Database Tuning Advisor, DMV and Activity Monitor.
• Solid working experience in managing large databases in 24/7 data processing environments, including developing and managing reports using SQL Reporting Services (SSRS) and Monitoring.
• Strong work experience and knowledge with SQL Server Database High availability using Standby, Replication, Database Mirroring, Clustering and Log Shipping - includes Installation, Configuration and Administration.
• Strong Database Administration experience with MS SQL Server 2000, 2005, 2008), MS Access 2000 & 2003.
• Database Monitoring, Performance Tuning and Query Optimization.
• Backup/Recovery and Security Management.
• Upgraded databases from SQL Server 2000 to SQL Server 2005/2008 and SQL Server 2005 to SQL Server 2008 R2.
• Database Migration: Migrated Oracle (10gR2, 11gR2) and MySQL (4.0.3, 5.0.15) database to SQL Server 2008.
• Deployed databases to different environments in development - test and production environment.
• Data Modeling, including script generation and forward/backward engineering
• Windows Operating Systems (2000, 2003, 2003R2, 2008, 2008R2): Installation, Configuration, User and Security Management.
• Strong knowledge and experience in administering Web Server (IIS-Internet Information Services), including installing, configuring and monitoring.
• Deployed Web Applications in web server in development, test and production environment.
• Working experience on Operating Systems (O/S) include Windows Server 2008, 2008 R2/2003, 2003 R2, Windows XP/7.
• Working experience also includes installing, configuring, and administering the above operating systems.
• VMWare - installed, configured and administered SQL Server 2008, 2008 R2, 2005 and 2000.

TECHNICAL SKILLS

Database: SQL Server 2012/2008R2/2005/2000, MS Access 2003 and 2000

SQL Tools: Query Analyzer, Profiler, Query Execution Plan, and Counter

Reports Development/Management: SSRS (SQL Server Reporting Services), MS Access and Excel

Data Modeling: Toad Data Modeler, ERWin and SSDD (SQL Server Database Diagram)

Programming: SQL, T-SQL,JOIN, Store Procedures, Trigger and Functions

Operating System: Windows Server 2008/R2, 2003/R2, 2000 and VMWare

Hardware/Storage: SAN and RAID

Performance Monitoring Tool: Profiler, Execution Plan, PerfMon, Database Tuning Advisor, DMV and Activity Monitor

PROFESSIONAL EXPERIENCE

Confidential

SQL Database Administrator

Responsibilities:

• Installed, configured and managed SQL Server 2008, 2005 and 2000 in development, test and production environment.
• Worked on data modeling projects using E-R Diagram.
• Backward & Forward engineering for logical and physical model respectively.
• Data Modeling tools used: ERWin, Toad Data Modeler.
• Created and managed Indexes and Constraints.
• Installed and configured SQL Server 2008 for testing different features and stability.
• Performed Database Backup and Disaster Recovery.
• Performed Point-in-Time Recovery.
• Restored Database from backup.
• Wrote documentation on Backup and Recovery Strategy.
• Managed Cluster Environment.
• Configured and managed Database Mirroring and Log Shipping as standby database from Production database for reporting purposes.
• Configured and maintained Replications.
• Upgraded SQL Server 2000 and R2.
• Applied SP (Service Pack).
• Migrated MS Access and My-SQL 4.1.0/5.0.15 databases to SQL Server 2008 R2.
• Monitored Database Health.
• Performed Performance tuning.
• T-SQL, Trigger, and Stored-Procedures.

Environment: Windows Server 2008 R2, 2003 R2, IIS 7.5, 6.5, SQL Server 2008 R2, 2005, 2000, ASP, ASP.net, PHP and AD (Active Directory)

Confidential

SQL Database Administrator

Responsibilities:

• Installed, configured and managed SQL Server 2008, 2005 and 2000 in development, test and production environments.
• Worked on data modeling projects utilizing E-R Diagram, ERwin and Toad data modeler.
• Installed and configured SQL Server 2008 for testing different features and stability.
• Database Backup and Disaster Recovery experience.
• Experienced with Point-in-Time Recovery.
• Restored Database from backup.
• Installed, configured and maintained Database Mirroring, including automatic fail-over option in SQL Server 2008.
• Configured Log Shipping as Standby database from Production database for Reporting purposes.
• Maintained Fail-Over Clustering using SQL Server 2008/2005.
• Configured and maintained Replications.
• Used DBCC to check database conditions, fix database corruption, rebuild indexes and other database maintenance purposes as well.
• Installed, configured and administered SQL Server Reporting Services (SSRS).
• Developed Reports for different purposes like DBA Reports, user reports using SSRS and Report Builder 3.0 & 2.0.
• Deployed Reports and managed security of report server including folder level.
• SQL Server /2008/2008 R2.
• SQL Server 2005 to SQL Server 2008/2008 R2.
• MS Access 2003/2000/97 databases into MS SQL Server 2000, 2005 and 2008.
• Oracle 10gR2/11gR2 databases to SQL Server 2008 R2.
• My-SQL 4.1.0/5.0.15 databases to SQL Server 2005 and 2008 R2.
• Applied SP (Service Pack) on SQL Server 2000, 2005, 2008 and 2008 R2.
• Applied Patch on Windows Server 2003 and 2003 R2.
• Database Monitoring and Performance tuning.
• Scheduled jobs to automate different activities, such monitoring database health, disk space, job alert, index monitoring, stats monitoring, etc.
• T-SQL, Trigger and Stored-Procedures.
• Assisted Database Developers to optimize SQL queries and Stored Procedures.
• Export & Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS and BCP.
• Export & Import data to/from databases like Oracle, My-SQL and Access to/from SQL Server.

Environment: Windows Server 2008 R2, 2003 R2, IIS 7.5, 6.5, Apache Tomcat 5.5, SQL Server 2008 R2, 2005, ASP, ASP.net, PHP and AD (Active Directory).