IT Database Specialist Resume Fort Hood, Texas - Hire IT People

SUMMARY

Proficient with MySQL and 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, Confidential lookup, Confidential Grouping, Confidential )
Skilled with preparing and analyzing reports in reference to both healthcare data and Confidential equipment.
Extensive experience on SAS, SQL and PL/SQL scripts for applying few transformations and cleansing data.
Strong Experience the various High Availability Implementation such as Failover Clustering, Mirroring, Log Shipping, Replication and Always On

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential, Fort Hood, Texas

IT Database Specialist

Responsibilities:

Served as an IT Specialist in the Confidential responsible for maintaining and troubleshoot database systems dat 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 dat Guard Soldiers rely on to accomplish their mission
Performed maintenance and performance tuning on MS SQL Server 2000-2003 databases and the network
Trained others on use of networks, software build, security and test applications

Confidential, Austin, Texas

Pest Control Tech

Responsibilities:

Inspect customer’s premise to identify insect and pest problems and applies appropriate products according to label directions..

Confidential, Austin, Texas

Junior Database Administrator

Responsibilities:

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 MySQL Query Analyzer.
Review and enhance documentation on change/ modifications made to systems. Such as when was the last backup/restore and who tested dat backup.

Confidential, San Antonio, Texas

IT Analyst/DBA support

Responsibilities:

Responsible for troubleshooting and maintenance on servers and OLTP Databases for our Pyxis Inventory System, used across various clients/hospitals throughout the Confidential America Region.
Help Design and Implement scalable, secure cloud architecture for Confidential Clients based on Amazon Web Services. Leveraged AWS cloud services such as EC2; auto-scaling, and VPC to build secure, highly scalable and flexible systems dat ca handle expected and unexpected load burst, and are able to quickly evolve during development iterations. W