Feima Zeinu

Over 9 years of IT experience in Microsoft SQL Server Database installation, configuration, administration, maintenance, performance tuning, backup/restore, Autosys, optimization and disaster recovery experience in SQL Server 2022/2019/2017/2016/2014/2012/2008R2. Hands-on experience migrating scripts in a production environment with extensive experience in creating and modifying stored procedures, triggers, cursors, and functions based on business requirements. Expert in SQL Server Reporting Services installation, configuration, and maintenance using Visual Studio and Reporting Services.

Proficient in implementing SQL Server security through administering user permissions, user roles, and setting database authentication modes. Expertise in implementing different types of high availability and disaster recovery (HADR) technology like Replication, Log Shipping, Database Mirroring, AlwaysOn, and Windows Failover Clustering (WSFC). Experienced in SQL server Enterprise edition data compression and online indexing.

Implemented Windows Failover

Clustering, High Availability solutions, and server consolidations. Migrated SQL Server 2012 database server to SQL Server 2014/2016/2017/2019. Creation of Linked Server connection between different SQL server versioned servers as well as SSIS package creation for data transfer between the environments.

Knowledgeable in creating Stored Procedures, Indexed Views, User Defined Functions (UDF), Triggers Distributed Queries, and Common Table Expressions. Expert in tuning a database by choosing indexes and using tools such as Database Engine Tuning Advisor and SQL Server Profiler. Experienced in troubleshooting database issues like space, deadlocks, performance, and blocking.

Experienced in allocating system storage and future capacity planning for various database systems. Experienced in monitoring and optimizing the performance of the database. Use AI-assisted performance tools: Fabrix.ai, Claude and Copilot. 24 X 7 Production Database on Call Support.

Install

Copilot in SSMS using the Visual Studio Installer.

SQL DBA - Houston Health Department - TX

(2021-02)

• Installed and configured MS SQL Server 2008 and, 2012,2014,2016,2019 and 2022 versions
• Experienced in SQL Server Migrations of various versions (2019/20016/2014/2012/2008R2)
• Create reports in SQL server using SSRS per the requirements provided by the front-end users.
• Create maintenance plans and jobs to achieve optimal performance.
• Supported both production and non-production environment.
• Configured and monitored the High availability solutions (SQL server Clustering, SQL server AlwaysOn, SQL server Database Mirroring, SQL server Log-Shipping and SQL server Replication Technologies)
• Extensively worked on upgrading Microsoft SQL Server failover clustering, log shipping, and replication, using System Monitor and SQL Server Profiler to identify bottlenecks, discovering slow-running queries, performing backup and recovery databases, and implementing database modifications on production servers.
• Analyzed and defined capacity planning for maintenance of the different Database Backups and Restore scenarios.
• Set up security and access profiles and procedures for SQL Server Instances & databases.
• Worked in coordination with different Teams (like Network Team and other application Teams) as well as with Stakeholders and customers.
• Experienced in Incident Management, Problem Management, and Change Management
• Supported the research, investigations, and recommendation of best practices for information and application services and contribute to work plans.
• Modify database structure as necessary based on the information given by application developers.
• Hands-on experience in troubleshooting all database-related issues.
• Performance tuning and optimization of databases using tools like SQL Profiler, Query Analyzer, Idera SQL diagnostic manager, and Database Engine Tuning Advisor.
• Work on SQL Server Integration Services (SSIS) to transform data from cubes and store it on SQL Server tables.
• Responsible for data migration from Excel, Flat file, Sybase, and Oracle to Microsoft SQL Server by using BCP and DTS utilities as well as Extracting, Transforming, and Loading data using Microsoft SQL Server SSIS.

SQL DBA - Halliburton - Houston, TX

(2019-08 - 2021-01)

• Install, upgrade, configure, and migrate SQL Server in clustered and non-clustered production environments.
• Set up Transactional Replication between SQL Servers, as well as between SQL and Oracle databases.
• Modify database structure as necessary based on the information given by application developers.
• Routine planning and exercise of database backup and recovery process.
• Performance tuning and optimization of databases using tools like SQL Profiler, Query Analyzer, and Database Engine Tuning Advisor.
• Create reports in SQL server using SSRS per the requirements provided by the front-end users.
• Work on SQL Server Integration Services (SSIS) to transform data from cubes and store it on SQL Server tables.
• Perform SQL Server Reporting Services (SSRS) maintenance.
• Create maintenance plans and jobs to achieve optimal performance.
• Expertise in Performance Monitoring & Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Responsible for data migration from Excel, Flat file, Sybase, and Oracle to Microsoft SQL Server by using BCP and DTS utilities as well as Extracting, Transforming, and Loading data using Microsoft SQL Server SSIS.
• Upgrade and migrate databases between various SQL Server versions.
• Worked with Change Data Capture (CDC) feature to monitor real-time database events and to capture all the changes during the migration of data between databases.
• Ensure recoverability of the Data Warehouse with minimal loss of information; this includes extensive testing of the backup and recovery processes.
• Work on installation, configuration, support, maintenance, and backup of SQL Server databases and IIS Web Server.
• Administer and implement SQL Server 2012 technology like data compressions and online indexing.
• Developed and documented backups, recovery strategies, and disaster recovery mechanisms and participated in disaster recovery drills for various environments. Successfully implemented Log shipping for DR solutions.
• Proactively managed Microsoft SQL Server instances at the corporate office by developing Microsoft SQL scripts for creating and upgrading databases, maintenance plans, user logins, network, and server monitoring automation with exception reporting via Database Mail notifications, and a SQL Server failover system.
• Extensively worked on upgrading Microsoft SQL Server failover clustering, log shipping, and replication, using System Monitor and SQL Server Profiler to identify bottlenecks, discovering slow-running queries, performing backup and recovery databases, and implementing database modifications on production servers.
• Involved in the development of databases including creating new databases, converting old databases to new databases, modification of existing databases, and creating reports to meet business needs.
• Hands-on experience in troubleshooting all database-related issues.

SQL DBA - Cerner Corporation - Houston, TX

(2017-06 - 2019-07)

• Responsible for data migration from Excel, Flat file, Sybase, and Oracle to Microsoft SQL Server by using BCP and DTS utilities as well as Extracting, Transforming, and Loading data using Microsoft SQL Server SSIS and DTS.
• Prepared, maintained, and modified SQL server installation and configuration documents.
• Database Administrator, Database Programming.
• Performed daily tasks including backup and restore by using SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics, and Re-indexing.
• Worked with different upstream teams for downloading ETL MART data.
• Worked on extracting data from multiple data sources such as Oracle, PeopleSoft, Siebel CRM, flat files, and loading into OLAP systems.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers, and user-defined functions.
• Involved in troubleshooting and fine-tuning databases for its performance and concurrency.
• Converted DTS or SSIS packages into SQL Server 2012 Integration Services.
• Migrating SQL Server 2008R2 databases into SQL Server 2012.
• Used SQL Profiler to capture the activities of the databases and used the trace file as a workload file to the Database Tuning Advisor for index recommendations.
• Installed SQL Server 2005 and created Development Database for testing, upgrades, and development.
• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Rebuilding the indexes at regular intervals for better performance.
• Involved with the development team and developed functions, procedures, and packages and performed Logical Backups using Export and Import utilities and Autosys.
• Handled numerous change management requests on production servers.