DBA
Resume:
KI CHIANG
KI CHIANG
Las Vegas, NV. 89148
**.******.*@*****.***
Objective
To work as a Senior DBA
Summary of Qualifications
Certificates: MCSE for Win2k & NT 4.0 (Microsoft Certified System Engineer),
MCDBA for SQL 2000 & SQL 7.0 (Microsoft Certified Database Administrator)
MCITP for SQL 2005: DBA (Microsoft Certified IT Professional)
Operating System: Windows 3.X/95/98/2000/2003, NT 4.0 server/Workstation, Unix, MS-DOS, Linux
Software: IPSentry, PCAnywhere, Visio, BackupExec, Microsoft Office 97 & 2000, WordPerfect, Precise, SQLLite, Altiris, MS Virtual Server 2005, Confio
Programming Language: TSQL, PL/SQL, C, Turing, HTML, VB, ASP, VB Script
Database System: SQL 7.0/2000/2005/2008, SQL 2000/2005/2008 Analysis & Reporting Services, Oracle 9i/10g, Sybase 12.5
Networking: Good knowledge of Network Principle and Structure, TCP/IP
Personality: Good Interpersonal, Communication, Problem Solving, Organizational and Time Management Skills.
A Fast Learner with great Team Spirit, always Helpful and Willing to share ideas.
Professional Experience
Apr. 2009 - Present, eCommlink, Las Vegas, NV, USA
Senior Database Administrator
• Managing and setting up Dev, QA, UAT, and production environment. Duties involve installing, configuring and trouble shooting Win2003/Win2008/Linux and SQL2005/2008, and MySQL in 24x7 environment.
• Capacity and resource planning database servers
• Creating and setting Database management standard
• Tune and optimize DB for optimum performance using profiler
• R&D and application support & deployment
• Implementing database integrity checking and optimizing SQL server performance by setting daily and weekly maintenance jobs.
• Setting up centralized SQL management server
• Managing SQL server security and validating users at two levels of security Login Authentication and permission validating on database user accounts and roles.
• Backup and Restore. Designing appropriate backup strategy, restoring backups from different backup types.
• Automating administrative tasks such as creating and scheduling jobs, creating alerts to respond to SQL server errors and creating operators to be notified when a job is completed or when an alert is triggered.
• Generating customized Stored Procedure for report and Database maintenance
• Design, creating, implementing Store Procedure and triggers for applications
• Data Import Export and creating customized report using SSIS/DTS
• Set up and manage SQL replication
Jan 2007 – April 2009, Canadian Pension Plan Investment Board, Toronto, On, Canada
Senior Database Administrator
• Managing and setting up Dev, QA, UAT, and production environment. Duties involve installing, configuring and trouble shooting Win2k/Win2003/Unix/Linux and SQL 2000/2005/2008, Sybase 12.5 and Oracle 10g in 24x7 environment.
• Capacity and resource planning database servers
• Creating and setting Database management standard
• Tune and optimize DB for optimum performance using profiler
• R&D and application support & deployment
• Implementing database integrity checking and optimizing SQL server performance by setting daily and weekly maintenance jobs.
• Setting up centralized SQL management server
• Managing SQL server security and validating users at two levels of security – Login Authentication and permission validating on database user accounts and roles.
• Backup and Restore. Designing appropriate backup strategy, restoring backups from different backup types.
• Automating administrative tasks such as creating and scheduling jobs, creating alerts to respond to SQL server errors and creating operators to be notified when a job is completed or when an alert is triggered.
• Generating customized Stored Procedure for report and Database maintenance
• Design, creating, implementing Store Procedure and triggers for applications
• Data Import Export and creating customized report using SSIS/DTS
• Mentoring juniors
August 2004 – November 2006, KPMG Canada, Toronto, On, Canada
SQL Database Administrator for Global Application Group
• Managing and Setting up Dev, QA, and Prod SQL DB environment.
Duties involved installing, configuring, and trouble shooting Win2k/Win2003 and SQL200/SQL7 in 24x7 environment
• Tune and optimize DB for optimum performance using profiler
• Implement, supporting, and maintaining Merge and transactional replication among 3 data centers
• R&D support and application support
• Log Shipping Implementation, supporting, and maintaining standby servers
• Implementing database integrity checking and optimizing SQL server performance by setting daily and weekly maintenance jobs.
• Managing SQL server security and validating users at two levels of security – Login Authentication and permission validating on database user accounts and roles.
• Backup and Restore. Designing appropriate backup strategy, restoring backups from different backup types.
• Automating administrative tasks such as creating and scheduling jobs, creating alerts to respond to SQL server errors and creating operators to be notified when a job is completed or when an alert is triggered.
• Generating customized Stored Procedure for report and Database maintenance
• Design, creating, implementing Store Procedure and triggers for applications
• Data Import Export and creating customized report using DTS
• Mentoring Junior
August, 2003 – August 2004, Descartes Systems Group, Waterloo, On, Canada
SQL Database Administrator/ System Engineer
• Managing and setting up QA, DEMO, and production environment. Duties involve setting hardware, installing, configuring and trouble shooting Win2k and SQL 2k in 24x7 Environment.
• Implementing and supporting Clustered environment
• Implementing database integrity checking and optimizing SQL server performance by setting daily and weekly maintenance jobs.
• Managing SQL server security and validating users at two levels of security – Login Authentication and permission validating on database user accounts and roles.
• Backup and Restore. Designing appropriate backup strategy, restoring backups from different backup types.
• Automating administrative tasks such as creating and scheduling jobs, creating alerts to respond to SQL server errors and creating operators to be notified when a job is completed or when an alert is triggered.
• Generating customized Stored Procedure for report and Database maintenance
• Performance Monitoring and tuning using SQL Profiler
• OLAP Implementation and maintenance; Creating cubes, Designing Schema for OLAP, Tuning.
• Unattended SQL Installation
• R&D support and application support
• Supporting PeopleSoft Database
• Supporting and implementing SQL 2000 Analysis Server(OLAP)
• Generating customized reports upon clients’ request using Stored Procedure and DTS
• Configuring IIS web servers and SSL certs install
• Configuring COM+ component
• Setting HP Blade environment using Altiris RDP
• Setting HP MSA1000 SAN storage setup and Array configuration
• Setting IBM SAN Storage FastT600 setup and Array Configuration
August 01, 2000 – June 2003, DoubleClick, Toronto, ON, Canada (Flonetwork)
SQL Database Administrator
• Managing over 30 mission critical WIN 2K OS based SQL 2000 & SQL 7.0 Servers in 24x7 environment. Duties include installing, configuring, and troubleshooting the Databases. (Each DB size 100 GB to 250 GB)
• Installing and managing of WIN 2K an SQL 2K & SQL 7.0
• Optimizing and tuning servers using system monitors
• Implementing and testing 2 node MICROSOFT Clustered WIN 2K SQL 2000 servers
• R&D support and application support
• Log Shipping Implementation
• Involve with R&D development for Database schema design
• Creating ASP for Ad-hoc processes
• Feasibility Research for SQL Replication
• Logical & Physical database design including creating database, tables, indexes, and view.
• Implementing database integrity checking and optimizing SQL server performance by setting daily and weekly maintenance jobs.
• Managing SQL server security and validating users at two levels of security – Login Authentication and permission validating on database user accounts and roles.
• Performance Monitoring and tuning using SQL Profiler and Precise Indepth tool
• Generating customized reports upon clients’ request using Stored Procedure and DTS
• Backup and Restore. Designing appropriate backup strategy, restoring backups from different backup types.
• Automating administrative tasks such as creating and scheduling jobs, creating alerts to respond to SQL server errors and creating operators to be notified when a job is completed or when an alert is triggered.
• Setting SQL mail as a notification tool.
January 01, 2000 – July 31, 2000 Flonetwork, Toronto, ON, Canada
System Operator
• Installed NT, 2000 & Unix servers and software
• Server Auditing for optimization and performance tuning
• Troubleshooting network problems
• Configuring Network Protocols (TCP/IP, WINS,DNS)
• Managing IIS 4.0 server
• Audit resources and events (Event viewer, View Log), Backup using Backexec
• Resolves Client Services questions and problems in the areas of system configuration setup, product functionality
• Managing Network security, manage users and network resources
August 30, 1999- December 31, 1999 Lucid, Mississauga, ON, Canada
System admin + Customer Service Representative
• Setting Up and Looking after internal network
• Installing of NT 4.0 Servers/Workstations, Configuring, System tuning
• Backup and Restore data (Tape device)
• Customer Support
Education
Graduated with a BASc. in electrical engineering from University of Toronto, June 8, 1998.
Contact this candidate