SEARCH

IT Analyst/DBA support Resume Example

Resume Score: 100%

Love this resume? Build Your Own Now
IT ANALYST/DBA SUPPORT
Summary
IT professional with over five years' of experience working as a DBA support functional analyst and reporting analyst in the military and healthcare industry. In-depth knowledge and passion for working with SQL database installation and maintenance, MS SQL, SQL server clustering/mirroring, log shipping, coding, query, testing and tuning. *Proficient with MS-SQL Server 2003-2014 working with business intelligence tools in SSIS (SQL Server Integration Service), SSRS (SQL Server Reporting Services). *Expertise in Creating Views, Triggers, Functions and stored procedures to facilitate efficient data manipulation and data consistency. *Experienced in writing complex queries using inner, outer, self, joins, correlated subqueries, CTE's (Common Table expressions and temporary tables. *Experience in creating reports using SSRS (SQL Server Reporting), Crystal Reports, SSAS (SQL Server Analytical Services) objects and OLAP including interface with BIDS (Business Intelligence Development Studio). *Great Passion for Performance Tuning, Query Optimization in particular my favorite tools to use is SQL Sentry when tuning database. *Well-versed in usage of SSIS utilities such as control flow items (for Looping, Executing SQL task statements, Script Task, Send Mail Task) and SSIS Data Flow items (such as Conditional split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot) *Skilled with preparing and analyzing reports in reference to both healthcare data and military equipment.
Skills
  • MS Access 2010, MS Office, Visual Studio
  • Operating Systems
  • Windows XP, 7, 8, 10
  • Linux
Experience
05/2016 to 03/2017
IT Analyst/DBA support CareFusion/BD － San Antonio, Texas
  • Strong Experience the various High Availability Implementation such as Failover Clustering, Mirroring, Log Shipping, Replication and Always On Responsible for troubleshooting and maintenance on servers and OLTP Databases for our Pyxis Inventory System, used across various clients/hospitals throughout the North America Region.
  • Analyze reports and fixed bugs in stored procedures using SSRS.
07/2013 to 05/2015
Junior Database Administrator Intel － Austin, Texas
  • Perform operational DBA duties in a large-scale environment.
  • These will include Performance Tuning, patching, database upgrades and application upgrades implementing backup/ recovery and monitoring procedures.
  • Experienced creating/organizing new tables in Database design using Normalization such as 3rd Normal and implementing Entity Relationship Design (ERD) for efficient the database structure.
  • Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like SQL Sentry Plan Explorer.
  • Review and enhance documentation on change/ modifications made to systems.
  • Such as when was the last backup/restore and who tested that backup.
01/2012 to 05/2013
Pest Control Tech Orkin － Austin, Texas
  • Inspect customer's premise to identify insect and pest problems and applies appropriate products according to label directions.
07/2006 to 05/2010
IT Database Specialist U.S. Army － Fort Hood, Texas
  • Served as an IT Specialist in the Army responsible for maintaining and troubleshoot database systems that support the Army's logistics data for all battalion operations.
  • Implemented Security protocols to ensure system integrity and to withstand cyber-attack and the programs that Guard Soldiers rely on to accomplish their mission.
  • Performed maintenance and performance tuning on MS SQL Server 2000-2005 databases and the network.
  • Trained others on use of networks, software build, security and test applications.
Education and Training
Bachelors of Science: Information Technology Data Management Colorado Technical University / College － Colorado Springs Austin, Colorado Texas Information Technology Data Management
Microsoft Certified Solutions Associate / Certification
Masters of Science degree: Information Systems/Database Administration DePaul University Information Systems/Database Administration Programming languages *In depth knowledge and usage of Transact -SQL, SAS, VB.Net Tools *Eclipse *MySQL, SQL Server 2003-2014
Oracle 10G/11G
Skills
VB.Net, Army, backup, Clustering, clients, DBA, Databases, database, Database design, documentation, Eclipse, Inspect, Explorer, Inventory, Linux, logistics, MS Access, Microsoft Certified, MS Office, 2000, Windows XP, MySQL, network, networks, Operating Systems, Oracle, organizing, Programming, protocols, SAS, servers, Shipping, MS SQL Server, SQL, SQL Server, tables, Transact -SQL, troubleshoot, troubleshooting, upgrades, utilities, Visual Studio
Build Your Own Now

Resume Overview

Companies Worked For:

  • CareFusion/BD
  • Intel
  • Orkin
  • U.S. Army

School Attended

  • Colorado Technical University / College
  • DePaul University

Job Titles Held:

  • IT Analyst/DBA support
  • Junior Database Administrator
  • Pest Control Tech
  • IT Database Specialist

Degrees

  • Bachelors of Science : Information Technology Data Management
    Microsoft Certified Solutions Associate / Certification
    Masters of Science degree : Information Systems/Database Administration
    Oracle 10G/11G

Advertisement

Similar Resumes

View All

Sr. Application Analyst

BTMU Capital Corporation

Revere, Massachusetts

Posted 1619 days ago