Manager Data

OBJECTIVE: Obtaining a Challenge Position as a Sr. SQL SERVER DBA

SUMMARY: Many years hands-on working experience in installing, configuring, designing,

implementing, replicating, troubleshooting, maintaining, optimizing and performance tuning Microsoft SQL Servers 2000/2005/2008/2012/2014/2016/2017/2019, T-SQL, SSIS/DTS packages, SSRS reports, SSAS, Power Shell scripts, VBA, VB.NET, C#, MDX, XML, XQUERY, HTML, Pivot Table, ASP.NET, MS AZURE, EMC Storage, VMware, SQLSentry, TOAD, Visual Studio DotNet, SQL Diagnostic Manager, Citrix, LiteSpeed, Spotlight, Idera, VMware, Delphix, and extended knowledge of MS Windows Server NT/2K/2K3/2008/2012/2016/2017.

Prefer Location: Local to NY Tri-State Area or Telecommute to Anywhere (Relocate with properly covered expense otherwise)

WORK EXPERIENCE:

Zooftware Consulting Sr. Database Consultant 02/2019-Current

Working on projects with MS Azure platform migration, sql 2017/2019 poly-base big-data migration and all sql server versions support/upgrade.

Helping implement azure paas, that including AD integration, database server migration and application migration.

Work with client to implement azue iaas to integrate datacenter db server with vendor cloud services and managed instance.

Work with client to migrate qualified application/database to Azure sql database as saas.

Sql 2016 and onward query store performance tuning and proactive monitoring via azure tool/perfmon/sql nexus/quest spotlight.

Power BI, SSRS, Crystal Report and MS AccessMIgration.

Joined Citi Bank L3 MSAAS project, sql server 2016-2019 upgrade and automation.

Allscripts Expert DBA /Architect 09/2007 – 02/2019

Working as an Database Architect, join company system design board for all project development and implementation,

Working as an Expert SQL DBA. Installing, configuring, patching, developing, maintaining, performance tuning, troubleshooting SQL Server including SQL Server 2005, 2008(R2), 2012,2014,2016,2017 and 2019.

Work closely with other IT departments and application team to deploy or expand the storage of the databases. Review, implement, and approve the database changing scripts and SQL jobs modification.

Developing, testing, and installing new standard in-house designed database maintenance jobs and procedures including the bank standard backup procedures, LiteSpeed, and TSM tape backup maintenance packages.

Set up database mirroring, high-availability always-on, log shipping, replication. Participating in testing DR plans.

Involving in testing new features of SQL Server 2016 such as contained databases, always-on high availability, dynamic data masking and auditing.

Perform defragmentation, re-indexing, and many other pre-designed performance job procedures.

Collect databases performance data in Pssdiag /Perfmon trace, proficiently use PAL/SQLNEXUS to analyze system performance.

Work with application and developers and business users to manage the patching of SQL Servers and will assist in the planning and execution of the database and job upgrades cross the development, Test, and production environment.

Supporting emergency calls, emergency change control management, and emergency operation requests. Work with incident manager to resolve emergency issues.

Create SSRS projects and SSIS packages for some specific support objects to generate some reports and transform data from different platform such as MySQL, DB2, Oracle, and Sybase.

Write T-SQL, PL/SQL, DOS, UNIX, Windows Scripts, and PowerShell or some VB/C# DotNet programs with SSIS, SSRS, and SSAS packages for automation job. Creating some cubes in SSAS analysis server to prospect or predict for the future changes in the data models. Publishing reporting data in SSRS reporting server or web servers.

Implemented sql cluster (high availability), database mirroring (DR / Downtime system), SQL2012/2014/2016/2017 Always on Availability Group and transitional replication (reporting and SSAS) for health system under 24X 7 operation environments.

7/2006 – 9/2007 Telular Corp. SQL Server DBA / Developer 07/2006 – 09/2007

Support operation of databases system 24X7 on call. Check and Monitor ETL/Nightly processes.

Install, upgrade, migrate, evaluate, and virtualize SQL servers 2000, 2005, IIS, and application Servers as required. Update Windows, SQL Servers, and application patches. Deployed IIS Website, SSIS packages, SSRS reports, and SSAS cubes projects.

Run ghost program to backup or recovery systems, back up databases, and clone VM servers as schedule. Create backup strategies and plan disaster recovery plan for production, development, and QA testing in advance and tested fail over and back on DR side. Documented server and backup information.

Make a lot of troubleshooting and performance tuning on SQL Servers. Use DTA, SQL profiler, or customized procedures to catch up the processing status for performance tuning or re-indexing.

Create Visual Studio.NET projects for IIS Web, SSIS, SSRS, and SSAS and write queries and codes using T-SQL, ASP.NET, VB.NET, C#, VB, Powershell or other shell scripts. Create and generate scripts for triggers, stored procedures, tables, databases, functions, indexes, rules, and custom define variables, etc. Create SSIS/DTS BIDS packages to extract and transform data from heterogeneous data sources such as DB2 and Oracle.

Install clustering SQL Server and set up database mirroring. Test SQL Server 2000 and 2005 Database transactional replication. Configured and set up log shipping and tape backups.

Create fault tolerance using SQL Server clustering, database mirroring, and snapshot. Set up load balancing for application server using redundant connections. Maintain disk array enclosure, iSCSI SAN, and other storage system as needed.

Gather users’ requirements and translate them into technical specifications for data modeling.

ATC Healthcare Inc. SQL DBA 10/2000 – 7/2006

Provide 24X7 supports in HQ data center for global manufacturing. Install, configure, upgrade, migrate, maintain, and back up SQL Server 7 and 2000.

Monitor and trace the status of SQL Servers and web-based application servers using customized procedures for performance tuning and troubleshooting purpose. Check error logs daily and create alerts to determine the solution for any possible problems; troubleshooting transitional and merge replications. Create log shipping for production servers with portable LiteSpeed customized scripts.

Create and maintain replication multiple locations. Utilize SQL diagnostics manager, NetIQ, AppManager, ApexSQL, ActiveX Monitor, SQL Answer Mail and other tools to enhance database functions. Design databases for database management related functions. Publish collected data in a web portal created in ASP.NET and DotNet Charting with ActiveX scripts and VB.NET coding.

Write T-SQL, ActiveX, Windows scripts and coding for automating ETL/Maintenance job.

Implemented and maintaining Microsoft Great Plain e-Enterprise Accounting system which contains Project Accounting, Human Resource, Sales Order Process, Receivable Management and General Leger modules across 60 offices in the states.

Developed Web application to integrate the business information from SQL, Oracle, FoxPro and MS Access Databases using ASP, VB and Crystal Report; implement Data Warehouse and OLAP for Sales, Profit Margin, Billing, Payroll analysis for all branch offices/Employees/Clients Via Extra-Net/Intranet.

Responsible for complete data flow between Corp and branch offices.

Responsible for DB Server performance tuning, data modeling, data replication, OLAP and disaster recovery.

Upgraded Microsoft Great Plains e-Enterprise in Version 5.5/6.0/7.5/8.0, SQL server 7.0 / 2000.

Developed Intranet Web base Data Pump to integrate the Legacy system data with E-Enterprise system in VB, ASP and Crystal Report.

Developed the corporate centralize system to replace current de-centralize system using Microsoft Terminal Service, Citrix Server MetaFrame and Balance Loading under windows’ 2000/XP environment, which will greatly reduce the corporate operation cost.

Migrating ASP/Crystal Report applications to Net/Microsoft Report Services platform.

Supervising application support / trainer team to support users under production environment

Publishers Clearing House/The Power Line System Manager/DBA 6/1993 - 11/2000

Designed, installed and maintaining a glowing Wide Area Network with a total of 5 locations, 16 servers and 300+ nodes.

Installed, configured and maintaining MS SQL Server 7.0, MS-Exchange Server 5.5, Proxy Server 2.0, Index Server, Certificate Server, IIS 2.0, Primary DNS, DHCP and RAS in NT 4.0 environment.

Installed, configured and maintaining NDS, DNS, FTP, DSS, NIS and NFS in NetWare 4.11/5.0 environment.

Upgraded SCO UNIX to Open Server 5, Setup SNMP agent, monitoring UNIX system performance and administrating Informix Online.

Developing Internet/Intranet web applications which include online shopping cart, shipping process, Inventory Control, billing process, online reporting system and quality control modules in InterDev, Dream wave, Firework, VBScript, JavaScript, HTML, DHTML, Active Server Page, Photo Shop, Informix Online and SQL Server 7.0. Hosting and maintaining business client’s online applications and 16+ domains with mail, http, https, ftp and firewall.

Developed marketing information tracking system in Power Builder and Informix Online.

Configured Cisco 4500, 2501 and 1600 routers under company WAN using OSPF.

Education

New York Institute of Technology, Old Westbury, NY

MS in Computer Science, G.P.A. 3.4

Informix Online Training Certificate

SQL Skill Advanced training by Paul Randle

Microsoft SQL Server 7.0/2000/2005/2008/2012 DBA Training Certificate

Microsoft SQL Analysis Service Training Certificate

Power Shell 2.0 Training Certificate

Oracle 10g Administration Training

Working Status: US Citizen

Contact this candidate