Moeed A.
Quickpivot Customer Data Solutions @Vericast
Signup · Get unlimited contacts
WORK HISTORY
Quickpivot Customer Data Solutions @Vericast
Worked on Performance Tuning and Troubleshooting issues using SQL Profiler, Extended Events, wait stats, Execution Plans, Activity Monitor, Performance Monitor, DMVs, SQL Server Logs, Event Viewer, custom scripts, adding missing indexes• Supported the group policy and process of adding users to Active Directory groups and then granting database permissions to the AD group• Worked on high priority Production Incident ticket alerts generated through Nagios XI monitoring• Used SQL Server Profiler to monitor the server by running traces on various events like User connections, stored procedure execution time etc.• Developed Disaster Recovery plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting• Documented Problem Management RCA (root cause analysis) for outages due to SQL Server issues• Identified and defined Data Source and Data Source views mappings for ETL processes• Used PerfMon and Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes• Performed Uploading of bulk data migration with BCP utility, robust file copy, and Xcopy• Resolved issues of mission critical systems for high usage of system CPU, Disk, Deadlocks issue and Transaction per/sec, Memory involved in performance monitoring of Memory, Processor, Disk I/O• Created Stored Procedures, triggers, and views in SQL for data manipulation and reporting• Implemented SQL 2016 features such as Query Store, Row Level Security, Dynamic Data Masking, Temporal Tables, multiple Temp DB database files• Explored new features in SQL 2017 such as Adaptive Query Processing, Resumable online index rebuild, Automatic plan correction, Automatic database tuning• Explored operating SQL 2019 database engine on Linux, container image with Docker, big data clusters container images with Kubernetes
EDUCATION
University of Arkansas at Little Rock
Master of Science - MS, Information Quality and Information Science
ABOUT MOEED A.
A seasoned Data Professional with several years of IT experience in managing Data, Analytics, and Technology teams as a Database Administrator, Developer, and Data Engineer. Currently leading Data Engineering teams to deliver innovative customer-facing solutions at Vericast. Skilled at building data products from scratch and scaling them to production scale. Expert in problem-solving, finding solutions, troubleshooting, and resolving issues. Strong consulting professional graduated with a BE in Computer and Information Sciences. Holds a MS in Information Quality and Information Science. • Possesses a wide variety of Domain Expertise in Banking and Financial Services, Education, Food and Beverages, Healthcare, Hospitality, Marketing, Manufacturing, Oil & Gas, Print, Mail & Electronic Communications, Retail, Telecommunications• Installed and configured SQL Server 2019 through 2008 R2 Failover Clustered Instances on Windows Clusters 2019 through 2008 R2• Configured Always-on Availability Groups on SQL 2019 through 2012 in Synchronous and Asynchronous commit modes• Configured Database Mirroring in High Performance and High Safety mode with/without automatic failover and fixed issues with the same• Experienced in Security and Support of MS SQL Server 2019 through in Production, UAT, QA, Development, Staging and Test Environments• Involved exclusively in Disaster Recovery plans like Backup/Restore, Database Mirroring, Always-on Availability Groups, and Log Shipping• Expert in configuring and supporting SQL Server Replication in different topologies for Snapshot, Transactional, Merge, and Peer-to-peer from SQL to 2019• Configured Cross-platform IBM Infosphere Data Replication Change Data Capture from DB2 z/OS Mainframe to SQL Server• Experienced on working with Production Servers and 24 x 7 On-Call environments• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative, and the ability to think outside the box
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.