SUMMARY

• Over 8 years of IT experience on Database Administration and development with MS SQL Server technology.
• Hands on experience in Installation and Configuration of SQL Server 7/2000/2005/2008 technology, service packs and hot fixes.
• Expert in using different recovery models simple, full and bulk - logged depending on availability of database.
• Expert in handling Very Large Databases (VLDB).
• Experienced and knowledge of high availability SQL Server solutions with SQL Server Failover Clustering, Database Snapshot, Log shipping, and Database Mirroring.
• Expert in Capacity planning, Performance Tuning, Disaster Recovery, Troubleshooting, backup and restore procedures.
• Solid experience in performance monitoring with Activity monitor, SQL Profiler, Performance monitor, Database Tuning Advisor, DMVs and DMFs, SQL Diagnostic Manager.
• Good understanding in implementing different types of Replication Models such as Transactional, Snapshot, Merge and Peer to Peer.
• Expert in automating the system by using Notification service and creating alerts, jobs and maintenance plans.
• Collaborated on numerous management initiatives, including Data Security, Data Management & Data Retention & Resource Tracking, Change Control, and Disaster Recovery Planning, High Availability.
• Worked on administration tasks such as Data loading, batch jobs, Data unloading, backup and recovery, user and application table management, upgrades, creating Databases, file groups, files, transaction logs.
• Experienced in creating and optimizing tables, indexes, schemas, views.
• Extensive experience in managing the Database Security at granular level.
• Hand full of experience in using third party tools like idera, Spotlight, Sql tuner, Sqlexpert, etc.
• Expert in constructing triggers, stored procedures, user functions, views, indexes, user profiles, data dictionaries, and data integrity using T- SQL.
• Extensive knowledge in developing and deploying ETL packages using, DTS, Informatica, SSIS for accessing heterogeneous data, data cleansing and auditing.
• Expertise in Data Modeling tools such as ERwin, MS Visio, and ER/ Studio Design Tool.
• Expert in logical and physical modeling for OLTP and OLAP applications.
• Ample of experience in data warehousing using star schema and snow flex schema.
• Experienced in leading a team of any size.
• Excellent verbal and write communication skills.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Plenty of Knowledge on different system and tools like oracle, DB2.
• Brain Bench certified Database Administrator.
• Able to work independently and collaborate proactively & cross functionally within a team.

TECHNICAL SKILLS

• SQL Server 7/2000/2005/2008
• Oracle
• Windows XP
• Windows Server 2000/2003/2008
• T-SQL
• MS Access
• Visual Studio
• BIDS
• Query Analyzer
• DTS
• ERwin
• Informatica
• SSIS
• SSRS
• SSAS
• Teradata
• Idera tools
• SCOM
• Spotlight
• SMO
• RMO
• SQLCMD
• SQL Profiler
• Database Tuning Advisor
• Performance Monitor
• Client Configuration Utility
• Server Configuration Utility
• MS Visio
• MS Access
• MS Office
• HTML.

PROFESSIONAL EXPERIENCE

Confidential, Eagan, MN

SQL Server DBA

Responsibilities:

• Checking and correcting the faulty sql server configuration in environment.
• Installed, upgraded and configured SQL Server 2012 server.
• Installed Sql server instances in non-cluster environment on virtual windows servers.
• Worked on incidents and notification mails from footprints tool based on Priority of issue.
• Supported database which involved in log shipping configured in Redgate.
• Occasionally supported as SharePoint admin.
• Attended RCA calls with application owners on global issues to explain the root cause and fix.
• All databases are backed up in to tape drives using Redgate tool.
• Maintained all the maintenance jobs in all the servers.
• Configured and altered alert configuration settings for the jobs and issues.
• Backup and restore the databases from old environment to new environment.
• Periodically (daily, weekly, or monthly) performed a database reorganization on all the indexes on all the tables in all databases to rebuild the Indexes so that the data is no longer logically fragmented.
• Ensured security logins and database access permissions
• Created and scheduling maintenance jobs in new environment.
• Provided support to numerous applications tuning stored procedures and modify them if necessary.
• Provided 7x24 technical supports to the production databases mission critical.

Environment: MS SQL Server 2000,2005,2008R2,2012 SQL Agent, SQL Profiler, Redgate pro 7,Database Tuning Advisor, Database Mail SQL, Windows2003, 2008 server, Footprints Incident management tool, SharePoint 2010,Vmware.

Confidential, Minneapolis, MN

SQL Server DBA

Responsibilities:

• Installed, upgraded and configured SQL Server 2008.Suported store server refresh rollout including hot fixes.
• Installed virtual Sql server instances in cluster environment.
• Worked on incidents and WO’s from HPSD incident management tool through SCOM tool based on Priority of issue.
• Supported stores and HQ application developers with production database issues.
• Performed proactive checks on store servers during the expected busy days like Thanks giving Day and Christmas days.
• Confidential has two datacenters with multiple application and database servers supported by our team.
• Attended RCA calls with application owners on global issues to explain the root cause and fix.
• All databases are backed up in to the legato servers tape drives.
• Supported cluster environment in Data center level. Two data centers with clustered.
• Maintained all the maintenance jobs in all the servers.
• Configured and altered alert configuration settings for the jobs and issues.
• Backup and restore the databases from old environment to new environment.
• Periodically (daily, weekly, or monthly) performed a database reorganization on all the indexes on all the tables in all databases to rebuild the Indexes so that the data is no longer logically fragmented.
• Reconfigured Log Shipping and Database Mail after migration.
• Ensured security logins and database access permissions
• Created and scheduling maintenance jobs in new environment.
• Provided support to numerous applications tuning stored procedures and modify them if necessary.
• Provided 7x24 technical supports to the production databases mission critical.
• Implemented and maintained Transaction replication for high availability in all stores.
• Documented the work and issues for the offshore partners.
• Provided support to replication environment to stores from enterprise server.
• Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor for individual application developers.
• Scheduled meeting with team lead and provided the reporting data like issues of the week.

Environment: MS SQL Server 2000,2005,2008, SQL Agent, SQL Profiler, Erwin, Database Tuning Advisor, Database Mail, System Center Operational Manager (SCOM)2007,T- SQL, Windows2003, 2008 server, Control M, HPSD Incident management tool.

Confidential, Lake Zurich, IL

SQL Server DBA

Responsibilities:

• Installed, upgraded and configured SQL Server 2008 that resembles the production configuration.
• Involved in setting security settings to oracle database in one of the client location from offsite.
• Detached database from Sql server 2005 and attached to Sql Server 2008 using SSMS.
• Backup and restore the databases from old environment to new environment.
• Identified and categorized the problems in existing database in SQL server 2005 using Upgrade Advisor.
• Ensured the compatibility level changes and perform database checkup routines to ensure consistency and integrity is preserved.
• Daily periodically monitored performance using System Monitor, Profiler and SCOM.
• Periodically (daily, weekly, or monthly) performed a database reorganization on all the indexes on all the tables in all databases to rebuild the Indexes so that the data is no longer logically fragmented.
• Reconfigured Log Shipping and Database Mail after migration.
• Ensured security logins and database access permissions
• Created and scheduling maintenance jobs in new environment.
• Giving 7x24 technical supports to the production databases mission critical.
• Created Notification and alerts for replication jobs failure.
• Implemented and maintained Transaction replication for high availability.
• Use replication stored procedures to create scripts to automate the transaction replication once databases are refreshed.
• Ran DBCC CHECKDB on all the databases to verify database integrity.
• Planned the backup and recovery for Publisher and Distribution servers.
• Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.
• Ensured distributed server side processing and data consolidation for client application using Service Broker.

Environment: MS SQL Server 2005/2008, Business Intelligence - MS SQL ServerIntegrated Services (SSIS) and MS SQL Server Reporting Services (SSRS),SQL Agent, SQL Profiler, Erwin, Database Tuning Advisor, Database Mail, System Center Operational Manager (SCOM)2007,T- SQL, Windows2003 server.

Confidential, Portland, OR

SQL Server DBA

Responsibilities:

• Handled up to 2 TB Size databases with clustered and replication environment.
• Regular Database backing up and implementing tests on that backup and generating reports.
• Relocation of Databases from one server to another server using attach and detach database.
• Extensively worked on Dynamic Management Views (DMV’s) to get the information about executed T- SQL statements.
• Used Idera SQL safe backup which provides a high-performance backup and recovery solution.
• Worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
• Rebuilding the indexes at regular intervals for better performance.
• Implemented log shipping between two instances of server using Database.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Developed and deployed ETL packages using SSIS and Converted DTS packages into SQL Server 2005 Integration Services.
• Used export and import wizard to migrate data from oracle to Sql server databases.
• Involved in maintaining data ware house which is in teradata.
• Used third party tools like Primavera Project planner (P3e) to manage the entire life cycle of the projects.
• Monitoring the server usingidera tools.
• Maintaining the database consistency with DBCC at regular intervals.
• Used ETL packages to move logins and jobs from one server to another server.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Do general technical trouble shooting and give consultation to development teams.

Environment: SQL Server 2005 Enterprise Edition, Business Intelligence Development Studio(BIDS) - SQL ServerIntegrated Services (SSIS), DTS, SQL Agent, SQL Profiler, SCOM Database Tuning Advisor, Database Mail, Notification Services, T- SQL, Windows 2003 server, Idera Sql safe backup.

Confidential, New York, NY

SQL Server Developer/ DBA

Responsibilities:

• Problem identification, troubleshooting, resolution, and index tuning databases.
• Worked on the server and keep it running. Concerned with backups, security, patches, and replication.
• Implementation of Immediate Transactional Replication to reduce the workload on servers.
• Worked on building queries, stored procedures that meet business needs.
• Tested and implemented Database Replication solution for Production critical application.
• Use replication stored procedures to create scripts to automate the transaction replication once databases are refreshed.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
• Developed and implemented Disaster Recovery Plan and Procedures.
• Managed the use of disk space, memory, processor and connection.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Diagnosed and tuned the server optimal performance using SQL Server 2005’s Dynamic Management Views (DMV), Profiler and Index Tuning Wizards.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Reduced systems downtime risk through automatic offsite backup and recovery over network.

Environment: MS SQL Server 2000,T- SQL, SQL Query Analyzer, SQL server Agent, DTS, Windows server 2003

Confidential

SQL Server Developer/DBA

Responsibilities:

• Installed and Configured SQL server 2000.
• Created and managed objects such as tables, views, stored procedures, and triggers and User defined functions using T-SQL commands.
• Checked slow running queries and tuned.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins.
• Used DBCC commands to check the database consistency.
• Used SQL profiler to check the database performance.
• Implemented regular database backup and created logins.

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