Professional Summary

• 8+ years of experience in Database Administration, Database Design, Modeling ,Development & Support of MS SQL Server 2008R2/2008/2005/2000 in Production & Development environments.
• Good knowledge of MS SQL Server 2008 implementing new features like Row and Page compression mechanism, CDC, Data Compression, Backup compression, Resource Governor, Performance Data Collector and Transparent Data Encryption.
• Performed Log Shipping and implemented Replication as High Availability techniques.
• Experience in Database Mirroring as Disaster Recovery Solution.
• Experience in Creating Tables, Views, Triggers, Cursors, Dynamic Stored Procedures, User Defined Functions and other Transact-SQL (DDL, DML) statements for various applications.
• Worked with SSIS & SSRS for various BI requirements.
• Proficiency and Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Tracked Server Activity, Query Performance and Disk usage activity statistics via Performance Data Collection.
• Expertin designing Relational Database Model, implementation and testing as per business needs.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Implemented SQL Server 2005 new concepts like Data partitioning, Snapshot Isolation, Online Indexing, Try-Cache Blocks, DDL Triggers and DMV & DMF.
• Created Partition function, Partition scheme and multiple file groups and files to host the table data for Data partitioning.
• Optimized the Disk space for performance using RAID and SAN.
• Experience in data migrating (using tools like DTS, BULK_INSERT, BCP) between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
• Experience in extracting, transforming and loading data (ETL) using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
• Extensive use of DTS in SQL Server, Performance Tuning & Application Design, Disaster Recovery Planning, Security Management, Managing server and clients, T-SQL, etc.
• Experience in building Adhoc Reports, Parameterized Reports, Linked Reports, Toggle Reports, and Reports with Sub Reports using SSRS.
• Experience in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008.
• Intensive experience in Monitoring and Tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, Windows Performance Monitor.
• Expert in automating process by creating jobs, and error reporting using Alerts, SQL Mail Agent.
• Experience in creation of logins, users and configuring permissions and assigning roles to users. Good understanding of Normalization /De-normalization, Normal Form and database design methodology. Experience in Database Backup and Disaster Recovery procedures like Log shipping.
• Worked extensively in Clustered environment (Active / Passive) to further increase scalability and stability of business critical systems.
• Development of automated notification when SQL Server Backups and schedule maintained Jobs.
• Expertise andInterest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 2 Terabytes.
• Experience in optimizing the query by creating various clustered, non-clustered indexes and indexed views.
• Experience in creation of logins, users and configuring permissions and assigning roles to users. Experience in Migrating of SQL Server 2000 to SQL Server 2005 & SQL Server 2005 to SQL Server 2008using suitable approach.Experience in working with Windows Server 2003 Enterprise Edition, Windows 2000 Advanced Server, Windows 2000 Server and Windows NT.
• 24 x 7 Production Database on Call Support. Excellent Analytical, problem solving and communication skills.
• Excellent communication and interpersonal skills, self-motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good Team player with excellentinterpersonal and team work skills.

RDBMS

MS SQL SERVER 2000/2005/2008, Analysis Server 2000/2005, MS Access 2000/2005.

Databases Tools

SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), Database Engine Tuning Advisor, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, DTS xChange, MS Visio, SSRS, SSIS, SSAS

Programming Languages:

SQL, TSQL, XML, PL/SQL.

Operating Systems

Windows 95/98/2000/2003/2008/XP, MS-DOS.

Utility Tools:

MS Office, MS Project.

Confidential,TX Feb 2012 to Current
SQL Server Database Administrator
Environment: SQL Server 2008, Oracle 11g, Windows server 2003.
Responsibilities

• Replicated database from Oracle11g to SQL Server 2008 (Snapshot replication and Transactional replication).
• Created a Linked Server to Oracle11g from SQL Server.
• Created Active Directory with Security group with Table level permissions.
• Responsible for maintenance of all the SQL Server and Oracle servers.
• Created maintenance plan for regular scheduled Transaction log backup, Full backup (Separately in remote server), Check database, Reorganize index, Rebuild Index, Update Statistics and Cleanup task.
• Setup and maintain Replication for Production servers to provide high availability and monitor using Replication Monitor.
• Setup Alerts, Notifications, Jobs, Job steps with automated response solution schedules.
• Frequently Monitor Connections, Locks and Database Performance using Performance Dashboard.
• Reviewed and optimized SQL queries, stored procedures, functions, Indexes, views and Triggers.

Confidential,MN June 2011 to Feb 2012
SQL Server Database Administrator
Environment: SQL Server 2008, SQL Server 2005, Windows server 2005/2008.
Responsibilities

• Responsible for all the servers which are running in SQL platform (SQL Server 2005/ 2008)
• Setup multiple Nodes (Active/ Passive) in SQL Servers to add clustering feature.
• Manage SQL Server databases and Configure failover cluster.
• Plan and modify SQL Server Permissions in quarterly basis.
• Create databases and schedule backups (Transaction log backup, Differential backup and Full backup) with Recovery sessions (Simple or Full).
• Setup and maintain Replication for Production servers to provide high availability and monitor using Replication Monitor.
• Setup Alerts, Notifications, Jobs, Job steps with automated Response solution schedules.
• Frequently Monitor Connections, Locks and Database Performance.
• Reviewed and optimized SQL queries, CDC, stored procedures, functions, Indexes, views and triggers.
• Created an internal secured Website linking to the database that includes updated information about all Target SQL Servers information.

Confidential, AL Nov 2009 to May 2011
SQL Server Database Administrator
Environment: SQL Server 2008, SQL Server 2005, Windows 2008 server, SQL Profiler, SSIS, SSRS, SSAS.
Responsibilities

• SQL Server 2008/2005 Database Administration.
• Responsible for 24x7 critical production support for 150 servers out of which 90 are production servers, remaining test and development servers.
• Installation and Configuration of MS SQL Server 2008 on Windows 2008 Servers.
• Installed service packs and security fix on production, test and development servers.
• Configured multiple node failover cluster.
• Performed Migration ofdata from SQL Server 2005 toSQL Server 2008Edition.
• Designed the physical and logical data modeling design for development projects.
• Reviewed and optimized SQL queries, CDC, stored procedures, functions, Indexes, views and triggers from other developers to achieve maximum efficiency and scalability.
• Installed, configured and maintained MS SQL Server Replication for production servers to provide high availability.
• Implemented partitioning to handle tables with over 300 million rows.
• Created and developed stored procedures to handle complex business rules, history data and audit analysis.
• Performed database backups for production, test and development servers and restored backups onto test servers to ensure that we had good backups.
• Additionally designed andimplemented a disaster recovery system. Involved in disaster recovery procedures and restoring the production database.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XML) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS) 2008/2005.
• Designed SSAS Cubes in Business Intelligence Development Studio 2008/2005.
• Generated complex reports as per business requirements using SQL Server Reporting Services (SSRS) 2008/2005.
• Involved in SQL security and planning; administrating and creating user accounts for proper access, SQL/Server system databases and tables,SQL ProfilerandEnterprise Manager/Management Studio, and Server monitoring and capacity planning to ensure adequate CPU, disk space, and memory on all SQL servers.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Worked with the Copy Database Wizard for migrating the data from SQL Server 2005 to SQL Server 2008.
• Created and developedtables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Trained developers on how to write better SQL, how to use more powerful features like table variables, how to avoid cursors, etc.
• Profiled and tuned servers on a monthly basis to ensure fast queries and reports.
• Provided 24x7 on-call supports. Supported systems beyond regular hours/ weekends/ holidays.
• Managed all report code and .rdl files using a source control system.
• Periodically monitored performance using both System Monitor and SQL Profiler Trace.
• Gathered, stored and analyzed different types of SQL Server performance activities using Management Data Warehouse (MDW).
• Documented changes made to the servers, including documentation of performance issues.
• Regularly checked OS Event Logs and SQL Server Logs for unusual events.
• Implemented Database Mirroring, Log Shipping on SQL 2008 Servers for high availability and maintaining Disaster Recovery sites.
• Setting up andAutomatic/Forced fail overfor the production servers usingLog Shipping, Database Mirroring and Replication.
• Performed compression of historic data for VLDB and compressed backups to reduce amount of space it takes on disk.
• Managed unstructured data in SQL Server 2008 using filestream.
• Encrypted data and log files using transparent data encryption (TDE) solution.
• Experience in MS SQL Server tools like MS SQL Server Service Area Configuration, SQL Server Profiler, Business Intelligence Development Studio, SQL Server management Studio, SQL Server Configuration Manager.

Confidential, AZ May 2009- Oct 2009
SQL Server Database Administrator Environment: SQL Server 2000/05/08, T-SQL, Excel, Advanced Windows 2000 Server, MS access.

Responsibilities:

• Installation and configuration of SQL server 2008 in development, production, testing, environments
• Installing and configuring windows 2003 fail over cluster for SQL 2008
• Up gradation to SQL Server 2008 along with some database up gradation.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Involved in cluster implementation
• Implemented log shipping for hot stand by servers
• Provided 24 X 7 dedicated support to all Production Environments
• Scheduled the full backup, differential, transaction log backup of Database
• Restored the Databases from the Disaster.
• Planned and modified the permission issues in the server.
• Transferred the data to homogenous and heterogeneous platforms using DTS utility.
• Extensively worked on replication.
• Fine tuning the Database Settings as well as the Server Settings.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed.
• Created stored procedures, triggers and functions
• Maintaining SQL Script for creation of Database Objects.

Confidential, VA (July 2008- April 2009)
SQL DBA
Environment: MS SQL Server 2005, SSIS, SSRS, SSAS, T- SQL
Responsibilities

• Over 2 year experience in MS SQL Server 2005 database development in enterprise environment. Strong troubleshooting and organizational skill.
• Solid experience in database development and support. Database migration, SQL Server 2000 upgrade to SQL Server 2005.
• Database performance tuning, capacity planning, and troubleshooting.
• Expertise in RDBMS, data warehouse architecture and modeling, ETL and DTS/SSIS experience.
• Thorough understanding and experience in data warehouse and data mart design, star schema, snowflake schema, normalization and demoralization concepts and principles.
• Expertise in SSIS (Integration Service), SSAS (Analysis Service), SSRS (Reporting Service).
• Hands on experience on SQL Server Notification Service, Service Broker
• Excellent T-SQL and database programming skills
• Solid experience in software development life cycle.
• Over 3 years work experience in international team and multi-cultural environment
• Extensive experience in project management and execution involving multiple concurrent development projects with a proven successful track record
• Exceptional ability to gather and translate complex user requirements into practical, cost-effective software solutions.
• Creative and innovative thinker, bringing energy, enthusiasm and leadership to problem resolution.
• Consistent, well-organized and dependable performer with the flexibility to adapt to constantly shifting priorities.

Academic Qualification

• Bachelor in Computer & Information System