Database Administrator
CurrentBack end Database Administration for Microsoft SQL Server 2012, SQL Server 2016, SQL Server 2019 Windows environments.Develops, manages and tests database administration support processes including backup/recovery, security and upholding best practices for performance for database systems.Works directly with other teams to build and test database designs that will operate with applications.Follows design and coding standards, code reviews, code versioning, testing, and deployments.Performed DDL and DML operations in T-SQL, SQL Server Integration Services (SSIS), and Powershell.Utilized T-SQL and Powershell to perform dynamic DDL and DML operations.Performed database health analysis and SQL troubleshooting within a cross-team setup in the company.Performed database process repairs on internal servers.Created technical documentation for many processes for easy sharing, training, and implementation within the team.Implemented Jupyter Notebooks (runbooks) in VS Code for executable documentation.Works with internal customers to define and develop database applications.Building reports in SQL Server Report Builder that are driven in SQL Server Report Services(SSRS).Utilizing troubleshooting skills to tackle and complete assigned projects.Participate in On-Call Team rotation.Researched and created a repeatable process to utilize Jupyter Notebooks runnable documentation notebooks. Built detailed documentation on this process.Automated the an existing process to dynamically build the databases, tables, and views within the databases involving 100+ objects across test and prod servers using Powershell and dynamic T-SQL. This was a full conversion of a previously manual process. Built detailed documentation.