Client: Employment Security Department, State of Washington

• Supported SQL Server 2014/2016 production environment including server performance monitoring and performance tuning.• Supported SQL Server lower development, testing, and staging environments. • Maintained all database environments using a tested automated deployment maintenance approach.• Perform database administration activities including: monitoring, backup & restore, and maintenance tasks.• Managed security changes and audits for databases, servers, and shares.

• Worked with the CEO of the company to develop the company’s strategical use of information technology.• Designed, developed, and implemented SQL Server 2017 databases in AWS RDS which store internal corporate information and external client information and interact with the Real Body Life phone application.• Supported and performed daily administration of the Real Body Life RDS SQL Server 2017 databases.

• Assisted with evaluating ROI for programs, events, and promotions. • Responsible for providing technical support to resolve all issues involving the Player database.• Made enhancements to Access SQL Linked databases to add functionality and improve performance.• Wrote detailed technical policies and procedures for all Marketing departments.

• Supported and administered Microsoft Windows workstations and laptops for various clients.• Personal caretaker for my brother who was diagnosed with ALS (Lou Gehrig’s disease). Assisted my brother with personal care, including dressing, mobility, administering medication, personal hygiene, eating, and transporting to doctor’s appointments.

Provide operational DBA support for large scale enterprise relational databases. Maintain highly reliable, high performance database processing environments. Implement physical changes to computer databases; coding, testing, and upgrades. Provide effective technical expertise for projects in collaboration with customers to ensure direction, quality assurance, and standards for all database environments. Work with IT associates in a technical role, ensuring best practices for database security, availability, recoverability and performance.

Responsibilities• Proactively manages database server resources using performance monitor, profiler, custom scripts and third party tools.• Develops database documentation, including architecture diagrams, schema definitions and operating procedure manuals.• Performs ad-hoc data queries for reporting and data analysis needs.• Handles database support escalation and production database preventative maintenance as a sole subject matter expert.• Creates and performs database administration tasks for development, test and production SQL environments following industry and security best practices.• Deploys and maintains a database security framework supporting role based group access.• Documents configuration of all SQL Server instances and develops disaster avoidance and recovery plans.• Supports the development of Microsoft SQL Server Reporting Services Reports (SSRS) and SQL Server Integration Services (SSIS) applications and data flows.• Develops, implements and maintains backup and disaster recovery strategy for all SQL server databases and systems.• Troubleshoots connectivity and performance issues relating to SQL Servers and data enabled applications.• Supports the vision and values of the company and the team through role modeling and encouraging desired behaviors.• Supports the corporate software development lifecycle (SDLC) methodology.• Other duties as assigned.

• Provided Enterprise SQL Database Engineering and Development services. Designed, developed, and implemented the following: Corporate SQL Server Inventory database, reporting, and ETL process; standard complete Database Maintenance/Repair SQL Agent jobs and deployment system; standard customizable SQL Server monitoring and alerting database and scripts; corporate SQL database procedures and standards.• Responsible for managing, administering, and supporting 90+ SaaS cloud application MS SQL Server 2008/2005/2000 Instances containing 10,500+ databases totaling over 185 terabytes.

• Provided application database support by developing and performing database operations processes and procedures, such as maintaining and synchronizing development/test database environments with production. Monitored and recommended database application changes for optimal performance. Provided third-level production operations support on a rotating on-call basis, to ensure data integrity and quick recovery of databases. Installed database software products and resolved software problems.• Participated in the definition and implementation of database architecture and standards.

• Performed database administration functions including but not limited to: Security access, performance monitoring and tuning, capacity planning, and database replication/backups for recoverability. Responded to customer-reported system/database problems.• Developed and maintained database administration processes, procedures, and standards for database security, monitoring, recoverability and disaster recovery

* Lead Senior Database Engineer/Administrator for the Database Utility (DBU) environment (64 bit SQL 2005 instances on Windows 2003 PolyServe clusters) and the Shared SQL environment (32 bit SQL 2000 instances on Windows 2003 clusters). Responsible for the design, implementation, technical evolution, management, support, and monitoring of the DBU/Shared SQL environment.* Created a DBU SQL SharePoint intranet site, DBU/Shared SQL standards, procedures, guidelines, database maintenance plans/jobs, and disaster recovery processes. * Migrated over 1000 application databases into DBU/Shared SQL. In 2006 I managed the consolidation of 650 databases and 66 database servers into DBU/Shared SQL, resulting in a $1.5 million savings for the bank. DBU/Shared SQL have saved Washington Mutual millions of dollars through server/database consolidations and reduced operating costs.* Technical Lead DBA for Production Support DBAs; Operations Duty Manager on a rotating basis.

* Responsible for the daily database administration and support of over 500 production, test, and development MS SQL Server 2005/2000 database server instances. Installed, configured, and optimized SQL Server 2005/2000 on Windows 2003/2000 servers and clusters (active/passive and active/active). Responsible for server and database monitoring, performance tuning, database backups and recovery, database security, database maintenance, applying service packs and patches, troubleshooting, and resolving production problems.* Project Manager/Liaison on the IBM Global Services to Wipro DBA Vendor conversion project.* Consulted development teams, provided guidance regarding coding best practices and standards.* Wrote several Enterprise level SQL Server standards, procedures, and guideline documents. * Utilized Erwin for database data modeling, schema generation, and reverse engineering.* Wrote PL/SQL report queries for Oracle databases.

* Developed, tested, and implemented SQL stored procedures/scripts, VBS scripts, and command shell scripts to automate daily database administrative and reporting functions.* Responsible for the daily database administration and support of over 200 production, test, and development SQL Server 2000/7/6.5 database servers. Responsibilities included server and database monitoring, performance tuning, database backups and recovery, database security, database maintenance, applying service packs and patches, troubleshooting and resolving production problems, setting up and maintaining replication and log shipping, and documenting SQL standards.* Created SQL Server Agent jobs for database backups, tape backups, database checks, database maintenance, database monitoring, and server alerts.

* Designed, developed and supported Acadio business unit internal applications written in T-SQL, VB 6, VBS, ADO, COM, ASP, and HTML.* Developed infrastructure and integration components, developed VB COM objects, made enhancements to existing systems, fixed defects, maintained the web site search index database, and supported the web site build process.* Responsible for maintaining and supporting all of the SQL Server 7/2000 database systems used by the public web site, internal publishing and content, and backend transactions. Responsibilities included setting up and maintaining database backups/restores, log shipping, replication, data transformation services, data integrity, security, ODBC, and performance tuning. Provided data design and support to development staff. Created and maintained stored procedures, triggers, and SQL scripts.

* Developed and implemented a major upgrade to the Claims processing system. The upgrade included designing and coding system enhancements and Y2K fixes, converting the database and programs from SQLBase/Novell 3.11 to SQL Server 7/Windows NT 4.0, writing system test plans, and testing the system. System processing time, reliability, and customer satisfaction were all greatly improved after the upgrade.* Made enhancements to merchandising system programs written in COBOL II, DB2, CICS, and JCL.* Responsible for the database administration, maintenance, and production support of the PC based client/server Claims system, written in SQL Server 7, VB 5, and SQL Windows 5.04. Designed and implemented database backup/restore scripts and a database user security system, monitored and maintained the databases, transferred data into and out of databases, wrote and optimized SQL.* Served as a project lead on 2 Y2K conversion projects and a merchandise sorter platform conversion project.

* Designed, developed, and tested cellular switch interface programs in COBOL II/DB2/CICS.* Wrote business requirements documents, technical design documents, and program specifications that were used for making client/server enhancements to the Ameritech cellular customer management systems.* OS/2 Subject Matter Expert - provided OS/2 technical leadership, support and training for the team.

* Technical lead responsible for the design, development, testing, and implementation of more than 100 ADW/COBOL II/DB2/CICS on-line/batch programs utilized in the Customer Service, Customer Marketing, Work Management, and Electric/Gas Metering client/server systems.* Responsible for project management duties on the Customer Marketing System project, which included planning, assigning and monitoring tasks, customer support, and status reporting.* Developed the application disaster recovery plan for the Customer Service System.* Wrote data conversion programs and REXX utility programs.* Provided production support during critical system implementations.

* Designed, coded, tested, and implemented several system enhancements and customer service requests in COBOL, DB2, CICS, Telon, MVS JCL, and VSAM.* Supported the batch and on-line Expressway Point-of-Sale, Credit Card Authorization, Quality Service, Business Reporting, and Cellular Phone systems.* Interfaced with the customer to develop definition, analysis, design, and testing documents and assisted with user acceptance testing.* Reviewed and updated system batch job restart/recovery documentation, which improved production problem resolution.

* Interfaced with the customer to gather requirements and assisted with user acceptance testing and system documentation on several Item Processing projects. * Responsible for customer support and customer reporting on all Item Processing maintenance and production support projects.* Designed and constructed Dbase III Plus databases and programs for the Account Management Services Performance Reporting System.* Worked extensively with several PC software packages and hardware configurations and provided technical support to the account.* Wrote a forty page MS Word training manual and provided MS word training for fifty EDS staff, which saved the account $5000 in training fees.

* Provided technical phone support for Microsoft Word, Excel, Works, Project, and Chart.* Assisted in testing new product releases and wrote technical support letters to customers.