FARZAN FARNOODFAR Microsoft ID: 5969275

Senior Technology Architect - DBALead

Location: San Francisco Bay, CA(California Resident)

Visa Status: Australian citizen holdingE3 valid thru 2018 (sponsored - renewable onshore)

Phone: +1 (248)-489-6646

Email:

Web:

Professional Summary

•Innovative thinker with extensive experience designing, coding, testing and supporting next generation database solutions

•Possesses 17 years+ experience in database management systems, software and ICT management

•Expert in technical problem solving

•Skilled in designing and implementing complete life cycle client servers and database applications with various development tools and languages

•In-depth understanding of security procedures

•Expert in reviewing and re-architecting application and database security structures

•Solid experience in database integrity, high availability and recovery solutions

•Capable to produce best results in pressure situations

•Most capable of achieving best as part of a team as well as individually

•Eager to complete tasks efficiently and meeting deadlines

•Successful in tailoring solutions as per requirements and aligning them with policies

•Successful team leaderin setting goals and achieving while keeping team highly motivated

•Wisely delegating manager with a coaching approach who recognizes values and sets goals, effectively

•IT Strategic planner with and extensive background in driving technology

•Leader of technical IT teams in complex environments

•Patient with providing clear and transparentstatements and working closely with people

•Self-starter and highly motivated

Technical Skills

  • Expert in MS SQL SERVER all versions with long experience maintaining MySQL with also background inOracle, PostgreSQL, Informix, DB2 and MSAccess/Excel.
  • Design and analyze database structure, SQL Programming, Administration, Automation
  • Tuning, Clustering, Management, Backup/Restore, Replication, Mirroring, High Availability, ETL
  • Query Analyzer, BIDS, SSMS VS.Net 2005-2012, VSS, FTP Clients, SequelPro, DBVisualizer, SQL Developer
  • SQL Report (SSRS), MicroStrategy, QlikView, Crystal Reports
  • Disaster Recovery, SQL Clustering, DB Replication (/P2P), Mirroring, AlwaysOn, Stand By and High Availability
  • BigData BI,MapReduce, Hadoop, PigLatin, HiveQL, Oozie, Azure Hadoop Cluster
  • Backup/Maintenance Strategies, Security Management, Resource Management, ETL Tuning
  • C# (ASP.NET), VB (ASP.NET), PHP, ASP
  • PowerShell, VBScript, JavaScript, HTML, CSS, XML, HL7 (AJAX, UML, SEO, ADLC, Ad-HOC)
  • VMware and virtualization technologies, HyperV, Oracle VM, Network infrastructure and fundamentals
  • Windows 2012, 2008R2, 2000, NT, 7, XP, 98, 95, MS DOS, Linux, Active directory, DHCP, Group Policy, Firewall
  • Linux, KVM, Percona, SSH, Disk management and capacity planning
  • MS SharePoint, MS Office Suite, Photoshop, Antivirus, Remote support
  • Finance database platforms including MS Dynamics, GP, Procube, Sage MAS 500, PowerBudget
  • Cerner, IPM, Bossnet, Zedmed

EducationAwards

  • Master of Business Administration (MBA) StudentVictoria University (2015-ongoing)
  • Bachelor of Science (hons) in Computer EngineeringAzad University (2002 to 2006)

Certifications & Training

  • MCSE Business Intelligence and BigData * (Microsoft Certified Solution Expert)
  • MCSA SQL 2014 * (Microsoft Certified Solution Associate)
  • MCP SQL 2012 *(Microsoft Certified Professional)
  • Certified Software Engineer. (ACS - Australian Computer Society)
  • MCTS SQL *(Microsoft Certified Technology Specialist)
  • MCSD.NET *(Microsoft Certified Solution Developer)
  • MCAD.NET *(Microsoft Certified Application Developer)
  • Prince 2 – Project management(Lixivium)
  • PMI – Project management(LearnSmart LLC)
  • MCP *(Microsoft Certified Professional)
  • C#.Net(Cavendish College .Net Certificate)
  • JAVA(Cavendish College Certificate)
  • OOP & VC++(Cavendish College Certificate)
  • MySQL Administration(Prexiv)
  • MicroStrategy – Data and Dashboards(MicroStrategy)
  • MicroStrategy – Enterprise Applications(MicroStrategy)

Professional Experience

Facebook (Pro Unlimited),Menlo Park, CA, USAMar 2017 – Current

Senior Database Engineer

Facebook is an American online social media and social networking service.

Responsibilities:

  • Install and maintain SQL cluster, DB replication, mirroring, 2012 AlwaysOn and high availability
  • Analyze and document performance of database servers and provide improvement solutions
  • Provide PowerShell automation for SQL Servers
  • Maintain and optimize MS SQL 2008 R2, MS SQL 2012, MS SQL 2014 servers
  • Develop and Optimize SQL queries, procedures and ETL processes
  • SQL Server and MySQL Servers Recovery DR and availability
  • Set up alerts and notifications
  • SQL Server Security management
  • SQL 2008R2/2012/2014management
  • Capacity planning and monitoring servers' performance
  • Audit logins and sever/database activities
  • Design and analyze relational database and file base data manipulation structures
  • Troubleshoot applications connectivity and performance issues
  • Document and provide KTs on Wiki

Environments and Technologies:

SQL Server 2008R2, 2012, 2014, SSRS, SSIS, SSAS, Windows 2008R2, 2012, Mac OS, Linux, SSMS, Genetec, CCURE, Traka, VMWare

Apple Inc,Cupertino, CA, USAApr 2016 – Mar 2017

Lead Database Architect/Senior TechnologyAdvisor

Apple is the world's largest information technology company by revenue, the world's largest technology company by total assets, and the world's second-largest mobile phone manufacturer.

Responsibilities:

  • Provide architecture of future database platforms with higher scalability and contingency
  • Install and maintain SQL cluster, DB replication, mirroring, 2012 AlwaysOn and high availability
  • Analyze and document performance of database servers and provide improvement solutions
  • In place and side by side edition upgrade to later versions, install patches and service packs
  • Maintain and optimize MS SQL 2008 R2, MS SQL 2012, MS SQL 2014 servers
  • Design and optimize DTS/SSIS packages
  • Optimize SQL queries,procedures and ETL processes
  • Plan for SQL Server and MySQLServers Recovery DR and availability
  • Design backup & restore strategies for SQL Servers and MySQL servers
  • Native automation using SQL Agent and PowerShell + VBScript for Windows servers
  • Develop automations using MySQL and Crontab for Linux servers
  • Optimize databases withindexing strategies and tailoring configurations for SQL Server
  • Set up alerts and notifications using Crontab and SQL mail
  • Establish Log-shipping for reporting and stand-by servers purposes
  • Implement MySQL replication and adequate monitoring
  • Use Percona tools in monitoring and optimizing MySQL performance and replication
  • SQL Server and MySQL Security management
  • SQL 2008R2/2012/2014 Central servers management
  • MySQL, SQL Server partitioning and defining appropriate file/filegroups
  • Capacity planning and monitoring servers' performance
  • Audit logins and sever/database activities
  • Design and analyze relational database and file base data manipulation structures
  • Troubleshoot applications connectivity and performance issues
  • Document and provide KTs on Wiki
  • Key participation in re-architecture of SQL Servers platform withmore than 50% increase in performance
  • Sole implementer of SQL2012 AlwaysOn for high priority databases
  • Assist BI team with data discovery and ETL for MicroStrategy and SSAS
  • Procided support for 8 node Gallera Cluster maintenance
  • Provided optimized re-architectural design for legacy MYSQL Databases
  • Coordinated various implementation projects for DBA / Architects team

Environments and Technologies:

SQL Server 2008R2, 2012, 2014, MySQL, Gallera, PostgreSQL, Oracle 11g, 12c, Vertica, MongoDB, SSRS, SSIS, SSAS, Windows 2008R2, 2012, Mac OS, Linux, Percona, SQL Developer, SSMS, SequelPro, DBVisualizer, KVM, Operations Orchestration, Nlyte and RFCode, Clarity, BigData, MicroStrategy

Victorian Eye & Ear Hospital Melbourne, AustraliaNov 2010 – Apr 2016

Senior DBA - Database Management Lead / Deputy CIO

AVABI is a service on demand provider to Health Care centers and hospitals delivering patient management systems and PAS where database platforms are generally SQL Server 2000, 2005, 2008, 2012 and 2014 based on clients’ infrastructure.

Responsibilities:

  • Provide sound leadership and effective co-ordination of respective team
  • Effectively co-ordinate, execute and resource the actions identified in the ICT Operational Plan
  • Contribute in Strategic planning for ICT Data Management
  • To provide excellence in service to all internal and external stakeholders through the provision of advice on appropriate system solutions required to support the current and future operational requirements of the organization.
  • BigData Hadoop Implementation Evaluation
  • Install and troubleshoot SQL Server 2005, 2008, R2 and 2012 on VM and physical servers
  • Install and maintain SQL cluster, DB replication, mirroring, 2012 AlwaysOn and high availability
  • Develop and maintain or reports and report services on QlikView and SSRS
  • In place and side by side edition upgrade to later versions, install patches and service packs
  • Maintain and optimize DW and related queries
  • Design and optimize DTS/SSIS packages
  • Optimize T-SQL queries, procedures and ETL processes
  • SQL Server Recovery DR and troubleshooting
  • Design backup & restore strategies for SQL Server
  • Native automation using SQL Agent and PowerShell + VBScript
  • Optimize databases and table indexes for SQL Server
  • Migrate data from legacy servers and databases, from physical into VMware virtual environment
  • Set up alerts and notifications using paging system and SQL mail
  • Establish Log-shipping and replication for reporting purposes
  • Hardware maintenance, start/restart cluster, snapshots
  • SQL Server Security management
  • SQL 2008R2/2012 Central servers management
  • SQL Server 2005, 2008, R2 and 2012 table partitioning and defining appropriate file/filegroups
  • Capacity planning and monitoring servers' performance
  • Audit logins and sever/database activities
  • Design and analyze relational database and data warehouse structures
  • Managing web applications for their connections to database (OLEDB, ODBC, Native, LINQ to SQL, Entity framework, ADO.Net)
  • Design, test, deploy and publish SSRS complex reports
  • Key participation in data warehouse architecture and initial implementation of QlikView which had a significant improvements for the business in minoring KPIs and accessing business insights based on current data flow

Environments and Technologies:

SQL Server 2000, 2005, 2008R2, 2012, 2014, MySQL, Informix, PostgreSQL, C#.Net. QlikView, SSRS, SSIS, SSAS, Windows 2008R2, 2003, Citrix XenApp, VM Ware, Exchange 2012, Office 2012, HTML, CSS, JavaScript, JQuery, Intermapper, Cerner, IPM, Bossnet, Dynamics, GO, PowerBudget.

Caterpillar Inc,Peoria, ILJun 2010 – Sep 2010

Senior DBA

Caterpillar designs, manufactures, markets and sells machinery and engine. The IT department is supporting the regional office building infrastructure and applications.

Responsibilities:

  • Support SQL Servers 2000 and 2005 in maintenance, upgrades, patches and recovery
  • Code T-SQL Statements for various Reports and application specific needs
  • Manage a team of nine IT professionals in a safe and secure work environment
  • Maintain the organization's effectiveness and efficiency by defining new IT continuity plan and delivering strategic plans for implementation of information technologies
  • Direct researches by studying organization goals, strategies and market
  • Coordinate development projects' resources and times with departments
  • Provide ongoing report to executive management team
  • Implement disaster recovery procedures
  • Provide ongoing support in identifying problems, evaluating trends and anticipating requirements
  • Accomplish financial objectives by forecasting requirements and budget management
  • Maintain quality service by establishing and enforcing organization standards to alignwith IT standards
  • Introduce and updatedisaster recovery plans
  • Manage implementation of new finance system replacement

Environments and Technologies:

SQL Server 2000, 2005, 2008, MySQL, SSRS, SSIS, Windows 2008R2, 2003, HyperV, GroupWise, Office 2003, Redgate,

Cerner, IPM, Dynamics, GP, PowerBudget, Qlikview, Procube

Orbitz,Chicago, ILOct 2009 – May 2010

Database Solutions Architect

Orbitz is a company that operates a web site used to research, plan and book travel

Responsibilities:

  • Design databases and related functions and stored procedures in SQL 2005
  • Create class diagrams and use case specifications of applications
  • Manage SQL servers in backup/restore and replication between servers
  • Analyze and amend developers T-SQL and C# codes for best performance
  • Implement disaster recovery plans and procedures for production environment
  • Create stored procedures/functions using complex algorithms in T-SQL
  • Deal with the customers to model users’ needs.
  • Liaise with the project manager on a daily basis to ensure progress and constancy across the SDLC
  • Interpret and document users' requirements into technical documentation for the development team
  • Create and analyze use case specification documents
  • Provide support and guidance to the development team during the SDLC
  • Design database systems and application structure
  • Design data marts and develop data warehouses
  • Manage implementation of the new agents portal application and database

Environments and Technologies:

SQL Server 2000, 2005. VB.Net. SSRS, SSIS, Windows 2008, 2003, XP, MS Project, Office 2003, HTML, Java.

Alkhalidi Group,Dubai/Ajman – UAEFeb 2009 - Aug 2009

DBA Management / Head of Technology

Alkhalidi Group is a structural maintenance company in UAE with offices in Dubai and Ajman

Responsibilities:

  • Manage team of SQL Server developers, administrators and report writers
  • Review disaster recovery procedures for production environment
  • Manage integration between database systems including datawarehouse and Finance GP and Sage MAS 500 DBs
  • Identify technology trends and evolving social behavior that may support or impede the success of the business.
  • Establish and supervise a quality assurance process, including integration and system testing.
  • Select, deploy, and monitor performance profiling tools and procedures.
  • Develop, track, and control the development and deployment annual operating and capital budgets for purchasing, staffing, and operations.
  • Direct development and execution of an enterprise-wide information security plan that protects the confidentiality, integrity, and availability of the company’s data and servers.
  • Supervise recruitment, training, retention, and organization of all development staff in accordance with the company hiring process, personnel policies, and budget requirements.

Environments and Technologies:

SQL Server 2000, 2005, 2008R2. C#.Net. Windows 2008R2, 2003, XP, Citrix, Office 2003, Photoshop, HTML, PHP, ASP, Sage MAS 500, Procube

AT&T, Dubai - UAEAug 2008 - Feb 2009

Database Engineer

AT&T Inc. is an American multinational telecommunications corporation, headquartered in Dallas, Texas. AT&T AMEA is an internet provider in Europe, Middle East, Africa.

Responsibilities:

  • Design, develop and deliver / implement data solutions
  • Architecture design, prototyping of concepts to proof of concept
  • Design and development of test plans
  • Manager recovery options in high availability and stand by environments
  • Effectively manage day-to-day tasks in coordination with a team of developers to effectively meet the deliverables
  • Lend support to various business and technology teams as necessary during design, development and delivery
  • Support SQL Servers to meet business delivery specifications and needs.

Environments and Technologies:

SQL Server 2000, 2005, 2008R2. C#.Net. Windows 2008R2, 2003, XP

Yasesepid Ltd,Tehran – IranJan 2007 - Aug 2008

IT & DataOperations Manager

Yasesepid is a travel and tourism agency company which offers electronic sightseeing tours

Responsibilities:

  • Manage a team of four and reporting to the CIO
  • Create new or develop existing SQL and MYSQL databases
  • Support SQL Servers to meet business delivery specifications and needs.
  • Manage and implement disaster recovery solutions when required
  • Develop .Net web-based applications and php websites
  • Manage and supported websites and web-based applications by telephone and remote support
  • Perform installation, maintenance and update for OS and software
  • Assess customer needs and recommended appropriate products and solutions whilst providing time and money saving solution for customers
  • Monitor database, network and application performance or activity
  • Maintain and troubleshoot system bugs and rapidly solve problems
  • Introduce a new method for selling flight tickets via internet
  • Coordinate distribution of 50 web kiosks around the city to sale air tickets

Environments:

SQL Server 2000, 2005. ASP, Crystal Reports, DTS, Windows 2003, NT, Office 2003, MS Project.

Karafarinan Ltd,Tehran – IranJan 2004 - Jan 2007

DBA Solution Developer

Karafarinan was an international travel agency company engaged in interactive ticket sale system with some airlines using CRS and GDS in Iran

Responsibilities:

  • Monitoring progress of requests for support and ensure users and other interested parties are kept informed.
  • Enhancements, reconfiguring systems, changing operating procedures
  • Training users or operations staff, producing additional documentation
  • Escalating requests to software suppliers. Ensure all work is carried out and documented in accordance with required standards, methods and procedures
  • Monitoring application systems for which responsible by regular scrutiny of reports
  • Noting problems and identify performance trends
  • Liaising with software suppliers on the development of system enhancements
  • Develop MS Access and SQL Databases
  • Migration of historical MS Access DBs and FoxPro data into SQL Server with DTS packages

Environments and Technologies:

Informix, SQL Server 2000, PHP, APACHE, DTS, MS Access, Windows 2003, NT, Office 2003, Solarwinds.

Homaye Saadat Ltd,Tehran – IranJan 2001 - Jan 2004

DBA & Web Developer

Homaye Saadat is a travel agency and international tour operator

Responsibilities:

  • Developed C#.Net third-party applications to work with GDS data for online sale
  • Managed applications for GDS (Global distribution system)
  • Installed, supported, and maintained LAN, network equipment, servers and other computer systems
  • Performed troubleshooting systems and network reported problems
  • Performed backup and restoration on servers, clients and applications
  • Implemented important policies and procedures for network and database
  • Create an integrated system for E-Tourism in Iran (i.e. Iran-tourism.net)
  • Obtaina high level of systems performance and user satisfaction

Environments and Technologies:

SQL Server 7, 2000, C#.Net, C++, JAVA, Windows 2003, NT, Office 2000, 2003, Dreamweaver.

Alborz Insurance, Tehran – IranJul 1999 – Dec 2000

Software Developer

Alborz Insurance is an insurance provider private company

Responsibilities:

  • Develop C++ and VB forms
  • Install database servers and IIS
  • Design MSAccess and SQL Server Databases
  • Create stored procedures and functions
  • Write SQL queries
  • Install, support, and maintain LAN, network equipment, servers and other computer systems
  • Perform troubleshooting systems and network reported problems
  • Implement important policies and procedures for network and database
  • Introduce an automated process for insurance renewal notifications

Environments and Technologies: