Database Admin Resume
VA
WORK EXPERIENCE
Confidential,
Arlington, VA
2/11 - 4/11
Database Admin
-Manage DoD-based Portal, backed up by SQL Server 2005 Database.
-Create T-SQL scripts for information requests.
-Provide help desk services for issues concerning the functionality of the portal.
-Assist in facilitating IT setup of board meetings of top Air Force Brass.
-Learned T-SQL/SQL Server and Powershell.
-In the process of developing PERL scripts to streamline processes in SQL server to quickly format requested data.
Confidential,
Alexandria, VA
10/10 - 2/11
Portal Content Manager
Chief System Administer for government used portal. Supports/manages traffic from multiple government agencies and departments. Responsible for functionality, upgrades, user access, content and training.
Confidential,
Alexandria, VA
12/2007 - 10/2010
Programmer II/Database Administrator
-Performed Database Administration for CTSummation Legal Database. Chief Database Admin for user privileges, loading files and exhibits to the database, troubleshooting system errors.
- As Summation DBA, regularly accessed the server and backed summation data.
- Created/edited pre-existing tables, triggers and stored functions.
-Extracted, Transformed, and Loaded 1TB of data into several web databases.
-Learned PERL, MySQL and PL/SQL; writing over 100 scripts.
-Created PERL scripts for data retrieval, ad hoc querying; PERL being a derivative of Unix/Linux.
-Performed ad hoc requests for data retrieval and updates in SQL Developer and SQL Plus(Oracle SQL).
-Used SFTP to transfer encrypted data to outside vendors for processing confidential information.
- Worked in a team-oriented environment, at times serving as lead for certain projects.
- Years of experience working with end-users to precisely get the information they are seeking.
- Worked with MS Excel and MS Access; report formatting and data processing.
Confidential,
Silver Spring, MD
5/2007 - 10/2007
Configuration Management Analyst
-Provides support to teams that make changes to the Collection Litigation System.
-Tracks and manages a list of requested changes to COTS vendor products.
-Assigns tasks to the Requirements Analyst and Help Desk Team.
-Manages the updates to the "Software Project Library" and Inventory Log.
-Gives authorization to the Test Team to begin various test phases for software release.
-Moves baseline programs to the appropriate environment during the test phases.
-Authorizes the release of program changes into the "Production Environment".
-Conducts baseline audits and provides status reports and metrics.
Confidential,
Washington, DC
5/2006 - 5/2007
Requirements Analyst
Requirements Analyst (Workstation Configuration Management Project):
-My team managed Remedy database containing the profiles of each workstation of every employee of the Library of Congress.
-Working in concert w/ a team of fellow SAIC employees we were facilitating the upgrade of every workstation in the Library of Congress.
-Documentation: Kept track of applications and user configurations in a collection of MS Excel spreadsheets.
-Testing: Tested prototype for documentation in collecting user configurations, made suggestions on system upgrades.
Help Desk: Interacted with users on functionality/resolve issues on electronic configuration forms.
Confidential,
Herndon, VA
1/2006 - 2/2006
Junior IT Business Analyst
-Prepared the daily CASH/MBS Inventory and Daily financial MIS report, using MS Excel: used macros to pull up financial reporting formats, edited formulas to modify financial reports.
-Conducted ad hoc SQL queries for personnel to obtain financial information from the company database in MS Access. Worked on projects in VBA coding in MS Access.
Confidential,
Forestville, MD
1/2004 - 4/2005
IT Manager
-Created database which contains all of the company\'s records.
-Used MS Office applications to prepare bids and conduct searches.
-Created and developed company\'s network. Maintained and repair company\'s hardware/software.
-Sorted, maintained, updated company\'s files and records. Developed and maintained company\'s web site.
BS in Business Administration/Information Systems
-
