Sr Sql Server Dba L3 Support Resume
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.