Sql Server Disaster Recovery

Name: Aziz Karim

Email: ******@*****.***

Experience Summary:

20+ years of SQL Server and 3+ years of Azure and cloud platform experience

Troubleshooting performance using extended events, dmv, perf monitor, profiler, trace, index tuning and stats.

Hands on experience in database design and architecture. Defining keys, indexes, normalization, tables, triggers and partitioning

Experience in database consistency, health check, data integrity, data encryption, data audit and compliance.

Solid experience in large and high transaction database systems

Experience in SQL Server BI tools including SSIS, SSRS and SSAS

Proficient in PowerShell and automating daily DBA repetitive tasks

Hands on experience in performance tuning and Resource Governor.

Extensive knowledge with disaster recovery, data archiving and standby systems

Work with SQL Server HA including Always on, replication, mirroring, log shipping and clustering.

Work with complex T SQL, stored procedures, and reports

Experience in TSQL, Azure SQL, MySQL and very familiar with MongoDB, Postgres and CosmosDB, NoSQL and AWS RDS

Experience in azure and AWS migration

Experience in Windows server admin, Active directory, Group policies, DNS, DHCP, SQL Server and network security, 3rd party monitoring tools, health check, protocol security and security patch

Hands on experience in Azure AD and email security like Mimecast, barracuda

Hands on experience in endpoint security policies and threat protection

Experience in Ransomware attack and disaster recovery

Worked in an agile and devops environment

Education:

Texas A & M University at Kingsville, TX 1991- 1992

Master's degree in chemical engineering major and Computer Science minor

Bangladesh University of Engineering and Technology, Dhaka-Bangladesh 1985-1989

Bachelor's or graduate degree in Chemical Engineering major and computer science minor

Data Modeling Tool: ERWIN, Visio.

Additional Training:

Power BI, Endpoint security, Identity, and threat protection, Multi factor authentication, azure cloud, data warehouse, data factory, SQL Server 2022 Administration, Always on Availability, SQL Azure and AWS, and Data factory and data lake, Cohesity, ITIL Foundations, Argos report, DACPAC

Technical Skills:

Database Management and clients:

Database development, management and design starting with SQL Server 6.5 and all the way to SQL 2022. MySQL, puTTY, PostgreSQL, MS Access

Programming: T SQL, Object-oriented programming with Visual Basic, C, PowerBuilder, MS Access, PowerShell, SharePoint, Linux shell scripint, Agile and devops

SOC against cyber-attack: CrowdStrike, Sentinel one. Knowledge of ISO 27001 SOC controls

Monitoring tools: Azure Monitor, Logic monitor, Cisco USC, Meraki, Nagios, Workspace one, Mimecast, Knowbe4, and Varonis

Data Monitoring tools: Idera, Confio, Redgate, Sentry one, SQL Performance tools, Profiler, CDC, Query Analyzer, Ignite

ETL Tools: All BI Tools, Data factory, Data integration SSIS, SSDT, Reports SSRS and Data analysis SSAS.

Operating Systems: Windows 2019 and older system administration.

Work History:

Marian University, Indianapolis, IN Oct 2022 – July 2024

SQL Server DBA and Developer

Maintained SQL Server and query performance

Created financial, census, tax and confidential reports, census report.

Database administration and architect by Installation, patching, performance tuning, disaster recovery

Automated daily jobs. Setup all alerts to monitor 24X7

Automated jobs using sftp, SQL Agent job, Task Scheduler and PowerShell

Colleague system administration. Cloning from prod to test.

Monitored and managed the resources proactively. Worked closely with the customer.

System administration. Server patch, maintaining certificates, Maintain TLS or SSL patch.

Penetration Test, Identify risks, perform risk analysis on SQL Servers.

maintained data quality, data consistency and data integrity

Migrated database to cloud.

BCforward, Indianapolis, IN Aug 2018 – Feb 2022

Sr Database Admin and IT Operations team lead

Designed and supported a large SQL migration to Azure. Used upgrade advisor.

Monitored and troubleshot server and query performance. Used perf monitor, extended events, DMV, profiler etc.

Performed and monitored SQL Server best practices, health checks and patches.

Proficient in PowerShell, Azure shell, Azure migration and Azure CLI

Oversaw all systems security including email gateway, DLP, security audit, firewall, end points and data protection.

Supported SQL Server 2014 and above. Including installation, patches, configuration, health check, alerts, backup, restore, disaster recovery etc.

3 years of experience in various azure technologies (e.g., Virtual Machines, Storage, Network, Azure Automation, Azure Backup and Site Recovery Services, Security) to develop and maintain an Azure based cloud solution, with an emphasis on best practices and cloud security.

Pros and cons of all Azure SQL service-related offerings

Supported Active Directory and Email security policy setup using SPF, DKIM and DMARC

Supported Azure SQL,mySQL and NoSQL, PostgreSQL, and Cosmos DB

Designed and architected cloud computing services in one or more of the following areas: Security, alerts, Compute, cost, growth, Data and Storage, Networking.

Used azure log analytics and monitoring tools

Managed a team of 4 System administrators and Network administrators.

Setup endpoint security management, threat protection, Identity and MFA.

Supported systems on Azure and hyper V and vSphere

Supported Microsoft Dynamics and combining it with erecruit ATS or ERP

Remote access management

Bloom Insurance Agency, Bloomington, IN

Sr DBA and Developer Dec 2015 – Jun 2018

Troubleshoot any performance issue and figure out optimal configurations.

Setup and managed SQL replications

Migrated databases from SQL 2005 to SQL 2012 instance

Setup and troubleshoot replication

Implemented NetLib, transparent encryption with key management

Setup a SQL native Column encryption with key rotation and TDE

Checked overall SQL server health issue and implemented best practices

Setup Redgate Monitoring and troubleshoot all Redgate issues

Installed and maintained SQL instances on clustered environments

Created and migrated SSIS 2016 packages using Visual Studio 2017, SSDT and SFTP

Created SSRS reports.

Used PowerShell script to perform daily maintenance and automated maintenance

Setup Database, column encryption and always encryption for HIPAA compliance

Worked with database design. Structure and storage

Proactively monitored all SQL issues

Used Redgate and SQL Clone

Worked in Agile, Devops and DACPAC

Used T SQL to write sprocs, triggers and views

Key Benefit Administrators, Indianapolis, IN Dec 2014 – July 2015

SQL Developer

Converted DTS packages to SSIS

Migrated databases from older version to SQL 2012

Work with Log shipping and replication

Worked with SSRS reports and security. IIS and deployment.

Used VB/.NET and TSQL code within SSIS

Converted data from non-SQL Server to SQL Server

Performance monitoring and TSQL tuning.

Navient (formerly SallieMae) Fishers, IN Nov 2013-Nov 2014

SQL DBA

Migrating databases for their new split company.

Supported SQL Server in a cluster environment. Install, patch, support and manage databases.

Supported large databases. Use replication and active – passive cluster.

Build script to make reports and jobs, alerts, monitor security and other health checks

Improved installation process and documenting.

Recovered databases from a disaster.

Setup CDC and worked with CDC

Used Idera, SQL data collection and my script to monitor disk space, performance counters, security etc.

Used SSIS, NetBackup and SQL agent backup

Used Resource Governor and MAXDOP

Used DMV and third-party tools to improve performance

Perpetual Technologies, Inc., Indianapolis, IN Oct 2011 – Oct 2013

Senior SQL Server DBA and Supervisor

Provided after-hours support for a client with very high-volume transactions and large-sized databases.

Monitored 24/7 activities, DB performance and disk space on highly available cloud servers

Worked in a clustered system. Used log shipping and replication and Change data control

Used DMVs and Ignite to monitor performance

Worked with data Extraction, Transformation and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS), creating and deploying packages

Experience in creating and using Stored Procedures, Views, User Defined Functions, Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.

Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables.

Strong knowledge of MS system-based server system administration and storage technology SAN.

Supervised a 24/7 on call database support team

Managed a MySQL database and Kayako helpdesk ticketing system

Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.

Eli Lilly and Company, Indianapolis, IN Aug, 2005 – Aug, 2011

Senior SQL Server DBA

Used SQL Server Reporting Services SSRS to monitor all servers. Like backup, disk space etc.

Developed a PowerShell script to install SQL Server unattended.

Worked with Replication and mirroring. Two-way immediate update transaction and merge replication.

Monitored and improved performance. Used SQL Server Audit, Perf monitor, profiler, or trace, tempDB and index tuning etc.

Setup policy-based monitoring for all SQL Servers

Put standard in place to ensure all instances meet the minimum requirements

Used two-way immediate update transaction and merge replication

Supported many SQL Servers (>700) and big (>100 G) databases.

Developed a tool to automatically monitor backup, disk space, change password for sa account and monitor other vital information. Used SQL alert and SQL mail.

Upgraded SQL Servers to SQL 2005 and 2008.

Used oracle 9G installation, Unix script, RMAN

Migrated databases between different servers and performed disaster recovery.

Contact this candidate