Sr. Database Administrator Resume Reston, VA - Hire IT People

SUMMARY

SQL Server DBA (2000, 2005, 2008R2, 2012, 2014, 2016), SSIS. SQL Server DBA for the last 11 years
Certified Oracle DBA 8, 8i and 9i
Experienced wif large scale complex Legacy Systems, 1 ½ Terabyte in size.
Experienced designing dimensional models, including physical and logical data modeling.

TECHNICAL SKILLS

Languages: VB (4 - 6, 2005, 2008 and 2010), MS .Net, Crystal Reports, SQL, PL/SQL

Database: SQL Server (2000 and 2005, 2008, 2008R2, 2012, 2014,2016), Oracle 8, 8i, 9 & 10g

Operating Systems: Windows and Unix

PROFESSIONAL EXPERIENCE

Confidential

Sr. Database Administrator

Responsibilities:

Red Brick Data

Sr. Database Administrator

Responsibilities:

Confidential

Sr. Database Administrator

Responsibilities:

Confidential

Database Administration

Responsibilities:

Production DBA
Writing Stored procedures in SQL Server (T-SQL) for various users.
SSIS package and SSRS reports for server space usage, using powershell to gather data, SSIS to load data and SSRS to generate reports
SSRS and Crystal Reports support for new reports.
Backup and recovery of SQL Server database using native SQL Server backup and recovery. Also EMC networker
User management on SQL Server
Application support

Confidential

Database Administration /Development DBA

Responsibilities:

Performance Tuning of application
Report Server Tuning
SSIS Migration package from OLTP to OLAP databases
SSIS migration using T-SQL scripts to migrate an applications database to a refactored database.
Migration of existing application to new version (schema) for application
Support of query/stored procedure tuning for online application in production
T-SQL stored procedure writing and tuning. Specialty T-SQL scripts for data cleansing and data modifications.
Database performance tuning using SQL Profiler tracing, Database Tuning Advisor and custom application.
Escalation support production
Wrote custom application for working wif SQL Profiler traces and mapping SQL Server databases (2005 and 2008 versions)

Confidential

Data Analyst

Responsibilities:

Confidential

Programming / DBA

Responsibilities:

Database design and programming for a custom application for calibration of radiation survey meters, utilizing Oracle 9i, 10g and SQL Server 2005.
Design and build Applications take the results from external laboratories and apply them to the samples, generate Crystal Reports from this data.
Nuclear Power Plant databases are roughly 6 Gigabytes in size.
Application to track radioactive sources, instruments and personnel radiation exposure for small facilities.
Designing databases including physical and logical data modeling.
Responsible for performance tuning and analysis of queries and PL/SQL code.
Responsible for writing Oracle Applications utilizing PL/SQL and .Net, report results are generated in Crystal Reports.
Responsible for database design, backup and recovery procedures.
Monitoring applications in both SQL 2005 and Oracle 10g.
Interface wif Architects, Developers, and End Users on a daily basis.
Responsible for backup, recovery, space management, and tuning, both in house and remotely.
Applications written in VB.Net using T-SQL or PL/SQL

Confidential, Reston, VA

Oracle DBA

Responsibilities:

Responsible for database design, writing stored procedure, capacity planning, database tuning, backup and recovery, planning and implementation.
Oracle installation, migration and upgrades on Win NT and HP-UX.
Responsible for a large complex Legacy data migration of mainframe systems to Oracle Database System for the US Navy.
Database was roughly 1 ½ Terabytes in size.
Designed dimensional models, including physical and logical data modeling.
Interfaced wif Architects, Developers, and End Users on a daily basis.
Performance tuning and analysis of queries and PL/SQL code written by developers and end-users
Responsible for database design, backup and recovery procedures.
Responsible for writing PL/SQL queries.
Developed database documentation and design using ERWin.