Luis Lima

Luis Lima Email and Phone Number

Director, Database Engineering at PDI Software @ PDI Software
Luis Lima's Location
Miami-Fort Lauderdale Area, United States, United States
Luis Lima's Contact Details

Luis Lima phone numbers

About Luis Lima

Responsible for managing the daily operations of the database engineering team. Execute database strategies to provide secure, high availability and high-performance environments.Microsoft® Certified Solutions Expert (Data Management and Analytics)Microsoft® Certified Solutions Expert (Business Intelligence)Microsoft® Certified Solutions Associate

Luis Lima's Current Company Details
PDI Software

Pdi Software

View
Director, Database Engineering at PDI Software
Luis Lima Work Experience Details
  • Pdi Software
    Director, Database Engineering At Pdi Software
    Pdi Software Jun 2020 - Present
    Alpharetta, Georgia, Us
  • Zipline
    Director Database Engineering
    Zipline Nov 2019 - Jun 2020
    Portland, Maine, Us
    Responsible for managing the operations of the database engineering team, responsible of the database administration and database development. Responsible for setting the database strategy and delivering a scalable and reliable data platform that supports our payment platform and other Applications. Provide leadership designing and implementing new databases for new systems and oncoming applications, execute database strategies to provide secure, high availability and high-performance environments.Maintain direct communication and relationships with key stakeholders in order to keep current with the direction of the business and the needs of the customers.
  • Zipline
    Sr. Sql Dba
    Zipline May 2016 - Nov 2019
    Portland, Maine, Us
    Ensure that the database infrastructure is highly available and secure. Participating in daily quality assurance and development project work.A few of the notable accomplishments:• Created a database architecture that was highly-available as well as optimized our SQL Server licensing model to avoid out-of-compliance costs while improving our disaster recovery capabilities• Migrated infrastructure and upgraded SQL Server components to be on the latest Microsoft versions• Improved the speed of transaction processing (PreAuths 10x & Completion 20x faster, Monthly letters 18hrs to 3.7hrs) though upgrades and tuning• Hardened security though waves of changes and improvements specific to our SQL Server instances, in line with PCI data security standards• Built out data warehouse and BI platform including Integration and Analysis Services• Supported all development and system initiatives• Designed, Developed and Deployed an Automated Monthly Billing system - eliminating manual and sometimes inaccurate processing that where in existence for years.• Supporting a successful build out of Host.net as a DR facility.• Supporting a successful migration of Rackspace DC's• Re-architect/re-organize database models for various systems (such as billing) and initiatives (such as FleetCor)• Continuing to enhance security by working with the development team and reforming how applications access database resources.• Built Oracle database management skills to support on-premise loyalty infrastructure• Continuing to support BI projects as well as Consumer Engagement and Marketing Initiatives.
  • Edenred México
    Sql Server Dba And Business Intelligence Consultant
    Edenred México Mar 2015 - Dec 2015
    Ciudad De México, Distrito Federal, Mx
    As part of the Architecture Department of Edenred Mexico I had the responsibility to design new databases solutions and develop new applications to improve the automated business processes. Review new T-SQL codes for new applications developed by the existing development teams as well as provide recommendations for best practices. I reviewed SSIS packages and RDL codes for performance enhancement. Provide technical support in critical situations in order to ensure the continuity of services.I created and set in play a new monitoring process for the fraud prevention department. That solution is an Incremental ETL process focused on capturing possible malicious transactions. By implementing this new process I help the fraud prevention department to dramatically increase the efficiency the monitoring transactions. This solution was created on SQL Server Integration Services (SSIS).I developed an application for translate information between middle office systems and different authorizers. This application was focused to improve the card approval process, payments and charge of cards. With this improvement we achieved 30% increase the daily transactional load of process. Tools: SSMS, SSIS, SSRS, SSAS, Visual Studio, Team Foundation Server
  • Grupo Salinas
    Database Administrator
    Grupo Salinas Mar 2014 - Mar 2015
    Mx
    In this company I have been worked in Operations Deparment. I was responsible for installing and configuring SQL Server Instances into PROD-QA-DEV environments, responsible for monitoring and performance tuning. I performed upgrades and migrations, design and create Solutions for high availability and Disaster Recovery. Review new codes for new applications. I have deployed and configured multidimensional models and Tabular models in order to provide a suitable environment for generating reports.I documented the standard for T-SQL codes. Focused on using best practices and clarity in writing code.I implemented a security scheme based on Database Encryption by certificate. I implemented Transparent Data Encryption (TDE) to encrypt confidential assets and ensure a secure system.I configured SQL Server Failover clustering and AlwaysOn to support multiple databases in clustered environments for ensuring continuity of services in case of critical problems such as downs of nodes, electrical problems, etc. I configured Database Replication for some Databases. This configuration was focused to decrease the high transactionality and provide other options for reporting applications. Tools: Microsoft SQL Server 2012, Oracle 11g, 12c, TOAD, OAS, Application Managers
  • Rex (Luxury Car And Limousine Rental Agency)
    Software Engineer
    Rex (Luxury Car And Limousine Rental Agency) Jan 2009 - Dec 2013
    Analysis and design of database model. Microsoft SQL Server administration to support multiple databases in both clustered and non-clustered environments with replication. I was responsible for managing and developing of (SIGREX) Automated control system for rental cars. This system contains 6 Subsystems (Business, Sales, Operations, Fleet, Workshop, and Informatics). Management and Programming of Invoice System. Management and Programming of www.rex-rentacar.com reservation module. I implemented distributed databases with Merge Replication. This configuration was created to support the (SIGREX) Computer system. I installed the Publisher and Distributor on Central Server located in Main Office in Havana and 22 Subscribers in all country. I created a process to transport sales information from REX to TRANSTUR. With this process the business group (TRANSTUR) kept up to date statistics on sales.
  • Bank (Banco Popular De Ahorro)
    Software Engineer
    Bank (Banco Popular De Ahorro) Sep 2006 - Dec 2008
    Application developer for BPA (Banco Popular de Ahorro).Responsible for the development and maintenance of 5 subsystems of the banking system. Develop new applications for BPA (Banco Popular de Ahorro). Performed databases integration and analysis on existing systems. Design and Modeling Database for new solutions. Perfomance tuning for query optimization before to apply into productions server.

Luis Lima Skills

Alwayson Etl Data Warehousing Distributed Databases C Sharp Powerpivot Ssis Dax Sql Server Analysis Services T Sql Visual Studio Data Analysis Microsoft Sql Server Relational Databases Load In Memory Oltp Replication Technologies Microsoft Reporting Service Toad 9.0 Oracle Data Modeling Olap Cube Php Business Intelligence Extract Sql Database Design Software Development Mdx Unix Oas Visual Paradigm Ssas Tabular Data Model Rational Rose Enterprise Edition Team Foundation Server Transform Database Administration Databases

Luis Lima Education Details

  • Higher Institute-Technology (Cujae)
    Higher Institute-Technology (Cujae)
    Computer Software Engineering

Frequently Asked Questions about Luis Lima

What company does Luis Lima work for?

Luis Lima works for Pdi Software

What is Luis Lima's role at the current company?

Luis Lima's current role is Director, Database Engineering at PDI Software.

What is Luis Lima's direct phone number?

Luis Lima's direct phone number is (877) 403*****

What schools did Luis Lima attend?

Luis Lima attended Higher Institute-Technology (Cujae).

What are some of Luis Lima's interests?

Luis Lima has interest in Leadership, Analyze Needs, Empathy, Adaptable To Change, Learning Fast, Troubleshoot And Correct Problems, Able To Get To The Heart Of Problems, Able To Work Well Under Stress, Results Oriented, High Sense Of Responsibility And Honesty.

What skills is Luis Lima known for?

Luis Lima has skills like Alwayson, Etl, Data Warehousing, Distributed Databases, C Sharp, Powerpivot, Ssis, Dax, Sql Server Analysis Services, T Sql, Visual Studio, Data Analysis.

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
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

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.