Mehghen Njiti

832-***-**** adlyl2@r.postjobfree.com

MSSQL SERVER DBA

PROFESSIONAL PROFILE

DBA with over 6 years of experience as an SQL SERVER Database Administrator. Worked on SQL SERVER 2019/2017/2016/2014/2012/2008 Versions. Work areas include production and development and test support, installation and configuration, backup and recovery, performance tuning, database cloning and refreshes, security, database upgrades and patching, database migration, Always on, clustering, log shipping, Mirroring and replication technologies. Also worked on implementing adequate security measures, backup and recovery solutions which support our work environments RPO and RTO. TOP SKILLS

• HA & DR solutions (Replication, Mirroring, Log shipping, Failover clustering, AlwaysON)

• Database creation and management

• Database maintenance task automation

• Performance monitoring and tuning

• Database security/TDE/Data masking

• Database cloning/ migration / upgrade / patching

• Backup and Restore

• SSIS, SSAS, SSRS

• Microsoft Office / Windows Server / Azure / VMware

• Programming: T-SQL

• Excellent Communication Skills

• Bilingual French and English

PROFESSIONAL EXPERIENCE

SQL SERVER DBA

SUBARU AUTOMOTIVE Nov 2019 - Present

• Experience in implementing, designing, developing and maintain SQL server environments both DEV and PROD

• Installation and configuration of SQL SERVER 2008&R2, 2012,2014,2016,2017 and 2019 in both UAT/DEV/PROD servers

• Perform and monitoring daily task such as Backup & Restores, maintenance jobs, handling developers requests and user's permission.

• Managing database level security on all instances, including creating and managing logins, database users and user permissions.

• Implementing and Maintenance of all (HA) High Availability configurations like Replication and Failover Clustering as a part of HADR Plan.

• Setup Linked Servers, which allows access to the distributed, queries against OLE DB data sources for EXCEL, MS ACCESS and Text files and running the Batch Processes, dataflow from server to server

• Monitor disk configuration and storage allocation to support application enhancements.

• Conducting weekly Database Refreshes from Prod to Dev and Test or per Application team's request.

• Identifying the usage of Old SQL servers (SQL 2000, SQL 2005), Migrate/Upgrade the databases to higher versions based on Application compatibility and planning to Decommission.

• Knowledgeable in T-SQL Development skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Queries.

• Monitor server capacity and make recommendations for hardware upgrades or add-ons (E.g. processors, disk space and memory) to accommodate current and planned server usage,

• Deploy SSIS packages in SQL servers and Configured the jobs using those SSIS packages based on user requirements using dedicated Proxy accounts.

• Migrating databases and DB Objects between DEV, QA and Prod environments using Export/Import wizard and/or Generate Scripts. Setup & configure Server and Database properties and various options

• Review performance stats and recommend changes for Database Tuning, Query Optimization, Diagnosing & fixing SQL performance issues.

• Maintain application performance & scalability with a focus on (PTO) Performance Tuning & Optimizing SQL queries, table design, indexing, query plan analysis, databases & SQL servers

• Create alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breaches.

• Setup Database Security and maintain accounts and access levels by creating suitable Logins and Roles and assigning object level permissions.

• Schedule weekly Maintenance tasks for better performance, created alerts with Database Mail SMTP.

• Configure Database Maintenance Plans for Backups, Re-indexing, and Reorganization of Indexes, Clean up History, and Update Statistics.

• Used 3rd party tools like COHESITY for backup and restore, SOLAR WINDS and REDGATE for performance Tuning

• Creation of DB2 tables, Database, Deploying stored procedures, catalogue, alias, table spaces. Environment: MS SQL Server 2019/2017/2016/2014/2008R2/2005, T-SQL, SSIS, SQL Profiler, Log Shipping, Always on, Mirroring, Clustering Windows Server 2012R2 and Windows Server 2008R2, PowerShell, MS DOS, SharePoint 2010, VMware, solarwind, Redgate,etc.

SQL SERVER DBA

PROS INC

Houston – TX June 2017- Sept 2019

• Expertise in installing, configuring, planning, testing MS SQL Server 2016, 2014, 2012, 2008R2, 2008, 2005 and associated database tools, updating with latest service packs, hot fixes, and security patches. Successfully implemented Capacity planning for different servers.

• Experience in creating Maintenance plans for backups, indexing and database integrity check, update database stats using SQL server native tools and OLA Hallengren’s scripts.

• Experience in different types of backups, restoration of the database and using SQL Server agent to schedule jobs and Maintenance Plans and set Database Mail settings for notifications or alerts.

• Experience in conducting Performance Tuning, Query Optimization and Client/Server Connectivity, Database health Check, Indexing and Updating Statistics etc. Extensively used the native tools like Index Tuning Wizard or Database Engine Tuning advisor, SQL Profiler, Performance Monitor, Activity Monitor, DMV’s, SQL server error log and Event viewer for performance analysis and fix any performance related issues, ensuring optimum performance.

• Troubleshoot Blocking and Deadlocking issues by making appropriate changes to Transaction Isolation levels and the types of locks being held and avoid keeping transactions open for long durations after completion depending on app logic, breaking large transactions to smaller ones.

• Expertise in troubleshooting SQL Server Agent jobs, Error Logs, Windows Logs to resolve failure job component.

• Experience in Implementing Side by Side Migration and in-place upgrade of MS SQL SERVER. Implement database migration from SQL SERVER 2008 to 2012 and from 2012 to 2016 using best practice and troubleshooting related issues post migrations

• Strong experience in mentoring with team members, documentation and 24/7 on call production support.

• Excellent Problem-Solving Skills, Communication, presentation, and interpersonal skills. Strong troubleshooting and organizational skills.

SQL SERVER DBA

Samsung

DALLAS - TX March 2014 - May2017

• Day-to-day DBA responsibilities for backups, server uptime, performance tuning and optimization of code developed by developers.

• Performance tuning of slow running queries and providing timely advice on Indexes and query logic.

• Deployment, administration and operational support of production, development and test environments utilizing proper change management and other ITIL best practices using the ticketing tool Service Now.

• Comprehensive experience utilizing VMware technologies in the deployment of mission critical SQL Server environments

• Deploying Service Packs and hot fixes for SQL Server as per deployment schedule.

• Involve in change review meeting to discuss database changes before rolling them out after approvals and troubleshooting and application issues dues to change rollout.

• Implemented different types of Replication Models like Snapshot, Transactional and Merge.

• Proficiency in developing Maintenance plans, backup, recovery strategies and Rebuild/Reorganize strategies.

• Reviewing and verifying Database backup details, Database user privileges, Inactive user accounts

• monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.

• Created Jobs and maintenance plans for better performance of the server some of the jobs include index rebuild/reorgs, DBCC check, update database stats, database clean-up and other SSIS packages to help with data migration. Used Database Consistency Checks – DBCC Commands for database maintenance.

• Experience in managing database security by creating logins, users, groups and assigning them just the required privileges.

• Also, experience implementing database audits and reviewing audit logs in case of any database security abnormalities.

• Supported a 24/7 on call rotation database infrastructure and a very willing team player PROFESSIONAL DEVELOPMENT

UNIVERSITY OF BUEA

Bachelor’s degree in banking and finance 2014

MCDBA (Microsoft Certified Database Administrator) certified 70-764 Administering a SQL Database infrastructure certified 70-765 Provision SQL Databases certified

Contact this candidate