Database Engineer Resume
2.00/5 (Submit Your Rating)
Irvine, CA
OBJECTIVE:
I am a certified Microsoft and Oracle Database Engineer looking to continue my career as a Database Engineer utilizing my strong technical and communication skills.
SUMMARY:
- Six+ years of experience as a DBA in production and development environments
- Administered SQL Server High Availability always on 2012/2014
- Installed, upgraded and patched MS SQL 2005/2008/2012/ clusters
- Responsible for Windows Server 2005/2008R2/2012 configuration and management, specifically as it relates to MS SQL Server installations and mission critical systems
- Implemented Performance Tuning including scheduled maintenance plans with DBCC CHECK DB, Index Reorganization and Update Statistics
- Monitored data activities (i.e. database status, logs, space utilization, extents, checkpoints, locks and long transactions)
- In - depth understanding of security and backup procedures to ensure database integrity
- NetApp SAN administrator of six Filers in the United States and the United Kingdom
- Created and administrated databases, tables, indexes, datasets and constraints using both Microsoft & Oracle databases
PROFESSIONAL EXPERIENCE:
Database Engineer
Confidential, Irvine, CA
Responsibilities:
- SQL Server 2016 Always Encrypted including master and column level key administration.
- Software Deployments weekly using Visual Studio 2012 with Team Foundation Server (TFS).
- Standardize SQL Server environment including SAS Disks formatted to 64k, separating drives for system/user databases, TempDB and adding additional TempDB files based on virtual processors.
- Create Performance Tuning standards (max memory, auto growth settings, DBCC Check commands, Index Tuning, Update statistics, SQL Agent errors 823, 824, 825 along with severity levels 19 through 25).
- OLA scripts for backups and index maintenance as well as integrity checks for user and system databases.
- Oracle 12c administration including Cloud Control and RMAN backups.
- Oracle SQL Server Developer to assist with Oracle 12c administration of financial SBO databases.
Principal Database Administrator
Confidential, Huntington Beach, CA
Responsibilities:
- Installed, upgrade and patch SQL Server 05/08/2012 Clusters.
- Managed the migration of SAN Compellent storage to NetApp.
- Assessment of SQL Environment for installation, configuration, storage, CPU, memory, IO and security.
- Setup of jobs and alerts for Backup Restore, re-indexing, integrity checks, database shrinking, transaction log growth monitoring and routine database maintenance processes.
- Expert in Installation, Configuration, Maintenance and Administration of SQL Server including always on SQL 2012/2014.
- Experience in using SQL Server Native Tools (Profiler, SSMS, SSIS, SSRS, PerfMon, DMVs, DMFs) and third party DBA tools and applications (Ignite, Foglight, Nimsoft).
- Monitored Databases for lock escalation, dead lock, resource utilization by sessions, package caching, buffer pool hit-ratios, Capture long running SQL/runaway queries.
- Controlled user access rights, and manage data security.
Database Administrator / SAN Administrator
Confidential, Denver, CO
Responsibilities:
- Installed, upgrade and patch SQL Server 05/08/2012 Clusters.
- Maintained company MS SQL 05/08/12 Databases on MS Windows platforms.
- Set up and maintenance of SAN and SQL Disaster Recovery for three countries.
- SAN Administration of NetApp Filers on data centers for East & West coast of United States.
- Responsible for all backup jobs including over one hundred databases.
- Estimated disk storage requirements for database software, files and administration needs.
- Implemented & manage database clustering, failover and load balance technologies as per client requirement.
- Installed & configured database software, associated tools and performance monitoring software.
Database Administrator / Technical Instructor
Confidential, Denver, CO
Responsibilities:
- Assisted Networking team with Database Administration of SQL 05/08 Clusters on a MS Windows 2003 platform.
- Implemented & manage database clustering, failover and load balance technologies.
- Maintained individual service accounts for SQL Server services to raise security mark.
- Created Linked Servers between SQL Server 2005 and 2008 R2.
- Taught Microsoft SQL Database Administration courses.
- Taught courses in Microsoft T-SQL as well as SSAS, SSIS, SSRS.
- Presented multilevel classroom courses on Microsoft Excel/Outlook/Word using MOC.