Lead Database Engineer Resume Bellevue WA - Hire IT People

SUMMARY

Seasoned IT DBA/DBE known for being results driven and performing high quality work.
An accomplished database expert with extensive experience in database technology with the ability to administer large mission - critical database systems, implement complicated database projects, foresee problems, resolve issues and deliver work on time in a high demand environment.
Excellent collaboration, multi-tasking, and communication skills. A self-motivated and detail-oriented team player who is also able to work independently.
Skilled technical leadership and mentoring abilities.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential, Bellevue WA

Lead Database Engineer

Responsibilities:

Install SQL Servers, build databases, configure and optimize systems, setup securities, extract and load data, deploy project database changes.
Gather and analyze SQL server and database project requirements. Plan project SQL server resource and capacity. Setup and configure SQL server database test and prod regions.
Design and implement data warehouse, objects, tables, views, primary keys, foreign keys, indexes and constraints. Analyze, solve, and correct issues in real time.
Merge data from multiple sources into data warehouse. ETL data from various sources to SQL Server tables using SSIS. Build up SQL and DB maintenance plans.
Design and setup data purge or data archiving. Code review project SQL scripts. Plan hour by hour project migration and rollback strategy.
Document and provide project Run Book to Operation team. Support project warranty. Establish and enforce SQL Server and database standard and policy.
Optimize database configuration and performance. Build security models, enrolling users and maintaining system security. Ensure cross platform schema synchronization.
Control and monitor user access to the database. Perform scheduled maintenance, database migration and release deployment. Practice agile methodologies.

Confidential

Lead Database Administrator

Responsibilities:

Maintain SQL Server 2008R2, 2012, 2014, 2016 instances, databases, user logins, securities, jobs, ETL packages, log shipping, replications, SSAS, SSIS and SSRS.
Monitor SQL Server and database activities, performance, errors and job completions.
Troubleshoot, resolve database issues. Investigate root cause and provide solutions.
Build, upload, schedule and manage business reports using SQL Server Report Manager.
Plan database capacity and growth. Assign and manage database system storages.
Administer and manage all test and production database environments.
Document SQL Server and database. Backup, restore and recover databases.
Establish and maintain database standards, policies and procedures.
Implement and maintain database security. Create and maintain users, roles, privileges.
Upgrade SQL Servers. Apply security patches. Size and optimize SQL Server system resource.
Perform SQL Server tuning, database tuning and query tuning.
Involved in DBA 24X7 on-call duties. Provide SQL Server fail over and disaster recover solution.