PROFESSIONAL SUMMARY:

• 7+ years of IT experience includes System Analysis, Database Design, Development & Support of MS SQL Server 2005, 2000 in Production, QA & Development environments.
• Configure, patch, test, monitor, and support all MS SQL Server db instances, monitor db performance. Configured DB configuration/SQL to optimize performance
• Experience with design, testing, implementation, maintenance, and control of the organization's physical, relational, and object - oriented databases across multiple platforms and computing environments.
• Worked on Business Objects XI for report generation.
• Used crystal reports for getting data in required format.
• Support & Maintenance of Production/Development Databases on various servers with on-call support for Production applications.
• Implement and maintain Oracle Advanced replication option for various databases in different sites including multi-master replication read-only snapshots.
• Expertise in planning and implementing MS SQL server security and database permissions.
• Good experience on migration and upgrades.
• Experienceinconfiguring, administering and maintainingReplication
• Installed SQL server 2008 and setting environment.
• Worked on reverse Engineering queries using Query Analyzer and SQL Trace.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Experience in writing and debugging stored procedures and triggers.
• Able understanding and executing the details across multiple operations functions within the infrastructure.
• Having excellent communication, analytical, and leadership skills.
• Expert in technical and problem solving abilities.
• Responsible for supervising staff in the execution of projects.
• Gathering data requirements, and designing and fine-tuning of databases as per the requirement of clients.
• Expertise in SQL Loader and Import/Export Utilities.
• ExperienceinData Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System usingSQLtools (SSIS, DTS, Bulk Insert, BCP, XML)
• Experience in implementing different types of Replication models like Snapshot and transactional.
• Experience in troubleshooting permissions, account lock-outs, network connectivity, services andIISAdministration
• Hot and Cold Backups, Disaster Recovery Planning, Security Management, Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Knowledge in DBMS environments and product interdependencies, as well as all major business unit application portfolios.
• Experience in design, implement and maintain complex SQL Server 2000/2005/2008 e-Commerce database.
• Generate Complex reports as per business requirements using SQL Server Reporting Services (SSRS) 2008/2005.
• Able to leads ensure all DBMS related functions are completed and ensures quality of execution, using trend data to lead continuous improvement efforts.
• Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Expertise with Table Design, Index Design and Performance Tuning.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.

TECHNICAL SKILLS:

Languages: C#, T-SQL, VB .NET, ASP.NET, Java Script, Nhibernate

RDBM: SMS SQL Server 2008, 2005, 2000

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.

Version Control Tools: Visual Source Safe

Operating Systems: Windows 2008/2003 Enterprise Server, Windows 2000 Advanced Server, Windows NT

Other Tools: Quest Litespeed, CA Erwin, MS Visio, Idera SQL Diagnostic ManagerTechnologiesRAID, SAN

PROFESSIONAL EXPERIENCE:

Confidential

Senior Consultant

Responsibilities:

• Experience with SQL 2008 R2and all DBA tasks like replication, Clustering, log shipping.
• Experience migrating from Windows Servers and .
• Test and upgrade in SQL 2008 R2 and implement database replication model.
• Upgrade database from SQL 2005 to SQL 2008.
• Experience with creating and maintaining database.
• Export or Import data from other data sources like flat files using Import/Exports through DTS, SSIS.
• Worked on performance of Table space, data file space errors, blocking locks, application errors Client software issues and Poor performance.
• Created all administration tasks of SQL Server and designed database.
• Created and modified procedures, triggers and functions.
• Design of physical data storage, maintenance, access and security administration and correct functioning of backup and recovery on DBMSs.
• Used SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Development activitiesAdvisor for index recommendations.
• Provide front-line response to events generated by database monitoring and alerting systems.
• Used System procedures and DBCC commands.
• Implemented and administratingSQLServerSnapshotreplicationand transactionalreplication
• Active Directory Administration, user logon scripts.
• Experience in writing complex T-SQL queries using joins.
• Troubleshooting permissions, network connectivity, services andIISAdministration
• Implemented various levels of constraints and triggers to preserve long term database consistency and accuracy.
• Provide to the managers in using the system, using reports, executing complex queries and writing.
• Evaluated, examined and implemented user roles and assigned relativedatabaseaccess privileges.
• Disaster Recovery Planning, Security Management, Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Experienced in performance of the server using DMV commands
• Worked with the tools Fog light, Spotlight, Capacity Manager
• Extensively used SSRS for reporting.
• Testing, implementation, maintenance, and control of the organization's physical, relational, and object-oriented databases across multiple platforms and computing environments.
• Created automatically running stored procedures for day-end operation using SQL Server Agent.

Environment: MS SQL server 2008/2005, Windows 2008/2003 Enterprise edition, SQL profiler, Idea Diagnostic Manager, Idea Diagnostic Manager, SQL Light speed Backup Software.

Confidential, CA

SQL Server DBA

Responsibilities:

• Used database mirroring for transfers transaction log records directly from one server to another and can quickly fail over to the standby server and database.
• Client applications were originally interactive command-line tools with graphical user interfaces have been developed for all desktop operating systems.
• Managed and maintained all production and non-production databases.
• Design of physical data storage, maintenance, access and security administration and correct functioning of backup and recovery on DBMSs.
• Configured database parameters, created prototype designs against logical data models, and defines data repository requirements, data dictionaries and warehousing requirements.
• Provide front-line response to events generated by database monitoring and alerting systems.
• Designed and developed primary database objects (tables, views, indexes).
• Export or Import data from other data sources like flat files using Import/Exports through DTS, SSIS.
• Good experience on analyzing OLAP databases group the related facts in a member intohierarchies Provide account administration for all database resources.
• Created SSIS Packages that loaded IIS log files into a SQL Server 2005 database for site usage reporting.
• Designed, Built ETL procedures and a data warehouse to meet client requirements using SQL Server Integration Services.
• Good experience in data modeling and metadata services.
• Upgrading SQL Server 2000 data bases into SQL Server 2008.
• Hands on experience with backup and restoring databases
• Knowledge of MS SQL Server clusters.
• Used SSRS to write complex formulas and to query the database different to generate different types of ad-hoc reports.
• Implemented newT-SQLfeatures added inSQL Server 2005that areData partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE), Data Partitioning, Snapshot Isolation
• CreatedDatabase Maintenance Plansfor the performance of SQL Server which coversDatabase Integrity checks, update database Statistics and Re-indexing.
• Developed and optimized database structures,stored procedures, Dynamic Management views,DDL triggersanduser-defined functions.
• Identified, tested and resolveddatabase performance issues (monitoring and tuning)to ensuredata optimization.
• Involvedin trouble shooting and fine-tuning of databasesfor itsperformance and concurrency.
• Managed trouble shooting ofClient connections, viewing error log and applications.
• Developedautomated backup and DBCC scriptsfor databases and transaction logs.
• Maintaining the databaseconsistencywithDBCCutility at regular intervals.
• Worked on log shipping for synchronization of database.
• Authenticated logins and validated permissions. Created SQL Server Databaseusers and Roles.
• Writingstored procedures, triggers, and functionsand maintained coding standards.
• Created and supportedcomplex database schemas.
• Used SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Development activitiesAdvisor for index recommendations.
• Installed SQL Server 2005 and created Development Database for testing, upgrades and development.
• Monitored servers usingSpotlight third party software.

Environment: Windows 2003 server, XML, MS SQL Server 2000/2005/2008, MS Access, MS Excel, Visio, IIS.

Confidential, CA

SQL Server DBA

Responsibilities:

• Database Administrator, Some Database Programming.
• Relocation of Databases from one server to another server using attach and detach databases.
• Touch works application was implemented in Active Passive clustered environment.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Migrated DTS packages from Legacy system to SQL SERVER 2005.
• Implemented log shipping between two instances of servers using Database Maintenance Plan by creating a Monitor server and a shared Folder.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Monitored and modified Performance using execution plans and Index tuning.
• Recovering the databases from backup in disasters
• Maintaining the database consistency with DBCC at regular intervals
• Used DTS packages to move logins and jobs from one server to another server.
• Used Data Partitioning in SQL Server 2005.
• Used Snapshot Isolation in SQL Server 2005.
• Using log shipping for synchronization of database.
• SQL Server Reporting Services (SSRS).
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Maximum performance and uptime in production environment.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Handled up to half TB Size databases with clustered and replication environment
• To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• To implement all database development enhancements to multiple SQL Server databases to ensure a flawless functioning of production environment.
• To perform installations & performance tuning, manage capacity planning & user accounts, and implement database security for multiple instances of development,, QA, and production SQL Servers databases.
• 24 X 7 Production Database on Call Support.

Environment: SQL Server 2000/2005, Excel, Advanced Windows 2000 Server, MS access