SUMMARY:

An experienced Senior SQL Server DBA with over 16 years of experience with SQL Server. Have worked at a number of companies in different lines of business, include Toyota, Confidential, Kaisar Permanante, Honeywell, StateStreet and Viewpointe. I have been part of DBA teams providing SQL Server production support and for projects to upgrade and migrate SQL Servers. I have supported SQL Servers from SQL Server 2000 to SQL Server 2016. I have supported servers with small to medium sized database to large terabyte sized databases. Standalone servers on as well as SQL Server clusters with Database availability groups setup. I have supported replication, logshipping and mirroring. Database as a service and Infrastructure as a service with Azure and AWS.

TECHNICAL SKILLS:

Operating Systems: Windows 2003 Servers, Windows 2008 R2, Windows 2010, UNIX, Linux.

Databases: SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQLServer 2012. SQL Server 2014, SQL Server 2016, SQLBase 7.6 - 8.0, Oracle9, Oracle 10g, MongoDB.

Tools: and Packages used SSIS, SSRS, SSAS, Advantage Data Transformer 3.1, TFS, IIS, Remedy, Quest light speed, Red gate backup, SQL Monitor. TDP, VERITAS Net Backup.

Programming Languages: T-SQL, PL/SQL, SQL, Vb script, XML,Window power shell.

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server DBA Contractor

Responsibilities:

• As a contractor working for Confidential through Confidential I have been part of multiple teams of SQL Server DBAs providing production support to companies in fields like healthcare, insurance, banking and manufacturing with different large and small enterprise environments.
• Companies supported included Kaiser Permanante, Honeywell, StateStreet and Viewpointe. SQL Servers supported include SQL Server 2005 through 2016, Azure VM and AWS EC2 server.
• Supported clustered servers and standalone servers with log shipping, mirroring and high availability database groups.
• As part of these different teams I have installed, configured and upgraded SQL Servers in clustered and standalone environments.
• I have Installed patches and service packs. Setup maintenance plans.
• Configured log shipping, mirroring, availability groups and replication.
• Trouble shoot production issues.
• Done application schema deployments, query performance tuning, indexes, data fixes and adhoc reporting. Creating, deploying and scheduling SSRS reports and SSIS packages.
• Backups and restores using native SQL backups as well as using tape backup options. Database migrations and DR testing.
• I have worked as a technical team lead for more than 3 years and was responsible for dispatching work to my team members and keeping track of work assigned to the team members.
• I worked on incident and change tickets as well as conducted meetings for my team and represented my team in meetings with customers to discuss progress on projects and status of different change and incident tickets.
• I have also led projects to upgrade servers from SQL Server 2005 and 2008 to 2012 and 2014.
• Also upgraded servers from 2008 and 2012 to Azure VM machines.

Confidential

SQL Server DBA

Responsibilities:

• Created standards for SQL Server Servers installation, configuration and maintenance, installing configuring servers as per standard.
• Setting up backup and other maintenance tasks.
• Created SSIS packages and SSRS reports.
• Setup mirroring and log shipping.
• Was also backup support person for Kronos version 6.1.5.
• Developed around 30 SSRS report used by the Kronos users.
• Also got training as Oracle DBA and participated in some activities which related to Oracle applications.

Confidential

DEV/OP SQL Server DBA

Responsibilities:

• Administered over 150 SQL Server 6.5, SQL Server 7.0, SQL Server 2000 and SQL Server 2005 mission critical productions servers and data warehouse.
• Installed and configured all new SQL Server servers, Reporting services Server, SSIS and Analysis servers on regular standalone servers and on cluster servers.
• I was also responsible for upgrade of SQL Server servers and for installing service packs for SQL Server servers.
• Also installed, upgraded for SQL Base servers and Advantage Data Transformer server.
• Gave input on infrastructure and hardware requirements and capacity planning on projects using MS SQL Server Databases.
• Set up test and production environments for new production applications. Responsible for moving database changes to production.
• Planned and documented the DR policy and regular backups and the maintenance of the databases.
• Created linked servers, created, deployed and scheduled Confidential and SSIS packages and jobs.
• Performance tuning, setup SQL Mail, Database Mail, maintained permissions. Created stored procedures and Triggers. Importing and exporting data and database objects.
• Set up replication and monitoring it.
• Creating SSIS packages and scripts for Advantage Data Transfer (ETL tool by CA) used for moving and transforming data between different sources including SQL Server databases, Oracle database, DB2 databases, Mainframe, text files etc.

Confidential

SQL Server DBA

Responsibilities:

• Performed SQL DBA role for multiple clients.
• Administered SQL Server 7.0 production Databases in a Windows 2000 cluster environment.
• Responsible for the backup, restore, database tuning and setting up and monitoring the replication of databases on multiple servers.
• Monitored the import process which got data from multiple sources including Oracle Database and text files using Confidential packages and linked servers.
• Import process uses stored procedures for processing data before inserting records into the databases.
• Data modeling and writing stored procedures and triggers for multiple Databases.
• Helping developers with database problems.
• Developed Backup and Restore Procedures, Included Testing and implementing Full, Differential and Transaction log backups.
• Documenting backup and recovery procedures.
• Creating and maintaining Linked Servers.
• Creating and scheduling Confidential packages.
• Creating and scheduling jobs.
• Scheduling and monitoring DBCC checks on production databases.
• Setting up SQL Mail. Performance tuning. Setting up security.
• Installing Service Packs.
• Setting up and monitoring replication.
• Upgrading SQL Servers to the newer versions.