Sql Server Engineer

Aaron A. Smith

*** ****** ******* **

Glen Burnie, MD 21060

PHONE 202-***-**** ************@*****.***

[pic]

QUALIFICATION SUMMARY

Organized, articulate Database Administrator/Engineer with 10 years of

progressively responsible experience within the information technology

area, covering database management systems, server support, and database

application systems. Demonstrated ability to utilize both technical and

functional skills to prioritize tasks, meet time-sensitive deadlines, and

work independently or as a team member to achieve goals. Excellent

leadership with skilled communication capabilities when interfacing with

government leaders, clients, customers, and vendors. [pic]

Security Clearance: Top Secret/SCI with a Full-Scope Polygraph, BI dated

December 2008

FS Poly dated August 2009

Skills:

O/S: Windows, UNIX, Linux/Solaris

RDBMS: Oracle 9i/10g/11g, SQL Server 2008, Sybase ASE Server, Microsoft

Access

Utilities: Oracle Enterprise Manager, PeopleSoft, RMAN, Oracle, SQL

Server Migration Assistant, Oracle Streams, Datapump, Dataguard,

SQL Developer, Putty, SSH/SFTP, Toad, Weblogic, STAT for

PeopleSoft

[pic]

Education B.S. Computer Science - Bowie State University May 2003

[pic]

Professional Experience

10/2012 - Present - Deloitte

Database Administrator (NSA)

. Administer several dozen multi-terabyte Oracle 11g/SQL Server 2008

database/web Unix/Linux O/S servers in development and production

environments serving a very large community of government customers.

. Execute data migrations and data loads for multiple developmental teams

across several servers using PeopleSoft Application Designer, Datapump,

and SQL Server Migration Assistant.

. Design relational database via the creation and manipulation of schema,

procedures, functions, table relationships, constraints, indexes, views,

triggers and database links.

. Maintain policy & procedure documentation per database, server, and

System Security Plan (SSP) along with major administrative tasks, and

processes.

. Administer and monitor change management using STAT for PeopleSoft in

support of high and low level environments covering all application and

database servers in addition to user account management.

. Participate in the DoD Information Assurance Certification and

Accreditation Process (DIACAP) assisting in the Plan of Action and

Milestones (POA&M) to remediate/mitigate IT control weaknesses per

mandated security measures and Security Technical Implementation Guide

(STIG) processing.

. Support database web application via PeopleSoft and Weblogic utilities.

. Collaborate with System Administrators to manage user and application

security and development.

07/2011 - 06/2012 - L3 Communications

Database Administrator (NSA)

. Performed migration testing for Oracle 11g and SQL Server 2008 databases

for transition planning while providing the design for data extraction

and ingest.

. Supported the Oracle 11g and SQL Server 2008 development and production

database systems per several hundred member back end user community.

. Managed RMAN database backup and recovery planning and implementation

along with monitoring DB processes and user management.

. Developed text based query index design, increasing the processing speed

of data character search capture of foreign data along with the

configuration of appropriate lexer types.

. Created database triggers, stored procedures in addition to UNIX shell

scripting.

. Installed and implemented Database and COTS software of query design and

modification strategies.

05/2010 - 05/2011 - SITEC CONSULTING

Database Administrator (NSA)

. Maximized and maintained database stability within development and

production environments.

. Implemented and administered Oracle Streams per requirements to

replicate databases.

. Migrated/ingested data and transfered to Government financial reports.

. Built SQL Server and Oracle databases instances and schema necessary for

development testing.

. Installed SQL Server 2008 and Oracle 10g/11g server software and related

products.

. Established and preserved sound and manageable backup and recovery

policies and procedures via RMAN.

05/2009 - 05/2010 - SYBASE, INC.

IT Consultant / Database Administrator (NSA)

. Supported database migration planning and implementation, stored

procedures scripting, and administered command line and Replication

Server administration.

. Troubleshot and diagnosed problems at the server and database levels and

conducted performance and code analysis.

. Provided technical support and research for various development groups

concerning issues related to system performance and progression; created

UNIX shell script to monitor performance, consolidated backup and

recovery, and automated administration tasks.

09/2007 - 05/2009 - Lockheed Martin

Database Administrator (DoD)

. Administered Oracle 10g and SQL Server 2008 databases on Windows and Sun

Solaris platforms in a 24/7 managed environment.

. Installed and configured database and application server packages,

patches, and other approved system software sided by client software for

development and production purposes.

. Maintained, monitored, and developed databases based on strict

procedures and scheduling practices.

. Managed importing and exporting of database data for upgrade from

development to production servers while diagnosing errors, monitored

space usage and system performance.

. Utilized the Security Technical Implementation Guide (STIG) processes to

ensure system integrity and made necessary corrections per audit report

findings.

09/2006 - 09/2007 - ManTech

Database Administrator (DoD)

. Administered Oracle and SQL Server databases on Windows and LINUX system

platforms and developed automated backup procedures.

. Installed and maintained database software, application software, and

COTS software relative to DBMS administration.

. Provided tier level 3 support for database related issues and RMAN

backup scheduling; in addition performed regularly scheduled maintenance

processes to maintain database stability.

. Coordinated with system administrators and developers in order to

properly provision and maintain assigned systems while assessing

potential impacts to systems based on changes to requirements and system

usage.

06/2006 - 09/2006 - ABFloyd Enterprises

Database Administrator (DoD)

. Performed database administration and development functions for DISA

while handling the backup and recovery planning of critical database

system information; maintained archived data both on tape and by backing

up and restoring the database to an online application server.

. Constructed and modified primary database objects (queries, tables and

forms) as needed to improve database functionality after application

design.

. Controlled and maintained user accounts, managed system updates and

patches.

06/2004 - 06/2006 - SYBASE, INC

IT Consultant (DoD)

. Supported Sybase and Oracle database servers for several JPAS database

servers, ensured optimal system performance and prevented global system

failure by using extensive SQL, T-SQL, and UNX shell scripting

strategies.

. Organized and ensured data dependency sensibility through normalization

standards and utilized Oracle Enterprise Manager and SQL to create

primary database storage structures.

. Developed SQL scripts in Sybase ASE Server RDMS and provided technical

support and research for various development groups concerning issues

related to Oracle and Sybase server performance.

. Monitored and managed data servers, making restorations and repairs as

needed and managed database and application software version upgrades.

10/2003 - 06/2004 - Raytheon

Software Engineer (DoD)

. Performed daily administrative tasks for the continuous operation of a

24x7 SUN Solaris system by maintaining system functionality and handled

the installation of newly changed code procedures using UNIX shell

scripting strategies and SQL-based applications.

. Developed Cognos discrepancy reports to track system errors affecting

program functionality and collected and maintained logs of all central

system activity and communicated with appropriate departments about

project planning and system organization.

. Investigated and diagnosed highly complex mainframe operational issues

pertaining to open and active projects, as well as monitored system

applications.

09/2002 - 10/2003 - Environmental Protection Agency

Database Developer / Programmer (DIA)

. Developed SQL in Microsoft Access relational databases and executed

programs using Compaq iPAQ Pocket PCs equipped with Compaq wireless LAN

network cards for development.

. Designed wireless data display screens used as part of a low thru-put

system available to any authorized user from any web browser using HTML,

JavaScript, and SQL.

. Performed testing of the wireless project using acquired handheld

devices and Verizon Wireless service to be adopted as a model by other

organizations.

05/2002 - 09/2002 - Environmental Careers Organization

Database Application Intern (DIA)

. Led the full database management of the State Authorization Tracking

System in Microsoft Access as a Database Application Intern at

Environmental Careers Organization; in addition, created reports and

converted formats for placement on EPA internet/intranet web site.

. Solicited and administered input from the regional and environmental

staff regarding potential data reports and updated database data upon

receipt.

. Converted databases from a legacy software application to the EPA's

Permits and State Program Division standard database package.

Contact this candidate