I am a US citizen. I have an active DoD NACLC clearance, multiple SQL, Azure SQL and CompTia Security+ certifications to work on any private or US government project. Worked on 24x7 on-call rotation to resolve Severity issues such as applications or servers down and resolving quickly to bring critical applications online. The largest database supported was 19TBexpertisePostgreSQL• Installation/configuration/upgrade/migrate version of 9.6/10/11/12/13/14• creating database/table/indexes etc.• Managing database/table space/schema etc.• Backup/restore/export/import• Monitoring and performance tuning using native and third-party toolsSQL Database• Manual & auto Installation, Configuration, Upgrade, Migrate and patch management of SQL server 2008/2008R2/2012/2014/2016/ 2017/2019• Developed, implemented, and managed backup/restore and business continuity plans including very large database of 19TB.• Strong working experience with SQL Server HA/DR using Failover Cluster/Alwayson High Availability/Replication/Mirroring/Log Shipping configuration and administration• SQL Monitoring, Tuning & Optimization, failed job, disk space, incidents etc.• Analyzing and resolving blocking, deadlock & long-running queries.• Expert knowledge of Error log, Event Viewer, Profiler, Perfmon, DMVs and Extended Event• Expert knowledge of SQL server & database architecture such as data file, log file, tempdb, VLF, COP, MAXDOP, Index, Statistics, wait type, blocking, deadlock, Isolation, Concurrency, Execution plan, CPU, Memory, DMV, SQL dump file etc.• Worked with various teams regarding application & database development, testing and deployment in dev, test, cert and prod environments.• Wrote & reviewed T-SQL code, stored procedures, functions, views, and Triggers.• Working knowledge on capacity planning for database migration• Working knowledge on SSRS concept and report design• Working knowledge on SSAS & SSIS package deployment and troubleshootingCloud computingWorking knowledge of Azure VM, Storage, networking, security, deployment model (IaaS & PaaS), purchase model, service tier, migration, data management, scaling, high availability, monitoring, tuning, cost control, etc. Automation• Databases backup/index rebuild/update statistics/Server health check/disk space monitoring/backup report/blocking/deadlock/various administrative tasks etc.• SQL installation, Database Mirroring, and Log Shipping configuration.• Monitoring Database mirroring, Replication, and Log Ship out of sync.• Centralized monitoring for all production servers