Database Administrator Resume Profile
NJ
Summary:
- 20 Years of Information Technology experience with Database Administration, Development and Design, Application Development, Integration, Data Warehousing and Reporting, and Trouble shooting.
- 15 years of MS SQL Server DBA experience using Microsoft SQL Server versions 2012, 2008, 2005, 2000, 7.0 and 6.x, 2.x, 1.x and its technologies
- 10 years of Sybase Server DBA experience using Sybase Server versions 13.x, 11.x, 4.92 and its technologies
- 12 Years of Team Leader experience.
- 4 Years of Microsoft SQL Server 2012, 2008 Integration Services SSIS , Reporting Services SSRS and Analysis Services SSAS experience.
- SQL Server High Availability using Microsoft Clustering, Log Shipping, Replication experience
- Expertise in Data Modeling, Database Design with Erwin, Database Programming, ETL Development
- Experience in Microsoft .NET Technologies
- Strong Troubleshooting Skills and Performance Tuning experience
- Strong experience in 3-Tier Web environment.
Work Experience:
Confidential
BI Technical Manager / DBA |
- Stabilized TM1 Server Environment
- Coordinated Modification for overhaul on Planning System
- Managed development, test, and production environments
- Database Lead on Data Warehouse project using MS SQL 2008
- Built several custom integration applications between Tm1 / Peoplesoft
- Modeled System using Erwin 7.3 and profiler
- Configured hardware for Development/Testing/Production Environment Dell
- Recommended server and database maintenance plans
Confidential
Lead Database Administrator |
- Developed Reltima's Teluware a real-time Vehicle/Fleet tracking and management system.
- Provided 24/7 production support for multiple MS SQL Servers
- Built grass roots system
- Managed development, test, and production environments
Environment: SQL Server 2005/2000/7.0, SSRS, SSAS, SSIS, Windows 2003, 2000, Erwin 7.1.2
Confidential
Lead Database Administrator |
- Discrete Wireless is a market leader in Fleet/Vehicle Tracking system headquartered in Atlanta, Georgia.
- Lead DBA for the SQL DBA team supporting SQL Server systems of the organization in dire need of repair
- Providing 24/7 production support for 8 MS SQL Servers located in multiple locations
Environment: SQL Server 2005/2000, SSRS, SSAS, SSIS, Windows 2003, 2000, 3- Tier Web Infrastructure, Erwin 3.5.2
Confidential
Database Administrator / Designer |
|
Environment: Sybase 11.5, Unix, Windows 2000, Erwin 3.5.2
Confidential
Owner, Database Administrator, Modeler, Team Lead |
- Provided consulting services developing, trouble-shooting and tuning intricate relational applications. Annual revenues exceeded 400,000. Became a Microsoft Solution provider. Designed state-of-the-art, real-time, trading application for Exxon International. Recruited employees directly from MIT. Trained employees in database, network and programming. Worked with dozens of clients some highlights included.
- Designed Erwin relational model for Dow Jones News Wire billing system. Developed a calculation engine for system that was 100 accurate in performing bill computations on a relational basis via stored procedures. Provided triggers with imports to AR, GL and bill hardcopy production and reporting interfaces. Supported thousands of billing scenarios with volumetric pricing and corrections on a prorated basis. System was completed on time and under budget.
- Revamped a competitor's failed relational model for SeaLand's terminal automation system TAS . Unified association entities by generalizing the model. Reduced the number of tables in their original model from over 400 to 70. Created workflow templates that portrayed every work combination possible. Reduced query time in locating a single container from 20 minutes to less than a second. Enhanced numerous security, integrity, performance and recovery features. Average truck turn-around time was reduced by 66 or 4 hours per container . This story was published in Sybase magazine 1994
- Resolved problem with data synchronicity, which plagued Hong Kong port operations. Monitored database conversations seamlessly and in real-time, acquiring and providing container location information to expert parking and DB2 legacy system using Open Data Services SDK . First version remained viable throughout development and deployment process. Received Microsoft's Application of the Year award in 1994.
Confidential
Designed, developed and deployed multi-dimensional supply vs. demand model for worldwide hydrocarbon production inventory balance in TM1 and product-pricing data warehouse. Automatically captured and stored crude price data, production and consumptions accruals and estimates for company and industry operations worldwide for multiple time frames. Over 60 analysts and managers utilized system and success spearheaded future client / server development efforts.