Senior SQL Server Architect & Database Engineer

MOSES PATRICK

Senior SQL Server Architect & Database Engineer

Laurel, Maryland, 20707 240-***-****

https://www.linkedin.com/in/moses-patrick-669a1715 Clearance: Top Secret

PROFESSIONAL SUMMARY

Accomplished Senior Database Architect with over 23 years of experience specializing in high-availability (HA) infrastructure, multi-subnet clustering, and enterprise cloud migrations for federal agencies (USMS, GAO). Expert in stabilizing large-scale environments, managing over 1,500+ databases, and implementing robust Disaster Recovery (DR) via Avamar and AWS. Proven track record of delivering 99.99% uptime for mission-critical systems through proactive performance tuning, T-SQL optimization, and advanced security hardening.

TECHNICAL SKILLS PROFILE

Databases: SQL Server (2022/2019/2016 & Legacy), Oracle 10g, PostgreSQL, MySQL, MS Access

Cloud & DevOps: AWS (EC2, Athena, Data Lake), AWS DevOps, Cloud Migration

High Availability: Windows Failover Clustering (Multi-subnet), Mirroring, Always On Availability Groups

BI & Reporting: SSIS, SSRS, SSAS, Crystal Reports, Informatica, Power BI

Backup & DR: Avamar, DDBoost for SQL Server, RMAN, Continuity of Operations (COOP)

Security & Monitoring: ArcSight, SPLUNK, Database Encryption (TDE), OEM, AWR, ADDM

Languages: T-SQL, PL/SQL, PowerShell, SQL, Command Line Tools

PROFESSIONAL EXPERIENCE

Strategic Intelligence Technologies (US Marshal Services) Crystal City, VA

Senior SQL Server Engineer December 2017 – Present

Enterprise Cluster Architecture: Designed and deployed a high-availability 3-node multi-subnet Windows Failover Cluster; successfully migrated 13 mission-critical database applications and 1,500+ databases with zero downtime.

Cloud Modernization: Orchestrated the migration and configuration of SQL Server instances within AWS, leveraging AWS DevOps, Athena, and Data Lake to modernize USMS data accessibility.

Business Continuity & DR: Engineered enterprise backup solutions using Avamar and DDBoost, ensuring 100% recoverability for both physical and virtual clustered environments.

Security & Compliance: Hardened the database environment by configuring Transparent Data Encryption (TDE) on SharePoint databases and integrating audit logs with ArcSight and SPLUNK for real-time monitoring.

Performance Optimization: Led T-SQL code reviews, system tuning, and capacity planning to stabilize the USMS SQL Enterprise, resulting in near-zero unplanned downtime.

ETL & Reporting: Developed complex ETL pipelines via SSIS to consolidate data from disparate sources and designed automated performance dashboards using SSRS and T-SQL.

Intelligent Decisions (US Marshal Services) Crystal City, VA

Senior Database Administrator January 2014 – December 2017

Legacy Modernization: Led the in-place upgrade of all SQL Server 2008 R2 instances to 2012 R2 across Dev, Test, and Production environments.

Disaster Recovery: Configured disaster recovery solutions between untrusted SQL Server domains for the USMS and DEA (OFDT) using database mirroring for 65+ production databases.

Infrastructure Migration: Migrated enterprise databases from Virtualized SQL Server Clusters to Physical SQL Server Clusters to improve hardware resource allocation and performance.

Systems Integration: Provided Tier 1 administration and support for HEAT/REMEDY Ticketing Systems and SharePoint database expertise.

SRA International (USGAO) Washington, D.C.

Senior Database Administrator (Oracle, SQL Server & MySQL) March 2011 – January 2014

Multi-Platform Support: Provided primary lead support for GAO SQL Server and MySQL environments while assisting with Oracle environment maintenance.

Operational Integrity: Managed physical database design, implementation, and inventory for consolidated reporting.

Compliance: Executed security and access standards, critical patch updates (CPU), and database password maintenance in alignment with GAO security protocols.

PAE, A Lockheed Martin Company Washington, D.C.

Senior Database Administrator & Configuration Manager September 2010 – February 2011

Source Control & Lifecycle: Established source control protocols for all database scripts and developed standardized operational procedures to move custom database designs toward an Enterprise Data Management Solution.

Business Intelligence: Utilized Business Intelligence Development Studio (BIDS) and SQL to design standard reports for global consumption and ad-hoc business intelligence needs.

Infrastructure Maintenance: Managed end-to-end database maintenance, including performance tuning, capacity planning, and scheduled backup implementations.

National Institute of Health Training Center (WSDD) Bethesda, MD

SQL Server DBA & LMS Project Administrator April 2010 – August 2010

High Availability: Implemented and administered replication and log shipping across remote production and development servers in both clustered and non-clustered environments.

Reporting & Monitoring: Designed specialized reports in SSRS to monitor SQL Server Logs and conducted proactive performance tuning to improve environment stability.

Data Administration: Managed Learning Management System (LMS) records, performing complex data updates and integrity checks via SQL Query Analyzer.

United States Patent and Trademark Office (USPTO) Alexandria, VA

Senior Oracle 10g Database Administrator March 2005 – March 2010

Massive Scale Management: Managed 650+ Oracle 10g databases across 400+ Windows, Linux, and Unix servers, overseeing a total data footprint exceeding 5,000GB (5TB).

Disaster Recovery: Spearheaded backup and recovery operations using RMAN and established periodical restoration testing to ensure 100% data availability.

Performance Engineering: Optimized high-volume instances using Explain Plan, hints, Enterprise Manager, and TOAD; implemented materialized views to enhance query speeds for end-users.

Lifecycle Management: Led the installation, patching, and upgrading of Oracle products and managed capacity planning for system growth.

24/7 Production Support: Provided round-the-clock on-call support for a massive-scale production environment, ensuring zero-loss integrity for federal patent data.

Mobil Communications Laurel, MD

SQL Server Database Administrator February 2002 – February 2005

Early DBA Operations: Managed remote production servers, implementing log shipping and replication for early SQL Server environments.

Cross-Platform Reporting: Designed automated reports connecting Excel and MS Access via ODBC to extract real-time data from SQL Server.

SharePoint Administration: Administered SharePoint server environments, managing user access, meeting documentation, and collaborative data workflows.

PROFESSIONAL CERTIFICATIONS

AWS: AWS Certified Data Architect

Microsoft: MCTS – SQL Server 2008 Implementation and Maintenance

Oracle: Master Certificate, Oracle 10g Database Administration

Virtualization: VCA – Datacenter Virtualization (VMware)

IT Governance: ITIL V3 Foundation

General: Certified Microsoft Office User

EDUCATION

Bachelor of Science in Computer Science

oUniversity of Benin

Contact this candidate