SQL Database Administrator Resume

SUMMARY:

A technical, dedicated professional with more than five years of experience and exceptional analytical, problem - solving and communication skills looking to secure a challenging and dynamic MSSQL DBA position for continuous growth of the company and client satisfaction.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2016 / 2012 / 2008

R2RDBMS: MS SQL Server 2016 / 2014 / 2012 / 2008 R2, MySQL

Administration Tools: SQL Server Management Studio, MySQL Workbench

Languages: T-SQL, Java

Monitoring Tools: SentryOne

Other Tools: Project Portfolio Management, ITSM Ticketing, Visual Studio

MS Office: Word, Excel, Access, Outlook, Power Point

AREA OF EXPERTISE

Administration of SQL Server versions 2016, 2014, and 2012 versions
Hands on High Availability (HA) Always-ON Availability Group clusters implementation
In-place upgrades and migration of databases from lower to higher versions
Configure backup strategies and recovery models
Account management following best industry practices and security policies
Troubleshoot connection and performance related issues using Sentry One
Service Packs patching and applying cumulative updates whenever required
Implementation of Transparent Data Encryption (TDE)
Setup and configure SQL Server maintenance packages
Write T-SQL scripts in stored procedures, triggers and SQL jobs
Familiarity with SQL Auditing
Provided Capacity planning and architecture design of new database servers
Draw logical and physical database design diagrams
Familiarity with High Availability (HA) Database Mirroring
Follow Change Management process using ITSM Ticketing system
Time management process using Project Portfolio Management (PPM)
Work with different vendors and business units on various projects
Mentor and train junior DBAs
24/7 On-Call Database Administration support

WORK EXPERIENCE:

SQL Database Administrator

Confidential

Installed, Configured, and Managed SQL Server versions 2016, 2014, and 2012
Performed in-place upgrades and migrated databases from SQL Server 2008R2 & 2012 versions to 2014 and 2016 versions
Configured and administered Always-On Availability Groups on 2012 and newer versions
Administered Mirroring solutions on 2008 R2 versions
Maintained Two and Three node Active/Passive Windows Failover Cluster High Availability and Disaster Recovery solutions with SQL Server AG technology
Implemented SQL logins, roles and authentication modes as a part of security Policy
Configured Full & Log backups; performed Point-In-Time Recovery solutions
Managed user account security and permission policies on SQL Server environment
Created Database Objects like Stored Procedures, functions, Views, Triggers, etc.
Managed index usage and fragmentation and updated statistics in databases
Implemented Transparent Data Encryption (TDE) solutions on critical Tier Level 0 and Tier Level 1 backend database servers
Enabled & configured security Auditing on SQL Servers
Troubleshot and fine-tuned DB performance and concurrency and root cause analyses
Checked Database Health by using DBCC Commands and DMVS
Designed and implemented comprehensive Backup plan and disaster recovery strategies
Monitored and modified Performance using SentryOne monitoring system
Updated DB system by planning, testing and installing security patches and service packs
Define and maintain database and code standards as well as naming conventions
Translate business requirements into technical design specifications
Participate in implementation of new database releases into production
Maintained disk and memory spaces issues on PROD and non-PROD servers
Follow change control ticketing system for all production and non-production requests
Provide 24/7 production on-call support for all SQL Server database servers

Quality Control Tester

Confidential

Served as a contractor for a local company established as the leading provider of software solution for Microsoft SharePoint.
Worked on multiple roles as “QC Tester” and “Helpdesk Support Tester” for the client.
Foremost use of Microsoft Team Foundation Server (TFS) integrated with Microsoft Test Manager (MTM) system.
Served as the key tester of “Workflow Conductor” product primarily working with graphical user interface, Sanity, Integration, end-to-end, regression, and storage testing.
Performed main tester duties of recreating end-user issues logged by helpdesk call center and report findings in MTM system and help Business with UAT testing
Utilized Microsoft Visual Studio for regression testing.
Take part in daily meetings providing status, reports, and updates.
Occasional validation of backend testing on SQL Server platform.
Contributed to the agile software development cycle for workflow conductor tool.
Evaluate business requirement to create different test cases.
Compose and implement test cases and test suites using MTM.
Identify software defects, issues submission, & update status.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship