PROFILE:

• Database administrator with extensive experience in designing, coding, testing, and supporting next - generation database solutions.
• Well-rounded SQL Database knowledge in Data Warehouse, AlwaysOn Availability, Data Quality Service, Database Optimization and Administration.
• Deep understanding of a broad range of technologies.
• Twenty years of solid IT experience with two major public investment banks, a private-held credit card payment processor, a software development company and other industries.

TECHNICAL SKILLS:

Enterprise Databases: SQL Server (2014, 2012, 2008 R2, 2005, 2000, 7.0, 6.5), Paradox 5, dBase IV, Foxpro, MS Access

Database Design: ER/Studio, Erwin

Database Optimization: Confio Ignite8, Red Gate SQL Toolbelt, SQLIO/SQLIOSIM, CrystalDiskMark, Solarwinds. Idera Diagnostic Manager and other free tools

Others: MDX, DAX, T-SQL DML, SSIS, SSAS, SSRS, DTS, OLAP, Shell Scripting, ETL, Report Builder, Visual Studio

PROFESSIONAL EXPERIENCE:

Confidential

DBA Consultant

• Provided database architecture, design, installation, configuration, technical support, and maintenance of the MS SQL Enterprise databases in a Storage Area Network and Cluster Server environment.
• Designed and implemented ETL processes, the Import Entry Feed project, which automatically load third party XML files to SQL database, and then produced multiple ASCII files per format file for international clients.
• Demonstrated and provided best practices and methodologies for development team.
• Optimized and automated archiving processes for warehousing large partitioned production data in TB size regularly across multiple airport hub databases. It was designed with the consideration of flexibility, consistency, accuracy, efficiency and driven by metadata.
• Troubleshot database performance issues, identified and monitored inefficient and poor performing SQL queries, batches, statements and stored procedures causing blocks and deadlocks, such as long or most frequent queries or queries consuming unusually high CPU or I/O.
• Set up a central SQL Job Management System along with alert and report features, which enable administrators to see jobs and identify job contention across multiple servers. Maximized hardware resources and improved application performance by leveling jobs across available resources.

Senior Database Administrator

• Ensured all 60 SQL servers were backed up in a way that met the business's Recovery Point Objectives (RPO) by thoroughly analyzing business model, customizing maintenance plans and tested various replication and failover method.
• Configured SQL Server monitoring utilities to minimize false alarms, set up server security polices and alerts.
• Developed dynamic triggers, TSQL, functions, and stored procedures. Approved new database designs.
• Determined whether to use clustering, log shipping, mirroring, transactional or slapshot replication, Windows Azure, or other technologies, when a new systems was introduced to the company.
• Installed, configured and upgraded SQL servers side-by-side or in-place from 2000 /2005 to 200 8R 2/2012/2014.
• Properly configured Window Failover Clustering and AwaysOn Availability Group and offloaded reporting read-only connections from the primary servers freed up for OLTP processing.
• On-call troubleshoot SQL Server service outages. When performance issues arose, evaluated the most effective way to increase performance including hardware purchases, server configuration changes, index/query changes and finding DMV queries to answer questions about server-level performance. Using free tools like Idera or Redgate and in-house development system to diagnose server reliability and performance issues.
• Conducted SQLIO/SQLIOSIM tests for benchmarking hard drive performance and stress tests.
• Established and enforced best practices, coding policies and proper documentation. Trained developers to write efficient SQL statements. Be consistently practicing code review before production deployment.

Database/Data Warehouse Administrator

• Led installation and upgrade Microsoft Database Engine, Analysis/Reporting/Intelligence Services in SQL Server 2005, 2008R2 and 2012.
• Administrated SQL server database security, backup, and recovery in a cloud network; monitor index fragmentation and manage database available space; enforce SQL server database naming conventions using Policy Based Management and ensure data integrity using server/database triggers.
• Utilized the enterprise solution Transparent Data Encryption (TDE) to ensure database backup security. In addition, performed decryption to encrypted credit card and social security numbers upon request.
• Monitored data performance using Ignite. Troubleshot/tuned database objects to solve problems or improve performance. Reengineer ETL processes if it is necessary. Performed code review; deployed database objects across development, QA, and production servers;.
• Designed and implement daily/monthly production data transfer via SSIS packages; Updated legacy DTS packages to dynamic SSIS package; Automate ETL by SQL agent jobs.
• Responsible for the successful delivery of business intelligence information to the entire organization and experienced in system analysis, BI development and implementations, data architecture and data warehousing.
• Coordinated senior staff of Credit Analysis Service, Risk, Customer Service, Compliance and Finance department to produce robust in-depth comprehensive SSRS reports for customer accounts, and identified key trends, business opportunities or risks, and sometimes create ad-hoc brief customer/vendor/market analysis.
• Create interactive, tabular, graphical or free-form SSRS reports in Microsoft SQL Server Business Intelligence Development Studio (BIDS) or Report Builder for EVO managers/clients. Based on their requirements, write stored procedures to pre-aggregate data or program to retrieve meaningful datasets from different SQL server databases. Publish reports, which can be viewed over a web-based connection; schedule report processing to meet client’s needs of accessing reports on-demand.
• Design and implement star schema, perform ETLs and use SSAS to prepare large scale and multi-dimensional transactional data from data warehouse for Finance department, and validate results of OLTP and OLAP with business party. As a result, they can create Power Pivot tables, which connect to the SSAS service that I prepare for them, and perform accurate calculation in Microsoft Excel spreadsheet.
• Optimized BI solutions by monitoring and turning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues across 45 database production servers and 700+ databases.

ETL Processing Consultant

• Managed a project called Workforce Optimization for Citi corp North America Technology, in the Transaction Processing group. The software provided the functionality to forecast staffing needs to meet customer arrivals and demands for transactions with a “just-in-time” approach, down to 15 minute intervals.
• Clarified business requirements with vendors to customize the Planet application and match Citi Group’s needs.
• Worked with Citi transaction resource centers to establish transaction feed to data processing system, manipulated data format, and then export integrated data to Planet.
• Supported and handled production data processing issues and/or change control across Development, QA, UAT and Production environment.
• Established ETL standards via Stored Procedures, Bulk Insert and SSIS package.
• Evaluated, selected and optimized the efficiency among different data transaction methods.
• Troubleshot network/server hardware configuration issues, and leveraged VMware platform for data storage.

Quality Assurance Analyst

• NBTY is a leading, global, vertically-integrated manufacturer, marketer and distributor of nutritional supplements.
• Responsible for high level of programming, code review, data analysis, functional testing, system testing, integration testing and defect tracking against the company’s E-commerce websites.
• Worked with project managers, programmers, business analysts, network administrators, marketing, and senior management, regarding new project development or maintenance.
• Improved processes, understood the needs of the Customer Service and Marketing point of view to promote their sense of satisfaction. Monitored performance of online stores and shopping cart activities.

Web Application Security Manager

• Implemented and built company Intranet, EDCis in Coldfusion, Content Management System, Commonspot and in a load-balanced cluster environment to maintain optimized performance levels while enhancing high availability
• Developed Single Sign-on solution and personalized web page, MyEDCis, to integrate Active Directory Login and Application Login for intranet security control. Developed in-house applications, such as Project Central, Press Digest, Conference Room Reservation, and File Box Tracking System.
• Responsible for web site administration, including installations of server software updates, monitoring server activities and setting up security policies, and scheduling auto tasks and procedures.

Senior Programmer

• Established coding methodology and standardized source code library. Promoted technologies like Coldfusion, Fusbox, Ajax and XML among the development team.
• Developed a project management application for the Office of General Technology. This robust documentation repository allowed project managers and programmers to search and retrieve files by project, client, programmer, and date range. It included features, such as checking conflicting schedules, scheduling meetings, and uploading documents.

DBA, Webmaster

Responsibilities:

• Fulfilled SQL server administration responsibilities using MS SQL 6.5 & 7 Enterprise.
• Designed relational databases, ensured data integrity, security policies and optimized data objects and improve database infrastructure to achieve better performance of web applications..
• Developed database scripts and deployed various database objects throughout the entire software development life circle.
• Programmed Power Builder applications and stored backend data in Sybase. Later successfully migrated and converted Sybase database into MS SQL Server and Power Builder Applications into Web Applications.
• Responsible for internet & intranet security. Implemented Digital Certificate from Verisign to the internet web server. Provided comprehensive analysis and reports of web server traffic using WebTrends Log Analyzer.