Peter A.

Dear Sir/Madam, I am a Microsoft Certified SQL Server Database Administrator. I have 10 years of experience with databases such as Oracle, Microsoft SQL Server, MySQL, MS Access, EXCEL, CSV, TXT, etc. that I migrate to the latest platform for faster performance both On-Cloud and On-premises. I remove flawed data, normalize tables and create Web Apps for end users. Your benefits: You won't waste time with me. I know it can be a rocky road to finding the SQL Database Developer that. -Has the skills you need. -AND who is actually motivated to work closely with you. -AND you can trust to get the job done RIGHT, the first time. -I’m not like most others who take on as many clients as they can, then run off and disappear for weeks at a time. Instead, I intentionally target a smaller, select group of clients that I can work closely with for exact results. SKILLS Database Design and Analysis: ------------------------------------------------- -Design, develop and implement databases using standard industry rules and standards. -Normalize databases using primary and foreign keys to prevent duplication and to -Enforce referential integrity. -Organize tables and create keys. -Use views to connect related to tables for high volume data retrieval Using Transact-SQL Code ------------------------------------------ -Demonstrate ability to utilize basic transact SQL to create views, functions and stored procedures -Create functions using primary key to return descriptions from table. -Demonstrate ability to use transact SQL code to query database tables and views. -Create stored procedures to create, read, update and delete information from tables and views. Coding C# Applications and Programs: -------------------------------------------------------------- -Utilize Visual Studio C# with Microsoft's Entity Framework Core SQL Server to -Scaffold Database objects into C# classes use those classes for CRUD (Create, ----Read, Update and Delete operations). -Create front end to interact with SQL Server database. SSRS - SQL Server Reporting Services: ------------------------------------------------------------- -Create master detail report using key relationships defined within the SQL Database Tables. -Use relationships between primary and foreign keys to extract linked data -Present link-data on a report in a master details format -Use report and sub-report functionality of SSRS. Application Support/Maintenance: ------------------------------------------------------- -Create yearly production database, design, monitor and maintain. -Resolved submitted tickets for issues/problems with Web application, and SQL database servers. -Resolved submitted tickets for firewall rules and ports. -Install and configure SQL Server Reporting Services (SSRS) Server for deploying and printing reports. Environment: Microsoft Window Server, SQL-Server 2019, High Availability (HA), Cluster Servers Node1,2,3,4 Failover nodes and Disaster Recovery (DR).