Sql Server Developer

FRANK LAM Address: *** **, **rd Ave

Phone: 347-***-**** Bayside, NY 11364

Email: ******@*******.*** Citizenship: US citizen

PROFESSIONAL SUMMARY

Hands on experience in financial, entertainment, environmental, education, market research and connection industries. Detail

oriented with good analytical and problem solving skills. Enjoy working as a team member, as well as independently. Quick

learner. Able to work in a fast–paced and multi tasking environment. Good communication skills.

TECHNICAL SKILLS

Programming Skills: SQL (Stored Procedures, Views, Triggers, Functions), VBA, ASP.Net, ADO.Net, XML, HTML

Applications: SQL Server 2000/2005/2008/2012, SSIS, SSRS, SSAS, Visual Studio 2005/2008, BIDS,

Access, Crystal Reports 2008

Operating Systems: Windows NT/XP/2003/2008/7/8, DOS

Others: MS Office Suite, Red Gate, Photoshop, TCP/IP, IIS, PowerShell, Symantec Backup, LiteSpeed, VLDB

EXPERIENCE

SQL DBA/Developer Conxeo Inc., New York, NY May 2012 – Current

Serve as a production DBA and database developer managing multiple SQL Server (2005/2008) databases for

Fortune 1000 clients. One of the team member supported Bank of America, Walmart, Dick’s Sporting Goods,

Southwest, Wells Fargo. Responsibilities are as follows:

• Perform backup/restore/upgrade/patching for database servers. Participate in all releases & change control.

• Perform ETL operations using SSIS package. Diagnose errors with applications that are related to database.

• Develop stored procedures for client’s ad hoc reports or system related projects. Develop views, triggers and

functions for better database performance, security and archive purposes.

• Monitor SQL Server health, growth, and proactively manage enterprise data systems toward 100% system

availability. Assume ownership of all sql servers performance tuning and maintenance.

SQL DBA/Developer Tech Savvies Inc., New York, NY Oct 2009 – Feb 2012

Served as a SQL database consultant for client’s project. Provided support on SSIS, SSRS and database development in addition

to database administration. Responsibilities were as follows:

• Performed install, backup, restore, upgrade and configuration for SQL 2000/2005/2008 database servers.

• Performance tuning and Auditing for client servers. Rebuilt and reorganized index for index fragmentation.

• Used BCP, bulk insert & SSIS packages to move & standardize data and SSRS reports for reporting purposes.

• Set up and implemented high availability solutions including replication, log shipping and database mirroring for client servers

environment. Created stored procedures, views, functions and triggers to centralize business logic and for audit & security

purposes.

SQL Server DBA IPsoft Inc., New York, NY April 2008 – May 2009

Served as an on call production SQL Server DBA providing Tier I and II support for clients with SQL Server (2000/2005/2008)

contracts. One of the team member supported IndyMac Bank, Genworth, Liz Claiborne, Gentiva, Vertrue, Fandango, Canon and

CV Therapeutics. Responsibilities were as follows:

• Developed backup/restore/upgrade and disaster recovery plan for production servers and participated in client’s weekly or

monthly conference call meeting for quality improvement.

• Joined emergency bridges or releases to troubleshoot outages, remediated database server issues, initiated and approved

production changes. Configured, patched and secured production SQL Servers.

• Administered over 100+ SQL Servers in a team environment and provided 24X7 dedicate support for both production and

development SQL Servers. Responded to system ticket alerts.

Database & Web Developer BEM Systems Inc., Chatham, NJ Oct 2007 – Feb 2008

Served as a SQL database developer within a team providing development support for client’s website using the PAECETrak

application. Hands on experience in DDL, DML & T SQL. Responsibilities were as follows:

• Developed SQL queries in the back end using DML (select, insert, update, delete) and DDL (create, alter, drop) to ensure

data entered on the website were being read, saved, updated and deleted from the database. Developed web forms and

controls used by the front end.

• Created templates and designed queries to populate bookmarks on the templates in order to generate documents . Ensured

data being inserted, updated and deleted from the database were also logged to the document and log libraries.

EDUCATION & TRAINING

1. Bachelor’s Degree in Computer Science – City University of New York Queens College 2005

2. Training classes in SQL, ASP.Net, ADO.Net, XML – Compu21 Tech Training, Flushing, NY 2006 07

CERTIFICATIONS

1. MCITP: SQL Server 2008 Database Administrator (Exam 70 453)

2. MCITP: SQL Server 2005 Database Administrator (Exam 70 431, 70 447)

3. MCITP: SQL Server 2005 Database Developer (Exam 70 431, 70 441 & 70 442)

4. MCTS: SQL 2005 Business Intelligence Development & Maintenance in SSRS, SSIS, SSAS

(Exam 70 445)

5. MCDBA: SQL Server 2000 Database Administrator (Exam 70 228, 70 229, 70 290 & 70 293)

Interest: Tennis, Soccer, Jazz

Other languages: Cantonese, Mandarin

References Available Upon Request

Contact this candidate