SUMMARY

• Around 8 + years of IT Experience in SQL Server database Admin, System Analysis, Design and Development and Support of Microsoft SQL Server 2012/2008 R / 2000 in Development, Test and Production Environments on various business domains like Financial, Insurance and Manufacturing.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving System Analysis, Design, Development and Implementation.
• Expert in designing VLDB using design methodologies like STAR Schema, Snowflake Schema.
• Experience in administrative tasks scheduling Backup and Recovery Strategies and Disaster Recovery Procedures.
• Expert in using different Recovery Models simple, full and bulk - logged depending on availability of database.
• Experience in implementing different types of Replication Models like Snapshot and Transactional and Merge Replication.
• Hands on experience in maintaining Clustering, Snapshot Replication, Log Shipping and Database Mirroring.
• Experience in SQL Server Performance Tuning, client/server connectivity, Query optimization and running Database Consistency Checks using DBCC Commands.
• Experience to Handle VLDB servers stored in local disk and SAN.
• 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.
• Solid experience in Eliminating Blocking issues, performance monitoring with Activity monitor, SQL Profiler, Performance monitor, Database Tuning Advisor, DMVs and DMFs, SQL Diagnostic Manager.
• Expert in Monitoring Disk space, Improving Efficiency in databases including Index Tuning Wizard, Query tuning, and performing other maintenance tasks as Data Partitioning, Snapshot isolation.
• Expertise on Business Intelligence Tools to Create SSRS Reports, SSIS Packages and SSAS with OLAP.
• Experience in building Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions, for data warehousing using DTS and SQL Server Integration Service (SSIS).
• Worked in an Enterprise environment supporting many SQL Server instances
• Experience in Data Migrations from SQL 2000 to SQL 2005, SQL 2005 to SQL 2008/2008R2/2012, creating, deploying and troubleshooting SSIS packages.
• Experience in working with Reporting tools like Crystal Reports, Microsoft Reporting services SQL Server Reports, handling Sub Reports and defining query for generating Drill Down reports using SSRS 2005.
• Experience in developing PL/SQL and TSQL Packages, implementing business logic in backend using Stored Procedures, Triggers, Views, Scripts, Functions and Cursors.
• Ample of Expertise in Data Modeling tools such as ERwin, MS Visio and ER Studio.
• Used Bulk Copy Program (BCP) extensively for flat file import and export operation to/from SQL Server.
• Experienced in Reorganizing database structures, Reorganize or de-fragment database table spaces, tables, and indexes.
• Extensive experience with VMWARE consolidated environment.
• Knowledge on ALWAYS ON,MULTI SUB-NET Cluster and Contained databases
• Expert in using tools like SCOM, Idera, Red gate, Lite Speed, and NetBackup.
• Responsible in providing Development and Production Support 24x7 and off hours support.
• Strong interpersonal skills, analytical ability, communication skills, writing skills, highly organized to meet the deadlines and ability to grasp and adapt to the rising technologies.

TECHNICAL SKILLS

Operating systems: Windows XP/NT/98, Windows 2000/2003/2003 R2/2008/2008R2, Linux, UNIX.

Databases: Microsoft SQL Server 7.0/2000/ 2005/2008/2008 R2/2012, MS access 97 & 2000MySQL, Oracle 9i/10g.

SQL Database Tools: MS SQL Server Enterprise manager, Profiler, DTS, Query Analyzer, SQL Server Management Studio, SQL 2005/2008/2008 R2/2012 Integration Services (SSIS)Reporting Service (SSRS), and Analysis services (SSAS) (BIDS), SQL Server Migration Assistant (SSMA), SQL Profiler, SQL CMD, Database Tuning Advisor, Performance

Monitor, SQL Server Activity Monitor.:

Data Modeling Tool: ERWIN 4.0, Visio 2003, Office Visio 2007

Programming: Visual Basic 6, Visual Basic 5, C, C++ & SQL

Third Party Tools: Visual Source, Backup Utility, SCOM 2007, NetBackup, LiteSpeed, Idera, Commvault Control-M, Red Gate, MS- Visio, HPSM ticketing tool.

Web Tools: HTML and XML, SQL NET, ODBC, TCP/IP

PROFESSIONAL EXPERIENCE

Confidential, Richmond VA

Sr. SQL Server DBA

Responsibilities:

• Involved in migration from MS SQL Server 2000 and SQL Server 2005 to MS SQL Server 2008/2008R2/2012.
• Involved in installation/upgradation of SQL servers on Standalone and Clusters 32/64 bit, SQL Server 2005/2008/2008 R2 installed on Clusters 32/64bit 2 node clusters. Applied SQL Server Service packs, Hot fixes (Cumulative updates) on production/DR/QA servers.
• Responsible for configuration, tuning and provide 24X7 dedicated support, done maintenance windows to all Production, development, QA and clustered servers.
• Implemented and maintained Failover clustering (Active/Passive node) and Replication (Snapshot and Transactional, Transactional with Updateable) as databases high availability solution.
• Creating a virtualized Failover Cluster, create the virtual machine, install windows on the VMs, create a domain controller and ISCSI target, and configure the cluster nodes.
• Involved in documentation and implemented a disaster recovery system.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Worked on Security Issues such as creation and granting permissions on various Objects. Assign permission to user(s), role(s), and object.
• Analyzed long running slow queries and tuned the same to optimize applications and system performance and Performed DBCC Checks.
• Develop standards for data warehouse operations, programming, and security.
• Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
• As a gatekeeper to production, reviews, coordinates and implements changes, assess the effectiveness of the environment, recommends and follows through on implementation of improvements.
• Design databases to support business applications and develop database applications, designing, coding, testing, and implementing complex non-standard programs and scripts.
• Applying data fixes based upon the incident request by App team members.
• Handled Table and Index partitioning for 1TB size of databases.
• Diagnosed and tuned the server optimal performance using SQL Server Dynamic Management Views (DMV), SQL Profiler and Index Tuning Wizards.
• Rebuild Indexes and Tables as part of performance tuning exercise
• Successfully migrated data to new location using Snapshot Replication, and implemented Merge Replication to support up to date record of Inventory Information.
• Overall database design, such as creating normalized databases, authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types using T-SQL Statements.
• Hands on experience with Bulk Insert, BCP and Database consistency check using DBCC commands.
• Configured Transactional replication between Primary Server and three Read - Only servers, with separate Distributor server and experience in troubleshooting replication problems.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Monitored and report generation for the database infrastructure and these reports are submitted to management on regular basis.
• Reconfigured the default locations of the data files, log files and error log files onto the SAN environment for all the servers.
• Designed and implemented comprehensive Backup plan and rewriting the code to use SQL Native commands for SQL Server 2008 R2 versions
• Monitoring Double-take console to check the status of mirroring/replication of backup files cross the network
• Reviewing DBA Daily status report to troubleshoot the low disk space, consistency checks, server configuration and DB growth in proactive and submitting to Manager.
• Participated in Primary On-Call rotation, responsible for the prod releases, supporting app teams in case of assistance, applying patches, server verification and monitoring maintenance jobs
• Responded to issues that have been escalated with Change Control Processes and adherence to standards and documentation.

Environment: SQL Server 2000/ 2005/2008/2008 R2/2012, MS Access, Windows 2003/2008/2008 R2, SSRS, SSAS, SSIS, Commvault, Control-M, Idera monitoring tool, HPSM ticketing system, SharePoint 2007 and 2010.

Confidential, Los Angeles CA

Sr. SQL Server DBA

Responsibilities:

• Involved in migration from MS SQL Server 2000 and SQL Server 2005 to MS SQL Server 2008/2008R2.
• Install/upgrade of SQL servers on Standalone and Clusters 32/64 bit, SQL Server 2005/2008/2008 R2 installed on Clusters 32/64bit 2 node clusters. Applied SQL Server Service packs, Hot fixes (Cumulative updates) on production/DR/QA servers
• Upgraded SQL Server 2000 to SQL Server 2005/2008 and SQL server 2005 to SQL Server 2008/2008R2/2012 on Production/DR/QA Servers.
• Responsible for MS SQL Server 2005/2008/2008 R2, configuration, tuning and provide 24X7 dedicated support, done maintenance windows to all Production, development, QA and clustered servers.
• Configured MS SQL Server to use TCP/IP with default settings and ensured port 1433 is open in firewall.
• Involved in documentation and implemented a disaster recovery system.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Experience in Security Issues such as creation and granting permissions on various Objects. Assign permission to user(s), role(s), and object.
• Analyzed long running slow queries and tuned the same to optimize applications and system performance and Performed DBCC Checks.
• Diagnosed and tuned the server optimal performance using SQL Server Dynamic Management Views (DMV), SQL Profiler and Index Tuning Wizards.
• Rebuild Indexes and Tables as part of performance tuning exercise
• Successfully migrated data to new location using Snapshot Replication, and implemented Merge Replication to support up to date record of Inventory Information.
• Overall database design, such as creating normalized databases, authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types using T-SQL Statements.
• Hands on experience with Bulk Insert, BCP and Database consistency check using DBCC commands.
• Configured Transactional replication between Primary Server and three Read - Only servers, with separate Distributor server and experience in troubleshooting replication problems.
• Worked closely with audit team to implement SOX-Audit on all SQL servers.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Data migration using DTS services across different databases like Oracle, MS access, Sysbase & flat files.
• Monitored and report generation for the database infrastructure and these reports are submitted to management on regular basis.
• Reconfigured the default locations of the data files, log files and error log files onto the SAN environment for all the servers.

Environment: SQL Server 2000/ 2005/2008/2008 R2, MS Access, Windows 2003/2008/2008 R2, ASP.Net, ADO.Net, VB Script, SSRS, SSAS, SSIS, NetBackup,, Team foundation server (TFS), Windows 2007R2 Communicator, BMC Ticketing System, ER Studio, SharePoint 2007 and 2010.

Confidential, Minneapolis MN

SQL Server DBA

Responsibilities:

• Designed and implemented multiple systems using MS SQL Server 2005
• Developed various database objects like Tables, Triggers, Views and Stored Procedures by using T-SQL.
• Responsible for transferring of the databases and database objects from Development to Production Server DTS.
• Prepared Estimates for Database, table size growth.
• Responsible for MS SQL Server 2005, configuration, tuning and provide 24X7 dedicated support to all Production, development and clustered servers.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Additionally, designed and implemented a disaster recovery system.
• Created the logical and physical data modeling using Erwin tool.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Performance Tuning on live databases. This includes scanning for performance bottlenecks and troubleshoots them in order to provide the best service with the Servers.
• Developed database monitoring and tuning strategies and also Tuned Complex SQL Queries.
• Configured Log shipping from one production server to the reporting server.
• Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery.
• Scheduling the Backups and performing the restoration. Support for huge Databases.
• Importing and Exporting of the Database using DTS utility.

Environment: MS SQL Server 2000/2005 Enterprise Manager, Query Analyzer, System Monitor/Performance Monitor, Event Viewer, SQL Profiler, Quest Litespeed, T-SQL

Confidential

SQL DBA/ SQL Developer

Responsibilities:

• Installed and configured SQL Server 2000/2005.
• Developed various database objects like Tables, Triggers, Views and Stored Procedures by using T-SQL.
• Responsible for transferring of the databases and database objects from Development to Production Server DTS.
• Prepared Estimates for Database, table size growth.
• Responsible for MS SQL Server 2005, configuration, tuning and provide 24X7 dedicated support to all Production, development and clustered servers.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Additionally, designed and implemented a disaster recovery system.
• Involved in Database designing, Logical and Physical Data modeling using Erwin. Transformed logical model into Physical SQL Server Database.
• Created SQL tables using scripts and Erwin Forward Engineering Utility.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Performance Tuning on live databases. This includes scanning for performance bottlenecks and troubleshoots them in order to provide the best service with the Servers.
• Developed database monitoring and tuning strategies and also Tuned Complex SQL Queries.
• Configured Log shipping from one production server to the reporting server.
• Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery.
• Scheduling the Backups and performing the restoration. Support for huge Databases.
• Importing and Exporting of the Database using DTS utility.

Environment: MS SQL server 2000, Windows Server 2000, VB .Net, Enterprise manager, Query Analyzer, SQL profiler