Sql Server Support
Resume:
Stephen Slaven
Windermere, Fl 34786
*********@*****.***
SUMMARY
Highly motivated IT Professional with experience in SQL Server Databases, Oracle Databases.Demonstrate leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.
TECHNICAL SKILLS:
Create and Develop Stored Procedures for Projects using T-SQL in SQL SERVER\
Use ErWin to Data model, Create and Document an Oracle databases from 600 flat files.
Use Data Modeling tools to create a SQL Server database from a CRM application.
Tune code using explain plans in T-SQL.
Create and Develop SSIS Packages.
Create and Develop SSRS Reports.
Create and Develop Stored Procedures for Projects using PL/SQL in Oracle.
Knowledge in database architecture and design;
Experience with database replication and integration;
Experience with SSAS
Understanding of multiple database concepts and procedures;
Proven experience in a data warehouse application development environment;
Expertise in schema optimization for performance and scalability;
Excellent written communication skills;
Data analysis/modeling
Excellent problem solving ability;
Ability to multi-task and still maintaining focus;
Create Training materials to support training of various Applications and Projects
Create Documentation to support projects
Teach students and users using Training materials
Programming Languages:
Transact SQL, XML, SQL, PL/SQL, SAS, MS Access, Word, Excel, Power Loader, COBOL
Database Skills:
Microsoft SQL Server 2000,2005,2008-r2,2012 and 2016, Oracle 8,9,10 & 11, Oracle Enterprise Manager, Navigator, ERWIN, Toad, RMAN, Teradata
Software:
SQL Server Management Studio, Microsoft Visio, Microsoft Office, and Toad for Oracle, Database Engine Tuning Advisor, SQL Server Profiler, Oracle Management Utilities, Crystal Reports, ETL, SSAS, SSRS, SSIS, DTS
Experience
Osceola County Court Osceola, FL 03/2016–02/2017
SQL Server Developer/DBA
Create and Develop SSIS Packages for Projects using Visual Studio 2014.
Create and support SSIS packages to extract data in *PSV, *CSV files to various court customers.
Create and support SSIS packages to send to Court State agency.
Create Procedures to populate SSRS reports that are consumed by internal customers.
Create and support various Crystal reports.
Create documentation to support t projects.
All Software changes, projects are tracked thru to production using Manage Engine.
Tuning queries in SQL Server 2012 & 2016
Support and Maintain BenchMark application which is the main application used at the courthouse.
Create and Support reports, lists, and forms used in Benchmark.
Backup SQL Server databases on a daily basis.
Restore Production database to our Test and Development environment.
AAA Lake Mary, FL 09/2015–02/2016
SQL Server Developer
Create and Develop Stored Procedures for Projects using T-SQL.
Using FTP to download the files into *CSV data.
Create SSIS packages to extract the *CSV files into the database tables.
Create Procedures to Extract 5 million rows of data from outside AAA clubs
This includes a series of T-SQL queries that manipulates the data to get ready for online production application.
Create documentation to support this project.
All Software changes, projects are tracked thru to production using JIRA.
Tuning queries in SQL Server using explain plan
Orlando Health Orlando, FL 06/2015–08/2015
Data Analyst
Documenting SSIS packages.
Re-factoring and updating the SSIS packages for SQL Server 2012.
Symantec Lake Mary, FL 04/2013–05/2015
SQL Server Developer/DBA
Create and Develop Stored Procedures for Projects using T-SQL
Create, Update, and Support SQL2008R2 Databases
Backup, Restore SQL Databases using SQL Backup, and Restore Utility
Create & Maintain SSIS packages
Use SSIS packages for ETL.
Create & Maintain SSRS reports
Getting data for the SSRS and SSIS from Excel Files.
Create & Maintain SSAS Projects Using Cubes
Tune and Upgrade stored procedures.
Database migration and import/export.
Performance monitoring of SQL servers.
Track and document server and database changes
All Software changes are tracked thru to production using TFS
Support, Maintain and Control Security on Salesforce
Support, Maintain and Administrator in Satmetrix application for Symantec Surveys.
Maintain and Support CRM applications.
Lee Hecht Harrison Maitland, FL 12/2011–04/2013
SQL Server Developer
Create and Develop Stored Procedures for Projects using T-SQL
Create & Maintain SSIS packages.
Convert DTS packages to SSIS
Create & Maintain SSRS reports,
Create & Maintain Crystal reports
Convert Crystal reports to SSRS reports.
Getting data for the SSRS and SSIS from Excel Files.
Setup and Supporting users in Report Builder 3.0
Created and Supported the Candidate Portal
Create & Maintain stored procedures, views, indexes and tables in SQL Server Databases
Document and Support internal and External Applications.
Create and Support packages written .net
Backup, Restore SQL Databases using SQL Backup, and Restore Utility
Supported and Maintained SQL Server Reporting Services (2008+) writing reports, writing report models, administrating a SSRS server instance and BI portal
Experience working with SSAS
Data analysis/modeling for Sql Server databases.
Working with team members on a global scale across multiple countries
All Software changes, projects, and documentation are tracked thru to production using TFS.
Universal American Financial Corp Lake Mary, FL 09/2010–12/2011
SQL Server Developer
Create and Develop Stored Procedures for Projects using T-SQL
Create, Update, and Support SQL 2005& 2008 Databases
Backup, Restore SQL Databases using SQL Backup, and Restore Utility
Create & Maintain SSIS packages
Use SSIS packages for ETL.
Create & Maintain SSRS reports
Getting data for the SSRS and SSIS from Excel Files.
Tune and Upgrade stored procedures.
Database migration and import/export.
All Software changes, projects are tracked thru to production using TFS.
Performance monitoring of SQL servers.
Track and document server and database changes
Document and Support Medical Insurance Applications.
Create and Support packages written .net
Support Sharepoint helping out Sharepoint Administrator.
Techskills Maitland, FL 09/09–09/10
IT Instructor
Teach students in Oracle versions 10 & 11, Excel, Word, Power Point, SQL Server 2005 & 2008 Databases, .net, and Linux
Evaluate and grade students' class work, laboratory work, assignments, and papers.
* Maintain student attendance records, grades, and other required records.
* Prepare course materials such as syllabi, homework assignments, and handouts.
* Compile, administer, and grade examinations or assign this work to others.
* Keep abreast of developments in the field by reading current literature, talking with colleagues, and participating in professional conferences.
* Initiate, facilitate, and moderate classroom discussions.
* Plan, evaluate, and revise curricula, course content, and course materials and methods of instruction.
* Supervise students' laboratory work.
* Maintain regularly scheduled office hours to advise and assist students.
* Advise students on academic and vocational curricula and on career issues.
Generate and adjust long-term and short-term forecasts for assigned programs.
Review historical data and long-term forecasts to provide staffing recommendations to Campus Directors and recruiting.
Update and maintain databases
Provide performance reports to Campus Directors.
Setup of Windows 2005 servers.
Windows cluster setup and configuration.
Setup of SQL Server 2005, and 2008.
Database migration and import/export.
Experience in SQL Server Integration Service (SSIS).
Show Students how to use SSIS as an ETL tool.
SQL Server Reporting Service (SSRS).
Manage Windows and SQL Server user accounts.
SQL Server disaster recovery techniques and procedures.
Performance monitoring of Windows and SQL servers.
Track and document server and database changes
Transcore Inc Orlando, FL 11/2007 - 9/2009
Database Administrator
Install and configure databases to Oracle version 10g, on HP Itaniums Server running on VMS
Run RMAN to backup, restore for Oracle, loading the Oracle 7.3.4 data into 10g
Created Oracle databases, tables, indexes on 10g to support upgrade from 7.3.4.
Develop documentation and scripts to support this upgrade
Upgrade SQL Server databases from 2000 to 2005.
Write various reports using SSRS.
Write various packages in SSIS and DTS to interface with Oracle.
Used SSIS for ETL with Oracle.
Create & Maintain Crystal reports
Scripting and task scheduling in Windows.
Data analysis/modeling for Oracle/Sql Server databases.
Manage the Loan Origination Production Database in SQL Server 2005.
Ensure data integrity, data recoverability and quick access to data.
Recommend system improvements and provided support for improvements.
PMA Re-Insurance Corp Philadelphia, PA 08/1996 - 10/2007
Database Manager/Project Manager
12 years of support on Oracle, SQL Server, and Unix in a production environment.
Install, maintain, and create Oracle databases on Compaq TRU64, Windows NT.
Install, and maintain SQL server 7.0 and 2000, using PeopleSoft.
5+ years of hands on experience on SQL server.
Use DTS/SSIS to move SQL HR data into Oracle database as part of ETL tool.
Install, upgrade, and patch Oracle and SQL server databases.
Conduct timely backups and restore operations on all databases.
Successfully implement Oracle Financials for A/R,G/L,A/P and HR, which resulted in the ability to access Financials and HR over the company Intranet and provide more reliable and timely reporting.
Create and support G/L, A/P, A/R and HR reports written in PL/SQL.
Troubleshoot and support applications created by the Development Group, to catch potential bugs.
Task scheduling in Windows.
Upgrade Oracle databases and Oracle financials.
Assist other team members in developing their technical skills.
Provide support to team members in all phases of the software development life cycle
Manage a team of IT professionals in developing, implementing, and customizing insurance claims projects as Project Manager, this project ran for 3 years.
Setup Oracle 11gRac in a Linux environment.
Data analysis/modeling using ErWin for Oracle Databases
Maritrans Inc Philadelphia, PA 02/1984 - 08/1996
Programmer/Database Administrator
Maintain and create Oracle databases running on an IBM/AX Unix server.
Install and patch Oracle databases.
Provide application and security on all Oracle databases.
Convert Natural/Adabas system to Oracle system, which dramatically improved company’s core billing systems.
Install and maintain software relating to manufacturing, order entry, and financial systems.
Develop training manuals and facilitate PC classes for users on various PC products, which resulted in teaching the tug shipmates valuable computer skills to run tracking system.
Develop and maintain a vessel tug tracking system, which helped the company capture lost revenue.
EDUCATION
Community College of Philadelphia Philadelphia, PA – May 1984
Associates, Computer Science - Overall GPA 3.34
CERTIFICATIONS
• Oracle Database Administrator 10g Certification –Techskills
• MCTS: Microsoft Certified Technology Specialist: SQL Server 2008- Techskills
• Oracle 10g HR Certification - Oracle University
• Linux Administrator Certification -TechSkills
• Implementing SQL Server 2008 Databases
• Designing a SQL Server 2008 Infrastructure
• Designing High Availability Databases using Server 2008
• Oracle Database Administrator 7 Certification – Learning Tree
Contact this candidate