SUMMARY

• Over seven years of IT experience in Database Administration, managing and support many different database technologies include: MS SQL Servers ( 2005 - 2017), Oracle (9i,10g, 11g and 12c), MySQL, Mongodb, PostgreSQL, Redshift
• Experience in logical & physical Design database servers, Installation, Configuration, Maintenance and provide administration support for database servers .
• Experience in monitoring and manage databases include files and disks space growth, block queries, deadlock, CPU, RAM, etc. Use power shell scripts, T-SQL script, command line script and database monitoring tools like Solarwind, Red-Gate, OME, Nagios, etc.
• Experience in Cloud computing, AWS and Azure, design, configure, maintain and monitor multiple database solutions on the cloud computing platform include MS SQL, Redshift, MySQL and PostgreSQL
• Experience in upgrading MS SQL Server and Oracle from different version in Production, QA and Development environments .
• Excellent experience with data structure design, standardized database schemas, tables and indexes, creating and managing data files and Filegroups for database space and optimize data flow operations .
• Excellent experience in data warehouse databases and OLTP systems, support, maintenance and troubleshoot . implement best practices to maintain optimal performance such as partitioning tables, archive data, proactive indexes solutions, etc. Analysis and troubleshooting to identify the bottleneck and provide optimal solution such as database architecture redesign.
• I mplementing cluster failover databases, Standby databases, DR solution, High Availability of database servers. Method included using snapshot database, mirroring and replications, VM mirroring and replication, backup and restoring and Log Shipping for DR .
• Experience Tableau administration, install, configure and manage Tableau servers. Provide ongoing admin support including user access, backups, monitoring and troubleshoot.
• Experience in Data Migration Management, ETL, SSIS, data replication between different types of databases .
• Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Experience in encrypted or decrypted databases to protect sensitive data. Using encryption key or certificate to encrypt and protect database, tables or sensitive data in a column.
• Created maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics.
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS Packages.
• Extensive experience in writing Distributed Queries between SQL Servers by creating link servers and federated servers.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
• Experience in performing integrity checks. Methods include configuring the database maintenance plan wizard and DBCC utilities.
• Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
• Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
• Experience in applying patches and service packs to keep the database at current patch level.
• Experience in migrating packages from DTS to SSIS.
• Good experience with Analysis Services, Reporting Services, and SQL Server Clustering.

TECHNICAL SKILLS

• OS: Windows, Unix, Linux, Macintosh OSX
• Databases: MS SQL Server 2005 - 2017, Oracle9i-12c, MySQL, Redshift, PostgreSQL, MongoDB, Sybase, DB2
• Languages: T-SQL, PL/SQL,Power shell, C, C++, and Core Java JDK 1.1
• SQL Server Tools: Solarwind, Redgate, Oracle Enterprise Manager, Golden Gate, Informatica, Nagios, Management Studio, Business Intelligence Development Studio, TOAD, Visual Studio 2005/ 2008/2010/2012, Kapow, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, DTS, Log Shipping, Server Network Utility, Database Tuning Wizard, Index Tuning Wizard, SSIS, SSAS, SSRS, Microsoft Clustering Services (MSCS)
• Report Tools: MS Reporting Services, Tableau, SAS, STATA
• Data Migration: MSDTS, SSIS, BCP, Data Migration, SQL Loader, Import/Export Wizard, Data dump

PROFESSIONAL EXPERIENCE

Confidential, Quincy, MA

Database Administrator

Responsibilities:

• Responsible for Database support, troubleshooting, planning, migration, upgrade, backup and restore .
• Monitoring of database size and disk space in Production, UAT & Development environments, Involved in capacity planning, sizing and database growth projections.
• Created shell scripts to monitor production databases for administration purposes.
• Used System monitor to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database server performance.
• Used DBCC commands to troubleshoot issues related to database consistency.
• Conducted various meetings and conferences with application teams to meet corporate milestones for projects and goal . Build or reconfigure database to meet all requirement for testing and training
• Central Control and Coordination data for different departments, controls and customized security profiles for different department needs to improve security and integrity.
• Performed installation, configuration and upgrading of database server software, related products, and p atch applications.
• Evaluate database features and database related products, gives profession advise to management for features and products that can improve current system and best benefit for business’s future growth .
• Responsible for documented, design and maintain database backup and recovery policies and procedures.
• Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
• Configured Database mail, linked servers in SQL server and Oracle .
• Responsible for databases refreshes, automate monthly, weekly refresh jobs, created standby production database and failover database
• Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.
• Implemented trigger and stored procedures and enforced business rules via checks and constraints.
• Migrated DTS packages to SSIS packages, created SQL job to run SSIS packages.
• Good Knowledge of using SSRS, response for support and troubleshoot SSRS issue.
• Plan and implement DR strategies, documented DR solutions, monitoring and maintain DR processes.
• Reviewed DB Scripts from the development team before releasing them into the Production.
• Provide 24/7 Production support and on Call duties, provide maintain, changes to production database on weekend .
• Work on all database related documentations include database inventory, database administrator tasks, database password change process, database installation and upgrade, etc.

Confidential, Cambridge, MA

Data Engineer

Responsibilities:

• Responsible for both g eneral OS and database a dministration and p erformance.
• Performed server installation and SQL Server installation and configuration.
• Creating and maintaining various databases for Production, built the entire production and documented the whole data process from raw data to production data.
• Responsible for updating new patches for OS, database and applications, a secured system with latest service packs and security patches.
• Planning and scheduling backups and developing recovery procedures
• Creating procedures, functions, and triggers, handling data process.
• Set up domain network with amazon servers, linked local user pc to be part of the amazon domain network’s subnet. provide data capture operations - analyst, design, and configure application/package to extract, transform and load into the databases.
• Measure and improve data capture methods, including recommendations to senior management.
• Lead the team in new best practices in data capture, constantly thinking of innovative ways to improve these processes.
• Fix and troubleshoot data capture with SQL Server and other technologies, troubleshoot slowness caused by server or database or applications. implemented source control, provide support and troubleshoot and keep source control updated with newest releases.
• Develop and implement tools to improve the Data Engineer Team.
• Research and implement a new data mining technology to the Data Engineer Team, which increase 50% efficiency for data mining process, and also makes the data mining package increase 200% more stable.
• Analysis and simplify the data mining process, makes the packages kill less CPU, so each server can stored more package than before, it helps to cut down the amount of servers require to host those data mining package, which saves company’s annual hosting fee by 40%, which is $20,000 per month .
• Computer servers management, like amazon servers, etc.