Sign in

Sql Server Engineer

Raleigh, North Carolina, United States
March 10, 2019

Contact this candidate



Raleigh, NC ***** 919-***-**** MS SQLSERVER DATABASE ENGINEER

Maximize Customer Efficiency & Performance

Customer-driven computer engineer skilled in translating customer requirements into high-quality information system solutions that address critical business needs. Tenacious and analytical problem solver with unique blend of technical, communication, and interpersonal skills. Reputation for going above and beyond to achieve team and company success. Passionate about providing best-in-class customer service. Database Design, Programming, & Performance-Tuning Customer Relations Employee Training Cross-Functional Collaboration Troubleshooting Research Data Management, Modeling, & Quality Verbal & Written Communication TECHNICAL SKILLS

Languages:Transact SQL, Perl, Javascript, HTML, BASH, PowerShellPlatforms:Windows, Linux, Cygwin, AIX, ESXi, MS SQL Server, Sybase, Active DirectoryTools:MS SQL Server Management Studio, VMware vSphere, MS Office, Eclipse IDE for Java, Visual Studio IDE for C#, Pycharm IDE for Python, Mercurial, Wireshark, Selenium, GIT, Json, XML, Hudson/Jenkins, rfbproxy, VNC, Freetds, PuTTY, OpenSSH Client and Server, rdesktop, SAMBA, Browser Debuggers, Subversion, Ajax PROFESSIONAL EXPERIENCE

FDH Infrastructure Services, Raleigh, NC 2018 - Present Contractor / Database Consultant

Hired to help resolve several problems resulting from a recent cyber attack.

·Quickly resolved attack related problems.

·Worked with SQL Server 2008r2 and SQL Server 2016 to resolve data access problems and several database blocking and performance issues.

·Found and fixed problems with SSIS and SSRS of SQL Server 2016. Used SSMS from SQL Server 2017.

·Fixed problems with and extended functionality of Access database pulling data from SQL Server.

·Fixing problems with construction management software package named Spectrum built on ProIV entity framework and SQL Server 2016.

·Replacing staging Access database with SQL Server based stored procedures being called directly from Excel spreadsheet to greatly simply user's jobs.

·Finding and fixing problems with in-house developed application based on DotNetNuke entity framework and SQL Server 2008r2 to improve performance and maintainability. ONE IDENTITY, A Quest Company, Raleigh, NC 2005 - 2018 Software Development Senior Engineer

Partnered with small team of software developers to build and support appliance based computer security product, TPAM, used globally to automate password change process of 1000s of shared accounts for 100s of global companies. Collaborated with technical support group to ensure customer satisfaction with TPAM. TPAM is a security hardened appliance running MS Windows 2008 and SQL Server 2008 r2 with a web based GUI.

·Created tables, triggers and stored procedures that provide majority of appliance functionality. Most every user or automated service interaction goes through database via a stored procedure call.

·Extensive work with SQL Server 2000 and SQL Server 2008r2 developing User Defined Functions, Triggers and Stored Procedures to handle all incoming data from web based front end, command line interface and limited web services while optimizing performance and efficiency.

·Acted as subject matter expert for another team of developers that were creating replacement product for TPAM based on newer technology and became familiar with newer technologies such as RESTful API, etcd key value store, Agile development methods, and Cassandra NoSQL database.

·Assisted in adding many customer-requested features, with a rapid development cycle, helping to close deals and grow customer base.

·Provided primary development and support for user session recording and playback feature of TPAM.

·Added support for non-US keyboards, including German, Spanish, Korean, Norwegian, and French.

·Became familiar with non-US keyboard layouts and special characters as well as internationalization issues.

·Made process flow changes to improve support for many concurrent users with better performance and reliability.

·Extended TPAM’s SAP platform support to be more robust and work with all SAP account types, developing familiarity with SAP’s ABAP interface.

·Maintained and enhanced TPAM’s support for platforms, including many Linux flavors, HPUX, Windows, Windows Active Directory, LDAP, MySQL, Teradata, Oracle, Sybase, and MS SQL Server.

·Ensured high level of customer satisfaction by helping educate frontline support staff on resolving customer issues and working closely with team members to resolve more difficult cases and incorporate fixes into product.

·Telecommuted after Dell closed Morrisville office in 2015. Continued very close relationship with coworkers with Skype and Slack from home office.

·Collaborated to upgrade TPAM’s underlying OS and DBMS from Windows 2003 Web Edition and SQL Server 2000 to Windows 2008 Server and SQL Server 2008 r2.

·Collaborated to upgrade TPAM’s distributed processing appliance and required packages from Fedora 10 to Fedora 24.

·Helped build and support TPAM’s high availability cluster capability based on database log shipping and merging data changes on failback to support many replicas. HARDISON CONSULTING, INC., Raleigh, NC 1998 - 2005 Owner / Database Consultant

Provided database design, programming, performance-tuning, and troubleshooting to multiple clients. Worked on multiple data warehousing projects and a single MS SQL-Server-based OLTP system.

·Built data warehouses, providing clients with business intelligence.

·Worked closely with small team, designing, building and supporting custom ERP system for service division of Kodak 1-Hour Photo.

·Implemented Star Schemas and developed several ETL processes to keep data current. EDUCATION

Master of Science in Management (MSM), Information Systems, North Carolina State University, Raleigh, NC

Bachelor of Science (BS), Computer Engineering, North Carolina State University, Raleigh, NC Ralph Kimballs’s Data Warehousing In Depth & Dimensional Modeling In Depth VOLUNTEER

Assistant Scout Master, Boy Scout Troop 395, Raleigh NC – Active

Contact this candidate