Jack Nathan Email & Phone Number

Looking for opportunities as a SQL Database Administrator/Developer/Azure DBA in the Dallas or Remote. Extensive experience in a SQL Server and Azure debvelopement, managing and maintenance. Expert in server migration, on-prem to cloud migration. Database administration, support, performance tuning, troubleshooting, and installation, programming, design: SQL server 2019, 2016, 2014, 2012, 2008 R2, 2008, SSAS, SSIS, SSRS (SQL Server Reporting Services), Clustering, Always On, Replication, mirroring, log shipping, Azure, data warehouse, MySQL, and PostgreSQL.Database backup and recovery platforms: Rubrik, NetBackups, and CommvaultDatabase performance tuning: Solarwinds Database Performance Analyzer (DPA), Idera, DMV's and Query store. Azure: Done on-prem to Azure SQL DB, IaaS. Setup data sync replication, HADR always on setup to off site. Data Migration and upgrades: Migrated multi servers to single server, done tech stack upgrades, Operating Systems: Windows 2019, 2016, 2012, 2008

• 

  Database Administrator

  Black Knight

  Aug 2013 - Present

  ● Installed, Configured, and managed SQL server 2012, 2014, 2016, and 2019 servers.● Experience in setting up Always on, troubleshooting and maintaining the Always on servers. ● Conduct day-to-day administration of SQL servers, both on-premises and in Microsoft Azure.● Implement, configure, and maintain SQL Server instances (2014, 2016, 2017, and 2019) and related platforms (SSRS, SSIS, SSAS).● Monitor and maintain log shipping, ETL (SSIS Packages) jobs, and encryption for data… Show more ● Installed, Configured, and managed SQL server 2012, 2014, 2016, and 2019 servers.● Experience in setting up Always on, troubleshooting and maintaining the Always on servers. ● Conduct day-to-day administration of SQL servers, both on-premises and in Microsoft Azure.● Implement, configure, and maintain SQL Server instances (2014, 2016, 2017, and 2019) and related platforms (SSRS, SSIS, SSAS).● Monitor and maintain log shipping, ETL (SSIS Packages) jobs, and encryption for data security.● Develop and document complex installation, configuration, and optimization procedures for automation.● Proactively monitor, trend, and tune SQL databases to ensure optimal performance.● Respond to database and user requests in a timely manner, providing guidance to junior DBAs.● Analyze SQL query plans, suggest and implement solutions to support development teams.● Communicate system health and performance to leadership in both production and development environments.● Ensure databases are regularly backed up and implement recovery plans.● Conduct system maintenance activities, including error log reviews, root cause analysis, and remediation.● Proactively monitor system health to reduce interruptions and server crashes.● Assist in data environment development, testing, and release activities.● Create and implement policies, standards, procedures, and guidelines for effective database administration● Installed and Configured SQL Server Reporting Services (SSRS).● Setup replication, troubleshoot and fix the transactional replication. ● Created SSIS packages, deployed the packages, and troubleshooted the job failures. ● Setup SSISDB for different projects.● Setup Table partitioning, process for performance archive as per archive retention policy.● Perform database administration tasks including Installation, Configuration, upgrades, capacity planning, performance tuning, backup, and recovery. ● Creating and scheduling maintenance jobs. Show less

• 

  The University Of Texas At Austin

  4.0