LiveCareer-Resume

sql database administrator resume example with 7+ years of experience

Jessica Claire
  • , , 609 Johnson Ave., 49204, Tulsa, OK 100 Montgomery St. 10th Floor
  • H: (555) 432-1000
  • C:
  • resumesample@example.com
  • Date of Birth:
  • India:
  • :
  • single:
  • :
Summary

Over Seven years of experience as DBA Providing technical support for the database environment from MS SQL Server 2005 to SQL Server 2019 with ability to analyze and troubleshoot very large and highly transactional database systems. Solid working experience in designing and implementing database solutions. Highly motivated and takes initiative to manage and work on different projects individually and as a team. Strong business and technical vision with effective people skills, innovative, problem solver, result oriented, and has high aptitude to learn new technologies. I am looking to join a dynamic team that works under high pressure and challenging environment to build and deliver high quality solutions.

Skills
  • MS visual studio, Solar Winds, Red Gate, ERWIN, VMware, Spotlight, Grafana, SQL Built in tools (Extended events, SQL Profiler & DTA).
  • Microsoft PowerShell
  • Data Conversion and Migration
  • Writing Queries
  • Database Analysis
  • Data Testing
  • Agile Methodology
  • Document Management
  • Planning & Organizing
  • Data Management
  • Maintenance & Repair
  • Computer Skills

· Database Backup/recovery

· SQL Server Integration Services

· Statistics

· Database Design

· SQL Server Reporting Services

· Rebuild and reorganize index

· MS SQL Server 2005-2019

· Analysis Services

· Performance Tuning

· High availability/disaster recovery

· Scripting

· Auditing

· Stored Procedures

· Encryption/Decryption

· Documentation

· Clustering

· Firewalls

· Capacity Planning

· Virtual Machine

· IAAS / PAAS /SAAS

· IIS

Experience
SQL Database Administrator, 03/2020 - Current
Computer Aid Pittsburgh Or Whippany Nj, PA,
  • Installation and configuration MS SQL Server on production UAT and Dev environments
  • Managed Critical production environment databases, and performance tuning whenever there is an issue with performance to ensure high levels of performance and availability
  • Analyze, solve, and correct issues in real time, providing problem resolution end-to-end
  • Perform scheduled maintenance and support release deployment activities after hours
  • Refine and automate regular processes, track issues, and document changes
  • Manage data backup, recovery, security, and integrity
  • Implement Transactional SQL, and DTS stored procedures
  • Implement High Availability (HA) and Disaster Recovery (DR) solutions for SQL Server
  • Design, implement and manage high availability & disaster recovery solutions including Failover Clustering, Replication,
  • Log shipping, Database Mirroring and AlwaysOn
  • Create Microsoft SQL Server Integration Services (SSIS) package and deployment
  • Experience in working with Performance Metrics, set up alerts and Plan Management
  • Ability to working with multi-instance management
  • Configured server level and database level firewalls as per security compliance
  • Experience implementing TDE (Transparent Data Encryption) and DDM (Dynamic Data Masking) Features
  • Configured Always on Availability groups using Cloud VMs
  • Used Power Shell to execute batch files and other scripting tasks
  • Experience in migrating the on-premises database to Cloud and from cloud to on premise using multiple DMA and DMS
  • Migrated on premise database servers into Azure SQL Databases
  • Installation of MS SQL Server enterprise on Clustered Production, Azure VM, Test and Development boxes
  • Used Nagios and other third-party tools to monitor the performance of SQL Server
  • Performed rebuild and reorganize Indexes and update outdated statistics
  • Performed backup file managements, archiving and cleanups
  • Performed database consistency and allocation checks and troubleshooting where problem arise
  • Implemented TLS.1.2 Transport Layer Security on multiple databases for an encryption protocol to keep data secure over a network
  • Debugged complex queries and stored procedures
  • Implemented log shipping as part of disaster recovery plan
  • Implemented mirroring with master key and certification for DR purpose
  • Monitored log space usages and troubleshoot issues arising with log files
  • Designed and implemented backup and recovery plan strategies
  • Performed databases maintenances using maintenance wizard features
  • Managed SQL data and log files and hard drive storages for maximum performance
  • Performed data loads using SSIS, scripts and BCP from different data sources
  • Managed users and permissions of SQL Server reporting services
  • Optimized the performance of ETL jobs scheduled on staging and SSIS servers
  • Implemented automated database refresh in lower environments using backup and restore
  • Setup databases mails and alerts for critical jobs and server issues
  • Implemented job history cleanup and managed SQL server log files
  • Provide 24/7technical support and monitoring.
SQL DBA, 02/2017 - 02/2020
Apex Systems Medford, MA,
  • AvalonBay Communities, Inc
  • Is a publicly traded real estate investment trust that invests in apartments
  • I was responsible in managing database servers and worked on multiple projects with internal and external clients
  • Installation of MS SQL Server enterprise on Clustered Production, Test and Development boxes
  • Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems
  • Migrate databases from SQL Server 2005/2008 to SQL Server 2016
  • Configured 4 Node widows failover clustering and SQL 2016 Alwayson
  • Performed SQL service pack & security patch on failover cluster and AVG
  • Installed and configured SQL Server Reporting Services
  • Regularly monitor the performance of UAT and PROD server (CPU, Memory, I/O) using SQL Profiler, Performance monitor, DMVs, Wait Stats and Events
  • Experience in T-SQL writing Stored Procedures, Functions and Triggers
  • Created login id, passwords and roles in production and non-production environment
  • Experience on creating and maintains on SQL Virtual Machine running at VM ware and Microsoft Hyper-V environment
  • Used Power Shell to execute batch files and other scripting tasks
  • Set up transactional and snapshot replication among SQL Server 2008/2012 boxes
  • Auditing stored procedures for optimization and improving performance
  • Backing up system and user databases and restoring them when necessary
  • Schedule the jobs for the Database Maintenance
  • Run DBCC commands to check the database consistency
  • Extensively used DMV, SQL profiler and performance Monitor, and Performance Dashboard for troubleshooting
  • Maintain index rebuild and re-organize indexes periodically
  • Transfer data among SQL boxes using SSIS, BCP, and Back up & restore
  • Created Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, task assignment and tracking
  • Working with external clients and business analysts in gathering, understanding, and documenting requirements
  • Tuning SQL server performance issues by using indexes, partitions and by implementing best practices
  • Implementing Code Deployments to Higher Environments
  • Tuning and enhancing slow running queries and stored procedures
  • Installing and configuring SQL server and other applications
  • Managing logins, users, roles, securable and permissions for all environments
  • Preparing security compliance and implementing Audit/Check balance procedures for each server
  • Analyzing database workloads and planning capacity changes of the servers
  • Monitoring, identifying, and troubleshooting SQL Server performance bottle necks
  • Supporting all Production Environments and External Clients in a daily basis
  • Monitoring and troubleshooting SQL Server Agent jobs
  • Upgrading and Patching SQL Server boxes in all Environments (Production, QA, and Development)
  • Provide 24/7technical support and monitoring.
SQL DBA, 03/2015 - 01/2017
Apex Systems Midlothian, VA,
  • Configured, Installed, and Maintain SQL Server in development, test, and production environment
  • Installed and Configured Operating Systems, Windows Server
  • Installed and Configured SQL Server Reporting Services (SSRS)
  • Implement and manage database clustering, failover, and load balance technologies as per client requirements
  • Configured and Maintained Replications, Log Shipping, Mirroring and Alwayson Availability group
  • Upgraded databases from SQL Server 2008R2 - 2012/2014/2016 in testing and production environment
  • Upgraded/migrated SQL server instances/database from older version of SQL server to newer version of SQL server
  • Applied latest SP (Service Pack) and patches on SQL Server
  • Writing T-SQL and Stored-Procedures
  • Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views,
  • Stored Procedures, and Triggers
  • Working experience in Database Backup, Restore and Point-in-Time Recovery
  • Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
  • Performed writing scripts for automations, debugging procedures and functions
  • Performed in performance tuning of SQL queries, indexes, disk I/O, memory and CPU
  • Monitor Server Activity, Error Log, space usage, and solving problem as needed
  • Managed security principal by defining user's role on server level and database level
  • Managed grant/deny login credentials and fix orphan users
  • Solved locking, Blocking and deadlock issues
  • Provide 24/7technical support and monitoring.
Education and Training
Bachelor's Degree: computer science, Expected in 2014
-
Gage University College - ,
GPA:
Status -
Certifications
MuleSoft Certified Developer version 4 Certified Developer LANGUAGES English - Fluent,

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • Gage University College

Job Titles Held:

  • SQL Database Administrator
  • SQL DBA
  • SQL DBA

Degrees

  • Bachelor's Degree

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: