SUMMARY:

• 11 years of experience in IT industry with 10 years of DBA experience in SQL Server 2012/ 2008/2005/2000 .
• Experienced in database administration activities like installation, configuration, backup & recovery, database Security and data transformation services.
• Experienced in Always On SQL Server 2012.
• Expert in installation, upgrade and configuration of MS SQL Server 2012, 2008, 2005 & 2000.
• Tested and implemented Log Shipping with SQL Server 2008/2005.
• Successfully implemented Database Mirroring in SQL Server 2008, 2005 for high availability and disaster recovery.
• Experienced in implementing Snapshot, Transactional and Merge Replication models.
• Experienced in Installing, configuring and maintaining SQL Server Active/Active and Active/Passive cluster.
• Experienced in creating maintenance plans, Jobs and sending alerts using database mail.
• Experienced in installing Service Packs and Cumulative Updates for SQL Server.
• Good Knowledge in preparing and updating cost cutting and disaster recovery documentation.
• Developed backup and recovery techniques for production environment.
• Experienced working with 24x7 Production Support.
• Good knowledge of Relational Database Management Systems (RDBMS).
• Experienced in data normalization and de - normalization.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation Experience in working with high transaction OLTP systems in SQL Server 2012/ 2008/2005/2000
• T-SQL coding and testing: indexes, views, triggers, functions, cursors, stored procedures etc.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity and Database Consistency Checks using DBCC Utilities.
• Involved in Performance tuning of Stored Procedure.
• Worked on partition table in SQL 2008/2005.
• Designed documents for Capacity Planning and System Maintenance for Production.
• Worked on DMVs, System tables and Stored Procedures for performance tuning.
• Handling database designing and query optimization.
• Extensive knowledge in Tuning SQL queries & improving the performance of the Database.
• Extensively worked on Performance tuning of stored procedure.
• Experienced in creating SSIS packages, Jobs, Sending Alerts using SQL Mail.
• Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Experienced in using tools like SQL Profiler and performance counters for Monitoring and Tuning MS SQL Server Performance.
• Monitoring SQL Server logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Experienced in database and system audit in order to allocate the proper resources across the network.
• Experienced in implementing Various RAID technologies.
• Experienced in SQL Server Integration Services (SSIS).
• Experienced in Extracting, Transforming and Loading of Data from Excel, Flat file, Sybase, Oracle to MS SQL Server by using BCP and DTS Import/Export utility, SQL Server Integration Services (SSIS).
• Worked in SQLCMD mode in order to troubleshoot Database Engine.
• Migrated DTS Packages to SSIS Packages.
• Deployed SSIS Packages to MSDB and File system from development to Production environment.
• Experienced in creating partition tables and partition views.
• Worked with Popular Third Party monitoring solutions like Red Gate.
• Management of users including creation/alteration, grant of system/db roles and permissions on various database objects.
• Worked on backup tools like Red Gate.
• Excellent communication skills.
• Good team player with strong analytical skills.
• Flexible, enthusiastic and project oriented team player with solid leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS:

Applications: SQL Server 2008/2005/2000, Visio, Netscape, Internet Explorer, DNS Servers, Web servers using IIS, Netscape, Apache, Mail Servers using MS Exchange 5.5 and Mailer Daemon, FTP servers using Wu-Ftpd, NcFtpd, RADIUS, MS Ftp, Proxy/Cache server using Squid and MS Proxy 2.0, Microsoft Internet Security and Acceleration Server, PcAnywhere v9, Adobe Photoshop, Corel Draw, Page Maker, Microsoft Office Suite.

Internetworking: Configured and maintained Cisco routers (2500s, 1700, 1600s, 800s & 700s series) for WAN links. Experienced in Implementation of Internet Service Provider s Setup

Operating Systems: Windows NT/9x, Windows Server 2003/2008/2012, Windows XP, Windows Vista, Windows 7 and Windows 8.

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Sr. SQL Server DBA

Responsibilities:

• Migrated, Upgraded and consolidated different versions of SQL Servers for Plano Migration.
• Implemented SQL Server 2012 Always On for Load Balancing and Disaster Recovery.
• Installed SQL Server 2008R2/2012 service pack and cumulative update in STG, QA and PROD environments.
• Implemented Log Shipping between PROD Servers.
• Implemented centralized solution for monitoring jobs, Database Mirroring and Log Shipping.
• Installed, maintained and monitored SQL Server 2008/2012 on 4 Node Clusters with mount point technique.
• Installed SQL Server 2005/2008/2012 clusters for high availability and applied service pack and cumulative update.
• Created Linked Server for Oracle connectivity.
• Implemented Transactional Replication.
• Implemented maintenance plans for Backups, DBCC, Clean ups, and Rebuilding Indexes.
• Responsible for all the change in production using the Change Request standard procedure.
• Provided on call support for major issues.
• Implemented solution for backup and recovery based on SLAs.

Confidential, Allen, TX

SQL Server DBA

Responsibilities:

• Installed SQL Server 2008 R2 with service packs in production and UAT environments.
• Implemented Log Shipping between Production Servers.
• Maintained and monitored SQL Server on 2 Node Active/Active Clusters.
• Upgraded SQL Server using Side by Side strategy.
• Migrated servers in a Consolidated & Virtualized environment using Hyper-V for cost cutting.
• Implemented Transactional Replication & Database Mirroring In SQL 2008.
• Applied SQL Server 2005/2008 patches on production.
• Configured Linked Servers between Oracle and SQL Server 2005/2008.
• Setting up database backup and recovery procedures for production, test and development servers.
• Designed and created user databases, tables, views, complex stored procedures and SQL joins and statements.
• Worked on Optimization and Tuning of Stored Procedures and T-SQL queries.
• Created maintenance plans for performing Optimizations, Backups, Rebuilt and Reorganize indexes.
• Designed documents for Capacity Planning and System Maintenance for Production.
• Resolved deadlocks and blocking issues using Performance Monitor, SQL Server Profiler.
• Used BCP and Bulk Insert for transferring data between various environments.
• Worked on DMVs, System tables and Stored Procedures for performance tuning.
• Worked in SQLCMD mode in order to investigate/troubleshoot SQL Server Database Engine.
• Created jobs and alerts for monthly and weekly Maintenance Plan.
• Worked with T-SQL, DDL, DML and DCL statements.
• Created tables, indexes, views, complex stored procedures, functions, defaults, rules and constraints.
• Prepared documentation for cost cutting and management of Production Servers.
• Used DBCC commands for consistency checks to improve performance.
• Actively participated in gathering requirements from business users to create new database objects.
• Coordinated with Windows Net-Backup and System Management teams for resolving backup and performance issues on regular basis.
• Creation of Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and Database Mail.
• Provided 24x7 production support.
• Created, tested and Deployed SSIS packages from system test and UAT to production.

Environment: SQL Server 2005/2008 Enterprise Edition, Windows 2003/2008, TSQL, SQL Server Integration Services (SSIS).

Confidential, Irving, TX

SQL Server DBA/Windows Server Admin

Responsibilities:

• Created databases and tables after thorough business analysis, technical analysis, and systems design.
• Configured database replication and database mirroring for load balancing and redundancy.
• Involved in design and development of disaster recovery plan.
• Developed, deployed and monitored SSIS packages.
• Migrated DTS to SSIS.
• Performed daily database tasks including backup, restore using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Agent, and Database Engine Tuning Advisor.
• Resolved issues and improvised the process to ensure a stable and accurate solution.
• Used SQLCDM for resolving the issues related to SQL Server Database Engine.
• Provided technical and systems knowledge to team members.
• Work with architects, developers on business and technical issues, helping in designing of system; and testers to ensure all requirements are correctly translated.
• Deployed database objects from development/UAT environments to production environment.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases involving index modification, file group modifications, and adding scheduled jobs to rebuild indexes and update statistics on tables.
• Monitored SQL Server performance using SQL Server Profiler.
• Monitored and modified performance using execution plans and Index tuning.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Prepared project management and technical documentations.
• Export/Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Analyzed and tuned long running slow queries using execution plan.
• Configured transactional replication.
• Created Linked Servers between SQL Server 2005 and DB2/Oracle.
• Set up SQL Server configuration settings.
• Implemented SQL Logins, Roles and Authentication Modes as a part of security policies for various categories of users.

Environment: SQL Server 2005 Enterprise Edition, Windows 2003, TSQL, SQL Server Integration Services (SSIS), Visual Source Safe and DB2.

Confidential, Waltham, MA

SQL Server DBA

Responsibilities:

• Installed and configured MS SQL Server 2005.
• Designed SSIS packages in order to automate SQL Server administration.
• Configured Web Crawler, so it can collect search code from different web site and can store them in appropriate SQL databases.
• Configured load balancer in order to distribute traffic among all web servers.
• Extensively worked on DBCC commands and the DML commands to manipulate data.
• Assisted in planning for the relocation of servers.
• Responsible for all database in SQL Server environments
• Performed task like backup, restore, code review, security planning and implementation.
• Interacted with Windows administrators on almost daily basis.
• Responsible for reviewing all stored procedure code as well as writing the most complex procedures in use by the applications.

Environment: SQL Server 2005, Windows 2003/2008, UNIX, Linux and Indexing applications.

Confidential, Princeton, NJ

SQL Server DBA

Responsibilities:

• Involved in database development and production environment support.
• Installed and configured SQL Server 2005 clustering under Windows 2003 Advance Server using Storage Area Networks (SAN). Configured 3 different clusters one for each in Production, Testing and UAT environments. Each cluster was configured in Active/Active.
• Managing several SQL Servers in multiple locations supporting several hundred users.
• Rebuilding indexes at regular intervals for better performance.
• Performed index tuning, performance tuning and query optimization using SQL Server Management Studio and execution plan.
• Implemented a disaster recovery plan on SQL Server 2000 and on SQL Server 2005.
• Re-designed backup strategy to meet recovery targets.
• Improved space management and monitoring to meet expansion needs and streamline effort required.
• Analyzed query patterns of 3rd party application and recommended improvements.
• Trained employees on the usage of SQL Server, replication, and disaster recovery.
• Responsible for periodic review of performance and operation of all SQL Servers.
• Recommended improvements on existing applications to meet performance and scalability requirements.
• Provided analysis and recommendations for implementing full text indexing to meet management requirements.

Environment: SQL Server 2000/2005, MS Cluster Server, SSIS, Windows 2000/2003, Windows XP, Visio, Red Gate backup utility.

Confidential, San Francisco, CA

SQL Server DBA

Responsibilities:

• Installation & configuration 2005 enterprise Edition.
• Performed migration SQL Server 2000 to SQL Server 2005.
• Converted DTS packages to SSIS packages.
• Dynamic configuration for memory.
• Transformed millions of records of data to SQL server by SSIS and DTS.
• Managed the clustered environment.
• Used log shipping to synchronize database.
• Suggested and implemented replication techniques to meet business needs.
• Maintained database consistency with DBCC commands at regular intervals. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Performed daily backup and created named backup devices to backup the servers regularly.

Environment: SQL Server 2000/2005, Windows Server 2000/2003, VB Script, SQL Light speed.

Confidential, Austin TX

SQL Server DBA

Responsibilities:

• Installed MS Windows 2000 Advanced Server, SQL Server 2000, and SQL 2005 beta version.
• Installed and maintained MS SQL Server databases on UAT and Production Server.
• Tested new SQL Server Management Studio interface, features and SSIS Services in SQL Server 2005 beta.
• Performed backup and recovery on daily basis.
• Performance tuning using query analyzer and index tuning advisor.
• Created logins and maintained user permissions appropriately.
• Used DBCC commands to troubleshoot issues related to database consistency.
• Recommended system design approaches, which are consistent with the application business requirements.
• Interacted with Business Analysts and Developers for identifying the requirements, designing and implementing schema.
• Managed disk space, memory and user connections.
• Transferred data using BCP and DTS.
• Performed query plans and making sure each query is using appropriate indexes.
• Created Windows Logins and privileges to User Accounts/Groups and objects.

Environment: MS SQL Server 2000/2005 beta, Windows 2000 Advanced Server, Unix, Oracle 9i, MS Access, Erwin 4.0 and Visio.

Confidential, San Diego, CA

SQL Server DBA

Responsibilities:

• Ensured trouble free access to SQL Server databases 24 hours a day.
• Timely completion of activities for database backup, restoration and health check of databases.
• Monitored log shipping/replication and trouble shooting of errors.
• Addressed security issues related to logins, database users, and application roles and linked servers.
• Wrote codes for automating database administration tasks and generating related reports.
• Involved in trouble shooting and fine-tuning of databases.
• Analyzed problems in the production environment and developed new procedures and methods to monitor problems. Alert messages were sent out to take pro-active action.
• Wrote scripts for continuously monitoring the up and running of the servers and auto monitoring for capacity planning.
• Wrote scripts for generating Daily Backup Report, verifying completion of all routine backups.

Environment: T-SQL, MS SQL Server 2000/7.0.