Project Manager Sql Server

CAREER SUMMARY

Experience for more than ** years in RDBMS. Focus on database design, maintain, stored procedures, Data Extract, Transform and Load.

In-depth knowledge of Software Development Life Cycle (SDLC)

Expert in PHP, Web Services, SOAP, REST, JDBCand WordPress

Hands on experience on UML, for developing application specific Object model, Use case diagrams, Class diagrams, Sequence diagrams and State diagrams.

ETL structured and unstructured data from different sources to Oracle database up to G bytes.

Experience in developing and maintaining both front-end and back-end.

Solid skills in database Oracle, MySQL, MS SQL SERVER.

Expertise in SQL and PL/SQL programming.

Solid experience in Oracle database administrate, backup, recovery and tuning.

Excellent team work ethics, quick understanding capability

Excellent at data analysis in Business Intelligence and KPI design.

Excellent at data architect. Reversing, designing and optimizing database.

Proficient at Office and VB scripts, good at using Macros to do repetitive work.

Excellent at Project, Office, ORACLE, MYSQL, SQLSERVER, PowerBuilder, FoxPro, VB, C, Java, Visio, CVS, VSS, PowerDesigner, SAS, Matlab and R.

Work experience in object-oriented analysis and design, involved in a team environment to meet challenges and milestones for the organization.

Enjoy learning new tools, techniques and methodologies to face challenge projects and solving different problems.

Excellent team work ethics, good communication, interpersonal and learning skills with strong presentation skills, and ability to interact with people at all levels.

Good at in Experiment Design, Time series, Multivariate research, Linear analysis, Spatial statistics, Data Modeling, Machine learning and Simulation.

Technical Skills

Languages

Java, SQL, PL/SQL, PowerBuilder, FoxPro, VFP, VB

RDBMS

Oracle 7/8i/9i/10g, MySQL, SQLServer, MariaDB, Microsoft Access

Tools

CVS, SVN, Maven, Project, Visio, VSS, Powerdesign

Operating Systems

Windows 7/Vista/XP/2000/NT, Unix, Linux, Mac OS X

Professional Experiences

Employee: Hele International, Inc.

Position: DBA

Duration: 6/2014 -Present

Responsibilities:

Proactively performed duties including: database backups, restores, and performance tuning.

Performed DBA duties including: Space management, Database Security, Copy/ Modification Creating Databases in all environments, Troubleshooting defragmentation of objects and databases.

Managed the products and development, Test and Production databases including performance tuning, SQL Server clustering, database security configuration, and database continuity. Knowledge of capacity planning.

Created and implemented backup and recovery policies and strategies for all mission critical database systems.

Automated all maintenance activities (Index rebuilds and reorgs, Stats update, alerts, etc) for all production systems.

Troubleshoot databases and custom application issues for OLTP systems.

Working with Application team to manage multiple RDBMS as Oracle, Access, MYSQL, MariaDB, SQL server.

Implemented backup and recovery strategies that ensure that backups meet the recovering requirements using the RESTORE VERIFY option when creating backups

Responsible for the Production support of more than 200 different databases.

Managed and Setup SQL Server transactional replication, log shipping and mirroring.

Proactively engaged in various tuning techniques to maintain high performance production database environments and ensuring minimal to zero downtime

Worked with rest of the team to setup and manage transactional replication and log shipping.

Participated and coordinated the creation, modification and maintenance of database structures with minimal supervision.

Assisted in the design, coding, testing and implementation of SQL databases instances

Taken an important role in a critical situation of restoring a corrupted database from a point in time with zero loss of data.

Wrote stored procedures to clean data and make reports.

Build and maintain online websites based on WordPress.

Proactively performed duties including: database backups, restores, and performance tuning.

Employee: University of Arkansas

Position: Teacher Assistant

Duration: 8/2013 -5/2014

Responsibilities:

Facilitate a discussion section or tutorial;

Hold weekly office hours;

Grade homework, programming assignments, exams, or projects;

Keep records; distribute and copy reading materials;

Prepare answer keys or supplementary notes

Company: Guangzhou Jxtech Co.,Ltd

Position: Sr. Software Engineer, Project Manager

Duration: 11/2008 – 8/2011

Responsibilities:

Design KPI for China Southern Power Grid Company and China Mobile.

Manage projects involving project initiation, scoping, planning, tracing, adjusting, costing, closing and status reporting.

Manage teams to ensure professional behavior and appearance.

Communicate and manage risks both internally and externally.

Write training manuals up to 500 pages.

Project Management Information System (MIS)

Client: Yangjiang Power Supply Co. Ltd.

Jiangmen Power Supply Co. Ltd.

Chaozhou Power Supply Co. Ltd.

Position: Project Manager, Coder, DBA

Duration: 2/2003-8/2008

Yangjiang Power Supply Co. Ltd. (YJPS), Jiangmen Power Supply Co. Ltd. (JMPS) and Chaozhou Power Supply Co. Ltd.(CZPS) are wholly owned subsidiaries of China Southern Power Grid Co. Ltd. (CSG). YJPS takes on the pivotal task to supply power for 5 administrative districts, the number of clients adding up to 0.43 million. CZPS severs clients up to 0.46 million. JMPS severs clients up to 2.6 million.

Responsibilities:

Code in PowerBuilder, middleware using Jaguar, database using Oracle, developed in B/S mode under agile methodology.

Upgrade structured, semi-structured and unstructured data into Oracle database for 3different cities and serving more than 3 million electric consumers.

Worked up to 200 hours in two weeks for achieving a very important milestone.

Coded up to 20k lines stored procedures in PL/SQL for higher performance.

Manage a team of 6 people. Assign team member tasks, and motivate them to meet deadlines.

Data analysis and forecast. Developed hundreds of reports for data analysis.

Responsible for Oracle database operation, maintenance, troubleshoot, monitor, backup, and recovery.

Project Management Information System (MIS)

Client: Zhongshan Power Supply Co. Ltd.

Position: Coder, DBA

Duration: 9/1999-9/2002

Zhongshan Power Supply Co. Ltd. (ZSPS) is a wholly owned subsidiary of China Southern Power Grid Co. Ltd. (CSG). ZSPS takes on the pivotal task to supply power for 3 administrative districts and 24 county-level cities of Zhongshan, the number of clients adding up to 0.7 million.

Responsibilities:

Code in VFP and Oracle in C/S mode and Waterfall model.

Develop application to compute electric bills for more than 700k consumers.

Interact with user to teach user and improve applications.

Educations

8/2012-5/2014 UNIVERSITY OF ARKANSAS (UNITED STATE) GPA:3.7/4

Major:Statistic Degree:Master

9/1995 – 6/1999 SUN YAT-SEN UNIVERSITY (CHINA)

Major: Engineering Mechanics Degree: Bachelor

Contact this candidate