Summary

• 8 years of IT experience in Database Administration, Design Development and Support of MS SQL Server2012/2008R2/2008/2005 in Production, Test, Development and Cluster Server Environments.
• Experienced in using Corrective Measures in resolving issues like long running queries and blocking situations.
• Experience in using SQL Server Tools like DTS, Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer.
• Migration experience from MS SQL Server 2000 to MS SQL Server 2005/2008, MS SQL Server 2005 to MS SQL Server 2008/2008R2 and migration between contour environments.
• Master in performing administrative tasks, Database files management, Backup/Restore, Security management, Database Mirroring, Data integration and Synchronization and Isolation levels.
• Extensive use of DTS/SSIS in SQL Server, Performance Tuning, optimization and Normalization, Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients.
• Experience in Disaster Recovery Planning, Execution and Testing at remote side.
• Expertise in reading and understanding execution plan and fixing query to execute with low cost using various operators depending on the scenario.
• Worked in OLTP and OLAP environment that includes Production 24x7 , QA and development databases in SQL Server.
• Experienced in Administering, configuring and managing SAN, EMC storage for backups and disaster recoveries.
• Experience in Postgre MSSQL.
• Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.
• Monitored data activities i.e. database status, logs, space utilization, extents, Checkpoints, locks and long transactions .
• Experience in identifying root cause analysis and fixing the Windows / IIS Web Server Related issues. Extensive experience with IIS Internet Information Services 6.0/7.0 using Bulk Copy Program BCP , Data Transformation Services DTS packages and SSIS integration services with MS SQL Server 2000/2005.
• Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2000 and SQL Server 2005.
• Experience in PowerShell scripts and PowerShell active directory with SQL server PowerShell extensions.
• Designed and implemented administrative tools to automate system maintenance, accounting, and performance monitoring using UNIX toolbox.
• Expert in Extraction Transformation Loading ETL , Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
• Experience in Database administration activities for DB Security creating logins, users, roles, and assigning permission to them and implemented the security Policies as per PCI and SOX compliances.
• Expertise in DBCC Trace Flags and Blocking situations. Handled Logical Data and Index partitioning for large tables in SQL Server 2005 and 2008.
• Implemented the new SQL Server 2008 concepts like Data partitioning ,Snap shot isolation, database mirroring, Default trace, change data capture CDC , File stream, database snapshot, DDL triggers, try-catch blocks, online indexing, DMV's, DMF's, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
• Experience in database upgrades and applying software patches to databases as per application/client requirements.
• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management, Migrating DTS Packages to SSIS, Package Migration Wizard, and Storage Management.
• Experience in using SSIS SQL Server Integration Services for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.
• Experience in designing/generating/using/deploying Visual Studio 2005 Business Intelligence Reports, SQLServer 2005 Reporting Services SSRS, ADHOC and Crystal Reports .
• Experience in tuning of any SCOM management packs currently deployed.
• Suggested Application level tuning changes for code, queries SQL objects which may not be performing up to the optimum database performance standards.
• Extensive work experience on system analysis, design, development, testing and implementation of projectswith full SDLC Software Development Life Cycle .
• Experience in implementing High availability SQL Server solutions, including Replication Models Snapshot/Transactional and Implementing SQL Server clustering Active-Active, Active-Passive , Multi Node Cluster .

ADDITIONAL INFORMATION TECHNICAL SKILLS

WORK EXPERIENCE

Senior SQL Server DBA

Confidential

Responsibilities:

• Administrated and Managed SQL Server 2012/2008R2/2008/2005/2000 databases in Production, Staging,QA and development environments.
• Responsibilities include the Production and Application Support for the Database and Application Servers.
• Upgraded/Migrated SQL Server 2005/2008 databases to SQL Server 2012 databases and mentored other technical staff.
• Designed and developed SSISpackages using different control flow tasks, data flow task and data transformations.
• Performed ETL tasks from flat files to the servers and from SQL server to the flat files, csv files.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Resolving performance issues using DMVs Dynamic Management Views .
• Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
• Installing, Configuring and Maintaining SQLServer 2012/2008R2/2008/2005 64 bit on Active/Active Cluster with latest Service Packs, Hot Fixes.
• Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
• Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.
• Designed the Database Recovery plan and implemented the Database Mirroring in SQL Server 2008/2005 and participated in Disaster Recovery Drill processes.
• Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.
• Implemented new features in SQL Server 2008 like Policy based Management, Table Compression, Backup Compression, SQL Server Auditing, Resource Governor and Merge statement in T-SQL.
• Performed data partitioning for efficient management of database tables and indexes.
• Extensively working on performance issues like update statistics, Auto Stats.
• Involved in Change Data Capture process.
• Maintained Production and Test Database Environment in SQL server 2012/2008R2/2008/2005. Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.
• Debugged and Deployed SSIS packages in to file system server and MS SQL Server with the help of manifest file.
• Designed, Developed, Configured and Deployed custom build business reports using MS Reporting Services - SSRS.
• Provided 24/7 Support for Production, Development Test Servers of MS SQL Servers.

Environment: MS SQL Server 2005/2008/2008R2/2012, Windows 2008 server NT, IIS Server 6.0, SSIS, Reporting Services.

SQL Server DBA

Confidential

Responsibilities:

• Installed and maintained MS SQL Server 2005 on Windows 2003 Server. Worked on SQL Server 2003failover clustering which is built on top of a Windows 2003 server cluster.
• Upgraded/Migrated SQL Server 2005/2008 databases to SQL Server 2012 databases and mentored other technical staff.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQLServer.
• Designed and developed SSISpackages using different control flow tasks, data flow task and datatransformations
• Configuring, tuning and optimizing SQL Server 2005.
• Responsible for Stored Procedures optimization, Performance tuning index tuning.
• Administrator tasks like managing users, roles and permissions. Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.
• Implemented new features in SQL Server 2008 like Policy based Management, Table Compression, Backup Compression, SQL Server Auditing, Resource Governor and Merge statement in T-SQL.
• Performed data partitioning for efficient management of database tables and indexes
• Involved in complete database design including conceptual, logical and physical models.
• Experienced in working with SQL server PowerShell provider and central management server from PowerShell.
• Participated in the designing and development of software using agile development practices.
• Providing support for storage operations for EMCDatadomain, Net backup and other storage products. Based on the EMC requirement, updated the drivers HBA etc. /patches Operating System on all systems involved in the data migration.
• Implemented Tivoli Alerting for the SAN Infrastructure devices to alert the command Center and workedclosely with Tivoli team to create log adapters and carefully planned out the severity levels.
• Creating DTS Packages for data import/export, scrubbing and scheduled jobs for backups.
• Managing local and remote databases from within IIS Internet Information Services Manager.
• Creating Database Maintenance Planner for the Performance of SQL Server, which covers DatabaseIntegrity Checks, Update Database Statistics and Re-indexing.
• Maintained high availability of databases using Database Mirroring and Log Shipping.
• Used third party tool, Lite Speed, Red Gate to speed up backup operations.
• Created Complex reports using SS Reporting services.
• Created and maintained logical/physical data structures.
• Creating views and stored procedures and optimizing them as required by front-end developers for easierimplementation on web pages.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformationand data extraction.
• Used functions to create predefined conditions and prompts to filter the data and dynamic user selection.
• Involved in creating Cubes using SQL Server Analysis Services.
• Created the reports using Business Objects functionality's like Queries, Sub queries, Slice and Dice, DrillDown, Cross Tab, Master Detail and Formulae's etc.

Environment: Windows 2008, MS SQL Server 2000, MS SQL Server 2005, Perl, UNIX, Power shell, EMC Data domain, SAN, Oracle 9i, T-SQL, Visual Studio, Crystal Reports 8.5, Business Objects 6.1b, OLTP, SQL Loader, IIS, Lite Speed, Red Gate, MS Access, DTS, BCP, SSIS, SSAS, SSRS, SQL Profiler.

SQL Server DBA

Confidential

Responsibilities:

• Responsible for the Installation, Daily monitoring, Maintenance of SQL Server 2000/2005 installations inboth the Production and Development Environments and also upgrades to SQL server 2005.
• Involved in the configuration of new SQL Server Instances on Windows servers with appropriate parameters. Participated in the Migration of the databases and managed the location of database files, log files and their sizes.
• Upgraded/Migrated SQL Server 2005/2008 databases to SQL Server 2012 databases and mentored other technical staff.
• Developed, implemented, and maintained policies and procedures for ensuring the security and integrity ofSQL Server 2000/2005 and the corresponding databases.
• Created Maintenance plans, Scheduled Jobs and SSIS packages.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systemsand multiple applications.
• Created tables, views, indexes, functions and advanced queries for databases by using SSMS.
• Configured and maintained Transactional, Snapshot and Merge Replications.
• Monitored database status including CPU, memory, I/O, space, and deadlocks using SQL Server utilities.
• Performed Root cause analysis to track down problems and used SQL profiler for troubleshooting.
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.
• Created and managedschema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Monitored and modified Performance using execution plans and Index tuning.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQLServer.
• Creating Database Maintenance Planner for the Performance of SQL Server, which covers DatabaseIntegrity Checks, Update Database Statistics and Re-indexing.
• Technical Analysis, Code Review, Implementation, 24 x 7 production support.
• Experience in using ERWIN tool for Entity Relationship diagrams.
• Checking Database Health by using DBCC Commands and DMVS.
• Update statistics, database integrity check and Backup operations.

Environment: Windows 2000/2003, MS SQL Server 2000/2005, SSRS, SSIS, SSAS, VB 6, Erwin, SQL Server Profiler, SQL Loader, Database engine tuning Advisor, BPA, Upgrade Advisor.

SQL Server DBA

Confidential

Responsibilities:

• Administrated the SQL Server 2008/2005/2000 servers and production, pre-production, non-productiondatabases, Front end Application support and Performance Analysis/tuning.
• Created Documentation, schema designing, ER Diagrams using Erwin and MS Visio and involved inarchitecture.
• Monitoring SQL server performance using profiler to find performance, Dead locks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Migrated SQL Server 2000 databases to SQL Server 2005 databases including DTS to SSIS migration andmigrated SQL Server 2005 to VMware and SQL to Oracle using SSMS.
• Developed SSRS custom reports, Ad-hoc reports, sub reports.
• Extensively worked on snapshot and merge replication.
• Extensively worked on Log Shipping and Database Mirroring for 2000 and 2005 Production servers andSQL server 2005 security Audit.
• Used DMVs, DMFs for Identifying missing indexes and Index usage stats, Fragmentation levels of Indexesfor query/stored procedures tuning.
• Managed Security using SQL Logins, Roles and Authentication Modes for various categories of users.
• Involved in configuring table/data partitioning on huge tables for better performance.
• Troubleshooting and resolved Application issues, database performance and deadlocking issues.
• Reviewed and approved stored procedures developed by the developers and data modification SQL script for production.
• Resolved database space issues by sizing Table spaces, data files, and log files.

Environment:Windows 2000/2003, MS SQL Server 2000/2005, SSRS, SSIS, SSAS, VB 6, Erwin, SQL Server Profiler, SQL Loader, Database engine tuning Advisor, BPA, Upgrade Advisor.

Database Developer

Confidential

Responsibilities:

• Installation and configuration of SQLServer 2000/7.0 on Window 2000/NT OS.
• Managing of database objects like Tables, views, stored procedures, indexes etc.
• Written complex stored procedures and functions according to business requirements.
• Implementing Backups and restoring when necessary.
• Creation and management of Database maintenance plan for various database consistency checks.
• Extensively working on performance issues like update statistics, Auto Stats.
• Experience in SQL Server Analysis Services SSAS for designing OLAP Cubes.
• Creating monthly transaction report for all sections. Developing of Multi-Lingual Reports using CrystalReports.
• Designed and Implemented Reports using Business Objects Full Client.
• Reports were developed using Crystal Reports utility.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Involved in planning, designing, configuring and implementing SAN fabric.
• Worked on monitoring and tuning of SQL scripts using UNIX. Created upgrade scripts for productiondatabase and supported it.
• Managing of users including creation/alteration, grant of system/db.Roles and permission on variousdatabase objects.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Develop documentation that sufficiently describes technical deliverable as required for internal controls sothat the maintenance responsibility can be passed on to production support team.

Environment: SQL Server7.0/ 2000, Enterprise Manager, Windows 2000, SQL Profiler, DTS, Unix, Perl, Business Objects, T -SQL, ERWIN Data Modeler, SAN, DTS, SSAS, SSRS, SSIS, Crystal Reports.