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

• MS 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, 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 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, South Pembroke, FL

SQL Server Developer/DBA

Responsibilities:

• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Installed and Configured SQL Server 2000.
• Tested to optimize the Stored Procedures and Triggers to be used in production. Responsible for stylish design layout like GraphsandLinked Reports.
• Developed complex T-SQL code for the application.
• Worked in Enterprise Manager for job scheduling and batch queries.
• Planed, defined and designed data flow processes for data migration to the Data Warehouse using DTS.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Implemented fine tuning of database objects and server to ensure efficient data retrieval.
• Managed and monitored the use of disk space.
• Maintained the consistency of the client’s Database using DBCC.
• Planned Backup strategy based on projects requirements.
• Maintained the client relationship by communicating the daily and weekly statuses of the project.

Environment: SQL Server 2000, Windows Server 2000, Data Center, SQL Query Analyzer, DTS.

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.