Server Dba Database Administrator
Resume:
DJAD ALOUI
SQL Server Database Administrator AWS Solution Architect BSc
Houston, TX
Email: **********@*****.***
Cell1:571-***-****
Cell2:703-***-****
LinkedIn site:linkedin.com/in/djad-aloui
OBJECTIVE
An enthusiastic and passionate IT consultant with over 12 +years of total IT experienced, (10) years as a Microsoft SQL Server Database Administrator. Skills in the areas of Installation, Configuration, Maintenance, Migration, Backup, DR Planning, Performance Tuning, Security, SSIS, SSRS, ETL, TSQL, SAN, Data Modeling and design. Detail oriented hardworking professional with an effective combination of logical, analytical, communication and documentation skills. AWS Solution Architect certified. PowerShell skills TECHNICAL EXPERIENCE SUMMARY
A Database Professional with solid technical experience maintained and developed different business systems using Microsoft technologies. My broad general skills include:
• Database Tools: MS SQL Server 2008/2012/2016/2017/2019
• Azure SQL Management
• Experience in Windows Azure, migrating database to Azure
• Proven Experience in Database Migration from MS SQL server 2000-2008 to 2014-2019
• Backup/Recovery, Design and implement and maintain SQL Jobs and Alerts, database security
• Database performance Tuning, Create and maintain Databases and Database Objects Server Administration, Install/upgrade SQL Server
• Experience working as a DEVOPS Automation Engineer for database deployment
• Have a good understanding on deploying databases in the cloud AWS and AZURE
• Proficient in Windows Server Clustering, Always ON FCI, and PowerShell Automation and reporting
• Programming Languages: T-SQL, PowerShell
• Development Environment: SQL data tool, Vscode. Azure Data Studio, Power BI.
• Reporting Tools: MS Excel, SSRS, Power BI.
• Operating Systems: Windows Server 2008, 2012,2016,2019
• Software: IIS, VMware, PowerShell, Microsoft Office. Windows server, intro to Linux
• Third Party Tools: Red Gate Backup tools, Red Gate Data compare tools. Spotlight Monitoring tool
• Extensively worked with SQL Profiler, Activity monitor, Perfmon, DMVs, DMFs and DTA
• Extensive knowledge of Relational Database Management Systems (RDBMS),
• I have Supported more than 5,000 databases, 500 applications and 200 servers, biggest database 6TB
• Backup, DR Planning, Performance Tuning, Security, SSIS, SSRS, ETL, TSQL, SAN,
• SSMA (SQL Server Migration Assistant) for Oracle, MySQL, Access, and ODBC/DB Link
• Basic – to Intermediate Window server Administration.
• Good exposure to Linux and Docker, Install MSQL server on Docker and Linux environment
• I have professional training on MongoDB and have replication and Shading concept, backup, and administration.
• Devoted and Quick learner with capability to master and implement new technologies
• Good understanding of the Cassandra echo system and the NoSQL
• Amazon AWS RDS Instance Administration
• Amazon Web Services
• AWS Public Cloud Admin
• AWS ECS
• Knowledge on performance and fine-tuning MySQL servers.
• 3+ years of relevant experience as MySQL 5.X/8.X DBA, MariaDB 5.X/10.X on Linux & Windows.
• Installation, Creation, Maintenance of Databases, Performance Tuning, Backup and Recovery, optimization, Database Security and High Availability TRAINING & CERTIFICATION
• BS Electrical Engineering, Constantine, Algeria
• DBA & QA certification, Computech International Institute Inc., June 2008
• AZ900 Certified 2021
• Certified AWS Solutions Architect Aug 2018
• Certified on SQL Server Reporting Services (SSRS): Report Development & Administration,
• Training on Database High Availability Solutions June-2014
• Training on Database Performance tuning – Online Led Training (SQL 2012)
• Training on Database High availability – Alexandria VA (SQL 2012)
• MIM Training at the DTOC Center Disney with (Learning How to Handle situation and resolve problems)
• Basic – to Intermediate Window server Administration.
• training in NoSQL Database option like MongoDB and Cassandra EXPERIENCE
Nes Global Woodside Energy Inc Houston Texas /Hybrid MS SQL Server DBA April 2022 to Now
• Database High Availability: Installed, Configured and Maintained Database Mirroring using automatic
• Assessed customer needs and goals through communication and system evaluations to modify existing databases for personalized customization.
• Installation of Microsoft Windows Server 2005, 2008R2, 2012, 2014, 2016, 2019, building, designing, Configuration, Install and test new version of the database management system (DBMS).
• Upgrade, Migration and application of Windows and SQL Patching during scheduled database downtimes after hours to ensure databases are up to date in Virtualized environments.
• Setting up and defining a good maintenance plan for Backup and Recovery strategies and Capacity planning following the company's Recovery Point Objective (RPO) and Recovery Time objective( RTO) and the Retention policy.
• Set forward authorization, audit plans and data security by creating users and assigning permissions based on the company SLA, established and monitored users access and security.
• Monitored performance and manage parameters in order to provide fast responses to front-end users.
• Successfully Configured High Availability (HA) and Disaster Recovery (DR) Solutions on productions systems using - Always On, Database Mirroring, Replication, Log Shipping to make sure the databases were always available and running.
• Successfully Implemented capacity planning, Managing and providing end to end support and problem resolution for SQL Server databases through multiple product lifecycle environments, such as development, testing to mission-critical production systems.
• Performed capacity management as & when required.
• Reviewed logs for compliance issues with people attempting to access the database
• Monitored query store for database performance and report problems.
• Provide 24X7 dedicated production support for SQL Server problem resolution and server outages.
• Implementing different types of Replication topologies involving Snapshot, and Transactional replication.
• Install and configure MS SQL 2008, 2008r2, 2012, 2014, 2016,2017 and 2019 on Windows Server 2012- 2022, also apply service packs and security fixes on MS SQL Servers.
• Have Managed SQL server In Azure and AWS. And work with SQL Azure . Cognizant BHP Houston Texas /Remote
MS SQL Server DBA Lead July 2019 to March 2022
BHP Billiton: - BHP Billiton, is an Anglo-Australian multinational mining, metals and petroleum dual-listed public company headquartered in Melbourne, Victoria, Australia Successfully performed 4 major transitions for this company for multiple regions, which has more than 2500 SQL instances and now working on BAU in post-production support along with my team. Build the cluster setup on always on for 32 servers. Build the Consolidated environment in Company landscape to minimize the SQL server licensing cost.
In my role at BHP, I was responsible for managing all aspects of SQL Server across the Americas, assisting with servers at numerous sites around the world, which has more than 2500 SQL instances. Responsible for both BAU activities, as well as high level architecture. Experience includes:
- Experience Managing SQL server Environment that is multiple Domain and it was close to 3000 Servers spanned across the world.
- Experience with SQL Server administration in all versions, from SQL 2000 to SQL 2019
-have managed SQL server In Azure and. And work with SQL Azure.
-Good Understanding & Knowledge on Cloud computing architecture, technical design and implementations including Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS)
- Backup and restore specialist
- Always On Availability groups
- High Availability and Disaster Recovery
- Database migration/upgrades
- TSQL Development
- Performance monitoring and troubleshooting
- Server monitoring, including a custom designed monitoring solution
- High level and low level architecture
- Designing standards for the installation and use of SQL Server
- SSRS and SSIS installation and support
- Report design and deployment in SSRS
- DxEnterprise cluster configuration and support
-Create many automation processes and report using PowerShell scripting.
-Proficient in PowerShell to monitor database servers’ health & status I was also involved supporting numerous applications, including:
- Honeywell EBI
- Cority/MedGateGX
- ArcGIS
- Documentum
- SAP MII
- Smart Plant
During the pandemic, I was able to successfully work remotely for the duration of the pandemic. I was engaged with teams in Americas, Chile, Australia, and the United States on a daily basis, via instant messaging and online meetings. My performance improved during the isolation HCL America (Walt Disney Company). Winter Garden, FL MS SQL SERVER DBA July 2017 to June 2019
• Provide 24X7 dedicated production support for SQL Server problem resolution and server outages.
• Implementing different types of Replication topologies involving Snapshot, and Transactional replication.
• Install and configure MS SQL 2008, 2008r2, 2012, 2014, and 2016 on Windows Server 2012,and 2016, also apply service packs and security fixes on MS SQL Servers.
• Database migration from SQL server 2008 to 2012 and 2012 to 2014.
• Have Managed SQL server In Azure and AWS. And work with SQL Azure .
• Experience of working with VMware environments
• Database High Availability: Installed, Configured and Maintained Database Mirroring using automatic fail-over option in SQL Server 2008
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Configured and Maintained Replications
• Configured and Maintained Always on Availability Groups
• Involve in database and log backups and restoration, planning backup strategies.
• Verify backups and error logs on the servers and troubleshoot any failures or alert problems, and open trouble tickets, if necessary, to work with engineer from other departments.
• Schedule jobs and alerts using SQL Server Agent.
• Monitor Servers activity, solving problem SQL Server Error Log, space usage performance tuning
• Assisted SQL developers to optimize SQL queries and Stored Procedures.
• Create T-SQL stored procedures, tables, views, functions, triggers and indexes.
• Involve in tuning, improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
• Use third party tool Red Gate, ensuring all the databases are backing up on the regular basis and then restoring these databases on requests.
• Responsible for securing SQL Server, user management, and taking care of permissions and roles.
• Create reports using Report Builder.
• Work with SSIS package, Bulk Insert, and BCP Utility to import and export operations in and out of the SQL Servers.
• Report Development: Installed, Configured, and administered SQL Server Reporting Services (SSRS)
• Experience with Percona Server/Toolkit
• Configuring multiple MySQL instances/Replication
• Knowledge on performance and fine-tuning MySQL servers.
• Performed Scripting for monitoring the server
• Setting up the cronjob /MySQL Events
• Experience in Importing and Exporting Database Backup.
• Have good understanding on the MySQL internals.
• Experience with MySQL Backups and Restore Scenarios.
• Highly organized, with efficient time, task, and resource management.
• Quick to learn, adjust, and adapt to new environments and techniques.
• Coordinating and interacting with team members and development team.
• Excellent verbal and written communication skills, self-motivated, ability to handle multiple tasks and meet deadlines, able and willing to learn quickly.
•
VACO Inc. AIRGAS Inc Lawrenceville, GA
MS SQL SERVER Migration Feb 2017 to June 2017
• Database Installation and configuration:
• SQL Server 2012, 2014, 2016 (SSRS, SSIS) installation.
• Familiar with different types of error occurred during installation.
• Instant file initializing, proper allocation unit for system drive and other drives.
• Exported data from SQL Server to multiple destinations for sales forecast and other purposes.
• Designed and developed SSIS packages using different control flow tasks,
• Transformations and data flow tasks.
• Perform some testing on how to deploy SSIS packages using PowerShell
• Creating Backup strategies and scheduling them as a part of database maintenance plans.
• Experience in SQL Server / Backup Restore, Migration and having knowledge in
• Manage the SQL Servers using PowerShell
• Manage jobs and respond to failing jobs.
• Take database backup and point in time restores
• Check for the disk space, generate different documentation and reports
• Perform server migration using PowerShell Module Dbatools very powerful stuff.
• Migrating from SQL Server from 2012 to 2014 on standalone and cluster
• Always on Availability Groups setup and maintenance and Troubleshooting
• Involved in Change Data Capture process.
• Applied SP (Service Pack) on SQL Server 2012, 2014and Windows Server (2008, 2014).
• Cluster aware update for windows servers 2012 R2.
• Applied HOT Fixes, Cumulative update on SQL Server (2012, 2014)
• Clustering, Log Shipping, Replication, Always On Availability Groups. and TDE BIRLASOFT Inc. (GE Power and Water, PDS). Atlanta, GA Senior Software Engineer (MS SQL SERVER DBA) Sep 2015 to Jan 2017
• Experience configuring and administrating SQL databases between Azure/On-Premises Database, Synchronization (Data Sync), SQL Server Stretch Database, SQL Server Sharding, Elastic Database, Geo- Replication, Distributed Transactions, Azure Automation
• Worked with AWS technologies like RDS, EC2, S3 Storage, Cloud-watch and Lambda
• Worked with application teams to meet corporate milestones for database consolidation & data migration.
• Implemented Always On, Database Mirroring, including custom-scripted (with some PowerShell) re- configuration of automatic fail-over partners and voting and custom-scripted SQL Server Agent job enabling per primary/secondary status of availability groups (AGs)
• SQL Server Installation and configuration (across all the Environment):
• SQL Server 2005, 2008, 2012, (SSRS, SSIS) installation.
• Familiar with different types of error occurred during installation.
• Perform the installation using PowerShell script
• Exported data from SQL Server to multiple destinations for sales forecast and other purposes.
• Have tested some packages deployment using PowerShell
• Server Monitoring/Performance Tuning:
• Strong knowledge on database Monitoring and Performance tuning.
• Monitor different logs, Space usage, Events, Agent Job history by PowerShell scripts.
• Provide support to application developers in designing and implementing physical database structures.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Managed SQL Server using PowerShell.
• Proactively monitored the production database(s) and optimize stored procedures for better performance. Resolve deadlock, block, and locking conflicts and resource utilization.
• Performance Tuning & Establishing integrated change control.
• Backup/Recovery:
• Idera Backup solution - SQL SAFE. LiteSpeed
• Strong working experience in SQL native database Backup and restore.
• Using OLA maintenance Solution able to automate the Deployment for Multiple server across the environment.
• Disaster Recovery planning and implementation.
• Experienced with Point-in-Time Recovery.
• Planned the Complete Backing up of Database and Restoring the Database from
• Disaster Recovery.
• Data Corruption resolution:
• Take necessary prevention for data corruption.
• Strictly maintain data integrity using DBCC CHECKDB.
• Restoring single page from backup using DBCC write page, DBCC ind.
• Documentation: Prepare different documentation (SQL Server Build Guide, Database Decommissioning steps, restore steps,) and update them in timely manner.
• Technologies used:
• Clustering, Linux, Idera, Replication, Log shipping. PSAV Inc (Remote). Washington, DC
SQL SERVER DBA October 2011 to August 2015
• Database Installation and configuration (Development, QA and Live environment):
• SQL Server 2008, 2012, 2014 (SSRS, SSIS) installation.
• Familiar with different types of error occurred during installation.
• Instant file initializing, Proper allocation unit for system drive and other drives.
• Database Upgraded (Development, QA and Live environment):
• SQL Server 2008 to 2012 and 2014
• SQL Server 2005 to SQL Server 2008, 2008R2
• Server Migrated (Production environment)
• Physical server to VM ware.
• Standalone to Active/passive Cluster (By consuming Old DNS name and IP Address)
• Database Developing and deployment (Change management)
• Written T-SQL, Trigger, and Stored-Procedures
• Assisted application, web and database developers to optimize SQL queries, Stored Procedures, functions
• Maintain a change control process. Guide developers through new SQL code deployment to Dev, QA and Production environment. Tool use - TFS, SQL compare, ServiceNow.
• Database High Availability:
• Create and managed MS SQL Cluster (Active/Passive), Multi node cluster.
• Installed, Configured and Maintained SQL 2012 Database Mirroring (High Safety) using automatic fail- over option (Multi database, Agent Job) for Jennifer (Voice Picking Software for warehouse solution)
• Tools Used: VISIO, SQL Server Data Diagram
• Applied SP (Service Pack) on SQL Server (2008 and 2012) and Windows Server (2008, 2003, 2000).
• Cluster aware update for windows servers 2012 R2.
• Applied HOT Fixes, Cumulative update on SQL Server (2008, 2012, 2014)
• Database Monitoring/Performance Tuning:
• Strong knowledge on database Monitoring and Performance tuning.
• Monitor different logs, Space usage, Events, Agent Job history by PowerShell scripts.
• Provide support to application developers in designing and implementing physical database structures.
• Tune slow running, resource consuming queries by evaluating query execution plan.
• Proactively monitored the production database(s) and optimize stored procedures for better performance. Resolve deadlock, block, and locking conflicts and resource utilization.
• Backup/Recovery:
• Idera Backup solution - SQL SAFE.
• Strong working experience in SQL native database Backup and restore.
• Disaster Recovery planning and implementation.
• Experienced with Point-in-Time Recovery.
• Dealing with Database Corruption:
• Take necessary prevention for data corruption.
• Strictly maintain data integrity using DBCC CHECKDB.
• Restoring single page from backup using DBCC PAGE, DBCC IND.
• Documentation:
• Strong experience in documentation and 24/7 on call production support.
• Encryption:
• SQL auditing. And transparent Data Encryption (TDE)
• Analysis Services (SSAS)
• Created tables and stored procedures in SSMS for the modification of the OLAP
• Created several cubes, dimensions, and business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
PSAV Inc. (Gaylord National Resort) National Harbor, MD Database Analyst (Database Administrator). January 2009 to September 2011
• Work as a Database Administrator in the Information Management System, Responsibilities included:
• Database Upgraded (development, testing and production environment):
• SQL Server 2000 to 2005/2008
• SQL Server 2005 to SQL Server 2008, 2008R2
• Database Migrated (development, testing and production environment)
• Oracle 10gR2 databases to SQL Server 2008
• MySQL 4.1.0/5.0.1 database to SQL Server 2005 and 2008
• Tools Used: SSMA (SQL Server Migration Assistant) for Oracle, MySQL, Access, and ODBC/DB Link
• Database Programming:
• Written T-SQL, Trigger, and Stored-Procedures
• Assisted Database Developers to optimize SQL queries, Stored Procedures etc.
• Tools Used: Query Analyzer
• DTS/SSIS (integration services):
• Import data from multiple sources such as Flat file, CSV file, Oracle, MySQL, Access, ODBC/OLEDB data sources to SQL Server
• Database High Availability:
• Managed MS SQL Cluster (Active/Passive), Multi node cluster.
• Installed, Configured and Maintained Database Mirroring using automatic fail-over option
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Configured and Maintained Replications (Transactional) Technology Used: Clustering, Database Mirroring, Log Shipping, and Replication, Always On
• Administering SQL Server High Availability and Disaster Recovery like log shipping, database mirroring, and Always On . 24 X 7 Production Database on Call Support.
• Report Development:
• Installed, Configured, and administered SQL Server Reporting Services (SSRS)
• Developed, Deployed, and Managed Reports
• Managed Reports Security
• Tools Used: Developed Reports using BIDS (Business Development Studio), and Report Builder 3.0, 2.0
• Patch Management:
• Applied SP (Service Pack) on SQL Server (2000, 2005, 2008) and Windows Server (2008, 2003, 2000)
• Applied HOT Fixes on SQL Server (2000, 2005, 2008) and Windows Server (2008, 2003, 2000)
• Database Monitoring/Performance Tuning:
• Strong on database Monitoring and Performance tuning
• Monitor SQL Server Error Log, space usage, Events, Jobs, customer complaints, Daily routine works
• Tools Used: SQL Server Error Log, Windows Event Logs, Profiler, Query Execution Plan, Index Tuning Advisor, Database Tuning Advisor, System Monitor, Perfmon, Counter etc.
• Backup/Recovery:
• Strong knowledge and working experience in Database Backup and Disaster Recovery
• Experienced with Point-in-Time Recovery
• Extensive knowledge on Restoring Databases using backups PSAV Inc. (Omni Shoreham) Washington, DC
Help Desk Technician April 2007-December-2008
• Maintain and support software loaded on personal computers and LAN
• Interact with users daily with a strong focus on excellent customer service, to facilitate support with any and all aspects of software, hardware, or connectivity.
• Actively participate in disaster recovery plan as it relates to all aspects of the systems department
• Occasional travel between local offices as needed.
• Perform PC and printer installs and moves.
• Facilitate maintenance of all hardware Install
• Assist users in password reset and account unlocking via Active Directory
• Assist customer with Microsoft Outlook and other Microsoft software issues as well as limited web related problems.
• Correctly assign and route ticket in the ticketing queues. Escalate and page according to escalation process.
• Provide customer service and answer computer and non-technical question user may have.
Contact this candidate