Database Administrator Sql Server

Resume

Xiaowei Cao **********@*******.*** U.S. Citizen

Objective: Database Administrator - DBA Database Developer SQL Server Admin

Database Engineer System and database Admin

Computer Skills:

System and Platform: Window Server 2008-2022, Windows 8-11, VMWare, Microsoft Azure Cloud, AWS, Linux-Unix

Database and Language RDBMS, SQL Server 2000-2022, Oracle 11g-20c, Progress Open Edge, Postgres, MySQL, MS Azure databases, Oracle PL/SQL, T-SQL, PowerShell, JavaScript etc.

Business intelligence – MS SSIS, SSRS, SSAS, ETL, Data Warehouse, Visual studio BI Tools, Power BI, Tableau, Crystal Reports etc.

Software: Visual Studio, Azure Data Studio, Oracle SQL Developer, TOAD, Subversion, SolarWinds DPA, vSphere, Visio, DB Schema, RMAN, SSMS, PowerShell, SQLPLUS, MS System Center Orchestrator Runbook, Control-M, Versatrans/E-Link, SharePoint, ArcGIS, Redgate toolbelt etc.

Employment History

Database Administrator Senior: Seattle Public Schools Mar 2011~Present

1.Manage, administrate, support SQL server and Oracle database applications for school district that ranges from Student Information System, transportation, safety and security, School budget and allocations, Library, Advanced Learning etc.

2.Responsible for creating and overseeing standards, procedures to ensure data integrity and high availability of database applications.

3.Install, upgrade, patch, migrate database servers and monitor and optimize database server performance. Manage security, resources, high availability, and disaster recovery of database servers.

4.Design and implement data models for district developed database applications including conceptual, logical, physical models.

5.Develop and automate ETL or ELT packages, implement, manage SSRS report servers.

6.Develop schema, packages, stored procedures, functions etc. for SQL Server and Oracle Databases using T-SQL and PL/SQL.

7.Automating jobs using PowerShell, SQL Plus, MS Orchestrator Runbook, Control-M and other scripts languages.

8.Mastered skill on RDBMS like Oracle, SQL server, MySQL, PostgreSQL, OpenEdge, MS Azure, Azure Data Factory etc.

Network Database Specialist IV: Minnetonka Public School District. April, 2005~ Mar 2011

(Top National School Technology Visit Site)

1.Manage, support, and develop database applications for school district.

2.Database administrator- mainly SQL Servers and Progress database Servers.

SharePoint server (MOSS) administrator and district single sign on system administrator and developer

3.Support, data analysis and data mining for major academic software applications.

4.Create crystal reports, SQL reports using Business Intelligence tools like SSIS, SSRS.

5.Develop asp.net web forms and infopath forms for district web sites.

6.Implement data and database integration for all the academic software and system applications for example, software like Blackboard, Skyward, Follet Destiny, Exact Target, ConnectED, Lifetouch Photos, Schoology, etc.

7.Create ad hoc queries and process import and export - ETL data according to business needs.

8. Manage and maintain district network active directory users’ creation scripts.

Information Technology Specialist 3, State of Minnesota: Department of Public Safety of Minnesota

Division of Driver’s License and Motor Vehicle Services Jan 2004 ~ April 2005

Database administrator, responsible for the planning, maintenance and development of databases, data security and recovery control, working as a member for drivers and motor vehicle services ESupport team.

1.Reviews, develops, and designs data models using standard diagramming techniques, in conjunction with application development teams; creates logical data models and translates into physical database structures that integrate with existing or proposed database structures.

2.Monitors relational databases to optimize database performance, resource use, and physical implementations of databases.

3.Maintains development, test, and production RDBMS environments.

4.Monitors and maintains database security and database software, in cooperation with network security administrators.

5.Provides advice to applications programmers in the effective use of database languages; advises on troubleshooting, exception processing needs, and other data management issues.

6.Monitors and manages database backups, logs, and journals; installs, maintains, and upgrades database software; restores and/or recovers data as required.

7.Creates, procures, and maintains various database related documents such as manuals and programmers’ handbooks.

8.Export and import data, using DTS, SSIS, Stored procedures.

Information Technology Specialist 2, State Employee: Campaign Finance & Public Disclosure Board of State of Minnesota April, 2001~Jan 2004

1.Develop, maintain, manage, and coordinate computerized information system for board office.

2.Provide technical service, assistance, and training to board staff.

3.Web master: Design, develop, programming and maintain board website. IIS Web Server and MS SQL server administration

4.Used VB, VBA, Microsoft Access, MS SQL Server implementing queries, forms, reports, modules, macros, views, triggers, and stored procedures, DTS, for relational database applications.

5.LAN administration, database administration, PC support

Internet Programmer, Media Relations, Inc. Sep, 1999~April 2001

1.Design, update, and maintain general, comprehensive e-commerce, and media web sites, including flow charts, storyboards, interface, graphic, database, contents, interactivity design. Mainly used ASP, Cold Fusion, JavaScript for programming.

School Teacher Oct, 1991~Oct 1996

Attached Middle School of Xi’an University of Technology and Architecture

Education

Master degree of Software System, University of St. Thomas, Minnesota

Major: Software System (MSS)

Contact this candidate