SUMMARY:

• Confidential ’s work passion lies in everything SQL - server related. From development, to administration, to Business Intelligence, he has experience on various applications and platforms, with a major emphasis on MS SQL Server. As a DBA in all versions of MSSQL from 6.5, he has strived to keep the company’s data clean, up-to-date, and accessible to end users.
• He takes his role as the custodian of data seriously, and is continually updating his skills through classes, tutorials, and hands-on . As a developer, he sees his goal as being able to transform raw data into usable information.
• Business Intelligence involves taking this one step further, enabling knowledge to be drawn from the information, whether it be in the form of reports, charts, or verbal presentations. s include CompTIA A+; CompTIA Network+; CompTIA IT Operations Specialist; CIW Site Development Associate; MCDBA (SQL 2000); MCTS - SQL Server 2008, Implementation and Maintenance; and MCITP - Database Administrator 2008.

TECHNICAL SKILLS:

• MSSQL ( ), Administration and Development
• T-SQL
• MySQL / Aurora database systems
• MemSQL database maintenance
• Query Performance and Index Tuning
• Data Modeling
• SSRS, SSIS, SSAS
• Data Visualization / Report Layout
• Data Warehousing / Data Mart
• VB.NET
• R (Statistical Language) (novice)
• Python (novice)
• PERL
• Crystal Reports
• MS Office (Word, Excel, Access, Outlook, PowerPoint, Visio)
• Powershell scripting
• Power BI
• Help Desk / Customer Service

EXPERIENCE:

Confidential, Bellevue, Washington

Senior SQL DBA / Data Architect

Responsibilities:

• Responsible for backups / restores, nightly maintenance, security/user permissions, updating MSSQL versions, and query tuning in a DEV/QA/PROD system.
• As a Data Architect, responsible for new database design and implementation; best practices in retrieving data from existing databases; and guiding developers in methods of extracting useful, actionable data from our systems.

Confidential, Puyallup, Washington

SQL DBA / Developer

Responsibilities:

• Developer duties included writing Stored Procedures (SPs) for inserting and deleting data from various table; scripts to directly insert migrated data (see below) to existing tables, using many-table to many-table joins in some cases; and modifying existing scripts and procedures in the current Dev/ QA / Production databases.
• Bulk of time (18 months) at Confidential was migrating data from acquired company’s Document Tracking systems to Confidential ’s Document Tracking system (IRIS). The acquired companies were running on Access, MySQL, and MSSQL systems; Migration involved mapping their legacy systems data to the IRIS MSSQL system database.
• Some work with PowerBI, in retrieving time-based data from IRIS (Document Management System) and creating SPs to be used by PowerBI to display dashboards.
• Extensive use of SSMS, MySQL Workbench, Access, and other database utilities to compare and convert data from one DBMS to another.
• Continued usage of Powershell scripting for DB Administration.
• Usage of Visual Studio (including TFS), from earliest versions up through VS 2017.

Confidential, Tacoma, Washington

SQL Server Developer / DBA

Responsibilities:

• Main emphasis in MSSQL, but also many Access databases and Excel spreadsheets used as databases / reporting systems; also some MySQL database maintenance and reporting processes.
• Responsible for schema development, indexing strategies and maintenance, and general DBA duties.
• Besides duties as DBA, also responsible for reporting applications, using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Creation of SSIS packages for loading data from flat files (via local Network and FTP processes) to SQL server tables for use in Reporting Services.
• Powershell scripting for automation of administrative and ETL tasks. Adept at creating and monitoring SQL Server agent jobs for backups, restores, automated emailing of reports and ETL processes. Sharepoint development with third-party Finance/HR system for creating dashboards / Key Performance Indicators (KPI) / web parts. Development languages / platforms include VB.Net, LightSwitch, ASP.Net (through Visual Studio ).
• Union shop steward, working with management and to resolve issues, or preferably prevent them from occurring; recognized as fair and equitable by both sides.
• Has created custom reports used by all levels of library staff (from front-line staff to upper management) using SSRS and Crystal Reports, utilizing graphs, charts, tablixes (table and matrix combinations) to help guide strategic decisions at the branch, department, and system levels.
• Responsible for backups and restores, routine maintenance, and version / hotfix updates on MSSQL.
• Over the past seven years, has upgraded the SQL Server system from SQL 2000, through SQL 2005 and 2008, to 2012. Included project planning, contingency planning, roll-back plans, etc.
• Creation and maintenance of the “DBA Bluebook”, a documentation handbook / guide of databases, agent jobs, DBA duties and responsibilities, to be used by staff when DBA is not around.
• Usage of Visual Studio, from earliest versions up through VS 2013.

Confidential, Bellevue, Washington

Sr. Consultant / Database Developer

Responsibilities:

• Creation of new Stored Procedures and maintenance / updating of existing Stored Procedures.
• Research and creation of new indexes, removing unused indexes. Some exposure to Business Objects 6.5. Extensive use of Perforce for source code tracking and deployment, and RAID for bug tracking.
• On-shore team leader, with the rest of the development team in China, for database reporting updates and other database maintenance tasks. Lead developer, responsible for assigning tasks to off-shore team for completion, and checking quality of finished code.
• A great deal of T-SQL Stored Procedure development, database object scripting.
• Some perl development / maintenance.
• Coordinating maintenance requests between Bellevue, Washington and Shenzhen, China.
• Software versioning using Perforce (P4) for code and MS Visual Studio for documentation.
• Bug tracking using RAID.

Confidential, Enumclaw, Washington

SQL Reporting Services Developer

Responsibilities:

• Creation of SQL Reporting Services Reports. Part of Rainier Project (transferring Claims System from IBM mainframe to SQL / Distributed system)
• Translated approximately 30 mainframe reports to SQL (2005) Reporting Services format, using T-SQL and VB.Net languages. Worked with end users and business analysts during development and testing of new reports. Analyzed differences between legacy and SSRS reports and capabilities, devised solutions to bridge differences.
• Deployed reports through development, test, and production systems.
• Extensive use of Visual SourceSafe during development and final deployment.

Confidential, Tacoma, Washington

SQL Developer / Application Support

Responsibilities:

• Developed SQL applications (SQL 7.0/2000, Access 2000) for use by Russell’s financial analysts. Created databases for use by Web applications, third-party applications.
• Maintained existing database for Web-based survey and reporting applications.
• Source of general SQL knowledge (indexing, collations, triggers, stored procedure, etc.)
• Member of Tier 2 application support team (24/7 support, 1 week on, 2 weeks off) of mission-critical MS and UNIX applications (data retrieval, ETL processes, Web reporting). Responsibilities included monitoring processes, responding to calls from end users and other Tier 2 application support analysts, and escalating to Tier 3 as appropriate.

Confidential, Olympia, Washington

DBA / System Administrator

Responsibilities:

• DBA for Liquor Control Board, responsible for installing and maintaining multiple SQL servers (in a Development / Test / Production environment); deploying and troubleshooting SQL objects (tables, SP’s, Triggers, Users, Logins, etc.); setting security for users and groups.
• SQL 2000 programming, including Stored Procedures, DTS packages, and complex Triggers.
• Developed reports in SQL Reporting Services, retrieving information from a SQL 2000 database and displaying it on an intranet Web page.
• Implemented and supported a third-party Workflow and Document imaging system, retrieving licensing data from DOL databases and creating LCB workflows for liquor license approvals. Involved integration of A/S 400, MS Access, and MS SQL data in a seamless system to improve approval times and accuracy.
• Developed various applications relating to WSLCB’s Point-of-Sale System (Store / HQ communications, Inventory Receiving Scanning, Credit Card Reconciliation).
• Designed and developed a Visual Basic application for transferring monthly DUI Data (in ASCII format) from Washington State Patrol to the Confidential (WSLCB) SQL Database. Information is received on a floppy disk (due to user requirements) and is parsed and loaded into the database.
• Upgraded WSLCB’s Liquor Store communication program from QuickBasic running on Windows 95 to VB6 application running on Windows 2000. Acted as lead developer on this sub-task, working with other groups (both IT and non-IT) to coordinate development, testing, and deployment efforts.
• Developed VB6 / SQL application to migrate Licensing templates from (no longer supported) A/S 400 OfficeVision system to SQL-based n-tier system.
• Re-designed and developed a Receiving Scanner application for state liquor stores. They use this application to receive all inventories (units and cases) into POS system.
• Designing and developing VB6 application (front end to a SQL 2000 DB) for reconciling Credit and Debit sales and returns (from the state liquor stores) with records received from our Credit Card Processing vendor. This project uses a VB application to cycle through records in a Gigabyte-sized SQL database, creating an encrypted, dated reconciliation file for each of approximately 160 liquor stores nightly.
• Tasks include end-user interviews to develop project requirements and time constraints; designing SQL database; designing application workflow; writing SQL Select statements; setting up ODBC / OLE DB connections and recordsets; and writing reconciliation files to network folders.

Confidential, Olympia, Washington

Computer Information Consultant

Responsibilities:

• Recognized by his peers for his troubleshooting skills and customer service aptitude.
• Support of various sales and inventory related programs running under Windows 95 in the stores; office program and hardware support in the headquarters for all departments; and problem tracking and resolution.
• Extensive use of PCAnywhere to resolve software problems throughout the state.
• Bendata (FrontRange) HEAT Administrator (Call Logging and Tracking software) developing and implementing database, adding and removing users, developing reports for HelpDesk and management usage.