About Me

Hello, I’m Pol Alzina!

I’m a Database Administrator with experience designing, coding, testing and supporting next generation database solutions in Amazon Web Services (Amazon Aurora, DynamoDB, Athena, …).

Proven success in working as a part of cooperative team effort as well as independently on various projects having the ability to take the technical lead. Skilled in assessing requirements and prioritizing tasks for an on-time solution’s delivery. Interface effectively with working team members, supervisors and costumers. A committed team player, self-motivated with the ability to communicate at all levels.

Think and function clearly and calmly in a fast paced and hectic environment, while maintaining a professional, courteous and friendly atmosphere. High achiever, who can generate results with little or no supervision. Present a professional and positive company image at all times.

Personal Information

Full Name
Pol Alzina Güell
Birthday
12 Oct 1990
address
Barcelona - Spain
e-mail
pol.alzina@gmail.com
phone
+34 620 443 905

Languages

Catalan native
Spanish native
English fluent

Professional Skills

My DBA Skills

  • Data modeling and database design. Ability to create an efficient physical database design from a logical data model and application specifications. Responsible for data modeling, normalization, and conceptual and logical design.
  • Metadata management and repository usage. Ability to collect, store, manage, and enable the ability to query the organization’s metadata.
  • Backup and recovery. Implement an appropriate database robust backup and recovery procedures based on data volatility and application availability requirements.
  • Ensuring data integrity. Ensure the structural integrity of the database (referential integrity, constraints and triggers).
  • Performance management and tuning. Ability to proactively monitor the database environment and to make changes to data structures, SQL, application logic or the DBMS subsystem to optimize performance.
  • Ensuring availability. Ensure data availability using non-disruptive administration tactics.
  • SQL code reviews. High in-depth SQL knowledge and practice to review and optimize all kind of queries.
  • Procedural skills. Procedural skill to help design, debug, implement and maintain stored procedures, triggers, and user-defined functions.
  • Data security. Ability to implement a rigorous security infrastructure for production and test databases. And a database auditing capability to document compliance.
  • Capacity planning. Ability to predict growth based on application and data usage patterns and to implement the necessary database changes to accommodate the growth.

My Complementary Skills

  • Database Management Systems. Fully experienced working with MySQL, Amazon Aurora, DynamoDB (NoSQL), Amazon Athena.
  • Cloud Computing. Wide knowledge working as a System Administrator with Amazon Web Services technologies (IAM, EC2, S3, VPC, Route53, Glue, Accounts Manager, …).
  • Programming Knowledge. SQL, Python 2.7, C, C++, C#, Objective-C, Android, Java, Php, Javascript.
  • Operating systems. Advanced OS knowledge working with Linux, MacOs and Windows.
  • Goal Directed. Ability to quickly understand complex problems and devise effective solutions.
  • Keen to learn. Always seeking to keep leaning and growing personally.

work experience

March 2017 - Present

Inbenta

Inbenta Holdings, Inc.

Lead DBA responsible for the technical and administration aspects of the Database infrastructure. Also the first point of call for providing technical support as well as specialist technical input.

Duties:

  • Designing schema, access patterns, locking strategy, SQL development, and tuning
  • Modifying the database structure
  • Optimizing application and end-user queries (reactive tuning)
  • Archiving data
  • Generating needed ad hoc reports by querying from the database
  •  Proactive performance tuning
  •  Enrolling users and maintaining system security
  •  Controlling user access to the database
  •  Parameter configuration and tuning
  •  Cache management
  •  Job scheduling
  •  Monitoring
2011 - 2017

iOS / Android Developer

PoliusCorp

Designing and developing multiple iOS / Android projects. (www.poliuscorp.com/#portfolio)

2010 - 2011

Back-End Developer

Iberpotash ICL

Responsible for the implementation of quality auditing through designing and developing web-based applications.

Education

2011 -2017

Bachelor Degree in Computing Engineering

Polytecnic University of Catalonia, Barcelona (Spain)
2009 - 2011

Advanced Technician in EDP applications development

Joviat, Manresa (Spain)
2007 - 2009

Upper Secondary Education

Joviat, Manresa (Spain)

Trainings

2015

English Course – C1 (CAE)

Delfin English School, Dublin (Ireland)
2012

English Course – C1 (CAE)

Hansa Language Centre, Toronto (Canada)

My Personal Projects

VegetaCAT

View More

VegetaCAT

Web /

VEGETA.cat és una pàgina web sense ànim de lucre que té com a objectiu recopilar totes aquelles sèries en català que es van emetre entre els anys 1990, 2000 i 2010 i que van marcar a tota una generació.

For more information: http://www.vegeta.cat

More Projects

Colors Saga

View More

Colors Saga

iOs /

Colors Saga is a game in which your speed and accuracy will lead you to success. There is only one rule: Click the designated color, although it is not as easy as it seems.

Try the three game modes available:

– Classic: Hold all you can
– Change: Don’t let it fool you
– Chrono: Do it as quickly as possible
– Challenger: An exciting challenge

For more information: https://itunes.apple.com/us/app/colors-saga/id977118549

LoLNexus

View More

LoLNexus

iOs /

LoLNexus is your go-to source to lookup ongoing League of Legends matches. It provides you with detailed information about every player in the game, giving you a chance to familiarize yourself with them and size them up.

LoLNexus uses the data of OP.GG to ensure a complete integration.

How does it work?
Once a game has started, simply enter the name of one of the players in the match, and LoLNexus will take care of the rest.

For more information: https://sensortower.com/ios/us/pol-alzina/app/lolnexus-match-scouter-for-league-of-legends/765059876/overview

Match Search for LoL

View More

Match Search for LoL

Android /

Search League of Legends games in real time.

Detailed information of each player:

· Summoner Name
· Magic
· Champions
· KDA
· Won games
· Rankeds
· Series
· Runes
· and much more!

Supported regions: NA, EUW, EUNE, BR, TR, RU, LAN, LAS, OCE

Match Search is available in the following languages:

· English
· Spanish
· German
· Français
· Italian
· ελληνικά
· Türkçe
· Русский
· Melayu
· 中文
· 일본 의
· 한국 의

For more information: https://play.google.com/store/apps/details?id=com.poliuscorp.matchsearch

More Projects

YouWaiter

View More

YouWaiter

Android /

Your Waiter is the perfect and easy application to take restaurant orders.

What functions does your waiter integrate?

  • Products. Complete management of restaurant products. The current stock, the price of each product, and an image and small description are shown.
  • Orders. Complete management of restaurant orders. Orders can be ordered according to their price, units and also allows you to search for orders between two datas and see at all times the price gained from all orders placed.
  • Help. Section where is detailed how each section of the application works.
  • Configuration. Allows you to change the language of the application among three available (Spanish, English, Catalan).

For more information: https://play.google.com/store/apps/details?id=com.poliuscorp.youwaiter

More Projects

Classified

Hey! I did not expect you to get that far down the page!

Well, I can not keep hiding this. It was a matter of coming to light.

¯\_(ツ)_/¯

Contact Me

Feel free to contact me in case of any question