We provide IT Staff Augmentation Services!

Sql Server Dba Resume

NY

SUMMARY:

  • Database administrator with six plus years of experience managing SQL Server in Production, Testing and Development Environments
  • Expert in installation, applying Service pack, Cumulative update, upgrade, migrate and configuration of SQL server in clustered and non - clustered environments
  • Worked on upgrading SQL Server 2005 /2008 R2 /2012R2/2014/2016
  • Experience in managing SQL server security, controlling the user privileges, monitoring audit issues
  • Experience with configuration, implementation and maintenance for Disaster Recovery/High Availability solutions using Log shipping, Mirroring, Replication, Failover cluster(Active-Active/Active-Passive) and Always On Availability Groups
  • Experience in data migration between the two environments with SSIS and Import, Export wizard
  • Designed data partitioning solutions for tables and indexes for risk monitoring and control
  • Strong Experience in creating jobs, Alerts and Scheduling SSIS Packages
  • Troubleshoot performance problems, fine-tuning of databases and index Analysis
  • Experience in maintenance plans to perform index de-fragmentation, reorganize index, rebuild index, and update the index statistics.
  • Expertise in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics.
  • Experience in developing and managing Stored Procedures, Triggers, Indexes, Views
  • Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks
  • Strong experience in mentoring team members and writing documentation
  • 24 X 7 Production Database on Call Support

TECHNICAL SKILLS:

Operating Systems: Windows Server 2003/2008 R2/2012, ESXi 5.5.0. ESXi 6.0

RDBMS: MS SQL Server 2016/2014/2012/2008 R2/2005

Languages: T-SQL

Reporting Tools: SSRS, Crystal Report

ETL Tool: SSIS

Backup Tools: RedGate, Idera/SQLSafe, Lite Speed

Monitoring Tools: RedGate, SCOM

Data Modeling: SQL Server Database Diagram, VISIO

Network Topologies: TCP/IP, DNS, DHCP.

Other Tools: ServiceNow, JIRA, Remedy Ticketing System.

PROFESSIONAL EXPERIENCE:

Confidential, NY

SQL Server DBA

Responsibilities:

  • Installed Configured, and Managed SQL Server 2016 / 2014 / 2012 and migrated databases from SQL Server 2008R2/2005.
  • Configured and Maintained Active/Passive Windows Failover Cluster with SQL Server 2012 R2.
  • Configured and maintained transactional and peer-to-peer replication and troubleshoot replication issues.
  • Configured and administered Always On Availability Group.
  • Designed and Deployed SSIS Packages to Export and Import Data from various Databases and Files.
  • Performed Database Backup and Point-In-Time Recovery solutions using SQL Server Client and Quest LiteSpeed.
  • Managed security and permission of SQL Server.
  • Involved in capacity planning and monitoring data/log files size, growth and disk space.
  • Created Database Objects like Stored Procedures, functions, Views, Triggers.
  • Managed index usage and fragmentation and updated statistics in databases.
  • Involved in troubleshooting and fine-tuning database performance and concurrency and root cause analysis.
  • Worked on Query optimization and tuning using SQL Server Profiler, Database Engine Tuning advisor, and Activity Monitor and analyzing execution plan.
  • Checked Database Health by using DBCC Commands and DMVS.
  • Enforced Policy Based Management at Database Level as well as Table Level.
  • Translated business requirements into technical design specifications and actively supported business users for change requests.
  • Provided 24/7 on call support for all the Production Servers .

Environment: MS SQL Server 2016/2012/2008 R2/2005,Windows Clustering, Replication, Always on AG, Windows Server 2008R2 and Windows Server 2003, Red Hat Linux 6, .Net Framework, C#.Net, JavaScript, MS TFS, MS-Access, SharePoint 2010, Oracle 10g, Lite Speed. SCOM, Service Now.

Confidential, Bethesda, MD

SQL server DBA

Responsibilities:

  • Installed, configured SQL Server 2012 and 2008 R2.
  • Experience Upgrading SQL Server 2005/2008r2 and 2012R2.
  • Configured and maintained SQL Server High Availability solution such as Replication, Log Shipping and Mirroring.
  • Perform SQL Server service pack and Windows Service pack upgrades.
  • Rebuilding the indexes at regular intervals for better performance.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
  • Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Transferring the data from excel to SQL Server 2005 & SQL Server 2008 through SSIS package.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
  • Perform advanced system diagnostics, debugging and performance analysis. Create reports on all activities and generate solutions.
  • Provide 24x7 production support for SQL Server databases on Clustered Servers to achieve maximum performance and uptime in production environment.

Environment: SQL Server 2005/2008R2 and 2012R2, SharePoint2007/2010, Windows Server 2003/2008 and 2012, RedGate, JIRA.

Confidential, Warren, NJ

SQL Server DBA

Responsibilities:

  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users
  • Technical trouble shooting and give consultation to development teams.
  • Developed, monitor, and maintain backup and recovery for all assigned databases to include the appropriate transaction logging.
  • Monitoring High availability Solutions of the SQL Server Databases.
  • Responsible to Monitor and troubleshooting Log Shipping.
  • Setting up and Monitored transactional replication, Database mirroring on Production.
  • Participate in implementation of new releases into production.
  • Used Stored Procedures, DTS packages, BCP for updating Servers.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
  • Applied table partitioning to improve I/O access.
  • Tuning queries which are running slow using Profiler and Statistics by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications
  • Monitored and modified Performance using execution plans and Index tuning.
  • Tested and Implemented procedures to detect poor database performance, collecting required information, and root cause analysis.
  • Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.

Environment: MS SQL Server 2005 & 2008, T-SQL, DTS, SSIS, BCP, Windows 2003/2008 Server

Hire Now