| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
SENIOR SQL SERVER ADMINISTRATOREMAIL AVAILABLE PHONE NUMBER AVAILABLE Street Address
ObjectiveI am a SQL Server Developer and Administrator with 30+ years of hands-on experience in developing Databases as well as administering and maintaining them and various .NET applications that talk to the databases.Professional ExperienceMedadept, LLCSenior Software Architect, April 2004PresentFor almost 20 years Ive been part of a team that has designed, built, and maintained several Healthcare Applications. Ive worked with Physical, Occupational, Speech, Respiratory Therapists as well as Home Health and Hospice Professionals and Doctors.All our Servers are in Azure, and I am an Administrator for all Windows servers. I have set up and maintained all Security Groups in Azure and been involved with successful SOC2 Audits and staying abreast of all HIPPA regulations. I access the Windows based Servers by use of Virtual Private Networks (VPNs) creating a completely encrypted connection. I maintain every aspect of the SQL Server security, from row/table level access to accessing the Azure Server itselfI designed the initial templates for all the SQL Tables and Views used in the Healthcare Apps. From populating the Lookup list in Drop-Down boxes in the Apps, to writing end-user data to specific tables in the Applications. I tuned each query in the Applications to provide an optimum performance to the end user.I built JOINS of every kind, Complex Queries using Aliases, Views, Cursors, Cross Apply Queries, CTEs and Triggers. I set up daily Differential and weekly Full Backups for each Production database. I wrote a series of complex queries that uses Restore and Verify commands to ensure the integrity of each Full database backup.As Medadept employed additional developers, working with a Source Code Repository became critical, we chose GitHub. Building on that experience, I learned to write APIs for communications between different Applications and wrote the Source Code as well. We maintained a separate Development Server, also in the Azure space, so we could Test what we wrote before placing the new components into Production. This coupled with other steps in the CI/CD Pipeline allowed us to rapidly develop, test and deploy the new code and components.Besides building the Source Code in a .NET environment, I used the Entity Framework to communicate with User-Specific Databases authorized by using OAuth logins which I built for Single-Sign-On to the Apps and Database.I also built all the Clinical Reporting Application that the users need every day to communicate their findings to various people in the Healthcare world. Every Report I built has several filters that allow the user to customize what data is seen. I built an average of 80 sub-reports for each major category of Reports. I used Crystal Reports, Tableau and most recently, Telerik to build and maintain these Reports.SkillsDatabase Development:MS Access DatabaseSQL Stored Procedure with VariablesSQL SSIS PackagesBackup and Restore ProceduresSQL Agent JobsReport Development:SQL Server Data ToolsCrystal Reports (Earlier versions)Tableau Reports (Earlier versions)Telerik/Progress Report Server and ToolsCode DevelopmentVB.NETASP.NETJava ScriptHTMLDevOps CI/CD Software Development MethodologyWorked with GitHub Source Code RepositoriesAutomated Testing before placing new versions of code into ProductionAccelerate Code and Data Table DevelopmentStrict Guidelines for placing new versions of code into ProductionProfessional References available upon request |
