| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Business Intelligence Sql Server Smithfield, PA SQL SERVER DBA Pittsburgh, PA Sql Server Power Bi Pittsburgh, PA Computer Science Sql Server Canonsburg, PA Sql Developer .Net Pittsburgh, PA Qa Analyst Selenium, API and database testing, SQL, Postman Carnegie, PA Production Support Database Administrator Coraopolis, PA |
|
Click here or scroll down to respond to this candidateCandidate's Name
Tucker, GeorgiaEmail EMAIL AVAILABLEPhone: PHONE NUMBER AVAILABLEPROFESSIONAL SUMMARYo5+ years experience in administration of MSSQL servers.oHands on experience on Installing, Configuring, administering MSSQL Server in development, QA and production environments while ensuring their performance, availability, and internal/external security as production support database administrator.oExcellent experience with software installations and patches (including Service Packs, Cumulative Updates and Hot Fixes) using change and release management processes.oSolid understanding of user management and database security at different levels.oPerform database recovery from logs, hot & cold backups, Export/Imports, and Disaster Recovery.oGood knowledge of design and database modeling.Solid experience in performance tuning, and troubleshooting using native tools like Query store, Performance Counter, Dynamic Management Views (DMV), Extended Event and Profiler or third-party tools.oExperienced in creating automated recurring or redundant database tasks.oWorked closely with System, Network, Security Engineers, Developers, Tasters on verification and implementation in database/SQL Server related activities.oWork as production support and troubleshot errors and incidents.oCreate and update documents on server inventory, standard procedures, naming conventions and technology features.oGood understanding of database and data warehouse concepts (OLTP and OLAP).oExperience in extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using DTS and SSIS services.oExperience in using Business intelligence tools (SSIS, SSAS, SSRS) in MS SQL Server.oExcellent communication, coordination, presentation, and analytical skills.oWork on 24X7 operational support, involved in an on-call rotation.oGood Understanding and coding skills JavaScript, Node.JS, ES6, HTML, CSS, and Git version control.PROFESSIONAL EXPERIENCEClient: Acrisure Dallas, Texas Jan 2021 to presentRole: MSSQL Server AdministratorResponsibilities:oHandle Production support and troubleshot errors and incidents.oManage Installation, Configuration, Upgrades, Capacity Planning of SQL servers.oConduct performance Tuning and troubleshooting as needed.oDesigned and Managed database maintenance plans including backups, Index optimization and statistics.oAdminister database security by creating server logins for Windows groups and assigning appropriate permission using database and server roles.oConfigure and administering High Availability and Disaster Recovery Solutions such as: Log Shipping and AlwaysOn Availability GroupoHandel maintenance of multiple environments (Development, Testing, and Production), including patching, backups, security, and space management.oProactively monitor database for errors and respond quickly and effectively to troubleshoot and resolve on-going issues in all environments.oManage space usage, Job failures, customer complaints in the daily routine works.oUse SQL Server Profiler, Event viewer, Query Store, Activity Monitor, and other local tools to troubleshoot and resolve performance issues.oProviding technical support and working with Network, security, and development teams.oWorked on and deployed SQL Server Integration Services (SSIS) packages.oProvided 24/7 production support on rotation base.Client: Truist Bank May 2019 to Dec 2020Role: MSSQL Server AdministratorResponsibilities:oPerformed database creation, decommissioning, and database migrations from 2008 to 2016 Version.oImplemented database security and auditing features and periodic reviews.oWorked as production support DBA and ensure database stability and performance as well assist day to day activities. Conducts root cause analysis for repeated incidents.oWorked closely with application team to accommodate design and administrative needs, such as working on effective solutions for databases and deployment of changes to higher environments.oDesigned documents and implemented effective utilization of resources for optimal performance and enforces database standards and user guidelines.oCoordinated and scheduled database downtime to perform database maintenance procedures like database patching, upgrades, migration.oAdd and maintain users on the SQL Servers Databases; assigning access, ensuring security, and maintaining their configurations are within standards.oFormulate backup strategies based on client SLA as well as RTO and RPO as well as design and implement high availability and disaster recovery solution.oAutomat routine database maintenance jobs like index defragmentation, statistics update, integrity checks, cleanup, monitoring etc. jobs using SQL server agent.oUse tools like SQL profiler and performance monitor to identify bottlenecks in query performance.EDUCATION AND OTHER SKILLSUniversity of District of Columbia, Bachelor of Science in Computer ScienceGeneral Assemble Full stack.Administration Microsoft Azure SQL Solution |
