| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateShakhawat is a TS/SCI (Active)/CASP+/MCSE/MCSA/AAA Certified SQL Server professional with 8 plus years of experience in Database Administration, Design, Development and Support of MS SQL Server and Oracle serverCandidate's Name
Email: EMAIL AVAILABLE US Citizen Cell Phone: PHONE NUMBER AVAILABLEDATABASE ADMINISTRATOR(Oracle&SQL DBA)Over 8 years of IT experience in Database Administration, Design, Development and Support of MS SQL Server 2019/2016//2012/2008R2/2008 in Production, Test, and Development Environments that included Clustered Servers.Working experience in SQL queries, procedures, scripts as well as Database High Availability Solutions, DR (Disaster Recovery) Solution, backup/recovery, performance tuning, Database security, etc.Manage large databases in 24x7 data processing environment including database security and monitoring.Migrated/ Upgraded Sql server instances/Databases from older version to new version of sql server like 2012 to 2019.Excellent Communication, Presentation and Interpersonal skills.TECHNICAL SKILL1.Database (RDBMS): SQL Server 2008/2008R2/2012/2016/20192.Database Tools: SQL Agents, SQL Alerts, SQL Jobs, Database mail.3.SQL Tools: Query Execution Plan, Counter, Crystal Reports, Extended Event.4.Data Modeling: ERD (SQL Server ER Diagram), Erwin.5.High availability: SQL clustering, always on availability, mirroring, log shipping, replications6.Performance Monitoring Tool: Execution Plan, PerfMon, Database Tuning Advisor, DMV, Activity Monitor, Extended Event.7.Reports Development/Management: SSRS, MS Access, Excel.8.ETL Tools: DTS, SSIS.9.Platforms: Microsoft Windows Server, VMware.10.Networking: TCP/IP, LAN, WAN, VPN routing.11.Programming Languages: T-SQL, PL/SQL XML, HTML, Basic Power Shell.12.Operating Systems: Windows Server 2012, 2008, 2008R2, Windows XP/Win7&8, 10.13.Third Party Tools: Red Gate and Idera.14.Computer Hardware/Storage: SAN, RAID, ISCSI.15.Migrating Sql database on premises to MS Azure16.STIG on SQL instances and SQL Databases17.Science logic18.VMwareEducationMasters in Sociology (National University) BangladeshBachelor from Dhaka University, BangladeshStatus of ClearanceTop secret/SCI (Active)CASP+TRANNING AND CERTIFICATIONMicrosoft Certified Solutions Expert: Data Management and Analytics(MCSE)Microsoft Certified Solutions Associate: SQL 2016 Database Administration(MCSA)Microsoft Certified Azure Administrator Associate(AAA)CompTIA Advanced Security Practionar (CASP+)Querying Microsoft SQL server 2012/2019Administering MSSQL server 2012 Databases and 2019Implementing Data warehouse with MSSQL server 2012Log Shipping, Mirroring, Replication, T-SQL, SSIS, IISProfessional Training: Clustering, Log Shipping, Mirroring, Replication, Always on.Professional ExperienceSQL DATABASE ADMINISTRATOR Client (US Air force), San Antonio, TX January 2023 to PresentApplied SQL Server service packs and hotfixes as they became available for updatesImplemented Database Backup Procedures, Restoration Procedures and Disaster Recovery procWorking extensively in SQL STIG on SQL Instances and SQL DatabaseWorking on SQL and Postgres databaseImplemented Database Backup, Restoration, and Disaster Recovery-procedures and performed Contingency plans testing.Rebuilt the indexes at regular intervals for better performance.Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.Scheduled to Rebuild and reorganize the index.Performed Database administration including monitoring and tuning, job automation, maintenance task, backup recovery, analyze database performance.SQL DATABASE ADMINISTRATOR Client (US Air force), Florida June 2021 to 30 December 2022Applied SQL Server service packs and hotfixes as they became available for updatesImplemented Database Backup Procedures, Restoration Procedures and Disaster Recovery procWorking extensively in SQL STIG on SQL Instances and and SQL DatabasesImplemented Database Backup, Restoration, and Disaster Recovery-procedures and performed Contingency plans testing.Rebuilt the indexes at regular intervals for better performance.Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.Scheduled to Rebuild and reorganize the index.Performed Database administration including monitoring and tuning, job automation, maintenance task, backup recovery, analyze database performance.SQL DATABASE ADMINISTRATOR Client (US Navy), Honolulu, HI Feb 2021 to May, 2021Configured and maintained SQL Server High Availability solution including Always On, Clustering.Applied SQL Server service packs and hotfixes as they became available for updatesImplemented Database Backup Procedures, Restoration Procedures and Disaster Recovery procImplemented Database Backup, Restoration, and Disaster Recovery-procedures and performed Contingency plans testing.Rebuilt the indexes at regular intervals for better performance.SQL DATABASE ADMINISTRATOR Client (US Army), AZ May, 2020 to January 2021Configured and maintained SQL Server High Availability solution including Always On, Clustering.Upgraded SQL Server 2008/2012 to 2017 and then, migrated databases and logins.Applied SQL Server service packs and hotfixes as they became available for updatesImplemented Database Backup Procedures, Restoration Procedures and Disaster Recovery procImplemented Database Backup, Restoration, and Disaster Recovery-procedures and performed Contingency plans testing.Rebuilt the indexes at regular intervals for better performance.Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.SQL DBA Client (Elite Technical, Reston VA) July 2016 April 2020Installed and configured SQL Server 2016 and 2012 in production, Development and test environments.Upgraded SQL Server 2008/2012 to 2016 and then, migrated databases and logins.Developed Transact-SQL codes to create/update Tables, Stored Procedures, Functions, Views and TriggersConfigured and maintained SQL Server High Availability solution including Always On, Clustering, Log Shipping.Used new compression Techniques in SQL Server 2016/2012/2008 for backup and restore jobs.Scheduled maintenance tasks planned production upgrades and capacity planning.Checked Database Health by using DBCC Commands and DMVS.Applied SQL Server service packs and hotfixes as they became available for updates.Scheduled DBCC and update statistics on databases to ensure data consistency and better performance.Implemented Database Backup, Restoration, and Disaster Recovery-procedures and performed Contingency plans testing.Rebuilt the indexes at regular intervals for better performance.Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.Database Administrator Verizon, Ashburn, VA Feb. 2015 - Jun. 2016Installed, Configured, and Maintained SQL Server 2008 R2, 2012, in development, test, and production environments.Supported day to day operational activities for the database platform like service requests and tickets, monitoring, performance tuning, troubleshooting long-running queries, locks, deadlocksAssisted developers with code enhancements, tuning of queries and indexing the tables.Built and maintained SQL Server Hot/Warm Standby and Ad-hoc replication.Designed and implemented Disaster Recovery strategy using SQL Server Log Shipping, Database Mirroring and Failover Clusters.Performed Query Optimization, Debugging, Tuning, and Improvising to improve performance of the databases.Used SSIS package, Import/Export utility, and BCP command to move data between different platforms.Assisted in creating and executing SSRS packages for the purpose of reporting and analysis.Monitored memory, CPU utilization, disk utilization, locks, deadlocks and run-time of queries.Implemented Replication Models including Transactional, Peer-to-Peer, Merge, and Snapshot.Performed Database administration including monitoring and tuning, job automation, maintenance task, backup recovery, analyze database performance. |
