Database Administrator Resume
0/5 (Submit Your Rating)
FloridA
SUMMARY:
- Confidential Sims has been working with relational databases for 7 years, to include Oracle, SQL Server, and Microsoft Access. In addition
- Confidential has also worked in Visual Studio development for 4 years, and has supported various products and applications.
PROFESSIONAL EXPERIENCE:
Confidential, Florida
Database Administrator
Responsibilities:
- Developed database and reporting solutions for the Veterans Administration (VA) on such projects as Veteran’s Health Identity Card (VHIC), the Resident Engineer Management System (REMS), Capital Asset Inventory (CAI), Project Management Data Retrieval and Integration (PMDRI) and the Document Repository System (DOCRS). These solutions utilized Oracle 11g, SQL Server 2008, SQL Server Reporting Services and JasperReports.
- Administer SQL Server 2005 and 2008 and Oracle 11g databases.
- Develop packages, procedures and interfaces to provide functionality to web applications and reports.
- Implement integration through the use of SQL Server Integration Services (SSIS).
- Provide reporting capabilities through SQL Server Reporting Services (SSRS) and JasperReports Reporting.
- Migrate Access objects to SQL Server and SSRS.
- Install and implement reporting platforms utilizing SSRS.
- Developed a workflow solution using Microsoft SharePoint, C#, HTML and CSS for use by the Army’s West Point Academy.
- Perform daily database checks, backups, restores, and other administrative functions.
- Created tables, triggers, jobs, views, and indexes on MS SQL Server 2000 and 2005.
- Developed complex T - SQL stored procedures and functions.
- Tune stored procedure and view results; use Profiler to find queries in need of tuning. Implemented snapshot and transactional table replication.
- Developed and maintained SQL Server Integration Services (SSIS) Packages.
- Created Crystal Reports and SQL Server Reporting Services (SSRS) Reports.
- Created automated SSRS solution to dynamically create reports and distribute to file system.
- Developed web applications in ASP.Net/VB.NET using themes and skins to maintain the consistent look and feel throughout the application.
Confidential, Newport News, VA
2nd Level Support Analyst
Responsibilities:
- Query and develop PL/SQL code on an Oracle 10g Database.
- Create local and stored procedures and functions.
- Troubleshot Packages and their components.
- Proposed changes to database objects and identified bugs.
- Developed VB.NET 2005 User Auditing program that imports users, verifies their status in Active Directory, and outputs results to verify Sarbanes-Oxley compliance.
- Developed Access database/VB.NET 2005 program, which formats and imports data files from an external unibasic database or queries PeopleSoft.
- Exports include XML documents, inserts and updates to external databases and reports.
- Migrated Access databases to Visual Basic 2005 application.
- Designed and implemented program for new associates.
Confidential, Moyock, NC
IT Specialist
Responsibilities:
- Developed Access database program for tracking deployments.
- Enhanced existing Access programs for security and functionality.
- Provided help desk assistance to approx 300 employees.
- Maintained and configured laptops and desktops.
- Employed through Office Team 10/ /06.