TECHNICAL SKILLS:

Using the following products: Confidential SQL Server 2016, 2014, 2012, 2008, 2005, 2000, 7.0, 6.5; SSIS; SQL DTS; Analysis Services (OLAP); ORACLE 10g; PL/SQL; MySQL; Cassandra; MongoDB; Postgres; HP Polyserve; Windows Server Enterprise; Quest Foglight; BDA Manager; System Center Operations Manager (SCOM); SpotLight; Quest Central; SQL Litespeed; PERL; Windows Shell Scripting; Power shell; NetBackup; Robocopy; Visual Studio; Visual Basic; XML; CGI; ERWin; Visual SourceSafe; C; C++; MS DOS; Access; ITIL

EXPERIENCE:

Senior Database Administrator

Confidential, WA

Responsibilities:

• Performing multiple database administration tasks including Tier 1 production operations support
• Using various database performance monitoring and analysis tools and techniques for tuning, optimizing and troubleshooting MS SQL database systems in a 24x7 mission critical high - traffic OLTP e-commerce environment; Configuring Confidential Clustering, Mirroring, Log-shipping, and Transactional Replication in Lab, pre-production, and production environments
• Administering Oracle, MySQL, Cassandra, MongoDB, and Postgres database systems
• Working with database developers and engineers to analyze and resolve database performance issues and identify problems in areas such as: execution plans, index coverage, and SQL Server statistics.

Senior Database Administrator

Confidential, WA

Responsibilities:

• Managed multiple SQL2005 and SQL2008 database environments within the Bank;
• Performed database upgrades from SQL Server 2005 to SQL Server 2008; Implemented SQL Server 2008 Failover clustering on SAN, Database Mirroring, Log-shipping, and Transactional Replication
• Installed and configured new SQL Server instances for production and non-production environments; Provided 24 x 7 operational on call support.

Senior Database Administrator

Confidential, WA

Responsibilities:

• I managed multiple SQL2008 database environments within the Confidential Engineering and Operations Systems Support department;
• Performed database upgrades from SQL Server 2000 and 2005 to SQL 2008
• Implemented SQL 2008 HA technologies such as failover clustering, database mirroring, and Log-shipping; worked with transactional and snapshot replication; provided 24 x 7 database operational on call support.

Database Administrator

Confidential, WA

Responsibilities:

• Installing, configuring, and maintaining SQL Server 2008 and 2005 on mission critical Windows Failover clusters in both production and non-production environments
• Ensuring that all database environments (Development, QA, Staging and Production) are in sync
• Installing service packs on both clustered and non-clustered SQL Server instances; working with a product team of database developers, application developers, business analysts, and IT engineers on implementing monthly software product releases; moving very large databases (VLDB) across the network and restoring them to support reporting initiatives.

Database Administrator

Confidential, WA

Responsibilities:

• Migrated SQL Server 2000, 2005, and 2008 non-production databases from existing MS Windows Cluster instances on to consolidated multi-instance HP Polyserve Failover Clusters.

Database Engineer

Confidential, WA

Responsibilities:

• Providing SQL Server 2008 support for the XBOX Online and XBOX Live Services teams;
• Configuring Replication and Database
• Mirroring on production databases partitioned across multiple machines;
• Working with Product Managers to deploy scheduled XBOX major releases into their no-production and production environments using SQL Server 2008 Management Studio.
• Designing new database maintenance processes and troubleshooting existing ones to improve performance and functionality.
• Using ITIL tools such as System Center Service Manager to manage trouble tickets and change requests between the web and database platform queues.

Senior Database Administrator

Confidential, WA

Responsibilities:

• Providing 24X7 production support on more than 16 dedicated financial business applications hosting over 50 SQL Server 2005 and 2000 instances containing over 137 databases
• Installing, upgrading, and configuring SQL Server 2005 and 2000 on clustered and stand-alone production database servers
• Architecting, Installing, and configuring complex disaster recovery solutions using SQL Litespeed, SRDF, and SRDF/A SAN Replication
• Installing and managing various complex multi-instance utility computing and shared SQL clustered OLTP and DSS environments using SQL Server 2005, SQL Server 2000, and Polyserve
• Analyzing database hardware capacity requirements for both new and existing enterprise database applications and working mutually with WAMU Technology Infrastructure experts and the Enterprise Database Engineering team to design hardware solutions based upon industry recognized best practices
• Using Windows NT shell scripting methods with utilities such as Robocopy to manage complex SQL Server environments
• Developing technical solutions and processes across functional units for technical tasks such as Server Patching, SAN migrations, hardware upgrades while closely adhering to the SDLC and ITIL methodologies
• Writing clear and concise processes, procedures, and instructions for communicating technical and non-technical information to varying audiences within WAMU business units and their outside Vendors
• Managing and controlling database administrator Level 2 and Level 3 security access to SOX and GLBA regulated databases using Quest Foglight; coordinating with the WAMU Enterprise Data Security and Group Policy teams in order to maintain global Security access across multiple domains
• Keeping up-to-date with current WAMU standards, policies, procedures, regarding segregation of duties, incident management, change management, database hardening, database Platform, SOX, GLBA, and BASEL compliance, and many more
• Conducting group training, mentoring, sessions with peers and vendors and also hosting technical interviews to screen potential DBA candidates to be hired by Enterprise Database Administration and Database Engineering
• Tracking, calculating, and reporting key performance indicators for database server rationalization and cost avoidance to upper management

Database Administrator

Confidential, WA

Responsibilities:

• Enhancing Confidential 's enterprise data warehouse (EDW), e-Procurement, and merchandising systems by Implementing a 1.5-Terabyte enterprise data warehouse system using SQL Server 2000, SQL DTS, VERITAS, EMC Symmetrics, and StorageTek components; utilizing VLDB management principles such as partitioned views and filegroups; developing ANSI and Transact-SQL statements and stored procedures to manipulate data;
• Analyzing and applying business logic to critical enterprise systems using SQL DTS; writing ETL procedures to import XML files into SQL Server databases; performing logical and physical database modeling using Erwin; architecting and tuning new SQL Server systems and performance tuning the existing ones; designing physical data structures to support application requirements for Confidential ; providing performance analysis and tuning recommendations for Confidential SQL-Server based applications; consulting with application developers regarding optimal use of DBMS technology; assisting in recommending and overseeing DBMS enhancements; assuring compliance with standards through participation in design and code reviews; working with Corporate Data Administrators to exploit data sharing and minimize data redundancy; training personnel in the use of DBMS and other file structures; preparing documentation and manuals; performing cost/benefit analyses and preparing project status reports where needed; administering Client/Server RDBMS products; testing and implementing new releases of RDBMS-related software; evaluating software packages pertinent to the DBA area; providing debugging assistance to development staff with DBMS; participating in providing 7 day/24 hour on-call support.

Database Administrator

Confidential, WA

Responsibilities:

• Collecting summarizing and warehousing Performance metrics from Confidential production servers using SQL-Server 7.0 and 6.5 databases running under Windows 2000 and NT 4.0 Operating Systems;
• Developing DTS packages, stored procedures, and batch processes for maintaining performance data collected from servers hosting Core technologies (SQL, IIS, Exchange, DHCP, etc.) and deploying and administering those processes remotely using operating system tools and techniques;
• Performing database administration tasks such as backing up and restoring databases, increasing data and log device sizes, and Transferring Data and objects between platforms.

Programmer Analyst

Confidential, WA

Responsibilities:

• Developed and maintained client-server business applications using VB5, SQL-Server 6.5, and ERWin 3.0; performed database administration tasks to include modifying stored procedures and triggers in order to maintain numerous SQL-Server 6.5 databases.