Sql Server Database Administrator

Tobin Lim

Senior Database Administrator

Secret DoD 8570 IAT2 Certified

443-***-**** ********.***@*****.*** Columbia, MD 21044

Experienced database professional specializing in SQL Server (v2008R2 – v2022) with over 15 years of experience and over 20 of combined industry experience spanning multiple disciplines including software development, systems architecture and database infrastructure and database modeling and development in both on-premises and hosted cloud solutions. Extensive experience in data modeling, design, development, and code-release along with post-production performance tuning. Experienced in ETL processing and custom data transformation to homogenize data across different platforms. Effectively communicate technical concepts to non-technical teams and senior leadership.

Skills & Expertise

Performance Tuning, Indexing, Data Modeling and Design, ETL, Database and Column-level encryption

DR technologies: SQL Server replication, mirroring, log shipping

HA technologies: Failover Cluster Instance, Always On AG

Languages: T-SQL, C#, VB.NET, ASP.NET, VBScript, Windows Batch, JavaScript

Tools: TFS, git, Bitbucket, JIRA, Rally, Confluence, Jenkins, Flyway, Liquibase, ERwin

Certifications & Accomplishments

Security+ CE Certified

Dramatically improved scalability and performance issues within 18 months.

Improved reporting performance within 6 months.

Migration and conversion over 100 ETL packages from DTS to SSIS.

Relevant Experience

NT Concepts Lead Database Engineer (3/2024 – present)

Provided database support for feature development team.

Troubleshoot bug fixes in triggers and stored procedures.

Provided deployment support for database changes across environments from development to production.

Mentored junior database team members regarding workflow, best practices and task management.

PROTEK CONSULTING Rockville, MD Database Consultant (10/2023 – 3/2024)

Performance tune and refactor legacy database systems in SQL Server.

Reviewed data cardinality in data access patterns to detect parameter sniffing issues.

REI SYSTEMS INC. Sterling, VA PostgreSQL Database Engineer (3/2023 – 9/2023)

Identify and diagnose data integrity issues and write SQL scripts to implement enterprise-level corrections.

Mapped third-party reference data to internal target tables for column-to-column mapping including data conversion to handle nullability. Maintained mapping documentation in Excel.

Reversed denormalized data from outside vendors into parent-child data using new key values.

BONTERRA TECH Washington, DC Senior Database Engineer (10/2022 – 1/2023)

Identified and implemented performance-tuning strategies within stored procedures and functions using execution plans and statistics usage during query analysis and refactoring processes.

Optimized indexing strategies.

TRADESTATION Washington, DC Senior Database Engineer/Administrator (8/2021 –8/2022)

Provided database support for multiple OLTP development teams (FINRA CAT reporting and Cashiering applications)

Recommended performance optimization techniques for other database developers during collaborations.

Involved in recommending schema and table design structures as well as refactoring stored procedures and rewriting UDFs into inline TVFs where applicable.

COSTAR GROUP Washington, DC Senior Database Engineer (8/2019 –8/2021)

Worked extensively on tuning stored procedures that were heavily dependent on using dynamic SQL.

Troubleshoot and resolve performance problems through profiler, execution plan analysis and statistics output parsing.

Involved in the engineering and architecture for OLTP SQL objects such as tables, functions and procedures during feature planning sessions (MSSQL).

Created technical documentation for the entire CRM pricing module.

Troubleshoot Jenkins database build jobs.

TRAVELERS INSURANCE Hunt Valley, MD Production DBA (11/2017 – 8/2019)

Delivered T-SQL best practices documentation for developers.

Developed dashboard reports for database management regarding database server metrics.

Assisted development team for change deployments.

TEACHING STRATEGIES Bethesda, MD Senior Database Administrator (11/2014 – 11/2017)

Provided database support (OLTP and OLAP modeling) for new and existing functionality.

Provided administrative support in a clustered server environment including replication.

SSIS development to import and integrate data from third-party data providers.

Implemented database script migrations using git and flyway in a CI\CD process through Jenkins.

Safeguarded PII through the implementation of TDE and column-level encryption.

DEPT. OF VETERANS AFFAIRS Baltimore, MD Database Administrator (4/2010 – 11/2014)

Database architectural and development support for multiple VA health registries.

Optimized application queries and stored procedures for VA credentialing system.

USAC Washington DC Database Administrator (2/2006 – 4/2010)

Converted migration of over a hundred SQL 2000 DTS packages to 2005 SSIS packages.

Migrated an Oracle 10g database to SQL Server 2005 using SSMA.

Provided database development (design and modeling) support in the form of writing stored procedures, triggers and schema updates via DDL.

Education

M.S. Psychology Loyola University Maryland

B.S. Mathematics Loyola University Maryland

Contact this candidate