Manville, New Jersey, United States
Senior MS SQL DBA, SME Specialties: Performance tuning and optimizations, PHI PCI compliance and security, migrations. AWS, Right-sizing
• Acquired public clearance. • Perform on call duties for sensitive corporate and federal instances. • Worked on incident analysis and optimizing alerts and improving monitoring. • Performed multiple POCs on monitoring used in the company and proposed future vendor software and internal automation tools. • Worked on new build document for SQL 2022 and reviewed existing documents. • Detected an issue with networking, documented the behavior and worked with team on solution preventing slowness. • Provided performance tuning analysis and solutions to numerous incidents. • Participated in DR testing. • Provided database expertise in migration projects and oversee changes • Monitored AG and fixed issues with HA • Implemented and Maintained SSL encryptions
• MS SQL Subject Matter Expert leading team of 6 offshore HCL SQL DBAs • Provided performance tuning analysis and solutions to numerous incidents. • Review health and optimized configuration on AWS 71 EC2 and 12 RDS instances saving $361k yearly and $140k in licensing. • Review and approve numerous work instructions, checklist, IQOQ documents and other internal documents reports and publications. • Worked on incident analysis and on automating and reducing the number of common issues. • Review and improve standard security measures, reporting and detection method. • Provide technical guidance and monitoring progress of work of L1 and L2 DBAs
• MS SQL Subject Matter Expert leading team of 6 offshore HCL SQL DBAs • Provided performance tuning analysis and solutions to numerous incidents. • Review health and optimized configuration on AWS 71 EC2 and 12 RDS instances saving $361k yearly and $140k in licencing. • Review and approve numerous work instructions, checklist, IQOQ documents and other internal documents reports and publications. • Worked on incident analysis and on automating and reducing the number of common issues. • Review and improve standard security measures, reporting and detection method. • Provide technical guidance and monitoring progress of work of L1 and L2 DBAs
• Provided technical leadership and guidance to team of 4 DBAs • Fixed the slowest queries, automated and improved reporting, support SharePoint. • Improve security for HIPAA compliance, introduced and implemented encryptions, hashing, masking, access and identity management and other security measures. • Performed quarterly internal DB audits and reviews, resolved vulnerability issues, • Participated in datacenters migrations and perform AWS migration. • Maintained VLDB 8TB OLTP, perform optimization tasks, trimming and archiving.
• Provided 8 times performance gain on main server, optimized 4 other SQL servers • Performed data cleansing, quality checks, data integrity checks. • Utilize reverse engineering to create a logical DB design in effort to prepare data base for migration and mapping to new system.