Oliver Jen

Oliver Jen

Tableau DevIT Database Administrator

Portfolio items

Objective

Actively seeking a position in a smaller company with a compelling and impactful mission.

My ardent hope is to have a long-term position contributing and growing in a highly proficient and collaborative team.  My professional expertise is with SQL Server.  In my perfect career destiny, I'd have opportunities to extend my skill set to include other related technology including, but not limited to, NoSQL, MySQL, Oracle and BI.

Skills

Skills

Powershell

Versions 2.0, 3.0. Cmdlet and script samples available upon request.

Database Performance Tuning

(SQL Server, all versions) Index, statistics analysis Query plan analysis Index health/maintenance development

Database Security

Server, Database, object-level security Utilizing server, database, application roles Best practice implementation (SQL injection, authentication modes, integration with Active Directory) Encryption (symmetric, asymmetric keys) SQL Server Audit (SQL2008, 2008R2)    

High Availability

Database Mirroring (SQL 2008, 2008 R2) SQL Always-On Groups (SQL 2012) Log-shipping (SQL 2005, 2008, 2008R2) Transactional Replication (SQL 2005, 2008, 2008R2, 2012) Backup/Recovery (All versions)  

Capacity Planning

SQL Server ( versions 2005, 2008, 2008R2, 2012)   Tools: Data collection Perfmon Profiler

SSRS

SSIS

T-SQL Development

Work History

Work History
Sep 2014 - Present

Database Programming Instructor

Bellevue College Continuing Education

Instruction for the following courses:

  • Database Design : Introduction to relational theory, normal forms and utilizing database features to implement business rules.
  • Advanced T-SQL Programming: SQL Server programming concepts including stored procedures, functions, triggers, transactions and error-handling.
Nov 2013 - Present

Development IT Database Administrator

Tableau Software
  • Created standard production server environment.  Standardized backups, monitoring, capacity planning, documentation and security for production databases.
  • Implemented, upon request, performance tuning and debugging to 
  • Conceived & implemented reporting infrastructure utilizing SQL Server transactional replication.
  • Curated and implemented several new test data sources for the development team to work with, including Amazon Redshift and SAP HANA (AWS and appliance).
  • Created patching scripts to update database servers on Windows VM hosts.
Aug 2010 - Sep 2013

Senior Database Engineer

Microsoft (XBox)

Technologies: SQL Server 2005/2008/2008 R2/2012, Powershell, Windows 2008, 2008 R2, 2012.

Performance Tuning & Optimization:

  • Researched, authored and tuned methodology for business requirement to alter table structure to a federated database table with 1.5B rows. No customer impact was incurred.
  • Diagnosed, quantified and resolved several live-site performance related bugs. Techniques included query analysis with execution plans, index fragmentation analysis, blocking and concurrency analysis.

Capacity Planning

  • Developed, refined database growth metrics collection and analysis at the data file and table/index-level to project hardware requirements.
  • Developed SSRS reports displaying growth trends in a concise, attractive format.

High Availability

  • Developed and refined infrastructure (SQL jobs, Powershell cmdlets and database objects) to monitor and alert on SQL Server transactional replication latency.
  • Architected, monitored, deployed and supported several SQL instances utilizing SQL 2012 Always-on groups, SQL Database Mirroring, log-shipping and replication.

Security

  • Authored, implemented a high-security database utilizing table encryption, auditing and limited security configuration. Work included defining symmetric and asymmetric keys, a secured escrow certificate, and code to encrypt and decrypt the sensitive data.
  • Implemented Active directory role/resource group separation in order to grant least-required client-to-server privileges.

Leadership in operational excellence

  • Developed deployment protocols to efficiently test, validate and rollback partitioned database deployments.
  • Scripted automated database patching to simplify and consistently and thoroughly patch database servers.
  • Defined and led a project to store infrastructure source control and deployment strategy for database infrastructure code. 
  • Set up code review process to for internally developed database monitoring and administrative code.
Sep 2007 - Aug 2010

Database Developer

Microsoft (IT)

Technologies: T-SQL, SSIS, SSRS, MSBuild

  • Defined requirements, designed, developed and reviewed database back-end for a custom build tracking system.
  • Independently developed and deployed a light-weight disk space monitoring solution bridging needed functionality until the team was able to onboard SCOM.
  • Implemented TFS daily build and validation automation.
Dec 2005 - Sep 2007

Senior Database Administrator

Microsoft (IT)

Technologies: SSMS (2005), T-SQL, VBScript

  • Owned the domain password change enhancement process, reducing the effort from 72 work-hours to 4. Work included problem analysis, definition and scope, solution development, testing and implementation.
  • Planned, documented, tested and implemented SQL 2000 to SQL2005 upgrade for the Compass/Clarify datastore.  Zero-downtime incurred.
Feb 2003 - Dec 2005

Systems Engineer

Microsoft (microsoft.com)

Technologies: SQL2005, SQL2000, T-SQL

  • Collaborated with Windows Update feature team in planning, deploying, upgrading and supporting the data-tier infrastructure for Windows Update.
  • Debugged and refined dev and test environments to properly simulate production for PENS (Personalized Electronic Newsletter Service)
Apr 2002 - Feb 2003

DBA Manager

T-Mobile (Voicestream Wireless)

  • Assign, monitor, and reallocate team resources, as needed to current and future SQL production projects. 
  • Serve as a liaison between Production Support and internal customer groups in charting the progression and procedures required to move SQL Server database applications from dev/test to production. 
  • Provide a sounding board and direction to new ideas for staff DBA's.
Jan 2001 - Apr 2002

SQL Server DBA

T-Mobile (Voicestream Wireless)

  • Developed/documented Voicestream SQL Server hardware and software installation standards. 
  • Indexing and query-tuning analysis for several mission critical systems. Tools included SQL Profiler, Index Tuning Wizard, Query Analyzer, Windows 2000 Performance Monitor & Quest Spotlight on SQL Server. 
  • Diagnosed and remedied day-to-day SQL-related problems. 
  • Developed and implemented disaster recovery plan. Leveraged log-shipping for SQL 7.0 to remote site. 
  • Developed and implemented database capacity planning and forecasting. The system utilized SQL Agent Jobs, stored procedures and transactional replication to track database and database table growth on several servers to be used to provide a historical basis to predict growth trends and patterns.

Education

Education
Sep 1995 - Jul 1997

B.A. Computer Science

University of Maryland University College
Sep 1992 - Sep 1995

University of Maryland