• Over 10 years of experience in SQL Server Database Administration experience including 2019, 2016, 2014, 2012, and 2008R2 on Standalones, and Clustered environment.• Performance Tunning, using Performance Monitor, SQL Query Analyzer, DMV’s, Execution plan, Indexing, Index Statistics, updating, and Index Optimization.• Configure Idera Diagnostic Manager to monitor SQL server instances.• Worked with Application Developers to design databases, tables, and Views, User defined data types, Triggers, Stored Procedures, to support Development activities and achieve optimal efficiency.• Implemented data filegroups to improve the performance of the large table, reduce contention and increase the availability of data.• Create and maintain linked server objects to assist in cross-instance queries.• Track the data growth, provide recommendations to management for scalability, and storage space requirement, and implemented recommendations.• Configure and managed SQL Transactions and Snapshot Replications.• Configured and managed SQL Log Shipping.• Configured and managed SQL Mirroring.Configured and Managed SQL Failover Clustering Active/Passive.• Configured and managed SQL Server 2019 Always on 3 NODES Replicas Configurations. • Perform quarterly DB Patches and Hit Fixes and Data STIGs.• Conduct biannual DR testing with the Apps, DB, and Infrastructure teams.• Operating System Installation and support Windows Server 2019, 2016, 2012, 2008 R2, Standalone , and Clustered environment.• Manage the client environments using Remedy Ticketing System and Zendesk.• Ability to learn and adapt to new technologies quickly.• Sr. SAP HANA Database Administrator, Healthcare/Financial and client application support using SAP HANA 1.0 and HANA 2.0 HANA Systems.• Production 24/7, Test and DEV support and maintenance over 7 years.• Configure SAP HANA High Availability, Multitenant Database, and Fault Tolerance.• Configure SAP HANA Cockpit and HANA Studio.• Support SAP HANA System Administration using SAP HANA Cockpit and HANA Studio.• Implement SAP HANA Table Management and techniques in data compression, table partitioning, loading and unloading tables into the memory.• Implement SAP HANA Security strategies for the admin and users.• Support the SAP HANA Applications and SAP HANA System Monitoring.• Implement SAP HANA Database and Disaster Tolerance• Troubleshoot SAP HANA System and Performance Tuning.• Implement SAP HANA Backup and Recovery strategies.
-
Sr Sql Server Sap Hana DbaSoftnet Ventures Inc Nov 2018 - Sep 2024• Softnet Ventures is a Managed IT Services provider, and a Software design company, managing its client databases in Production SQL 2016-2019.• Responsible for day-to-day operations for Production, UAT, and Development environment.• Database Backup & Recovery Plans in On-Premise Data Center.• SQL Agent jobs, tunning Stored Procedures, Indexes, Code Reviewing, and Query Optimization.• ETL SSIS, SSAS, and TSQL developer, supporting the client Data Warehouse and Data Loads.• Applied STIG/Security based on STIG guidelines on the SQL Server.• Configure and maintain the SQL Transactional and Snapshot Replication.• Applying patches on the Servers.• Configured and managed SQL Server 2019 Always on 3 NODES Replicas.• Configure SQL 2016 Active/Passive in the VMWARE environment.• SQL Migration from on-Prem to Azure laas Infrastructure VM SQL 2012 to SQL 2016.• Manage the Azure SQL Database Performance by increasing the DTUs for Premium SKU for Premium Storage.• Support AZURE SQL DBA administration task.• Tune database instances and applications and recommend changes to improve database performance.• Configure SAP HANA High Availability, Multitenant Database, and Fault Tolerance.• Configure SAP HANA Cockpit and HANA Studio.• Support SAP HANA System Administration using SAP HANA Cockpit and HANA Studio.• Implement SAP HANA Table Management and techniques in data compression, table partitioning, loading and unloading tables into the memory.• Implement SAP HANA Security strategies for the admin and users.• Support the SAP HANA Applications and SAP HANA System Monitoring.• Implement SAP HANA Database and Disaster Tolerance• Troubleshoot SAP HANA System and Performance Tuning.• Implement SAP HANA Backup and Recovery strategies. -
Sr. Sql DbaAplus Financial Mar 2012 - Oct 2018• Aplus Tax & Financial is a Financial Institution, works closely with the application team in the Production SQL 2014 - 2016, in Physical and VMWARE environment.• Create Tables, Indexes, Stored Procedures for the Client Vendor Application.• Load multiple data from MySQL 8.0 and Oracle 11g into SQL 2016.• SQL Migration 2012 to 2016 on Prem.• Implement SQL Server 2016 Always on 2 NODES Replicas.• Data Consolidations from Oracle, CSV, Excel, flat files into SQL 2016.• Maintenance the backups/restores process.• Manage and Support Active/Passive in SQL 2016.• Configure Always On Availability Groups 2 NODE.• Restructured the Data and user security privileges.• Manage the data performances.• Configure the Log Shipping.• Configure the Replications.• On Prem SQL 2014 Migration to AWS RDS Instance.• AWS Manage Instance Migration SQL 2014 – SQL 2016 EC2 Instance.• Manage the AWS MSSQL Database Administration, in RDS Instance.• AWS SQL Server Database Backup and Restore using S3 Bucket. • Performed Production DBA task, part of the on call support, on Oracle 10g administration.• Collaborated with various teams on multiple projects.• Support the RMAN Backups/Restored.• Build database schema, tables, procedures and permissions.• Maintained the Database Segments and the TABLESPACE growth.• Maintain the system and platform for availability.• Evaluated and recommends new database technologies• Implemented and maintained database security and encryption.
-
Sql Database AdministratorWellpoint Mar 2011 - Feb 2012WellPoint is a Healthcare Organization comply with HIPAA Compliance.• Implement new data models in their current environment.• Support the day-to-day operations.• Configure and support SQL 2012 Active/Passive.• Configure and support SQL 2008 R2 Active/Passive.• Configure and support Transactional Replication.• Create and manage the user permissions.• Create and support the data load process.• Work on performance tuning on the databases.• Create and support the ETL SSIS packages.• Applying patches on the Servers.• Implement Back/Restore strategies.• Participate in the on-call 24X7 support for all production, UAT, and development databases.
Frequently Asked Questions about D Williams
What is D Williams's role at the current company?
D Williams's current role is Sr SAP HANA SQL DBA at SOFTNET VENTURES INC.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial