Yasir Khan

Sunnyvale CA *****

Cell: 949-***-****

Email: acpchz@r.postjobfree.com

Visa Status: E3 - Australian Citizen

OBJECTIVE

A highly efficient, organized and dedicated IT professional. I am keen to

maintain a challenging career in an assigned role providing Technology and

Communication Solutions with effective and comprehensive experience

spanning 14+ years, as well as natural talents and abilities in an

atmosphere conducive to professional growth and development.

PROFESSIONAL PROFILE

. 14+ years of comprehensive Real-world experience, specializing in

Architecting & Building Enterprise Data warehouse, target state

architectures and roadmaps, server integration technology and middleware,

advanced understanding of Cloud Architectures i.e. SaaS, PaaS, IaaS,

enhancing customer satisfaction and loyalty by improving the usability,

ease of use, and pleasure provided in the interaction between the

customer and the product.

. 3+ years' hands on experience with Agile development practices across US,

Australia and Asia

. Evaluating, installing, configured and supported 8i, 9i and 10G, Oracle

11g and 12c, Database software, upgrading to new versions, coordinating

with hardware, changes and applying database patches.

. Database Administration in SQL Server Azure/2012/2008/2005/2000 (High

Availability, Replication, Troubleshooting, Performance optimization,

Automation, Data Migration (DTS / SSIS using Pragmatic tool)

. Experience in Oracle EBS includes, Oracle CRM, Oracle Financials, Oracle

HRMS, Supply Chain Applications, Warehouse Management system.

. Deep understanding of the business processes to facilitate data

governance and influence the diverse stakeholders

. Translate business requirements using complex methods/models to determine

appropriate architectural solutions

. Expertise in working in RAC with ASAM and GPFS (General Payroll File

System) implementations

. Expertise in working with Active Directory, SAN & NAS, Virtualization

. Expertise in working 24*7 production support environment

. Expertise in working system requirements and develop a backup and

restoration resolutions in a 20% increase in system efficiency.

. Expertise in application Support, Implement, Migration, Upgrade and

support of High Availability Data Recovery Solutions, Capacity Planning,

SQL Clustering. Also I have an experience of Data Migration, MS Share

Point 2007/2010 and reporting (SSRS, Crystal Report) of large scale

including Banking, Financial Services, Insurance, Manufacturing, Non

Profitable Organization, Government, IT and Hospitality based

applications.

. Worked through all stages of software development lifecycle for different

implementations.

. Expertise of database development including stored procedures, functions,

triggers, ad hoc scripts / reports in TSQL

. Worked within a cross-functional team to provide technical expertise in

the design and planning.

. Experience to implement DB/data partitioning and archiving, snapshot

isolation, database snapshot, DDL triggers, try-catch blocks, online

indexing, DMV's, DMF's SQLCMD and dedicated administration connection.

. Establish and implement technology migration strategies for applications

or architectures

. Experience in Data modeling logical and physical using Data modeling

tools such as Erwin, Informatics, Congo's, and warehouse Builder

. Expert knowledge of modeling, database, infrastructure, information

management, and business processes and strategic goals

. Experience in N-tier application architecture with good knowledge in VBA,

VBScript, JavaScript,Ajax and Object-oriented programming and design

interest with a pragmatic approach

. Database Administration in Oracle Active Data Guard, Oracle Streams, SQL

* Net, SQL * Loader and SQL *PLUS, Explain Plan, end-to-end performance

tuning, upgrade, High Availability, Disaster solutions and

implementations.

. Good knowledge of Flashback Technology, Flash recovery Area, Automatic

Storage Management, SAN (EMC & NetApp) and remedy tool.

. Experience in OLTP/DSS database systems, managing large Oracle databases

(VLDB)

. Desktop application design and assist in solution development for

integration, system analysis, administration and management of MS SQL,

GP, CRM, Share Point and Chris21(Payroll system)

. Expertise in issue resolution, Client Interaction, bugs fixing, data

analysis, data Migration and performance optimization.

. Sound business communication, client interaction and leadership skills.

. Highly motivated, hardworking, reliable and a team player.

. Experience in SDLC, Waterfall, RAD, Spherical and Agile/Scrum software

engineering methodologies

. Led a team for large SQL DB migration from SQL 2000/2005/2008 R2 to SQL

2012 for banking and financial services, retail and manufacturing

. Managed of 10 employees across 4 locations including large offshore and

third party contractors

. Eager to learn and adapt to new tools and technologies with ease.

. Excellent business requirement understanding, able to come up with new

design, ideas and solutions

TECHNICAL & SOFTSKILLS

. SQL Server Technologies and Solutions

> AlwysOn, Analysis Services, Database Engine, Data

Warehousing, Integration Services, Management Studio Express,

SQL Scripting, PowerPivot, Replication, Reporting Services,

Service Broker, SQL Native Client, SQL Server Data Quality

Services, SQL Server JDBC Driver, SQL Server Master Data

Services, SQL Server StreamInsight, Windows Azure SQL

Database

. Oracle Technologies and Solutions

Oracle Grid Infrastructure Physical/Logical Standby

Databases, RAC, RMAN, Active DataGuard OEM Cloud/Grid Control

12c, DataGuard Disaster Recovery solutions, Golden Gate

Performance tuning, Oracle Database Vault

DataPump/EXP/IMP/SQL*LOADER

. High Availability (MS Clustering, GoldenGate - OGG systems on Oracle

11gR2 RAC)

. Database Security

. SQL Server Data tools

. Transact SQL Queries

. BI tools

. Search Engines: Endeca, Solar, Lucene, Google

. Web Technologies: ASP.Net 3.5/2.0/1.1, C#, VB.Net, MVC 1.0, WCF,

Silverlight 2/3, Amazon RDS

. Web Servers: IIS 6.0/5.0/4.0, COM, COM+

. Management S/w: Snap Manager for Microsoft SQL Server

. Operating System: Windows, UNIX, Linux, Mac

. RDBMS: SQL Server, MYSQL, Oracle, DB2, MS Access

. Performance Monitoring: Quest Spotlight, Toad, Tkprof, Traces, SQL

Scripts, Zenoss, SQL Diagnostic Manager, Nagios

. Tools: PRTG, ControlM, IBM Trivoli, BMC Remedy, Quest Litespeed,

Spotlight, SQL performance, Red Gate, TOAD, Case Studio, Erwin and

DBArtisan, SQL built-in-reports, Plan Explorer, Profiler, SQL Broker,

Oracle Golden Gate, Install and resolve issues with Visual Studio

2008, 2010 and 2012

. Reports: SSRS, Crystal Reports, GrapeCity Active Reports v7.0

. Orchestration tools: MS System center orchestrator, Chef and Puppet

. CASE/Packages: Erwin, Bpwin, Rational Rose, Sybase Power Designer, MS

Visio, SQL Litespeed

. Source Control: IBM Rational ClearCase, Perforce, Razor, TFS, Vault,

Visual SourceSafe

. Data Modeling: ER/Studio, Erwin, FastTracks, Workbench, Toad Data

Modeler, Visio, xCase

. ELT: Informatica, SSIS, DTS

. Database programming /administration experience, Database Monitoring

tools management

. Performance ongoing tuning of the database instances, Finding & Tuning

hardware Bottlenecks

. Business Continuity Planning & DR Setup

. MS SQL Cluster/Node Management, SQL server Remote DBA Expert

. Ability to interact well within the organization and with the clients

as well

. Excellent organizational, multitasking and problem solving skills

. Team player with demonstrated leadership abilities

. Ability to learn and practice new skills efficiently at workplace

MANAGEMENT SKILLS

. Negotiation

. Managing budgets, costs and expenses of the Project

. Project execution and control

KEY STRENGTHS & ABILITIES

. Solution development for integrations, system analysis, administration

and management skills

. A keen interest in, and a strong understanding of the broader business

issues

. Excellent ability to assess situations and solve problems effectively

using initiative and creativity

. Liaison, communication and interaction with users, clients and

management

. Systematic and detailed approach to work, is highly organized,

multiple projects simultaneously

. Team player with demonstrated leadership abilities

. Thrives in a pressurized, busy environment with time constraints,

demonstrating responsibility, self-motivation, enthusiasm, dedication

and perseverance.

CAREER ACHIEVEMENTS

. Winner of "On the Spot Award" in 2013, i.e inspiring role model to my

colleagues.

. DR Testing as per the DR calendar or as specified by

Application/Project Manager

. Define / plan /design / implement / audit db security

. Experience working on and deploying a diverse set of computer

technologies and platforms including Microsoft, Unix/Linux and Mac

Operating Systems and application

. A firm understanding of Business Analysis, Project Management

concepts, tools and industry standards

. Hands-on experience with the installation, configuration and

management of Oracle 81, 9i, 10g, 11gR2, 12c, Microsoft SQL Server

2000/2005/2008/2012/Azure databases running on various versions of

Windows and Linux

. Experience in projects with superior analytical, organizational and

planning and presentation skills

PROFESSIONAL EXPERIENCE

NetApp - USA (March 2014 - to date)

http://www.netapp.com

Database Architect

Contract:

This position's responsibilities include:

Work with infrastructure, security, integration and business analyst team

to become familiar with the application requirement, Drive the detail best

practicing technical design, implementing, and maintaining an efficient

secure, and reliable database infrastructure for specific portions of the

application, Responsible for strategic planning with our database strategy.

Assistant project and development managers to define the scope and develop

plan for the project deliverables, Accountable for meeting the milestones

set for the project, database administration tasks like new software

installation, database setup, database upgrade, database patching, database

cloning and performance tuning. Responsible in installing, configuring and

maintaining Grid infrastructure and real application cluster for high

availability configurations

Project #1: EDO SLQ Server Health Check FY15

Environment: SQL Server 2008R2 & 2012 [Database Engine, ETL, SSIS &

SSRS], Clustering, Replication, T-SQL,Query Analyzer, DB tuning advisor,

2012, AlwaysOn, Microsoft Project

Dun & Bradstreet, Inc. (September 2013 - March 2014)

http://www.dnb.com.au

Sr. DBA / Project Lead

Contract:

This position involved to support 25 applications simultaneously in all

environment, participated in Design and Architecture meetings and proposed

technical solutions to resolve business requirements, designed and

implemented the Replication Architecture across global, Install and

configure the Visual Studio 2010 for the Developers and resolve the issues,

analyzed the architecture to propose an ETL design solution for DWH. It

also included planning, controlling, monitoring and managing and directing

the assigned project resources to best meet project objectives, collecting

metrics data including costs, schedule, work in progress and work completed

& reports on project progress and other project specific information to

stakeholders.

Project #2: APLAN Database Migration and Upgrade

Environment: ASP.NET, SQL Server 2000 & 2012 [Database Engine, ETL,

SSIS & SSRS], Clustering, Replication, T-SQL,Query Analyzer, Spotlight, SQL

Profiler, DB tuning advisor, Entity Framework, C#, VB.NET, web services,

IIS, Windows 2012, AlwaysOn, Redgate,

Westpac Banking Corporation - Australia (February 2013 ~ August 2013)

http://www.westpac.com.au/

Sr. DBA

Contract:

This position involved to server as a technical SME to other engineering

team for SQL Server/Oracle, delivered consolidated and reliable business

critical date using Master Data Management (MDM), tracked Software/Database

upgrade\Migration, defects and issues via the use of Agile Software

engineering, created in-house monitoring and inventory system for all SQL

servers using SSIS packages. Advised, guided and overlooked other DBA's on

their daily tasks and processes. Have experience in refreshing Salesforce

data to local production reporting environment using DBAmp.

Monitored project activities and advised staff of issues due to resource

availability, DB trend analysis and capacity planning, performance and

availability of hardware and software as it relates to servers, storage,

and database including reporting. Setup and monitor custom automated

database index & statistics maintenance and consistency checks. Design ETL

jobs for the Data Management team in various projects

Project #3: Online Transformation Program (OTP)

Environment: Informatica Power Center 8.6.1, SQL Server 2008R2

[Database Engine, SSIS & SSRS], Clustering, Replication, T-SQL,Query

Analyzer, Quest, SQL Profiler, DB tuning advisor, Entity Framework, C#,

VB.NET, Win 2008R2, Erwin 4.0

Datacom Australia NZ SEA (October 2010 ~ February

2013)

http://www.datacom.com.au/

Application DBA

Full time:

This position involved manage 1 to 2 technical resources as well as

authored Statement of Work, developed project plans and assumed

responsibility for project profit and loss, tracked Database

Upgrade/Migration, defects and issues via the use of SDLS, create and

maintains all databases required for development, testing, education, and

production usage. It also included Microsoft DPM(Data Protection Manager)

for backups and disaster recovery, Worked with developers to tune the SQL

queries using SQL Profiler, Provided 24 * 7 Production support for the

database and application issues, Implementing Resource Governor, Log

shipping, Mirroring and Replication

It also included managed upgrades and patching from 9i, through 10g, and on

to 11gR2 and latest Oracle PSU and CPU patches, including establishing

critical modifications for security, Standardized backups across all Oracle

databases, including RMAN configuration, and export data pump processes.

Project #4: SharePoint SQL Consolidation

Environment: ASP.NET, SQL Server 2008R2 [Database Engine & SSRS],

Clustering, Replication, T-SQL,Query Analyzer, Spotlight, SQL Profiler, DB

tuning advisor, VB.NET, web services, IIS, Win 2008R2

Project #5: TFS SQL Consolidation

Environment: ASP.NET, SQL Server 2008R2 [Database Engine & SSRS],

Clustering, Replication, T-SQL,Query Analyzer, Spotlight, SQL Profiler, DB

tuning advisor, VB.NET, web services, IIS, Win 2008R2

Project #6: Design Disaster Recovery Strategy

Environment: SQL Server 2008R2 [Database Engine & SSRS], Clustering,

Replication, T-SQL,Query Analyzer, Spotlight, SQL Profiler, DB tuning

advisor, Win 2008R2, CA AutoSys Job Scheduler.

Project #7: Data warehouse Migration in 2012

Environment: SQL Server 2005/2012 [Database Engine, SSIS & SSRS],

Clustering, Replication, T-SQL,Query Analyzer, Spotlight, SQL Profiler, DB

tuning advisor, VB.NET, web services, IIS, Win 2008R2

e. Law Asia Pacific Pty Ltd (December 2009 ~ October

2010)

http://www.elaw.com.au/

Database Administrator

Contract:

This position involved for configuration, data Management, documentation,

maintenance, performance, planning, reporting and security of SQL Servers,

provide data migration, transformation, backup and recovery, performance

and tuning and other services to support production & QA, Implemented

procedure for backup/recovery and maintenance of SQL Server databases.

Provide senior management with performance management and capacity planning

data. Writing database documentation, including data standards, procedures

and definitions for the data dictionary ('metadata')

On Going Tasks

. Develop, document processes and procedures,

. Monitor and /automate tasks required to maintain databases.

. Introduce latest technology to help improve the overall efficiency of

the DBA Team, understand business processes for hardcopy and softcopy

processing.

Challenges

. Working in an undocumented environment

Project #8: Relativity E-Discovery Migration and Upgrade

Environment: SQL Server 2005/2008R2, Cherwell, RFC, windows server

2008R2

Lifeline Community Care State Office QLD (July 2007 ~ June 2009)

http://www.uccommunity.org.au/

State ICT Database Administrator

Contract:

This position involved for monitored server performance, database and

transaction log growth, developed procedures and guidelines for SharePoint

usage, Installing and testing new versions of the database management

system (DBMS), Check for failed Processes, Research Errors, validate disk

space is not low, create SQL alerts to notify potential problems, emailed

and, validate none of the database are offline or corrupt, Perform

database maintenance

Project #9: Planning, Configuration and Implementation of Great Plains

and Administration

Environment: ASP.NET, SQL Server 2008 [Database Engine & SSRS],

Clustering, Replication, T-SQL,Query Analyzer, Spotlight, SQL Profiler, DB

tuning advisor, VB.NET, web services, IIS, Win 2008R2

Project #10: Planning, Configuration and Implementations of CRM and

administration

Environment: ASP.NET, SQL Server 2008 [Database Engine & SSRS],

Clustering, Replication, T-SQL,Query Analyzer, Spotlight, SQL Profiler, DB

tuning advisor, VB.NET, web services, IIS, Win 2008R2

Project #11: Planning, Configuration and Implementation of Chris21

Payroll System and Administration

Environment: ASP.NET, SQL Server 2008R2 [Database Engine & SSRS],

Clustering, Replication, T-SQL,Query Analyzer, Spotlight, SQL Profiler, DB

tuning advisor, VB.NET, web services, IIS, Win 2008R2

Al Nahr Co. Ltd. Tripoli, LIBYA (Sep 2002 ~ May 2007)

Database Architect

Contract:

This position involved for all aspect of solution creation with regards to

end user IT services, Served as a client Manager to implement clients

server billing and customer care solutions, Managed 5 to 10 technical

resources as well as authored Statement of work, Creation of DDL, Stored

Procedures, functions, views, triggers, logical/physical data model and

Schema generation, Requirement gathering / gap analysis, functional

specification preparation, development / verification, Data Migration and

onsite UAT / production support, Technologies used are .NET, SOAP, Web

Services, Java, SSL, LDAP, C++, XML, Windows, SQL Server, Unix, Oracle, and

Oracle Real Application Server clusters. Designed automated SEI CMM

compliance project to automate quality assurance

Project #12: BI Data ware house Setup

Environment: ASP.NET, Oracle 8i, SQL Server 2005 [Database Engine, SSIS

& SSRS], Clustering, Replication, T-SQL,Query Analyzer, Spotlight, SQL

Profiler, DB tuning advisor, VB.NET, web services, IIS, Win 2003

Project #13: Online Production Design and Implementation.

Environment: Oracle 8i, SQL Server 2005 [Database Engine, SSIS & SSRS],

Clustering, Replication, T-SQL,Query Analyzer, Spotlight, SQL Profiler, DB

tuning advisor, VB.NET, web services, IIS, Win 2003

Project #14: Oracle 8i, SQL Server Reporting Services Production

Implementation

Environment: SQL Server 2005 [Database Engine, SSIS & SSRS],

Clustering, Replication, T-SQL,Query Analyzer, Spotlight, SQL Profiler, DB

tuning advisor, VB.NET, web services, IIS, Win 2003

ACADEMIC RECORD

. Microsoft Certified Solution Associate (MCSA 2012) - July 2013

. Oracle Certified Associate (OCA) - Aug 2012

. Microsoft Certified IT Professional (MCITP) - March 2012

. Microsoft Certified Tech Specialist (MCTS) - July 2011

. Master in Engineering Studies (2009 ~ 2010) from UTS -

Sydney, Australia

. Bachelor in Computer Science (1996 ~ 1999) From Punjab

University, Lahore

PROFESSIONAL MEMBERSHIP

. Australian Computer Society

. The Professional Association for SQL Server

. MSDN Social Forum

ADDITIONAL INFORMATION

. Proficiency with Unix-based platforms including: IBM AIX, HP, Sun

Solaris, Sequent, IBM390, DEC Alpha Digital Unix, Linux

. Proficiency with IBM PCs including: Windows (All Versions), circuitry

design and interfacing, computer repair, systems optimization,.

. Programming language skills including:

Unix: Java, PL/SQL, C++, C++ POSIX Multithreading, HPGL, PostScript,

perl, Korne shell, C shell, DNS/BIND, Sendmail, Windows: Java, C++,

SQL, Visual Basic, ISAPI, COM, ActiveX, OLE/OLE2, .NET, Active

Directory, IBM PC: SQL, Java, C Visual Basic, Pascal, Assembly,

PostScript, COM, ActiveX, OLE/OLE2, Macintosh: Java, C++, SQL, FoxPro,

Pascal, Assembly, BASIC, AppleScript, HyperScript, Internet: Java,

C++, HTML, SGML, XML, JavaScript, DNS/BIND, Sendmail, Web Services,

SOAP

. Databases skills including

SQL Server 2000/2005/2008/2012, Data Warehousing, Replication,

Reporting Services, Service Broker, Server Data Quality Services,

Window Azure SQL Database, High Availability, Database Security, SQL

Queries,Project Management, MS Share Point, DTS, SSIS, SSRS, PRTG

Network Monitor, IBM Tivoli, Spotlight on SQL Server, BMC Remedy,

MYSQL, OLTP, Lotus Notes, Eterprise batch Scheduling toolset, Visio,

Visual studio,OLTP Perf Tunning, MS Access, BMC Control-M, CRM, Quest

LiteSpeed, Great Plains, Erwin, DB Management tool, Quest, Oracle,

toad for SQL Server 5.7, ETL Tools Informatica Power Center

. Big Data: HDFS, HBASE, Cassandra, Mongo DB, Hive

. Management Tools: Ambari, Ankush, StarCluster, OpsCenter, MongoVUE

. Cluster Vendors: Microsoft, VERITAS, HP Tru64 Unix, RAC

. Knowledge of Mahout, Zookeeper, Oozie, Spark, Scipy/NumPy and Storm

[pic][pic][pic]

Contact this candidate