We provide IT Staff Augmentation Services!

Sr Sql Server Dba L3 Support Resume

0/5 (Submit Your Rating)

Los Angeles, CA

PROFESSIONAL SUMMARY:

  • SQL Server Certified with 8+ years of experience as a SQL Server DBA in the analysis, design, and maintenance of Database systems in the Client Server environment on version 2014/2012/2008/ R 2/2005/2000.
  • Troubleshooting SQL Server performance issues and train staff on areas for improvement in code, storage, indexes, and configuration.
  • Managing and monitoring around 600+ Virtualized SQL Server.
  • Bottleneck analysis on database and application and identify and resolve the issues.
  • Have configured and implemented High availability and disaster recovery in company’s SQL Servers using Always On, Database Replication and log shipping
  • Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server
  • Data migration between homogenous and heterogeneous system using various tools like Data Transformation Services (DTS), SSIS, BCP, Bulk Insert.
  • Develop system documentation for Encryption and data loss prevention.
  • Develop operational and installation procedures for SQL Server encryption, databases, s, backups and recovery and data loss prevention.
  • Enterprise Manager, Management Studio, Query Analyzer, Extended Events, SQL Server Profiler, SQL Server Agent, Business intelligent Studio.
  • Implemented SQL server Always On, SQL Server clustering, Mirroring & log shipping.
  • Experience in Normalization, Performance Tuning, Disaster Recovery and Data Archiving.
  • Experience with T - SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
  • Extensive experience with data modeling, logical and physical database design.
  • Experience in Deploying SQL Scripts to update and deploy databases.
  • Experience with Analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
  • Strong knowledge and experience in SQL Server disaster recovery, backup/restore, migration and upgrade.
  • Strong skills using Microsoft Integration Service and Reporting Services with Business Intelligence Development Studio.
  • Deliver presentations and webcasts to my peers and juniors on a variety of database topics.
  • Worked as IT coordinator for Onshore/offshore 24x7 (6 members team), which earned me good experience in managing/ documenting every piece for long term stability share easy.
  • Hands on Experience on Change Data Capture an Enterprise Feature of SQL Server.
  • Monitoring of Autosys jobs configured using SQL Server Agent, Alerts, and Operators.
  • Received an for Completing SQL/TFS migration from 2005 version to 2012 both SQL server and TFS Server
  • Industry working experience in SQL Server database management, maintenance, performance tuning, and troubleshooting.
  • Strong Hold on ITIL Process and Concepts Using Remedy Management tools Like CA Service desk and BMC Remedy.
  • SQL Server Migration Specialist which includes Side by Side and IN place SQL Server Migration on Cloud and Virtual Environment.
  • Hands on experience on Oracle and MySQL.
  • Around 15 months of Experience on Cloud Platforms like AWS and Microsoft Azure.

TECHNICAL SKILLS:

Operating Systems & DBMS: Proficient with WINDOWS WIN 2000, 2003, 2008, 2008R2, 2012, Windows azure 2012and Ubuntu Linux 15.XX. Good knowledge about the SQL Server 2000/2005/2008/2008 R2/2012/2014, MYSQL, SharePoint 2010, Team Foundation Server 2008/2010/2012 , Oracle 12c. Data warehousing using DTS tools, SSAS,SSRS, SSIS, and Oracle Golden Gate, DB Forge, Navicat, ApexSQlSuite. Proficient with IIS Setup.

Programming Language and Package: C, C#.Net, T-SQL.

Areas of Interest: Data Base Management System & Server Management & Cloud Computing.

Tools: BMC Service desk, CA Service Desk, Spotlight, Foglight, Red gate 5.0, Sanvoi, OP manager, IDERA, NetApp Manager, Light speed

PROFESSIONAL EXPERIENCE:

Confidential (Los Angeles, CA)

Sr SQL Server DBA L3 Support

Responsibilities:

  • Supporting servers in the Dev/ QA/UAT/Prod environment for SQL Server 2014, 2012, 2008 R2, 2008, 2005 and 2000 Databases.
  • Installation of SQL Server 2008 R2, 2012, 2014 and Implementing Fox standards.
  • SQL Server migration - Migration of SQL server from 2000, 2005, 2008 to SQL server 2008R 2/2012/2014.
  • Installation of Client Software Oracle, Netezza, MySQL, DB2 and NoSQL.
  • Creating and Maintaining Linked Server
  • Creating User logins & permission on Instance and Databases.
  • Import & Export Data using SSIS and Import Export Wizard.
  • Migrating SSRS and SSIS Packages in Co-ordination with Application Developers.
  • Configuring SQL Replication, Log shipping, Database Mirroring, Always on and SQL clustering on Windows Platform involved in Migration and day to day Operations.
  • Implementation and Configuration of DR Site Solution.
  • Performance optimization and tuning of SQL server database.
  • Capacity Planning and SQL Resource Management Implementation on Windows Platform.
  • Implementation of Consolidation of SQL server.
  • Installation, Configuration, Backup and Recovery of Microsoft SQL Server 2000, 2005, 2008R2, 2012, 2014.
  • Configuring and Managing and Deploying SSAS, SSRS, SSIS Cubes, Reports and Packages.
  • Configured and Deployed Light Speed for SQL Compressed backup.
  • Handling of Day to Operations Tasks Using Service Now.
  • Index Rebuild and Re-Organize as Per Microsoft Recommendation.

Confidential (Fresno, CA)

SQL Server DBA-III

Responsibilities:

  • Supporting servers in the Dev/ UAT/Prod environment for SQL Server 2014, 2012, 2008 R2, 2008 and 2005 Databases.
  • Configured DB mirroring with Automatic Fail over on SQL Server 2012.
  • Configured Always ON Availability Group on SQL Server 2012.
  • Deployment of SQL DB and project codes using TFS Server 2005/ 2008/2010/2012 .
  • Configuring Log shipping for database in Dev/ SIT/ UAT/Prod environment
  • Implement SQL Server Database Mirroring with Automatic Failover using SQL server 2012
  • Monitoring the Database Server's Health and Tuning and using Profiler whenever required.
  • Working on the Indexes of tables.
  • Using Orion Tool for monitoring SQL Server Landscape of 50+ SQL Server platform.
  • Managing Access Permissions to users on SQL database Servers.
  • Maintaining IIS and Supporting windows Server as per SQL server dependent request.
  • Provides communication to the customer for Service Request
  • Assesses stalled Incident and Service Request and takes appropriate Action to move them through the process.
  • Ensures misrouted cases are trapped and assigned to correct support workgroups.
  • Complete Service Request as per the Service Level Agreement.
  • Daily Maintenance of SQL Servers included reviewing SQL error logs, Event Viewer.
  • SQL Server migration - Migration of SQL server from 2005 to SQL server 2008/2008R2/2012 on Cloud Platform including Amazon and Microsoft Azure.
  • Assisting developers to Optimize Query.
  • Creating and Maintaining Linked Server
  • Create user logins & permission
  • Import & Export Data.
  • Implementation and Configuration of DR Site Solution
  • SSRS site Management for Reports hosted on Production environment.
  • Configuring and Managing and Deploying SSRS, SSIS Reports and Packages.
  • Performance optimization and tuning of SQL server database.
  • Installation, configuration of MYSQL on Ubuntu Server.
  • Administration of MYSQL Server.
  • Done Side by Side Migration from SQL server 2008 to SQL server 2012 on Windows Azure 2012 with Total DB size of around 450 GB.
  • Full Development of SSRS & SSAS Reports as per Requirement.
  • Implementation, Configuration, Deployment and Supporting of SSRS, SSIS, SSAS Components from SQL Server BIDS.
  • SSAS Backup, Restore and Security Configuration using XMLA and GUI for Data warehousing Projects.
  • Hands on Experience of MYSQL And Oracle 12c on Ubuntu 14.04
  • Setting Replication for MYSQL 5.6
  • Patching of MYSQL servers.

Environment: Amazon Cloud,AzureCloud Windows 2012/ 2008/2003/2000 , Ubuntu14.02, MS-SQL Server 2012/ 2008/2005/2000 , SSIS, SSRS, SSAS System Monitor / Performance Monitor, MYSQL.

Confidential (Bakersfield, CA)

Sr. SQL Server DBA

Responsibilities:

  • Supporting servers in the Dev/ UAT/Prod environment for SQL Server 2012, 2008 R2, 2008 and 2005 Databases.
  • Deployment of SQL DB and project codes using TFS Server 2005/ 2008/2010/2012 .
  • Configuring Log shipping for database in Dev/ SIT/ UAT/Prod environment
  • Implement SQL Server Failover Clustering for High Availability production server
  • Monitoring the Database Server's Health and Tuning and using Profiler whenever required.
  • Working on the Indexes of tables.
  • Using Idera Tool for monitoring SQL Server Landscape of 600+ SQL Server platform.
  • Managing Access Permissions to users on SQL database Servers.
  • Maintaining IIS and Supporting windows Server as per SQL server dependent request.
  • Provides communication to the customer for Service Request
  • Assesses stalled Incident and Service Request and takes appropriate Action to move them through the process.
  • Ensures misrouted cases are trapped and assigned to correct support workgroups.
  • Complete Service Request as per the Service Level Agreement.
  • Daily Maintenance of SQL Servers included reviewing SQL error logs, Event Viewer.
  • SQL Server migration - Migration of SQL server from 2005 to SQL server 2008/2008R2/2012
  • Assisting developers to Optimize Query.
  • Creating and Maintaining Linked Server
  • Create user logins & permission
  • Import & Export Data.
  • Implementation and Configuration of DR Site Solution
  • Working in Agile Methodology with various projects within Confidential SJVBU.
  • Configuring and Managing and Deploying SSRS, SSIS Reports and Packages.
  • Performance optimization and tuning of SQL server database.
  • Implementing of Change Data Capture and Enterprise Feature of SQL server for auditing the SQL Tables.

Environment: Windows 2012/ 2008/2003/2000 , MS-SQL Server 2012/ 2008/2005/2000 , SSIS, SSRS, System Monitor / Performance Monitor, Oracle 11g, Idera .

Confidential (Monroe, NC)

Sr. SQL Server DBA

Responsibilities:

  • Implemented 2 SQL Server 2008 R2 two node cluster in virtual environment as per client requirement.
  • Implemented the Oracle Golden gate for Data replication from Oracle 11g server to SQL Server.
  • Documented the data flow diagram using the Microsoft Visio.
  • Migrated from SQL Server 2000 to Server 2008 r2 using side by side migration technique.
  • Migrated SQL server 2000 DTS to SQL Server 2005 and above into SSIS packages in co ordination with development team.
  • Documented the SQL server Inventory.
  • Configured updateable transactional replication for implementing data staging SQL Server.
  • Implemented the Back plan for All SQL Server and configured the Alerts to the client using SQL DB Mail.
  • Planned and updated the SQL Server patches accordingly.
  • Maintained the SQL Server Access list accordingly.
  • Implemented Standard SQL practices for the Performance tuning.
  • Implemented and configured the entire ATI Landscape on OPMANAGER Monitoring tool.
  • Supporting servers in the Dev/ SIT/ UAT/Prod environment for SQL Server 2012, SQL Server 2008 R2, SQL Server 2008 and SQL Server 2005 Databases.

Environment: Windows 2008/2003/2000 , MS-SQL Server 2008/2005/2000 , SSIS, SSRS, System Monitor / Performance Monitor, Oracle 11g, HP OPManager.

Confidential

Responsibilities:

  • Supporting servers in the Dev/ SIT/ UAT/Prod environment for SQL Server 2012, SQL Server 2008 R2, SQL Server 2008 and SQL Server 2005 Databases.
  • Performance optimization and tuning of SQL server database.
  • Configuring Log shipping for database in Dev/ SIT/ UAT/Prod environment
  • Implement SQL Server Failover Clustering for High Availability UAT & production server
  • Monitoring the Database Server's Health and Tuning and using Profiler whenever required.
  • Working on the Indexes of tables.
  • Using SQL Fog light, SQL Spot light, and Sanvoi Tools for Monitoring.
  • Smoke Testing the Database once password change activity is done
  • Assigning Access Permissions to users on SQL databases
  • Providing access to Share folder
  • Provides communication to the customer for Service Request
  • Assesses stalled Incident and Service Request and takes appropriate
  • Action to move them through the process
  • Ensures misrouted cases are trapped and assigned to correct support workgroups
  • Assess all escalated Incident and Service Request and provide the direction and communication
  • Needed to resolve the Incident and Service Request quickly and efficiently as possible.
  • Complete Service Request as per the Service Level Agreement
  • Daily Maintenance of SQL Servers included reviewing SQL error logs, Event Viewer.
  • Data migration - Migration of SQL server from 2005 to SQL server 2008/2008R2
  • Query Optimization
  • Linked Server
  • Table Partitioning
  • Database Normalization
  • Create user logins & permission
  • Import & Export Data
  • Preparing POA and conducting POC as per the requirement and Documentation as per ISO Standards.

Environment: Windows 2012/ 2008/2003/2000 , MS-SQL Server 2008/2005/2000 , SSIS, SSRS, System Monitor

Confidential

SQL Server DBA

Responsibilities:

  • Data Exporting and Importing (One server to other server) using DTS tools.
  • Implement database design solution in collaboration with programming team
  • Designed and maintained project databases using SQL ensured accuracy of information and automated functions.
  • Managing indexes and Performance problems.
  • Installation and configuration the SQL Servers
  • Implementation and uploading of data on SQL SERVER
  • Data migration - Migration of SQL server from 2000 to SQL server 2005
  • To check it out the Backup of the databases. Restore the databases as per requirement.
  • To setup the Backup plans and create the jobs and schedule the jobs.
  • Monitoring database growth.
  • Replication and Integrity - To create the Replication between the two servers and transferred the data using replication between two servers.
  • Developed utility programs for SQL (Query’s, Store Procedures, Triggers, Views)
  • Communication with client to ensure end user information discrepancies resolved.
  • To optimize the queries using the Execution plan.
  • Retrieving data as per the client requests and maintaining the log of data

Environment: Windows 2008/2003/2000 , MS-SQL Server 2008/2005/2000 , SSIS, SSRS, System Monitor / Performance Monitor.

Confidential

Jr SQL Server DBA

Responsibilities:

  • Installation of SQL server versions and Configuring the Application with the Databases
  • Data Exporting and Importing- Upload the new data in DB and managing productivity report.
  • Data Extraction as per client requirement- Processed data can extracted from DB and Send the data to client. Backup activity And Maintaining the DB
  • Updating Scripts according to Requirements.
  • Checking the status whether the backup done or not according to Check list.

Environment: Windows 2003/2000, MS-SQL Server 2005/2000, SSIS, SSRS, System Monitor / Performance Monitor.

We'd love your feedback!