SUMMARY:

• Extensive experience in installing, designing, architecting, modeling relational Database various schema using SQL Server, MySQL, Oracle 11, PL/SQL.
• Proficient in developing and optimizing complex stored procedure, script, t - SQL, functions, views and ad-hoc queries.
• Extensive experience in analysis, user requirements and design of business application into database and web interfaces.
• Extensive experience in tuning, raising performance and user’s troubleshooting and database administrating and authorization.
• Extensive experience of DB administration in DB resource management, monitoring and developing job scheduled, Backup, recovery and replication.
• Proficient in BI tools, migrating data, providing dashboard of reports, automation of data transaction, ETL, SSIS, SSRS,Tableau.
• Managed development team in a demanding and fast-paced environment, handling multiple tasks of agile methodology.
• Extensive experience in designing, developing web application software using PHP, C#, ASP .Net .in relation to DB platform in windows or Linux.
• Completely familiar with Cloud Computing, Splunk, NoSQL, Hadoop, Mongodb, Json.

TECHNICAL SKILLS:

Database: SQL Server (2003-2012), MySQL,Oracle PL/SQL, ETL, SSIS, SSRS, Tableau.

Languages: C#, Asp.Net, Java,php, XML, Java Script, SSH, JQuery, Json

Supporting Tools: Toad, UML, CPanel cron job, MySql Administrator, Mysql workbench, AWS, Visual Studio.Net, Log shipping, Aptana,Eclips, SQL BIDS, Crystal Reports,Tableau, Source Safe, Github

Operating Systems: Windows XP, Linux

Familiar with: Qlikview, Jira, icloud computing, NoSql, MongoDb, Hadoop, Map Reduce,Couchbase

PROFESSIONAL EXPERIENCE:

Senior Software Eng, SQL Database Developer

Confidential

Responsibilities:

• In fast-paced environment fast learning complicated Data structure and maintenance Data right database User's tools in SQL Server 2012 in Software Department.
• Design tables and Developed Stored Procedures to Validate data and Automate process
• Raise Performance and SQL Installation

Senior Database Software Engineer

Confidential

Responsibilities:

• Analyzed application requirements and business cases in detail and developed database flow and conceptual model.
• Architect database model, design schemaand tables, data types, constraint key, index and view of product and master checklist spec used Mysql workbench.
• Implemented and Maintenance the automation application system which I mentioned above to centralize IP (product) database and master check list automation
• Extend developed application by adding chip feature to centralize chip information and automation of Executive chip signoff report.
• Programming SQL ad-hoc query, store procedure and batch script or function.
• Designed & implemented web pages in PHP, HTML, CSS, jQuery, PHPExcel to present and search data and user interaction into DB and permission level using LAMP/OLTP technology.
• ETL/ELT task: import/export flat files such as csv/xls of product info and spec load from unix into temp table of DB then sort, distinguish and clean transaction by programming complicated SQL query to update DB.
• Functioned as a DBA to install MySQL. Worked closely with DB server team to set up routines for restore and backup.
• Work closely with web domain server team to set up domain web developed application in both production and development environment. Manage session variables, configuration, test and sync up domain servers.
• Work closely with Qlikview team to deliver desire reports. Provide DB model and T-SQL/ad-hoc query to use and load database.
• Individually DBA & Maintain task/ per user request to update some changes in DB or data mining or manipulating data task, writing and run bunch of ad-hoc /t-sql query and script.

Sr. SQL Database Administrator and Developer

Confidential

Responsibilities:

• Administrate, Re-Architecture of existing schemas with 120+ tables each to enhance data mining & data integrity, raising performance and tune DB of e-commerce system and source sales items used BI Sql server.
• Developed & maintained complex stored procedures, scripts, functions and ad-hoc/T-Sql queries to maintain, clean up and refine data. Used SQL Server 2008-2012 and MySQL Cron job/ write and set up Cron job task on server to run query commands and store procedures.
• ETL & DBA task: established new techniques for import/export raw data build & maintenance. Import shopping list flat files and products load into DB . Streamlined backend servers (Unix & Win) for added security, administration, maintainability.
• Maintenance& consult e-commerce web application in PHP

Database Admin and DB Architecture

Confidential

Responsibilities:

• Led migration, performance tuning, debugging, and porting Oracle 9i database system running on Windows XP to MySql on Linux platform for the California Traffic Report in Java oop .
• Designed and architected the database schema for the iPhone, Androidapplication for the utilized by 200k+ active users.
• Developed and implemented backend database (Mysql) schema supporting web interface (PHP) for border crossing wait times.

Technical Lead and DB Developer

Confidential

Responsibilities:

• Architected, Modeling and designed databases of electrical billing system, analysis and identified business process and creating Data modeling used UML and Star Schema database design technology with more than 200 tables including custom queries, views, functions and procedures from scratch till production and maintenance.
• Technical lead to develop data warehouse and writing complicated stored procedure and monitoring performance and job queue which maintain 8 CRM Subsystems supporting 4 major cities and over 5 million subscribers
• To optimized transactions and Maintained Databases, writing ad-hoc/Agil query or monitoring db tasks and test for correct operation and faster response or report
• Programmed web application in C #, ASP .Net,HTML, Java Script
• Tested and Qualified Conversion of Mainframe IBM-based Flat-File Database to Oracle Database
• Programmed store procedure and Triggers to separate business models from user’s view
• Database developer of CRM application Financial system in Sql server and Windows-based .Net developer and writing complicated query and store procedure like calculating Tax of each customer and accounting system
• Designed dynamic reporting facilities using Crystal Reports for accounting and client management system