OVERVIEW:

• Microsoft certified MCTS and MCITP in SQL Server 2008 DBA. Also a certified MCDBA, MCSE, MCP, MCP I, A
• 16 years of hands - on production database administration and development experiences in consulting, academic, financial, environmental, government, software, medical, pharmaceutical and SAAS areas
• Good exposure to MS BI with an interest of becoming a DWA
• Detail-oriented self-starter and quick learner. Breathe in technical challenges. Believer of creativity and efficiency. Non-stop technology absorber without feeling boredom
• Professional Mission-driven working attitude with persistence and patience
• Highly educated with Ph.D. degree in bio-science. Proficient in analysis, trouble shooting and project design methods
• Publication grade writing skills and an advocate of documenting, communicating and knowledge sharing
• Customer focused with well-rounded personality. Good people skills. A team player preferring to work independently

SQL SKILL:

SQL Server 2014/2012/2008R2/2008/2005/2000 administration, multi-node multi-instance clustering, HADR AlwaysOn, SSRS, SSIS, SSAS, DTS, installation and patching, transactional replication, database mirroring, log shipping, backup and restore with MS SQL native/SQL LiteSpeed/Idera SQLSafe compression, resource governor, IFI, performance tuning, DMVF, database monitoring and alerting, Database Engine Tuning Advisor, security best practice, audit, T-SQL querying, stored procedure, function, trigger, view, CTE, UNPIVOT, TDE, XML, data modeling, physical design, online index rebuild, DDL trigger, WMI events alert, MS Fulltext/Alta Vista/Lucene text search, DBCC, ODBC, database mail, disk space tracking and trend analysis, PAGE/ROW compression, data mart sliding window partitioning, partial filegroup backup and restore, VLDB, CDC, CT, PBM, ADSI Active Directory querying, linked server for SQL OLE DB, Oracle, Sybase, MS Access Jet driver. Red-Gate SQL/Data Compare, Idera, HP SiteScope, NetIQ, Advantage, Quest Spotlight, Lumigent Log Explorer, Toad, Navicat, undocumented DBCC/xp/stored procedure/functions. Naming conventions.

EXPERIENCE:

Confidential

• Principal Database Administrator telecommute
• Design, implement and support SQL Server 2012 AlwaysOn Availability Groups for call center applications.
• Migrate SQL Server 2005/2008 databases to SQL Server 2012 with HADR
• Automate new database creation with AlwaysOn Availability Group
• Migrate SSRS 2008 R2 to SSRS 2012. Support both reporting server platforms.
• Revamp RDL upload approach with rs utility
• Design SSRS 2012 security architecture
• In charge of schema releases for DEV/QA/PROD.
• Develop SSIS 2012 packages in ETL.
• Evaluate SQL Server 2014 in test environment.

Confidential

Principal SQL Server Administrator

• Technical account manager providing primary DBA support for multiple clients. Proven customer-facing experiences and skills to keep clients satisfaction.
• Provide customer high availability solutions by designing, building and supporting SQL Server 2012/2008R2/2008/2005/2000 multi-node multi-instance clusters.
• Help clients achieve huge disk space saving and better performance by designing and implementing database compression with optimal performance and balanced resource overhead.
• Design, test and implement Resource Governor to control customer applications that dominate SQL Server resources, thus preventing run-away queries freezing up SQL Server.
• Design corporate level audit solution with SQL Server 2008 R2 Audit.
• Complete analysis of database performance with execution plans, DMVFs, traces and perfmons.
• Investigate and provide proof for virtualization of SQL server instances in VmWare.
• Experiences of working with databases for Sharepoint 2010, ERP, CRM, SiteScope 2010, Kronos, SCOM
• Experiences of working with DBA tools, including IDERA Suite, SQLLiteSpeed, Sitescope monitors.
• Design and implement logon trigger for auditing requirement.
• Design and implement DDL trigger based alert system for SQL Server and database level events.
• 10 TB database administration and support experiences in a production environment.
• Experience of working in mixed environments with Oracle 10/11 g, Sybase, and MySQL. CLOUD based hosting.
• Solid experience in UTIL based ticketing system.
• SQL 2008 BI: Developing SSIS packages to synchronize tables and to import AD logon logs, Design reports to aggregate logon reports. Migrating SSIS packages and SSRS reports between environments. Administer data warehouse including processing SSAS cubes and running jobs to populate dimensional and fact tables.

Confidential

SQL DBA Consultant

• Help client setup database HA solution. Design, build, configure and support SQL Server 2008 cluster on Windows server 2008 with DELL hardware. Design migration of SharePoint and CRM applications to clustered environment.
• Develop SQL Server 2008 SSIS packages to ETL data between Oracle 10g databases, and between Oracle and SQL 2008 databases. Tune ETL performance in indexes, source data loading, lookup, merge join, and data conversion.
• Configure SSRS 2008 production server and migrate test reports. Develop reports for PeopleSoft data warehouse. Standardize report template. Help end users work smoothly in BIDS.
• Support SQL Server 2008/2005 mixed OLTP environments. Focus on disk space saving with backup compression and data/index page compression. Improve server performance through Resource Governor.
• Acquire entry-level Oracle experience. Install Oracle 10g client, set up connection, write PL/SQL scripts, Attunity and OLE DB Oracle connector. Daily use of Oracle admin tools Toad, Navicat, and SQL Plus .

Confidential

Principal DBA

• Support a non-profit organization with SQL Server 2008/2005/2000 servers spanning various environments.
• Database tech lead in data warehouse project using SQL Server 2005/2008 BI technology. Assist to design data warehouse/data mart architecture. Establish deployment procedures and security requirements for SSIS, SSAS and SSRS. Define hardware and software specifications for the BI data warehouse platform.
• Build and co-design new mission critical projects with SQL Server 2008 technology. Assessed CDC Change Data Capture, CT Change Tracking, backup/data compression, TDE Transparent Data Encryption, and auditing.
• Write project proposals, give technical presentations, document architectural design and strategies, rules, procedures, best practices and name conventions. Author a SQL Server and Database Standard guide.
• Performance tune transactional replication with high throughput and low latency. Investigate and pinpoint performance bottleneck on subscriber triggers. Work with database engineers to redesign trigger based denormalized campaign tables and performance tune triggers.
• Design hardware and software specification for various projects using SQL Server 2005/2008 64-bit Enterprise Edition on Windows 2003 64 bit Enterprise Edition. Use HP Blade servers with EMC storage attached SAN and NAS.
• Design filegroups, partitions and partial file backup strategy for VLDB data warehouse project.
• Design and implement a customized Online Index Rebuild process with SSRS 2008 report as monitoring tool.
• Design production SQL Server monitoring and notification process with Database Mail as backbone that alerts on database blocking, disk space shortage, job failure, service down, error log events and DDL trigger events. Trend analysis of disk usage, database and object space growth.
• Design true hot standby availability solution using Database Mirroring technology.
• Spearhead building SQL Server 2005 based clustering to provide HA solution.
• Design reporting platform using database snapshot off mirrored database and replace existing log shipping.
• Design, test, deploy and maintain highly performed SQL Server 2008 Reporting Server. Author on-demand reports.
• Reinforce SQL Server security standards and best practice. Implement least privileges including Using schema and role based security administration, using integrated authentication mode, running SQL services under separate regular domain user accounts, judicious assessment of request to grant dbo or sa access, reduce surface areas, etc.
• Familiar with VMware. Work closely with System Engineers on P-to-V projects with ESX clusters.

Confidential

Database Administrator

• Support around 60 SQL 2005/SQL 2000 active/active clustered instances.
• Perform backup and restore routines.
• Migration of SQL 2000 to SQL 2005 servers on a Windows 2003 clustered platform.
• Design automation of database routines including but not limited to backup/restore, refreshing testing/dev/QA boxes, monitoring on server status, login failures, error log event check, disk and database space growth.
• Research and implement SQL 2005/2008 new features.

Confidential

Senior Database Administrator

• Support the highly transactional main site of Monster with emphasis on performance. Monitor, detect and fix SQL server issues that contribute to site slowness. Expert on using SQL profiler, server side traces, system stored procedures and tables to pinpoint database issues caused by recompilations, outdated statistics, use of wrong indexes, blocks, uncached stored procedures, and heavy procedure calls.
• Support multiple SQL server 2000 64-bit on Windows 2003 64-bit platforms, full instance of 1.5 TB data with rapid growth, 50 dev/int/QA/prod SQL instances. Apply service packs and patches. Maintain and refresh QA, integration and development environments through backup/restore.
• Resolve disk space issues on multiple servers. Work with EMC experts to upgrade LUNs to add more space for QA, and work with in-house NT group to add extra disk arrays in various environments. Write T-SQL scripts to monitor and calculate disk space usage in daily operation and routine refresh process.
• Write complicated DTS packages to cope with cross server joins and to increase performance. Examples are massive data modifications, release hot fixes, rebuild tables, monitoring SQL error logs, and so on.
• Support complicated transactional replications in a remote distributor architecture. Resolve replication errors.
• Support remote fail-over sites through log shipping.
• Support a semi-production reporting server via log shipping and backup/restore.
• Work with Rational ClearQuest ticket system to assign and resolve tickets.
• Review schema and data kits for projects. Interact with developers to fix errors, give proposals and tune SQL statements. Serve as last line of defense of protecting bad and/or under performed codes getting into production.
• Coordinate between DBA, networking, QA, developer and shift groups to get projects done. Delegate DBA to attend project meetings. Document database related procedures and rules.
• Evaluation of SQL Server 2005. Installation and upgrade, database mirroring, database mail, service broker, XML, CTE, SSMS, and new security features.
• Part of a busy DBA team for on-call rotations, production releases and other weekend assignments. Responsible for interviewing candidates, training new DBA/consultants, and assigning projects.

Confidential

Senior Database Systems Engineer

• Support SQL Server 2000 databases for fund and stock trading system.
• Design a system to find disk IO usage to assist relocation of database files.
• Redesign database backup/restore architecture. Implemented disk based backups.
• Automate SQL server processes including disk space alerts, schema changes, critical errors, and blocks.
• Performance tune production SQL server by reviewing stored procedures, replacing cursors, table variables, index tuning, user-defined functions and file groups.

Confidential

Senior SQL DBA

• Support a mixed environment of more than 50 SQL 2000 and 7.0 servers with over 1 TB databases. Support applications written with .NET, Power Builder, Crystal Report and Actuate Report. Support 4000 end users.
• Design full database and log backup and restore. Automate daily restore of refreshing testing server. Implement SQLLiteSpeed backup and restore in addition to Microsoft native backup and restore for large databases. Automate regular refresh of development and test SQL servers using production backups.
• Tune application performance due to slow SQL queries via profiler, query execution plan, hints, index, and hardware resources. Examples include recompilations, rolling blocks, etc.
• Automate SQL server maintenance jobs including reindexing, integrity checking, error log checking, table fragmentation checking, block and lock checking, etc.
• Post new versions of in house web applications and refresh development and test SQL servers.
• Manage security of SQL logins, roles, and user accounts Grant/revoke permissions for objects.
• Install/uninstall SQL servers. Apply service packs and security patches for Slammer virus.
• Synchronize SQL servers. Moving databases to upgraded SQL servers.
• Performance monitor of baseline and daily usage of SQL resources including processor, memory, disk I/O, paging, cache, locking and blocking, etc.
• Automate SQL monitoring via SQLmail, alert, and scheduled jobs. Notifications via Outlook and pager.
• Distributed queries via linked servers and remote servers to interact with Sybase, SQL, and Active Directory.
• Disaster recovery and fault tolerance. Set up clustering failover support, backup and restore, and inventory on SQL server hardware/software/patch/role.
• Transactional replication between primary and report/remote production servers Customize replication stored procedures Automate create/drop replications without snapshot. Troubleshoot replication errors.
• Implement active/active and active/passive clustering solutions for SQL 2000 servers in a testing environment.
• Implement Log shipping on local/remote warm standby servers.
• Develop stored procedures, triggers and other T-SQL scripts and help developers optimize and trouble shoot codes.
• Evaluate, spec and build hardware for SQL server machines including DELL PowerEdge 6650, Compaq Proliant 8500, and Compaq Proliant DL380 G2. Exposure to EMC Clariion 4700, 4500 and HP StorageWorks msa1000 SAN.
• Participate in conversion of PeopleSoft database from Sybase to SQL.

Confidential

SQL DBA Consultant

• Support a Power Builder web application to administer student loans and grants.
• Write T-SQL ad hoc queries for State staff against educational databases.
• Assist JAVA consultant to develop, debug and upgrade financial aid pFAIDS .
• Generate rosters and letters for schools and students in the New England area using PowerFAIDS software.
• Generate reports using MS Access and Crystal Reports.

Confidential

Junior SQL Database Administrator

• Maintain over 200 school databases on tera-byte SQL 7.0 servers.
• Backup and restore databases. Create and maintain customized standby server.
• Fulltext catalogs and index performance tuning.
• Create, modify, maintain and trouble shoot scheduled jobs.
• DTS packages for data import and export of various formats: SQL, Excel and csv.
• One-way and two-way transactional replications.
• T-SQL programming of stored procedures, triggers, etc. Extensive use of cursors.
• Manage database and transaction log files and auto shrink log files.
• Work closely with ASP and JAVA developers on Internet business projects.

Confidential

Network/SQL Server Administrator

• Start database career with SQL Server 6.5 by learn-at-work approach. SQL Server responsibilities include but not limited to: Install SQL Server, create database devices, backup and restore database using VERITAS Backup Exec, Check database consistency and integrity using DBCC statements, manage logins, roles, user accounts and permissions, Set up SQL Mail with Exchange server to automate alerts.
• Maintain Windows PDC, BDC, IIS and Exchange servers. Configure domain trust relationship. Solid Win NT 4.0 skills.
• End user support for in house applications Order Entry, Accounting, Customer Support running on SQL servers.