SUMMARY

• Over 7 years of experience inSQL Server as Database Administrator and Developer inIT, Insurance, Finance, Commercial and industrial environmentsin Clustered and Stand - alone Server Environments.
• Microsoft Certified SQL DBA with staunch understanding of Database development, Administration, Design, Implementation & Support of SQLserver 2014/2012/2008 R2/2005.
• Expertise in core DBA tasks like Installation, Maintenance, Configuration, Backup & Restore, DR, Database Security and Database designing.
• Implemented and maintained ALWAYS ON feature in SQL Server 2012.
• Worked extensively on installing and configuring SQL Server Reporting services 2012, developed and deployed Ad- hoc, drill down reports for web based end users.
• Experience in PL/SQL developing like creating procedures, packages in Oracle 11gdatabases according to business requirements.
• NetApp- Implemented Microsoft SQL Server 2008: Decision support workloads-1 TB Data warehouse on IA64
• Experience in installing MS SQL Server 2005, 2008R2, 2012 and updating with hot fix and service packs.
• Extensive experience in implementing high availability solutions on physical and virtual machines.
• Implemented Side-by-Side Migration and in-place Upgrade of MS SQL Server 2000/20 R2.
• Good experience with XML, SQL, PERL, and shell scripting. Experience in writing Perl scripts covering data feed handling, implementing business logic, communicating with web-services and Application Programming Interface layers.
• Experience with Foglightin identifying the I/O and memory bottle necks, analyzing Locks, Dead Locks and handling the Isolation Levels and Concurrency Effects and handling them by implementing better Query Execution plans.
• Expert in designing and implementing Backup and Recovery Strategies.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, Spotlightand Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Experience in usingPerformance Monitor/Profilerto resolve Dead locks/Long running queries. And also good experience in data (table) partitioning.
• Expertise in Migrating SQL Server 2000 data bases into SQL Server 2005 and SQL Server 2008 and also expert in migrating DTS packages to SSIS Packages.
• Experience in using the DMVS, DMFS, INFORMATION SCHEMA, SYSTEM VIEWSand in-builtGlobal variables for the instant analysis.
• Designed DR plans while satisfying SLA requirements and conducted DR tests.
• Experience in implementing different types DR (disaster recovery) scenarios like Replication models like Snapshot, transactional, log shipping and Configure Database Mirroring in Cluster environment.
• Handful experience in Installs, deployments, certificate renewals, service accounts resets, process job tickets & bugs, test verify backups and recovery.
• Expert in Data Integrity, Performance Tuning and Query Optimization.
• Expert level skills in creating objects like Tables, Views, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing using T- SQL statements.
• Expertise in writing Stored Procedures, Functions and Triggers using T-SQL and also expert in tuning Complex Queries.
• Involved in ETL based applications and provided support.
• Performed BCP, BULK INSERT, imported and exported data from different Data Sources.
• Experience in Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Handling Memory configurations for SQL Server 2000 and 2005 on Windows 2003/2008 Server
• Extensively used the native tools like index tuning wizard, database tuning advisor, SQL Server Profiler, Performance Monitor, Activity Monitor, and Event viewer for performance analysis
• Auditing of database for user transactions, login and database action and in removing orphaned users.
• Provide software build support & ongoing assistance with build activities to ensure timely delivery of testing & production software builds in a highly software development life cycle process.
• Designed and documented Logical and Physical Data Models.
• Experience in using SSIS tools like Import and Export Wizard, PackageInstallation, and SSIS Package Designer
• Expert in creating SQL Server Reports using SSRS 2005 and 2008
• Thorough understanding of different RAID levels implementation.
• Strong ability in Scheduling and deploying reports on Report manager
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.

TECHNICAL SKILLS

Languages: Shell, PERL, C# ASP. NET, T-SQL, My SQL, Sybase, VB.NET, HTML, XML, C/C++, CSS, DHTML, Java Script

Operating Systems: Windows 95/2000/2003/2008/ XP/VISTA/7, Sun Solaris 9, LINUX, VMware ESX servers

Databases: MS SQL Server 2012, 2008R 2/2008/2005/2000, SQL AZURE, Oracle 10g/11g, MYSQL, Sybase, MS Access

ETL & Reporting Tools: DTS, SSIS, SSRS, SSAS, Crystal Reports

DB Utilities: SQL Server Management Utility, Query Analyzer

Application Software: Visual Studio 2005/2008, Visual Source Safe, TFS, MS Office Suite

Data Modeling Tools: Erwin, Visio

Other Tools: LiteSpeed, Red gate, Foglight, Spot light, IDERA SQL SAFE

PROFESSIONAL EXPERIENCE

Confidential -Foster City, CA

Sr Database Administrator

Responsibilities:

• Installed MS SQL Server 2008 R2 and2012 & 2014 updating with latest service packs and security patches.
• Configured Snapshot and Transactional Replication to replicate date to different environments.
• Extensively worked on migrating the databases fromSQL Server and alsoSQL Server 2005/ 2008toSQL 2008 R2.
• Worked on Upgrading SQL Server from including SSIS packages.
• Created and upgraded SSIS packages for creating file sand for ETL process.
• Worked on comparing database, database objects between two environments using schema compare tool in visual studio 2008.
• Implemented SQL Server installations, upgrades, installation of service packs, hot fixes, and maintenance activities.
• 4th generation SQL Server infrastructure (4 node clustered, multiple named instances) running in a Highly Available data center on Dell R710 hardware withNetapp backend SANstorage using iSCSI interconnects
• NetApp SAN- Sizing server I/O for SQL SERVER 2005/2008 on TR-3779
• NetApp SAN- Designed the storage layout for SQL SERVER 2005/2008 TR-3696
• Installed, authored, and managed reports using SQLServer2012 Reporting Services.
• Extensively worked on SQL Server Integration Services (SSIS).
• Created Maintenance Plans to make sure the database does not encounter any issues.
• Optimizedqueriesfor better performance.
• Configured change data capture(CDC)at database level to capture the Changes on the tables.
• Used Profiler to identify long running queries and optimize them.
• Rebuilt the indexes on regular intervals and placing the huge table/non-clustered indexon theseparate file group to improve the performance
• Planned and worked on setting upTable Partitioningforfaster maintenancesuch as rebuild and update statistics
• Involved in Capacity Planning, Database Normalization and De-normalization process
• Review T-SQL code to verify it meet standards for both performance and error handling according to DBA standards.
• Created Log on trigger to validate users connecting through different applications
• Written PowerShell scripts that are customized for a particular dataset - such as a morning health check, which outputs different Base information on reporting every morning.
• Used the PowerShell scripting to get the most consistent production environment.
• SAN:Storage and Storage Area Networks (SANs) including EMC, Fusion-IO, HP, IBM, NetApp, Dell

Environment: MSSQL server 2014/2012/2008 R2, T-SQL, SSIS, SSRS, Report Builder, Lite Speed, BCP, SQL Profiler, Replication, Log shipping, Mirroring, Clustering Service Desk BMC, Double Take, Team Foundation Server .Windows 8.1/7/XP, SSMS, DTS, SQL profiler, VSS6.0 C, HPSAN, Magic

Confidential - Folsom, California

Sr SQL Database Administrator

Responsibilities:

• Experience in installation, configuration, and upgradation of MS SQL Server R2 servers and from 2008R2 servers to Sql Server 2012.
• Experience in Resolving the Memory contentions using SQL Min/Max Settings, SQL 2008 Resource governor and Lock pages In Memory settings, Page File settings, Memory related DMV’s
• Identify deadlock, blocking scenarios and Perform Re indexing and Index defrag operations for the maintenance of large tables to resolve performance issues.
• Controlling Database Server file system management for data storage capacity and authority on SAN and RAID levels.
• Backup and recovery of production databases (using 3rd party tool Lite speed) on daily /weekly basis to ensure data integrity, striping the backups to ensure easy backup management.
• Perform database monitoring data and log growth, Jobs, Alerts, disk usage and cleanups, using various custom scripts in SQL Server Agent jobs, setup of Database Mail /operators for alerting.
• Database Design -reviewing\approving database designs before moving to production
• Database Code - reviewing\approving database code before moving to production
• Production Performance - reviewing production performance metrics to determine if\how changes are needed to prevent issues. Work with Tech services Database administration as needed.
• Application\Database Tuning- Proactively reviewing database specific application code (e.g. stored procedures, packages, etc.) to ensure optimal application and database performance. Work with Tech services Database administration as needed.
• Database Production\QA Turn support - responsible for creating, documenting &coordinating all Production\QA turn scripts via the Turn Center, and non-scripted changes with Tech Services Database administration. (e.g. SSIS Packages)
• Database Test Turn support - responsible for creating, documenting, coordinating, communicating and executing turns for stored procedure, tables, views, DTS packages and SSIS packages for Test.
• Liaison between IT and Tech Services Database administration for Production Support - Communicates between the Tech Services Database administration and e Pharmacy IT Application support teams to ensure everyone is aware of release schedules, turns, issues, fixes.
• Database Data Loading - data loading through application code, DTS packages, SSIS packages, BC Ping, FT ping, or exports
• Database Data extracting - data extraction through application code, DTS packages, SSIS packages, BC Ping, FT ping, or exports
• Database archiving\purging - responsible for determining what data should be archived\purged.
• Database Size - Maintaining space requirements for Database and monitoring for change

Environment: MS SQL Server 2008R2/2008/05,Windows 2008/2003 Server, ASP.NET, Java, CA Service Desk Lite Speed, MS Visio, Microsoft Visual Studio 2008/2005, MS Business Intelligence Development Studio 2008.

Confidential - Columbus, OH

SQL DBA

Responsibilities:

• Installed stand-alone and clustered SQL Server2008 and 2008 R2 on 64bit systems.
• Migrated SQL Server 2005 databasestoSQL Server 2008 R2 databasesincluding SSIS package sand from SQL Server 2008 to SQL Server 2012.
• Performed in-place upgrade from SQL Server R2
• Implemented and maintained Always-on, Database Mirroring, Log shipping and Transactional Replication as Disaster Recovery solution in SQL Server 2008 R2/2012.
• Managed and administrated SQLServer2012/2008R2/2005 on production and non-production servers.
• Involved in supporting Multi node Cluster environment in production having databases of size 3 to 10TB.
• Experience in Resolving the Memory contentions using SQL Min/Max Settings, SQL 2008 Resource governor and Lock pages In Memory settings, Page File settings, Memory related DMV’s
• Identify deadlock, blocking scenarios and Perform Re indexing and Index defrag operations for the maintenance of large tables to resolve performance issues.
• Implemented Policy Based Management on the servers and also wrote Power shell scripts which generates reports for monitoring space of the drives on the servers.
• Used Idera SQL Safe tool for performance monitoring, backup and recovery, security, auditing and PowerShell scripting
• Worked and provided production support to ETL based applications.
• Deploying and promoting SSIS packages from TEST to Prod environment.
• Developed a SSIS package to load data from SQL Base to SQL Server 2008 R2.
• Performed Failover drill tests to check the High Availability during disasters.
• Worked and responsible for design, implementation and enhancement of ETL jobs.
• Used Lite Speed for backups and maintenance jobs which includes updating statistics, database integrity checks
• Worked in setting upthe SQL Server configuration settingsto resolve various resource allocation & memory issues for SQL Server databases and to setupideal memory, min/max server options
• Developed and created the new database objects including tables,views, index, stored procedures, functions, triggers, advanced queriesand also updated statistics
• Modified Stored Procedures and complex T-SQL queries to improve query execution process
• Used SQL Diag utility tool for troubleshooting some issues.
• Worked on Hardware SAN and RAID levels configuration and placement of database files/file groups across different drives.
• Used third party tools like Quest lite speed for taking backups and restoring them, Spotlight and Confio Ignite tool for SQL performance monitoring.
• Created Logins, Roles and Proxy accounts with appropriate permissions and maintaining Database Maintenance Plans.
• Configured DB mail by creating accounts and profiles
• Worked on extensively on Linked servers and also was part of Oracle 11g Upgrade.
• Created and managed nightly Prod copy Jobs on the lower environments
• Monitored alerts usingFog LightandSpotlight and also looked into Event Viewer, SQL Error logs and Log File Viewer for software and hardware related errors.
• Worked on many Enhancement Projects and Upgrade Projects
• Provided On call Production support

Environment: MS SQL Server 2008R2/2008/05,Windows 2008/2003 Server, C#.net, VB and ASP.NET, Lite Speed, MS Visio, Microsoft Visual Studio 2008/2005, MS Business Intelligence Development Studio 2008, Ignite, Spotlight, Radmin, Oracle 11g/10g, Double Take

Confidential

SQL Server DBA/Developer

Responsibilities:

• Installed SQL Server on both 64 &32bit systems
• Managed and administrated SQL Server 2008R 2/2008/2005/2000 on production and non-production servers
• Installed SQL Server 2008/05 and service packson Windows Server Clustered environment
• Migrated SQL Server 2005/2000 databasestoSQL Server 2008 databasesincludingDTS to SSIS packages.
• Updated statistics, performed database integrity checks and Backup operations
• Performedbackup using backup compression and Data compression inSQL Server 2008 on clustered environment
• Set up and monitoredtransactional replication, database mirroring on Production, QA and Dev serversand troubleshot errors
• Developed and created the new database objects including tables,views, index, stored procedures, functions, advanced queriesand also updated statistics using Query Analyzer and Enterprise Manager on the existing servers
• Worked in setting upthe SQL Server configuration settingsto resolve various resource allocation & memory issues for SQL Server databases and to setupideal memory, min/max server options
• Configured SQL Server and SSRS using IIS
• Experience in using ERWIN tool for designing the reporting databases
• Responsible to monitor and troubleshooting Log Shipping
• Assisted on the Adhoc-Query requests based on the requirement by using joins, sub queries and co-related sub queries.
• Capacity Planning - Analyzed the Database Growth and reported future space requirements.
• Designed and developedSSIS packages using different control flow tasks, Transformations and dataflow tasks
• CreatedSSIS packagesto load robust data from differentheterogeneous data sourceslikeOracle, DB2 to SQL server
• Created, scheduleddatabase maintenance planusingSSIS Maintenance plan task
• UsedOnline Indexingandonline RestoringinSQL 2005
• Extensively used Repositories like Team Foundation Server (TFS).
• Prepared, maintained and modified SQL server installation and configuration documents.
• Succesfully done with Failover cluster testing and resolution on servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Created various reports like charts, sub reports, graphs and scheduled these reports using windows task scheduler to run on daily, weekly and monthly basis.
• Closely worked with client services and development team for analysis of client requirement and worked with development team to configure those changes into database management configuration.

Environment: MS SQL Server 2008R2/2008/05/00 (Enterprise Manager, OLAP cubes with SSAS, SSIS,Query Analyzer, SQL Profiler, Index Tuning Wizard, DTS, MSSQL Server2000 Analysis Server), Windows 2008/2003 Server.