John Penn

John Penn Email and Phone Number

SQL Server Developer – Database Design | Database Administrator (DBA) | Microsoft SQL Server | Relational Databases | Performance Optimizations
John Penn's Location
Sparta, New Jersey, United States, United States
About John Penn

With decades of experience in software and database development, I excel in creating, testing, and documenting applications and databases across diverse platforms. My track record includes consistently exceeding expectations and delivering high-performing solutions. I specialize in SQL Server database optimization, ensuring peak performance and efficient data management.My leadership skills shine through successfully leading cross-functional teams in database development projects. I thrive on challenges and leverage my analytical and problem-solving skills to contribute to the execution of key business initiatives.With a proven track record in database administration, I bring decades of experience optimizing database performance. I excel in designing and implementing robust data architectures tailored to meet organizational needs. Skilled in troubleshooting and resolving complex database issues, I ensure data integrity, security, and availability. Leveraging strong analytical skills, I identify opportunities for optimization and implement efficient strategies to enhance database performance. I stand ready to drive success in database administration roles, delivering solutions that drive organizational efficiency.Throughout my career, I've led in communicating complex technical concepts clearly and effectively. I am experienced at collaborating with technical teams to achieve common goals, and I consistently strive for excellence in all aspects of my work. For example, slashing the execution time of procedures to optimize database performance.Core Skills:Extract, Transform, Load (ETL) | SQL Database | Database Schema Database Design | Online Transaction Processing | Relational Database Management System | SQL Server Integration Services | Database Development | Query Optimization | Data Modeling | Stored Procedures | Database Administration | Performance Tuning | Database Design | Indexing Strategies | Data Migration | Data Analysis | Relational Databases | Troubleshooting | Database Security

John Penn's Current Company Details

SQL Server Developer – Database Design | Database Administrator (DBA) | Microsoft SQL Server | Relational Databases | Performance Optimizations
John Penn Work Experience Details
  • Kroll
    Software Engineer Manager Ii
    Kroll Oct 2021 - Nov 2023
    Morristown, New Jersey, United States
    • Enhanced performance of SQL Server databases for legacy applications by refactoring stored procedures, applying index optimizations, and redesigning tables for reduced memory usage. • Implemented functionality for row-level security in a GDPR-compliant database.• Provided training on SSMS and SQL Server to junior developers and reviewed their database design and code.• Optimized SQL Server database synchronization tasks, reducing the hourly sync task duration to 1-2 minutes and the weekly full-sync task to approximately 2 hours. »» Identified and rectified datatype mismatches in join predicates and parameters, and addressed inappropriate datatypes in queried tables, significantly improving query execution efficiency and system performance. »»Implemented changes to the stored procedure and introduced a script to redefine mis-declared columns, resulting in a substantial enhancement of task completion times.• Addressed global data segregation requirement for a new application by implementing a more efficient solution. »»Put in place a user authentication mechanism requiring the specification of the user ID within queries. »»Received positive feedback from developers, confirming its effectiveness in restricting data retrieval.
  • Business Edge Services & Technologies
    Senior Web Developer
    Business Edge Services & Technologies May 2015 - Sep 2015
    Washington, Nj
    • Implemented enhancements and fixes for new and legacy web applications for a client in the specialty pharmacy industry. • Assisted junior developers with their tasks and inquiries. • Assisted business personnel with report requirements and production issues.• Technologies used: C#, SQL Server, jQuery, Bootstrap, Web Services, Ajax
  • Nrt
    Senior Developer
    Nrt Mar 2012 - Mar 2014
    Madison, Nj
    • Implemented new and updated functionality for an existing WCF/SOAP application. Added new interfaces and method implementations to retrieve and persist data from web applications.• Member of a team that designed and developed a new enterprise application for use by real estate agents and rental property managers for accounting, management, and reporting purposes.

John Penn Education Details

  • Spring Garden College
    Spring Garden College
    Software Engineering

Frequently Asked Questions about John Penn

What is John Penn's role at the current company?

John Penn's current role is SQL Server Developer – Database Design | Database Administrator (DBA) | Microsoft SQL Server | Relational Databases | Performance Optimizations.

What schools did John Penn attend?

John Penn attended Spring Garden College.

Not the John Penn you were looking for?

  • John Penn

    National Director At Aarp
    Stillwater, Mn
    2
    yahoo.com, aarp.org

    4 +195289XXXXX

  • John Penn

    San Diego, Ca
    3
    broadcom.com, cypress.com, arm.com
  • John Penn

    Dayton Metropolitan Area
    6
    comcast.net, syncreon.com, aol.com, excite.com, msn.com, americanbatterysolutions.com

    11 +193777XXXXX

  • John Penn

    Sr Talent Acquisition Recruiter
    Dublin, Oh
    3
    gmail.com, pridetech.com, nisource.com

    2 +151379XXXXX

  • John P.

    Atlanta, Ga
    7
    netzero.net, yahoo.com, inspiremedia.info, digigumball.com, undercurrentlabs.com, digigumball.com, undercurrent.com

    3 +167890XXXXX

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.