Work Experience

Confidential

Senior Database Developer

• Working as the lead database consulting resource for two clients a large travel management company and a large insurance corporation
• Administering and providing 24 hour support for all SQL Server instances in the environment Versions 2008 R2 and 2012 , Responsibilities include: backup and restore, performance optimization, disaster recovery, database maintenance, replication, automating repetitive tasks, improving security, installations/upgrades.
• Implementing various SSIS packages in order to automate business processes.
• Developed over 100 distinct SQL Server Reporting Services reports with advanced T-SQL using Data Warehouse as the source.
• Configured SharePoint boxes serving as Business Intelligence portals.

Confidential

Senior Business Intelligence Solution Developer

• Architecting and implementing full life cycle business intelligence systems containing relational, dimensional, cube, ETL, transactional, and analytical reporting modules.
• Implemented SSRS reports, SSIS packages, Cognos reports, Cognos models, SSAS cube administration,

• Technology: Microsoft SQL Server 2008, SSIS, Analysis Services, Share Point Services, Reporting Services, Panorama, Cognos

Confidential

Business Intelligence Solution Developer

• Designed and implemented a large Enterprise Data Warehouse EDW solution running on SQL 2005 platform for a government client in Missouri.
• Created SQL Server 2005 SSIS packages using the latest Microsoft recommended methodologies.
• Created T-SQL stored procedures used by SSIS packages for populating the EDW, and for maintenance and optimization of database s .
• Implemented the reporting front-end using MS SharePoint 2003. Designed WSS sites using built-in and custom web parts.
• Creating reports using MS Reporting Services 2005.
• Building cubes using MS Analysis Services 2005, used as a source for all reporting needs.
• Documenting source to target mapping phase of the project.
• Using Erwin extensively for all database modeling needs, as well as forward and reverse engineering.

Confidential

Senior Data Warehouse/ETL Developer

• Working with a team of 4 professionals on implementing a Data Warehousing solution for a large insurance company.
• Developed a dimensional star schema model for the Data Warehouse containing 5 fact tables and over 30 dimensions.
• Developed all SQL queries for extracting data from 4 different relational databases used as sources for the Data Warehouse,
• Setting up standards for data validation, error handling, error logs and custom logs in DTS.
• In charge of database performance tuning, security, indexing strategies, disaster recovery plans, backup strategies, partitioning, etc.
• Interacting daily with upper management and business users on requirements gathering.
• Technologies used: MS SQL Server 2005, MS SQL Server 2000

Confidential

Lead SQL Server Database Administrator/Developer

• In charge of administering the complete SQL Server web hosting environment, consisting of 100 servers running versions SQL2000, SQL 7.0, and SQL 6.5 over 50,000 databases , installed on Windows 2003, Windows 2000, and NT.
• Served as the authority on all company wide, complex SQL Server issues 24/7.
• Implemented a completely customized remote backup solution written in T-SQL where all server s databases are backed up, zipped, and shipped to dedicated backup servers, and from there stored on tape. All activities are logged and tracked for future reference and monitoring.
• Designed and implemented the main customer and support ticket tracking system, running active/active 2 node SQL clustering solution, as well as several other clustered SQL installations.
• Was involved on several Data Warehousing projects with DW group, when my expertise was needed.
• Mentoring other junior and mid-level SQL Server administrators and support personnel.
• Documented a step-by-step disaster recovery plan.
• Developed the image used when deploying new SQL Server boxes online, making sure that each SQL Server instance is properly secured and customized for shared access by hundreds of different customers.
• Worked with other developers on building a complex web based real-time monitoring system which identifies at any time which SQL boxes are completely down, if all required services are running, and if backup jobs completed successfully.
• Providing last level support for customer issues not resolved by the first 3 tiers of support.
• Other responsibilities include: T-SQL stored procedures and triggers, managing SQL Server security, ASP scripting, Replication, Log Shipping, ETL DTS , shell scripting, IIS administration, Windows administration, Active Directory, recovering servers from different hardware failures.

Confidential

Senior SQL Server Database Administrator

• Hired as a lead contractor to improve performance of several OLAP and OLTP SQL 2000 databases with sizes ranging from 10GB to 1 TB.
• Managed a team of 4 SQL Server DBAs and developers
• Improved performance on long running batch jobs via indexing, creating DTS packages, daily maintenance plans and rewriting stored procedures.
• Placed Tempdb, database files, and database log files on a separate drives/controllers with appropriate RAID configurations, which minimized I/O decreasing CPU usage - all contributing to a 60 increase in performance.
• Created an automated backup procedure including disaster recovery.
• Created technical documentation, detailing future needs to improve performance.