ARSLAN AWAN

**** ******** **, ******, **. 757-***-****

ac3dtx@r.postjobfree.com

LinkedIN: linkedin.com/in/arslanawan

Objective

Strongly focused and knowledgeable SQL Database Administrator and Business Intelligence Developer with wide breath of day to day operation of high visibility Databases in multiple environments in a Agile Environment. Appreciates challenges, steep learning curves, and high-pressure deadlines. Reliable team player with effective troubleshooting and disaster recovery skills.

Technical Skills

IMS and Jira project management software.

Axosoft Ticketing System. Notepad++. Citrix.

MAS500/SAGE accounting software.

Microsoft Office Products.

Operating Systems: Windows XP, Windows 7, Apple OSX. Ubuntu and Linux.

SQL Server 2008 R2, SQL Server 2012 R2, SQL Server 2014 and 2016.

MS Azure, Visual Studio 2015-2017

SQL Server Reporting Services. SSIS. ETL.

SQL, My SQL, PostgresSQL

Work Experience

Ethos Group Sept 2017 - Nov 2017

BI and ETL Developer

Worked on developing new Azure data warehouse ETL package using SSIS and ZappySys tool kit to download data in JSON format from external HTTPS website, parsing it and moving data to Azure data warehouse tables.

SSIS package included type 2 CTAS statements that created new tables into a production schema from stage schema.

Deployed the SSIS package to Azure data warehouse and created SSISDB with different environments, setting up SQL job to execute the package.

KIPPDFW.ORG July 2017 - August 2017

Database Manager

Maintaining and administering student’s databases thru Illuminate and PowerSchool application.

Responsible for setting up ad-hoc reporting as requested by the management.

Perfect Commerce August 2014 – July 2017

Database Administrator

The Project lead on Oracle to EnterpriseDB Postgres migration. Testing, installing and disaster recovery after the migration to ensure all systems are running correctly.

Transfer of data from Australia Data Center to Richmond, Virginia. Installing 2014 SSMS and ensuring all backups were in place. Ensuring all schemas were restored and logins were in place. Checking with clients during their testing procedures.

Setting up Disaster Recover server and testing recovery times. Regularly testing DR for failover and recovery procedures.

Project lead on setting up PCI compliant database with encryption in 4 different environments (Dev, Stage, UAT and PROD).

Developing, implementing and managing DBA’s and database management systems in multi-datacenter environments.

Installation, administrations and configuration of SQL Server 2005, 2008, 2008 R2, 2012 and 2014 databases on Windows 2008R2, 2012 and 2014 enterprise and development editions in high visibility with multiple databases. Maintaining database concurrency and data integrity. Examining database schema to improve response time and customer experience in 24/7 environment.

Database disaster recovery and testing backups to ensure they meet the business’ Recovery Time Objectives.

Testing databases, correcting errors and making necessary modifications using performance tuning methods.

Responsible for the operational support of development, stage, UAT and Production databases.

Modifying reports for clients thru SQL Server Reporting Services. Creating and modifying SSIS packages.

Military Experience and Awards

US Navy Petty Officer 3rd Class March 2002 – November 2007

Navy Good Conduct Medal.

Global War on Terrorism Expeditionary Medal.

Global War on Terrorism Service Medal.

Certification

Security + SY0-401 November 2016

Education

Bachelor of Science: Computer Information System April 2016

Saint Leo University

Contact this candidate