TECHNICAL SKILLS

• Confidential SQL Server 6.5 | 7.0 | 2000 | 2005 | 2008 | 2008R2 | 2012 | 2014 | 2016
• Cloud Technologies Confidential Azure, Confidential AWS
• High Availability Clustering, Always - on, Database Mirroring, Log Shipping
• Data Security, Auditing, Encryption, Configuration Management, Data Virtualization
• Data Warehousing Design, Implementation and Administration
• Disaster Recovery, Data Recovery, Point-in-Time Recovery, Partitioning
• Business Intelligence Design, Implementation and Development
• Domain Knowledge Management, Master Data Services, Data Quality Services
• Enterprise Architecture, Data Modeling
• Data Administration, Performance Optimization, Scalability, Online Operations, Integration
• Business Analytics, Real-time Operational Analytics, Power BI, SSAS MDM, SSAS Tabular

PROFESSIONAL EXPERIENCE

Confidential

Team Lead

Responsibilities:

• Lead Confidential DBA for infrastructure, strategic planning, production, integration, architecture, and mentoring supporting multiple lines-of-service including transactional, data warehousing, cloud technology and analytics providing enterprise data services to all Baltimore County Government Entities.
• Senior Confidential database technologies consultant for the strategic planning and optimization for all transactional and analytical database services for the Maryland Department of Transportation (MDOT) surveillance and regulation data center.

Confidential

Senior SQL Server DBA

Responsibilities:

• Senior Confidential SQL Server DBA for the global enterprise hosted analytics, operations, research & development and strategic planning division of Blackboard, Inc. providing business intelligence and analytical solutions to educational facilities worldwide.
• Responsibilities involve provisioning, maintenance, security, optimization, analytics, best practice, research & development and DevOps support for over 200 globally dispersed Confidential SQL Server databases, analytical and reporting environments.
• Extensive work in design, architecture, implementation of Confidential SQL Server in large scale environment.
• Provided migration and support for AWS, Pyramid and complex proprietary analytical systems.
• Available 24X7 for analytics client issue resolution.

Confidential

Senior DBA

Responsibilities:

• Senior SQL Server DBA responsible for Enterprise Operations worldwide for Confidential database technologies providing 24x7 on-call production support, a wide variety of development efforts, strategic planning and mentoring.
• Responsibilities include a wide variety of production, development and mentoring activities including:
• High Availability implementation and maintenance of over 20 two-node and multi-node SQL Server Clusters.
• Performance optimization and troubleshooting for multiple applications production and development teams.
• Database support of multiple large SharePoint farms.
• HA, DR and optimization support of over 200 SQL Server 2000, SQL Server 2005, SQL Server 2008 and SQL Server 2012 instances hosting over 900 databases.
• SME Engineer for Confidential technologies strategic planning, research and development, security, industry best practice, standardization and optimization.
• Enterprise mentor to team of DBAs, messaging services, network, systems application teams and offshore resources.
• SME for business acquisitions integration to Confidential corporate central data repository and standards.
• Provided integration with Oracle multi-terabyte data warehouse as well as Confidential, Confidential, Confidential, Confidential, Confidential and Confidential data into the Confidential database platform.
• Interfaced directly with the CIO, Departmental Managers and Directors in a variety of efforts including acquisitions support.
• Consolidation of hundreds of Confidential Access, Excel and flat file data to a centralized Confidential Database repository.
• Consolidation of physical database servers into the Enterprise Virtual server environment.
• Developed enterprise auditing, policy and alerting systems and support.
• Administration and integration of large enterprise Confidential SharePoint Server 2005/MOSS/2013 clustered environment and corresponding unstructured document methodologies including management of full-text indexes.
• Provided high availability solutions including clustering, log shipping, replication, snapshots, database mirroring and custom HA solutions.
• Provided disaster recovery design and implementation including SAN storage optimal configuration and distributed partitioning.
• Construction and administration of SQL Server environments within a multi-domain enterprise that includes configurations for development, user acceptance testing, functional testing, load testing, prototyping, and production.
• Implemented advanced security techniques including auditing, accountability, compliance and encryption.
• Served as Corporate Confidential database technology SME working closely with large and diverse offshore development teams on complex projects.
• Provided technology and associated process solutions for international globalization efforts including multi-language support, international synchronization of data, spread processing and financial forecasting.
• Confidential Business Intelligence technical engineer tasked with integrating existing Oracle and Informatica data warehouse to Confidential Business Intelligence platform establishing a comprehensive multidimensional analysis infrastructure.
• Confidential technology SME for the Data Governance Service Group developing business requirements, functional documentation and associated logical and physical process diagrams, project plans and supporting technical methodology leveraging UML, RUP, Inmon and the Zachman Framework.
• Provided educational seminars to technical and business teams instructing users on efficient data consumption using Confidential front office tools capabilities and Business Intelligence techniques.
• Established configuration management and technology process infrastructure to align business requirements with their corresponding supporting technologies, best practice and data flow procedures.
• Supported extensive development environments using Confidential Team Foundation Server, Confidential Performance Point Server, Visual Studio 2005/2008/2010, Confidential SharePoint and MOSS technologies.
• Development of SQL Server 2012 Business Intelligence platform enterprise prototypes for Master Data Services, Data Quality Services, Data Integration Services, Excel Power Pivot Services, Columnstore Indexing, Azure SQL Database, Power View, Tabular Models, Multidimensional Models, AlwaysOn HA, Snapshots to Azure, Data Warehouse Partitioning, security auditing, Filestream and BI Semantic Models.

Confidential

Senior DBA

Responsibilities:

• Senior SQL Server DBA responsible for maintaining all corporate databases including case, utilization, maternity and disease management data. Developed UML/CASE solutions including data/business mapping, use case and what-if scenarios.
• Provided configuration management (CM) infrastructure, tools, processes, client data acquisition, parsing and analysis.
• Lead for strategic planning for integration of third party health care management applications and data collection tools.
• Provided Standard Operating Procedures (SOP) and procedural documentation in accordance with the Confidential Operations Framework (MOF) and best practices.
• Production DBA responsible for optimization, capacity planning, indexing, partitioning and database OLTP/OLAP design.
• Provided extensive documentation, technical and business analysis to senior corporate management.

Confidential

Senior SQL Server Production DBA / Lead for Strategic Planning

Responsibilities:

• Senior SQL Server DBA for the CMS SQL Server Enterprise facility
• Responsibilities include optimization, security, development support, hardware, patches, upgrades, and capacity planning.
• Lead for strategic planning for the SQL Server enterprise, interfacing with clients as well as presenting reports, and new methodologies to senior HHS management and establishing standards, procedures and protocols for the SQL Server enterprise.

Confidential

Senior Computer S cientist

Responsibilities:

• Lead technical engineer for the Confidential Department of State Confidential Processing Center ( Confidential ) data processing center.
• Responsible for support of Worldwide Confidential Admissions Program (WRAPS) data, process and security.
• Confidential gathers all pertinent information for the processing of Confidential admissions to the U.S. extracted from replicated data from diverse worldwide locations.
• Data is comprised of biodata, photos, fingerprints, scanned documents and all related data required from the Confidential Department of Population, Refugees and Migration (PRM).
• Lead engineer for data architecture, data engineering and database administration for the Overseas Processing Entities (OPE) centers.
• Responsible for data integrity, security, stability, optimization, reliability and integration throughout the enterprise, including testing and system integrity, analysis and selection of hardware and data space requirements, database performance and index tuning.
• Senior Data Engineer for the design and implementation of distributed federated data, design of redundant systems architecture, optimization of hardware, queries and reports, distributed partitioned data, transactional replication as well as developing applications for the administration and efficient access of central repository data and metadata.
• Part of a senior team responsible for the transition to Windows 2003 and SQL 2000 data environment and the involved data migration involved.
• Database manager responsible for a team comprised of senior engineers for data modeling, architecture and administration.
• Integration with senior U.S. State Department officials including providing support to other U.S. agencies such as the Department of Confidential ( Confidential ), Confidential ( Confidential ), Confidential ( Confidential ) and others, providing integration of WRAPS data with said agencies' data requests.
• Responsible for providing pertinent data to central processing center data analysts, designers and programmers as well as providing solutions for systems engineers around the world involved with the WRAPS program.
• Responsible for daily production DBA duties, data analysis, reports to senior management, project scheduling, accountability and proactive solutions at the Confidential and at all Overseas Processing Centers (OPE) worldwide.