Helen Berger

• Delivered exceptional results as a Lead SQL Server DBA in AMFM department

Responsible for every aspect of

• Setup complete SQL server infrastructure consisting of more than 100 SQL server instances
• Responsible for every aspect of administrative, troubleshooting support to Actuarial community
• Setup autoamtion solutions for business continuity tests, using Autosys, powershell
• Setup automation solutions for SQL mirroing and Always ON failover using Autosys, Ansible, powershell
• Migrated SQL server on-prem databases into COLO datacenters

• Log shipping
• Dashboard monitoring
• Jenkins pipeline automation
• Saving solutions for setting backups to ZFS
• 
  
• 
  
• Technical Expertise
• Automation Solutions
• 
  
• 
  
• 
  

• Effectively managing 120 Production Database Servers as a Senior SQL Server DBA Lead in a mission critical environments globally
• Applications include but not limited to employee communication and financial systems, instant messaging, emailing, videoconferencing and others
• Providing leading role in administration, troubleshooting and monitoring of the database servers using Tivoli client and BMC Patrol
• Effectively planning, scheduling and executing upgrade of existing servers to newer version to leverage software improvements, mitigate risk of hardware incompatibilities, and realize cost savings
• Providing key role in SQL coding – designing and creating databases, tables, applying indexes, stored procedures, cursors, transactions, functions and DTS/SSIS packages
• Creating SQL nightly/weekly maintenance plans for backups/re-indexing/integrity validations.Utilizing PowerShell for SQL batching
• Responsible for licensing and installation operations of: SQL Server 2008/2008 R2/SQL 2012 Participating in migration effort of SQL 2008 to SQL 2012
• Utilizing Clustering SQL server technology to boost the uptime of SQL Server: Installing and supporting SQL Clustering for multiple SQL instances on multiple nodes
• Configuring SQL Servers with multiple instances on Consolidated and VMware Environments
• Configuring SQL Mirroring and Failover for Disaster Recovery and Contingency Processes
• Providing Query Optimization in DETA and Profiler to improve query execution plans and overall server performance
• Performing performance monitoring via Microsoft PSSDIAGs diagnostic tools and PERFMON Counters
• Installing/configuring and creating Reporting Services (SSRS) and utilizing Analysis Services (SSAS) for data warehouse applications
• Supporting development of SQL database for new product launch
• Performing migration of Oracle Data into SQL Server
• Planning and administering business contingency testing (COB) to ensure stability of the systems in emergency situations
• Articulated project goals and scope, monitored progress to meet milestones and advocated on behalf of users and functional owners during meetings with business and management
• Building strong relationships and effectively cooperating with the core Businesses, Application, Operations and Engineering teams.
• Supporting and developing CitiDirect Card Management System (CCMS) which offers multiple transaction processing and reporting platforms for Government and Corporate agencies

Project Leader Role

• Effectively managing Production Support Team as Project Leader – responsible for CCMS production implementations, SDLC Documentation, Project Scheduling, Resource Allocation, Change Control Management, Estimating Requirements and Project Cost/budgeting
• Leading effort in providing all levels of production support and resolution of technical problems in database production environment, including data analysis and fixes on the fly utilizing SQL Sever Profiler and Tracing; performing queries optimizations and tunings by running query execution plan and creating/modifying indexes; supporting all system’s processes, including inbound/outbound feeds/files, monitoring system generated Tivoli Alerts
• Preparing Hermes packages for databases production deployments
• Participating in ongoing SQL Server 2000 to SQL Server 2005/2008 conversion project - installing SQL Server 2005/2008, performing analysis, development and testing of CCMS databases in SQL 2005 environment
• Incorporating SQL’s 2005 Partitioning and Clustering techniques and capabilities
• Playing a key role in the design and development of the major CCMS releases: allowing CCMS clients to have the data available in the morning, as soon as the TSYS inbound files have been loaded into production; migrating Jacksonville Help Desk Verification System (front end application and databases) into CCMS datacenter
• Redesigning and modifying the application and databases to support CCMS standards utilizing TSQL, DTS, Visual Basic, ASP
• Performing SQL coding – designing and creating databases, indexes, stored procedures, cursors, transactions, functions and Data Transformation Service packages
• Creating SQL database backups and restoring databases with SQL LiteSpeed, MS Enterprise Manager
• Including SQL backups batch files in windows batch files
• Leading and participating in the continuity of business recovery test (COB) to ensure the stability and contingency of CCMS business in emergency situations
• Participating in implementation and monitoring of replication/mirroring process to synchronize COB and Production database environments
• Implementing new web-based functionality to allow PA to set up and maintain account demographics and controls; oversee transaction and account activity, using SQL, ASP, VBscript, VB, Javascript, HTML, .NET framework
• Enhancing and supporting Citibank Financial Expense and Interface System (CFI) using TSQL, OSQL, DTS, Windows batch files, Windows scripting host, NDM scripts, XML configuration files
• Enchancing CitiExport exporting processes, generated through online application requests and transmitted using NDM secure server
• Participating in design, development and testing and production implementation of CCMS databases re-encryption process to successfully resolve compliance related issues
• Building strong relationships and effectively cooperated with the business, TI /DBA and Operations teams.