MOHAMMAD SHAHID PEER
Database Administrator/Data Engineer
Abu Dhabi
Summary
- Experience in Database Administration, Design and Support of MS SQL Server (2008-2019), Oracle
- . EBS in Production, Postgres SQL Test, Development environment Systems Expertise in Server Configuration, Performance Tuning and Maintenance with Outstanding
- . troubleshooting capabilities Experience on High Availability / Disaster Recovery (HADR) solutions; Failover Clusters and
- . Always on Availability Groups, Replication, Log Shipping and Mirroring Experiencein Upgrade/Downgrade/Migration of MS SQL Server 2008 to MS SQL Server 2008R2
- . from SQL Server 2012 and SQL Server 2014. Patching,Cloningand Administering Concurrent Managers in Oracle EBS Systems
- Experience ience in working with application team and implemented databases as per the specification cation
- . from application owners / client Exper ienced in Backup and Restore procedures (Manual, EMC, Veeam Backup Solutions), Quer y
- . Optimization and Security Monitoringthe health and performance of SQL Servers as well as in-house applications using SQL
- . Server native tools and several other third-party solutions . Adept at -SQL, stored procedures, tables, indexes, views, functions and triggers
- . Create various SSIS and SSRS packages to serve company needs
- Expert in using Extended events / Perfmon/ SQL Profiler/ Scripts and other third-party tools to
- (resolve bottlenecks, deadlocks and slow running queries (Index tuning & Defragmentation). Able to benchmark and load test new instance builds for performance with DB load simulators
- . Responsible for securing SQL Server , User management and Log explorer for MS SQL Server
- . StrongSystemAdministration background in Windows and Linux environments
- Experienced wi th Development/ Test/ Production / QA which included documentation
- Of processes, creation of test scenarios and execution of tests, via T-SQL scripts to ensure UI . standards met the required specifications Well versed with the Physical (Pages, extents, files, filegroups space allocation) and Logical design
- (.components (tables, triggers, views, keys, etc.) Creating technical documentation and process archiving and change management
- . Experienced working independently as well as in team - oriented environments
- . Supported SMS application OZEKI NG SMS integrated with MS SQL SERVER Database
- . Migrated Oracle database 1 TB to SQL Server using SSDT and SSIS service on Client projects
- Collaborating with System Architects, Information technologists, Project / Service Managers and
- Other staff members regarding data storage practices, network operation, and other server related. incidents and requests Improved the Query Execution Time by 80% by creating the appropriate indexes on the database
- . tables resulting in soft parse reads Wellexposure to Cloud platform Applications, build images on Amazon Cloud Services and creates
- . databases on Microsoft Azure Cloud
Overview
19
19
years of professional experience
Work History
Database Administrator/DB-Architect
IDMPS/Omnix International
Abu Dhabi
12.2022 - Current
- Supporting and Administering Microsoft SQL Server, Postgres Databases
- Experience in configuring High Availability and Disaster recovery Solutions
- Implemented a heterogeneous HADR solution for High performance and Availability of the databases
- Performance tuning including Index tuning (reorganizing, rebuilding in cases like Fragmentation)
- Experience in Migrating the on-premises databases and instances
- Troubleshot database and connectivity issues, enabling application development team to resolve application-database connectivity challenges
- Automated day-to-day operations and critical SQL Server alerts, streamlining repetitive tasks to enhance operational efficiency
- Monitored the health and performance of SQL server instances and applications using Extended Events
- Managing the database projects from design to go live phases
- Establishing best practices and standards, enforcing the security mechanisms
- Installation of Microsoft SQL Services on Standalone and Multi Node environments
Database Administrator
Tech Mahindra/ ENEC
Abu Dhabi
09.2021 - 12.2022
- Administering Microsoft SQL Server Databases and Oracle databases.
- Installation of Microsoft SQL Services on Standalone and Multi Node environment (Log Shipping, Mirroring, Failover Clustering, Always On availability) High available Solutions.
- Managed capacity and implemented backup and restore procedures to ensure data integrity.
- Delivered DR and high availability solutions for large-scale database migrations.
- Performance tuning including Index tuning (reorganizing, rebuilding in cases like Fragmentation)
- Created and migrated partially contained databases within Always on Availability Groups.
- Created Automation of day-to-day operations, critical SQL server alerts and repetitive tasks.
- Established best practices and enforced security standards to safeguard database environments.
Database Architect
GBM
Dubai
09.2020 - 01.2021
- Providing SQL Server implementation changes requested from application and DEV teams.
- Installed, configured, and maintained SQL Server according to supported LOB applications.
- Writing and improving SQL Server T-SQL queries.
- Created T-SQL scripts, stored procedures, tables, views, functions, triggers, and indexes to support application functionality and optimize performance.
- Developed disaster recovery and high availability solutions, managing large-scale database migrations to ensure minimal downtime and data integrity.
- Created and migrated partially contained databases within Always on Availability Groups.
- Automated day-to-day operations, critical SQL Server alerts, and repetitive tasks, streamlining processes and enhancing response times.
- Monitored the health and performance of SQL server instances and applications using Extended Events, SQL server Profiler, Perfmon and other third-party tools.
- Operated and oversaw database and log backups and restoration, planning backup strategies.
- Verified backups and error logs on the servers and troubleshot failures and alert problems.
- Installed, configured, and maintained SQL Server Failover Clustering and Always On for production environments.
- Worked with Installation, configuration and creation of SSRS, SSAS, SSIS, SSDT, SSMA.
- Deciding whether clustering, log shipping, mirroring, replication, always on are the right fit to solve a business problem.
- Secured SQL Server and managed user permissions and roles.
- Worked with capacity planning, database sizing and monitoring.
Database Administrator/DB- Architect
Sundus Recruitment Services, Trust Technical Services (INJAZAT DATA SYSTEMS, Mubadala Company)
Abu Dhabi
08.2015 - 04.2020
- Administered MS SQL Server databases and configured HADR solutions.
- Implementing Backup Solutions and Strategies, making sure backup is consistent and backup up regularly to prevent data loss, Database recovery and configuring different recovery models.
- Saved licensing costs by 40% through downgrading SQL Server and migrating databases from Enterprise to Standard versions upon management approval.
- Upgraded and migrated SQL Server lower versions databases to higher versions as per client requests.
- Developed checklists for proper and unattended installation of SQL Server, including application of service packs and security fixes.
- Created database maintenance plans for SQL backups, optimization and integrity check and TLOG backups.
- Taking the lead responsibility in Data Migration, migrated databases on the same database software versions and also good exposure in performing cross platform database migration.
- Migrated IBM DB2 databases using SSIS and stored procedures to ensure data integrity.
- Created packages using SSIS to import and export operations in and out of SQL Servers.
- Maintained SQL Server database security through server hardening and user auditing, analyzed and diagnosed incidents and requests logged via ticketing tool, and created root cause analysis reports detailing incidents.
- Leading Database Projects, coordinating with internal resources and third parties/vendors for the flawless execution of projects.
Senior System Analyst
AL KHAYAT INVESTMENTS LLC
Dubai
04.2014 - 07.2015
- Administering MS SQL Server, Oracle Databases & Oracle ERP Applications on Sun Solaris and Windows OS.
- Applying Patches in DEV/TEST and Production Instances.
- Resolving Database and ERP Application incidents and Requests.
- Measuring the database performance through OEM, AWR, Profiling, ADDM utilities.
- Enhanced system performance by establishing baselines and monitoring parameters and query response time.
- Evaluating server/instance architecture, hardware, system specifications and capacity planning.
- Documented configurations and procedures with Linux scripts for scheduling Cron jobs, ensuring clarity and consistency.
- Mentoring the junior staff and training them on the 3rd party tools and Application Utilities.
- Coordinated with end users to schedule concurrent requests and adjusted specific request timings to balance system load during peak periods.
Database Administrator
SYSTEM CONSTRUCT LLC
Dubai
03.2011 - 04.2014
- Administering and Maintaining Oracle Databases and ERP Applications.
- Automated daily backup/restore processes, implemented batch jobs to automate maintenance tasks.
- Created and managed DB maintenance plans, designing and implementing backup strategies.
- Diagnosed performance issues using STATSPACK, AWR, ASH, ADDM, and collaborated with developers on query optimization.
- Define and enforce database standards, policies, security and documentation.
- Upgrading databases and database objects, including logins, stored procedures, and jobs.
- Established and enforced security auditing mechanisms while performing tuning and optimization.
- Preparing current dB structure and configuration for high-performance through analysis and optimization.
E-Biz Analyst
TEMENOS
Chennai
01.2009 - 03.2011
- Administering and Support for Oracle Databases and Oracle Applications ERP on Sun Solaris Operating System platform, creating and managing users and responsibilities.
- Patched Oracle applications (one-off, CUs, RPs) across all user environments (Dev, Test, Prod) to ensure system reliability.
- Resolved database and ERP application issues, including tablespace, mount point, locks, and concurrent managers, to maintain operational continuity.
- Cloning Oracle Application and Databases, performing weekly DB refreshes upon user requests.
- Monitored system performance and configured Discoverer, resolving connection issues to improve data accessibility.
- Performed Space Estimation and Calculation, Performance/Memory tuning.
- Implemented SUN JRE NATIVE PLUG-IN in existing Oracle Applications Framework.
- Installed Primavera P6 Application for Project Planning team and used Oracle 10g database as backend.
Database Administrator
GENISYS SOFTWARE
Bangalore
07.2007 - 05.2008
- Installation, Configuration and Administration of Oracle 9i and 10g databases.
- Implementation and Administration of Oracle EBS ERP Applications 11i Technology Framework.
- Supported and monitored database and ERP applications to ensure optimal performance and availability.
- Resolving complex database issues, and optimizing performance.
- Directed tasks, reviewed and implemented change requests.
- Created, configured, optimized and maintained databases and repositories.
- Managed database backup and recovery processes.
- Tuned database systems to resolve performance issues related to SQL query execution, OS memory, SGA allocation, I/O, network delay, and indexing.
- Monitored system alerts to identify issues promptly.
- User Management and assigning roles in ERP applications.
- Managed space issues including tablespace and disk capacity to maintain system stability.
Education
Masters in Computer Applications - Computer Applications
Indira Gandhi University
India06-2007
Skills
- Microsoft SQL Server
- Oracle EBS R12
- Oracle 10g
- Oracle 11g
- Oracle 12c
- SQL
- T-SQL
- PL/SQL
- MYSQL
- Database admin
- Database design
- Database support
- Database oversight
- Schema management
- Index management
- Query optimization
- Performance optimization
- Backup recovery
- Data migration
- High availability
- Relational DB management
- Data security
- Cloud databases
- MS SQL SERVER 2008-2019
- SSIS
- SSRS
- SQL DEVELOPER
- TOAD
- SQL LOADER
- DATA LOADER
- EMC NETWORKER
- Oracle 12c
- WINDOWS 2008
- WINDOWS 2012
- UNIX
- Red hat LINUX
- SOLARIS10
- Docker
- Kubernetes
- AWS
- S3
- EC2
- RDS
- IAM
- Microsoft Azure
- Data lakes
- Apache Spark
- JAVA
- C
- PYTHON
- Shell
- HTML
- Putty
- HPOM
- HOBBIT
- WEB ADI
- LANDESK
- VDI workspace
- Ticket management
- Team collaboration
- Problem solving
- Root cause analysis
- Capacity management
- Patch management
- Index management
- Database design
- Relational DB management
- Database oversight
- Root cause analysis
People Skills
- Logical and Analytical approach for Problem Solving
- Conflict Resolution and Team Collaboration Skills
- Problem Solving & Conflict Resolution
- Communication and Interpersonal Skills
- Leadership and Decision-Making Skills
- Roadmap Strategic Planning and Execution
- Cost and Resource optimization
- Resource Planning & Utilization
- Continuous Learning & Mentoring
- Result Oriented and Positive Approach towards desired outputs
Passport Expiry
04/06/27
Languages
- Hindi
- Urdu
- English
- Hindi
- Urdu
References
Available on request
Summary
Experienced Database Admin/Architect having 16 plus years of experience in Managing Applications and Databases, Designing High Available and Disaster recovery Systems. Well exposure to Business domains (Construction, Banking, F&B, Pharma, Hospitality and Information Technology). Proficient in working with all levels of Business stakeholders in requirement gathering, analyzing and documenting Business requirements to provide the desired outputs., MS SQL SERVER 2008-2019, Oracle 10g, 11g, 12c, MYSQL, WINDOWS NT/2008/2012/2014, UNIX/Red hat LINUX, SOLARIS10, Oracle EBusiness Suite 11i/R12, SharePoint 2013, SQL, TSQL, PL/SQL, JAVA, C++, PYTHON, Shell, HTML, SQL LOADER, DATA LOADER, SSRS, SSMA, SSMS, SSIS, RMAN, PROFILER, HPSM, HPOM, PUTTY, SQL DEVELOPER, TOAD, EMC NETWORKER, MYSQLDOC SPOTLIGHT, HOBBIT, WEB ADI, LANDESK (Unified Endpoint Mgmt.), VDI workspace, DBFIPM, Docker, Kubernetes, AWS, S3, EC2, RDS, IAM, Microsoft Azure, Data lakes, Apache Spark
Personal Information
- Passport Number: Z3725130
- Driving License: UAE
- Visa Status: Employment
Timeline
Database Administrator/DB-Architect
IDMPS/Omnix International
12.2022 - Current
Database Administrator
Tech Mahindra/ ENEC
09.2021 - 12.2022
Database Architect
GBM
09.2020 - 01.2021
Database Administrator/DB- Architect
Sundus Recruitment Services, Trust Technical Services (INJAZAT DATA SYSTEMS, Mubadala Company)
08.2015 - 04.2020
Senior System Analyst
AL KHAYAT INVESTMENTS LLC
04.2014 - 07.2015
Database Administrator
SYSTEM CONSTRUCT LLC
03.2011 - 04.2014
E-Biz Analyst
TEMENOS
01.2009 - 03.2011
Database Administrator
GENISYS SOFTWARE
07.2007 - 05.2008
Masters in Computer Applications - Computer Applications
Indira Gandhi University