Ysaias Portes
Business Intelligence Manager at Community Care Plan- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Pran Joshi
Ysaias is a super smart SQL DBA with expert level skills and experience, I worked with him solving complex Oracle-to-SQL replication issues and we solved those issues thanks to his ability to think beyond the errors. I was particularly impressed by Ysaias's ability to handle even the toughest challenges effortlessly. That level of technical skills often takes years to develop and lots of experience with SQL Server.
Pran Joshi
Ysaias is a super smart SQL DBA with expert level skills and experience, I worked with him solving complex Oracle-to-SQL replication issues and we solved those issues thanks to his ability to think beyond the errors. I was particularly impressed by Ysaias's ability to handle even the toughest challenges effortlessly. That level of technical skills often takes years to develop and lots of experience with SQL Server.
Pran Joshi
Ysaias is a super smart SQL DBA with expert level skills and experience, I worked with him solving complex Oracle-to-SQL replication issues and we solved those issues thanks to his ability to think beyond the errors. I was particularly impressed by Ysaias's ability to handle even the toughest challenges effortlessly. That level of technical skills often takes years to develop and lots of experience with SQL Server.
Pran Joshi
Ysaias is a super smart SQL DBA with expert level skills and experience, I worked with him solving complex Oracle-to-SQL replication issues and we solved those issues thanks to his ability to think beyond the errors. I was particularly impressed by Ysaias's ability to handle even the toughest challenges effortlessly. That level of technical skills often takes years to develop and lots of experience with SQL Server.
Credentials
-
MCSA: SQL Server 2012
MicrosoftSep, 2015- Oct, 2024 -
MCITP: Database Developer on SQL Server 2005
MicrosoftApr, 2007- Oct, 2024 -
MCITP: Database Administrator on SQL Server 2005
MicrosoftFeb, 2007- Oct, 2024 -
MCTS: SQL Server 2005
MicrosoftFeb, 2007- Oct, 2024 -
MCDBA: Microsoft SQL Server 2000
MicrosoftFeb, 2005- Oct, 2024 -
MCPS: Microsoft Certified Professional
MicrosoftDec, 2004- Oct, 2024
Experience
-
Community Care Plan
-
United States
-
Insurance
-
100 - 200 Employee
-
Business Intelligence Manager
-
Nov 2018 - Present
-
-
-
Memorial Healthcare System
-
United States
-
Hospitals and Health Care
-
700 & Above Employee
-
Sr. SQL DBA
-
Aug 2005 - Nov 2018
• Administer over 80 SQL Servers (2008, 2012, 2014,2016, 2017) with over 3,000 databases from small(10GB) to very large (8+TB). Total of over 40TB • As a DBA responsible for all configuring all High Availability environments, building SQL Clusters (over 50 already built), AlwaysOn(5 built with over 30 databases and 12 replicas). • Created first Epic’s Clarit non-intrusive SQL data encryption .NET CLR function for encrypting PII, PCI, PHI data and making the database HIPPA compliant. CLR… Show more • Administer over 80 SQL Servers (2008, 2012, 2014,2016, 2017) with over 3,000 databases from small(10GB) to very large (8+TB). Total of over 40TB • As a DBA responsible for all configuring all High Availability environments, building SQL Clusters (over 50 already built), AlwaysOn(5 built with over 30 databases and 12 replicas). • Created first Epic’s Clarit non-intrusive SQL data encryption .NET CLR function for encrypting PII, PCI, PHI data and making the database HIPPA compliant. CLR uses change tracking to encrypt SSN and other private information, making it transparent to Clarity ETL process. • As an Epic Clarity SQL 2016 MCSA DBA, I Implemented the First Clarity database Availability Group in SQL 2012, upgraded to SQL 2014 and recently to SQL 2016. Databases over 8TB compressed. • Responsible for all databases disaster recovery configuration and processes, testing and validation. • Monitor, configure and tighten security using TDE, Encrypted connections and tracking auditing logins. Developed a Security and performance monitoring system allowing DBAs to constantly monitor security and configuration changes. Lead and developed the new 4TB Data warehouse for the first large integrated BI system in a HealthCare industry. Implemented the first SQL Server Disaster recovery procedure being used for our current yearly DR drill. Established the deployment of new database environment, consolidating multiple databases into a SQL farm and enabling new projects a fast and reliable method to implement databases. I am highly experienced on developing and designing entire databases including all tables, stored procedures, functions, CLRs and indexes. Continuously work on analyzing database performance metrics and finding ways to improve performance across multiple servers and databases, using Perfmon, SQL profiler and Idera DM. Constantly monitor and analyze indexes fragmentation, table statistics, locking, CPU, memory and disk performance. Show less • Administer over 80 SQL Servers (2008, 2012, 2014,2016, 2017) with over 3,000 databases from small(10GB) to very large (8+TB). Total of over 40TB • As a DBA responsible for all configuring all High Availability environments, building SQL Clusters (over 50 already built), AlwaysOn(5 built with over 30 databases and 12 replicas). • Created first Epic’s Clarit non-intrusive SQL data encryption .NET CLR function for encrypting PII, PCI, PHI data and making the database HIPPA compliant. CLR… Show more • Administer over 80 SQL Servers (2008, 2012, 2014,2016, 2017) with over 3,000 databases from small(10GB) to very large (8+TB). Total of over 40TB • As a DBA responsible for all configuring all High Availability environments, building SQL Clusters (over 50 already built), AlwaysOn(5 built with over 30 databases and 12 replicas). • Created first Epic’s Clarit non-intrusive SQL data encryption .NET CLR function for encrypting PII, PCI, PHI data and making the database HIPPA compliant. CLR uses change tracking to encrypt SSN and other private information, making it transparent to Clarity ETL process. • As an Epic Clarity SQL 2016 MCSA DBA, I Implemented the First Clarity database Availability Group in SQL 2012, upgraded to SQL 2014 and recently to SQL 2016. Databases over 8TB compressed. • Responsible for all databases disaster recovery configuration and processes, testing and validation. • Monitor, configure and tighten security using TDE, Encrypted connections and tracking auditing logins. Developed a Security and performance monitoring system allowing DBAs to constantly monitor security and configuration changes. Lead and developed the new 4TB Data warehouse for the first large integrated BI system in a HealthCare industry. Implemented the first SQL Server Disaster recovery procedure being used for our current yearly DR drill. Established the deployment of new database environment, consolidating multiple databases into a SQL farm and enabling new projects a fast and reliable method to implement databases. I am highly experienced on developing and designing entire databases including all tables, stored procedures, functions, CLRs and indexes. Continuously work on analyzing database performance metrics and finding ways to improve performance across multiple servers and databases, using Perfmon, SQL profiler and Idera DM. Constantly monitor and analyze indexes fragmentation, table statistics, locking, CPU, memory and disk performance. Show less
-
-
-
City of McAllen, TX
-
United States
-
Government Administration
-
300 - 400 Employee
-
Sr. SQL Server DBA/Developer
-
Feb 2002 - Aug 2005
Fully responsible for managing and administering all of the organizations databases. Worked on major projects like the implementation of a new CRM system where I was a project manager responsible for the analysis of database requirements, installation and configuration of cluster server, performance and disk requirements. During this time I became a big asset by developing the first IT help desk system on ASP.NET and later adding 6 other applications. Responsible for the development of multiple… Show more Fully responsible for managing and administering all of the organizations databases. Worked on major projects like the implementation of a new CRM system where I was a project manager responsible for the analysis of database requirements, installation and configuration of cluster server, performance and disk requirements. During this time I became a big asset by developing the first IT help desk system on ASP.NET and later adding 6 other applications. Responsible for the development of multiple DTS/ETL packages to integrate with other systems. I managed 6 24/7 databases, maintained backups, security and monitoring of all systems. I collaborated on a major project for the migration from Lotus Dominos to MS Exchange and SMS. My last project was the development of the new online payment transaction system that included creating DTS packages for integration with old CRM AS/400 DB2 system. Worked on developing projects for new applications to manage customer’s relationships. During this time I was fully responsible for the architecture, design and development the entire database for the projects. After completion, I provided another 2 months of testing and deployment of the database. I collaborated greatly on troubleshooting and debugging the application that had been built on VB6. Show less Fully responsible for managing and administering all of the organizations databases. Worked on major projects like the implementation of a new CRM system where I was a project manager responsible for the analysis of database requirements, installation and configuration of cluster server, performance and disk requirements. During this time I became a big asset by developing the first IT help desk system on ASP.NET and later adding 6 other applications. Responsible for the development of multiple… Show more Fully responsible for managing and administering all of the organizations databases. Worked on major projects like the implementation of a new CRM system where I was a project manager responsible for the analysis of database requirements, installation and configuration of cluster server, performance and disk requirements. During this time I became a big asset by developing the first IT help desk system on ASP.NET and later adding 6 other applications. Responsible for the development of multiple DTS/ETL packages to integrate with other systems. I managed 6 24/7 databases, maintained backups, security and monitoring of all systems. I collaborated on a major project for the migration from Lotus Dominos to MS Exchange and SMS. My last project was the development of the new online payment transaction system that included creating DTS packages for integration with old CRM AS/400 DB2 system. Worked on developing projects for new applications to manage customer’s relationships. During this time I was fully responsible for the architecture, design and development the entire database for the projects. After completion, I provided another 2 months of testing and deployment of the database. I collaborated greatly on troubleshooting and debugging the application that had been built on VB6. Show less
-
-