| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Shakhawat 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 server
Candidate'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 SKILL 1. Database (RDBMS): SQL Server 2008/2008R2/2012/2016/2019 2. 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, replications
6. 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 Azure
16. STIG on SQL instances and SQL Databases 17. Science logic 18. VMwareEducation Masters in Sociology (National University) Bangladesh Bachelor from Dhaka University, BangladeshStatus of Clearance Top secret/SCI (Active) CASP+
TRANNING AND CERTIFICATION Microsoft 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/2019 Administering MSSQL server 2012 Databases and 2019 Implementing Data warehouse with MSSQL server 2012 Log Shipping, Mirroring, Replication, T-SQL, SSIS, IIS Professional Training: Clustering, Log Shipping, Mirroring, Replication, Always on.Professional Experience
SQL DATABASE ADMINISTRATOR| Client (US Air force), San Antonio, TX| January 2023 to Present Applied SQL Server service packs and hotfixes as they became available for updates Implemented Database Backup Procedures, Restoration Procedures and Disaster Recovery proc Working extensively in SQL STIG on SQL Instances and SQL Database Working on SQL and Postgres database 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. 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 2022
Applied SQL Server service packs and hotfixes as they became available for updates Implemented Database Backup Procedures, Restoration Procedures and Disaster Recovery proc Working extensively in SQL STIG on SQL Instances and and SQL Databases 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. 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, 2021 Configured and maintained SQL Server High Availability solution including Always On, Clustering. Applied SQL Server service packs and hotfixes as they became available for updates Implemented Database Backup Procedures, Restoration Procedures and Disaster Recovery proc Implemented 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 2021 Configured 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 updates Implemented Database Backup Procedures, Restoration Procedures and Disaster Recovery proc 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.SQL DBA | Client (Elite Technical, Reston VA) | July 2016 April 2020 Installed 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 Triggers
Configured 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. 2016 Installed, 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, deadlocks
Assisted 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.
|
