Sql Server Windows
Resume:
TOBIN LIM
**** ****** **** ****, ********
MARYLAND 21044
ac0wl6@r.postjobfree.com
RELEVANT EXPERIENCE
Database Administrator November 2014 - present
Teaching Strategies
Provided production-level SQL Server support for their online product, Gold, by implementing an HA/DR solution, maintaining and expanding transactional replication for the report server farm, troubleshooting real-time performance issues through baselining and using real-time monitoring tools (New Relic APM, perfmon, SQL DMVs) on a two-node failover cluster instance. Enhanced OLTP performance through query tuning and index optimization while improving OLAP systems through appropriate indexing. Installed maintenance scripts to perform scheduled backups and index defragmentation and updating statistics during normal maintenance window. Collaborated with developers to provide architectural input for product revisions and with QA teams to reproduce and validate product bug fixes. Mentored developers for optimizing queries as well as providing final SQL code review. Implemented a complex solution for data encryption involving child data combining TDE and column-level encryption. Responsible for planning and migrating production environment to AWS to SQL 2014 with minimal downtime.
Database Administrator August 2013 – November 2014
Bally Total Fitness
As enterprise-wide database administrator, responsibilities include high availability, backup/restore operations, server updates, database migrations (2000 to 2008 and 2005 to 2012), and implementation of security policies as well as maintaining industry-level best practices. Implemented replication, log shipping, mirroring and clustering to maintain high data availability. Supported enterprise-level of data flow through ETL solutions including SSIS and legacy DTS packages. Provided necessary support for application development team in troubleshooting performance issues. Project managed the migration of the POS and health-club member check-in systems to SQL 2008 from SQL 2000. Efforts included overseeing the acquisition of new hardware and OS platforms as well as managing a contractor for the DTS-to-SSIS conversion project and coordinating testing across QA and software engineers ranging from full-stack Microsoft to AS/400.
Senior Solutions Architect February 2013 – August 2013
7Delta Corp
Provided leadership for two teams, both comprised of software developers and database developers, as lead solutions architect, to support web applications for two health care registry projects for the Veterans Affairs. Software cycling modeled through Agile SCRUM method. Coordinated and ran demo meetings with VA COTR, program managers, development team, QA Team to review and groom the backlog as well as what items to include with each SPRINT.
Database Administrator/Developer July 2010 – February 2013
NTT Data Corp
Performed troubleshooting, analysis and coding of stored procedures, triggers and other SQL-related tasks in the maintenance of VetPro credentialing system. Resolved data and coding related tickets for the production system via Web HelpDesk. Handled minor updates to ASP.NET pages written in C# to handle updated result sets from stored procedure changes.
Database Administrator/Application Developer February 2006 – July 2010
USAC
Installed and deployed SQL Server for a variety of environments. Backed up and restored databases using maintenance plans or jobs. Automated tasks through SQL jobs. Tuned SQL queries for BI developers or application developers. Maintained security through creating logins and users as well as schemas. Deployed service packs off hours. Performed server migrations and upgrades from version 2000 through 2008. Devised replication schemes using ETL tools such as DTS and SSIS to assist with creating a data warehouse. Migrated an Oracle 10g database to SQL Server 2005 using SSMA.
Provided development support for online application for FCC Forms submission for major telecommunications company to support the Universal Service Fund (USF) written in .NET and C# with SQL Server 2005. Developed stored procedures, triggers, views as well as the database architecture for feature enhancement.
EDUCATION
Psychology, Bachelor of Science May 2004 – January 2005
Loyola College of MD, Baltimore, MD
Mathematics, Bachelor of Science September 1990 – May 1994
Loyola College of MD, Baltimore, MD
Skills
SQL Server 2012
SQL Server 2008 R2
SQL Server 2005
SQL Server 2000
SSIS
SSRS
DTS
SSMA
TSQL
C#
VB.NET
ASP.NET
VBScript
MS-OFFICE 2010
git
TFS
JIRA
Confluence
Jenkins
Flyway
Windows Server 2003
Windows Server 2008
DOS
OS X
Linux
Contact this candidate