SUMMARY

• Over 6 years of IT experience in SQL Server Database Administration, Management,Upgrade Migration and Development.
• Worked as Server DBA and SQL Developer with technical expertise in Database creation and maintenance in multiple SQL Server database versions.
• Extensively worked on Installation and Configuration of MS SQL Server 2008R 2/ 2008/2005/2000 .
• Planned and implemented MSSQL Server Security and Database permissions.
• Implemented Database Backup, Recovery and Disaster Recovery Procedures.
• Experienced in configuring Database High Availability techniques like Database Mirroring, Log Shipping, Clustering and Recovery on SQL Server 2005 and 2008.
• Experienced in implementing different types of Replication Models such as Transactional, Snapshot and Merge inSQL Server 2008/2005/2000 inOLTP environments.
• Migrated data between servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services(SSIS).
• Experienced in Database Performance Tuning, Query Optimization, Client / Server Connectivity / Network Issues, Named Pipes, TCP/IP Protocols, Troubleshooting, Database consistency checks using DBCC Utilities.
• Experienced in writing and debugging Stored Procedures,Functions and Triggers.
• Good knowledge of RAID systems.
• Expert on Performance Monitor, SQL Profiler and Database Tuning Advisor to solve Dead Locks / long running queries.
• Experience in investigating and applying necessary SQL Server database patches and installing service packs.
• Extensive experience with Table Design, Index Design and SQL 2005 Online Indexing.
• Involved in optimizing code and improving efficiency in databases including rendering, updating statistics, recompiling stored procedures and performing other maintenance tasks
• Excellent analytical, communication, interpersonal skills and also have the ability to work effectively as a team member in determining requirements and application scope.

TECHNICAL SKILLS

Database Application Software: SQL Server 2000/2005/2008/2008 R2, MS Access.

DB Utilities: SQL Server Management Utilities, Query Analyzer.

GUI: SQL Server Integration Services.

Reporting: MS Access, Excel, MS SQL Server Reporting Services 2000/2005/2008/2008 R2, SSIS

Application Software: Microsoft Office, Macros, Visual Studio.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

SQL DBA

Responsibilities:

• Installed SQL Server 2008R2 in production environment.
• Worked on database planning in relation to physical and logical data architecture.
• Tested Backup and Recovery Strategies in recovery scenarios like loss of data files, Transaction logs, read only table spaces, Point - in-time recovery.
• Maintained security on the server and database level by creating logins.
• Created automated jobs, operators and alerts using SQL Server Agent.
• Managed high data availability using Database Mirroring.
• Written stored procedures, triggers and indexes.
• Managed the use of disk space, memory and connections.
• Monitored SQL Server and current activity using SQL Profiler and system monitor.
• Extensively used DBCC consistency checks, and to fix data corruption in application databases Monitor and tune SQL scripts.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Performed query plans and making sure each query is using appropriate indexes.
• Migrated data from SQL Server to SQL 2008 using Visual studio 2008 package.
• Used Microsoft Visual Studioto Import/Export from different servers like SQL Server to SQL Server
• Modified Data Flow tasks using Visual Studio 2008.
• Generated the Flat Files data loads for the initial conversion of user data using SSIS.
• Exported and imported data from text files and Excel to SQL Server database using bulk insert.
• Worked on Authoring Reports and managing reporting services.
• Provided on - call 24/7 provide support.
• Provided support for in-house and offshore Development Team.

Environment: SQL Server 2000/2005 Enterprise Edition, SQL, Enterprise Manager, T-SQL, MS PowerPoint, MS Project & Windows 2003 server, SQL Server 11g .

Confidential, Chicago, IL

SQL DBA

Responsibilities:

• Installed and configured SQL Server 2008 and 2008 R2 Enterprise Edition Environment.
• Upgraded SQL Server 2005 and SQL 2008.
• Installed and Configure SQL 2008, SQL 2008 Active-Passive Cluster on Windows 2008 production servers.
• Day-to-day Technical Support on MS SQL Server 2005 and 2008 Servers Platform for Production, Test and Development Environments (Clustered/non-clustered).
• Implemented code changes and configuration changes (if needed) and other administrative activities.
• Created Snapshot and Transactional replication.
• Technical support to users for various purposes like Access change, performance issues and storage space managements on RAID/SAN drives.
• Prepared RCA (Root Cause Analysis) using Profiler Trace, Performance counters with System Monitor.
• Implemented DatabaseMirroring for Disaster Recovery.
• Recommend possible remedies for better performance.
• Involved in using DB Tools like Idera.
• Worked in cooperation with developers/team for achievement of efficient database access for applications. This includes activities like designing, adding, eliminating, or maintaining indexes, organizing tables, recommending SQL changes to application development teams.
• Ensured all scheduled administrative/business jobs are running/completed for daily/adhoc business cycle on Microsoft SQL Servers in Production, Dev and QA Environment.
• Set up Transactional and snapshot Replication for Production Environment.
• Used DBCC commands for administration of database objects and system performance.
• Transformed data from various data sources like MS Access, MS Excel, and SQL Server using OLE DB connection by creating various DTS packages.

Environment: MS SQL Server 2008/2005, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), SQL Server Query Analyzer, SSIS, OLTP.

Confidential, Buffalo, NY

SQL DBA

Responsibilities:

• Installed SQL Server 2008 in production and development environments.
• Successfully upgraded from SQL Server 2000 to SQL Server 2005 on Development and Testing Environments.
• Involved in system requirements and the upgrade matrix for SQL Server 2005.
• Worked in 2- nodeActive/PassiveClustered Environment.
• Involved in migrating DTS packages from SQL Server 2000 to SSIS packages in SQL Server 2005 database.
• Successfully implemented Database Mirroring with High Availability Mode in SQL 2005.
• Implemented Log Shipping in SQL 2005 from Primary Server to Standby Server to support DR Solution.
• Worked in 24x7 production environment.
• Integrated SQL Server 2005 reporting services with Microsoft Share Point Portal Server to deliver automatically generated reports to a Share Point portal.
• Involved in Performance tuning, optimization of stored procedures and queries.
• Rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
• Monitored Performance with SQL Profiler, Perfmon and using a monitoring tool called DBArtisan.
• Created Logins and Roles with appropriate permissions.
• Prepared and documented database Backup & Maintenance Plans.
• Acted as a liaison between the offshore team and onshore team.
• Provided assistance and mentoring staff for developing conceptual, logical and physical database designs.

Environment: MS SQL Server 2008/2005, DTS, Windows 2003, SQL Server Management Studio, SSIS, SQL Server Business Intelligence Development Studio(BIDS), SQL Server Query Analyzer, OLAP.

Confidential, Charlotte, NC

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2005 on servers successfully.
• Involved in designing Flow charts, Data flow Diagrams etc. for the business documents and categories using Microsoft VISIO.
• Involved in Data modeling to develop the database design and defined primary and foreign keys using Erwin 4.0
• Developed SQL queries to fetch data as per the business requirements with proper tuning techniques.
• Created checks and constraints to maintain data integrity across the data in the database.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins
• Performed Index analysis on tables and developed more efficient solutions using Clustered, Non-Clustered and online Indexes for performance boost.
• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS).
• Worked on Client/Server tools like SQL Server Enterprise Manager for application performance, configuration management and Query Analyzer to improve application performance by monitoring and tuning the queries.
• Created Views to facilitate easy user interface implementation, and Triggers on them to facilitate consistent data entry into the database.
• Created Stored Procedures and functions to support efficient data storage and manipulation.
• Configured various Publishers and Subscribers for Snapshot and Merge replications.
• Generated Crystal Reports on web platform to generate reports based on viewer customization

Environment: SQL Server 2005, Microsoft Visual Studio, DTS, Query Analyzer, Erwin, Crystal Reports, VSS and Windows 2000.

Confidential

SQL DBA

Responsibilities:

• Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application.
• Provided 24 X 7 dedicated supports for the claims records database.
• Provided 24 X 7 supports for Production environment.
• Planned and modified the permission issues in the production servers.
• Server & Application fine-tuning & trouble shooting, Monitoring MS SQL Server performance and windows server issues.
• Created the backup and restore strategy for production environment.
• Worked with SQL server Profiler generated traces to optimize the performance of the database.
• Installed and configured active/passive clustered environment.
• Rebuilding indexes on various tables.
• Resolving locking and blocking issues.
• Installed and configuredSQL Server bit in a Test Environment and migrated & tested databases to production server.
• Implemented log shipping in standby mode to support DR servers.
• Documented and tested Mergereplication in test environment for generating reports.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the performance of the server on daily basis in email format.
• Provided technical assistance and mentoring to staff for developing conceptual and logical database design and physical database.
• Assisted other teams in stress-testing applications, locating bottlenecks, and recommending possible solutions.
• Responsible for quality control and auditing of databases to ensure accurate and appropriate use of data. Worked with management to develop database strategies to support company needs.
• Responsible for creating and maintaining technical documentation for the database environment.

Environment: SQL Server 2000/2005 Enterprise Edition, Windows 2000 Advanced Server, Windows 2003 Enterprise Edition, Idera Diagnostic Manager.

Confidential

Jr. SQL DBA/Developer

Responsibilities:

• Installation and configuration of SQL Server 2000.
• Created new database using SQL Server Enterprise Manager, Database Wizard and T-SQL Statements.
• Tuned the database to perform efficiently by managing databases using the options to grow or shrink database files and monitored the size of the transaction log.
• Managed databases on multiple disks using Disk Mirroring and RAID technology
• Used log shipping for synchronization of database.
• Completed documentation about the database and analyzed long running slow queries/stored procedure for better tuning.
• Involved in automation of the job and was also involved in daily monitoring of the tables and indexes to ensure excellent performance.
• Analyzed the problems in the production environment and developed new procedures and methods to monitor problems and automate alert messages to take pro-active action.
• Performed daily backup on System and Users database.
• Setup Replication and Database Mirroring to ensure high availability.
• Worked on DTS, BCP Import and Export utility for transferring data.

Environment: Windows 2000 Server, T-SQL, SQL Server 2000, Access 2000.