Home

Mohammed Madani - SQL DBA

[email protected]

Location: Aurora, Illinois, USA

Relocation:

Visa: GC

M. Madani + 1(815) 916 9799 [email protected] Professional Summary: 12 years of experience as a SQL Server Database Administrator/Developer Proficient in T-SQL and the creation/modification of Database Objects such as Tables, Schemas, Synonyms, Stored Procedures, Views, Triggers and Functions, Indexes as well as the use of Cursors Extensive experience with Schema Design, Clustered and Non-Clustered Indexes, and Normalization and De-normalization techniques Well-versed with the Installation, Configuration, Maintenance, Upgrade and Patching of different versions and editions of SQL Server Experienced in System Analysis, Design, Development & Support of SQL Servers 2008, 2008R2, 2012 and 2014 in Production and Development Server Environments Solid experience with the design and implementation of Relational Databases and sufficient understanding of Multidimensional Database Design Concepts Experienced with Disaster Recovery implementations including Backup &Recovery, Log Shipping, Mirroring and Failover Clustering Experienced with the implementation of High Availability approaches including Replication and Always On Availability Groups Well-versed in creating Maintenance Plans to Update Statistics, Defragmentation of Tables and Rebuilding and Reorganizing of Indexes Experienced with configuring Databases in the Cloud Environment using Microsoft Azure Proven track record with Data Migration tools such as SSIS including the development, deployment and monitoring of SSIS Packages Solid understanding of SQL Server Security and Active Directory integration Knowledgeable in the Principle of Least Privilege. Extensive experience with Creating, Configuring and Automating Jobs, Alerts, SQL Mail Agent Demonstrated proficiency with Performance Tuning and Database Optimization Techniques by using SQL Server Tools such as Profiler, Extended Events, Activity Monitor, Tuning Adviser, Query Analyzer, Execution Plans, Trace Flags, Statistics and Index Tuning Wizard Experienced with Data Warehousing, Data Mining and Data Purging Experienced with creating Linked Servers and working with Data from multiple sources Seasoned in supporting Very Large Databases (VLDB) and troubleshooting various problems Knowledgeable in designing and implementing reports using SQL Server Reporting Services (SSRS) Solid understanding of High Availability/Disaster Recovery(HA/DR) Principles Education Bachelors in computer science 2012 Technical Experience Summary Databases: MS SQL Server 2008/R2/2012/2014, MS Azure, Sybase 11.0/ASE 11.5 SQL Server Tools: Management Studio, Visual Studio 2005/2010/2013, SSDT, Enterprise Manager, Query Analyzer, Profiler, Extended Events, Performance Monitor, DTS, Database Tuning Wizard, Index Tuning Wizard, SSIS, SSRS, Microsoft Clustering Services Programming Languages: T-SQL, Visual Basic, HTML Data Modeling: ERWIN, ER Studio, MySQL Workbench Reporting Tools: Crystal Reports, SSRS Version Control: Team Foundation Server, GitHub, Operating Systems: Windows Server 1995/2000/2008/2012 Software: Oracle VM Virtual Box, Jira, RedGate (Backup tools, Data compare tools), Apex SQL, IDERA tools, Rational Automated Testing Products Professional Experience EATON Corp, Cleveland,OH SQL Server Database Administrator Jun 2020 Present Responsibilities: Create and implement Database Design Solutions and involved in Data Modeling, Designing and Building Relational Databases Perform day-to-day DBA activities such as monitoring SQL Server health, job status, addressing user requirements and responsible for troubleshooting all SQL Server Database Proactively monitor the Database health through automated scripts to check the Database and Extents growth, probing the alert log files, monitoring the rollback segments and temporary space usage Setup of SQL Server AlwaysOn Availability Group and AlwaysOn Failover Cluster Instance (FCI) Administer Production Backend Databases for the web applications and provide 24x7 dedicated Production support for SQL Server problem resolutions Design and create Database Objects on SQL Server 2008R2, 2012 and 2014 Implemented Transparent Data Encryption (TDE) for data sensitive databases. Design and implement a comprehensive Backup Plans and Disaster Recovery strategies Configure and implement Database security processes and Maintenance Plan for all Databases Create and configure SQL Server Mirroring process for High Availability Create Server Audit and Database Audit Specification Participate in weekly change management meetings to review scheduled deployments Plan and coordinate the Data Migration between Databases across the organization Implement Monitoring Processes for all the jobs in the Test and Production Environments Deploy and maintain SSIS packages for the ETL processes Petsmart / Naperville, IL SQL Server Database Administrator/Developer Feb 2017 May 2020 Responsibilities: Provided 24x7 Production support for SQL Server problem resolution and server outages Installed, Configured and Managed SQL Server 2012, 2008R2& 2008 in Dev, Test, and Prod Environments Export/Import data from Flat files to/from SQL Server, Oracle and My-SQL using DTS, BIDS/SSIS, BCP Created and Maintained data models for more than 10 Data Modeling Projects Recommended and Implemented best practices for Database security. Involved in moving Databases from on-premise server to Microsoft Cloud Platform (Azure) Experienced in managing and creating SQL Azure Databases through Windows Azure cloud portal. Strong on Database Monitoring and Performance tuning - Monitored and optimized system performance using SQL Profiler, Extended Events and Database Engine Tuning Advisor and optimized T-SQL query performance using Execution Plans and DMVs Scheduled Jobs to automate different Database related activities such as Backups and Backup Verifications, Monitoring Database Health, Disk Space Strong knowledge and working experience in Database Backup and Disaster Recovery Experienced with Point-in-Time Recovery Restored Databases from disk backups and experienced with performing Tail-Log Backups when it required the Restoration of the Databases to their Point of Failure Direct Edge Jersey City, NJ Jan 2015 Jan 2017 SQL Server Developer Responsibilities: Set up SQL Server Log shipping for databases from 2012 and 2016. Transparent Data Encryption on SQL Server (TDE). Migrating on-premises SQL Server databases to AZURE SSIS data cleansing and data cleaner for databases from 2012 and 2014 Developing tasks and notifications for weekly and monthly upkeep. Assisted in troubleshooting and resolving difficulties for all daily backend production jobs. Facilitated data replication between the reporting infrastructure and the main production SQL servers. Analyzing the logs and keeping an eye on the SQL Server and application logs. Keeping the production and development servers in sync. Data mapping, index tweaking, performance monitoring, and database optimization. Using transactional replication and snapshot replication to copy and distribute data, Planning for capacity and building new databases for various applications. Offer SQL Application Developers round-the-clock assistance in putting the application. Charles Schwab CO Apr 2013 Dec 2014 SQL Server Developer Responsibilities: Using the ERWIN tool, logical and physical data models were created. Designed SQL Servers employ the silent install method, which makes it simple and quick to install SQL Server on numerous nodes. Created databases on Target Cloud platform (Platform as a service), virtual machines, and physical machines. Organizing database attributes according to their surroundings. Added SCOM, the Legato Backup Monitoring tool, to every server and developed a productive way to keep an eye on backup failure notifications. Using security solutions from third parties, we created robust security procedures in both production and non-production environments. Users were granted user security based on appropriately specified roles in order to minimize manual labor. Developed dacpac tools to facilitate quick code releases. Deployed normal maintenance packages using this manner. Added a mechanism for building and overseeing indexes to the platform. IT Mind services Hyderabad, India MAY 2012 Jan 2013 SQL Server Developer. Responsibilities: Responsible for Asset Management, proactive risk management on all properties and identifying ways to increase equity and cash flow Researched properties and market conditions to determine the highest Return on Investment. Responsible for locating potential investment properties and handled all aspects of the process from negotiation to settlement closing Negotiated with, hired and managed vendors and contractors for supply and services need for rehabilitation Preserved a close relationship with Clients, Investors and Business Partners to ensure business growth Responsible for bookkeeping, receipts management, invoice management, cash flow management, financial statement preparation and tax document preparation to hand off to accountant. Keywords: information technology microsoft Colorado Delaware Illinois New Jersey Ohio