Lior Kimchi
Senior Database Architect and DBA
Lead SQL Developer
SUMMARY:
21+ years’ experience as a SQL Developer, Data Architect and DBA.
Advanced knowledge of Microsoft SQL Server; Expert in T-SQL; Expert in SQL tuning, optimization and data modeling and 20+ years hands-on SQL Server from version 2000 all the way to 2019.
Extensive experience with logical and physical data modeling, database optimization, OLTP, OLAP, ETL/ELT, Data Warehouse, Reporting, Replication, Mirroring, High-Availability (HA), Always-On.
Performance Tuning and Optimization, disaster recovery (DR), hardening, installations, conversions, upgrades and troubleshooting, DTS, backup/restore.
Expert in all phases of software development life cycle (SDLC).
Extensive use of scripting. Over 1M lines of SQL written, debugged, troubleshooted and optimized.
Extensive BI, business-analysis and analytics experience.
Developed and managed programming guidelines, policies and procedures.
Expert on SQL Enterprise Data Encryption, Data Security and Auditing.
Project management/supervision; team lead; user training. Knowledge and application of best practices, in methodologies, technologies and industries. Agile/SCRUM.
Expert in multiple business industries: E-Commerce, Software Security, Telecomm, Finance, Banking, Stock Market, Mortgage, Warehousing, Health Care.
PCI and HIPPA certified.
Detailed oriented, “Gets the job done” guy.
Mentored new DBA’s and lectured in Microsoft events and user groups on SQL topics and skills.
EXPERIENCE:
JaggedPeak (5/2013 – 12/2019)
Senior SQL Developer, Data Architect and DBA
Managed high-transaction, high-volume real-time OLTP systems. Optimized data and indexes, developed archiving and ETL procedures to transport to data-warehouse and real-time dashboards.
Extensive T-SQL scripting, using SSMS and Visual studio on SQL versions 2000 2008R2 201*-****-**** 2017 2019. Wrote and maintained 100K+ lines of complex SQL queries, stored procedures, triggers, jobs, dmv, functions, CTE, DTS.
Created logical and physical data models for optimal DB access and performance, for both Transactional and Warehouse applications.
Worked with a large development group using Agile/SCRUM. Used JIRA for collaboration. Provided daily support to the development and QA teams and consulted on future projects. Used Tortoise SVN Version control/ change management to save and control all code.
Upgraded servers from 2008 to 2016/17/19. Updated databases, stored procedures, tables and indexes to work with new version. Managed and coded very large databases, and optimized SQL queries.
Maintained, troubleshooted and optimized huge databases (15 TB) using index tuning, wide/partition tables, Profiler, third party tools like Red-Gate toolbox and others.
Supported and worked on classified healthcare database. Used SQL Enterprise key Data Encryption and security features to encrypt data and maintain safety for HIPPA auditing compliance.
Maintained financial, bank, sales and customer data security using encryption, data masking and access control on tables and individual columns and for PCI compliance and audit.
Built and maintained hundreds of SQL servers and thousands of databases for E-comerce web sites in a highly distributed and redundant VM cloud network. Created always-on high-availability protocols and procedures and implemented them.
Installed multi-instance SQL servers on physical and Virtual machines (Vmware). Created system and SQL probes for monitoring. Created server hardening and encryption procedures for security.
Created and managed complex logical and physical database models involving multiple databases and 1000’s of tables and relationships.
Installed SQL server instances on Amazon AWS. Configured and optimized for Cloud.
Created, implemented and maintained large scale disaster recovery plans and sites (100’s multi-instance servers and thousands of DBs), using replication, log shipping, and clustering. Implemented backup/restore and recovery procedures to support aggressive SLA’s and minimize down-time.
Worked with the BI group to provide aggregated data and reports, used ETL and ELT, summarized and analyzed data in Excel to support daily statistical analysis and management reports.
Created SQL monitoring jobs, probes and tools and provided continuous support and real-time alerts.
Available 24/7 for remote support. Spent 20% of time working remote.
Supported and maintained MS Great Plains and Dynamics back-end SQL server.
Certified annually for PCI. Worked with third-party licensing group to fully certify all servers and databases for PCI compliance. Provided full documentation and detailed evidences and reports.
WellCare (9/2012 – 4/2013)
Senior SQL Developer and Data Architect
Part of a team to help implement WellCare’s Healthcare Regulatory and Compliance effort. Wellcare is on a new MMP (Medical Management Platform) using a new system (Care Advance Enterprise).
Analyzed and documented the vendor’s SQL database model and generated a dictionary for reporting.
Developed summary and Ad Hoc financial/regulatory reports in web pages utilizing Visual Studio 2008/2010 and custom reports.
Worked extensively with managers, end users and business units to gather requirements, design the queries and implement parameterized stored procedures and to design interface and feed to the system and provided training and support.
Studied and passed HIPPA certification.
Verizon (2/2010 – 7/2012)
Senior SQL Developer /Architect
Hired to consult, develop and maintain two major systems for Verizon’s call recording and IP ACD telephony systems that used SQL Server extensively as the back-end database.
Responsible for over 50 Clustered Servers in an OLTP high transaction environment installed throughout the country, consisting of hundreds of DB’s and 15TB of data.
Created SSIS packages for ETL, for preparations for reports and handling of complex business rules. Deployed packages over multiple servers and collected data in Excel and for data warehouse.
Analyzed, designed and developed custom reports using stored procedures and published to internal site using Share-Point and SSRS.
Analyzed and created security procedure and guidelines for data security on the server and DB levels using certificates, DB key encryption and data masking.
Installed and configured Windows clusters, SQL Server 2008 R2, dozens of databases, multiple topologies of replication, including star and peer to peer, one-way and two-way; multiple mirroring.
Developed and implemented backup and restore scripts and procedures, data recovery.
Coded daily T-SQL stored procedures, triggers, and database optimization. Used SVN and GIT for version control and archiving.
Migrated SQL Servers from 2005 to 2008R2 Enterprise.
Worked with the mainframe storage and networking teams to maintain and support the systems.
Provided 24/7 support for all issues. Worked with Microsoft Engineers to resolve critical issues.
Interfaced with hardware and software vendors (Autonomy, Qfiniti, Avaya, Nice, HP, Dell) to assist them install and repair their systems.
Independent Senior SQL Developer/Consultant (2-12/2009)
Contracted to assist in development of a large database+web application for retail/marketing firm.
Installed and configured SQL server 2008 R2 Enterprise servers and databases.
Created complex normalized logical and physical database models.
Reviewed and implemented database schemas received from another firm.
Used SSIS to import very large amounts of data.
Implemented business rules with constraints, triggers and stored procedures.
Worked remotely to diagnose and troubleshoot server problems.
Designed and configured Partition Tables and Views.
Debugged and assisted other developers with their SQL code.
Created and ran benchmark/performance tests and optimized performance.
Created disaster recovery plans and documented process flows and database scripts.
Advised on backup procedures and monitored server usage and logs.
Sunbelt Software (4/2005 – 1/2009)
Senior SQL Developer/Architect
Administered and developed multiple SQL server 2005 servers and databases.
Created logical and physical database models, business rules (using triggers, rules stored procs and functions), developed numerous stored procedures, consisting of tens of thousands of lines of code.
Integrated with development teams and IT to maintain and optimize the servers' performance.
Managed multiple very large high transaction (OLTP) databases (VLDB) with sizes in the 10+ TB’s, and billions of records and partitioned tables.
Analyzed and designed new physical and logical database models, imported data from external sources, worked closely with the development team and recommended improvements and new features.
Managed multiple large production SQL 2005 servers and databases, connected via web services.
Managed daily database operations, created business rules, used DTS and reporting.
Upgraded SQL Servers from 2000 to 2005. Configured hardware, installed software and updates. Configured desktop tools. Implemented replication.
Debugged issues and troubleshooted problems and provided quick and practical solutions. Diagnosed and resolved problems.
Handles issues like slow queries, deadlocks, indexing, data loss, connections, user permissions and memory configurations.
Provided support for the users via phone, email and in person.
Used SQL Server Management Studio, Profiler, Query Analyzer to analyze and debug queries.
Developed and managed programming guidelines, policies and procedures.
Used VMAWARE workstation to develop and test. Used Sharepoint to collaborate.
Provided 24/7 on call support for critical applications and systems.
Bulldog Hedge Fund (2/1999- 11/2004)
Senior SQL Developer and programmer
Built and implemented a complete stock trading system and blotter used by multiple traders.
Created links to Bloomberg API for quotes, back office accounting and brokers.
Coded in VB, .NET and MS ACCESS.
Supported the daily operations of traders and accounting.
Analyzed and summarized data and created reports.
EDUCATION/Certs/Achiements
Tel-Aviv University, Israel, 1988 - Computer Science Associate Engineer.
Microsoft MCP/MCSE, and SQL Server certified.
PCI and HIPPA certified.
Twice lectured at Microsoft and PASS sponsored SQL events and user groups.