Steven Locke's Location
Allegany, New York, United States, United States
About Steven Locke
I am a full-stack engineer passionate about designing and implementing scalable and maintainable systems. I have architected and built horizontally scalable back-ends; distributed RESTful API services; and web-based front-ends with modern, highly interactive Ajax UIs. I also have a keen eye for optimizations in SQL queries and middle-tier code. I have used these optimization skills many times with drastic performance improvements.ToolsPython, C/C++/C#.NET, Vb.NET, Javascript, SQL, PSQL, TSQL, PHP, Coldfusion, Adobe FlexOracle, Postgresql, SQL Server(MsSql), Redis, MySql, MongoDb, SSIS, Kettle(Pentaho)Ajax, JSON, HTML5, CSS3, XML, OauthPyramid, SQLAlchemy, MVC4, WPF, Linq, Entity Framework, Jquery, Nginx, Gunicorn, Waitress, Apache, IIS, NServiceBus, RabbitMQ, MsMqDocker, Dokku, VirtualEnv, Vagrant, VirtualBoxBsd, Linux, Mac OS X, WindowsTechniquesObject Orient Programming (OOP), Declaritive Programming, MVC, MVVMDistributed Architecture, Service Oriented Architecture (SOA), Domain Driven Design (DDD)OLTP Database Schema Design, Data Warehousing (Star Schema)DRY-Don't Repeat Yourself, KISS - Keep It Simple StupidQualitiesSelf-directed, driven, passionate, and persistentFocused and detail-orientedExcellent troubleshooting skillsTalented at creating innovative solutions to unusual and difficult problemsWork well in a team environment or individuallyGreat communication skills
Steven Locke Work Experience Details
-
Senior EngineerBarndoor AiAllegany, Ny, Us -
Staff Software Engineer On Data Infrastructure TeamAcv Auctions Feb 2023 - PresentBuffalo, New York, UsAs a staff software engineer I am responsible for steering the direction of our data infrastructure and our data pipelines both within my team and across the organization.* Build and maintain internal airflow libraries to auto-instrument monitoring and to simplify usage of the KubernetesPodOperator* Develop internal tooling to support local airflow development in a production-like environment* Evaluated and vetted distributed database technologies to replace our 300+ RDS databases with a highly available, multi-region database platform* Modified existing helm charts to add features for local development inside of KinD* Triaged and resolved production database related SEVs* Work with the infrastructure team to build our multi-cloud airflow platform* Maintain and enhance our event driven apis backed by Kafka* Improved the reliability of our apis by setting up the framework and tooling for my team to integration test our products* Improved the reliability and performance our our CI/CD pipelines -
Senior Software Engineer On Data Engineering TeamColor Sep 2021 - Nov 2022Burlingame, California, UsAs a senior engineer on the Data Engineering team I used my experience of building stable, efficient, and maintainable pipelines to bring stability, monitoring, and maintainability to a system prone to consistent failures and incidents.* Implemented and maintained database replication* Led the effort in containerizing the codebase to support running in kubernetes* Converted collection of cron jobs and celery jobs to airflow tasks by containerizing using the KubernetesPodOperator* Incrementally made improvements to a constantly failing and unsustainable etl pipeline developing a very stable system* Converted etl jobs written in Django models into a standard ELT pipeline built on BigQuery -
Devops Technical LeadAledade Inc Apr 2021 - Aug 2021New York, New York, UsAs a technical lead on the devops team I rolled out improvements to our systems with an increased responsibility on training and mentorship of other engineers* Led core initiatives to automate system integrations and reduce engineering toil* Worked across engineering and non-engineering teams to compile requirements for large system transitions* Utilized AWS and Kubernetes skills to continually increase security and stability across systems* Mentored other engineers on design principles as well as troubleshooting* Automated our database RBAC with our identify management software using terraform and python -
Senior Software Engineer, DevopsAledade Inc Sep 2019 - Apr 2021New York, New York, UsAs a software engineer on the devops team I was tasked with investigating better ways to process our data, setting up maintainable RBAC systems for our growing number of databases and users, and maintaining/improving our existing ETL process as well as setting standards.* Led many complex projects often simultaneously* Investigated and implemented improved data pipelining techniques to utilize big data solutions* Migrated 12Tb EC2 postgres database to RDS under a very tight deadline without complications* Migrated our EDW (Enterprise Data Warehouse) over to snowflake by shipping parquet extracts of our large RDS database to s3 and importing into snowflake daily* Docker-ized our terraform repo and schedule automated terraform operations inside airflow in Kubernetes
-
Senior Software Engineer, Data ArchitectureAledade Inc Oct 2016 - Sep 2019New York, New York, UsResponsible for ETL of data, building data products, and balancing the need for quick iterations with data integrity and scalability.* Worked daily with tables with hundreds of millions of rows to billions of rows* Processed massively complex medical data from CMS (government) and private sector companies* Converted massive SAS programs into SQL with data validation* Designed and implemented a data warehouse and custom etl framework* Ported existing airflow infrastructure into our brand new Kubernetes environment* Created developer tooling for managing developer's personal airflow instances
-
Technical Lead On Infrastructure/Architecture TeamLiazon Apr 2015 - Oct 2016Buffalo, New York, UsThis is an architect++ role that allows me a wealth of exposure to every aspect of the system and allots me some freedom to create proof of concepts to improve our system and move the technology forward.Provide maintainable solutions to major system deficienciesProvide guidance on working within our currently transitioning architectureIdentify and develop solutions to system bottlenecks and performance problemsPersonally audit all migration scriptsAll schema changes must be approved by meDatabase tuningMaintain database replication and currently integrating into the development life cycleDevelop tooling used by the entire development teamPersonally responsible and accountable for 11 production environments including database, redis, and IIS serversTroubleshoot production "fires"Provide support to feature delivery teams in whatever form necessary -
Software EngineerLiazon Dec 2013 - Apr 2015Buffalo, New York, UsBuilt consumer facing Ajax-driven components and pages utilizing MVC 4 frameworkUtilized SSIS to cleanse application data and store in a Data Warehouse used for reportingDesigned complex SQL queries to meet customer’s reporting needs. Data accuracy was crucialContinually drove to improve data accuracy and the reporting infrastructureConfigured and maintained reporting databasesBuilt templating system allowing customers to save customizations to report outputsOptimized existing code base improving performance in some cases by 90%+
-
Software EngineerValuecentric Jul 2012 - Dec 2013Designed and developed Ajax-driven report management tool which utilizes JavaScript name- spacing and prototyping to create a maintainable object-oriented JavaScript applicationPlayed a major role engineering the back-end for the new reporting system under an extreme deadline. This required working closely with other developers to ensure that we as a team produced a sane, maintainable framework and minimized cutting corners.Optimized existing reporting queries as well as troubleshot query bugsMaintained and enhanced the reporting engine that generates and queues the reporting queriesDrove continual improvement to the framework by re-factoring legacy code
-
Web DeveloperStogieboys Mar 2012 - Jul 2012UsWorked on a team of two developers maintaining and enhancing features on a small e-commerce applicationCreated and modified a number of admin utilities used by the sales team to maintain the e-commerce siteMade major over-hauls to the checkout code base which frequently miscalculated discounts, coupons, and taxes under certain circumstancesSignificantly reduced page load times by consolidating a number of queries that were performed in a loop into single efficient queriesImplemented Mantis ticketing systemIntroduced and implemented Git version controlCreated ajax driven search components -
Quality EngineerSynacor Aug 2011 - Mar 2012Buffalo, New York, UsAs a quality engineer I actively worked with developers to ensure the client received quality software. Designing detailed test cases and test plans was a crucial job responsibility that drove automated regression testing as well as manual testing.• Developed and enhanced internal tools utilizing PHP/Jquery/Javascript/MySql• Investigated and isolated design problems utilizing strong analytical skills• Utilized GIT version control software to track changes to the code base during development and testing• Created detailed training documentation• Worked closely with the engineering team to continually improve procedures -
Computer Operations AssistantAllegany Arc Jul 2008 - Aug 2010Working closely with the network administrator I maintained a network of five servers, 130 desktop computers and laptop computers dispersed across ten facilities in an Active Directory Microsoft network. My job duties included hardware and software troubleshooting as well as upgrades, network troubleshooting, and user education.• Designed web pages utilizing asp, php, html, and css skills learned on the job• Developed vbscripts and batch scripts to automate active directory changes to networked computers and perform bulk maintenance.• Developed efficient methods of imaging/re-imaging computers utilizing batch scripting and cloning software.• Saved company over $8,500 of man hours and software licensing costs by researching and implementing open-source alternatives to streamline IT operations.• Developed and implemented debian based thin clients utilizing recycled agency computers marked for disposal.• Worked closely with the network administrator to upgrade the network from a Novel network to a Microsoft network.• Prepared and taught agency wide training sessions on Microsoft Office 2007
-
Student Pc TechnicianSuny Fredonia Helpdesk Jan 2006 - Sep 2007Performed maintenance and troubleshooting on desktop and laptop computers at a campus with over 5,000 students and over 1,000 employeesResolved network issues such as mapped network drives, connectivity issues, speed issues, and network printersInstalled software, maintained hardware, transferred files, and re-imaged computers
-
Technical Support Representative, Tier IAdelphia Communications Jan 2005 - Jun 2005Provided technical support concerning high-speed internetProvided support for billing inquiriesWalked users through installation of equipment, restarting modems, setting TCP/IP settings, and addressed billing concerns
Steven Locke Education Details
-
State University Of New York At FredoniaMathematics
Frequently Asked Questions about Steven Locke
What company does Steven Locke work for?
Steven Locke works for Barndoor Ai
What is Steven Locke's role at the current company?
Steven Locke's current role is Senior Engineer.
What schools did Steven Locke attend?
Steven Locke attended State University Of New York At Fredonia.
Free Chrome Extension
Find emails, phones & company data instantly
Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Aero Online
Your AI prospecting assistant
Select data to include:
Total price:
$0.00
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