Jonathan H. Email & Phone Number

- Work closely with security team to identify and remediate security vulnerabilities. o SQL: From 42% compliance to 80% compliance, with 11% Risk Acceptance. o Mongo: From 38% compliance to 96% compliance, with 4% Risk Acceptance. - Yearly assist with internal SOC2 audit. - Developed triggers to stop unauthorized access granting, log server and database roles change, and alert and escalate the incident. - Automate patching SQL Server AG with PowerShell scripts. - Establish and maintain backup and recovery policies and procedures.- Perform database refreshes, cloning, backup, and recovery.- Performance tuning and optimization (PTO). - Perform advanced problem determination and root-cause-analysis.- Identify SQL end of life and migrate to latest and greatest SQL version- Standardize SQL server configurations for new built SQL server. - Migrating End Of Life (EOL) SQL servers to latest SQL version. - Monitor and resolve alerts (blocking, disk space, failed jobs, etc.). - Take care of service request and incident request with in SLA. - Modifying existing SSIS package to collect data.

- Monitored and resolved alerts (blocking, disk space, failed jobs, etc.). - Took care of service request and incident request with in SLA. - Managed database access. - Created standard operating procedure for database backup and recovery. - Worked with implementation team to do capacity planning for new clients. - Installed, Configured, and maintained database servers.- Performance tuning and optimization (PTO). - Created reports for managers to review audits of each client.

- Installed and configure SQL Server Reporting Services. - Developed various CPT and ICD reports. - Monitored and resolved SQL jobs failures for all environments. - Deployed database changes to production. - Created SQL job for index maintenance. - Performance tuning and optimization (PTO).

San Diego, Ca, Us

- Maintained backup and recovery for DEV/QA environments. - In charge of database security for DEV/QA environments. - Created a standard operating procedure for database deployment. - Automated tables, stored procedures, functions, and schema changes deployment to DEV/QA/UAT environments. - Optimized stored procedures used in reports.

- Worked with customers in order to develop new reports to automate manual processes. - Developed test plans for server replacement and migration. - Developed stored procedures for invoice process and trip scheduling. - Developed DTS for importing data. - Project Lead on 'Paper less Pride' team and on Yard Management System upgrade. - Project lead on iTLS application migration (save warehouse division 3000 – 4000/monthly). - Application support on production database and software support on Yard Management System application

Bs, Computer Science

Bs, Computer Science