Stephen Slaven
[Send email to request phone number] 87-9984 home
(856) 340-2766 - cell
[Send email using form at bottom]
SUMMARY
Highly motivated DBA with experience in SQL Server Databases. Demonstrated
leadership abilities and team work skills as well as the ability to accomplish
tasks under minimal direction and supervision.
TECHNICAL SKILLS
Programming Languages:
Transact SQL, XML, SSRS, SSIS, SQL, PL/SQL, SAS, C+, MS Access, Word, Excel,
Power Loader, Perl, COBOL
Database Skills:
Microsoft SQL Server 2000,2005 and 2008, Oracle, Oracle Reports, Oracle Forms,
Oracle Enterprise Manager, Navigator, ERWIN, Toad, RMAN
Operating Systems:
Windows 98/2000/XP, Windows Server 2003, UNIX, IBM, DEC, Linux
Software:
PeopleSoft, SQL Server Management Studio, Microsoft Visio, Microsoft Office,
Database Engine Tuning Advisor, SQL Server Profiler, Oracle Management Utilities,
Experience
SetFocus, LLC. Orlando, FL
09/08 - 04/09
SQL Server DBA
Created numerous simple to complex queries involving self joins, correlated
subqueries and XML techniques for diverse business requirements. Tuned and
optimized queries by altering database design, analyzing different query options,
and indexing strategies, using SQL Server 2005 & 2008.
Employed best practices in creating a complete schema including tables,
relationships, stored procedures, views, clustered and non-clustered indexes and
triggers, and implemented the importation and exportation of data using XML and
SSIS.
Created various reports according to the business requirements using SSRS.
Implemented robust stored procedures, functions, and triggers to implement
required functionalities.
Developed a backup and recovery plan based on the data availability
requirements.
Designed database maintenance plans to set up core maintenance tasks to make
sure that the database performs well, is regularly backed up in case of system
failure and is checked for inconsistencies.
Employed the Database Engine Tuning Advisor to analyze the performance effects
of workloads and implemented its recommendations wherever appropriate.
Used the SQL Server Profiler tool to monitor the performance of SQL Server
particularly to analyze the performance of the stored procedures.
Analyzed different high availability solutions and implemented database
mirroring and replication.
Familiar with employing Service Brokers, enabling HTTP support and
establishing Notification Services.
Transcore Inc Orlando, FL 11/07 - 9/08
Database Administrator (Contractor)
Upgraded databases to Oracle version 10g, on HP Itaniums Server running on
VMS
Ran RMAN to backup and restore for the Oracle databases, loading the Oracle
7.3.4 data into 10G
Developed documentation and scripts to support this upgrade
Managed the Loan Origination Production Database.
Ensured data integrity, data recoverability and quick access to data.
Recommended system improvements and provided support for improvements.
PMA Re-Insurance Corp Philadelphia, PA 08/96 - 10/07
Applications/Database Administrator
Installed, maintained, and created Oracle databases on Compaq TRU64 and
Windows NT.
Installed, and maintained SQL server 7.0 and 2000, using PeopleSoft.
Installed, tuned, and patched Oracle and SQL server databases.
Provided application and security support on all database.
Conducted timely backups and restore operations on all databases.
Successfully implemented Oracle upgrade for A/R implementation, which resulted
in the ability to access A/R over our Intranet and provide more reliable
reporting
Troubleshot applications created by the Development Group, to catch potential
bugs.
Documented and maintained procedures for backup and restores, which results in
quicker restores and heads off potential problems.
Upgraded Oracle databases and Oracle financials.
Assisted other team members in developing their technical skills.
Provided support to team members in all phases of the software development
life cycle
Managed a team of 6 members helping them develop database and development
skills.
Setup Oracle 11i Rac in a Linux environment.
U.S. Vision Deptford, NJ 02/95 - 08/96
Database Administrator
Installed, maintained, and upgraded Oracle databases HP server using UNIX.
Maintained Lotus Notes using AS/400.
Installed, tuned, and patched Oracle databases.
Administered security on Oracle and UNIX systems.
Conducted timely backup and restore operations on Oracle and UNIX systems.
Created interface between Oracle and Lotus Notes.
Maritrans Inc Philadelphia, PA 02/84 - 02/95
Programmer/Database Administrator
Maintained and created Oracle databases running on an IBM/AX Unix server.
Installed and patched Oracle databases.
Provided application and security on all Oracle databases.
Converted Natural/Adabas system to Oracle system, which dramatically improved
companys core billing systems.
Installed and maintained software relating to manufacturing, order entry, and
financial systems.
Maintained security of system with ACF2 and natural security packages.
Developed training manuals and facilitated PC classes for users on various PC
products, which resulted in teaching the tug shipmates valuable computer skills
to run tracking system.
Installed and maintained desktop hardware/software on office and vessel
desktops.
Developed and maintained a vessel tug tracking system, which helped the
company capture lost revenue.
EDUCATION
Widener University Wilmington, DE
Bachelors of Science, Computer Science - Overall GPA 3.34
HONORS AND AWARDS
Phi Beta Kappa, elected senior year
Awarded the Chairmans award at Maritrans in 1995.
CERTIFICATIONS
Oracle Database Administrator Certification - Learning Tree
Oracle Financials Certification - Oracle University
Oracle HR Certification - Oracle University
Desktop Troubleshooting - Learning Tree
|
