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.
MS Access 2010, MS Office, Visual Studio
Windows XP, 7, 8, 10
05/2016 to 03/2017
IT Analyst/DBA supportCareFusion/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.
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 TechOrkin － 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 SpecialistU.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 ManagementColorado Technical University / College － Colorado Springs Austin, Colorado TexasInformation Technology Data Management
Microsoft Certified Solutions Associate / Certification
Masters of Science degree: Information Systems/Database AdministrationDePaul UniversityInformation Systems/Database Administration Programming languages
*In depth knowledge and usage of Transact -SQL, SAS, VB.Net
*MySQL, SQL Server 2003-2014
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
Bachelors of Science : Information Technology Data Management Microsoft Certified Solutions Associate / Certification Masters of Science degree : Information Systems/Database Administration Oracle 10G/11G
Create a job alert for [job role title] at [location].