| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
SQL Server Database AdministratorFredericksburg VA Street Address
PHONE NUMBER AVAILABLE, EMAIL AVAILABLEProfessional summaryOver 8 years of experience in Database Administration, System Analysis, Design, development, and Support of MS SQL Server 2022/2019/2016/2014/2012/2008 R2 in Production, Test, Development, Stage Environments.Expertise in Database Administration on Production Servers with Server Configuration, Performance Tuning, and maintenance with outstanding troubleshooting capabilitiesExperience on High Availability /Disaster Recovery (HADR) solutions; Failover Clusters and Always on Availability Groups, Replication, Log Shipping and MirroringExperience in Upgrade/MigrationExperienced in Backup and Recovery, query OptimizationExperienced in monitoring the health and performance of SQL servers as well as home grown applications using SQL Server native tools and several other third-party solutionsCreated various SSIS Packages to serve company needsExpert in using Extended Events/PerfMon/SQL Profiler/ Scripts and other third party tools to resolve bottlenecks, dead locks and slow running queriesResponsible for securing SQL Server, user management, assigning permissions and roles.Strong System Administration background in Windows.Expert in problem solving, analysis and conflict resolutionsSkillDatabases: MS SQL Server 2019, 2017, 2016, 2014, 2012, 2008 R2, 2008, MS Access,Cloud: AWS, AZUREETL Tools: MS SQL Server Integration Services (SSIS)Reporting Tools: MS SQL Server Reporting Services (SSRS), Report builderProgramming Languages: T-SQL, PowerShell, CMDOperating Systems: Windows 2016/2012serverOther Tools: MS SQL Server Migration Assistant (SSMA) and ODBC/DB Link, MS Always On, MS Azure, MS SQL Server Clustering and Performance Tuning, Red Gate, ServiceNow, Jira, SplunkEducationBachelor Degree, Business AdministrationMaiwand University of Higher education (MIHE) 2010-2014CertificateMicrosoft Certified Solutions Associate (MCSA)Microsoft Azure AssociateTraining:Always on High Availability groupTraining on Database Performance tuningTraining on Azure DatabaseEXPERIENCETata Consultancy Services TCS Inc. March 2021- PresentSQL SERVER DATABASE AdministratorProvide Customer supportDesigned and developed SSIS packages to extract, transform, and load (ETL) data from various source, and SSRS.Provide technical support to client to manage BestBuy databasesDatabase refreshMigration from on premises to Azure & On premises to On premisesMigration from Azure to AWSImplementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications.Ensuring operational readiness (security, health and performance), executing data loads in development and production environmentCapable of working independently and collaboratively.Verify that the design and execution of database server configuration, and maintenance fulfill SLA goals.Responsible for creating, modifying and managing tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, TriggersAdminister, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the companys databases and systemsExtensive experience setting up and troubleshooting SQL Server Availability Groups.Proactively monitored the production database(s) and optimize stored procedures for better performance. Resolve locking conflicts and resource utilizationManaging SQL Server Database both on-perm and AzureAdvance performance tuning and T-SQL codeDynCorp International March 2019- March 2021 (Dallas, TX)SQL SERVER Database AdministratorProficiency in SQL server database Backup/Recovery, Refresh, Maintenance, Export/Import/ Performance monitoring/tuning, Security management, SQL Programming, with work experience on different version on SQL server database example 2008,2012,2014,2016,2019Configure and maintained High Availability (HADR) solutions, Failover Clusters and Always on Availability Groups, Replication, Log Shipping and Mirroring.Applying patches and Perform database upgrades/migrationsTroubleshoot complex systems to identify bottlenecks (SQL, IO, hardware, query related, etc.); Resolve database related issues.Provide production support in time sensitive situations in addition to providing support for multiple high-profile applications/projects.T/SQL, SQL, DML, DDL and DCL Experience, Manage connectivity to other RDBMS.Assist clients with fine tuning indexing and tune queries.Generate performance and efficiency metrics and offer expert advice to clients.Perform regular security and access reviews;Azure/SQL Server DBA Experience in an IaaS/PaaS environmentImplementing and maintaining data security protocols for sensitive data & PII.Azure/SQL Server monitoring and performance tuning, installation, administration, and maintenanceWorking of Agile methodology.Perform day-to-day operations (includes monitoring and maintenance, problem investigation and resolution, backup creation and maintenance, database optimization and tuning, etc.).Effectively prioritize and manage concurrent projects, demonstrate initiative and work independently with minimal supervision.Drive results and leverage past experiences to improve the environment and related processes.Stay current on technology and industry standards; work with leadership to develop strategic plans and roadmaps.AID MEDICAL INTERNATIONAL, Inc. March 2017- March 2019SQL SERVER Database AdministratorAssist team with Migration from on-premises to on Azure, IaaS.Provided support for data migration projects, including data cleansing, validation, and reconciliation tasks.Managing SQL Server Databases both on-prem and Azure using (IaaS) for production environment.Database refreshes and cloning using Delphix and native SQL backup and restore.Hands on experience with schemas, loading data, data retrieval and reporting.Root Cause Analysis (RCA) of Incident, Monitoring of Production, Dev and Test on-prem and Azure environment of SQL Server and analyzed the root cause and factors impacted database performance.Involve with database upgrades, patching, and migrations in windows environments.Working in Database related day-to-day Activities.Create SQL Server logins, database users, assigning permissions, moving security between servers and implementing database encryption TDE, dynamic data masking (DDM).Creating Alerts for growth and usage of mission critical database filesCreating SOPs and performing monitoring task with team.Ensuring solution and operations reliability.Designing and planning a cloud solution architectureWorking in an Automation team that delivers a high availability service.Excellent in Performance Tuning including monitoring, troubleshooting, and optimizing performance of the databases as well as high availability service.24 X 7 Production Database on Call Support. |
