SUMMARY:

• Over 7 years of SQL Server Database Administration experience wif an emphasis on design, development, enhancement, automation, tuning and optimizing databases for high Availability, Performance and Security
• Experience in Administration & Support of MS SQL Server 2000, 2005, 2008R2 in Production, QA & Development environments.
• Expertise in SQL Server 2000, 2005 and 2008R2, SQL Query Analyzer, SQL Server Management Studio and Business Intelligence Development Studio, scheduling jobs wif SQL Server Agent, SQL Server Storage Structures, Index and Security Architecture and SQL Profiler.
• Experience in migrating SQL 2000 servers to SQL 2005 and SQL Server 2000 to SQL Server 2008R2.
• Possess strong skills in developing processes for Importing, Exporting and Mapping of large volumes of data and integrating wif external systems
• Experience in Supporting Production Servers 24x7, on - call basis
• Expertise in defining Database Backup, Recovery and Disaster Recovery Procedures
• Proficient at Performance Tuning wif a solid knowledge of Optimizing Code and Improving Efficiency in databases including Query Tuning, Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks
• Experience in supporting Very Large databases (VLDB), troubleshooting teh problems
• Installed, Configured and Maintained SQL Server Failover Clustering.
• Experience in handling Database performance issues, database capacity issues, Replication, Clustering, Mirroring and other distributed data issues
• Experience in data partitioning which is used in splitting large table into few smaller tables.
• Experience in data warehousing including business intelligence tools- DTS(ETL), SSIS(ETL) and SSRS.
• Experience wif SQL Server Security and SQL Server Auditing and Encryption.
• Proficient at Documentation of Database Architecture according to established standards, capacity to balance both short and long term issues effectively and handle many simultaneous and often changing priorities.

TECHNICAL EXPERIENCE:

Relational Databases: SQL Server 2008R2/2005/ 2000, MySQL

Database Technologies/Tools: SQL Server Management Studio, SQL Server Profiler, SQL Server Query Analyzer, Index Tuning Wizard, DTS Import/Export SSIS, SSRS, Silverlight, Business Objects and Crystal reports.

Operating Systems: Windows XP, 2003, 2000, NT, 98, UNIX and Linux.

Network Protocols: TCP/IP on Windows NT 2003/2000

Programming Languages: T-SQL, PL/SQL, C, C#, HTML, XML.

Applications: Microsoft Office, Adobe PhotoShop.

PROFESSIONAL EXPERIENCE

Confidential, TX

SQL Server DBA

Responsibilities:

• Responsible for 24/7 critical production servers support.
• Involved indatabase designandupdatedschema objectslike tables, functions, store procedure
• Closely worked wif business analyst for capacity planning, storage and data archiving that would help in load balancing of teh present OLTP database.
• Performed daily backups and developed recovery procedures.
• Created and Modified Stored procedures for SQL-Server databases
• Resolved deadlock issues of an application using SQL Profiler.
• Worked wif developers to tune teh queries, run scripts and Confidential teh database production to development servers.
• Configured and maintained Snapshot and Transactional replication for 3 environments.
• Troubleshooting replication errors and handling logs.
• Created schema objects, rules and granted roles to teh users.
• Involved in installation and configuration, and participation in database design and SQL scripting.
• Worked and coordinated wif developers in writing and tuning new stored procedures.
• Responsible for stored procedures optimization, performance tuning and index tuning.
• Worked on data conversion of teh legacy systems data into MS SQL server using SSIS packages extensively.
• Set up backups for teh newly created databases in SQL-Server..
• Scheduled transfer of backups and log files to different servers.
• Provided a support for data issues and given appropriate solutions.
• Provided training to development team on performance tuning and SQL best practices for enhancing application output.
• Created SSIS packages to pull data from DB2, Access.
• Created teh documentation for SQL server and service packs installations.

Environment: MS SQL server 2005/2008R2, WindowsXP, Enterprise Manager, Query Analyzer, SQL Server Profiler, SQL Server Management Studio and SSIS.

Confidential, IA

SQL Server DBA

Responsibilities:

• Administered SQL Servers in 4-tier environment (Dev, SIT, UAT and Prod).
• Worked on upgrade projects (from SQL Server 2000 to SQL Server 2005)
• Worked on migration projects (databases moving off of Polyserve to VM).
• Setup and maintained Snapshot and Transactional Replication to our Reporting servers.
• Setup and Maintained Log Shipping and Clustering (Active-Passive configuration) to our BCP (Business Continuity Plan) servers (located off site).
• Involved wif SQL Server Performance Monitoring, Server and Database optimization and Query tuning.
• Performed administrative activities like creating user logins wif appropriate roles, granting and denying login privileges, monitoring teh user accounts, creation of groups, granting database and application roles to users and groups.
• Worked on performance tuning of servers.
• Created SQL traces using SQL Profiler Wizard to analyze any performance issues.
• Maintained our team’s inbox where requests (issues, tickets, model changes, physical db changes, clear case deployments etc) from teh users come to.
• 1 full week of 24 x 7 on-call support every 5 weeks.

Environment: MS SQL server 2000/2005/2008, Windows 2000/2003, Unix, Enterprise Manager, Query Analyzer, SQL Server Profiler, SQL Server Management Studio, SSIS,, SSRS, Sharepoint 2007, Performance Point Dashboards, ASP.NET, C#, VB.NET, Visual Studio 2008, Win Forms, HTML, DHTML, XML, XSLT, JavaScript, IIS 6.0.

Confidential, AL

Production Support DBA

Responsibilities:

• Administered SQL Servers in development and production environments.
• Setup and maintained transactional replication One Publisher and 4 subscriber environment for production servers. These subscribers are located in CT, England and NJ
• Setup and Maintained Log Shipping and worked on Cluster setup on VMware.
• Dropped and recreated teh indexes on tables for performance improvements.
• Rewritten teh stored procedures on teh new servers.
• Worked on creating SQL traces using SQL Profiler Wizard and also efficiently used teh PerfMon utility to capture hardware bottlenecks
• Involved wif SQL Server Performance Monitoring, Server and Database optimization and Query tuning.
• Performed administrative activities like creating user logins wif appropriate roles, granting and denying login privileges, monitoring teh user accounts, creation of groups, granting database and application roles to users and groups
• Used to back up user & system databases and restore them when necessary.
• Used batch processing to load lot of data from teh legacy system to SQL Server.
• Used SSIS to transfer data from OLTP databases to staging area
• Worked on 2-10 tickets per day.

Environment: MS SQL server 2000/2005, Windows 2000/2003, Unix, Enterprise Manager, Query Analyzer, SQL Server Profiler, SQL Server Management Studio, SSIS, SSAS, ASP.NET, C#, VB.NET, Visual Studio 2008, Win Forms, HTML, DHTML, XML, XSLT, JavaScript, IIS 6.0and SSRS.

Confidential, PA

Developer/ DBA

Responsibilities:

• Upgrade experience of SQL Server 2000 to 2005. Experience in applying Service Packs at database and OS Level.
• Migrated all teh DTS packages.
• Assisted wif teh implementation of Snapshot and Transactional Replication for teh reporting databases.
• Created teh Maintenance Plan for optimization and integrity check for all SQL servers.
• Used DBCC utilities, updated index statistics, monitored database and disk space; involved in security issues and scheduled tasks.
• Worked on migration and maintenance of data using various utilities like Import and Export via BCP.
• Setup and maintained Database Mirroring.
• Monitored Databases for Lock Escalation, Deadlock, resource utilization by sessions, capturing long running SQL queries, fine-tuning SQL statements that better result in efficient SQL statements processing.
• Modified existing Stored Procedures.
• Involved in query tuning processes for SQL developers
• Worked on creating SQL traces using SQL Profiler Wizard. Performed administrative activities like creating user logins wif appropriate roles, granting and denying login privileges, monitoring teh user accounts, creation of groups, granting database and application roles to users and groups
• Maintained teh Failover Cluster Architecture for SQL Server databases for mission critical applications.
• Split large tables using data partitioning.
• Performed Full Backups and Transaction Log Backups. Restored them whenever necessary; created backup strategies and worked on scheduling teh backups.
• Created and managed Schema objects such as Tables, Views, and Triggers & maintained Referential Integrity.
• Responsible for maintaining 2-node clusters in SQL Server
• Re-indexingof fragmented objects and gatheringstaticsandtuned SQL code
• Designed Data Warehouse and Data Mart wif Star and Snowflake Schema
• Created teh cubes and configured teh security roles to teh OLAP environment.
• Worked on SSIS packages to import teh data from Oracle, Access and text files.
• Involved in SQL Server 2005Reporting Servicesto design various kinds of reports.

Environment: MS SQL server 2000/2005, Oracle 10g, Linux, Windows 2000/2003, Enterprise Manager, Query Analyzer, SQL Server Profiler, SQL Server Management Studio, SSRS, Silver Light, ERStudio 7.1, C#.Net 2.0, XML, Win Forms, Windows XP, Visual Studio 2005, PERL.

Confidential, Westlake Village, CA

DBA/Developer

Responsibilities:

• Installed SQL server 2000 on windows 2000/2003 OS, applied service packs and security fixes.
• Involved indatabase designandupdatedschema objectslike tables, functions, store procedure.
• Worked wif developers to tune teh queries, run scripts and Confidential teh database production to development servers.
• Troubleshooting replication errors and handling logs.
• Involved in installation and configuration, and participation in database design and SQL scripting.
• Worked and coordinated wif developers in writing and tuning new stored procedures.
• Responsible for stored procedures optimization, performance tuning and index tuning.
• Worked on data conversion of teh legacy systems data into MS SQL server using SSIS packages extensively.
• Set up backups for teh newly created databases in DB2.
• Scheduled transfer of backups and log files to different servers.
• Provided a support for data issues and given appropriate solutions.
• Provided training to development team on performance tuning and SQL best practices for enhancing application output.
• Involved in writing PERL scripting for teh applications to interact wif DB2 databases.
• Created SSIS packages to pull data from DB2, Access.
• Created reports using SQL 2000 Reporting Services.

Environment: MS SQL Server 2000/2005, DB2, Windows 2000/2003, ASP.NET, ERStudio, PERL, SQL Profiler, UNIX. MySQL