Background Summary:

Project management/Technical Lead

Confidential

Responsible for establishing and managing the scope of remediation activities for the various clustered high availability data warehouse performance tuning technical tasks Responsible for creating and maintaining a plan for execution of the data warehouse performance tuning activities Managed offshore DBA team tasks and performance problem resolution. Managed 65 SQL Server database server/database migration to new data center vendor on both physical and virtual environments. Performed detailed database level planning and project creation for migration of 1000 databases and 25TB of data storage. Worked with Disaster recovery team to identify database LUNS required for EMC SAN SRDF replication. Determined RTO and RPO objective points to provide appropriate database SLA. Work closely with department heads as portions of the technical issues were shared inter-departmentally. In addition to building a close relationship I also defined the accountability resolutions to help long term problem solving pertaining to shared technical responsibilities. Focal point for all planning and execution activities for the technical environments involved. Accountable for the following tasks: Initial project planning, Development of project scope, Defining project guidelines, Resource coordination internal and contracted , Testing coordination. Manage project plans and project resource requirements and budget

Senior Database Architect

Confidential

Develop database solutions by designing proposed system defining database physical structure and functional capabilities, security, back-up, and recovery specifications. Gathered business requirements and convert to logical/physical data model. Test data model with developers and business. Develop recommendations for architecture. Perform capacity planning to determine physical database structure to anticipate performance bottlenecks.

Senior Performance Tuning Consultant

Confidential

Responsible for performance tuning and optimization of SQL Server databases, deployment of SQL Server 2000/2005/2008/2008R2/2012 running on Windows platforms. Provide consulting on performance tuning and troubleshooting, application workload testing, integration, data migration and general problem solving. Architect and implement backup and disaster recovery solutions including SQL Server mirroring/replication/Always On/SRDF.

Senior Database Administrator

Confidential

Responsible for administering, performance tuning and optimization SQL Server , deployment of SQL Server databases Analysis services SSAS databases AWS cloud based SQL Server range in size from 100 GB to 10 TB. The concurrent user count ranges from 50 to 50,000 users web users con-current . The systemsInfrastructure that these databases operate on range from stand-alone systems clustered systems My experiences include architectures such as ERP, Data Warehousing, OLAP, OLTP and Replication solutions. My experiences include network and attached disk array configuration and utilization.

BIG DATA Business Intelligence Architect Administrator

Confidential

Business Intelligence BI /Online Analytical Processing OLAP interactively analyze multidimensional data roll-up, drill-down, data slicing Cluster Analysis Data Mining Predictive Modeling NoSQL Database Big Data Strategies - Performance Management non-transactional, social data , Data Exploration, Social Analytics non-transactional, social data , Decision Science MongoDB DBA MongoDB clusters, Mongodb sharding, Mongodb partitioning. Implemented SQL Server SSRS,SSAS,SSIS as a Business Intelligence BIDW suite implementation for data warehouse using MS Visual Studio.Implemented SSIS for ETL data extraction and conversion for a model conversion. Created SSRS reports, migrated SSRS farm/reports to new data center servers. Directed data center DBAs on all migration tasks for SSIS and SSRS. Created migration process for SSRS and SSIS components from stage to production. Created disaster recovery process for SSRS/SSIS. Modified/created SSRS and SSIS objects per business end user requirements.

TECHNICAL SKILLS QUALIFICATION SUMMARY:

Database

• SQL Server 2000/2005/2008/2008R2/2012, Mongodb
• SQL Server SSRS, SSAS SSIS, Database
• Clustering Log Shipping, Data Mirroring,
• Replication , SAN Storage Technologies.
• Database Design and Administration - SQL Server v6, v7,
• 2000, 2005, 2008, 2008r2, 2012 MySQL, MongoDB, Access
• Database Design, Data Maintenance, Database
• Security, Database Management, Requirements
• Analysis, Teamwork, Technical Zeal, Project
• Management, Presenting Technical Information,
• Training , Operating Systems
• SQL Server DBA v6, v7, v2000, v2005, v2008,
• v2008r2, v2012 Windows designs,
• Implementations and performance tuning, Mirroring, Always On
• Staff and Budget Management Management of
• Technical Resources up to 50 on-shore off-shore
• in all. Departmental Budget and Project Budget
• Management for hardware and staffing
• requirements.
• Project Management Project Managed via
• software manager, Team Lead, Technical Lead,
• Resource Management and Project Development
• Big Data Technology MongoDB MongoDB sharding, MongoDB clusters, MongoDB replication Relational, hierarchical and graph
• databases, distributed data file systems, data