SEARCH

SQL Server Database Administrator Resume Example

Resume Score: 80%

Love this resume?Build Your Own Now
A
SQL SERVER DATABASE ADMINISTRATOR
Summary
  • I am an IT professional with over 6 years of experience working on complex database environments with focus on SQL Server. My key strengths are performance tuning, capacity planning, High Availability Solution, Disaster recovery planning, managing complex add-ONS in (SQL Server 2000- 2017), Migration/Upgrade, applying service Packs and routine DBA activities like Database health check, Index optimization, Updating statistics, Client/Server connectivity, Capacity planning, Database backup and Restore/Recovery, Query optimization, SQL Server Installation, Configuration of stand-alone with multiple instances in a non - Clustered environments etc.
  • A highly motivated IT Professional with over 6 years of Strong Experience with MSSQL Server 2000 through 2017 Administration.
  • Good experience in the field of Database Technology with experience in designing, developing, implementing Databases and good on documentation.
  • Experience working in an Agile environment.
  • Experience in translating business requirements into conceptual, logical, and physical data models
  • Experience administering, Managing and configuring RDBMS database design, performance tuning, optimization, disaster recovery planning, execution and testing backup
Skills
  • Automation
  • Backup
  • Capacity Planning
  • Consulting
  • Encryption
  • Disaster recovery
  • DML
  • Firewall
  • Managing
  • Mail
  • Processes
  • Quality
  • Reporting
  • Servers
  • Scripts
  • Tables
  • T-SQL
  • Troubleshooting
  • Upgrade
  • Agile methodology
  • High Availability Solution
  • Disaster recovery planning
  • Managing complex add-ONS in (SQL Server 2000- 2017)
  • Migration/Upgrade
  • Index optimization
  • Updating statistics
  • Client/Server connectivity
  • Capacity planning
  • Database backup and Restore/Recovery
  • Query optimization
  • SQL Server Installation
  • Configuration of stand-alone with multiple instances in a non - Clustered environments etc.
Experience
SQL Server Database Administrator
Cranford, NJAllstate Insurance/Sep 2018 to Current
  • Experience using SQL Server Tools like Import/Export Wizard, SSMS, SQL Profiler, Extended Events, SQL Query Analyzer Database Engine Tuning Advisor (DTA), Red-Gate , Service-Now.
  • Etc.
  • Production support in a 24/7 environment and project support.
  • Achieved 99.9% uptime on all SQL Servers.
  • Interacts with clients, application team and project managers to design, implement and support solutions to meet client needs.
  • Installed and configured SQL 2008, 2012, 2014, 2016 and 2017 in both standalone and clustered environment with availability groups.
  • Performed different SQL server version Upgrade in both standalone and cluster instances.
  • Complex database environments, Production, Test and Development Environments.
  • Provides support for the AppTeam, BI Team, IT Security team and IT Ops Team.
  • Execute all Production Implementations and Deployments.
  • Install and configure SSRS for reporting.
  • Create Database Mail for notifications.
  • Alerts settings on job failures and Resource deficiencies.
  • SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA) for performance.
  • Create Logins at Server level, users at Database level and also create Database Roles for groups of users.
  • Configured Always-On Availability Group for disaster recovery.
  • Trouble shoot complex issues on Always On availability group.
  • Provide a Stable environment for Availability group Replicas and databases from frequent fail-overs.
  • System monitoring and proper allocation of Resources.
  • Troubleshooting client connectivity.
  • Deadlock resolution.
  • SQL Server Performance Dashboard Reports for Monitoring.
  • Performance Base-lining.
  • Manage indexes to improve performance.
  • Schedule jobs using SQL Server Agent.
  • Developed routine jobs for data integrity check.
  • Managing Server and database security and identity.
  • Provide support for volumetric Encryption for security.
  • Database Vulnerability check on databases for security.
  • Configured and maintained Contained Databases.
  • Task Automation.
  • Implementation of snapshot isolation and DML triggers.
  • Stable Replication Topology.
  • Planning and implementation of Database backup/restore and disaster recovery.
  • Upgrade SQL Server 2012, 2014 and 2016 to SQL Server 2017.
  • Maintained database response times in 24X7 Production environments.
  • Developing SQL scripts for maintaining administration tasks.
  • Capacity Planning and resource allocation.
  • Monitoring standby databases to ensure high availability.
SQL Server Database Administrator
Houston, TexasMODAJ PRO IT SOLUTIONS /Apr 2016 to Aug 2018
  • SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA) for performance.
  • Create Logins at Server level, and users at Database level.
  • Configured and supported replication.
  • Configured AlwaysOn Availability Group for disaster recovery.
  • System monitoring and proper allocation of Resources.
  • Created and managed table compression and partitions.
  • Troubleshooting client connectivity.
  • Deadlock resolution.
  • SQL Server Performance Dashboard Reports for Monitoring.
  • Performance Baselining.
  • Manage indexes to improve performance.
  • Schedule jobs using SQL Server Agent.
  • Developed routine jobs for data integrity check.
  • Managing Server and database security and identity.
  • Managing Firewall Rule, Trigger, Temporal Tables, Change Data Capture (CDC).
  • Configured Transparent Database Encryption (TDE) for security.
  • Configured and maintained Contained Databases.
  • Task Automation.
  • Indexes Maintenance.
  • Stabilized Performance.
  • Implementation of snapshot isolation and DML triggers.
  • Stable Replication Topology.
  • Planning and implementation of Database backup/restore and disaster recovery.
  • Upgrade SQL Server 2008r2 Servers to SQL Server 2014.
  • Maintained database response times in 24X7 Production environments.
  • Developing SQL scripts for maintaining administration tasks.
  • Capacity Planning and resource allocation.
  • Monitoring standby databases to ensure high availability.
SQL Server Database Administrator
Lagos, NigeriaENTERPRISE BANK/Jun 2014 to Mar 2016
  • SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA) for performance.
  • Create Logins at Server level, and users at Database level.
  • Configured and supported replication.
  • Configured AlwaysOn Availability Group for disaster recovery.
  • System monitoring and proper allocation of Resources.
  • Created and managed table compression and partitions.
  • Troubleshooting client connectivity.
  • Deadlock resolution.
  • SQL Server Performance Dashboard Reports for Monitoring.
  • Performance Baselining.
  • Manage indexes to improve performance.
  • Schedule jobs using SQL Server Agent.
  • Developed routine jobs for data integrity check.
  • Managing Server and database security and identity.
  • Managing Firewall Rule, Trigger, Temporal Tables, Change Data Capture (CDC).
  • Configured Transparent Database Encryption (TDE) for security.
  • Configured and maintained Contained Databases.
  • Task Automation.
  • Indexes Maintenance.
  • Stabilized Performance.
  • Implementation of snapshot isolation and DML triggers.
  • Stable Replication Topology.
  • Planning and implementation of Database backup/restore and disaster recovery.
  • Upgrade SQL Server 2008r2 Servers to SQL Server 2014.
  • Maintained database response times in 24X7 Production environments.
  • Developing SQL scripts for maintaining administration tasks.
  • Capacity Planning and resource allocation.
  • Monitoring standby databases to ensure high availability.
  • Role: JR.
  • SQL SERVER DATABASE ADMINISTRATOR.
  • Installed SQL Server 2012 on advanced servers, applied security fixes.
  • Maintain the overall database integrity and quality, including routine data improvement.
  • Create Logins at Server level, and users at Database level.
  • Documented processes for installations, and upgrade.
  • Maintained database response times in 24/7 Production environments.
  • Proactively generated performance reports.
  • Automation of DBA Tasks and monitoring.
  • Planning and implementation of Database backup/restore and disaster recovery.
  • Database Mail and Operator.
  • Tables Design, views, Stored procedures, Function etc.
  • Capacity Planning and resource allocation.
  • Monitoring standby Databases to ensure high availability.
  • Maintained SQL Server Database; ensured accuracy of information and automated numerous functions.
  • Fine tuning of database objects and server to ensure efficient data retrieval.
  • Monitor and optimize system performance using SQL Profiler and Database Engine Tuning Advisor.
  • Schedule jobs using SQL Server Agent.
Education and Training
Bachelor of Science: Public AdministrationENUGU STATE UNIVERSITY oF SCIENCE & TECHNOLOGYDec 2008ENUGU STATE NIGERIA
Certifications

MSCA (inview)

CERTIFIED Scrum Master

CERTIFIED Software Tester

Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

Companies Worked For:

  • Allstate Insurance
  • MODAJ PRO IT SOLUTIONS
  • ENTERPRISE BANK

School Attended

  • ENUGU STATE UNIVERSITY oF SCIENCE & TECHNOLOGY

Job Titles Held:

  • SQL Server Database Administrator

Degrees

  • Bachelor of Science : Public Administration

Similar Resumes

View All
SQL-Server-Database-Administrator-resume-sample

SQL Server Database Administrator

Infor Global solutions

Greer, South Carolina