Skip to main content

Jorge Berganza

Data Base and IT Apps Administrator

Talent
Ellicott City, MD 21042Member since November 19, 2026
Microsoft Office SuiteOutlookExcelWordPowerPointAccessMS SQL ServerStrong written communication skillsAbility to multitask and prioritize tasks to meet deadlinesAnalytical and creative problem-solving skillsEffective interpersonal skillsIndependent worker and collaborative team memberProject leaderSQL Server ManagementPower BIBIDSSSRSSQL ProfilerDatabase Engine Tuning AdvisorDMVsAlways OnWSFClog shippingreplicationSSISDTSSQL Server Migration Assistant (SSMA)Transparent Data Encryption (TDE)SSL encryptionNetBackup
·

Hire this person

Send a job offer directly to this candidate

Microsoft Office SuiteOutlookExcelWordPowerPoint

About

Dynamic and detail-oriented database professional with a strong ability to bridge the gap between technical expertise and business objectives. Proficient in designing, implementing, and maintaining enterprise-grade database solutions that enhance performance, security, and scalability. Skilled in transforming business needs into actionable database strategies, driving efficiency and innovation in high-pressure environments.

Known for a proactive approach to problem-solving, fostering collaboration across teams, and delivering consistent results in optimizing database systems for peak performance and reliability. A forward-thinking leader dedicated to leveraging the latest technologies to meet and exceed organizational goals.

Experience

Data Base and IT Apps Administrator - Manganaro Mid-Atlantic

  • Administer and maintain SQL Server databases, including installation, configuration, upgrades, security, user management, and routine maintenance.
  • Perform database backup and restore operations to support data protection and recovery requirements.
  • Monitor database performance and troubleshoot production issues, including blocking, deadlocks, slow-running queries, and resource-intensive operations.
  • Utilize SQL Server Query Store and execution plans to identify expensive queries, investigate performance bottlenecks, and recommend optimization strategies.
  • Analyze index usage statistics, identify missing or inefficient indexes, and implement index optimization strategies to improve query performance.
  • Refactor and optimize existing T-SQL stored procedures to improve execution efficiency, simplify code, enhance maintainability, and reduce unnecessary resource consumption.
  • Develop, modify, and maintain stored procedures, views, user-defined functions, and complex T-SQL queries to support business and application requirements.
  • Identify opportunities to improve database performance by optimizing queries, refactoring stored procedures, and implementing indexing improvements.
  • Create, configure, and maintain SQL Server Agent jobs to automate database maintenance, scheduled processes, and recurring tasks.
  • Perform root cause analysis and implement corrective actions to resolve database performance and operational issues.
  • Collaborate with development and technical teams to support application enhancements, database changes, and SQL code improvements.
  • Database Tools: SQL Server Management Studio (SSMS), SQL Server Profiler

Remote SQL Server DBA & Analyst - The Bank of Glen Burnie

(2024-10 - 2025-01)

  • Database Management: Microsoft SQL Server, Relational Database Management Systems (RDBMS), Database Administration
  • SQL Development: T-SQL, Complex SQL Queries, Joins, Common Table Expressions (CTEs), Views, Stored Procedures
  • Performance Tuning & Optimization: Query Optimization, Execution Plan Analysis, SQL Server Query Store, Performance Troubleshooting
  • Index Management: Index Analysis, Index Optimization, Index Usage Statistics, Index Maintenance
  • Database Monitoring: Query Performance Monitoring, Resource Utilization Analysis, Database Performance Diagnostics
  • Automation & Maintenance: SQL Server Agent Jobs, Scheduled Tasks, Database Maintenance
  • Database Security: User Permissions, Database Access Control, Security-Aware Query Development
  • Database Tools: SQL Server Management Studio (SSMS), SQL Server Profiler

Remote SQL Server DBA & Analyst - M&T Bank (Corporate IT)

(2023-07 - 2024-10)

  • Administer and maintain SQL Server instances in AWS and Azure environments, ensuring high availability with Windows Server Failover Clusters (WSFC) and Always on Availability Groups.
  • Manage SQL Server 2019 and 2022 environments, leveraging advanced features to enhance database performance, security, and scalability.
  • Implement Transparent Data Encryption (TDE), Data Masking and SSL encryption to secure sensitive data and ensure compliance with industry standards.
  • Perform upgrades of legacy systems to newer SQL Server versions, ensuring minimal downtime and maintaining data integrity. Apply windows patches and updates monthly along with cumulative updates when available and applicable.
  • Lead database migration projects, including SQL Server to Postgres transitions, utilizing AWS and Azure Database Migration Services.
  • Configure and manage user environments, including installations and integrations of SQL Server, Microsoft Visual Studio, and other components of Microsoft.
  • Develop and maintain T-SQL Programming (DDL, DML, TCL, and DCL) constraints, views, and tables while managing SQL Agent and SSIS package jobs.
  • Design and maintain ETL processes using SQL Server Integration Services (SSIS) for seamless data integration and transformation.
  • Conduct proactive database maintenance, including configuration, performance monitoring, troubleshooting, and engine optimization.
  • Provide 24/7 support and implement disaster recovery strategies to ensure system availability and business continuity.
  • Manage SharePoint content and site collection databases, including site collection creation and maintaining robust backup and restore processes.
  • Automate recurring tasks using PowerShell scripts and batch files with Windows Task Scheduler to streamline operations.
  • Oversee database design efforts, including schema creation, indexing, and performance tuning, to ensure scalability and optimal application functionality.

DBA & Data Analyst - Bank of America - Remote

(2020-07 - 2023-07)

  • Provided critical database support for multiple SQL Server instances, ensuring seamless operations and optimal performance for various clients and organizations.
  • Resolved day-to-day database issues, including troubleshooting connectivity errors, managing user permissions, deploying database updates, and maintaining overall database stability.
  • Designed and maintained ETL workflows to extract, transform, and load data from diverse sources into Oracle and other target systems, enhancing data integration efficiency.
  • Managed database installations, configurations, and schema updates, ensuring smooth system functionality and minimal disruption to business processes.
  • Collaborated with development teams to facilitate the deployment of new projects to production environments, ensuring high-quality results and adherence to project timelines.
  • Installed and configured new SQL Server instances, integrating them into existing infrastructures to support expanding database needs.
  • Configured and maintained Database Mail, enabling effective communication and notifications within the database

Education

Diploma - General Studies - Howard Community College, MD

Skills

Data Base and IT Apps Administrator

Reviews

Related