Sql Server Project
Resume:
Yasir Khan
Sunnyvale CA *****
Cell: 949-***-****
Email: ************@*****.***
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