Laura C. Ost (321) 363-3545
101 Gleason Cv
Sanford, FL 32773
[Send email using form at bottom]
Professional Profile
I am seeking a position that utilizes my database administration and development
skills necessary to lead organizations in the successful design, implementation,
and administration of Microsoft SQL Server 2000/2005 databases.
· Database Management
· Project Management
· MS SQL Server 2000/2005
· SQL Server Clustering Setup and Management
· SQL Server Replication, Mirroring and Log shipping
· SQL Server Performance Tuning
· DTS/SSIS Packages
· Complex Data Conversions
· ETL Tools
· Open Source MySql, Firebird
· Linux
· Sarbanes-Oxley audit
· Strong TSQL Development and Tuning
· Database Architecture and Design
Experience and Professional Accomplishments
Connextions
Database Administrator - CONTRACT
October 2007 Present
Key Accomplishments - Database support and consilidation for all production and
production critical applications and development environments. Database and
database server documntation for all production systems.
Installing, Configuration & Maintenance of MS SQL Server 2005, 2000, and 7.0
versions.
Project lead for rewrite and documentation of Lance Armstrong ETL systems.
Supported, developed and configured processes and database systems utilizing
MS SQL Clustering, Replication and Log Shipping.
Design and support of DTS and SSIS packages.
Database backup, recovery and disaster recovery procedures documentation.
Expert TSL skills applied to design and development of stored procedures and
triggers.
Peer review and tune all TSQL code for integrity and performance optimization
for all code prior to production release.
Use performance monitor/profiler to resolve resource bottleneck.
Development and support of replication models - (Snapshot, Merge and
Transactional)
Data modeling and documentation and implementation.
Provided Database Administrative Support through 24x7.
Installed Reporting and Analysis Services and deployed reports.
Worked on Linked and Remote Servers to run distributed queries between SQL
server and other data sources like excel using ODBC, OLE DB drivers.
Excellent analytical, Interpersonal and Communication skills, fast learner,
hardworking and versatile team player, firmly adheres to documentation needs.
Expert TSQL skills expert I develop, review and performance tune all TSQL code
prior to production release.
Developed home grown replication scripts/processes from Oracle to SQL Server
Aspect Call data and Fedex systems.
INCHARGE Institute of America
Database Administrator - CONTRACT
May 2007 October 2007
Key Accomplishments - Create required reports in response to business user needs
and develop data warehouse architecture. Gather information for security and
business audits.
Installation/ configuration / maintenance /performance tuning of SQL Server
2000 and 2005.
Upgraded 3 servers from SQL 2000/2005.
Maintaining/creating/monitoring all maintenance jobs, security needs,
connections, services, backups, performance, storage and server capacity
planning.
Analyzed database performance issues, identifying bottlenecks, configuration
values, and performance issues and implement proper solution.
Monitor server connection, SQL error logs and Windows event logs, and audit
user activities.
Monitor, optimize and allocate physical data storage for database systems.
Inventory data sources and verify uses and user access (all excel, MSAccess
applications, SQLExpress instances) across the network.
Implemented Idera Compliance Manager solution.
Establish appropriate end-user database access control levels.
Develop routines for end-users to facilitate best practices database use.
Oncall support 24/7.
UAFC
Universal American Financial Corporation
Database Administrator
June 2006 May 2007
Key Accomplishments - Assess and develop long-term strategic goals for
production databases in conjunction with data owners and department managers.
Work with application development staff to develop database architectures, coding
standards, and quality assurance policies and procedures. Perform database
transaction and security audits.
Installation/ configuration / maintenance /performance tuning of SQL Server
2000 and 2005 in both clustered and non clustered environments.
Support of larges database systems (36 servers 8 SQL 2005, 28 SQL 2000
servers). Maintaining/creating/monitoring all maintenance jobs, security needs,
connections, services, backups, performance, storage and server capacity
planning.
Monitor database system details within the database, including stored
procedures and execution time, and implement efficiency improvements.
Design and implement redundant systems, policies, and procedures for disaster
recovery and data archiving to ensure effective protection and integrity of data
assets.
Monitor, optimize and allocate physical data storage for database systems.
Plan and coordinate data migrations between systems.
Develop, implement, and maintain change control and testing processes for
modifications to databases.
Create, or support creation of, required reports in response to business user
needs.
Establish appropriate end-user database access control levels.
Develop routines for end-users to facilitate best practices database use.
Mobile, AL
ACO
Database Administrator
November 2005 June 2006 - (CONTRACT)
Key Accomplishments - Database documentation.
Responsible for conversion and installation of new client database conversion
to STAR Securites business model, an enterprise scale software solutions
servicing State financial regulatory agencies.
Developed data migration checklist and dynamic scripting of conversion
tasks.
Configuration and support of merge replication to remote clients.
Create, or support creation of, required reports in response to business user
needs of remote clients.
Design and implement redundant systems, policies, and procedures for disaster
recovery and data archiving to ensure effective protection and integrity of data
assets on local site to insure secure developing environment and code is archived
to source safe.
Testing and installation and support of STAR Securities databases to
Securities Regulatory agencies/clients in Alabama, Alaska, Arizona, Arkansas,
Illinois, Kentucky Massachusetts, Mississippi, Washington, West Virginia and
District of Columbia.
PHNS
Baton Rouge, LA
Senior Data Analyst
August 2004 - November 2005
Key Accomplishments - Conduct integrity audits for patient critical data.
Manage the acquisition, cleansing and quality assurance of client healthcare
data (patient critical SQL Data Warehouses for four hospitals - Baton Rouge
General Hospital, Lapeer Medical Center, McLaren Medical Center, Ingham Regional
Hospital).
Implementation and development of medical coding audit system for Detroit
Medical Center.
Developed archiving system for HL7 data received freeing up an estimated 120 GB
between database servers.
Maintain the quality of the data by performing validity checks using SQL
scripts to ensure integrity of data used throughout the business. Identifies data
issues and presents solutions to management.
Worked with data providers and internal staff to resolve data issues.
Process automation - development of data transformation rules, maintenance of
reference data, loading data files from external customers into an internal SQL
Data Warehouse.
Developed processing speed analysis features to include in web application.
Reduced HL7 data feed errors by 80% and replayed data feed into the databases
with minimal impact to client.
Played essential role in email notification system. Wrote custom email
procedures and data structure for email system for clustered SQL servers.
American Nursing Services Inc.
Metairie, LA
DBA/Developer
September 2003 - August 2004
Key Accomplishments - Application and database upgrades for Great Plains
accounting system and other internal applications. Gathered report
specifications and wrote all company reports using Seagate Crystal and TSQL.
Implemented advanced reporting methods using views and stored procedures with
Seagate Crystal.
Database creation, data base size estimation, performing physical and logical
design, and
database performance tuning.
Assess and documented company resources.
Documented and defined disaster recovery plan. · Migrated existing
database from MS SQL Server 7.0 to MS SQL Server 2000.
Conducted Server and Database consistency checks.
Developed ETL process, database and reports for an elaborate ACT! Contact
mailing event system.
Actively involved in system and user audits.
Ongoing maintenance and development of backend procedures, views, triggers,
indexes and application upgrades.
Developed ADO Client Server applications with SQL backend to automate business
systems.
Scheduling of tasks, monitoring of events, administering of MS-SQL Login
security.
Advanced reporting using views and stored procedures with Seagate Crystal.
Delta Add-Power Systems, Inc.
Metairie, LA
DBA, SQL Programming, Data Warehousing
November 2001 September 2003
Key Accomplishments - Provide guidance and documentation of project plans,
deliverables, research and analysis and presenting test case analysis.
MS SQL Server 7.0/6.5 installation, databases creation, performing physical
and logical design, disks space management and database tuning.
Involved in designing, testing, implementing and continuous monitoring of SQL
databases and systems.
Project Lead Developer for billing interface utilizing EDI/ANSI X12 HIPAA
compliant formats including ANSI 3051 and ANSI 4010 and remittance 835 payment
posting back to patient account in POS interface.
Extensive knowledge of any of the following ANSI X12 datasets: 835, 837,
HIPAA standard code sets and the HIPAA Transaction and Code Set regulations.
Experience in HL7 Implementation for Patient Demographic Information.
Designed and implemented database devices, objects and scripts developing
tables, indexes, stored procedures, views, triggers, default and alerts, jobs
ect.
Build schema files for ODBC connection to UNIX.
Provided DBA support to ADD-POWER clients.
Implement Data Warehouses to clients on Microsoft SQL 2000.
Determined requirements and established procedures for backup/recovery.
Managed server maintenance, manual and scheduled.
Performed complex data Conversions.
Performance Monitoring.
Implemented standard security server lockdown procedures.
Managed security including managing object and system privileges, granting,
revoking and displaying privileges.
Starwood Vacation Ownership
Orlando, FL
Systems Analyst / Solution Developer / Project Leader, SQL Programmer
June 2000 - September 2001
Key Accomplishments - Project lead for a complex accounting conversion from
Timberline on Unix/Data General System to Microsoft SQL Server 7 database.
Requirements gathering and validation of financial reports.
Meet with accountants to define the interface needs, specification.
Documented project requirements for all development phases.
Met all project timelines was awarded special recognition.
Created and managed database, stored procedures, DTS packages, tables,
triggers, indexes and all views, · SQL mail alerts, and job scheduling.
Designed database architecture detail transaction tables and stored
procedures to generate GL transactions for summarization and development of
SAP documents for export to SAP.
Designed database and stored procedures to generate GL transactions and
export to SAP Interface.
Developed complex financial reports with SQL views and Crystal Reports.
Macmillan Bloedel / Weyerhaeuser
Thomasville AL
Systems Analyst
August 1998 - May 2000
Key Accomplishments - Responsible for Business programs development in a
Manufacturing / Distribution related industry utilizing SQL Server 6.5, Business
Basic BBx, Power Builder and Microsoft Access in a HP3000 and Windows NT
Client/Server environment.
Project Applications Development and maintenance of Automated process
scheduling.
Responsible for database design and modifications using PL/SQL, report writing
with BBx and
Developed Crystal Reports for Peoplesoft accounting reports.
Performed Lead code review for Y2K project, including modifications, testing
and documentation of all site programs.
Awarded for project excellence with an error free transition into the year
2000.
The SSI Group
Programmer / Team Leader
October 1996 - December 1998
Key Accomplishments - Document coding changes and assist peers with efficientcy
processes.
Ongoing development in insurance billing application in accordance with ever
changing statandards distributed by NEIC, Medicare, Medicaid, BCBS and other
independent supported billing entities.
Experience with Microsoft FoxPro 4.0, Crystal Reports, Microsoft Access,
Windows NT Client/Server, PC Anywhere, and Microsoft Office.
Received every productivity awards given to our department for as long as
worked at The SSI Group and was promoted to a Team Leader among my peers
providing motivation and guidance on project direction, coding standards,
techniques and goal setting.
EDUCATION
Southeast College of Technology, Mobile, AL
Associates Degree in Computer Information Systems 1996 (4.0 GPA).
NATHS - National Association Technical Honor Society
Triple A Award - 4.0 GPA
Outstanding Student Award - Excellence in achievement and leadership
|
