Ms-sql Dba Resume
Irving, TX
SUMMARY:
- Over 9+ years of IT expertise of SQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000 Database Administration, Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server, performance tuning, client/server connectivity, query optimization and back - up/recovery, Disaster recovery procedures, Database Consistency Checks using DBCC.
- Highly experienced in Database Maintenance plans, scheduling of jobs and alerts and Notifications using Database Mail, SSIS packages.
- Expertise in providing high availability support for SQL Server: Always on availability groups, Database Mirroring, Log Shipping and Replication.
- Hands on experience in system security, managing user logins, granting access roles and creating services account
- Responsible for Tuning Complex SQL Queries and Stored Procedures to increase Performance.
- Involved in Integration/System Testing and Backup/Restore Testing for all components.
- Solid Testing experience in working with SQL Stored Procedures, Triggers and Views. Also worked with Performance Tuning of Complex SQL queries.
- Created linked servers between SQL Server 2005 and 2008, 2008R2 and 2012.
- Migrated servers from 2005 to 2012, 2008 to 2012 & 2014 with In-place and Side-by-Side Processes
- Installed, Configured, managed security for SSIS, SSAS, and SSRS (2008 R2, 2012 &2014).
- Creating SSIS packages to load data across different servers.
- Good in monitoring Event viewer and SQL Error logs for Software and hardware related errors.
- Daily routine Developer/DBA tasks like handling user's permissions, monitoring Blocking, Deadlocks, Long running jobs, and space issues on Production and Semi-Production servers and handling maintenance jobs.
- Good Knowledge of generating reports using SQL Server reporting services and deploying them on various applications on to the web servers.
- Excellent communication skills, self-managing and teamwork spirits in multicultural environment
- On Call 24X7 supports, Request Queue, Daily Maintenance and Application Support.
TECHNICAL SKILLS:
Programming Languages: Visual studio 2012/2010/2008, .net, Java, Linux
Databases: SQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000, SQL Azure-Microsoft Cloud Database Services
High Availability options: Clustering, Mirroring, AG Groups, Replication, Log Shipping
Network Topologies: Standalone, Dedicated, Physical/Virtual Machines, Windows Clustering
Microsoft / SQL Tools: SQL Profiler, Database Engine Tuning Advisor, Import/Export wizard, Query analyzer, SQL Agent, DTS, SSIS, SSRS, Database Mail, SQL Server Management studio, T-sql, Powershell, Dataware house, DML, DDL, DCL
Operating Systems: Windows 7/2000/XP/2003, MSI Mode(Command line mode)
Third party tools: Fog light, Quest Lite speed, Idera SQL Check, SQL Sentry, Embarcadero UC4 Job Scheduler, Embarcadero DB Artisan, Tivoli Storage Manager, Service now, IBM Lotus Notes, JIRA
PROFESSIONAL EXPERIENCE:
Confidential, Irving, TX
MS-SQL DBA
Responsibilities:
- Maintaining SQL Server instances which include Primary Database Maintenance, Performance Tuning and support.
- Optimize database queries as per the request from the Application Team.
- Performed database backups on a regular basis to allow for Database Recovery.
- Assisted the app team in periodic purging of old data from databases and maintaining the archive database.
- Daily tasks like handling Security and space issues on Production and Semi-Production Servers, maintenance Jobs.
- Successfully migrated from SQL server 2008 to SQL server 2012 and SQL Server 2014.
- Successfully setup Always on availability groups which were migrated to 2012.
- Assist development team to Run and analyze transformation jobs using Microsoft SSIS
- Regular monitoring of SQL Server agent jobs and providing logs/event logs in case of any issues.
- Good expertise on created Databases on Azure SQL Server and Migrated On-Premise development databases to Azure SQL.
- • Setting up High availability | DR solutions over Azure.
- • Configured Azure SQL Server Firewall for Performance Tuning.
- • Migrated the development SQL Server Schema to the new AWS RDS.
- • Used Cloud watch for basic and detailed monitoring of AWS resources.
- Assisted development team with any queries pertaining to Sql Server Integration Services.
- Routine DBA tasks like handling Security and space issues on Production and Semi-Production Servers, maintenance Jobs.
- Monitoring Memory, CPU, IO, Blocking via SQL Check.
- Actively participated in weekly team meetings and discussing the database/server issue.
Environment: MS SQL Server 2014/2012/2008 R2, Windows 2003/2008 /2010 Enterprise Edition, SQL Server Management Studio, Always on availability groups, Mirroring, Indexing, Java, .Net, SQL Check, SQL Profiler, SSIS deployments, SQL Server Agent, Tuning Advisor, Java, .NET.
Confidential, Richardson, TX
SQL Server DBA
Responsibilities:
- Installing and maintaining SQL Server Databases which are not limited to ensuring successful backups, resolving system/database issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
- 24*7 on-call support.
- Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
- Coordinating with the Systems Administration/Network team pertaining to any system, network related issues.
- Extensively involved in setting up Database Replication - SNAPSHOT.
- Support and maintenance of Transactional Replication between Primary Servers and Read-Write servers, and experience in troubleshooting replication problems.
- Administrate security for server logins (Windows and SQL Accounts).
- Periodic creation of objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008 R2.
- Worked in Active Active, Active Passive Cluster environment as a High availability solution.
- Periodic monitoring of Database Health by using Consistency Check Commands and DMVS
- Good experience in pulling out PERFORMANCE Reports using FOGLIGHT tool
- Monitored and modified Performance using execution plans and Tuning the Index’s as per requirement.
- Worked on deploying SSIS packages and jobs to QA and prod.
- Daily routine DBA tasks like handling Security and space issues on Production and Semi-Production Servers, maintenance Jobs.
- Handled periodical Database Refresh in QA-Test environment for testing new Deployments and Build using TSM (Tivoli Storage Manager) backups.
- Experience in connecting to remote SQL Server as Linked Servers and support Development Team in deploying and testing the application, which uses SQL Server backend.
- Responsible for providing daily and weekly reports to the immediate supervisor and actively involved in weekly meetings to discuss project status.
- Very proficient in troubleshooting replication related issues.
- Document, and promote security "Best Practices", policies, standards and protocols.
Environment: MS SQL Server 2008 R2, Windows 2003/2008 Enterprise Edition, SQL Server Management Studio, Snapshot replication, Mirroring, Java, SQL Profiler, SSIS deployments, SQL Server Agent, database engine tuning Advisor, Quest LITESPEED, FOGLIGHT from DELL
Confidential, Austin, TX
SQL DBA
Responsibilities:
- Successfully implemented SQL Server Migration from 2008 to 2012 side by side.
- Extensively involved in setting up Always on availability groups and Database Mirroring.
- Daily routine DBA tasks like which included Periodic refreshes from prod to test and dev environments, handling Security and space issues, ensuring maintenance Jobs are running successfully according to the schedules, assisting development team in creating and automating SQL agent jobs.
- Document, and promote security "best practices", policies, standards and protocols.
- Provided daily & weekly status to the immediate supervisor and actively involved in weekly meetings to discuss project status and provided reports.
Environment: MS SQL Server 2012/2008/2005, Windows 2003/2008 Enterprise Edition, SQL Server Management Studio, Always on availability groups, .net, SQL Profiler, SQL Server Agent, Indexing, Tuning Advisor.
Confidential, Austin, TX
SQL Server DBA
Responsibilities:
- Intensively worked on archiving old data from production systems.
- Verified, maintained and created automated procedure for daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing updates and compression of databases.
- Experience in working with private party tool UC4 for scheduling daily/weekly jobs.
- Experience in deploying Database/Application/Web servers using In house tool - Final Builder.
- Migrating application code and objects from development/test environments to production.
- Successfully upgraded SQL Server 2008 to SQL Server 2012.
- Extensively involved in setting up Database Mirroring with always on availability with SQL Server 2012.
- Support and maintenance of Transactional Replication between Primary Servers and Read-Write servers, and experience in troubleshooting replication problems.
- Assigned permissions to user(s), role(s), and object. Support column level permission. Administrate security for server logins (Windows and SQL Accounts).
- Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005/2008/2012.
- Worked in Active Active, Active Passive Cluster environment as a High availability solution.
- Regular monitoring of Database Health by using Consistency Check Commands and DMVS
- Monitored and modified Performance using execution plans and Tuning the Index’s as per requirement.
- Participated in 24*7 production on call support
- Prepared Documentation for the Disaster Recovery plan
- Worked on deploying SSIS packages and jobs to QA and prod and worked on environment set up for the packages to run on QA and Prod
- Daily routine DBA tasks like handling Security and space issues on Production and Semi-Production Servers, maintenance Jobs.
- Handled periodical Database Refresh in QA-Test environment for testing new Deployments and built linked server linked servers
- Good at connecting to Linked servers and helping application team in resolving any issues.
- Provided daily & weekly status to the immediate supervisor and actively involved in weekly meetings to discuss project status and provided reports.
- Experience in using an In-house tool - Embarcadero DB Artisan for monitoring blocking & locks.
- Proficient in troubleshooting any issues that are relate to Replication.
- Document, and promote security "best practices", policies, standards and protocols.
Environment: MS SQL Server 2012/2008 R2/2008/2005, Windows 2003/2008 Enterprise Edition, SQL Server Management Studio, Always on availability groups, Mirroring, Transactional replication, Java, .net, SQL Profiler, SQL Sentry, SSIS, IIS Server, SQL Server Agent, Database engine tuning advisor, Embarcadero DB Artisan, UC4, Visio, Final Builder.
Confidential, East Windsor, NJ
SQL Server Administrator
Responsibilities:
- Installed SQL Server 2008 in Production, Test and Development environments
- Provided technical support for the database environment including overseeing the development and organization of the databases, assessment and implementation of new technologies
- Designed and implemented database changes.
- Reviewed and tune up SQL queries, Stored Procedures, Views, and Triggers.
- Worked with architecture, application development and operations to help achieve a state-of-the-art environment that meets current and future business objectives
- Provide and design tools to assist in the management of the database and transaction processing environment
- Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL Server 2000, MS SQL Server 2005 databases.
- Help in-house developers improve performance of their stored procedures and TSQL codes
- Managed health of SQL Servers including backups, restores, monitoring
- Develop a security scheme for the database environment, as well as assisting in disaster recovery if necessary.
- Provided technical support during the development and enhancement of production databases, technical support and operations during the design, development and implementation of databases.
- Worked with the Transaction processing area to develop both the physical and the logical database administrations functions
- Provided support for developers in developing SQL queries.
- Managed administrative work through Automatic Script, performing Daily/Weekly Backups.
- Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler/ SQL Analyzer
Environment: MS SQL Server 2008 R 2/2008/2005/ 2000, SQL Server Management Studio, .NET
Confidential
SQL Database Administrator
Responsibilities:
- Carried out a Database administrator’s role on MS SQL Server 2005, MS SQL Server 2000
- Managed the security of the servers as a part of administration duties.
- Created and automated regular Jobs such as Daily/Weekly Report Generations.
- Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon.
- Managed and Monitored System Utilization.
- Managed Backup and Disaster Recovery of the systems.
Environment: Windows XP/NT, MS SQL Server 2005, MS SQL Server 2000, SQL Server Enterprise Manager, Microsoft.