| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLEStreet Address Crafton BlvdPittsburgh PA, Street Address
EMAIL AVAILABLEObjectivesAn experienced SQL Server DBA with detail oriented and troubleshooting having more than 4years of professional experience in different Microsoft products as a SQL Server Database Administrator. Solid working experience in managing large databases, backup/recovery, configuring and managing HA solutions. As a DBA professional and troubleshooting experience include SQL Server database administration, gathering and analyzing business requirement and Operating Systems, Monitoring, Performance Tuning, stored procedures, functions, constraints and views etc. Working experience entails strong knowledge on using database third party tools like SolarWinds, REDGATE, ServiceNow, Jira as ticketing tool and TSM as backup tools.Education and TrainingPursuing Associates Degree in Computer Sciences (University of the People)MCSA SQL Server 2016 Database AdministrationPursuing 70-764 Administering a SQL Database infrastructurePursuing 70-765 Provisioning SQL DatabasesCertificationMicrosoft Technician Associate Database AdministrationExperienceCITIZENS CARE INCSQL Server Database Administrator Jan/2018- PresentResponsibilities:Regular monitoring of servers, which includes backup jobs monitoring, Disk space monitoring, Services monitoring, and blocking monitoring and troubleshooting using SSMS. Responsibilities:Database Migration from On Prem to AWS RDSInstallation, Upgrades, Patching and Configuration of MS SQL Server 2016, 2014, 2012, 2008R2 in different 32/64-bit production, test, and development environments.Responsibilities include performance monitoring, security, backups, patches, troubleshooting, refresh, and data recovery, minimize downtime, maintain various environments, perform testing and documentation of processes. Proven working experience as a Database administrator.Creation and maintenance of Databases, creating Roles and managing user permissionsand Admin groups.Automate maintenance plan jobs in SQL Server agent and task scheduler: such as backup database, index rebuilding, index reorganizing, cleaning up, and updating statistics.Assist in the development of new application systems and database changes.Supports day to day operational duties for the database platform such as service nowrequests and tickets, and other tasks as assigned or expected from DBAs.Responsible for Securing SQL server, user management, assigning permissions and roles.Perform database deployments (After work hours) and provide support for application releasesSupport all areas of the enterprise, ensuring all databases run at optimal performanceAdminister and monitor 24/7 applications and systems, developing automated alerts towarn of failureProvide DBA support and technical expertise for multiple applications in development, test, QA and production - SQL Server 2008R2, 2012, and 2014 environmentsParticipating in on call rotation.Experience in Implementing high availability with Always on Availability and Failover Clustering with Disaster Recovering.Hands on experience trouble shooting when SQL Server is Paging out.Perform database performance analysis and optimization, define bottlenecks, manage testing and production implementation.Prepare reports on administration best practices, new technologies, etc., and recommend enhancements and configuration changes to improve and optimize the environment.Work with project teams as required to design technical solutions to address project requirements.Work with leadership to research, define, interpret, and analyze complex, unstructured technical database problems and recommend solutions, and implement them.Ability to work with a team to provide written responses to technical proposals and /or reports/documentation for delivery.Capital Health & Human ServicesSQL Server Database Administrator JAN/2017 - NOV/2018Responsibilities:Installation, Upgrades, Patching and Configuration of MS SQL Server 2016, 2014, 2012, 2008R2 in different 32/64-bit production, test, and development environments.Regular monitoring of servers, which includes backup jobs monitoring, Disk space monitoring, Services monitoring, and blocking monitoring and troubleshooting using SSMS.Ensuring data recovery, maintenance, Data integrity and space requirements for physical database.Creation and maintenance of Databases, creating Roles and managing user permissions and Admin groups.Automate maintenance plan jobs in SQL Server agent and task scheduler: such as backup database, index rebuilding, index reorganizing, cleaning up, and updating statistics. Supports day to day operational duties for the database platform such as service now requests and tickets, and other tasks as assigned or expected from DBAsResponsible for Securing SQL server, user management, assigning permissions and roles.Perform database deployments (After work hours) and provide support for application releasesAssist developers with MS SQL Server issues and questionsAdminister and monitor 24/7 applications and systems, developing automated alerts to warn of failureProvide DBA support and technical expertise for multiple applications in development, test, QA and production - SQL Server 2008R2, 2012, and 2014 environmentsExpertise Implementing high availability with Always On Availability and Failover Clustering with Disaster RecoveringSkills4 Years of Database Administration on MSSQL Server 2016,2014, 2012, 2008R2.Experience in Migrating from SQL server 2008R2 to 2012, 2014 and 2016 by using In-Place upgrade process as well as side-by-side upgrade process.Experience in Supporting Different High Availability & Disaster Recovery scenarios like Always-On Availability Groups, Clustering, Replication models, Log Shipping and Database Mirroring.Designs and maintains access and security administrationServed as support for database administration tasks including configuration management, backup/ restores and recovery models, performance optimization, and space management.Experienced with DMS (Database Migration Services) tools to migrate data from On- premises to Cloud.Experience in Database Migration from On-Prem to AWS RDSExperience in setting up and managing database security by creating new users, roles, and provide required user privileges in development, test, training environments.Experience in implementing operational automation using scripts.Experience using PowerShell. (Still learning)Experience handling Locks, Deadlocks, Detect CPU, I/O, Memory Bottlenecks, Optimization, Performance tuning of SQL Server databases using Extended events, DMVs, Activity Monitor, SQL Profiler, DB Tuning wizard, and third-party tool. (SOLARWINDS AND REDGATE) Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities, Re-Indexing, Updating Statistics, performing Maintenance Tasks.Diagnosed job errors and implemented solutions.Experience in importing/exporting data from various sources of data into SQL Server Databases and vice versaProvide 24 X 7 Production Database on Call Support per the published schedule, with the expectation of after-hours support for unplanned service disruptions as well as planned maintenance windows.Perform database performance analysis and optimization, define bottlenecks, manage testing and production implementation.Have a flair for technology and willing to take up challenging assignmentsHave excellent analytical, problem solving, communication and interpersonal skills with ability to interact with people at all levels and can work as part of a team or independently.Devoted and Quick learner with ability to master and implement recent technologies.Excellent professionalism, communication, and interpersonal skills.Ability to communicate proactively to management any potential issues that may hinder the ability to meet project deadlines |
