Haala Binyam
Houston,TX
Summary
High-performing professional with extensive experience managing large-scale, complex databases. Skilled in SQL and database management systems. Strong understanding of database design and data modeling with excellent troubleshooting skills. Smart and committed to staying up-to-date with new technologies and advancements. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Overview
8
8
years of professional experience
Work History
Sr. SQL Server DBA
HP Inc
01.2022 - Current
- HP provides one of the tech world's most comprehensive portfolios of hardware, software, and services. As a DBA, my role was maintaining performance, migrating databases, and upgrading for servers 2017/2016/2014.
- Designed and implemented TSQL queries for reporting and complex solution development.
- Implemented system enhancements to design and develop solutions to address problem reports.
- Documented analysis results and provided performance improvement feedback.
- Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
- Developed custom database objects, stored procedures and delivered application support.
- Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
- Analyzed business reports for prompt communication, follow-up and ongoing support.
- Followed standard practices for migrating changes to test and production environments.
- Supported projects enabling delivery efficiencies and technical resolution.
- Produced high-standard database solutions to meet stability, reliability and performance metrics.
- Worked with staff to develop and implement procedures to prevent data loss and maximize system availability.
- Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
- Set up and controlled user access levels across databases to protect important data.
- Modified databases to meet needs and goals determined during planning process.
- Tested programs and databases to identify issues and make necessary modifications.
- Determined database structural requirements, working with business stakeholders to identify optimal database specifications.
- Developed and updated databases to handle customer data.
- Adhered to set schedules to test databases for flaws and reduce downtime.
- Coordinated with project management on database development timelines.
- Designed and developed analytical data structures.
- Utilized RDBMS tools and utilities to monitor, tune and optimize system performance.
- Implemented security measures to protect vital business data.
SQL Server DBA
ConocoPhillips
09.2018 - 12.2021
- ConocoPhillips is one of the world's largest independent E&P companies based on production and proved reserves
- My role in this project was to maintain and monitor servers and databases and migration of several applications for servers 2017/2016/2014/2012 Enterprise edition.
SQL Server DBA
Amegy Mortgage Capital
10.2015 - 08.2018
- Amegy Mortgage Capital provides full-service mortgage banking, direct portfolio lending and loan servicing, with expertise in providing creative financing solutions for all major types of commercial real estate
- As a DBA, I was responsible for data migration from various data sources such as access, excel, flat file to SQL Server database systems.
Education
Database Design and Computer Programming -
Research Institute/India
Microsoft Certified MSSQL Server Database Administrator -
AbroVision IT Consulting /US
Bachelor of Science: Computer Science -
University of Baghdad/Iraq
Skills
- Reporting Tools: SSRS
- MS SQL Server 2017/2016/2014/2012/2008R2
- Operating System: Windows Servers 2016/2012/2008, Windows 7, 8, 10
- ETL Tools: SSIS, Import/Export Wizard, BI (BIDS/SSDT)
- SQL Server Tools: SQL Server Query Analyzer, SSMS, SSCM, SSDT, BIDS, Profiler, Extended Events
- Languages: T-SQL
- Conflict Resolution
- Critical Thinking
- Recordkeeping
- Friendly, Positive Attitude
- Active Listening
- Remote Office Availability
- Organization and Time Management
- Quality Assurance
- Excellent Communication
- Problem-Solving
Additional Information
Over 7 years of SQL Database Administration experience supporting MS SQL, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) in numerous versions. Proficient in SQL server version upgrades and database migration with both stand-alone and clustered servers. Monitor SQL Server health, performance tuning and optimization of SQL servers using tools such as SQL Profiler, Performance Monitor (PerfMon), Extended Events, Database Engine Tuning Advisor (DTA) and system stored procedures. Experienced in High Availability and Disaster Recovery (HADR) solutions using Windows Failover Clusters, AlwaysOn Availability Group, Replication, Log Shipping and Mirroring technologies. Experienced in database performance tuning, query optimization, client/server connectivity, database consistency checks using DBCC/DMVs/DMFs utilities, re-indexing, updating statistics and online indexing. Creating and modifying stored procedures, tables, indexes, views, functions and triggers in the test environment and eventually deploying them to the production environment. Established and maintained sound backup and recovery/restore policies and disaster recovery procedures to meet both the business RTO (Recovery Time Objective) and RPO (Recovery Point Objective). Performing root cause analysis of database problems, analyzing the efficacy of existing indexes, observing and managing system resource usage. Expertise in moving large amounts of data (bulk loads) with import/export wizard, BCP, bulk insert, attach/detach operations. Establishing database security via different authentication modes and creating custom user roles and access. Installation, configuration and maintenance of SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS) SQL Server Integration Services (SSIS); and creating, modifying and deploying SSRS and SSIS packages. Hands on experience in designing business objects universes using SAP information designing tool in mapping complex data into descriptive business terms for accessibility through queries and reports. Leveraged SSIS to import data from various data sources to SQL Server in generating business reports using SSRS. Involved in information gathering and support for various stages. 24x7 production database on-call support. Excellent analytical, communication and interpersonal skills.
Timeline
Sr. SQL Server DBA
HP Inc
01.2022 - Current
SQL Server DBA
ConocoPhillips
09.2018 - 12.2021
SQL Server DBA
Amegy Mortgage Capital
10.2015 - 08.2018
Database Design and Computer Programming -
Research Institute/India
Microsoft Certified MSSQL Server Database Administrator -
AbroVision IT Consulting /US
Bachelor of Science: Computer Science -
University of Baghdad/Iraq
Similar Profiles
Om AgravatOm Agravat
Inside Sales Representative at Hp IncInside Sales Representative at Hp Inc
Md Kashif KalamMd Kashif Kalam
Lead Software Engineer at Hp IncLead Software Engineer at Hp Inc
Rajni TripathiRajni Tripathi
Technical Solutions Representative II at HP IncTechnical Solutions Representative II at HP Inc
ANGIE LOWMANANGIE LOWMAN
Senior Director, HP Solutions Operations at Hp IncSenior Director, HP Solutions Operations at Hp Inc
SHARON GUERREROSHARON GUERRERO
Logistics Specialist at Army National GuardLogistics Specialist at Army National Guard