LinkedInPaulo Condeça

Paulo Condeça

SQL Server Premier Field Engineer at Microsoft

Location
Lisbon Area, Portugal
Industry
Information Technology and Services
Current
  1. Microsoft
Previous
  1. Barclays Bank Portugal - NOESIS PORTUGAL,
  2. Freelancer,
  3. SIBS Processos
Education
  1. MCITP - Microsoft Certified IT Professional Database Administrator SQL Server 2008
Recommendations30 people have recommended Paulo
Websites
500+connections

Join LinkedIn & access Paulo's full profile

Join LinkedIn & access Paulo's full profile. It's free!

As a LinkedIn member, you'll join 300 million other professionals who are sharing connections, ideas, and opportunities.

  • See who you know in common
  • Get introduced
  • Contact Paulo directly
500+connections
Microsoft

Microsoft

Premier Field Engineer - SQL Server

– Present

View full profile

Background

Summary

SQL Server Database Specialist.

Senior DBA/ Arquitect/ Developer - Interested in relational VLDB design/ arquitecture/ implementation/ performance & tuning using MS-SQL Server.

Interested in DB Migration/Consolidation/High Availability/ETL & Tuning projects.

Specialties: Microsoft SQL Server 7.0/2000/2005/2008/2012/2014 Database Arquitect - Clustering, DSR, Data Warehousing, Partitioning, ETL, SSIS, DB/T-SQL Tuning/Internals & Development.

Microsoft Windows Server Systems Design & Implementation.
Automation & Monitoring with VBS/WMI/WSH/WSQL.

.NET Development with C#.

Strong focus on results, I am a problem solver by nature that is able to work under stress.
Recognition & Challenges are my fuel.

You can reach me at paulo@citen.net & +351 961 339 499

Jung Typology Test:
Personality type : E N T J (2 % of World Population)
Extraversion = 44 %
Intuition = 11 %
Thinking =44 %
Judging = 11 %

http://en.wikipedia.org/wiki/ENTJ

Snapshot :
Stable, relaxed, calm, secure, optimistic, reliable, efficient, fun.

Skills

  • SQL Server
  • High Availability
  • VLDB
  • Clustering
  • ETL
  • Database Administration
  • T-SQL
  • Performance Tuning
  • Query Optimization
  • Database Optimization
  • SQL Profiler
  • System Tuning
  • Perfmon
  • PAL
  • Physical Data Modeling
  • SQL database design
  • SSIS
  • SQL Server 2000-2008
  • SQL
  • Microsoft SQL Server
  • SQL Tuning
  • Cluster
  • Databases
  • Oracle
  • Active Directory
  • Data Migration
  • Business Intelligence
  • Microsoft Technologies
  • .NET
  • C#
  • Data Modeling
  • Disaster Recovery
  • Database Design
  • Operating Systems
  • ITIL
  • Microsoft Exchange
  • System Administration
  • Windows Server
  • PL/SQL
  • DNS
  • Data Center
  • See 26+  See less

Experience

Premier Field Engineer - SQL Server

Microsoft
– Present (2 years 9 months)EMEA

Working as a SQL Server PFE, my main responsability at Microsoft is to work closely with Premier Customers such as Telcos/ Retail/ Finance/ Oil Industry in Portugal, France, Angola, Ireland, Sweden, Norway, Belgium, Jordan...
To achive high level of satisfaction of customers, not only I'm obsessed with the quality of the delivery but I also have a need-to-know mentality that drives to good results.

Premier Support for Global and Enterprise Customers.

For organizations with the most complex IT needs, Premier Support equips you with the tools, services, solutions, and subject-matter experts needed to manage your operations across business units, regional offices, and your larger global marketplace. Whether your IT operations are on premises, in the cloud, or a mix of both, Premier Support can help you simplify administration across your enterprise.

SENIOR SQL SERVER DBA

Barclays Bank Portugal - NOESIS PORTUGAL
(1 year 11 months)

Microsoft SQL SERVER DBA in a complex, multiple cluster environment.

* VLDB > 8TB Database Management/Maintenance including > 1TB table partitioning with index alignment.
* Development of a monitoring engine (DBA EYE) for the RDBMS & OS, including interface (web) and notifications (e-mail).
* T-SQL & VBScript Development.
* Advise & Support development teams on database related topics/tuning/issues.
* Database security enforcement. ( ex: principle of least privilege ).
* Performance Analysis.
* Performance Tuning -> TSQL / SSIS / OS / SGBD.
* Disaster Recovery.
* Unlock dormant projects.
* Datacenter Move.
* International Projects.
* Capacity Planning (currently managing > 20 TB of data).
* Monitoring.
* Auditing.
* ETL – SSIS Development ETL – SSIS Development.
* Quest Software Suite -> Foglight / Spotlight / Litespeed .
* RedGate SQL Toolbelt Suite .
* Work environment with different cultures ( offshore teams -> UK / INDIA / SINGAPORE ).
To be completed...

MICROSOFT SQL SERVER TRAINER

Freelancer
(1 year 11 months)

* DBA & DEVELOPMENT *
* MOC Courses *

Microsoft Official Curriculum (MOC) is professional courseware intended for IT professionals and developers who build, support, and implement solutions by using Microsoft products and technologies. MOC is designed to cover the topics that employers know are mission-critical in the real world.

SENIOR SQL SERVER DBA

SIBS Processos
(1 year)

* DBA, responsible for the database infrastructure in a highly available environment.

* > 4 TB Database Management/Maintenance.

* Head & Developer of DBA EYE, a monitoring engine for the RDBMS & OS, including interface (web) and notifications (e-mail).

* T-SQL & VBScript Development.

* Data Modeling with ERWin.

* Support development teams on database related topics/tuning/issues.

* Database security enforcement. ( ex: principle of least privilege ).

* Development of a FGAC (Fine Grained Auditing Control) on MS SQL SERVER (Server Side Traces / T-SQL), for security auditing purposes.

* Capacity Planning.

* Debug issues in Production Environments.

* Performance Analysis.

* Database rollout to Production.

Microsoft SQL Server DBA

Barclays Bank Portugal - NOESIS PORTUGAL.
(1 year 5 months)

* > 2 TB MIS Database Management/Maintenance.

* Daily Batch reduction to 1/3 of time.

* Business Processes duration to 1/8 of time.

* RDBMS & T-SQL Tuning.

* Data Striping.

* Fact Table Partitioning ( > 600 GB ) by Month.

* Indexed Partitioned Views.

* SQL SERVER INTEGRATION SERVICES Specialist.

* T-SQL / SSIS / C# & VBScript Development.

* Several SSIS ETL Projects, complex synchronous/asynchronous processes between heterogeneous/homogenous sources/destinations.

* DTS Migrations To SSIS.

* Fully Customized Database Security Audit Trace, that among other data, will store Succeeded/Failed Logons, Database/Schema GDR Events. This audit process doesn’t require tight maintenance (in contrast with NSA-C2 Level Audit), because it automatically extends to a maximum of 100 files with 100 MB files each, if this max is reached it will automatically roll-over.

Microsoft SQL Server DBA

Banco Popular Portugal - INDRA PORTUGAL
(2 years 2 months)

* Microsoft SQL SERVER 2000/2005 DBA, responsible for all the Microsoft SQL SERVER company infrastructure.

* Project High Availability - Two Node Active/Active Microsoft SQL Server 2005 Enterprise x64 Edition Cluster.

* Project Database Consolidation and Migration (Microsoft SQL Server 7.0 to Microsoft SQL Server 2000 in Microsoft Windows Server 2003 Enterprise).

* Project Databases Backup Policy Optimization, Database Tuning, Pro-Active Monitoring.

Systems Administrator

PT.COM - NewValue
(4 months)

* Systems and Database Administrator, administration of company infrastructure including the Microsoft SQL SERVER 2000 Enterprise Cluster, Windows 2003 Enterprise, and NLB Web Servers (IIS 6.0).

Systems Administrator

Millenium BCP Bank - HP
(5 months)

* Systems and Database Administrator, administration of company infrastructure including the Microsoft SQL SERVER 2000 Enterprise Cluster, Windows 2003 Enterprise, and NLB Web Servers (IIS 6.0).

Systems Administrator & DBA

Movensis
(1 year)

* Systems and Database Administrator, responsible for all the company infrastructure including the Microsoft SQL SERVER 2000 Enterprise Cluster, Active Directory, DNS, DHCP, Exchange 2003 Server and Web Servers ( IIS 5.0, IIS 6.0, Apache and Tomcat with NLB).

Publications

Data Warehouse Partition Strategies(Link)

sql-server-performance.com
September 2008

Microsoft put a great deal of effort into SQL Server 2005 and 2008 to ensure that that the platform it is a real Enterprise class product. I’m not going to write about all the new features in the OLTP Engine, in this article I will focus on Database Partitioning and provide a real world scenario. This article will cover the following points:

I. Benefits and Limitations of Partitioning (HEAPS/CLUSTERED/NONCLUSTERED).
II. Implementation Methodology.
III. Partitioning Management.

Education

MCITP - Microsoft Certified IT Professional Database Administrator SQL Server 2008

MCTS - Microsoft Certified Technology Specialist in Microsoft SQL Server 2008

MCITP - Microsoft Certified IT Professional Database Administrator SQL Server 2005

MCTS - Microsoft Certified Technology Specialist in Microsoft SQL Server 2005.

MCDBA - Microsoft Certified Database Administrator.

MCSE - Microsoft Certified Systems Engineer on Windows Server 2003.

IT Course LVL III UE.

Cambridge FCE - First Certificate in English

EPED

Citeforma

Organizations

View Paulo's full profile to...

  • See who you know in common
  • Get introduced
  • Contact Paulo directly

Not the Paulo Condeça you're looking for? View more

Insights


People Also Viewed

LinkedIn member directory:

  1. a
  2. b
  3. c
  4. d
  5. e
  6. f
  7. g
  8. h
  9. i
  10. j
  11. k
  12. l
  13. m
  14. n
  15. o
  16. p
  17. q
  18. r
  19. s
  20. t
  21. u
  22. v
  23. w
  24. x
  25. y
  26. z
  27. more