Mark K. work email
- Valid
- Valid
- Valid
- Valid
Mark K. personal email
Mark K. phone numbers
• Lead Database Engineer with a software engineering and database administrator background. I have over 20 years of professional relational database experience, and 15+ years software engineering and DBA experience.• Expert-level knowledge of writing complex SQL queries, transaction management, stored procedures, indexes (columnstore, filtered, full-text, includes), database/schema design, ETL/ELT, query execution plan analysis, performance tuning, database internals, views, functions, triggers, partitioning, high availability, disaster recovery, replication/distributed databases, and supporting large-scale, high volume OLTP database systems in both on-premises and cloud environments (Azure/AWS/RDS).• Proficient in designing, building and supporting large-scale, high-transaction OLTP database systems using SQL Server, PostgreSQL, MySQL, and Snowflake in both on-premises and cloud environments (Azure/AWS/RDS).• Experience with automating and streamlining processes, designing Windows, Linux, Web, and mobile applications using various technologies, including .NET/C#, SQL Server, Node.js, Java, ASP.NET Core, MVC, REST web services, and Amazon AWS/Azure.• Financial services experience building high-performance trading solutions for a cryptocurrency exchange.
-
Lead Database EngineerHireology Feb 2024 - PresentChicago, Il, Us▪ Supported multiple PostgreSQL database clusters on Linux VM’s in AWS. Currently creating migration plan for moving the database infrastructure from AWS to Azure, as well as building near real-time pipelines to Snowflake.▪Supported custom in-house ETL and reporting processes, including reverse-engineering existing shell and python scripts to add new features, fix data issues, and troubleshoot broken pipelines. -
Senior Database EngineerSfox Sep 2021 - Dec 2023Stanford, California, Us• Designed new database tables, procedures, functions, and events for client-facing cryptocurrency trading features, including Shorting/Margin trading and Post-Trade Settlement, using deployment and rollback scripts.• Developed the internal system for charging interest on loans, allowing for flexible loan terms and custom overrides. This project generated over $700,000 in the first 15 months of operation.• Re-wrote stored procedures responsible for client-created orders, resulting in reduced execution time and fewer deadlocks.• Supported 24x7 high volume MySQL database system in Amazon RDS.• Built internal .NET/C# toolset used to create efficiency by streamlining/automating many tasks in the Data Management Team’s day-to-day operations. -
Lead Developer/Senior Database AdministratorProcaps Laboratories May 2020 - Aug 2021Henderson, Nv, Us• Upgraded the SQL Server environment from SQL Server 2008R2 to SQL Server 2019 with a multi-node, highly-available cluster using Always-On Availability Groups.• Updated internal Enterprise Warehouse Automation Tracking Application to handle the SQL Server automatic failover between nodes in the Availability Group.• Assisted with the completion of migrating the company CRM from Clarify to the internal Enterprise Warehouse Automation Tracking Application. -
Senior Software EngineerRed Dog Media Oct 2017 - Apr 2020Henderson, Nv, Us• Added new features to the company’s e-commerce website, internal desktop applications, and internal automated server processes.• Created new process for automating sitelink creation across all advertising platforms.• Re-wrote database queries that were causing home page load delays and timeouts. Provided ongoing performance tuning assistance to other engineers.• Stabilized SQL Server environment, including upgrading production SQL Servers from SQL Server 2014 to SQL Server 2017. -
Lead Developer/Senior Database AdministratorProcaps Laboratories Dec 2010 - Sep 2017Henderson, Nv, Us• Lead Developer on internal Enterprise Warehouse Automation Tracking Application using SQL Server database design/development, C#, ASP.NET/MVC web development, web services, and custom form printing.• Developed new shipping solution utilizing C#, SQL Server, web services, label printing, and USB/HID communication. This solution replaced Pitney Bowes SendSuite, saving $60,000 in development costs plus annual support costs.• Updated the SQL Server environment from SQL Server 2000 to 2008R2 with database mirroring for high availability.• Resolved issues while upgrading CRM database from SQL Server 2000 to 2008R2, saving the company more than $200,000 in back-support.• Performed standard DBA tasks, including performance tuning, ETL processes, backups, restores, environment refreshes, maintenance, monitoring, etc.
-
Database AdministratorQualcomm Apr 2007 - Dec 2010San Diego, Ca, Us• Provided support and administration for over 40 production applications in an enterprise environment.• Analyzed customer databases and provided performance-based recommendations, including efficient coding procedures, improved database design (normalization) and preferred table indexes.• Supported administration, maintenance, and performance tuning on a 6TB database.• Setup Database Mirroring and Log Shipping and performed Disaster Recovery drills to ensure all databases were highly available in the event of an emergency.• Performed multiple SQL Server 2005 and 2008 installations on Windows 2003/Windows 2008 clusters, stand-alone servers, and virtual machines.• Analyzed SQL Profiler and Microsoft HTA data for troubleshooting and database performance tuning.• Performed standard DBA tasks, including backups, restores, refreshes, maintenance, monitoring, etc. -
Senior Programmer AnalystQualcomm Oct 2002 - Apr 2007San Diego, Ca, Us• Created n-Tier server-based Windows and Linux applications in C#/VB.NET, Java, PERL, Visual Basic, ActiveX/COM, and bash. These applications supported custom ETL processes, reporting, data management and analysis, wireless network monitoring, and process automation.• Designed dynamic web applications and reports to streamline data collection and analysis for five major products, 20 Network Management Center systems, and over 200,000 mobile units.• Created the Integrated Interface desktop application which combined multiple engineering sessions into one consolidated Windows form. This significantly reduced troubleshooting time, increased employee productivity and shortened new-hire training by approximately two months.• Designed internal database auditing tool that collects metadata on over 3000 databases and 200 SQL servers. Automated data collection using PowerShell, and developed ASP web interface for reporting and administration.• Internal and external website development using ASP.NET MVC, ASP, PHP, JavaScript, AJAX, CSS, and SQL Server.
-
Technical Support AnalystQualcomm Feb 2001 - Oct 2002San Diego, Ca, Us• Performed data analysis for Qualcomm Enterprise Solutions business unit, including analyzing wireless network system data and creating reports to find network system deficiencies.• Developed an automated process to import mobile data logs and analyze system data on over 2000 OmniExpress wireless terminals.• Created a wireless coverage map showing geographical areas in which mobile units had difficulty communicating over the Sprint 3G wireless network.
-
Technical Support SpecialistQualcomm Sep 1997 - Feb 2001San Diego, Ca, Us• Created the Customer ID Search web-application, which replaced the monthly distribution of 50+ page reports to over 30 customer support agents. This tool saved thousands of sheets of paper and hundreds of man-hours no longer required to create, distribute, and file the reports.• Automated several key telnet commands used by customer support agents, reducing the amount of time needed for troubleshooting. This included a Fleet Message macro, reducing the 30-35 minute process down to 5-10 minutes.• Provided customer and technical support for Qualcomm Enterprise Solutions business unit.
Mark K. Skills
Mark K. Education Details
-
Coleman CollegeComputer Engineering
Frequently Asked Questions about Mark K.
What company does Mark K. work for?
Mark K. works for Hireology
What is Mark K.'s role at the current company?
Mark K.'s current role is Lead Database Engineer.
What is Mark K.'s email address?
Mark K.'s email address is ma****@****abs.com
What is Mark K.'s direct phone number?
Mark K.'s direct phone number is +170256*****
What schools did Mark K. attend?
Mark K. attended Coleman College.
What skills is Mark K. known for?
Mark K. has skills like Sql, Database Design, Microsoft Sql Server, Databases, Perl, Disaster Recovery, Javascript, Database Administration, C#, Java, Performance Tuning, Etl.
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