Moses Patrick Email & Phone Number

• Provide primary lead support for the USMS SQL Server• Install SQL Server, design, create, code, manage, and support all databases in both virtual and Physical environments, clustered and non-clustered Servers• Design, develop, implement, administer and provide support for all MS SQL Servers including clustered instances• Design, develop, generate, and administer reports using SSRS for Helpdesk Tickets status reports, CITRIX reports, ACD reports from the customer Telephone system, ad hoc or on-demand reports using T-SQL, excel, MS Access, etc. • Provide administration and tier one support for HEAT/REMEDY Ticketing System• Provide SharePoint databases expertise and support. • Configured database encryption on all SharePoint Databases• Provide BES database support and develop reports using SQL Server Reporting Services (SSRS)• Support complex database systems• Design ETL processes using SSIS to consolidate heterogeneous data from disparate sources• Develop technical specifications to meet system functions and user requirements• T-SQL coding, documentation, system performance and optimization• Perform development testing, conversion, implementation, tuning and capacity planning• Provide Disaster Recovery, High Availability, and Backup solutions• Provide monthly customer on-site and remote maintenance support.• Configured and implement SQL Server backups to Avamar data domain using Avamar backup client and DDBoost for SQL Server.• Built and configured master data services webs service and database, built MDS websites using IIS.• Successfully migrated Oracle database using Microsoft SQL Server Migration tool.• Proficient knowledge of windows operating system.• Proficient knowledge of Active directory• Build and configured RDS SQL Server instances and created C-name Alias in DNS• Migrated SQL Server 2012/2014 and 2016 databases from on-prem to RDS instance on AWS• Converted and migrated Oracle databases to SQL Server instance

• Provide primary lead support for the USMS SQL Server• Install SQL Server, design, create, code, manage, and support all databases in both virtual and Physical environments; clustered and non-clustered Servers• Design, develop, implement, administer and provide support for all MS SQL Servers including clustered instances• Design, develop, generate, and administer reports using SSRS for Helpdesk Tickets status reports, CITRIX reports, ACD reports from the customer Telephone system, ad hoc or on-demand reports using T-SQL, excel, MS Access, etc. • Provide administration and tier one support for HEAT/REMEDY Ticketing System• Provide SharePoint databases expertise and support. • Configured database encryption on all SharePoint Databases• Provide BES database support and develop reports using SQL Server Reporting Services (SSRS)• Support complex database systems• Design ETL processes using SSIS to consolidate heterogeneous data from disparate sources• Develop technical specifications to meet system functions and user requirements• T-SQL coding, documentation, system performance and optimization• Perform development testing, conversion, implementation, tuning and capacity planning• Provide Disaster Recovery, High Availability, and Backup solutions• Provide monthly customer on-site and remote maintenance support.• Configured and implement SQL Server backups to Avamar data domain using Avamar backup client and DDBoost for SQL Server.• Proficient knowledge of windows operating system.• Proficient knowledge of Active directory

• Provide primary lead support for the GAO SQL Server, MYSQL environments and support GAO Oracle environment.• Support quarterly consolidated reporting for the GAO Oracle and SQL Server environments• Database Operations Support• On-Call Support• Physical Database Design• Physical Database Implementation• Database Inventory• Security and Access Standards• Database Backup and Recovery• Continuity of Operations• Database Monitoring• Database Notification• Database Maintenance• Critical Patch Updates• Database Change Management• Database Password Maintenance

• Resolve database performance and capacity issues• Design, Schedule, Implement, and perform regular database backup and maintenance• procedures.• Provide database design assistance for the development of custom applications.• Utilize SQL experience to provide adhoc reports to respond to immediate business needs• Use existing reporting applications to deliver standard reports for global consumption• Implementing business needs using business intelligence design studio (BIDS)• Ensure all scripts for the entire database are in a source control.• Develop operational procedures.• Move new database designs toward an Enterprise Data Management Solution• Other duties as assigned

• As a SQL Server DBA he supported remote production and development servers, clustered/non clustered environment. • Update user records, update employee profiles, add vendors, update vendors, process de-obligations (refunds) etc. • Use SQL Query Analyzer to update or create.• Performed DBMS maintenance, backup and recovery.• Implemented, configured, administered replication and log shipping. • Designed Report in SQL Server Reporting Services and used Reporting Services to search for the SQL Server Log.• Conduct performance monitoring and tuning, implemented performance improvements of database instance/environment.

Master Certificate, Information Technology

Bachelor Of Science (Bsc), Computer Science