SQL Server Database Administrator Resume Andover, Connecticut - Hire IT People

SUMMARY:

Seasoned SQL Server database administrator with over 5 years of Strong Experience with SQL Server 2000 through 2016 Administration. Production support in a 24/7 environment and project support. Interacts with clients, application team and project managers to design, implement and support solutions to meet client needs. Install and Upgrade SQL Server 2008, 2012 and 2014 database standalone / cluster instances, Service packs, Complex database environmentsProduction, Test and Development Environments

SKILLS:

Environment: Databases: Virtualization tools (VMware), SQL Server 2017/2016/2014/2012/2008 R2 Enterprise, Windows Enterprise Server 2012/2008R2, T - SQL, SSIS, SSRS, Tools BCP, Import and Export Wizard, Profiler, DTS, SQL Diagnostic Manager, Microsoft Office (Word, Excel, Power Point, Outlook, Access)

PROFESSIONAL EXPERIENCE:

Confidential, Andover, Connecticut

SQL Server Database Administrator

Responsibilities:

Production level support for onsite and offshore Clients
System monitoring
Integrated Temporal Tables
Troubleshooting client connectivity
Lock resolution.
SQL Server Performance Dashboard Reports for Monitoring
Performance Baselining And Query tuning and optimization
Manage indexes to improve performance
Schedule jobs using SQL Server Agent
Developed routine jobs for data integrity check
Code deployment into Production
Information Risk Management Control
Tables Design, views, Stored procedures, Function etc.
Managing Server and database security and identity
Managing Firewall Rule, Triger, Row version, Temporal Tables, Change Data Capture (CDC) etc.
Column Store Index for performance
Contained Databases
Task Automation
Monitoring And Re - indexing of databases
Stabilized Performance
SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA) for performance
Implementation of snapshot isolation and DDL triggers
SQL Azure
Comprehensive Backup plan and disaster recovery strategies
Installed SQL Server 2008 on advanced servers, applied security fixes
SQL Server Upgrade
Installed and configured MS SQL Server 2008 R2, supported all Production and development servers
Maintained database response times in 24X7 Production environments Developing SQL scripts for maintaining administration tasks
SSIS, high performance data integration solutions, ETL packages
SQL server Reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draws content from a variety of data sources.
Capacity Planning and resource allocation
Monitoring standby databases to ensure high availability

Confidential

SQL Server Database Administrator

Responsibilities:

Upgrading SQL 2008 to 2016 in our environment
Setting up always on, replication and database mirroring
Database migration to Azure
Windows and SQL patching
Reviewing and optimizing VMWare environment
Reviewing and optimizing storage
Responding to ticket queue (refreshing databases, creating logins and users)
Performed all day - to-day aspects of MS SQL database administration.
Responsibilities include database design, installation, security, managing users and logins, performance. monitoring and tuning, database availability, backup and recovery, troubleshooting and problem resolution.
Configured High Availability Solution - Always On Cluster, Traditional Failover
Clustering, Database Mirroring and Log Shipping.
Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical database. Creating and Modifying Tables, Views, Indexes, and
Triggers etc. as requirement on SQL Server Environments.
Responded to and resolved all database access and performance issues.
Oriented other database administrators on SQL Server management including upgrades and migration.
Ensured databases adhere to corporate standards and policies, including database auditing.
Installed SQL Server 2012, 2014, 2016 and 2017 on advanced servers, applied security fixes.
SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA) for performance.
In charge of Server Lease Replacement, Server Decommissioning for the entire Datacenter.

We provide IT Staff Augmentation Services!

Sql Server Database Administrator Resume

Andover, ConnecticuT

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship