SQL Server Database Administrator Resume

PROFESSIONAL SUMMARY:

I am a database administrator wif over 6 + years of Strong Experience wif SQL Server 2000 through 2016 Administration, Production support in a 24/7 environment and project support.
I Interact wif clients, application team and project managers to design, implement and support solutions to meet client needs.
I also has extensive experience in the Installation and Upgrade of 2008 R database standalone / cluster instances.
Applying service packs, working on complex database environments, supporting Production, Test and Development Environment.
My key strengths are performance tuning capacity planning, High Availability Solution, Disaster Recovery Strategy, Clustering, AlwaysOn, Database Mirroring, Log Shipping, managing complex add - ons in (SQL Server )I has Experience in the field of Database Technology in designing, developing and implementing Databases.

TECHNICAL EXPERIENCE:

Translating business requirements into conceptual, logical and physical data models
Administering, Managing, Developing and configuring SQL Server database design,
Performance tuning and query Optimization
Production level support for onsite and offshore - On Call 24/7 environment
SQL Server Performance Dashboard Reports for Monitoring
Performance Baselining
High Availability Solution- Clustering, AlwaysOn, Database Mirroring and Log Shipping
Disaster Recovery Strategy
Managing complex add-ons in (SQL Server )
Designing, Developing and implementing Databases
Query Store, Import/Export Wizard, SSMS, SQL Profiler, Extended Events, Red-Gate tools etc.
Replication Models(Snapshot/Transactional/Merge)
Clustering Setup, Troubleshooting and Management
CMS Reporting-Member enrollment
Virtualization
SSIS and Reporting Services (SSRS)
Good T-SQL Writing skills
Temporal Tables
Knowledge of Powershell.

PROFESSIONAL EXPERIENCE:

Confidential

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
Manage indexes to improve performance
Schedule jobs using SQL Server Agent
High level of performance tuning
Using Query Store for performance monitoring
Developed routine jobs for data integrity check
Code deployment into Production
Information Risk Management Control
Tables Design, views, stored procedures, table valued etc.
Managing Server and database security and identity
Credentials management
Managing Firewall Rule, Triger, Rowversion, Temporal Tables, Change Data Capture (CDC) etc
Column Store Indexfor performance
Integration and Reporting Services
Contained Databases
Task Automation
Indexes Maintenance
Database Restore - Point-In-Time Recovery solutions
Stabilized Performance
SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor(DTA) for performance
Expert in implementing the snapshot isolation and DDL triggers
Stable Replication Topology
Comprehensive Backup plan and disaster recovery strategies

Confidential

SQL Server Database Administrator

Responsibilities:

Installed SQL Server 2008 on advanced servers, applied security fixes,
Migration of SQL Server 2005 Servers to SQL Server 2008
Installed and configured MS SQL Server 2008 R2, supported all Production and development servers
Maintained database response times in 24X7 Production environments
Proactively generated performance reports.
Automation of DBA Tasks and monitoring
Planning and implementation of database backup/restore and disaster recovery
Analyzing business requirements and build logical data models that describe all the data.
Configuring and administering Database Mirroring, Log Shipping on SQL Server 2008R2.
Developing SQL scripts for maintaining administration tasks.
Indexes Maintenance
SSIS, high performance data integration solutions, ETL packages
Database Mail and Operator
SQL server Reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
Capacity Planning and resource allocation
Monitoring standby databases to ensure high availability