SUMMARY

• over 7+ years expertise as DBA in Microsoft SQL Server 2005/ 2008 management and performance tuning, System analysis, Design, Development and 3 years of experience on development and testing ETL.
• Expertise in Installation, configuration, Backup /recovery, database security, Data Transformation Services (DTS), Database design, query optimization, Security administration
• Experience with Storage Area Networks (SAN) and utilizingSANdisk space in a Windows Environment
• Familiar with Virtualization technology and running Windows inside a Virtual Machine
• Extensive experience in overhauling improperly designed database schemas including improperly merged entities, improper references between entities, references on the many-side entity failing to reference the full unique key of the one-side entity, and first & second normal form violations.
• Experience with ETL processes for importing vendor data for e-commerce products, assimilating bulk job postings, SHRM member loads and re-loads, and integrating corporate acquisitions\' entire databases.
• Experience in disaster recovery, performance tuning, and migration from 2000 to 2005 and 2008
• Expertise in configuring and maintaining SQL Server Active/Active and Active/Passive cluster.
• Experience in installing MS SQL multiple instances in windows cluster environment.
• Experience in installing multiple instances of SQL failover cluster on SQL 2005 & 2008
• Extensive expertise in implementing High availability: Mirroring, Log shipping and Replication.
• Implemented different types of replication models: Snapshot, Merge and Transactional.
• Capacity planning, Performance tuning, Disaster recovery, trouble shooting backup /restore procedures
• Experience in handling in large (VLDB) including T-SQL coding, Full-text indexing, stored procedures.
• Data modeling tools: SQL Diagram, Erwin and Database security with SOX Compliance Standards.

Education: Bachelors in computer Science

------------------------------------------------------------------------------------------------------------------------
Skill Acquired:
Languages : T-SQL, PL/SQL, C#, XML, HTML.
Databases : MS SQL Server 2000 and 2005, 2008 MS-Access, oracle
Operating Systems : Windows 2000/2003/2008 Exchange Server, Windows NT.
Version control Tools : Visual Source Safe, Rational Clear case.
Web Servers : IIS 5.0/6.0, Apache, Tomcat, and Web sphere.
Database Tools : DTS, SSIS, Enterprise Manager, SQL profiler
Modeling tools : Erwin3.5/4.0 and Microsoft Visio 2003.
Other tools : SQL Backup (Red gate), Idera SQL safe, SQL compare, SQL Diagnostic Manager, light speed
Data warehouse : OLAP, MS analysis server, Data mining server, Multi dimensional cubes, Star & Snow flake schema, SQL Data Transformation services (DTS), MSSQL Reporting Services, Integration services.

Confidential,
Jan 09 – Till Date
SR.SQL DBA/Developer
Provide 24x7 on site and remote\\off-site assistance and production support for Company. I am one in the team of 3 responsible for Databases Administration, Backup and Restore operations, Participate with Ad-hoc SQL server DBA activity applications throughout the company as needed. Duties include SQL Server 2005 Production, Test and Development support, performance tuning and trouble shooting. Overall all the tasks were focused on maintaining steady and reliable systems and subsystems internal and external customers and users.

• Installed MS SQL Server2000/2005/2008 on Windows 2003/2008 servers, applied service packs, security fixes
• Wrote automated backup and highly configurable index /statistics maintenance stored procedures for both the DEV an client production sites in a VLDB environment
• Automated bugs/white list apply in all Prod/Sandbox and Pre-Prod environment
• Setting up Log shipping & Replication on Production environment
• Individually implemented Transactional Replication process for updating our servers.
• Resolve database performance issues, database capacity issues.
• Manage security of database structures and corporate data held within databases.
• Develop database procedures, triggers and SQL scripts for development teams.
• Created Scheduled jobs to execute multiple DTS package to extract data from multiple Rockwell and Avaya switches from the southeast regions call centers.
• Involved in setup of the clustered SQL server environment at VLDB.
• Worked extensively on SQL queries, stored procedures and functions.
• Used Reporting service (SSRS) to publish data to the end user via HTML, PDF, Excel, and CSV formats.
• Created Integration Services (SSIS) to perform multiple data extractions from IEX TotalView application.
• Helped to adapt the data load SSIS packages from one client that uses Oracle for use in a new client that uses Sybase. The SSIS packages utilized variables, expressions, loops, and scripts.
• Monitor databases for errors and perform problem determination when necessary.
• Review existing T-SQL code, to locate performance issues and develop improved T-SQL processes.
• Worked with load balancing backend processing applications allowing teaming of SQL Server engines to facilitate grid computing of web traffic user request to maintain 24x7 uptime and tight SLA response time.
• Support Development staff with SQL Server related tasks and along with review of code to prevent and resolve database bottlenecks.
• SQL server profiler-used as an auditing tool for security proposes to capture traces, Restricting the events and Diagnosing problem queries.
• Automated tools for moving files between cross domains using batch scripts
• Demonstration of In-built features of SQL Server including but not limited to: Security and processing how to code T-SQL , create programming objects (Databases, Tables, Stored procedures, Functions and Jobs)
• SSRS-Configured Report server virtual directory/configured report manager virtual directory/configured windows service identity/configured web service identity/configured the Report server databases, SharePoint integration, working with Report server Encryption keys, Initializing the Report server Instance, Configuring Email settings, Configuring the Execution account.
• Involved in database upgrade planning from SQL Server 2000 to SQL 2008(where it covers 2005 to 2008 too)
• Configuring Indexes for Maximum Performance-Configuring Index statistics, Exploring Fragmentation Considerations, Implementing fill factor administration, determining when to rebuild or reorganize an index , sorting indexes in the tempdb, using the database engine tuning advisor
• Conducting the health check for every 3 months-By using tools like SQLH2, SQLDIAG, and SQL2005 BPA
• Troubleshooting performance problems-on SQL profiler, system monitor(in the windows server 2003 operating system) and performance monitor(in the windows vista and windows server 2008), also known as perfmon, Dynamic management view(DMVs), SQL Server Extended Events (Extended Events) and the data collector, which are new in SQL server 2008.

Confidential, (Dallas, Texas)
April2008-December2008
SR.SQL DBA/Developer

• Installed new MS SQL Server 2005 and maintained 10 servers (Total size of the db around 5.1 TB).
• Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Designed the entire logical and physical model with 100 + tables using Visio, ERWin
• Enforced referential integrity via creation of constraints on database objects
• Designed and developed SQL Server Integration Services (SSIS) for data migration.
• Implemented database maintenance plan for new SQL server 2005 databases.
• Implemented data partitioning for new SQL Server 2005 databases (Created partition function, partition scheme mapped to a partition function and created the table on the partition scheme)
• Set up alerts, operators, SQL Mail, SQL Agent Mail, and notifications.
• Set up and schedule jobs that perform backups and database structure checks
• Monitored MS SQL servers for errors and performance degradation.
• Performed all aspect of database administration, including backup, recovery, and replication for SQL server 2005.
• As part of a team, analyzed the business requirements and systematically designed a database. Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the importation and exportation of data using SSIS
• SSRS-configured the report server Databases, SharePoint integration, working with Report server Encryption keys, Initializing the report server instance, configuring E-mail and execution account.
• SSRS-used Reporting services administration tools like Report manager and command line.
• Administering Reporting services site settings-configuring-Reporting services site name, My reports feature, report history, report execution timeout, report execution logging.
• SSRS-Reporting services security-Administering Item roles, system roles
• SSRS-Administering shared data sources and reports like-creating a shared data source, configuring shared data source credentials, securing the shared data source, publishing and viewing Reports, viewing and changing the report data source, viewing and changing report properties, administering a report-specific data source and creating linked reports with troubleshooting reporting services.
• Maintained the database consistency with DMV’s/DMF’s at regular intervals
• Analyze some of the long running slow queries & tune the same to optimize application and system performance.
• Created and maintained ERD diagrams
• Used SQL server profiler for performance tuning analysis services, to track full text queries by using profiler.
• Migrated database object using SSMA (SQL Server Migration Assistant)
• Involved in database upgrade planning from SQL Server 2000 to SQL 2008(where it covers 2005 to 2008 too)
• Administering Indexes- creating clustered indexes/Non-clustered index, Disabling/Deleting/enabling and Rebuilding Indexes. Implementing Index Maintenance and Maintenance plans
• SQL Query Analyzer: windows server 2000-Quicly created commonly used database objects from predefined scripts(templates), executed and debugged stored procedures(T-SQL debugger), Debugged query performance problems(Show execution plan, show server trace, show client statistics, Index Tuning wizard)
• SQL enterprise manager-windows server 2000-Defined groups of server running SQL Server, Register Individual servers in a group, configure all SQL server options for each registered server, Create and administer all SQL server database objects, logins, users, and permissions in each registered server,

Define and execute all SQL server administrative tasks on each registered server with test SQL statements, batches and scripts interactively by invoking SQL Query Analyzer

Confidential, (Pune, India) (June 2002-Aug2007)
SR.SQL Developer/DBA
Responsibilities:

• Installed new MS SQL Server 2005 and maintained 21 servers.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Maintaining the database consistency with DBCC at regular intervals
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Designed & implemented comprehensive Backup plan and disaster recovery strategies.
• Monitored and modified Performance using execution plans and Index tuning.
• Working with SQL Server Integration Services in 2005 for moving DTS packages.
• Rebuilding the indexes at regular intervals for better performance
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Complete documentation about the database
• Created and maintained ERD diagrams
• Monitoring SQL server performance using profiler to find performance and deadlocks and blockings.
• Export or Import data from other data sources like flat files using Import/Export of DTS
• Recovering the databases from backup in disasters
• Analyze long running slow queries & tune the same to optimize application and system performance.
• Writing Stored Procedures / Transact-SQL scripts.
• Creating / Scheduling Jobs, Alerts & Reports (Excel).
• Created and maintained ERD diagrams
• Used SQL server profiler for performance tuning analysis services, to track full text queries by using profiler.
• Migrated database object using SSMA (SQL Server Migration Assistant)
• Monitoring Locks, Blocking and other general DBA duties.
• SQL server profiler-used to generate workloads and test performance of databases and used the SQL server profiler to gather workloads over at least a 24-hour period
• Analyze long running slow queries & tune the same to optimize application and system performance.
• SQL enterprise manager-windows server 2000-Defined groups of server running SQL Server, Register Individual servers in a group, configure all SQL server options for each registered server, Create and administer all SQL server database objects, logins, users, and permissions in each registered server,

Define and execute all SQL server administrative tasks on each registered server with test SQL statements, batches and scripts interactively by invoking SQL Query Analyzer

Skills Used: MS SQL Server 2005/2000 with clustering, T-SQL, Win 2003, Oracle 8i, and Visual Basic 6.0 , SQL enterprise manager.