Senior Database Engineer Resume
Sarasota, FL
PROFESSIONAL SUMMARY:
- A Professional with experience in multiple areas of technology including project management, database architecture, application development, application integration and business solution management. Excellent customer service relations and support personality. Highly motivated leader who enjoys the challenge of Information Technology.
TECHNICAL SKILLS:
Programming: C#,TSQL, CLR functions, MS SQL Sever (6.5, 2000,2005,2008,12), MySql, MSMQ, COM+, Microsoft Access, Oracle (6i, 8i), Informix, Lotus Script, C, VB (5, 6.Net), ASP, ASP.NET,LINQ, SSIS, DTS, Html, XML, XSLT,DDL, DML, SMTP, SQL, OHM,VPL,Jquery,PHP,Perl,Python,Apex VisualForce,Salesforce WebService, SOQL
Environment: s:Windows (7,8, Server), IIS6.0/7.0, Microsoft. NET Framework (2.0, 3.5, 4), UNIX Solaris,Linux OSX, ArcGIS, Microsoft search APISoftware:VS 6.0, VS . NET, Crystal Reports, Lotus Notes, ARC Info, Microsoft Office, FrontPage, Toad, Erwin DataModeler r7.3Discipline Application Architecture, Database Architecture, Database Scrubbing, Enterprise Problem Resolution Basic Research, Data Analysis, Reporting Practices, Floor Presentation, GIS, Tax and Financial data integration, Legal data integration. Operations Migration
PROFESSIONAL EXPERIENCE:
Confidential, Sarasota, FL
Senior Database Engineer
Responsibilities:
- Salesforce Public Site Creation with Custom Object, Apex Class and VisualForce page implementation.
- Architected CONQ Dashboard solution with data integration from JIRA
- Created views, stored procedures/functions, indexes to support development project
- Re architected the database xml access layer for better performance.
- Integrated NetSuite ERP Data via .NET and PHP web services
- MYSQL DBA for medical simulation software.
- Salesforce Web Service .NET Integration.
- Digital Document Management via SQL Server Full text search, CLR, and, IFilter implementation (PDF,EML,HTML)
- Backup and Recovery for Production Servers
Confidential
Consultant PHP & SQL Developer
Responsibilities:
- Extended the open source archival application ARCHON with html json endpoints to enable a migration path to be established with the application’s Mysql Database.
Confidential, Saint Petersburg, FL
Development Team Lead, Senior Developer/DBA
Responsibilities:
- Managed the Development Group daily activites and Software Releases.
- Migrated DB from Mysql to MSSQL 2008
- Converted PHP/CGI Webste database layer from MySql to MSSQL
- Migrated 30 databases to Rackspace environment.
- Migrated Company Client Websites to Rackspace environment.
- Implemented Complete redundant operations disaster recovery Rackspace site with snycronous replication and DB log shipping
- Updated existing Asp.Net Web sites per client request
- Programming VB.net/C# components with access to DB with through stored procedures
- Created stored procedures and TSQL from design to implementation
- Business analysis and requirements documentation
- Coordinated Quality Assurance team priorty assignments
Confidential, Sarasota, FL
Senior Consultant Data Architect/Application Developer (Criminal Data Integration)
Responsibilities:
- Designing data model schema and logical layout
- Programming C# components with linq to consume Html, PDF and XML
- Created stored procedures and TSQL from design to implementation
- Business analysis and project plan documentation
- Dimensional modeling for data warehouse
- Quality Assurance by means of testing
Confidential, Sarasota, FL
Senior Consultant Application Developer
Responsibilities:
- Programming C# components to consume XML data files to provide audit capability
- Complete SDLC procedure from design to implementation
- Business analysis and project plan documentation
- Report Writing of Tax Active reports against SQL2005 Databases
- Created Microsoft Access Database for Audit results
- Programmatically loaded Microsoft Access tables from XML
- Programming custom data transfer applications for specific clients needs
- Technical support of several fortune 500 enterprise level clients
- Redesigning application validation modules from a C++ architecture to a VB, XML based architecture.
- On site custom data integration application implementation.
- Documenting and correcting application problems and support issues dealing with data.
- Maintained Microsoft Access databases responsible for financial meta Data
Confidential, Sarasota, FL
Project Manager/Senior IT Analyst G13 (HR, Finance, Risk Management and Fixed Assets)
Responsibilities:
- Programming Multiple Visual Basic Active X Scripts and Store Procedures within DTS packages on a MSSQL2000 Server to migrate the Sarasota County HR Benefits database to newly designed database architecture
- Programming multiple custom MSSQL2000 database scripts to satisfy external partner data schema requirements for insurance and financial reporting
- Analyzing new and old technology, HTML, Visual Basic, Microsoft Access, Tango and Crystal Reports
- Documenting and Correcting many application problems and support issues
- Mentoring and instructing several employees to understand multiple challenging technical issues
- Assisting in the implementation of an enterprise wide data center transfer
- Enhancing multiple Microsoft Access applications to increase the overall efficiency of the HR and Finance divisions of Confidential
Confidential, Sarasota, FL
SQL Developer /Data Analyst - Independent Consultant (Spherion)
Responsibilities:
- As Project Manager I organized the scope and timeline of the project.
- As The Business Analyst I researched the and documented the all the system constraints and processes
- As The Developer I programmed and documented the Visual Basic Active X Scripts, and SQL Scripts and Stored Procedures within SQL Server 2000 DTS
- Analyzed the database schema to determine relationships
- Gathered requirements for finding the resolution to all known issues
- Created and optimized SQL queries for database clean up
- Tested clean up queries and sampled data to test queries
- Created a VBA Reporting tool in Excel to monitor and delivered reports on the database tables
Confidential, Bradenton, FL
SQL Developer /Data Analyst- Independent Consultant
Responsibilities:
- Gathered requirements for the reports
- Analyzed the database schema to determine relationships
- Created and optimized SQL queries
- Extracted sample data to test queries
- Delivered Reports in the form of database tables
Confidential, Sarasota, FL
Application Developer
Responsibilities:
- Maintained existing 30,000 lines of Stored Procedures SQL and Visual Basic code
- Implemented new stored procedures and COM components
- Altered database structure to coincide with enhanced code
- Oversaw the deployment of new client and backend components
- Converted SQL Server 6.5 database to SQL Server 2000 database
- Provided 3rd level customer support for the application
- Managed logins and application rights
- Implemented new VBA Scripts
- Maintained SQL Server 6.5
- Provided 3rd level customer support for the application
Confidential, Boca Raton, FL
Information Associate
Responsibilities:
- Gathered requirements from the client
- Created business and technical designs
- Coded and integrated new enhancements into existing system
- Programmed SQL statements to support the Visual Basic data requirements
- Implemented REM 2.5 requirements by programming VBA and SQL code
- Subjected those enhancements to unit test and system test for verification of error free functionality
- Produced a Defect Report if errors were found
- Implemented resolutions for discovered defects
- Subjected system enhancements to retest
- Created unit tests and System test plans which were included in the IPM2.2 standard documents
- Assisted in the collection and documentation of Metrics using the IPM2.2 process for the REM-VANTIVE 2.5 project
- Reviewed Microsoft Access databases for the Y2K problem
- Developed fixes for those problems
- Implemented all changes for that database
- Assisted in the Metrics IPM process for the Microsoft Access project
Confidential, Knoxville, TN
GIS Technician
Responsibilities:
- Held the positions of Computer Specialist and GIS Technician.
- Used Arc Info in a Unix environment to digitize coal mine coverages in a Geological Information System
Confidential, Knoxville, TN
Assistant Information Engineer
Responsibilities:
- Developed a sample software package in Microsoft Access using the Micah Information Engineering Methodology which consisted of Jade Sessions, Data Modeling, and Demo Development