Joseph Dickson Email & Phone Number

Menifee, Ca, Us

Highland Heights, Oh, Us

• Provisioning Databases and configuring appropriate HA/DR strategy based on the RTO/RPO of the business Division • Configuring, Maintaining and troubleshooting Log shipping, Mirroring, Always On Availability Groups, SQL server Failover cluster on Same and multiple subnet. • Carrying out performance tuning task on a regular basis on issues ranging from query tuning to index optimization, TempDB issues, to IO, High CPU usage, severe blocking, long running query, always on out of sync, mirroring out of sync, log shipping out of sync. • Maintaining SQL Server Cluster setup and configuration • Weekly Patching of Standalone and Cluster instances • Migrating and Upgrading SQL server from Legacy to 2014, 2016, &2017 ▪ Managing permissions and security. • Monitoring daily, weekly, Monthly and quarterly Maintenance Task, ensuring that its successful and jumping into resolve issues when it fails ▪ Automation of repetitive task Using PowerShell. • Maintaining database space issue, resolving excessive log growth issue, and Normalization of DBs • Worked with other team members to implement changes to server, instance and database. • Provide regular supports to application owners and developers • Deploying changes and rolling back changes from production. • Working with team in an agile environment. • Creating SOPs for fixing, configuring, and maintaining DBs • Supporting 2005, 2008, 2012, 2014, 2016, 2017, 2019, Azure SQL, Azure Managed Instance, SQL VM Instances both on premises and in the cloud.

• I was responsible for installing, configuring and maintaining SQL failover clustering for Production Environment. • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various users. • Maintained Database Located in NY4 and LD4. • Weekly Refreshing Database for analysis and Developers Update • Using T-SQL stored procedures to automate task • Migrated SQL server 2008 to SQL Server 2012, in Microsoft Windows Server 2012 Enterprise Edition. • Migrated database from on premise to Azure Cloud • Installed and administered 2-Node cluster Active /Passive on Microsoft Windows Server 2012 Enterprise Edition, Active=NY4, Passive=LD4 • Securing Database with Transparent Data Encryption TDE • Rebuilding the indexes at regular intervals for better performance • Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented. • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency. • Monitored and modified Performance using execution plans and Index tuning. • Perform SQL Server service pack and Windows Service pack patches and upgrades. • Working with customers on Application rollouts and server migrations. • Extensively worked on Enterprise Manager for managing the database. • Troubleshoot performance problems and fine-tuning of databases. Environment: SQL Server 2008, SQL Server 2012, windows server 2012 R2, 2014, 2016, 2017.

• Implemented Always-On Availability Groups (AAG) and HA/DR Setup and Configuration • Performed Regular Backup and Maintenance Jobs across the 150 Database Managed • Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition. • Installed and administered 3-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment. • Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012. • Migrated database from on premise to Aws Cloud • Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS). • Rebuilding / monitoring the indexes at regular intervals for better performance. • Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions. • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency. • Involved in Source Data Analysis, analysis and designing mappings for data extraction using log shipping. • Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases. • Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers). Environment: SQL Server 2008, SQL Server 2012, 2014, windows server 2012 R2,