Sql Server Data

Charles Deng

** ***** **. **********, ** *******.****@*****.*** 609-***-****

Summary: I have been working on IT for over 13 year. My expertise is on MS SQL Server, performance tuning, database modeling, Security auditing, database and data warehouse architect for physical and logical design, high availability, AlwaysOn, clustering, replication, mirroring, log shipping, and ETL, SSIS, expensive stored procedures, triggers, functions, version upgrade to 2012, 2014, databases migration, windows server configure, maintenance, project management.

InsightDiscovery Princeton, NJ (9/2015 – present)

MS SQL Server Database Administrator and Partner

Database and server assessment and auditing.

Performance tuning.

HA configuration and disaster recovery geographically.

Transactional replication, database mirroring, AlwaysOn, Clustering, log shipping

Data warehouse and ETL.

ALK Technology Princeton, NJ (8/2012 – 9/2015)

Senior Data Architect (MSSQL Server)

Database modeling, physical and logical design on both OLPT databases and OLAP data warehouse.

Design, implement, and manage HA solution geographically on mission critical database systems (VLDBs), including AlwaysOn, clustering, mirroring, log shipping, and transactional replication (one-way and bi-directional) between domains and through internet.

Work closely with Dev team on table design, stored procedures, functions etc,

Code review and push from Dev, to QA, to Pre-prod, and production.

Migrate databases from data center to Amazon AWS.

Configure and implement SQL Server 2012 and 2014 AlwaysOn High Availability.

Implement transactional replication (1-way or bidirectional) between domains.

Implement column store index on data warehouse on SQL server 2014.

Performance and I/O tuning. Detect and resolve blocks, deadlocks, I/O wait time, wait type.

Implement databases and servers assessment, find the bottleneck.

Upgrade SQL Server to 2012 and 2014.

Database and server assessment and security auditing.

Design and implement data warehouse and reporting system, ETL, ELT, and reporting procedures.

Design and implement disaster and recovery plan.

Optimize stored procedures, functions, trigger, etc. Reduce server and IO load.

Design and implement distributed databases system on very heavily load system.

Manage and optimize several 24x7 multi-terabyte VLDBs on clustered environment (very large databases with very heavy transactions).

Create alerts, scripts to proactively monitor the database systems to ensure secure services with minimum downtime.

Storage and space planning on SAN, and EBS volume.

Jewish Renaissance Medical Center Perth Amboy, NJ (3/2010 – 8/2012)

IT Director

Develop and execute Technology Solutions for IT Assessments, Virtualization, Storage and Network Architecture on SAN, Security Assessments and Data Compliance, high availability of production environment, geographic DR and data center.

Took care of planning, organizing, controlling and management of all the IT employees, operations as well as quality and all the issues and projects pertaining to information technology.

Set annual targets related to IT operations and monitor the overall performance of the entire department.

Managed and led all projects designed from the point of view of achieving the organizational goals and objectives.

Overseen the development, design, and implementation of new applications and changes to existing computers and servers and software packages.

Established company infrastructure to support and guide individual divisions/departments/sites in computing/information technology and telecommunications efforts.

Monitored network scrutiny and supervise the entire network system of the organization Manages and optimizes infrastructure assets to sustain business operations.

Led development teams on projects of developing patient tracking system, clinical forms, reports, etc.

Database architect with SQL Server 2000 to 2008R2 and development and design, scheme modeling, ETL, OLAP, SSIS, SSRS.

Led developers on various .net and java application.

Write advanced complicated stored procedures, triggers, functions, etc.

Designed and implemented geographic HA and DR for all mission critical applications.

Zeta Interactive NY, NY (10/2007 – 3/2010)

Database Architect (MSSQL SERVER)

Physical and logical database architecture design on SEO, SEM, Social Medial, SMS, and Email Marketing.

Managed and optimized several 24x7 multi-terabyte VLDBs (very large databases with very heavy transaction).

Designed and implemented terabyte data warehouse and reporting system.

Performance and I/O tuning. Detect and resolve blocks, deadlocks, I/O wait time.

Implemented HA solutions mission critical database systems, including clustering, mirroring, replication, and log shipping.

Implement transactional replication (1way or bidirectional) between domains.

Supported a team of developers on various .Net and java applications.

Created and implemented disaster and recovery plan.

Storage planning on SAN.

Designed and implemented ETL processes between disparate systems

Created alerts systems to monitor storage, database performance and data integrity.

Created procedure and implemented scheme and objects changes between dev and production environments.

Involved all database architecture, wrote advanced complicated stored procedures, triggers, functions, and other objects for all projects.

Storage planning, windows scripts, c#, vb.net programming,

Database architect with SQL Server 2000 to 2008R2 and development and design, scheme modeling, ETL, OLAP, SSIS, SSRS.

AdverMedia Parsippany, NJ (5/2007 – 10/2007)

Senior Database Administrator (MSSQL Server)

Architected databases and data warehouse for high volume transactions systems.

Physical and logical database architecture design on SEO, SEM, Social Medial, SMS, and Email Marketing.

Optimized several 24x7 multi-terabyte VLDBs (very large databases).

Designed and implemented terabyte data warehouse and reporting system.

Performance and I/O tuning. Detect and resolve blocks, deadlocks, I/O wait time.

Storage planning on SAN.

Implemented HA solutions mission critical database systems to geographical DR site.

Supported a team of 15 developers on various .Net and java applications.

Created and implemented replication and log shipping.

Created alerts and scripts to monitor all servers, configured IPCheck to monitor databases and systems.

Involved all database architecture design, wrote advanced complicated stored procedures, triggers, functions, and other objects for all projects.

DigitalGrit Boonton, NJ (9/2006 – 5/2007)

Senior Database Administrator (MSSQL Server)

Architected databases and data warehouse for high volume transactions systems.

Physical and logical database architecture design on SEO, SEM, Social Medial, SMS, and Email Marketing.

Optimized several 24x7 multi-terabyte VLDBs (very large databases).

Designed and implemented terabyte data warehouse and reporting system.

Implemented partitioning schemes to optimize databases loads and performance.

Storage planning on SAN.

Implemented HA solutions mission critical database systems to geographical DR site.

Supported a team of 15 developers on various .Net and java applications.

Created and implemented replication and log shipping.

Created alerts and scripts to monitor all servers, configured IPCheck to monitor databases and systems.

Involved all database architecture design, wrote advanced complicated stored procedures, triggers, functions, and other objects for all projects.

Sanofi Aventis Bridgewater, NJ (6/2006 – 9/2006)

Senior Database Administrator (MSSQL Server)

Day to day SQL DBA administration tasks

Managed over 100 servers and thousands of databases.

Wrote complex stored procedures for multi applications.

Performance tuning large databases.

Configured log shipping and replication on several production databases.

Jewish Renascence Perth Amboy, NJ (3/2006 – 6/2006)

Senior Database Administrator (MSSQL Server)

Day to day SQL DBA administration tasks

Managed over 100 servers and thousands of databases.

Wrote complex stored procedures for multi applications.

Fidelis Manhattan, NYC (9/2005 – 3/2006)

Senior Database Administrator (MSSQL Server)

Day to day SQL DBA administration tasks.

Created and implemented database DR plan.

Optimize stored procedures and queries.

Design and manage claims upload/data feed in projects.

Redesigned and managed MEDS data warehouse and reporting services by .net environment.

Supported and managed claims data warehouse for claims and financial department, including redesign schema, stored procedures, functions, and triggers.

Worked with development team on projects, involved in all phases of projects lifecycle, including inception through elaboration, construction and transition.

Worked with development team on designing and managing data warehouse, and OLAP cubes for reporting services by analysis services and .net environment.

Plainfield Medical Center, Plainfield, NJ (3/2002 – 9/2005)

Database Administrator/database developer (MSSQL Server)

Day to day SQL DBA administration tasks.

Administered, maintained, developed and implemented policies and procedures for ensuring the security, consistency, and integrity of databases.

Created and maintained database replication and log shipping on multi-servers.

Implemented ETL for multi operations.

Created and managed Snapshot and transactional replication and log shipping.

Education:

Master of Science in Computer Science – Rutgers University 2003

Contact this candidate