Amanullah Ashraf Email & Phone Number

Islāmābād, Pakistan

SQL Server 2019▪ Deployed a 2-Node Failover Cluster for SQL Server 2019.▪ Successfully migrated databases to Azure on the IaaS platform.▪ Managed user access to SQL Server databases.▪ Configured SQL Server Email and implemented Transaction replication.▪ Backing up databases through Maintenance schedule▪ Integrated SSIS packages in the SSISDB, executing them in SQL Agent.▪ Installed and migrated SSRS Server.▪ Conducted Index Maintenance and created Snapshots of Databases.▪ Established a linked server to extract data from Postgres.▪ Troubleshot FCI and Mongo replication issues.▪ Maintenance of code in AzureDevOps ▪ Postgres 13▪ Prepared documentation for the Postgres upgrade process.▪ Collaborated in the Postgres upgrade process led by EDB using pg_upgrade.▪ Implemented Streaming replication in Postgres 13.▪ Partitioned a 350 GB table into smaller partition for CRON jobs.▪ Managed user access to Postgres databases.▪ MongoDB 3.4▪ Resolved a broken replication issue in MongoDB.▪ Upgraded MongoDB from an older version to a newer version on Linux.▪ Prepared documentation for the MongoDB upgrade process.▪ Enabled Authentication for Mongo Databases.▪ Created and granted privileges to end users.▪ Executed database movements using the mongodump and mongo restore.▪ Established a Cron job for Mongo DBs using mongodump.▪ MySQL (MariaDB 10.4)▪ Installation of MySQL on Ubuntu▪ Backup and Restoration of MySQL Database▪ Performance and tunning of MySQL Database▪ Setting up Master-Master replication on Ubuntu 22

Islamabad

▪ Query writing in PG Admin 4 Postgres.▪ Backup and Restore Postgres Database using PG Admin 4.▪ Creating users in Postgres with specific rights. ▪ Preparation of Database Strategy for MSSQL Server databases. ▪ Preparation of SQL Server Database for Bulk Extract Data Certification which includes Installation, Auditing, Email Setup, Alerts, Operator, Notification Setup, Scheduling task, User login & Linked Server.▪ Implementation of Log Shipping, Mirroring, Replication (Transactional) in a virtual environment on Windows 2016 Server using Active Directory user and Domain setting at home.

Karachi

Karachi

▪ Calculated Database size and predicted future growth.▪ Created Database from database design▪ Install Full-TextIndex search.▪ Design Backup Plan

Islamabad

▪ Query Writing in T-SQL.▪ Designing Back Up Maintenance Schedules.▪ Database Updates through Imports and Exports.▪ Prepared Functional Specific Doc.▪ Developed ETL Process using SSIS Packages

Karachi

▪ Designed migration packages for the Election Commission ofPakistan.▪ Replicated Database was created to save the migrated data on MSSQL

Karachi

Data Analyst, Data Analysis

Activities and Societies: Python, R, TableauTo be completed in 2018

Master, Computer Science

Master, Business Administration

Bachalor, Business Administration

Data Engineering, Pass