Amir K

Curriculum Vitae PERSONAL INFORMATION Amir Younas Khan Islamabad (Pakistan) -- JOB APPLIED FOR Database Administrator/Developer/Consultant WORK EXPERIENCE 25 April 2015– Current Database Administrator Huawei Pakistan ▪ ▪ ▪ ▪ Responsible for production database with SQL Server 2012 Capacity planning for existing and new deployment. Planning for Disaster recovery solution and implementation. Planning Database and Hardware solution for new products. ▪ Managing and configuring SQL Server AlwaysOn Availability. ▪ Writing complex queries for manual reports and pulling on demand data. ▪ Writing complex queries for export data. ▪ Monitoring real time database performance and health. ▪ Monitoring storage and removing and shrinking unnecessary data. ▪ Working with end users and cooperate executive to identify business process and application requirements. ▪ Available for on call support and response to any emergency. ▪ Responsible for managing and configuring active directory. ▪ Managing security and administering user and permission for OS and database. ▪ Managing and maintaining AD Services. ▪ Managing and Maintaining User security and permission both AD and Databases. ▪ Monitoring Storage. 01 March 2013–20 April 2015 Database Consultant Network Centric Support (UK based), Islamabad (Pakistan) ▪ Responsible for production database with SQL Server 2005, 2008R2, 2012 ▪ Configuring and managing SQL Server Cluster. ▪ Implementing and administering SQL Server Mirroring. ▪ Configuring and managing SQL Log Shipping. ▪ Responsible for oracle, SQL Server real time database performance monitoring, database troubleshooting & tuning, database emergency response / DR , and performed on call and support responsibilities. ▪ Write backup application backups, automatically delete old backups in accordance with our retention policies and record backup information in oracle, sql server database. ▪ Design and implement high availability solutions for a diverse group of clients. ▪ Checking database health monitoring and deleting unnecessary log files. ▪ DB health monitoring through scripts as well as OEM, Export/Import (data pump) and customize profile scripts tune SQL and database engine. ▪ Working with end users and cooperate executive to identify business process and application requirements that can be a part of ERD. ▪ Conduct DCL, DDL code for testing databases and production databases. ▪ Implementing policies for auto script through different ways. ▪ Responsible for emergency response and performed on call and support rotation responsibilities and generating patch if required. ▪ Following standard documentation for each issue and guidelines. Page 1 / 4 Curriculum Vitae 04 January 2013~2015 Database Consultant (Resident Engineer from NCS) Ufone, Islamabad (Pakistan) Oracle Responsibilities ▪ Creates and maintains all databases required for development, testing and production usage. ▪ Performs ongoing tuning of the database instances ▪ Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database. ▪ Plans and implements backup and recovery of the Oracle database. ▪ Implements and enforces security for all of the Oracle Databases. ▪ Performs database re-organization as required to assist performance and ensure maximum uptime of the database. ▪ Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures. ▪ Implement and maintain database security (create and maintain users and roles, assign privileges) Setup and maintain documentation and standards SQL Server Responsibilities ▪ Installing, Configuring, Patching and Upgrading SQL Server Software and Related Products. ▪ Maintaining Servers and Databases running on them. ▪ Configuring and Maintaining database mirroring. ▪ Creating and Maintaining Database Log Shipping. ▪ Configuring and managing SQL Server Cluster. ▪ Monitoring and maintaining of failover cluster. ▪ Creating jobs for different task (backup, maintenance etc…). ▪ Monitoring performance, server disk space, monitoring logs, ensuring jobs has run successfully, checking for errors. Page 2 / 4 Curriculum Vitae 01 February 2011–25 February 2013 Amir Younas Khan SQL Server Dba/Developer Medical Transcription Billing Company (MTBC), Islamabad (Pakistan) ▪ Installation of SQL Server Software and Related Products. ▪ Establish and Maintain Backups on Local and Remote Media. ▪ Performance Monitoring and tuning Using Performance Monitor, DBCC Commands, Maintenance Plans, Third Party Tools. ▪ Analyze Applications Performance Using Query-Execution Plans, Index Utilization and Procedure Cache Utilization. ▪ In Database Programming, Use of Indexes, Normalization Techniques, Execution Plans, T-SQL and Stored Procedures. ▪ Plan Growth and Changes (Capacity Planning) with Team. ▪ Database design development, Tune Database, Queries Optimization of SQL Server, Stored Procedures and SQL Scripts. ▪ Monitor Application Related Jobs and Data Replication Activities. EDUCATION AND TRAINING 01 June 2013–30 March 2014 Master in Project Management SZABIST (Pakistan) ▪ Project Management ▪ Risk Management ▪ Scheduled Management ▪ Human Resource Management 01 June 2007–09 March 2011 BS (CS) Hons Institute of Business and Management Sciences, Peshawar (Pakistan) ▪ Databases ▪ Networking ▪ Software Engineering ▪ Mathematics 01 June 2010–December 2010 OCP (Oracle Certified Professional) Techno-ed, Rawalpindi (Pakistan) ▪ Oracle SQL ▪ Administration Workshop 1 10g ▪ Administration Workshop 2 10g PERSONAL SKILLS Mother tongue(s) Other language Pashto English (Fluent), Urdu Page 3 / 4 Curriculum Vitae Communication skills Organizational / managerial skills Amir Younas Khan Deals with internal and external customers at all levels via telephone and email, to ensure successful communication via actively listening and probing questions. ▪ Substantial experience and outstanding skills in client handling. ▪ Accustomed to working in fast-paced environments with the ability to think quickly and successfully handle difficult clients. ▪ Excellent interpersonal skills, ability to work well with others, in both supervisory and support staff roles. ▪ Work as a team player Job-related skills Strong Database Administration and Development skills in both SQL Server and Oracle. Help and train new team members. Page 4 / 4