| Candidate Information | | Title | Sql Server Database Administrator | | Target Location | US-NC-Raleigh |
| | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateMICROSOFT SQL SERVER DATABASE ADMINISTRATORProfessional SummaryMore than 8 years of IT experience in Database Administration, Designing Development and Supporting MS SQL Server, and Azure Databases,Experience in RDBMS database design, database files management in MS SQL Server,Setup and maintain test and production databases,Solid experience and knowledge in database backup, restore and copy across servers,Extensive experience in capacity planning and monitoring, Performance tuning,Experience in Disaster Recovery Planning, Execution, Testing and Troubleshooting,Experience in using SQL Server Tools like DTS, SQL Server Enterprise Manager, SQL Profiler, SQL Query Analyzer, Extended Event, PERFMON, ETL and Query Store,Experience in database Security (creating logins, users, roles, and assigning permission),Experience in implementing high availability solutions using Log shipping, AlwaysOn and ReplicationAzure SQL database Administration, Azure Data Factory Setup,SSRS, SSAS and SSIS installation and configuration,Very good written and verbal communicationsProvides leadership and work guidance to less experienced personnel.Professional customer support on SQL ServerCognizant October 2018-PresentRaleigh, North CarolinaSQL Server Database AdministratorInstalling and configuring SQL Server database instances and setting up jobs,Provisioning Azure databases, and SQL on Azure VMs,Deploying changes to production servers after CAB approval,Migrating and upgrading databases to newer versions, & and to Azure VMs, Azure Databases and Managed Instances,Installing SQL Server/SSIS/ SSRS services on SQL 2019/2017/2016/2014 /2012/2008R2 \2005\2000 versions,Monitoring database servers proactively for performance related and resource contention issues,Creating, optimizing, and debugging queries and stored procedures,Creating triggers and functions,Configuring and monitoring High Availability and Disaster Recovery solutions like AlwaysON/Clustering Distributed Availability Groups, Log Shipping, Replication,Performing and maintaining database backups, recovery, security and ensuring the integrity of all database components through daily system checks,Designing and developing highly complex database systems for internal and external users/clients,Performing complex analyses and reviews of applications being released into production databases,Developing and overseeing the implementation of test application code in client server environments to ensure that software conforms to standard management practices,Analyzing new and emerging technologies and tools for applicability to the field,Responsible for SQL server logical and physical database design, implementation, and maintenance,Creating databases, tables, indexes, stored procedures, views, database management policies and constraints, defaults, rules, functions, triggers, and dynamic SQL queries.Investigating and analyzing the root causes of problems to provide long lasting solutions using tools like SQL Profiler, Query Store, Extended Events, Database Tunning Advisor and Query Performance Insight,Working knowledge of reporting tools like SQL Server native like SSRS, SSIS, SSAS, and othersConducting code reviews for standardization of codes and performance.Datagroup, Alexandria, VA August 2016-August 2018SQL Database AdministratorResponsibilities:Installed, configured, and administered SQL Server versions of 2016, 2014 and 2012 in Production, Development and Staging,Managed Microsoft Active-Active and Active-Passive Clustered SQL Server 2005, 2008/R2 and 2012 environments,Made sure the availability of databases by configuring, implementing, and maintaining solutions like Log Shipping, Mirroring and Replication, AlwaysOn AG and FCI,Ensured that the new database code meets company standards for readability, reliability, and performance,Monitored the regular backup of the production databases and resolved the backup failures ensuring a perfect database backup strategy for the organization,Monitored data activities like database status, logs, space utilization, locks, and long transactions,Ensured database security by controlling user privileges, diagnosing connection attempts, monitoring the security and audit issues as per Enterprise Standards,Worked on root-cause analysis of and troubleshoot SQL Server problems related CPU, Memory, Disk I/O, and network contentions,Resolved database performance bottlenecks using SQL Profiler, PerfMon, DB Engine Tuning Advisor, DMVs, SolarWinds and SpotLight,Developed efficient stored procedures, indexed views, User Defined Functions (UDF), Triggers, and Distributed Queries that alleviated some performance bottlenecks,Involved in resolving deadlock and blocking issues for concurrent users,Properly documented all the changes made in the database environment using SharePoint,EnvironmentSQL Server 2019, 2017, 2016, 2014, 2012, 2005,2000, VMWare, SAN, LiteSpeed, SpotLight, Windows 2016, 2012, 2003 Server, Enterprise Manager, SSRS, SSIS, SolarWinds, Business Intelligence Development, Teams, Service Now, SharePoint, AppDynamics,TECHNICAL PROFICIENCYAdministration of MS SQL Server 2019/2016/2014/2012/ 2008/2005/2000. ETL Tools MS SSIS, TSQL, Database Engine Tuning Advisor, Business Intelligence Development Studio, SQL Server Configuration Manager, SQL Client Connectivity SDK Visual Studio, Team Foundation Server, Enterprise Manager, Query Analyzer, Performance Monitor, SQL Profiler/Trace, Extended Event, Redgate, Solar winds, AppDynamicsDatabases SQL Server 2019/2016/2014/2012/2008R2/2008/2005/2000, MSSQL, MS Access.Languages: SQL, TSQL, PowerShell, JavaOperating Systems: Windows NT/2000/XP/2003, 2008/2008R2/windows2012/Windows 2012R2 and window 2016, Azure VMs,CERTIFICATIONMicrosoft Certified Professional (MCP)Azure Database Administrator Certified ProfessionalEDUCATIONBachelor of Science in Computer Science. |
