Mohamed Mydeen
Plymouth,MN
Summary
Highly accomplished and results-driven Senior Database Administrator with 12+ years of progressive experience in designing, implementing, and managing complex, high-performance database environments. Proven expert in multi-platform database migrations (on-premises to PostgreSQL, MongoDB on Google Cloud Platform), advanced automation, and supporting the latest SQL Server versions up to 2022. Adept at optimizing database systems for mission-critical applications, ensuring 24x7 availability, robust security, and disaster recovery readiness across global retail and healthcare sectors. Skilled in developing and implementing automated health check solutions, significantly enhancing proactive monitoring and operational efficiency. Seeking to leverage advanced architectural and troubleshooting skills to drive strategic database initiatives and innovation. Systematic Database Developer with 10 years of experience in designing, engineering architecture and data modeling. Proven track record managing all phases of software development lifecycle (SDLC). Analytical thinker quickly and effectively identifies and resolves technical problems. Driven Database Architect with 12 years of experience in full lifecycle development. Goal-oriented team player succeeds working with various colleagues and clients by maintaining communication. Motivated with keen analytical, problem-solving and task management abilities.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Senior Database Administrator
Ford Motor Company
03.2021 - Current
- Senior Database Administrator at one of the largest automobile manufacturer FORD in US and performing all day-to-day aspects of MS SQL Database Administration. Responsibilities include database design, installation, configuration, migration, upgrades, security, performance monitoring and tuning, database high availability, backup and recovery, troubleshooting and problem resolution.
- Managing 5000+ Production, Development, QA, and Test SQL Servers in Virtual and Physical Environments
- Installing and configuring of SQL Server 2008, 2008R2, 2012, 2014, 2016, 2016,2019 and 2022 database creations.
- Migrate SQL server databases from 2005/2008/2008r2 to SQL 2012/2014/2016,2019 and 2022.
- Creating and Auditing of SQL Logins and Roles as a part of Security Policies for various categories of User Access.
- Installing and maintaining SQL Active/Active and Active/Passive clustering for high availability.
- Installed and configured SQL Server Reporting Services (SSRS). Providing access to SSRS and URL.
- Deploying and Monitoring SSIS Packages on SQL Server to populate data from various data sources, creating packages for different data loading operations for applications.
- Upgrading SQL Server 2005 to SQL Server 2008/2008R2/2012/2014/2016, 2019 and 2022 which include installation of SQL Server.
- Creating linked servers from SQL to other RDBMS like Oracle, Teradata, and other external sources like Excel.
- Making connections to Teradata in SSIS packages and creating DSN to Teradata.
- Migrating cubes and cube databases for SSAS servers.
- Configuring report server and report manager on website.
- Patched server with latest SQL Server service packs and Cumulative updates.
- Managing DB Maintenance Plans and DBCC utilities and fixed data corruption in User databases.
- Worked with incidents, change management and requests from customers.
- Using DBCC commands to check physical and logical consistency of the databases.
- Created and managed schema objects such as tables, views, indexes, procedures, and triggers.
- Responsible for Backups, Restore and Monitoring on databases as primary DBA role.
- Performed Server & Application fine-tuning & troubleshooting.
- Scheduling the backups for Databases and Transaction logs using SQL native Backups, Tivoli, TDP, Cohesity and Veeam.
- Designed and implemented comprehensive Backup plans.
- Identifying and tuning bottlenecks, long running queries, blocking and dead locks with DMVs, profiler, Counters, Query Tuning, and Index Tuning.
- Provide 24x7 support for critical production systems.
Database Administrator
Constellation Brands Inc
10.2019 - 03.2021
- Database Administrator at one of the large liquor import companies (Constellation Brands Inc) in US and performed all day-to-day aspects of MS SQL Database Administration. Responsibilities include database design, installation, configuration, migration, upgrades, security, performance monitoring and tuning, database high availability, backup and recovery, troubleshooting and problem resolution.
- Installed and configured edition of SQL Server 2008,2012 and 2016 like Enterprise edition.
- Migration of databases from SQL Server 2000/2005, 2008 to SQL Server 2012 and 2016.
- Successfully migrated from SQL Server 2000/2005, 2008 to SQL Server 2012 and 2016 on Production, Development and Testing Environment.
- Installed stand-alone and clustered SQL Server 2012 and 2008 R2 on 64-bit systems.
- Performed in-place upgrade from SQL Server 2008 to 2008R2
- Involved in designing of Conceptual Logical Model and Physical Model.
- Experience working on database migration.
- Assisted management with database and resource capacity planning.
- Experienced in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, and security issues.
- Worked actively on the Clustered Environment.
- Have extensive operational background in establishing and implementing operational standards for installing and maintaining/patching SQL instances
- Establishing and implementing DB monitoring, DB backup/recovery, access management, performance troubleshooting, DB upgrades, DB migrations, test, and validation in a large-scale enterprise implementation.
- Management in DB technical and organizational trends and strategies to deliver more secure, stable, and cost-effective DB Service to the client.
- Providing shift-based work models to SQL application developers in implementing the applications on production server.
- Disaster Recovery Plan, Testing and analyzing and continuous update of documentation.
Database Administrator
Change HealthCare
03.2019 - 09.2019
- Database Administrator at one of the leading healthcare (Change HealthCare) companies in US and performing all day-to-day aspects of MS SQL Database Administration. Responsibilities include database design, installation, configuration, migration, IIS configuration (Web, APP and File server), upgrades, security, performance monitoring and tuning, database high availability, backup and recovery, troubleshooting and problem resolution.
- Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
- Experienced in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity and security issues.
- Experienced in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
- Ability to detect and troubleshoot SQL Server related CPU, memory, I/O and disk space. Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring and Replication
- Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
- Refine and automate regular processes, track issues, and document changes
- Provide 24x7 support for critical production systems.
- Perform scheduled maintenance and support release deployment activities after hours.
- Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
Database Administrator
Target Corporation
10.2013 - 02.2019
- Database Administrator at one of the leading retail stores (Target) in US and supported 8000+ SQL database servers with 180+business applications across different regions.
- Installation and configuration of SQL 2005/2008/2008 R2/2012/2014 and 2016 servers.
- Working on SSRS and configured SSRS.
- Database creation and configuration.
- Maintain SQL server security.
- Troubleshooting client connectivity issues.
- Have done SQL installation documentation on SQL 2005/2008/2008 R2/2012/2014 and 2016.
- Applied service packs on SQL servers
- Participating in upgrading SQL server from 2000/2005 to 2008 and 2102 to 2016.
- Backups and restorations.
- Used several SQL Server DBCC command, DMV’s and System Procedures for database performance monitoring and tuning activities
- Configure and troubleshoot all Issues related to AG, Log Shipping, and Mirroring.
- Moving databases from one place to another place within the server.
- Perform KB patching and troubleshooting on OS/Database level.
- Find the index fragmentation and rebuild the indexes.
- Working on 24/7 production support
Junior Database Administrator
Tata Consultancy Services
01.2011 - 08.2011
- Responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications.
- Understanding the client’s business functionality.
- Configuring, Scheduling, Monitoring, Testing and troubleshooting any database maintenance issues.
- Monitoring the databases and optimizing database performance including DB tuning.
- Query tuning and providing the report to optimize the query.
- Refreshing the Test, Development and Training environments from Production through scripts.
- Managing Users, Profiles, Privileges and Roles.
- Upgrade, Migration (Hardware and database) and applying software and security patches as per application requirements and bug fixes.
- Troubleshooting, analysis and resolution of various database errors and issues by closely working supporting team.
- Daily monitoring the data replication and resolving the data error.
- Generate reports on disk space on each server on a regular basis, to keep track of growth.
- Configure E-mail alert for the job failure and notify the monitoring team.
- Automatic service starts of services which are failed, which were automated with PowerShell Scripts.
- Generate reports for the database growth and the data file size in an automated E-Mail.
- Having good experience in configuring backups, restore and DB refresh.
- Responding and resolving problem tickets of different priorities in time periods stipulated by the Service Level Agreements.
- Ensuring high-level of customer satisfaction by timely resolution of problems reported by the business users.
- Work on the improvement and problem management tickets, to reduce the tickets flow.
- Optimized the database by creating various clustered, non-clustered indexes and indexed views.
- Troubleshooting of site issues, DB Performance issues and long running queries.
- Planning, implementation and support of database backup, database recovery and disaster recovery policies of databases in a highly availability environment.
Education
Bachelor of Engineering - Computer Science
Anna University
Chennai08.2010
Skills
- Database: SQL Server 2005/2008/2008 R2/2012/2014/2016/2019/2022,Oracle,Postgresql, Mongo DB and GCP spanner
- Server Operating system: Windows 2003 / 2008 / 2008 R2 /2012 R2 / 2016 / 2019
- Software Packages: MS-Office, MS-Office 365
- Monitoring Tools: Perfmon, Event viewer, SCOM and ServiceNow
- Performance Tools: Dynatrace, SolarWinds DPA, SQL Server Profiler, Database Tuning Advisor
- Backup Tools: Cohesity, Tivoli, TDP, Veeam, Legato
- Solutions Accelerator: BMC ITSM Suite, Request Center, SMART IT, IT Connect
- High Availability: Replication, Database Mirroring, Partition Tables, MS Cluster Server, Always On
Certification
- MCTS 70-432 - Microsoft Certified Technology Specialist
- ITIL - Information Technology Infrastructure Library V3 Foundations.
Timeline
Senior Database Administrator
Ford Motor Company
03.2021 - Current
Database Administrator
Constellation Brands Inc
10.2019 - 03.2021
Database Administrator
Change HealthCare
03.2019 - 09.2019
Database Administrator
Target Corporation
10.2013 - 02.2019
Junior Database Administrator
Tata Consultancy Services
01.2011 - 08.2011
Bachelor of Engineering - Computer Science
Anna University
Similar Profiles
Erica Cobb SchippersErica Cobb Schippers
Senior Software Engineer, •Senior Java Developer at Ford Motor Company, Ford Motor CoSenior Software Engineer, •Senior Java Developer at Ford Motor Company, Ford Motor Co
Zsuzsanna Pragerne DveriZsuzsanna Pragerne Dveri
Plant Manager's Executive Assistant, HR Associate at Ford Hungary Ltd - Ford Motor CompanyPlant Manager's Executive Assistant, HR Associate at Ford Hungary Ltd - Ford Motor Company
Melroy DsouzaMelroy Dsouza
Software Engineer at Ford Motor Company, Ford GmbhSoftware Engineer at Ford Motor Company, Ford Gmbh
ARUN KUMAARARUN KUMAAR
Manager at Ford Motor Company, Ford International Markets GroupManager at Ford Motor Company, Ford International Markets Group
Joy NguyenJoy Nguyen
Nail Technician at Excelsior Nails & Day SpaNail Technician at Excelsior Nails & Day Spa