LISA HAN

347-***-****

ad12ej@r.postjobfree.com

MCITP Certified SQL SERVER 2005 DBA/MCP SQL SERVER 2012/2014 DBA

New York, NY

QUALIFICATIONS:

10+ years of experience in Database Management Technology in Cluster, replications and log shipping, AlwaysOn, Database Design, Data Model

Extensive experience in database Design, Implementation and Administration in MS SQL Server, SSIS, SSAS, Oracle

Strong SQL Back End Programming in both Web based and Client/Server environment.

Experience in Oracle 10/11g RDBMS, Oracle Developer/2000, Oracle Forms 4.5, Reports 2.5, Sybase ASE, Postgresql, IBM DB2, MySQL, NoSQL; Python, Clouds AWS, Azure

Excellent communication skills and a key team player. Highly motivated and quick learner.

TECHNICAL EXPERTISE:

Languages: SQL, T-SQL, PL/SQL, Python, VBA, HTML, ASP, Java Script and Shell Script, HL7, CL,

Software: Oracle,SQL*Plus, SQL*Loader,, Juiptur notebook, MS visual studio, Atom, Anaconda,Micromedia,SSDT, Dreamweaver 4.0, PowerBuilder, Crystal Report, Visual Source Safe, Visible Analyst 6.0, Visio, Eclipse, DBArtisan, Lumigent, Netcool, MOM, Sybase Central,, Relativity, Spunk. AWS, Solarwinds, Web Services, ServiceNow, Liquibase,

Team Quest, Precise, Idera, Team Quest, Precise, Fog light, Redgate,SCOM

Databases: MS SQL Server, Oracle, Postgresql, Sybase, DB2, MS Access, MySql, Cassandra, Data Modeling, OLTP, DTS/SSIS, OLAP, Data Warehouse, Foxpro, Microsoft BI, MS Reporting Services, MS Analysis Services, SSIS, SSAS, SSRS, ETL, BCP, NoSQL, Big Data, Hadoop, Fivetran, Stitches, Redshift

Systems: Windows Server, iCloud, AWS, Azure, IIS, AS/400, UNIX, Linux, IBM iSeries Server, HP Polyserve, SAN, BizTalk, IIS, Commerce Server 2007, Virtualization, Powershell

PROFESSIONAL EXPERIENCE:

TEKSYSTEM INC. Sr. SQL DBA 08/2015 – Present

Provided technical Support for MS SQL Server Databases on Premise and Cloud

Conducted day-to-day administration on SQL Server for 2014/2016/2019

Configured database maintenance

Managed database health and Integrity across all systems

Diagnosed and troubleshot issues, Conduct performance tuning

Managed database capacity growth, support developers

Migrated Database into Clouds AWS\Azure

Monitor databases and supported with SSIS, SSRS

Review code release and schema

JP Morgan Inc Sr. SQL DBA 08/2012 – 07/2015

Provided Production Support for MS SQL Server Databases in High Availiabity

Performed day-to-day administration on SQL Server 2008/2012/2014

Set up and configure database mirroring, log shipping, replication

Participated in planning a Big Data/Hadoop project.

Ensured database health and integrity across all systems

Diagnosed and troubleshot issues and conducted performance tuning for optimizations

Managed database capacity growth and refreshed data from production to lower environment

Monitored databases and migrated SQL Server from SQL 2005 to SQL 2008 to SQL 2012

Supported/Worked with SSIS, SSRS, and data warehouses

Managed and implemented production release and led Disaster Recovery project

Time Warner Inc Consultant Sr. SQL DBA 09/2011 – 07/2012

Managed and supported MS SQL Server 2005/2008 R2/2012 databases

Installation and management of SQL Server, management of databases including Alwayson cluster; responsible for migration of SQL Server from SQL 2005 to SQL 2008

Imported and exported data in Oracle Data Pump utility and maintained MySQL

Set up and configurations database mirroring, Log Shipping, and worked with SSIS, SSRS

Automated maintenance jobs and installed services patching

Identified problems, found root causes and performance tuned to ensure application performance

Database Designed with tables and relationships and Indexes

Managed database capacity growth and wrote stored procedures and triggers

Maintained and managed database security and installed monitor tools on the Server

Managed User security in Oracle and backup/restore database

Bank of America Sr. SQL DBA 12/2009 – 09/2011

Provided production support for MS SQL Server 2005/2008 and maintenance in High Availability Cluster, Log Shipping, Mirroring, SRDF etc.

Collected business need to design server specs for new projects and installed and configured new SQL Server 2008 in Cluster

Conducted SQL Migrations from SQL 2000 to SQL 2005 and to SQL 2008 for large Data Center

Set up database Log shipping, Mirroring, Replication; installed and configured monitoring

Diagnosed bottlenecks and provided performance tuning for optimization

Managed database capacity growth and worked with Business Intelligence ETL SSIS, SSRS Services, support Datawarehouse database

Implemented service packs and managed database health; managed user security for compliance

Set up maintenance jobs and configurations on Server

Provided support for production releases related to database work

CDS Services Inc (Consultant) Sr. SQL DBA 06/2009 – 11/2009

Installed SQL SERVER 2008 On Cluster

Migration Databases from SQL 2005 to SQL 2008

Managed and maintained 2008/2005 Production Database Servers

Supported Developers and Business, wrote stored procedures\Queries, designed ETL SSIS

Tuned Sql Queries to Optimize Performance and Optimizing Index

Best Practice for the server management

Weight Watchers International Inc. Sr. SQL DBA 01/2008 – 05/2009

Managed and supported MS SQL Server 2000/2005 production databases

Installed SQL Server in Cluster and upgraded SQL Server from SQL 2000 to SQL 2005

Troubleshot and conducted performance tuning for applications

Automated DBA activities to help ensure the high availability of the Server

Wrote stored procedures, triggers and views

Set up log shipping and management strategy and capacity planning

Configured database in SQL 2005 to automate operation alert

Maintained and supported developers, worked with SSIS packages and SQL Analysis Services SSRS; Support datawarehouse Databases

Migrated DTS to SSIS and implemented SSIS to load data into DW systems

Supported large web applications and large data warehouse systems

Backup of Oracle database and monitored Oracle jobs

Participated in Oracle application release

CBS Corporation Inc. Sr. DBA 12/2005 - 01/2008

Managed and supported MS SQL Server 2000/2005 database in high

availability environments, including Cluster, Log Shipping, and Replication

Led DBA for consolidating MS SQL Server databases on HP Polyserve Matrix

Proactively monitored, tuned and improved database performance

Identified and troubleshot problems and resolved real-time database issues

Conducted performance tuning for applications

Designed and troubleshot ETL DTS/SSIS packages to transfer data from different platforms

Performed logical and physical database design

Upgraded MS SQL Server 7.0/6.5 to SQL 2000 and from SQL 2000 to SQL 2005

Wrote batch files to manage databases and migrated data across servers

Wrote stored procedures, triggers and views

Worked with Sybase ASE stored procedures and performance tuning

Automated DBA activities to help ensure the high availability of servers

Supported SSAS and managed OLAP database for data warehouse for financial business

Set up log shipping and replication and supported Sybase database applications

EDUCATION:

Baruch College, the City University of New York, Master of Science in Computer Information System

CERTIFICATES: MCITP Certification SQL SERVER 2005 DBA

MCP Certification SQLSERVER 2012/2014 DBA

MCP Certification SQL 2012/2014 Data Warehouse Implementation

Contact this candidate