- Introduce SSH Agent and Agent Forwarding to discontinue putting users private keys on servers- Write PHP, Bash and SQL scripts to do ETL.- Maintain backend data synchronization applications and external data source retrieval applications- Perform Code Review- Generate Synthetic Data for Developers and QA using PHP and Python Faker libraries- Major participant in troubleshooting/resolving P1 incidents.

- Database Tech Lead- Manage and administer database systems according to the company's policy.- Monitor and manage back-end data synchronization applications and external data source retrievalapplications- Troubleshooting and remediate Application/Database/User connection issues and performance issues.- Perform performance Tuning of queries and database engines- AWS Cost optimization- Maintain and refresh non-production databases using a combination of Shell Scripts, SQL, AWS CLI, Git, Docker Containers and Phinx Migrations.- Maintain Phinx Migration Git repository allowing DevOPS to include Database Changes in their Jenkins CI/CD pipelines

Troubleshooting: - DocASAP web application code defects and configuration issues - Integration issues with Client Systems (NextGen, Epic, Cerner, Athena, GE Centricity) :- EPM configuration issues through UI and database :- HL7 message communication failure :- HL7 message processing failure through application logs and database records :- JSON web service message failure through Apache Tomcat logs, Apache Httpd logs and database recordsWrite PHP scripts to do ETLInstruct and assist clients with configuring winHttp TLS on MS Windows ServersUse Grep and Sed from command line or shell scripts to search/replace strings or Regex patterns in Log, Config and or Source Code files Maintain Jira Automation scripts written in Laravel PHPPerform functional QA test Train new team members

- Managed and administered Database Servers according to company's policy.- Performed daily system checks on all production and hot-site servers (Windows, Unix and AS400).- Configured Double-take server and database replication- Monitored Double-take (used to replicate windows servers and MSSQL Server database) and Mimix (used to replicate AS400 server and DB2 database) replication services.- Installed database server patches and upgrades- Performed daily and weekly backups of AS400 Server.- Participate in Business Continuity and Disaster Recovery Planning- Participate in Business Continuity and Disaster Recovery Testing - Performed AS400 and Horizon trading system user administration.- Created database for applications created in-house.- Created SQL queries/stored procedures and or Crystal reports to extract trading data as required by the different departments.- Created SQL Table Valued functions and or DevExpress Xtra reports to extract data from Depend Central Securities Depository (CSD) system as required by the different departments or Member dealers.- Global Vision trading system user administration.- Depend Central Securities Depository (CSD) system user administration.- Assisted with user acceptance testing and act as a liaison between end-users and software vendors (Percival Software and Trayport Inc).- Performed ETL on the Registrar Services Unit (RSU) new clients (certificate) registers. - Maintained all in-house developed software applications- Build and installed (manually and through group policy) MSI packages- Wrote/maintained application user guides and technical documents. - Created ETL process to copy client transactions and holdings from CSD database to website statement warehouse database. - Resolved issues for clients that have difficulty viewing their online statements. Link: www.jamstockex.com