SQL Server Database Administrator
Resume:
Jeffrey Louie
El Sobrante, CA *****
adkn8f@r.postjobfree.com
EDUCATION:
B.A. Computer Science. University of California, Berkeley, California
PROFESSIONAL SUMMARY:
20+ years as a Database Administrator with Microsoft SQL Server 2008/2012/2016/Azure
15+ years as a Database Developer in SQL, Perl, shell scripts
3 years as a Microsoft Azure Database/Data Warehouse Administrator
2 years as a Greenplum/Postgres Database Administrator
PROFESSIONAL EXPERIENCE:
Senior Database Administrator April 2015-March 2020
Gap, Inc. under contract from Tekumen, Inc.
San Francisco, California
A Microsoft SQL Server/Azure database/data warehouse administrator for data analytics at Gap, Inc. Responsibilities include
omaintaining 100+ SQL Server 2008/2012/2016/Azure instances and 200+ databases
omaintaining 6 Azure data warehouse instances
omaintaining 4 large multi-TB datamarts (largest: 10+ TB)
omaintaining data warehouses (largest: 150+ TB)
oarchitecting data layouts/schemas
ocreating/editing stored procedures/triggers/functions/views
oidentifying, optimizing and refactoring poorly running SQL queries
operforming root cause analysis on critical database failures/performance issues
ocreating ETL processes using SSIS
omonitoring critical production processes
omaintaining replicated databases
oadministering users and access privileges
omaintaining various backup/failover strategies: log shipping, replication, clustering, co-location
ocreating and maintaining SSAS OLAP cubes
oresolving blocking/deadlocking/replication/connectivity/security issues
oproviding 24/7 on-call support of database systems
omaintaining database systems per application SLAs
Support development teams in San Francisco, San Ramon and Hyderabad, India
Senior Database Administrator October 2012-February 2015
Adknowledge, Inc.
Kansas City, Missouri / Fort Myers, Florida
A multi-platform database administrator for an Internet advertising platform application. Responsibilities include
omaintaining 100+ SQL Server 2005/2008/2012 instances and 200+ databases
omaintaining 3 Greenplum instances
omaintaining 4 large multi-TB datamarts (largest: 40+ TB)
oarchitecting data layouts/schemas
ocreating/editing stored procedures/triggers/functions/views
ooptimizing, troubleshooting, and performance tuning SQL queries
ocreating processes to import/export/archive/warehouse data
omaintaining replicated databases
oadministering users and access privileges
omaintaining various backup/failover strategies: log shipping, replication, clustering, co-location
omigrating TSQL stored procedures to MySQL
ocreating and maintaining SSAS OLAP cubes
ocreating and maintaining Perl processing scripts
oresolving blocking/deadlocking/replication/connectivity/security issues
oproviding support on NetApp SANs
oenhancing back-end Microsoft Dynamics reporting
operforming Oracle database administration
odeveloping BI queries for reporting
oproviding 24/7 on-call support of database systems
omaintaining database systems per application SLAs
Supporting systems remotely and in person at offices in Kansas City and Fort Myers
Senior Database Administrator 2012
Webroot Software
San Mateo, California
Worked as a consultant specializing in performance tuning and reorganization of data warehouse queries and processes
Identified processing bottlenecks and suggested improvements to improve database response times
Created scripts and processes for automated database backup, restores and log shipping
Migrated servers/databases from SQL Server 2005 to 2008
Senior Database Administrator/Architect 2006-2011
Verisk Analytics
San Francisco, California
A SQL Server DBA/developer for an automobile insurance auditing application. Responsibilities include
oarchitecting data layouts/schemas
ocreating/editing stored procedures/triggers
omanaging message brokering and queues
ooptimizing, troubleshooting, and performance tuning SQL queries
ocreating processes to import/export/archive/warehouse data
oimplementing and maintaining replicated databases
oadministering users and access privileges
omanaging production, staging, development, archiving and data warehouse environments
omaintaining various backup/failover strategies: Log shipping, replication, clustering, co-location
Worked directly with developers and business analysts to design and develop processing/storage strategies to solve business needs
Architected several mission-critical databases
Created ETL processes, SSIS packages and procedures. Automated FTP processes requiring PGP/SFTP/SSH protocols for submission to third-party data vendors, as well as retrieving and uploading vendor return data
Created Perl programs to scrape web sites and to extract, cleanse and upload data
Managed source code releases in VSS
Administered, maintained and updated Bugzilla bug tracking database
Mentored junior database administrator
Provide technical assistance to developers, QA/QC, technical support and documentation
Performed light Oracle database administration
Created plans for migration of database servers to off-site server facilities
Performed Oracle administration
Production: 6 servers, 150 databases, 4.2 TB. Data warehouse: 3 servers, 7 databases, 3 TB
Senior Database Administrator 2004-2006
Wetfeet, Inc.
San Francisco, California
A SQL Server database administrator/developer for an on-line job applicant tracking system. Wrote stored procedures/triggers; optimized, and performance tuned SQL queries; creating processes to import/export/archive data; implementing and replicating databases; administering users and access privileges
Created batch jobs, DTS packages, XML translators as needed
Created a Perl application to document database schemas
Created automated scripts for performing schema changes and basic DB maintenance functions
Maintained schema libraries using VSS
Performed Oracle administration on secondary system
Senior Software Engineer 1996-2003
Sybase, Inc.
Dublin, California
Database administrator/developer responsible for Sybase/Oracle/SQL Server/DB2 database servers across various hardware platforms; optimizing database resources, database replication, maintained schemas, wrote stored procedures/triggers, importing/exporting data, administered users and access privileges
Developed GUI-based database applications in Visual Basic, Java
Created/maintained automated shell and Perl scripts for database installation/upgrades and maintenance functions
Provided technical assistance to developers, QA/QC, technical support and documentation
TECHNICAL SKILLS:
Databases: Microsoft SQL Server 2008, 2012, 2016. Postgres. Greenplum, MySQL, Oracle
Languages: Perl, Shell, Linux. SQL: Microsoft SQL Server, Postgres, MySQL. XML, HTML, CSS
Operating Systems: Windows Server 2013, Windows 7; Unix
Other skills: Perfmon/Server-side tracing
Contact this candidate