SUMMARY:

• Administering SQL Server 2000/ 2005/2008/2008 R 2/2012/2014/2016 in Production, QA and Development environments and knowledge on SQL Server 2017
• Implementing Microsoft Private Cloud using System Center suite
• Hyper - V, System Center Virtual Machine Manager, Service Management Automation, Configuration Manager, Operations Manager
• Automating activities using PowerShell, T-SQL, WMI Scripting, VB Scripting
• SQL Server installations, upgrades and migrations, configuration
• Building SQL Server clusters and Always-On environments including multi-subnet clusters
• Administering very large databases (VLDBs)
• Setting up High Availability using Logshipping, Replication and Mirroring
• Setting up SQL Agent jobs and alerts, DBMail, Maintenance Plans
• Devising Backup strategies, Capacity Planning and Security Management
• Troubleshooting and query/performance optimization
• Using SQL Server tools (SSMS, Profiler, Configuration Manager etc)
• Using Third-party client tools (Oracle, Sybase, DB2, MySQL clients etc)
• Using Resource Governor and Policy Based Management
• Developing and deploying SSIS/DTS packages
• Using Backup tools like LiteSpeed, NetBackup and Avamar
• Preparing SQL Server Build Standards and Security Baseline documents
• Building UAT and DEV environments for SQL Server
• Sound knowledge on SQL Server architecture
• Provisioning VMs in Microsoft Private cloud environment
• Automating activities/tasks in Microsoft Private cloud environment using SMA Runbooks
• Provisioning and administering Virtual Networks, VMs and SQL Databases in Microsoft Azure environment
• Setting up and administering SQL Server Analysis and Reporting Services environments
• IIS and developing applications using .Net technologies
• Strong ability to learn new technologies quickly and adapt to changing environments

TECHNICAL EXPOSURE:

Operating Systems: MS - DOS, Windows 98/XP/7, Windows Server 2003/2008/2008 R2/2012/2012R2/2016, Linux

RDBMS: SQL Server 2000/ 2005/2008/2008 R 2/2012/2014/2016 /2017

DBMS Tools: BMC Database Automation (BDA), LiteSpeed, NetBackup, Avamar, Foglight, Solarwinds Database Performance Analyzer, TOAD, Spotlight, Benchmark Factory

Data Access Clients: Oracle, IBM DB2, Sybase, MySQL, iSeries, Access DB Engine, Teradata, Netezza, Informix (clients installed on SQL Server machines to connect to other RDBMS)

Scripting: T-SQL, PowerShell, VBScript, Perl

Business Intelligence: SQL Server 2005/2008/2008 R 2/2012/2014/2016 Integration, Analysis and Reporting Services

Virtualization/DBaaS: Microsoft Hyper-V, System Center 2012 R2 (VMM, SMA, Orchestrator, SCCM, SCOM), Windows Azure Pack (WAP)

Cloud Technologies: Microsoft Azure, Microsoft Azure SQL Database (SQL Azure)

Languages: C#.Net, VB.Net, C, C++

Web Designing: ASP.Net

Web/App Servers: IIS

PROJECT EXPERIENCE:

Confidential, Los Angeles, CA

Senior SQL Server DBA/Engineer

OS: Windows Server 2008(R2)/2012R2/2016

Database: SQL Server 2008/2008R 2/2012/2014/2016

Backup Tools: LiteSpeed

Performance Monitoring: Solarwinds Database Performance Analyzer (DPA)

Responsibilities:

• Building and configuring SQL Servers (stand-alone, cluster and AlwaysON Availability Groups)
• Defining the SQL Server standards to be followed within the Organization
• Planning and implementing any SQL Server projects
• Onboarding any SQL Server related tools
• Creating and maintaining SQL Server Configuration Items (CIs) in ServiceNow
• Implementing Service account password changes and other critical CRQs
• Monitoring the performance of the SQL Servers
• Migrating SQL Server databases to the latest versions
• Upgrading and patching SQL Server instances
• Escalation Point of Contact for Offshore Vendor team

Confidential

Lead Analyst (Lead SQL Server DBA/Engineer)

OS: Windows Server 2003/2008(R2)/2012/2012R2/2016, Linux

Database: SQL Server 2005/2008/2008 R 2/2012/2014/2016 /2017

Scripting: T-SQL, Windows PowerShell, VBScript, Perl

Automation: BMC Database Automation (BDA)

Backup Tools: LiteSpeed, NetBackup 7.6/7.7/8.1, Avamar 7.1/7.3

Virtualization/DBaaS: Microsoft System Center 2012 R2, Hyper-V, Windows Azure Pack (WAP)

Responsibilities:

• Building and configuring SQL Servers (stand-alone, AlwaysON and clusters including multi-subnet clusters)
• Automating SQL Server installation using BMC Database Automation (BDA) tool
• Working on implementing DBaaS in the Bank environment (using Windows Azure pack and System Center 2012 R2)
• Automating activities in Private Cloud using SMA runbooks
• Automating regular activities using PowerShell, T-SQL and other scripting languages
• Automating SQL Server patching using System Center Configuration Manager (SCCM)
• Configuring monitoring using System Center Operations Manager (SCOM)
• Evaluating Microsoft Azure (the public cloud) to implement hybrid clouds in the Bank environment
• Preparing the installation documents for SQL Server builds
• Implementing PBM (Policy Based Management) monitoring
• Performance analysis/monitoring, tuning, storage management, capacity planning, backup and recovery strategies
• Developing SQL Server maintenance routines using T-SQL
• Testing the regular functionality of the SQL Server and any enhancements (LogShipping, Replication, Mirroring, Backup & Restore, SQL Server Agent jobs etc)
• Evaluating new features of new SQL Server releases/service packs (Auditing, Change Tracking etc in SQL Server 2008, and HADR Availability Groups, Contained Databases, etc in SQL Server 2012, In-Memory OLTP, Delayed Durability, Backup Encryption etc in SQL Server 2014)
• Preparing Slipstreamed media for SQL Server
• Upgrading SQL Server from older version to newer version (Side-by-side and In-place upgrade)
• Certifying SQL Server Integration Services and evaluating its new features
• Involving in certifying SQL Server Analysis Services and Reporting Services new features
• Certifying third-party database product drivers against SQL Server (Oracle, Sybase, MySQL, DB2, AS400 etc ODBC, OLEDB and .Net Provider drivers)
• Certifying third-party database backup, monitoring and management tools for SQL Server (LiteSpeed, NetBackup, Avamar, Foglight, TOAD, Spotlight etc)
• Automating SQL Server backups using third party tools Avamar and NetBackup
• Managing BDA content/satellite servers hosted on Linux environment
• Preparing the Build Standards documents for SQL Server for new implementations
• Preparing the Upgrade Standards documents for SQL Server upgrades
• Creating and publishing Domain Reference Architectures (DRAs) for certified SQL Server versions to be used in the Bank
• Involving in preparing Security Baselines documents for SQL Server major releases
• Helping SQL Server Operational and DBA Production Support (L3) teams in cases where they can’t resolve issues
• Developing BDA actions, templates and patch packages for SQL Server releases using Perl, VBScript and/or PowerShell scripts
• Participating in meetings with all the SQL Server DBA team managers across the Bank
• Providing training to the new resources in to the team
• Handling Enterprise Architecture (EA) exception requests for SQL Server. This includes providing recommendations for the exception requests for using non-standard SQL Server implementations and cohabitating SQL Server services (Database Engine, Analysis Services and Reporting Services) on a single machine.

Confidential

Senior SQL Server DBA

OS: Windows Server 2003/2008(R2)/2012/2012R2

Database: SQL Server 2005/2008/2008 R2/2012/2014

Scripting: T-SQL, Windows PowerShell, VBScript

Backup Tools: LiteSpeed

Responsibilities:

• Building and configuring SQL Server standalone/Clusters/AlwaysON and other components
• Managing security on Production and Development environments
• Upgrading SQL Servers and migrating databases
• Administering Very Large DataBases (VLDBs)
• Automating regular DBA tasks using Windows PowerShell, VBScript
• Installing SQL Server Service Packs and Hotfixes
• Setting up HADR features - Log Shipping, Replication, Mirroring, Clustering and AlwaysON
• Building Confidential SQL Server environments which can be used by multiple teams
• Building and configuring SQL Server QA, DEV and Test environments
• Setting up monitoring tools to monitor the database environment
• Devising and implementing Backup and Recovery strategies
• Resolving disk space issues and other production related issues
• Scheduling DBCC checks and index rebuild/reorganization
• Importing data using Bulk Copy Program (BCP), Integration Services (SSIS) from various data sources
• Creating and deploying SSIS packages
• Building and configuring SSAS and SSRS environments
• Creating and deploying various reports using SSRS
• Analyzing the performance of database servers and fine-tuning the environment
• Participating in meetings with LOB managers

Confidential

Senior Database Administrator

OS: Windows 2003

Database: SQL Server 2000/2005

Scripting: T-SQL, VBScript

Responsibilities:

• Building, configuring and testing SQL Server 2005 Servers/Clusters
• Configuring various components of SQL Server 2005
• Capacity Planning for new SQL 2005 Clusters
• Implementing the Security model for the new SQL 2005 Clusters
• Migrating SQL Server 2000 databases to SQL Server 2005
• Defining and implementing Backup and Recovery strategies
• Implementing Point-In-Time recovery of the databases whenever needed
• Automating regular DBA tasks using VBScript, SQL Agent jobs (T-SQL)
• Developing SSIS packages to import the data into SQL Servers from other sources
• Monitoring the environments closely and suggesting the clients with better solutions
• Implementing the better database practices wherever it is possible
• Installing the SQL Server Service Packs and Security Updates
• Configuring the maintenance plans and SQL jobs required for the regular maintenance
• Configuring the features of SQL Server (like LogShipping) wherever it is required
• Building the UAT and DEV environments
• Troubleshooting and resolving any issues with jobs (SQL Agent and Scheduled Tasks)
• Monitoring the performance of the servers and fixing issues if any
• Representing the team from offshore and attending the client meetings

Confidential

SQL Server Database Administrator

OS: Windows 2003

Database: SQL Server 2000/2005

WebServer/Languages: IIS 6.0 / C#.NET 2.0, VBScript

Web Designing: ASP.NET 2.0

Responsibilities:

• Setting up the monitors to monitor the various application and database components
• Setting up the required SQL Agent jobs (for taking backups, DBCC checks, rebuilding indexes etc).
• Monitoring the IIS/database servers associated with the applications
• Troubleshooting and resolving the issues with the jobs (SQL Agent jobs and NT Batch jobs)
• Monitoring the database server performance and query performance closely to ensure database productivity, fixing the issues or suggesting Development team with the inputs
• Monitoring the Log shipping and Replication setup between various servers
• Developing DTS packages
• Working on blocking on the database servers when alerts are fired and killing the processes if required
• Failing over the resources in Cluster environment and Primary/Secondary Logshipping environment when there are any maintenance works on active/primary server.
• Implementing the new releases for the applications (which includes application code and the database component changes)
• On boarding new applications (which includes setting up application components, database components, SQL Agent jobs and taking care of permissions)
• Building BCDR (Business Continuity and Disaster Recovery) environment for critical applications
• Building UAT (User Acceptance Test) environment for all the applications so that before implementing a release, it is implemented in UAT and smoke tested thoroughly. This also involves refreshing the UAT databases on demand basis.
• Replacing the servers which are out of life cycle and also for providing the compatibility for newer versions of the Operating System (this includes installing IIS servers, building NLBS and SQL Clusters and setting up databases, logshipping and replication by coordinating with various teams if required)
• Maintenance works on the servers (like applying security updates, performing Security Scans and coordinating with various teams to upgrade the Operating System, service packs and any issues with Operating System)
• Training the new resources in the team (including Technical and Application oriented)
• Review meetings with the Project Managers on regular and scheduled activities

Confidential

SQL Server Database Administrator

OS: Windows 2000/2003

Database: SQL Server 2000/MS Access

Responsibilities:

• Collecting the domain related data and dumping the data into SQL Server database tables using DTS packages
• Migrating the workstations/servers to the new domain using Quest Migration Tool
• Monitoring the health of SQL Servers
• Troubleshooting blocking and other SQL Server related issues
• Building the Test environments (including SQL Clusters)
• Preparing the various reports using the data collected
• Working on any SQL Server migration issues