Robert Carlton Email and Phone Number

• Perform SQL Server installations for enterprise production environment, including capacity planning, installation, upgrades, configuration, patching, backups, restores, and all functions to provide high availability, high performance, and high security.• Configure and manage mission critical High Availability AlwaysOn environments that host the Virtual desktop infrastructure databases. • Migrate SQL server 2008R2/2012 to new SQL 2016/2019 Azure IaaS servers.• Assist various development teams in designing database tables and structures, T-SQL stored procedures, and writing and optimizing SQL statements.• Troubleshoot stored procedures and functions not returning the expected data or causing jobs not to complete in specified time frame. • Resolve trouble tickets within agreed Service Level Agreements for all database services across multiple environments (e.g., DEV/QA/UAT/PROD)• Provide mentorship (Hierarchical or Lateral) to junior associates• Install IBM DB2 on a Windows server and migrate enterprise database from version 9.7 to 11.1• Configure and manage DB2 replication between mainframe and DB2 database• Provide ongoing DB2 support for the application team with stored procedures, data dumps and ad-hoc reports• Continuously migrate and manage up to 8 TB of production data between environments.• Monitor and maintain security configuration settings and system modifications to ensure compliance with Information Assurance Vulnerability Alert (IAVA) mitigation actions, Security Technical Implementation Guide (STIG) guidance. • Consistently receive recognition from the Government SQL Server Section Chief for outstanding support and troubleshooting expertise.

• Database Administrator for SQL Server installations for enterprise production environment, including capacity planning, installation, upgrades, configuration, patching, and all functions to provide high availability, high performance, and high security.• Configure and manage 6 mission critical High Availability AlwaysOn environments that host the Virtual desktop infrastructure databases. • Migrate SQL server 2008R2/2012 to new SQL 2016/2019 Azure IaaS servers.• Continuously migrate and manage up to 8 TB of production data between environments.• Prepare documentation and participate in the Command Cyber Readiness Inspections (CCRI) for the SQL Server Instance and SQL Server Databases.• Monitor and maintain security configuration settings and system modifications to ensure compliance with Information Assurance Vulnerability Alert (IAVA) mitigation actions, Security Technical Implementation Guide (STIG) guidance.• Install IBM DB2 on a Windows server and migrate enterprise database from version 9.7 to 11.1.• Configure and manage DB2 replication between mainframe and DB2 database.• Provide ongoing DB2 support for the application team with stored procedures, data dumps and ad-hoc reports.• Consistently receive recognition from the Government SQL Server Section Chief for outstanding support and troubleshooting expertise.

• Responsible for architecting high performing database solutions for production databases with zero downtime• Configure High Availability AlwaysOn environments for production databases using clustering and High Availability groups• Perform daily asset maintenance for both SQL Server installation and SQL Server database assets per Defense Information Systems Agency (DISA) Security Technical Implementation Guidelines (STIG)• Participate in specification, design, testing, and implementation of systems to support the efficient operation of enterprise applications and critical network and system assets• Responsible for database performance, integrity, and security in a production environment• Perform ongoing monitoring, performance tuning, and scale-ability optimizations to the database systems supporting several thousand users• Troubleshoot/problem-solve SQL development, and provide trend analysis to our management to assist them in making resource utilization decisions

• Responsible for architecting high performing database solutions for production databases with zero downtime• Perform ongoing monitoring, performance tuning, and scale-ability optimizations to the database systems supporting several thousand users• Configure High Availability AlwaysOn environments for production databases using clustering and High Availability groups• Participate in specification, design, testing, and implementation of systems to support the efficient operation of enterprise applications and critical network and system assets• Perform daily asset maintenance for both SQL Server installation and SQL Server database assets per Defense Information Systems Agency (DISA) Security Technical Implementation Guidelines (STIG)• Responsible for database performance, integrity, and security in a production environment• Perform ongoing monitoring, performance tuning, and scale-ability optimizations to the database systems supporting several thousand users• Troubleshoot/problem-solve SQL development, and provide trend analysis to our management to assist them in making resource utilization decisions

• Responsible for providing enterprise database administration and management support for integrated applications, data systems, services and security on enterprise systems across the Medical Command • Monitor backup and recovery files and jobs to ensure backups are taken per client recovery requirements. • Utilize SSIS to import/export data across multiple domains. • Serves as an enterprise database developer and administrator with primary responsibilities of managing and administering 10 standalone servers and 2 clustered data systems operating on windows server platforms • Design, develop, deploy and support enterprise data system in support of United States Army Medical Command and Medical Information Technology command or external customer requirements • Perform daily asset maintenance for both SQL Server installation and SQL Server database assets per Defense Information Systems Agency (DISA) Security Technical Implementation Guidelines (STIG)

Design, Develop and Implement complex database systems, tools, and applications. Maintain Databases, DBA, Application Support

• Responsible for security and certification procedures of the Mental Health Systems(MHS), such as the DoD Information Assurance Certification and Accreditation Process (DIACAP) and the Certificate of Net worthiness (CoN).• Enforce security, including the implementation of security and patches and encryption, and provide documentation to meet Approval to Operate (ATO) and DIACAP requirements.• Serves as an enterprise database developer and administrator with primary responsibilities of managing and administering multiple standalone and clustered data systems operating on windows server platforms.• Design, develop, deploy and support enterprise data system in support of United States Army Medical Command and Medical Information Technology command or external customer requirements.• Perform daily asset maintenance for both SQL Server installation and SQL Server database assets per Defense Information Systems Agency (DISA) Security Technical Implementation Guidelines (STIG).