SUMMARY

• Certified DBA with 7 years of experience with installation of MicrosoftSQLServerin Production, Development and Testing in Clustered and Stand - aloneServerEnvironments on both 32-bit and 64-bit systems.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Expertise in MS SQL Server,SQL Stored Procedures, Cursors, Views, Triggers and Indexes
• Extensive experience in MS SQL Server Installation, Configuration andUp gradation, Performance Tuning, Query Optimization.
• Experienced on Extraction, Transformation and Loading (ETL) process using DTS and other application tools.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and automating DTS/SSIS Packages.
• Expertise in planning and implementing MS SQL Server security, database permissions, Backup/Recovery, Client/Server Connectivity and running Database Consistency Checks.
• Experience in trouble shooting database issues and performing consistency checks using DBCC commands.
• Experience in developing SQL and Windows scripts
• Good knowledge in Normalization and building Referential Integrity.
• Hands on experience in using Performance tools like SQL Profiler, Index Tuning Wizard & Database Engine Tuning Advisor to troubleshoot and monitor SQL Server.
• Good experience in performance testing the databases using LoadRunner.
• Maintained Database authentication modes, creation of users, configuring permissions and assigningroles to users.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) DTS/SSIS packages.
• Experience in working on different OLAP environments.
• Expertise in T-SQL writing stored procedures, triggers and functions.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Experience in Disaster Recovery Planning and Security Management operations.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Having hands on experience in DR processes including Log shipping and Database Mirroring.
• Worked on SQL Server migrations.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Management of Database Space, Growth Monitoring of Data & Transaction log files.

TECHNICAL SKILLS

Operating Systems: Windows Server 2008/2003/2000 , Windows 7/Vista/XP/98/95, Win NT 4.0

RDBMS: MS SQL Server 2008/2005/2000/7.0/6.5 , MS ACCESS 2007/2003/2000/97

Applications: SQL Backup Pro, LiteSpeed, Backup Exec, MS Office/Visio, IP switch and Erwin data modeling tool

Tool: Diagnostic Manager, SQL IO Stress Test, HP-SIM, IBM-Director, GFI Disk keeper, NETIQ, Scom 2012, MOM 2005, Foglight

Programming: T-SQL, Triggers, Packages, and Stored Procedures

PROFESSIONAL EXPERIENCE

SQL Server DBA

Confidential, Tysons Corner, VA

Responsibilities:

• Migration of Databases to SQL Server 2012.
• Implementing Backup and Recovery Strategies.
• Configuring and Automating Maintenance plans.
• Troubleshoot and Tune the database for optimum performance.
• Worked on SQL Query Performance Analysis Resolution.
• Analyzed execution plan and cache analysis, Avoid latency on query performance by building indexes, utilize update statistic, and fragmentation analysis.
• Created groups, roles, users and assigning access privileges to users.
• Helped to developer team to troubleshoot on creating report for Budget Tie Out process.
• Implemented, deployed and maintained Log Shipping.
• Utilized various recovery models and recovered the database during the event of crash on several occasions. The Recovery was done to Point-in-time.
• Used database mirroring, clustering for the high availability environment.
• Setup clustering SQL Server 2008 on windows server 2008 in order to achieve high availability of mission critical databases.
• Worked closely with the application team, network team and storage teams on various projects.
• Created SSIS packages to transfer data between databases and Third party data source and destination.
• Automating the Backup and Maintenance of user databases using SQL Server Agent.
• Configuring Alerts to be fired in the event of failed backups or performance issues.

SQL Server DBA

Confidential, NJ

Responsibilities:

• Provided system administration team with suggestions regarding disk configuration, RAID level according to database sizing and capacity planning
• Actively involved in Installing SQL Server 2012, Maintenance and Performance Tuning
• Moved production databases to new servers within least downtime, and responsible for space allocation, Recovery(Backup/Restore) strategies, table maintenance
• Monitoring server performance with Windows Performance Monitor, SQL Profiler, Query Analyzer, Execution Plan, Server Trace, Client Statistics or system stored procedures
• Checked data file allocation, index, fill factor, fragmentation.
• Actively monitor impact on system performance to analyze existing or potential problems to optimize performance, and created jobs, alerts, activity logs, error logs to capture any possible errors
• Worked with developer to manage setup the procedure of database backup and restore.
• Performed SQL Server Log Shipping to send transaction logs of critical database (the primary database) to the secondary database on a constant basis to back up the primary database and enhance the SQL Server availability in environment of SQL Server 2005/2008
• Maintain data consistency and synchronization with other branches using Replication.
• Database Design and Development using SQL Server 2005 management studio
• Actively involved to monitor the performance and availability requirements of on-line systems and multiple applications, including normalizing or de-normalizing database design to achieve efficient storage or better performance
• Design and Implementation of Microsoft Business Intelligence in SQL Server 2008
• Migrated some DTS packages of SQL Server 2008to SQL Server 2012 to make them reused in new environment
• Created SSIS package to fulfill the SQL Server maintenance tasks including rebuilding index, backing up database and updating statistics

SQL Server DBA

Confidential

Responsibilities:

• Administrated Upgraded and Managed SQL Server 2008R 2/2008/2005/2000 databases in Production, QA and development environments and mentored other technical staff.
• Responsibilities include the Production and Application Support for the Database and Application Servers.
• Setting up and Monitored transactional replication, Database mirroring on Production, QA and Development servers.
• Implementation of Permission, Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Handled up to 2 TB Size databases with clustered and stand alone environment.
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
• Designed the Database Recovery plan and implemented the Database Mirroring in SQL Server 2008/2005 and participated in Disaster Recovery Drill processes.
• Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans which covers Database Integrity Checks.
• Implemented new features in SQL Server 2008 like Policy based Management, Table Compression, Backup Compression, SQL Server Auditing, Resource Governor and Merge statement in T-SQL.
• Integrated SQL traces with Perfmon log to have better graphical analysis to find system bottlenecks.
• Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.
• Created Stored Procedures, Triggers, Views and Functions for the Application.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related-errors.

SQL Server DBA

Confidential, Washington, DC

Responsibilities:

• Installed, Configured, and Managed SQL Server 2005 & 2008 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) 2005/2008
• Configured and Maintained Replications (Transactional)
• Configured Log Shipping as Standby database from Production database
• Upgraded databases from SQL Server 2000 to 2005/2008 in testing and production environment
• Migrated data from MS Access 97/00 and My-SQL 4.1.0 databases to SQL Server 2005 and 2008
• Applied SP (Service Pack) on SQL Server 2005, 2008
• Expertise in database Performance tuning
• Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers
• Data Modeling, developing E-R Diagram using VISIO and SQL Server Data Diagram
• Backward & Forward Engineering with data modeling tools mentioned above.
• Export & Import data from Flat file, CSV file, Oracle 10g, My-SQL, and Access 97/03 to/from SQL Server Database using DTS, SSIS, and BCP
• Generated Report using SSRS (SQL Server Reporting Services) and controlled security of the SSRS
• Strong knowledge and working experience in Database Backup, Restore and Point-in-Time Recovery
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
• Developed Different Maintenance Plans for database monitoring
• Monitor Server Activity, Error Log, space usage, and solving problem as needed by the Company.