SUMMARY:

• 20 years’ work experience as DBA in development & production, Full life - cycle database management with SQL Server & Oracle, Well-organized, self-motivated team player with strong ability to understand client's business requirements and provide practical solutions within the timeframe and implement them to achieve the organization goals.
• Certifications for SQL Server DBA and Oracle DBA.
• Financial and telecommunications background for Database and Data Warehouse
• Expertise in Backup/Recovery, T-SQL, HA/DR, Performance Tune, Power-Shell, SSIS/SSAS/SSRS
• Achievement Solely developed the following tools used by several bank or insurance companies
• SQL Server Auto-Migration/Mirroring package by Power-Shell (Demo on YouTube)
• SQL Server Management GUI (Demo on YouTube)
• SQL Server Auto-Monitoring by Power-Shell

TECHNICAL SKILLS:

Languages: Transact - SQL, Power-Shell, MDX, VB Scripts PL/SQL, Shell Script, Perl

Tools: SSIS, SSAS,SSRS,DTS, Failover Cluster Manager, Erwin, SCCM/SCOM, Extended Event SQL*Plus, DBArtisan, Toad, Oradebug Transparent Gateway, Grid ControlMonitorDBCC, Profiler/DTA, SQLDiag, Spotlight, SQLPS Query Analyzer, PerfMon, DMV, Counter Logs STATSPACK,TKPROF, Explain Plan Grid Control, ASH/AWR/ ADDM

Backup: T-SQL, LiteSpeed, Veritas, TSM, Powershell,RMAN, NetBackup, imp/impdp

HA/DR: FCI/AG, Log-shipping, Database Mirroring, Availability Group, Transactional Replications,RAC, Standby, Stream Replication,Golden Gate, VMware, Veritas Cluster

OS: Windows Server, VMware, Hyper-V, SAN,Linux, Sun Solaris, HP-UX, AIX, VMware

PROFESSIONAL EXPERIENCE:

Confidential, Hudson, OH

DBA (Contractor)

Responsibilities:

• Install multiple 4-node Active-Active-Active-Passive virtual SQL Server instances
• Perform capacity plan, size and allocate virtual disk for data, log, tempdb and backup files.
• Install SQL Server and simulate activity on disk for stress test
• Install MSDTC per SQL instance group, design tempdb for better IO operation
• Setup preferred owners as well as failover/failback policy
• Develop database based on user requirement
• Design SSIS packages to load data from different data source
• Build snapshot, one-way and peer-to-peer transactional replication
• Create procedures, functions and triggers to populate data
• Generate audit process to monitor any DML activities
• Involved in server virtualization using VMware
• Load resource usage (CPU, IO etc.) for all instances in all hosts to prepare VMware servers
• Design and test HA/DR solution using different methodologies
• Design and build multiple AlwaysOn Availability Group
• Install 3-node AlwaysOn Availability Group
• Identify and resolve performance issues through OS, Instance and queries.
• Use Power-Shell to collect trace data & analyze network issues for failover cluster nodes
• Write codes to check hardware health for IO, CPU, memory and network
• Monitor SQL, Wait Event and Memory Usage through Extend Event
• Find historic performance issues by system-health
• Rewrite multiple queries to reduce running time

Environment:   MS SQL Server 2014/2012/2008 , Windows Server 2012/2008, Power-Shell, VMware, SSIS/SSRS

Confidential, Columbus, OH

DBA Card Services

• Write multiple Power-Shell scripts to automate database management
• Migrate thousands of databases with automatic user remapping between different domains Build hundreds of database mirroring with synchronizing logins automatically Install databases or procedures for hundreds of instances automatically. Create daily reports by email for the following through Power-Shell automatically
• Disk/Mount-point Usage Report for all servers
• Failed Job and Host Performance Report for all production servers
• Password Expiration Date Notification for all SQL accounts.
• Monitor Cluster Resource and Resolve Multiple Cluster Issues
• Reset Property for Cluster Resources and Resolve Failed Cluster Resource Monitor load balance for all nodes
• Construct heterogeneous replication from Oracle to SQL Server by Golden Gate
• Setup and configure snapshot and transactional replication
• Design and implement procedures to audit and regulate sever and database operations
• Develop DDL trigger to audit DDL operations on database
• Develop audit specification to catch user DML and logins activities
• Rebuild mirrored instances by crashed system databases for multiple production
• Monitor and remedy performance issue.
• Use dynamic views to identify long-running queries, index and IO issues.
• Use OS utility like resource monitor, performance monitor to pin system issues
• Use Cluster utility to identify node with resource contention.
• Define server configuration parameters for better performance
• Schedule automatic performance log collection and perform analysis
• Use Power-Shell to pin OS performance issue

Environment: MS SQL Server 2012/2008, Windows2008 Server, Power-shell, SSIS, SAN, Golden Gate

Confidential, New York, NY

Senior DBA (Contractor)

• Maintain and monitor database security and accessibility
• Create used-defined database role or application role to manage access permissions
• Create Server and Database audit specification to audit session activities
• Write procedures to generate audit reports from audit file automatically
• Develop Transact-SQL to recover a table updated incorrectly after inserted each time
• Write procedure to perform point-in-time recovery one second before update for all rows
• Generate SSIS package to load multiple flat file into fact tables of data warehouse
• Add & configure several lookup transformations with each flat file to output to fact tables.
• Use fuzzy lookup to map similar columns from reference table
• Use script component to separate invalid data
• Setup For-Each Loop container to load all flat files iteratively
• Build two-way transactional replication for real-time data synchronization.
• Generate dynamic SQL to setup articles as well as create jobs to run the replications.
• Tune the Log Reader and Distribution Agent for update-intensive operation
• Use Powershell scripts to automate management over 100 instances
• Remove obsolete users from all instances instantly using Powershell
• Scan failed jobs & disk spaces for all productions servers regularly
• Generate HTML report and email to DBA team automatically
• Monitor, Identify and resolve bottleneck issues for system and databases
• Configure instance parameters to utilize system resources for heavy transactions
• Monitor system resource contention for IO,CPU and Memory using DMV and GUI
• Replay trace file from production in the test server to compare performance changes
• Rewrite several reports to reduce running time to 10-25% of original ones   
• Identify performance issues from query, resource contention and system configuration
• Get cached execution plan, Find missing index and check index fragmentation
• Analyze requested or required memory, buffer hit ratio as well as loaded modules
• Perform driver load balance analysis and re-allocate files to reduce IO contention

Environment:   MS SQL Server 2008/2005/2K, Win. 2003/2008 Server, SAN, T-SQL, SSIS/ SSRS/SSAS

Confidential,  Danville, PA

Lead DBA

• Perform logical and physical database modeling, develop database objects.
• Collect user requirement and convert to technical specifications Load data from text or excel files to definition table using SSIS package. Create about 150 procedures, functions and triggers to populate data and handle error
• Write procedures to search metadata; modify & rebuild procedures by SQLCMD
• Install and configure Report Server, generate reports using SSRS
• Generate parameter-driven tabular reports, configure and maintain report server
• Build scaled shareable database shared by multiple report instances
• Create audit function to catch security, schema changes or DML activities
• Use DDL triggers to record security and schema changes
• Use procedures to catch all SQL statement which contains pre-defined key words
• Design and build High Availability, Disaster Recovery
• Build active-passive clustered SQL Server 2008 instance (First Clustered Server Here)
• Setup security, configure cluster-server, install SQL Server virtual instance
• Write set of SQL-like commands to manipulate cluster resource, group and failover
• Build standby database using asynchronous DB Mirroring for non-bulk-logged operation
• Build standby database using Log-Shipping for bulk-logged operation
• Develop Powershell Scripts to automate centralized management for over 30 instances
• Write Powershell to automate a set of database refreshment and migration
• Write Powershell to perform database disaster recovery for different situations
• Write Powershell to monitor jobs, spaces & cluster status etc. for all production instances
• Setup two OS jobs to run Powershell; one to collect data, another to analyze and report
• Document and maintain database system specifications, security standards etc.
• Create Transact-SQL template for developer to standardize code process
• Write guidelines for backup/recovery, disaster recovery as well as cluster process
• Monitor database and instance activities, identify and tune performance
• Write T-SQL to analyze fragmentation and rebuild or reorganize index automatically
• Perform memory and CPU analysis, setup parallel processes with proper threshold
• Analyze data file load balance, separate data, index and log files physically
• Monitor blocked processes through service broker
• Create queue, service and event notification, notify blocked processes by procedure
• Monitor query through DMV, Tune or rewrite over 30 queries for better performance
• Tune distributed queries for better performance

Environment: MS SQL Server 2008/2005, Win Server 2008/2003, SSRS/SSIS

Confidential, NE

DBA (Contractor)

• Designing Star Schema with Facts, Dimensions, Measures and Cubes
• Design data flow process of multi-dimensional data warehouse
• Design the BUS matrix for all fact and dimension tables
• Build cube with proper measures and dimension, backup SSAS databases
• Create reports from cubes by writing MDX queries.
• Create partitions for fact table and indexes
• Design sliding window process to move partitions to historic file-groups automatically
• Perform ETL between Homogenous and Heterogeneous System using SSIS
• Use Execute SQL Task to parse query and send result to Scripts Task for more processing Use Condition Split, Multicasting, Lookup, Derived Columns etc. to load data from CVS & text files
• Created tabular, chart, drill-through as well as cascading reports
• Configure report server and report manager, give proper permissions to different level of users
• Automate database management for hundred of instances through VBS (VB Scripts)
• Use VBS scan all instances for the information of backup, jobs and space usage, etc Use VBS find and install missing maintenance jobs for all instances automatically
• Standardize all maintenance jobs generically as template through TSQL
• Rewrite SQL code to analyze fragmentation and de-fragment automatically
• Monitor, identify and resolve performance issues for queries and instances
• Rewrite more than ten queries to reduce running time to 1/4 of the original in average
• Find proper driving tables for complicated query
• Tune partitioned views for fact table from full scan to range scan

Environment: MS SQL Server 2005/2000, Win Server 2003, SSIS/SSAS/SSRS

Confidential, Columbus, OH

DBA (Contractor)

• Build Active-Active-Passive virtual SQL Server 2005 instance
• Install and configure two virtual instances as well as service pack.
• Design backup strategy, setup veritas backup client to perform backup and recovery
• Create one way transactional replication for real-time data synchronization
• Tune the Log Reader and Distribution Agent for update-intensive operation
• Trace delivery latency for distributor and subscriber using Tracer-Token
• Create publications & articles to propagate changes from primary to secondary
• Use dynamic SQL queries to startup the replication jobs
• Setup two Active-Passive virtual SQL Server 2000 and 2005 instances
• Perform capacity plan and size database, allocate SAN space for data, log and temp DB.
• Write procedure to enable SQL backup job when Control-M agent fails to work
• Migrate data warehouse from SQL Server 2K to SQL Server 2005
• Move DTS to SSIS and AS (Analysis Services) through AS migration wizard
• Migrate Analysis Services cubes using Analysis Services migration wizard
• Write documents for database maintenance, installation as well as backup/recovery.
• Resolve the performance for queries and system using DMV, profile and counter log
• Monitor and optimize performance for queries, replication as well as DTS/SSIS etc.
• Tune SQL Server configuration setting for better performance
• Use profile to catch costly/slow running queries, resolve missing/incorrectly used indexes
• Identify fragmentation issues and de-fragment
• Automatic de-fragmentation process with sorting intermediate results in temp database

Environment: SQL Server 2005/2000, Oracle, Win Server 2003, T-SQL, SSIS, AS, Cluster Administrator

Confidential, Dublin, OH

Senior DBA 

• In charge of handling database objects and data for development and production of LIMS
• Translate business requirements to technical specifications
• Conduct database logical & physical modeling with normalized tables using Erwin
• Build and configure multiple database instances
• Select sizes for shared-pool, block-buffer, log-buffer and block-size.
• Layout table-space for DATA, INDEXES, RBS, TEMP, separate low-usage segments.
• Upgrade Oracle 8i database to Oracle 9i through export and import schema transfer
• Migrate data from different sources to production
• Use PL/SQL to filter and load data from other production databases
• Write Perl scripts to load data from access
• Manage database
• Create schema and users, grant privileges and access to the users
• Setup database links and database replication with snapshots.
• Develop database
• Create notification report, which access over 30 tables across 4 databases.
• Tune a single 4-page size query using different methodologies.
• Use dynamic SQL to generate schema and retrieve data.
• Create and test database objects like procedures, triggers and migrate into production.

Environment: Oracle 9i/8i, Solaris/WINNT, RMAN, SQL*Plus, Shell Scripts, TKPROF, STATSPACK, Perl, Erwin

Confidential Ann Arbor, MI

DBA

• Install, configure and size SQL Server as well as Capacity Planning
• Migrate database schema and data from Access to SQL Server by DTS
• Monitor performance statistics from server utilities, tune database/query
• Manage database/disk space, backup/recovery and security
• Create stored-procedures, functions as well as triggers for data processing

Environment: MS SQL Server 7.0, Transact SQL, DTS, Access

Confidential

DBA/Developer

• Analyze and design business process flow diagrams, Convert business requirements into technical specifications, Perform database schema design
• Install and configure SQL Server for GBAS and Oracle with OFA compliance for DTM.
• Create the logins, users as well as manage privileges/roles to ensure database security
• Design and develop the unit and integration test plan for different modules
• Administrate GBAS database daily, including backup/recovery, performance monitoring, database space management and database changes implementation.
• Load flight information between SQL Server and Oracle.
• Code GBAS database management GUI