PROFESSIONAL SUMMARY:

• Twelve + years of experience as a Database Administrator (DBA) in fields including Financial, Pharmaceutical, Insurance, Healthcare and IT industry working on different version of MS SQL Server 2000/2005, 2008/2008 R2/2012/2012 R2, 2014, 2016.
• Mentored/coordinated SQL Server DBA teams, including Offshore, operating in a 24x7 environment in accordance with all service level agreements and customer expectations.
• Monitor project, delivery schedules and resources.
• Lead team in proper escalation of internal tickets to both vendors and internal technical & service delivery team members supporting specific functions and technologies.
• Ensure team is conducting proper ticketing, documentation, process adherence, etc.
• Provide the correct team support - detailed investigative and analytical information - when problems occur.
• Solid experience on high availability SQL Server solutions, including Replication Models (Snapshot/Transactional) and SQL Server clustering (Active-Active, Active-Passive).
• Experience in Disaster Recovery Planning, Execution and Testing at remote side
• Support root cause analysis and define action plans to prevent future outages and ensure continuous availability of services and meeting all service level agreements.
• Develop and maintain support documentation of work performed with detailed process steps.
• Provide subject matter expertise as needed; including estimating levels of effort and troubleshooting.
• Recognize areas of process improvement; initiate and implement approved changes, and document policies, processes and procedures.
• Monitor and report on performance and customer satisfaction levels and research methods to improve overall client support.
• Maintain a relationship with the customer base, continuously gathering feedback concerning the perceived quality of support.
• Conduct regularly scheduled meetings with customer to provide project related status.
• Experience in Installing and configuring MS SQL Server Database Engine, MS SQL Server Reporting Services, MS SQL Server Analysis Services.
• Experience in installing and configuring MS SQL Server Database Engine on physical and virtual servers (VMWare).
• Built and Maintained standards for SQL Server High Availability and Disaster Recover technologies including but not limited to Log Shipping, Database Mirroring, Database Replication and SAN Replication (as it pertains to SQL Server)
• Strong understanding of Microsoft Best Practices for SQL Server Configuration.
• Provide design recommendations based on long-term IT organization strategy.
• Experience in applying hot fixes, cumulative updates on SQL Server Database Engine.
• Experience of performance tuning and MS SQL Server administration in various enterprise environments as DBA
• Extensive experience with SQL Server Database objects with the ability to leverage T-SQL to manipulate them
• Proficient in performance tuning of T-SQL queries, stored procedures and debugging the poorly written code and helping application teams in development life cycle.
• Extensive experience in working with Query Analyzer, Database Tuning Advisor, SQL Server Profiler for administrative tasks.
• Involved in migration of MS SQL Server Database engine from and and 2008 R2, R2 to 2012 versions.
• Experience in prepping up the servers with replication, Log shipping and Database Mirroring as part of DR- Strategy.
• Experience in taking backups, restoring backups, converting 3rd party backup to native SQL Server backups.
• Experience in using SSIS for various ETL process and using BCP and Bulk insert techniques as feeds to the databases.
• Created, monitored, and executed all SQL related Jobs in production environment
• Experience in scheduling, maintaining and monitoring jobs, alerts, SSIS packages using SQL Server Agent.
• Held responsible for creating SQL Server authenticated accounts and NT authenticated accounts in SQL Server environments.
• Installed and configured databases (including tables, views, keys, etc), administer policies, standards, procedures and guidelines necessary to effectively maintain the database environment.
• Knowledge of Windows server administration, RAID and SAN Storage Technologies.
• Good knowledge of Database portioning of tables for better performance in VLDB environments.

SKILL MATRIX:

Operating Systems: Windows 2012 R2, 2012, 2008 R R2/2000 Servers, Windows XP/NT/Vista, Linux, VM

Programming Languages: T-SQL, PL/SQL, C, C#, Java, VB.NET, HTML, XML, Batch Scripting.

Databases: MS SQL Server 2016, 2014, 2012, 2008R 2/2008/2005/2000, Oracle 9i/10g/11, Sybase, MySQL, NoSQL

Client Tools: SQL Server Management Studio, SQL Query Analyzer, Toad for SQL Server, Visual Studio, SQL Server Business Intelligence Development Studio (SSIS, SSRS),, SSDT, SQL Server Report Manager.

3rd party Tools: AIX, LINUX, PHP, NetApp, NetBackup, TSM, HyperBac, SQL Litespeed, Powershell, VMWare, SQL Change Manger, Remedy, Maximo

PROFESSIONAL EXPERIENCE

Confidential, Confidential, Confidential, Confidential, Confidential, Confidential

Sr SQL Server DBA

• Installing MS SQL Server 2016, 2014, 2012, 2008 R2/2005 on Windows 2008 R2/2003 R2 Operating systems on standalone servers and Active/Active and Active/Passive clustered servers.
• Coordinate SQL Server DBA teams in a 24x7 environment in accordance with all service level agreements and customer expectations.
• Monitor project, delivery schedules and resources.
• Lead team in proper escalation of internal tickets to both vendors and internal technical & service delivery team members supporting specific functions and technologies.
• Ensure team is conducting proper ticketing, documentation, process adherence, etc.
• Provide the correct team support - detailed investigative and analytical information - when problems occur.
• Plan, coordinate and execute change management processes
• Balance staff workload and identify gaps in technical capabilities so they can be filled or avoided to meet project and operational needs.
• Support root cause analysis and define action plans to prevent future outages and ensure continuous availability of services and meeting all service level agreements.
• Experience with Active Directory, DHCP, DNS, IP, Sub Nets, VPNs, vLAN, Network routing, firewalls, LAN/WAN switching and Backup & Recovery.
• Install and configure virtual cloud instances, support cloud servers including security configurations, patching, and troubleshooting.
• Installation, configuration, and deployment of VMware products such as VMware Workstation, VMware converter, VMware View, VCB and more in virtual environment
• Configuring DNS and also Domain Trust Relationship as per requirement.
• Windows Administration skillset with Active Directory and Core Windows administration activities.
• Implemented and supported high availability on the various servers using replication/mirroring.
• Implemented and supported Always-ON (AAG) on SQL Server
• Powershell programming skills and automating regular routine activities for efficient man hours.
• Knowledge on Virtualization and also creating virtual machines using ESX hosts.
• Implementation of Windows Clustering from Quorum to cluster implementations.
• Knowledge on Windows Cloud (Azure) implementations.
• Worked on SQL Server On-Premesis migrations to Windows Azure cloud.
• Implemented SQL Server Backup to Cloud Blob URL(SQL 2012) and Smart Backups(SQL 2014).
• Handson on Alwayson Availability Groups and also Alwayson Clustering (FCI).
• Worked on SQL Server Integration Services (SSIS) and Reporting implementation (SSRS).
• Experience in Windows 2008/2003/2000/ NT4.0Servers at single or multi domain platforms.
• Experience in installing and configuring MS SQL Server Database Engine on physical and virtual servers (VMWare).
• Installing services packs and cumulative updates for MS SQL Server 2012, 2008R2/2005 on standalone servers and clustered servers.
• Performed database partitioning, purging, archival
• Used Powershell scripting to automate the SQLServer administration.
• Changing MS SQL Server service accounts for MS SQL Server startup accounts as per the client’s policies.
• Involved in Migration/Up gradation of MSSQL Server 2000, 2005 to MSSQL server 2008 R2, 2012, 2014.
• Creation of Logins (AD/SQL Server Logins) with appropriate server roles in SQL server.
• Creating policies and held responsible for backups of databases as part of DR-Strategy using Litespeed, NetBackup, TSM, HyperBack SQL Safe Backup, Native SQL Server backups.
• Generated scripts for objects along with data into files using database publishing wizard and executing them in DEV environment.
• Created databases, tables, views, local temp tables, global temp tables, table variables as per the application requirements.
• Checking consistency of databases using DBCC commands or Dynamic Management Views (DMVs) to check for any inconsistencies and improving the performance of databases and avoiding slow performance in application.
• Responsible for developing scripts in T-SQL scripts for administrative purposes, and tuning scripts for better performance.
• Updating/Creating Statistics on indexes that help the optimizer to yield better results for the queries that were executed.
• Worked with SQL profiler and generated traces when needed for bottlenecks in applications and poorly performing queries.
• Leverage Change Control processes for all SQL Server changes made in the Production environment
• For generating reports we create Database snapshots and dropping them when the reporting is done.
• Performed Bulk data migration using SSIS from flat files

Environment: MSSQL Server 2016, 2014, 2012, 2008 R2/2005, 2000, Windows Server 2012, 2008R2/2003, Windows 7,, SQL Server Integration Services (SSIS), MSSQL Server Reporting services 2005/2008 R2, 2012, Sybase, AIX, LINUX, PHP, NetBackup, TSM, HyperBac Maximo, Remedy, VMWare, Powershell, TSQL, SQL Server Profiler.

Confidential, San Francisco, CA

Sr SQL Server DBA

• Installing and configuring MS SQL Server 2005/2008 on Window 2003/2008 servers.
• Installing Service packs, cumulative updates for MSSQL Server 2005/2008 on standalone and clustered servers (active/active) and (active/passive)
• Migrated Databases from MS SQL server 2005 to MS SQL Server 2008 environment using Side by side up gradation technique.
• Changed MS SQL Server startup service account passwords on a half yearly basis as per the client requirements.
• Configuring DNS and also Domain Trust Relationship as per requirement.
• Windows Administration skillset with Active Directory and Core Windows administration activities.
• Created logins and dropping logins for administering them in SQL Server environment with appropriate servers roles and database role s.
• Part of security, created server audits for various auditing purposes in MS SQL Server 2008.
• Creating various administrative jobs in MSSQL Server and scheduling them under SQL Server Agent.
• Expert in extracting data using SSIS from OLTP to OLAP
• Using Policy based management created policies for MSSQL Server for different type of administrative tasks.
• Created policies for database backups and backing up databases as part of DR- strategy in case of any disasters.
• For compressing backups used new SQL Server backup compression technique that way it helped storage allocation.
• Using Transparent Database Encryption technique, database backups were secured in MS SQL Server 2008.
• Restoring databases in DEV/UAT/Test environments from PROD backups as per the requirements of DEV/UAT/Test teams and scripting out all the users and their permissions and role s.
• Created tables, views, temporary tables and table variables in MS SQL Server 2008/2005 environment.
• Checked consistency, fragmentation, torn page detection in databases using DBCC commands and DMV’s at regular intervals.
• Created indexes on columns of a table with appropriate index type, in turn, help SQL queries to perform better.
• During Maintenance window we used to rebuild indexes, updates statistics for better performance of MSSQL server.
• Working with SQL server profiler to check for any performance issues and tracking them and tuning them for better performance.
• Monitoring and troubleshooting blocking and locking issues on regular using Activity Monitor.
• Using Database Tuning Advisor and finding out any missing indexes on tables and implementing suggestions given DTA.
• Tracking changes in databases using Change Data capture technique in MS SQL Server Environment.
• Implemented Log Shipping and Database Mirroring DR techniques were implemented and tested as part of High availability solution in case of disaster.
• Responsible for creating Database snapshots for reporting purposes on DR sites for load balancing on production servers.
• Created SSIS packages deployed them and administered them for various business continuity purposes.

Environment: MSSQL Server 2008/2005, Oracle, Windows Server 2003/2008, MS SQL Server Integration Services, MS SQL Server reporting services, Database tuning Advisor, SQL profiler, Litespeed, Business Development studio, Report Builder.

Confidential, Aliso Viejo, CA

Sr SQL Server DBA

• Installed SQL Server 2005 on standalone as well as consolidated SQL server environments.
• Applied Services packs, hot fixes, and cumulative updates in SQL Server 2005 Environments.
• Created
• Scheduling and monitoring Jobs were done using SQL Server Agent in MS SQL Server.
• Monitoring of SQL Server blocking, Job Monitoring, Disk space monitoring and trouble shooting performance issues using Jobs, DMVs.
• Checked consistency, fragmentation, torn page detection in databases using DBCC commands and DMV’s at regular intervals.
• Using BCP commands tables data was exported to flat files and these files were used to import the data back to tables as a part of business logic.
• Backing up the databases with different backup types (Full, Differential, Transactional Log) as a part of backup strategy.
• Helping Dev/QA/Test teams with database refresh requests and with application deployment and testing.
• Creating Indexes on right columns of a table that help providing T-SQL queries to run faster.
• Updating SQL statistics on databases will help optimizer to choose the best plan to execute the queries.
• Extensively Developed SQL scripts for maintaining administration tasks.
• Consistencies of databases were checked using DBCC commands and Dynamic Management Views.
• Prepping up servers for implementing and maintaining Log shipping method as part of DR-Strategy.
• Prepping up servers for implementing and maintaining Replication (Transactional and Snapshot) as part of DR-Strategy.
• Used SQL Server Profiler to find any performance issues in SQL Server Databases and tracking them and tweaking them for better performance.
• Using Database Tuning Advisor used to track down any missing indexes on columns of a table and that helped T SQL queries to perform much faster than before.
• Migrated databases from MSSQL server 2000 to MSSQL 2005 Database engine using in place upgrade strategy.
• Created stored procedures and functions as per the application requirements and for various administrative tasks.
• Responsible for developing physical and logical data models using ERWIN.
• Documenting all the changes that were made to existing MS SQL Server environment.
• Created SSIS packages for various administrative tasks and deploying and maintaining them.
• Developed SSRS reports and configured SSRS in MS SQL server Environment.

Environment: MS SQL Server Database Engine 2005, MS SQL Server Integration Services, MS SQL Server Reporting Services, Remedy, ERWIN, Sybase, SQL profiler, Database Tuning Advisor, Business intelligence Development studio, TOAD, HPOVO.

Confidential, Raleigh, NC

SQL Server DBA

• Installed MS SQL Server 2005/2000 on standalone and clustered servers on windows 20 and 32 bit) servers.
• Created tables, views, stored procedures, functions in MS SQL Server Environment.
• Created triggers for capturing DML and DDL changes for critical tables in MS SQL Server 2005 databases for auditing purposes.
• Creating and managing schema objects and maintaining referential integrity depending upon the requirements and technical specifications.
• Involved in interacting with business managers to gather requirements analyze and work on information provided by them.
• Involved in Data Modeling design and building relational databases.
• Worked with development team in tuning complex stored procedures and T-SQL scripts that were effecting OLTP application.
• Creating Jobs, Alerts, and Proxies and maintaining under SQL Server Agent.
• Prepping up and maintaining Log shipping technique from PROD to DR servers as part of disaster Recovery.
• Created Logical and physical modeling using ERWIN tool.
• Maintaining MS SQL Server security settings with appropriate roles and s as per the DBA team policies.
• Creating Backups for MS SQL Server Database engine as part of back up strategy.
• Restoring databases from PROD backups to DEV/QA/UAT environments scripting out all the users and their permissions and role s. as per the requests of application teams

Environment: MS SQL Server 2005/2000, ERWIN, SQL Server Configuration Manager, Query Analyzer, Database Tuning Advisor, Index Tuning Wizard (ITW SQL Server 2000).