Database Administrator Resume
Colorado Springs, CO
PROFESSIONAL SUMMARY
11+ years of IT experience including Database Design, Development, and Administration.
TECHNICAL SKILLSLanguages: T-SQL, PL/SQL, C#, VBA, HTML, VBScript
Development Tools: Visual Studios 2010/2008/2005, MS SQL Server Enterprise Manger, Query Analyzer, Profilier, RapidSQL, PeopleTools
Databases: MS SQL Server 2008 r2/2005/2000, Oracle 11
Reporting: SAP Universe, Crystal Reports
ETL: DTS, SSIS, SAP Business Objects
Change Management: Remedy, ClearQuest
Source Control: Visual Source Safe, Team Foundation Server
Application Packages:Visio,MS Office, PeopleSoft, IBM Relationship Resolution
Held SECRET clearance for 8 years, currently inactive.
PROFESSIONAL EXPERIENCESenior Database Developer 7/2008 – Present
Employer:
Confidential, Colorado Springs, CO
Job Description: Designed and developed a transactional database, a data warehouse, and ETL procedures for El Paso Corporation information systems. Provide production support for legacy systems.
Responsibilities:
- Designed and developed SQL Server 2008 databases, including transactional systems and a data warehouse
- Worked with users to create meaningful business requirements
- Created logical and physical data models
- Composed data dictionary
- Contributed to Enterprise Master Data project
- Mentored programmers on database best practices
- Developed ETL jobs for Oracle and SQL Server
- Developed database schemas, stored procedures, indexes, constraints, functions, triggers, and reports
- Evaluated database performance and tuned accordingly
- Utilized Visual Studio and Team Foundation Server to manage database development and implementation
- Wrote technical documentation in support of SDLC
Database Administrator 3/2006 – 7/2008
Employers:
Confidential, Colorado Springs, CO
Confidential, Colorado Springs, CO
Job Description:
Designed and developed databases and vetting user interface. Supported production databases and vetting system for the Department ofHomeland Security (TSA).
Responsibilities:
- Performed administration tasks including installation of database software, backup and recovery, file partitioning, and job scheduling
- Designed and developed SQL Server 2005 databases
- Interviewed users, developed data models, and created technical design documents
- Designed and implemented database schemas, stored procedures and triggers
- Designed and developed user interface for vetting system
- Created and managed DTS and SSIS packages
- Assisted intelligence analysts with data searches and analysis
- Wrote complex data queries
- Wrote technical documentation in support of SDLC
- Secret Security Clearance
Developer/Analyst 2001 – 2005
Employers:
Confidential, Virginia Beach, VA
Confidential, Virginia Beach, VA
Job Description:
Designed and developed databases and GUIs for the US Navy. Conducted business case analysis and cost analysis.
Responsibilities:
- Designed and developed databases in SQL Server and Microsoft Access
- Designed and created user interfaces with Microsoft Access, ASP.NET, Visual Basic 6, and Visual Basic .NET
- Create reports with Crystal Reports
- Wrote technical documentation and user manuals
- Conducted business case analysis
- Supervised six analysts
Programmer/Analyst 1999 – 2000
Employer:
Confidential
Job Description:
Worked as part of a team to customize a university-wide software package from PeopleSoft with an Oracle database.
Responsibilities:
- Wrote technical designs based on functional requirements
- Developed and tested modifications to PeopleSoft software
- Created graphical user interfaces, stored procedures, and triggers
- Designed and coded reports
- Presented modifications for user feedback
- Wrote test scripts
- Tested and reviewed the work of other programmers
Degree: Master of Business Administration
Concentration: Information Systems
Degree: Bachelor of Business Administration
Concentration: Information Systems